bachisolana uniq program1
    Updated 2022-07-06
    select date(block_timestamp) as day, b.address_name as program_name, sum(1) as no_of_transactions from solana.core.fact_transactions
    a join solana.core.dim_labels b on a.instructions[0]:programId = b.address
    where block_timestamp >= '2022-01-01' and succeeded = TRUE and
    instructions[0]:programId in ('FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe4975bi2epH', '9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin', 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68',
    'DtmE9D2CSB4L5D6A15mraeEjrGMm6auWVzgaD8hK2tZM', '11111111111111111111111111111111','Memo1UhkJRfHyvLMcVucJwxXeuD728EqVDDwQDxFMNo',
    '675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8', 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA', 'ZETAxsqBRek56DhiGXrn75yj2NHU3aYUnxvHXpkf3aD',
    'KeccakSecp256k11111111111111111111111111111' )
    group by day, program_name
    order by no_of_transactions desc
    --limit 10


    Run a query to Download Data