BRIDGER_ADDRESS | BRIDGE_COUNT | TOTAL_VOLUME_USD | Tokens Bridged | AVG_BRIDGE_VOLUME_USD | |
|---|---|---|---|---|---|
1 | 0x3f6e473d9457452952026c6a77ea79a469d8bdd3 | 1101 | 34749.26687194 | 16 ETH | 31.532910047 |
2 | 0x0604e652a188931e245717d45feb26f583b92908 | 78 | 41029.431278665 | $18435 BOBA, 9 ETH | 512.867890983 |
3 | 0xb46619c7e8ab447692e4d4b3f69b8f10451ff615 | 66 | 4933.711637747 | 3 ETH | 30.644171663 |
4 | 0x0b89d72ba572b1389c444583f6db62a36af0029c | 56 | 30681.6592895 | $30643 BOBA | 547.886773027 |
5 | 0xac6a579987e812581c9f28d23526079187a38ed6 | 30 | 157019.347581025 | 56 ETH | 5233.978252701 |
6 | 0xbc16fef143eaeadaed65c0ce4375b97aad1393f8 | 30 | 1614.546355 | 1 ETH | 30.463138774 |
7 | 0x664fe2accb8096bd612639eb1e05a81121a9ea9a | 22 | 747.94807 | 33.997639545 | |
8 | 0x9255a776c1103e88b4d876c118755cf0939826ee | 21 | 964.294087 | 1 ETH | 32.143136233 |
9 | 0x2727e77b19c49725407aa02bc4dfafdea5ee3a1b | 15 | 46331.080407661 | $44443 BOBA, 1 ETH | 3088.738693844 |
10 | 0x8c8dc0e9abbb733fc5aa9f05c6c6227ab4100f99 | 9 | 7007.532207 | 2 ETH | 778.614689667 |
datavortexTop Bridgers
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
),
bridger_totals AS (
Last run: 19 days ago
10
886B
4s