alitaslimiSwaps Overview
Updated 2022-09-13
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
swaps_from AS (
SELECT
symbol_in AS token,
COUNT(DISTINCT tx_hash) AS txn,
COUNT(DISTINCT sender) AS swappers,
SUM(amount_in) AS volume,
SUM(amount_in_usd) AS volume_usd
FROM
ethereum.core.ez_dex_swaps
WHERE
block_timestamp::date >= '2021-01-01'
AND token_in IN (
'0xae7ab96520de3a18e5e111b5eaab095312d7fe84', -- stETH
'0xae78736cd615f374d3085123a210448e74fc6393', -- rETH
'0x3a3a65aab0dd2a17e3f1947ba16138cd37d08c04', -- aETH
'0xfe2e637202056d30016725477c5da089ab0a043a' -- sETH2
)
GROUP BY
token
),
swaps_to AS (
SELECT
symbol_out AS token,
COUNT(DISTINCT tx_hash) AS txn,
COUNT(DISTINCT tx_to) AS swappers,
SUM(amount_out) AS volume,
SUM(amount_out_usd) AS volume_usd
FROM
ethereum.core.ez_dex_swaps
WHERE
block_timestamp::date >= '2021-01-01'
AND token_out IN (
'0xae7ab96520de3a18e5e111b5eaab095312d7fe84', -- stETH
'0xae78736cd615f374d3085123a210448e74fc6393', -- rETH
'0x3a3a65aab0dd2a17e3f1947ba16138cd37d08c04', -- aETH
Run a query to Download Data