kasadeghUntitled Query
    Updated 2022-11-21

    with solana_usdc_transfer as (
    select chain, log_volume, count(*) as transfer_count
    from
    (
    SELECT
    'solana' as chain,
    TX_ID,
    amount as volume,
    floor(log(2,volume)) log_volume

    FROM solana.core.fact_transfers
    where MINT ='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    AND block_timestamp::date >='{{start_time}}' and block_timestamp::date <='{{end_date}}'
    and volume!=0
    )
    group by 1,2
    order by 2
    )
    SELECT chain, log_volume, transfer_count / (select sum(transfer_count) from solana_usdc_transfer)
    FROM solana_usdc_transfer
    Run a query to Download Data