Swaps | Swappers | Swap Volume $USD | Swap Per Swappers | Volume Per Swappers | |
|---|---|---|---|---|---|
1 | 16842 | 485 | 34905077.6169371 | 34.725773 | 71969.23219987 |
Sajjadiiicapy 1 .2
Updated 2025-03-18
999
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 price_tab_cb AS (
SELECT
hour::date as date,
avg(price)::string as price,
'WETH' :: string AS token_symbol,
'0x98a8345bb9d3dda9d808ca1c9142a28f6b0430e1' :: string AS token_contract,
'0x3ce1aa52eeaf57a355939c09ac76f03f01988f13' :: string AS pool_contract_address
FROM ethereum.price.ez_prices_hourly
WHERE symbol = 'WETH'
AND token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
AND hour::date >= current_date - interval '365 day'
GROUP BY 1
UNION all
SELECT
hour::date as date,
avg(price)::string as price,
'WKLAY' :: string AS token_symbol,
'0x19aac5f612f524b754ca7e7c41cbfa2e981a4432' :: string AS token_contract,
'0x8a5562d2a17488647381c1a0e9cf527a01b6f3bd' :: string AS pool_contract_address
FROM kaia.price.ez_prices_hourly
WHERE symbol = 'KLAY'
AND hour::date >= current_date - interval '365 day'
GROUP BY 1
UNION all
SELECT
hour::date as date,
'1'::string as price,
'USDT' :: string AS token_symbol,
'0x5c13e303a62fc5dedf5b52d66873f2e59fedadc2' :: string AS token_contract,
'0xa856b5da8e85b23395c17783954edda010317fce' :: string AS pool_contract_address
Last run: 2 months ago
1
55B
433s