Abolfazl_771025daily wmatic
    Updated 2023-02-13
    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