a seer bot history fetching tool
python -m venv venv
. venv/bin/activate
pip install -r requirements.pip
cp .env.example .env
Then fill in you api id/hash from my.telegram.com along with your phone number
# this fetches the telegram history
make scrape
after you have the db, you can run the app with python3 application.py
An example query you might call on to find the green signals and when they were emitted
SELECT name || ': ' || strftime('%m-%d %H:%M:%S', date) AS formatted_name_date FROM token_data WHERE ai_degen = 'green' GROUP BY name, date ORDER BY date ASC;
get a specific tickers signal data
SELECT * from token_data where name LIKE '%WADDUP%';
get the memeability scores ordered by highest to lowest
select memeability || ' - ' || name from token_data where memeability is not null order by memeability desc;