BaseMC- Supply- Price- 1 token
    Updated 2024-09-08
    with pricetbl as
    (
    SELECT price
    from base.price.ez_prices_hourly
    where token_address = lower ('0x4ed4E862860beD51a9570b96d89aF5E1B0Efefed')
    order by hour DESC
    limit 1
    ),
    supplytbl as
    (
    with database as
    (
    with general as (
    with tbl3 as (
    with tbl as (
    select
    to_address as "Address",
    sum(amount) as "Input"
    from
    base.core.ez_token_transfers
    where
    contract_address = lower ('0x4ed4E862860beD51a9570b96d89aF5E1B0Efefed')
    group by
    1
    ),
    tbl2 as (
    select
    from_address as "Address",
    sum(amount) as "Output"
    from
    base.core.ez_token_transfers
    where
    contract_address = lower ('0x4ed4E862860beD51a9570b96d89aF5E1B0Efefed')
    group by 1
    )
    select
    QueryRunArchived: QueryRun has been archived