TIME | TOKEN_SYMBOL | VOLUME_DAILY | VOLUME_ADJ_DAILY | TOTAL_VOLUME | |
|---|---|---|---|---|---|
1 | 2025-02-02 00:00:00.000 | LUAUSD | 12574.61 | -12574.61 | -6175463.64114357 |
2 | 2025-01-06 00:00:00.000 | APRS | 2134.765575 | -2134.765575 | -6826508.84662416 |
3 | 2025-01-03 00:00:00.000 | Farm Land | 0 | 0 | -2031678.65165966 |
4 | 2025-01-20 00:00:00.000 | Farm Land | 0 | 0 | -2231207.99285732 |
5 | 2025-01-18 00:00:00.000 | WETH | 2176904.91928482 | 1980032.60871638 | -1528790.8122251 |
6 | 2025-02-10 00:00:00.000 | KONGZ VX | 0 | 0 | -11046572.2270528 |
7 | 2025-02-20 00:00:00.000 | AXS | 5115.665730323 | 3654.006410391 | -5379805.01326482 |
8 | 2025-02-23 00:00:00.000 | AXS | 362052.455980565 | 357181.205074865 | -4035078.22983811 |
9 | 2025-01-16 00:00:00.000 | WETH | 759966.278776106 | 648638.555938778 | -4087653.81336316 |
10 | 2025-01-09 00:00:00.000 | Farm Land | 0 | 0 | -10719022.1725543 |
11 | 2025-01-05 00:00:00.000 | WETH | 457589.903558236 | 189814.262279196 | -1893609.27941265 |
12 | 2025-02-06 00:00:00.000 | USDC | 254701.711296374 | -73134.854115496 | -7260655.79051483 |
13 | 2025-01-03 00:00:00.000 | WETH | 1092119.66950283 | -985089.638821609 | -2031678.65165966 |
14 | 2025-02-24 00:00:00.000 | USDC | 90326.776518968 | -82106.794890058 | -5382964.81205132 |
15 | 2025-01-26 00:00:00.000 | USDC | 329306.235747853 | 274544.043591071 | -6100711.00053385 |
16 | 2025-01-14 00:00:00.000 | AXS | 67288.353242817 | 17345.143002121 | -9922004.15124306 |
17 | 2025-02-11 00:00:00.000 | Farm Land | 0 | 0 | -10905610.1533689 |
18 | 2025-02-21 00:00:00.000 | Farm Land | 0 | 0 | -4891980.16625081 |
19 | 2025-02-08 00:00:00.000 | BANANA | 2261.906179471 | 2189.585739607 | -10012284.5443096 |
20 | 2025-01-08 00:00:00.000 | WETH | 89162.998061254 | 15721.627237418 | -7515658.53869413 |
SandeshRonin all bridge data
Updated 2025-02-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with combined as
(
select *, volume as volume_adj from $query('c9cb7b00-6571-46d0-8fcf-98ddd0918d00') -- eth to ronin native
union all
select *, volume *-1 as volume_adj from $query('0f7064ce-f741-4478-b2fb-36ad3299fe87') -- ronin to eth native
union all
select *, volume as volume_adj from $query('12e4fd6e-d1cf-4de9-a264-52f2cbc27427') -- eth to ronin ccip
union all
select *, volume as volume_adj from $query('eb0fed1b-bf9c-4bd5-94cb-3e7ab26172bc') -- base to ronin ccip
union all
select *, volume *-1 as volume_adj from $query('22d4f224-9dde-43f6-9bd1-6b9b14e96140')-- ronin to base and eth ccip
)
select date_trunc('day',date) as time, token_symbol, sum(coalesce(volume,0))::FLOAT as volume_daily, sum(coalesce(volume_adj,0))::FLOAT as volume_adj_daily
, sum(volume_adj_daily) over (order by time asc)::FLOAT as total_volume
from combined
group by time, token_symbol
Last run: 2 months ago
...
543
43KB
4s