zakkisyedUntitled Query
Updated 2021-12-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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 = '0xc18360217d8f7ab5e7c516566761ea12ce7f9d72'
and event_name = 'Claimed'
and event_removed = FALSE
Run a query to Download Data