TOTAL_SWAPS | TOTAL_TRADERS | TOTAL_SWAP_VOLUME | TOTAL_BUYS | TOTAL_SELLS | TOTAL_BUYERS | TOTAL_SELLERS | TOTAL_BOUGHT_VOLUME | TOTAL_SOLD_VOLUME | |
|---|---|---|---|---|---|---|---|---|---|
1 | 586407 | 98840 | 23033767.6185792 | 8702 | 10689 | 278 | 355 | 25524.753200336 | 31524.926927857 |
feyikemiSwap Totals
Updated 2025-03-23
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 all_time_totals AS (
SELECT
COUNT(DISTINCT TX_HASH) AS Total_swaps,
COUNT(DISTINCT TRADER) AS Total_traders,
SUM(COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD)) AS Total_Swap_Volume
FROM near.defi.ez_dex_swaps
WHERE
TOKEN_IN_CONTRACT = 'blackdragon.tkn.near' OR TOKEN_OUT_CONTRACT = 'blackdragon.tkn.near'
),
swaps_7_days AS (
SELECT
TX_HASH,
TRADER,
COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD) AS Volume,
CASE
WHEN TOKEN_OUT_CONTRACT = 'blackdragon.tkn.near' THEN 'Buy'
WHEN TOKEN_IN_CONTRACT = 'blackdragon.tkn.near' THEN 'Sell'
ELSE NULL
END AS Swap_Type
FROM near.defi.ez_dex_swaps
WHERE
(TOKEN_IN_CONTRACT = 'blackdragon.tkn.near' OR TOKEN_OUT_CONTRACT = 'blackdragon.tkn.near')
AND BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '7 DAY'
),
buy_stats_7_days AS (
SELECT
COUNT(DISTINCT TX_HASH) AS Total_buys,
COUNT(DISTINCT TRADER) AS Total_buyers,
SUM(Volume) AS Total_bought_volume
FROM swaps_7_days
WHERE Swap_Type = 'Buy'
),
sell_stats_7_days AS (
SELECT
COUNT(DISTINCT TX_HASH) AS Total_sells,
Last run: 2 months ago
1
84B
138s