headitmanagerCopy of 8opsol
    Updated 2022-12-11
    with tops as (select count(distinct tx_id) as transfer_count, 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 transfer_count DESC
    limit 10)

    select count(distinct tx_id) as transfer_count, 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