rahoQuorum
Updated 2023-02-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
with
circsup as (
select
balance / pow(10, 18) as circbal,
date_trunc('day', block_timestamp) as curdate,
contract_address
from
ethereum.core.fact_token_balances
where
curdate = cast(getdate () as date)
and contract_address = '0xc18360217d8f7ab5e7c516566761ea12ce7f9d72'
group by
2,
3
),
grouped as (
select
curdate as "Date",
circbal / pow(10,18) as circulating,
circbal * 0.01 as "Quorum"
from
circsup
)
select
*
from
grouped
Run a query to Download Data