alitaslimiSupply Over Time
    Updated 2024-03-18
    with
    -------------------- BTC Price --------------------
    prices as (
    select
    price
    from
    bitcoin.price.ez_hourly_token_prices
    qualify
    hour = last_value(hour) over (order by hour)
    ),
    -------------------- Dates --------------------
    dates as (
    select distinct
    month_start_date as date
    from
    crosschain.core.dim_dates
    where
    date_day between '2022-06-01' and (current_date - 1)
    ),
    -------------------- Arbitrum --------------------
    arbitrum_mints as (
    select
    date_trunc('month', block_timestamp) as date,
    sum(amount) as volume
    from
    arbitrum.core.ez_token_transfers
    where
    contract_address = '0x2297aebd383787a160dd0d9f71508148769342e3'
    and from_address = '0x0000000000000000000000000000000000000000'
    and to_address != '0x0000000000000000000000000000000000000000'
    group by
    date
    ),
    arbitrum_burns as (
    select
    date_trunc('month', block_timestamp) as date,
    QueryRunArchived: QueryRun has been archived