datavortexdex
Updated 2025-02-03
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 price AS (
SELECT
price,
hour,
token_address
FROM
kaia.price.ez_prices_hourly p
WHERE
token_address = '0x19aac5f612f524b754ca7e7c41cbfa2e981a4432'
),
swaps AS (
SELECT
COUNT(DISTINCT origin_from_address) AS swappers,
COUNT(DISTINCT tx_hash) AS TotalSwaps,
COUNT(DISTINCT tx_hash) / NULLIF(COUNT(DISTINCT origin_from_address), 0) AS AvgSwapsPerSwapper
FROM
kaia.defi.ez_dex_swaps
WHERE
token_in = '0x19aac5f612f524b754ca7e7c41cbfa2e981a4432'
),
volume AS (
SELECT
SUM(s.amount_in * p.price) AS TotalSwapVolume,
SUM(s.amount_in * p.price) / NULLIF(COUNT(DISTINCT s.tx_hash), 0) AS AvgSwapVolume
FROM
kaia.defi.ez_dex_swaps s
JOIN price p ON s.token_in = p.token_address
AND date_trunc('hour', s.block_timestamp) = p.hour
WHERE
s.token_in = '0x19aac5f612f524b754ca7e7c41cbfa2e981a4432'
)
SELECT
*
FROM
swaps,
volume;
QueryRunArchived: QueryRun has been archived