Abolfazl_771025daily wmatic
Updated 2023-02-13Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select
block_timestamp::date as date,
case
when date <= '2022-12-19' then 'Before Bootstrapping'
else 'After Bootstrapping'
end as period,
sum(amount/power(10, decimal)) as bridged_volume,
sum(bridged_volume) over (order by date) as cumulative_bridged_volume,
count(DISTINCT receiver) as bridgers_count,
sum(bridgers_count) over (order by date) as cumulative_bridgers_count
from osmosis.core.fact_transfers join osmosis.core.dim_labels on address = currency
where project_name like '%MATIC%'
and receiver like 'osmo%'
and sender like 'axelar%'
group by 1
Run a query to Download Data