TRANSACTION_COUNT | UNIQUE_WALLETS | TOTAL_BTC_BRIDGED | TOTAL_VALUE_USD | |
|---|---|---|---|---|
1 | 0 | 0 |
Updated 2025-03-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
-- DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,
COUNT(DISTINCT TX_HASH) AS transaction_count,
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS unique_wallets,
SUM(AMOUNT) AS total_btc_bridged,
SUM(AMOUNT_USD) AS total_value_usd
FROM avalanche.defi.ez_bridge_activity
WHERE TOKEN_SYMBOL = 'BTC.b'
AND DESTINATION_CHAIN = 'avalanche'
AND BLOCK_TIMESTAMP >= '2025-01-01'
-- GROUP BY 1
Last run: about 1 month ago
1
17B
1s