feyikemiAvalanche Inbound Bridge
Updated 2024-06-22
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
›
⌄
WITH bridge_activity AS (
SELECT
date_trunc('day', BLOCK_TIMESTAMP) AS day,
CONCAT(SOURCE_CHAIN, '->', DESTINATION_CHAIN) AS bridge_direction,
'inbound' AS direction,
COUNT(DISTINCT TX_HASH) AS total_bridges,
COUNT(DISTINCT source_address) AS total_bridgers,
SUM(Amount_usd) AS total_amount_bridged
FROM
crosschain.defi.ez_bridge_activity
WHERE
DESTINATION_CHAIN = 'avalanche'
AND SOURCE_CHAIN <> DESTINATION_CHAIN
AND BLOCK_TIMESTAMP::DATE >= '2024-01-01'
GROUP BY 1, 2, 3
)
SELECT
--day,
bridge_direction,
direction,
SUM(total_bridges) AS total_bridges,
SUM(total_bridgers) AS total_bridgers,
SUM(total_amount_bridged) AS total_amount_bridged
FROM
bridge_activity
GROUP BY 1, 2
--Order By 3 DESC
QueryRunArchived: QueryRun has been archived