count(distinct tx_from) presaler_ct

, sum(amount) presale_sol_ct

, sum(amount) *200 presale_usd_ct

, count(distinct tx_id) presale_ct

from solana.core.fact_transfers

where 1=1

and date(block_timestamp) >= date('2024-03-16')

and date(block_timestamp) <= date('2024-03-17')

and tx_to = 'HdENn8wP6srk1AuE2CaJj6bRbjcU2kYs12H4C4HgNAsF'

and mint = 'So11111111111111111111111111111111111111112'