!pip install praw
Collecting praw
Downloading praw-7.2.0-py3-none-any.whl (159 kB)
|████████████████████████████████| 159 kB 14.3 MB/s
Collecting prawcore<3,>=2
Downloading prawcore-2.0.0-py3-none-any.whl (15 kB)
Collecting update-checker>=0.18
Downloading update_checker-0.18.0-py3-none-any.whl (7.0 kB)
Collecting websocket-client>=0.54.0
Downloading websocket_client-0.59.0-py2.py3-none-any.whl (67 kB)
|████████████████████████████████| 67 kB 8.7 MB/s
Requirement already satisfied: requests<3.0,>=2.6.0 in /shared-libs/python3.7/py/lib/python3.7/site-packages (from prawcore<3,>=2->praw) (2.25.1)
Requirement already satisfied: certifi>=2017.4.17 in /shared-libs/python3.7/py/lib/python3.7/site-packages (from requests<3.0,>=2.6.0->prawcore<3,>=2->praw) (2020.12.5)
Requirement already satisfied: chardet<5,>=3.0.2 in /shared-libs/python3.7/py/lib/python3.7/site-packages (from requests<3.0,>=2.6.0->prawcore<3,>=2->praw) (3.0.4)
Requirement already satisfied: idna<3,>=2.5 in /shared-libs/python3.7/py/lib/python3.7/site-packages (from requests<3.0,>=2.6.0->prawcore<3,>=2->praw) (2.10)
Requirement already satisfied: urllib3<1.27,>=1.21.1 in /shared-libs/python3.7/py/lib/python3.7/site-packages (from requests<3.0,>=2.6.0->prawcore<3,>=2->praw) (1.26.4)
Requirement already satisfied: six in /shared-libs/python3.7/py-core/lib/python3.7/site-packages (from websocket-client>=0.54.0->praw) (1.16.0)
Installing collected packages: websocket-client, update-checker, prawcore, praw
Successfully installed praw-7.2.0 prawcore-2.0.0 update-checker-0.18.0 websocket-client-0.59.0
import praw
reddit = praw.Reddit(client_id='xzBFq1dloayLdg', client_secret='NhVH6QPkZq0t7Yv-CIeDJyQe8gMeMA', user_agent='my_user_agent')
hot_posts = reddit.subreddit('pennystocks').hot(limit=10)
for post in hot_posts:
print(post.title)
THE LOUNGE: thoughts, noob stuff, low effort, brokers, zero DD, non pennies - May 06, 2021
Daily Plays - May 06, 2021
$FOMC ; FOMO Corp Name Change/Ticker Change Approved!!! - $ETFM ticker change to $FOMC effective May 7, 2021. HUGE updates from today's FOMO Hour!!
$SLSSF - Canadian Mining company- Announces expansion its resources and reserves
Bullish on BLRX "strinkingly positive" phase 3 cancer treatment data
AGTC Reports Positive 12-Month Data from Highest Dose Groups in its Ongoing XLRP Phase 1/2 Clinical Trial
Jack Nathan Health Announces 153 Clinic Expansion and National Telemedicine Strategy with Walmart Mexico
$RETC and $GVSI custodianship plays
Qyou adds Amazon to growing list of advertisers
ALFI $ALF Live while you wait
!date
Thu 06 May 2021 02:14:45 PM UTC
SQL
Saved to variable
df_1SELECT * from kokso
ExecuteSqlError: There is no Dataframe named kokso in scope!