scottincryptoDune Query Copy
Updated 2021-08-03
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
›
⌄
⌄
-- select sum(weth.amount) as deposited
-- select
-- yweth.tx_id,
-- yweth.contract_address,
-- yweth.amount,
-- weth.amount
/*select weth.*, yweth.*
from ethereum.udm_events yweth
left join ethereum.udm_events weth
on yweth.tx_id = weth.tx_id
where yweth.contract_address = '0xa258c4606ca8206d8aa700ce2143d7db854d168c'
and weth.contract_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
and yweth.from_address = '0x0000000000000000000000000000000000000000'
and yweth.to_address = weth.from_address
-- and weth.EVENT_TYPE = 'erc20_transfer'
limit 10
*/
select
*
from ethereum.dex_swaps
where token_address = '0xa258c4606ca8206d8aa700ce2143d7db854d168c'
limit 10
Run a query to Download Data