DATE | SWAP_ROUTE | TX_COUNT | SWAPPERS_COUNT | SWAP_VOLUME_USD | |
|---|---|---|---|---|---|
1 | 2024-11-14 00:00:00.000 | stKAIA=>WKLAY | 5 | 1 | 242.800049624 |
2 | 2024-12-03 00:00:00.000 | stKAIA=>WKLAY | 203 | 3 | 556993.099085583 |
3 | 2025-01-25 00:00:00.000 | stKAIA=>WKLAY | 38 | 3 | 125487.189081195 |
4 | 2025-03-04 00:00:00.000 | stKAIA=>WKLAY | 86 | 4 | 39731.752407554 |
5 | 2024-09-30 00:00:00.000 | WKLAY=>stKAIA | 3 | 3 | 14.411726411 |
6 | 2024-11-24 00:00:00.000 | rstKAIA=>stKAIA | 4 | 2 | |
7 | 2025-03-04 00:00:00.000 | rstKAIA=>stKAIA | 1 | 1 | |
8 | 2025-03-17 00:00:00.000 | stKAIA=>sKLAY | 1 | 1 | 1.366105194e-12 |
9 | 2024-12-11 00:00:00.000 | stKAIA=>WKLAY | 65 | 4 | 85613.376394819 |
10 | 2024-12-18 00:00:00.000 | rstKAIA=>stKAIA | 3 | 2 | |
11 | 2024-11-01 00:00:00.000 | stKAIA=>WKLAY | 107 | 2 | 92295.620606767 |
12 | 2024-10-27 00:00:00.000 | WKLAY=>stKAIA | 28 | 4 | 74200.642630832 |
13 | 2024-10-22 00:00:00.000 | WKLAY=>stKAIA | 4 | 4 | 88.860837443 |
14 | 2025-03-14 00:00:00.000 | WKLAY=>stKAIA | 19 | 2 | 23272.451815739 |
15 | 2024-12-28 00:00:00.000 | WKLAY=>stKAIA | 4 | 4 | 467.111438784 |
16 | 2024-11-28 00:00:00.000 | rstKAIA=>stKAIA | 2 | 2 | |
17 | 2024-11-28 00:00:00.000 | wGCKLAY=>stKAIA | 1 | 1 | |
18 | 2024-10-24 00:00:00.000 | stKAIA=>WKLAY | 355 | 5 | 148138.650616523 |
19 | 2025-01-03 00:00:00.000 | stKAIA=>WKLAY | 55 | 5 | 215927.947410946 |
20 | 2024-10-28 00:00:00.000 | stKAIA=>WKLAY | 371 | 4 | 60817.316638174 |
Sajjadiiicapy 1
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
...
574
35KB
286s