boomer772023-05-15 02:21 PM
Updated 2023-07-19
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
›
⌄
--pc, bridge, hoppy, genie, loot
with buys as (select 'buys' as action, *
from ethereum.core.ez_dex_swaps
where token_out in (
'0x9426a0e93344c3e787a19022b2dac08e9786b8a6',
'0x89a13dbc89d05c4fefdb032e2a34f232ae637cfd',
'0x25942771b17f3790bf32cae7af7d539ce42cdc79',
'0xf21d9d6ccfb332bee9b92c3a811d809674c5caf7',
'0x5201523c0ad5ba792c40ce5aff7df2d1a721bbf8')),
sells as (select 'sells' as action, *
from ethereum.core.ez_dex_swaps
where token_in in (
'0x9426a0e93344c3e787a19022b2dac08e9786b8a6',
'0x89a13dbc89d05c4fefdb032e2a34f232ae637cfd',
'0x25942771b17f3790bf32cae7af7d539ce42cdc79',
'0xf21d9d6ccfb332bee9b92c3a811d809674c5caf7',
'0x5201523c0ad5ba792c40ce5aff7df2d1a721bbf8'))
select * FROM buys
limit 100
Run a query to Download Data