Abolfazl_771025Most popular stablecoins and non-stablecoins traded over time
    Updated 2022-07-27
    select
    address_name,
    count (t2.tx_id)as "count of transactions "
    from solana.core.fact_transfers t1 join solana.core.fact_transactions t2 on t1.block_timestamp = t2.block_timestamp
    join solana.core.dim_labels t3 on t1.mint = t3.address
    join solana.core.fact_events t4 on t1.block_timestamp = t4.block_timestamp
    where program_id = 'SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC'
    group by 1
    order by 2 desc
    limit 10
    Run a query to Download Data