DATE | VOLUME_IN | VOLUME_OUT | TOTAL_VOLUME_IN | TOTAL_VOLUME_OUT | TOTAL_GROSS_VOLUME | TOTAL_BRIDGE_TVL | COUNTER | TOTAL_BRIDGES | AVG_USD_BRIDGE_SIZE | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-04-02 00:00:00.000 | 1133434.30734998 | -1251271.98527095 | 504622201.535612 | -269661725.139566 | 774283926.675178 | 151410402.8017 | 946 | 798165 | 970.080029411 |
2 | 2025-04-01 00:00:00.000 | 2016990.95114067 | -945793.565804412 | 503488767.228262 | -268410453.154295 | 771899220.382557 | 152843045.798289 | 2261 | 797219 | 968.239869324 |
3 | 2025-03-31 00:00:00.000 | 1164816.26843212 | -1111563.28344317 | 501471776.277121 | -267464659.588491 | 768936435.865612 | 146813433.762398 | 2581 | 794958 | 967.266743483 |
4 | 2025-03-30 00:00:00.000 | 1475979.20113616 | -1137568.2861013 | 500306960.008689 | -266353096.305047 | 766660056.313736 | 146444005.09202 | 2556 | 792377 | 967.544560624 |
5 | 2025-03-29 00:00:00.000 | 1809717.7580836 | -1340226.40021992 | 498830980.807553 | -265215528.018946 | 764046508.826499 | 147617619.512544 | 2604 | 789821 | 967.366667671 |
6 | 2025-03-28 00:00:00.000 | 1955311.41118952 | -1082426.66606318 | 497021263.049469 | -263875301.618726 | 760896564.668195 | 151377653.316829 | 2948 | 787217 | 966.565209679 |
7 | 2025-03-27 00:00:00.000 | 1842986.13541915 | -1514206.34115497 | 495065951.63828 | -262792874.952663 | 757858826.590943 | 158715457.804049 | 2842 | 784269 | 966.325108593 |
8 | 2025-03-26 00:00:00.000 | 1803353.54601583 | -1051908.49651944 | 493222965.502861 | -261278668.611508 | 754501634.114369 | 158666012.071093 | 3051 | 781427 | 965.543338168 |
9 | 2025-03-25 00:00:00.000 | 1097889.83425061 | -984952.896100101 | 491419611.956845 | -260226760.114989 | 751646372.071833 | 160958087.876502 | 1868 | 778376 | 965.65974808 |
10 | 2025-03-24 00:00:00.000 | 1671646.98812971 | -1608625.9065224 | 490321722.122594 | -259241807.218888 | 749563529.341483 | 161410930.819841 | 1929 | 776508 | 965.300459675 |
11 | 2025-03-23 00:00:00.000 | 1559296.13905024 | -1503195.68576245 | 488650075.134464 | -257633181.312366 | 746283256.44683 | 155730685.596347 | 1827 | 774579 | 963.469518857 |
12 | 2025-03-22 00:00:00.000 | 1823224.89720078 | -1237091.2829925 | 487090778.995414 | -256129985.626604 | 743220764.622018 | 154872287.959029 | 1821 | 772752 | 961.784330059 |
13 | 2025-03-21 00:00:00.000 | 1622723.37187547 | -1260289.28302187 | 485267554.098213 | -254892894.343611 | 740160448.441824 | 153509471.242148 | 2955 | 770931 | 960.086503775 |
14 | 2025-03-20 00:00:00.000 | 2005897.92424436 | -1882444.69643383 | 483644830.726338 | -253632605.060589 | 737277435.786927 | 153813906.950695 | 2526 | 767976 | 960.026662014 |
15 | 2025-03-19 00:00:00.000 | 2321247.04227156 | -1827893.47356936 | 481638932.802094 | -251750160.364155 | 733389093.166249 | 155732944.899926 | 2210 | 765450 | 958.114956125 |
16 | 2025-03-18 00:00:00.000 | 1757615.7499015 | -1212763.77436657 | 479317685.759822 | -249922266.890586 | 729239952.650408 | 147763285.441948 | 2090 | 763240 | 955.45300646 |
17 | 2025-03-17 00:00:00.000 | 1138888.63452651 | -883722.29732197 | 477560070.00992 | -248709503.11622 | 726269573.12614 | 148997560.654626 | 2125 | 761150 | 954.17404339 |
18 | 2025-03-16 00:00:00.000 | 1200590.76491578 | -1073288.80450986 | 476421181.375394 | -247825780.818898 | 724246962.194292 | 146606484.779226 | 2155 | 759025 | 954.180642527 |
19 | 2025-03-15 00:00:00.000 | 2017334.24028508 | -1297348.85396797 | 475220590.610478 | -246752492.014388 | 721973082.624866 | 149636891.337616 | 1703 | 756870 | 953.893115892 |
20 | 2025-03-14 00:00:00.000 | 1891571.62792296 | -1608201.94720624 | 473203256.370193 | -245455143.16042 | 718658399.530613 | 147288178.915271 | 2151 | 755167 | 951.654931334 |
All bridges by Bridge
Updated 49 minutes ago
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 hyperlane_bridges as (
select
'Hyperlane' as bridge
, date
, volume_usd_in
, volume_usd_out
, tvl_usd
, events_count
from $query('19f93923-bf61-4c76-a496-194ee7e6d11f')
)
, canonical_bridges as (
select
'Canonical' as bridge
, date
, volume_usd_in
, volume_usd_out
, tvl_usd
, events_count
from $query('3b847d0f-cb54-439d-90d7-a6c81442058c')
group by all
)
, aggregated as (
select
date
, zeroifnull(a.volume_usd_in) + zeroifnull(b.volume_usd_in) as volume_in
, zeroifnull(a.volume_usd_out) + zeroifnull(b.volume_usd_out) as volume_out
, sum(volume_in) over (order by date) as total_volume_in
, sum(volume_out) over (order by date) as total_volume_out
, total_volume_in - total_volume_out as total_gross_volume
, a.tvl_usd + b.tvl_usd as total_bridge_tvl
, zeroifnull(a.events_count) + zeroifnull(b.events_count) as counter
, sum(counter) over (order by date) as total_bridges
, total_gross_volume / total_bridges as avg_usd_bridge_size
Last run: about 1 hour agoAuto-refreshes every 3 hours
...
221
33KB
181s