MONTH | PLATFORM | MONTHLY_AMOUNT | |
|---|---|---|---|
1 | 2021-11-01 00:00:00.000 | hop | 23897445.66 |
2 | 2021-12-01 00:00:00.000 | hop | 29538224.47 |
3 | 2021-12-01 00:00:00.000 | celer_cbridge | 16546441.48 |
4 | 2022-01-01 00:00:00.000 | celer_cbridge | 18548768.95 |
5 | 2022-01-01 00:00:00.000 | hop | 23336251.39 |
6 | 2022-02-01 00:00:00.000 | celer_cbridge | 5783416.22 |
7 | 2022-02-01 00:00:00.000 | hop | 16458998.42 |
8 | 2022-03-01 00:00:00.000 | hop | 18077349.19 |
9 | 2022-03-01 00:00:00.000 | stargate | |
10 | 2022-03-01 00:00:00.000 | celer_cbridge | 4568672.9 |
11 | 2022-04-01 00:00:00.000 | stargate | |
12 | 2022-04-01 00:00:00.000 | hop | 41005688.25 |
13 | 2022-04-01 00:00:00.000 | celer_cbridge | 3950814.71 |
14 | 2022-05-01 00:00:00.000 | stargate | |
15 | 2022-05-01 00:00:00.000 | celer_cbridge | 2758165 |
16 | 2022-05-01 00:00:00.000 | hop | 25102285.46 |
17 | 2022-06-01 00:00:00.000 | stargate | |
18 | 2022-06-01 00:00:00.000 | hop | 42149758.81 |
19 | 2022-06-01 00:00:00.000 | celer_cbridge | 8551835.01 |
20 | 2022-07-01 00:00:00.000 | stargate |
matejchiBridging on Optimism
Updated 2025-04-14
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
›
⌄
with top_5 as
(
select
platform,
sum(amount_usd) as total_volume
from optimism.defi.ez_bridge_activity
where platform != 'multichain'
group by platform
order by total_volume desc
limit 5
)
select
date_trunc ('month', block_timestamp) as month,
platform,
sum(amount_usd) as monthly_amount,
from optimism.defi.ez_bridge_activity
where
month < date_trunc('month', current_date)
and platform in (select platform from top_5)
group by month, platform
order by month asc
Last run: 2 months ago
...
143
7KB
3s