strawbettyMatic circulating supply
    Updated 2022-06-08
    with b as (
    select date_trunc('day', balance_date) as dt, balance
    from flipside_prod_db.ethereum.erc20_balances
    where CONTRACT_ADDRESS = '0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0'
    and user_address != lower('0x50d669f43b484166680ecc3670e4766cdb0945ce')
    and user_address != lower('0xcbfe11b78c2e6cb25c6eda2c6ff46cd4755c8fca')
    and user_address != lower('0xb316fa9fa91700d7084d377bfdc81eb9f232f5ff')
    and user_address != lower('0xccb04768f3abcf1af1e749085ef67d8ec7c5fdd2')
    and user_address != lower('0x5e3ef299fddf15eaa0432e6e66473ace8c13d908')
    )
    select dt, sum(balance) as circulate_supply
    from b
    where dt >= '2019-04-01'
    group by 1
    Run a query to Download Data