Updated 2023-01-03
    --credit : https://app.flipsidecrypto.com/velocity/queries/6ffe7ad6-7fe7-4740-87b2-e23974fdbe83
    with mintable as (
    select tx_from,
    min (block_timestamp) as mindate
    from osmosis.core.fact_transactions
    group by 1)

    select project_name,
    count (*) as Countt
    from osmosis.core.fact_swaps t1 join mintable t2 on t1.trader = t2.tx_from and t1.block_timestamp = t2.mindate
    join osmosis.core.dim_tokens on to_currency = address
    group by 1
    order by 2 DESC
    limit 20
    Run a query to Download Data