FROM_RONIN_BRIDGE_TRANSACTIONS | FROM_RONIN_BRIDGERS | FROM_RONIN_AMOUNT_USD | FROM_RONIN_AVG_BRIDGE_USD | FROM_RONIN_LAST_24H_TRANSACTIONS | FROM_RONIN_LAST_24H_AMOUNT_USD | TO_RONIN_BRIDGE_TRANSACTIONS | TO_RONIN_BRIDGERS | TO_RONIN_AMOUNT_USD | TO_RONIN_AVG_BRIDGE_USD | TO_RONIN_LAST_24H_TRANSACTIONS | TO_RONIN_LAST_24H_AMOUNT_USD | TOTAL_BRIDGE_TRANSACTIONS | TOTAL_BRIDGERS | TOTAL_AMOUNT_USD | TOTAL_AVG_BRIDGE_USD | TOTAL_LAST_24H_TRANSACTIONS | TOTAL_LAST_24H_AMOUNT_USD | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 12185 | 5977 | 4496462042133.68 | 369016170.876789 | 109 | 4619346301.69498 | 9316 | 4670 | 2023977561458.93 | 217258218.27597 | 76 | 685140958.05691 | 12185 | 5977 | 6520439603592.61 | 535120197.258318 | 12185 | 5304487259.75189 |
datavortexfinal
Updated 2025-03-18
999
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_from_ronin AS (
SELECT
t.tx_hash,
MAX(
CASE
WHEN t.event_name = 'Transfer' THEN COALESCE(t.decoded_log:_to, t.decoded_log:to)
END
) AS bridger,
MAX(
CASE
WHEN t.event_name = 'Transfer' THEN COALESCE(t.decoded_log:_from, t.decoded_log:from)
END
) AS bridge,
MAX(
CASE
WHEN t.event_name = 'Transfer' THEN COALESCE(t.decoded_log:_value, t.decoded_log:value)
END
) AS transfer_value_raw,
MAX(
Last run: about 2 months ago
1
199B
19s