zakkisyed Accounts HODLing onto their RUNE - Post Airdrop
    Updated 2021-12-01

    SELECT -- block_timestamp,
    -- DISTINCT
    DISTINCT event_inputs :account :: string as account,
    --event_inputs :tx_id :: string as tx_id
    event_inputs :userClaim :: string / pow(10, 18) as tokens_airdropped
    from
    ethereum.events_emitted

    --INNER JOIN thorchain.liquidity_actions
    --ON ethereum.events_emitted.tx_from_address = thorchain.liquidity_actions.from_address


    RIGHT JOIN thorchain.outbound_events
    ON ethereum.events_emitted.tx_from_address = thorchain.outbound_events.from_address


    where tx_to_address = '0x8526cec1d97a68c0e69420488d04dec5f101b46e'
    and event_name = 'Claimed'
    and event_removed = FALSE


    Run a query to Download Data