Total Unique Bridge Transactions | Token Symbol | Net Flow (USD) | |
|---|---|---|---|
1 | 7445 | XETA | 1386336.11625626 |
datavortexxena token
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
transaction_data AS (
SELECT
DATE_TRUNC('hour', block_timestamp) AS event_hour,
tx_hash,
decoded_log:user AS wallet_address,
decoded_log:amount AS raw_token_quantity,
'0x31c994ac062c1970c086260bc61babb708643fac' AS token_address,
event_name AS activity_type
FROM avalanche.core.ez_decoded_event_logs
WHERE
contract_address = '0xb866b661db0b1b0f39ed28fc59c77d60983dccbb'
AND event_name IN ('Deposit', 'Withdraw')
),
price_data AS (
SELECT
hour AS recorded_hour,
token_address,
symbol AS token_symbol,
name AS token_name,
decimals,
price
FROM avalanche.price.ez_prices_hourly
WHERE token_address = '0x31c994ac062c1970c086260bc61babb708643fac'
),
final_aggregations AS (
SELECT
p.token_symbol AS "Token Symbol",
COUNT(DISTINCT t.tx_hash) AS "Total Unique Bridge Transactions",
SUM(CASE
WHEN t.activity_type = 'Deposit' THEN p.price * (t.raw_token_quantity / POW(10, COALESCE(p.decimals, 18)))
WHEN t.activity_type = 'Withdraw' THEN -1 * (p.price * (t.raw_token_quantity / POW(10, COALESCE(p.decimals, 18))))
END) AS "Net Flow (USD)"
FROM transaction_data t
Last run: 2 months ago
1
32B
7s