maybeyonaszap-out-eth
Updated 2022-11-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
with zap_out_eth as(
select distinct tx_id
from ethereum.udm_events
where origin_function_signature = '0xf6216495'
and from_address = '0x9d409a0a012cfba9b15f6d4b36ac57a46966ab9a'
)
select
block_timestamp,
tx_id,
symbol,
contract_address as token_contract,
amount,
amount_usd,
'zapOut' as event
from ethereum.udm_events
where tx_id in (select * from zap_out_eth)
and from_label_type = 'dex' and symbol='WETH'
-- select *
-- from ethereum.udm_events
-- where -- origin_function_signature = '0xf6216495'
-- -- and from_address = '0x9d409a0a012cfba9b15f6d4b36ac57a46966ab9a'
-- tx_id = '0x2f743a5bee4c0821e28a211f7b3935c7eb44804e671279aad0599156934de190'
-- -- limit 100
Run a query to Download Data