drone-mostafaUntitled Query
    Updated 2022-07-10
    select instructions[0]:programId as program_ID,
    case when program_ID = 'FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe4975bi2epH' then 'pyth oracle'
    when program_id ='9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin' then 'serum dex v3'
    when program_ID = 'JUP2jxvXaqu7NQY1GmNF4m1vodw12LVXYxbFL2uJvfo' then 'jupiter aggregator v2'
    when program_ID = '11111111111111111111111111111111' then 'system program'
    when program_ID = 'DtmE9D2CSB4L5D6A15mraeEjrGMm6auWVzgaD8hK2tZM' then 'switchboard oracle'
    when program_ID = 'ComputeBudget111111111111111111111111111111' then 'Compute Budget Program'
    when program_ID = 'cjg3oHmg9uuPsP8D6g29NWvhySJkdYdAo9D25PRbKXJ' then 'Chainlink Data Feeds Store Program'
    when program_ID = 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68' then 'Mango Markets'
    else program_ID end as program_name,
    sum(fee/1e9) as Paid_Fee_SOL
    from solana.core.fact_transactions
    where block_timestamp >= '2022-01-01' and SUCCEEDED ='FALSE'
    group by 1,2
    order by 3 desc
    limit 10
    Run a query to Download Data