Moe1 FLOW's Path
    Updated 2023-04-21
    with
    base as (select
    date_trunc(month,BLOCK_TIMESTAMP)::date date ,
    sum(amount) as circulating_supply
    from flow.core.ez_token_transfers
    where token_contract='A.1654653399040a61.FlowToken'
    group by 1
    )

    ,fin as (select
    date_trunc(month,BLOCK_TIMESTAMP)::date date ,
    sum (AMOUNT) as stake_AMOUNT
    from flow.core.ez_staking_actions
    where ACTION ilike '%Committ%'
    group by 1)

    select
    a.date ,
    a.stake_AMOUNT,
    b.circulating_supply,
    100*stake_AMOUNT/circulating_supply as stake_ratio
    from
    base b , fin a
    where
    a.date = b.date
    Run a query to Download Data