TOTAL_BRIDGE_TRANSACTIONS | TOTAL_BRIDGERS | TOTAL_AMOUNT_USD | |
|---|---|---|---|
1 | 12183 | 5976 | 482661836.351265 |
datavortexbridge from ronin
Updated 2025-03-18
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 daily_prices AS (
SELECT
TOKEN_ADDRESS,
DATE_TRUNC('day', hour) AS price_date,
SYMBOL,
NAME,
DECIMALS,
AVG(PRICE) AS avg_daily_price
FROM ronin.price.ez_prices_hourly
GROUP BY
TOKEN_ADDRESS,
DATE_TRUNC('day', hour),
SYMBOL,
NAME,
DECIMALS
),
transfer_data AS (
SELECT
t.tx_hash,
MAX(CASE
WHEN t.event_name = 'Transfer' THEN COALESCE(t.decoded_log:_to, t.decoded_log:to)
ELSE NULL
END) AS bridger,
MAX(CASE
WHEN t.event_name = 'Transfer' THEN COALESCE(t.decoded_log:_from, t.decoded_log:from)
ELSE NULL
END) AS bridge,
MAX(CASE
WHEN t.event_name = 'Transfer' THEN COALESCE(t.decoded_log:_value, t.decoded_log:value)
ELSE NULL
END) AS transfer_value_raw,
MAX(CASE
WHEN t.event_name = 'Transfer' THEN t.contract_address
ELSE NULL
END) AS contract_address,
MAX(CASE
Last run: about 2 months ago
1
31B
9s