sum(fee / 1e9) as "Tx costs",

count(*) as "Tx count",

sum(array_size(instructions)) as "Ix count",

date_trunc('day', block_timestamp) as "Period"

solana.core.fact_transactions

ARRAY_CONTAINS('opNS8ENpEMWdXcJUgJCsJTDp7arTXayoBEeBUg6UezP'::variant, signers)

and date_trunc('day', block_timestamp) between '2024-11-01' and '2025-01-01'

group by

date_trunc('day', block_timestamp)

order by

date_trunc('day', block_timestamp) desc

limit 100