Trader Category | Total Bridgers | Category Volume (USD) | |
|---|---|---|---|
1 | Dolphin ($10K-$100K) | 1519 | 40278610.2974461 |
2 | Shark ($100K-$1M) | 146 | 30955954.6367677 |
3 | Fish ($1K-$10K) | 5453 | 18026174.628304 |
4 | Whale (>$1M) | 3 | 5561863.12716259 |
5 | Minnow (<$1K) | 40614 | 3013132.08711444 |
datavortexdfk category
Updated 2025-03-29
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 dfk_tx AS (
SELECT
DATE_TRUNC('hour', block_timestamp) AS date_hour,
tx_hash,
origin_from_address AS sender,
origin_to_address AS receiver,
decoded_log:token::STRING AS token_address,
decoded_log:amount AS raw_amount,
CASE
WHEN event_name = 'TokenDeposit' THEN 'Deposit'
WHEN event_name IN ('TokenRedeem', 'TokenRedeemAndSwap') THEN 'Withdraw'
END AS flow_direction
FROM avalanche.core.ez_decoded_event_logs
WHERE contract_address = '0xc05e61d0e7a63d27546389b7ad62fdff5a91aace'
AND event_name IN ('TokenDeposit', 'TokenRedeem', 'TokenRedeemAndSwap')
AND decoded_log:chainId = '53935'
),
token_prices AS (
SELECT
hour AS price_hour,
token_address,
symbol AS token_symbol,
name AS token_name,
decimals,
price
FROM avalanche.price.ez_prices_hourly
),
enriched_dfk AS (
SELECT
dt.date_hour AS block_timestamp,
dt.tx_hash,
dt.token_address,
tp.token_symbol AS "Token Symbol",
tp.token_name AS "Token Name",
COALESCE(tp.decimals, 18) AS "Token Decimals",
tp.price AS "Token Price (USD)",
Last run: 2 months ago
5
209B
9s