headitmanagerCopy of 10opsol
    Updated 2022-12-11
    with tops as (select sum(amount) as volume, tx_from
    from solana.core.fact_transfers inner join solana.core.dim_labels
    on tx_from=address
    where address_name like '%coinbase%'
    group by tx_from
    order by volume DESC
    limit 10)

    select sum(amount) as volume, tx_from , trunc(block_timestamp, 'MONTH') as days
    from solana.core.fact_transfers
    where tx_from in (select tx_from from tops)
    group by tx_from,days
    Run a query to Download Data