TRANSACTIONS | VOLUME_BRIDGED | ETH_VOLUME_USD | BOBA_VOLUME_USD | AVG_BRIDGE_VOLUME_USD | BRIDGERS | |
|---|---|---|---|---|---|---|
1 | 1850 | 447150.544373943 | 326820.374636109 | 120330.169737834 | 223.687115745 | 403 |
datavortextotals
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: about 1 month ago
1
77B
5s