bachisolana uniq program1
Updated 2022-07-06Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
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