0xHaM-dVis 10: Received Airdrop in daily
    Updated 2022-07-20
    select
    block_timestamp::date as date,
    count(INSTRUCTION:accounts[0]) as receiver
    from solana.core.fact_events
    where tx_id in (select tx_id from solana.core.fact_nft_mints where PURCHASER = 'NFTsPae8pUuvKHiUHpXfZaQwwbiVPw6dPCWpwfvrwR6' )
    and block_timestamp::date >= '2022-05-01'
    and INSTRUCTION:accounts[0] is not null
    group by 1
    order by 1
    Run a query to Download Data