strawbettyMatic circulating supply
Updated 2022-06-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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