fanta7opsolana
    Updated 2023-03-16
    with orca_and_saros_address as (select label,address from solana.core.dim_labels where label_type='dex' and label in ('orca' ,'saros'))
    , tops as (select tx_to,sum(amount)
    from solana.core.fact_transfers inner join orca_and_saros_address
    on tx_from= address and mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    where block_timestamp::date >= '2023-01-01' and label='orca'
    group by 1
    order by 2 DESC
    limit 10)

    select * from tops

    Run a query to Download Data