LTirrellUntitled Query
    Updated 2022-08-03

    select
    date_trunc(hour,block_timestamp) as hour,
    count(distinct tx_from) as affected_wallets
    from
    solana.core.fact_transfers
    where
    date(block_timestamp) > '2022-08-01' and
    tx_to in
    ('CEzN7mqP9xoxn2HdyW6fjEJ73t7qaX9Rp2zyS6hb3iEu',
    'Htp9MGP8Tig923ZFY7Qf2zzbMUmYneFRAhSp7vSg4wxV',
    '5WwBYgQG6BdErM2nNNyUmQXfcUnB68b6kesxBywh1J3n',
    'GeEccGJ9BEzVbVor1njkBCCiqXJbXVeDHaXDCrBDbmuy')
    group by 1
    Run a query to Download Data