deevhynTop Q1 AXL Users by volume
Updated 2024-07-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
a.sender,
COUNT(DISTINCT a.tx_hash) + COUNT(DISTINCT b.tx_hash) AS trades,
SUM(a.amount) + SUM(b.amount) AS total_volume
FROM axelar.defi.ez_bridge_satellite a
JOIN axelar.defi.ez_bridge_squid b
ON a.sender = b.sender
WHERE date_part('quarter', a.block_timestamp) = 1
AND date_part('year', a.block_timestamp) = 2024
AND date_part('quarter', b.block_timestamp) = 1
AND date_part('year', b.block_timestamp) = 2024
AND a.amount IS NOT NULL
AND b.amount IS NOT NULL
GROUP BY 1
ORDER BY 3 DESC
LIMIT 20
QueryRunArchived: QueryRun has been archived