date_trunc('month', block_timestamp),

sum(amount),

count(*)

solana.core.fact_transfers transfers

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

and

(0=1

-- tx_to = 'EUuMsDPsS9og1uzhzEQxBmE92QNywCxXL6ztpLAiCZMW'

-- or tx_to = 'G1itch7djMvG4vMRToAgs45cVqrLGKFbzrgV4qNDsG1X'

or tx_to = 'mLyfgvyTAuEBVyAZcqyWKJ4SnM88Tqv2hFMy68y8hmY'

)

and tx_from = 'DtZWL3BPKa5hw7yQYvaFR29PcXThpLHVU2XAAZrcLiSe'

-- and array_contains([

-- 'EUuMsDPsS9og1uzhzEQxBmE92QNywCxXL6ztpLAiCZMW'

-- ])

group by date_trunc('month', block_timestamp)

order by

date_trunc('month', block_timestamp) desc

limit 10000