CHAIN_NAME | TRANSACTIONS | BRIDGERS | TOTAL_VOLUME_USD | ETH_VOLUME_USD | BOBA_VOLUME_USD | AVG_BRIDGE_VOLUME_USD | |
|---|---|---|---|---|---|---|---|
1 | Ethereum Mainnet (L1) | 127 | 59 | 270453.687069271 | 203500.547464349 | 66953.139604922 | 2033.486368942 |
2 | Optimism Mainnet | 979 | 331 | 55913.356457503 | 55913.356457503 | 0 | 54.817016135 |
3 | BNB Chain Mainnet (L1) | 27 | 2 | 12368.089416671 | 0 | 12368.089416671 | 458.077385803 |
4 | Arbitrum One Mainnet | 615 | 15 | 67406.470714257 | 67406.470714257 | 0 | 94.143115523 |
5 | Boba BNB Testnet (test L2 on BNB Chain) | 102 | 7 | 41008.94071624 | 0 | 41008.94071624 | 398.145055497 |
datavortexPer Source Chain ID
Updated 2025-04-03
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 disbursement AS (
SELECT
block_timestamp,
tx_hash,
decoded_log:amount / 1e18 AS amount,
decoded_log:depositId AS deposit_id,
decoded_log:sourceChainId AS source_chain_id,
decoded_log:to AS receiver,
decoded_log:token AS token_address,
CASE
WHEN decoded_log:token = '0x0000000000000000000000000000000000000000' THEN 'ETH'
WHEN decoded_log:token = '0xa18bf3994c0cc6e3b63ac420308e5383f53120d7' THEN 'BOBA'
END AS token_symbol
FROM boba.core.ez_decoded_event_logs
WHERE event_name = 'DisbursementSuccess'
AND origin_function_signature = '0x92c3ec48'
AND tx_succeeded = TRUE
),
disbursement_with_price AS (
SELECT
d.block_timestamp,
d.tx_hash,
d.amount,
d.deposit_id,
d.source_chain_id,
d.receiver,
d.token_address,
d.token_symbol,
p.price AS token_price,
d.amount * p.price AS amount_usd
FROM disbursement d
LEFT JOIN boba.price.ez_prices_hourly p
ON d.token_symbol = p.symbol
AND DATE_TRUNC('hour', d.block_timestamp) = p.hour
)
SELECT
Last run: 14 days ago
5
430B
1s