twitter_fund_of_the_year_analyze

execute

go run main.go

SQLite

sqlite3 foy2023.db

csv mode

.headers on
.mode csv
.once './ranking.csv'

count by ticker

select
    count(tweets.ticker) c,
    tickers.name
from
    tweets
    inner join tickers
        on tweets.ticker=tickers.ticker
group by
    tweets.ticker
order by
    c desc;

File ranking.csv will be saved.