majidgholamiMost Popular destination from Solana
    Updated 2022-07-27
    with A as (
    select POST_TOKEN_BALANCES[1]:mint as aim,
    sum (POST_TOKEN_BALANCES[1]:uiTokenAmount:uiAmount) as transfered_volume
    from solana.core.fact_transactions
    where inner_instructions[0]:instructions[2]:parsed:info:mint = 'BJUH9GJLaMSLV1E7B3SQLCy9eCfyr6zsrwGcpS2MkqR1'
    and INNER_INSTRUCTIONS[0]:instructions[0]:parsed:type = 'transfer'
    and INNER_INSTRUCTIONS[0]:instructions[1]:parsed:type = 'transfer'
    and INNER_INSTRUCTIONS[0]:instructions[2]:parsed:type = 'mintTo'
    group by aim
    ),
    B as (
    select ADDRESS_NAME , ADDRESS
    from solana.core.dim_labels
    where ADDRESS in (select aim from A))

    select B.ADDRESS_NAME,
    A.transfered_volume
    from B
    inner join A
    on B.ADDRESS = A.aim
    order by A.transfered_volume DESC

    Run a query to Download Data