potmoCIrculating Supply
    Updated 2022-08-17
    with circ_supply as (
    select *
    from optimism.core.fact_event_logs
    where 1 = 1
    and ORIGIN_TO_ADDRESS ilike '0x9c7305eb78a432ced5c4d14cac27e8ed569a2e26'
    and event_name ilike 'supply'
    )
    select block_timestamp, event_inputs:supply /1e18
    from circ_supply
    where block_timestamp in (select max(block_timestamp) from circ_supply) /* 316159058.815807 coinggecko 296M */
    Run a query to Download Data