nickpayiatis_AAVE in Polygon Data
Updated 2021-09-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
⌄
/*
select distinct tx_to_label
from polygon.events_emitted
group by tx_to_label
--limit 10
--both aave and AAVE?
*/
select * from ethereum.dex_swaps e
left join uniswapv3.swaps u
on e.to_address = u.recipient
and e.block_timestamp = u.block_timestamp
where
e.tx_id = '0xd452455acc7b4d6d544848349acefa4994554f63c2546c2a6474d5de81aeb403'
and e.to_address = '0x1a3becc3fa08cc6aebd0f43cdc069ba95713b856'
and e.block_timestamp = '2021-08-23T02:21:55Z'
and e.direction = 'IN'
Run a query to Download Data