glass_blossomsamount of transactions
    Updated 2022-02-19
    select
    date_trunc('day', block_timestamp) as day,
    posttokenbalances[0]:owner as wallet,
    (inner_instruction:instructions[2]:parsed:info:amount)/pow(10,9) as amount
    from solana.events
    WHERE block_timestamp::date >= '2022-02-01'
    --AND tx_id = '5ptLnEaEAjC45QRKGS8RLDFp3UwdzarWSuN65yT2inV1WuFha7HE8bvREHzs1KTSyrSLRHhJG7darVj6dav4Lrow'
    and inner_instruction:instructions[2]:parsed:info:mint = 'monKYjV2bHTjbJVWCCcwhxE8C96sdTKR2HUNUHCjh4z'
    and inner_instruction:instructions[2]:parsed:info:mintAuthority = '41CKnj1gy1AXQ1nf2dB9Ubst3QGHxjWkFLd78KLpGYsr'
    and inner_instruction:index = 4
    and succeeded = TRUE

    Run a query to Download Data