sinahosseinzadehUntitled Query
Updated 2022-08-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with cs as (
select
BALANCE_DATE as date,
sum(balance) as curculating_supply
from flipside_prod_db.ethereum.erc20_balances
where
CONTRACT_ADDRESS = lower('0x7D1AfA7B718fb893dB30A3aBc0Cfc608AaCfeBB0')
and USER_ADDRESS not in ('0x50d669f43b484166680ecc3670e4766cdb0945ce', '0xcbfe11b78c2e6cb25c6eda2c6ff46cd4755c8fca',
'0xb316fa9fa91700d7084d377bfdc81eb9f232f5ff', '0xccb04768f3abcf1af1e749085ef67d8ec7c5fdd2','0x5e3ef299fddf15eaa0432e6e66473ace8c13d908')
group by date
),
price as (
select
date_trunc('day', HOUR) as date,
avg(PRICE) as matic_average_price
from flipside_prod_db.ethereum.token_prices_hourly
where TOKEN_ADDRESS = lower('0x7D1AfA7B718fb893dB30A3aBc0Cfc608AaCfeBB0')
group by date
)
select cs.date,
cs.curculating_supply,
p.matic_average_price
from cs join price p on cs.date = p.date
Run a query to Download Data