barbodCoinbase Adds SOL Ecosystem Coins
    Updated 2022-02-16
    with bf as (
    SELECT
    date_trunc('day',block_timestamp) as d1,
    sum (instruction:parsed:info:tokenAmount:uiAmount) as transfer_Fida
    from solana.events
    where block_timestamp between '2022-01-31' and CURRENT_DATE
    and instruction:parsed:info:mint = 'EchesyfXePKdLtoiZSL8pBe8Myagyy8ZRqsACNCFGnvp'
    and pretokenbalances[1]:owner = 'H8sMJSCQxfKiFTCfDR3DUMLPwcRbM61LGFJ8N4dK3WjS'
    and succeeded = 'TRUE'
    group by 1
    ),
    oc as (
    SELECT
    date_trunc('day',block_timestamp) as d2,
    sum (instruction:parsed:info:tokenAmount:uiAmount) as transfer_Orca
    from solana.events
    where block_timestamp between '2022-01-31' and CURRENT_DATE
    and instruction:parsed:info:mint = 'orcaEKTdK7LKz57vaAYr9QeNsVEPfiu6QeMU1kektZE'
    and pretokenbalances[1]:owner = 'H8sMJSCQxfKiFTCfDR3DUMLPwcRbM61LGFJ8N4dK3WjS'
    and succeeded = 'TRUE'
    group by 1
    )

    SELECT
    bf.d1 as dt,
    transfer_Fida,
    transfer_Orca

    from bf
    inner join oc on bf.d1 = oc.d2
    Run a query to Download Data