zakkisyed Unique Accounts using LP actions - Post Airdrop
    Updated 2021-12-01
    SELECT --block_timestamp,
    -- tx_id,
    DISTINCT event_inputs :account :: string as account,
    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

    where tx_to_address = '0x8526cec1d97a68c0e69420488d04dec5f101b46e'
    and event_name = 'Claimed'
    and event_removed = FALSE
    Run a query to Download Data