dethectiveWintermute - ETH token
Updated 2025-02-04
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH token_in as (
SELECT
block_timestamp,
token_in as token,
symbol_in as symbol
from
ethereum.defi.ez_dex_swaps
where
origin_to_address = lower('0x51C72848c68a965f66FA7a88855F9f7784502a7F')
or origin_from_address = lower('0x51C72848c68a965f66FA7a88855F9f7784502a7F')
),
token_out as (
SELECT
block_timestamp,
token_out as token,
symbol_out as symbol
from
ethereum.defi.ez_dex_swaps
where
origin_to_address = lower('0x51C72848c68a965f66FA7a88855F9f7784502a7F')
or origin_from_address = lower('0x51C72848c68a965f66FA7a88855F9f7784502a7F')
),
all_transactions as (
SELECT
*
FROM
token_in
UNION
ALL
SELECT
*
FROM
token_out
)
SELECT
count(distinct token) as token_traded
QueryRunArchived: QueryRun has been archived