cheeyoung-kekLil Nouns treasury value Vs Noun Treasury
Updated 2022-07-04
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
28
29
30
31
32
33
34
35
36
›
⌄
⌄
/*
Q2. The Lil Nouns DAO was created as a sub-DAO from Nouns DAO. The Lil Nouns DAO compensates Nouns DAO by automatically sending every
11th Lil Noun (Lil Noun ids #1, #11, #21, #31 and so on) to the Nouns DAO Treasury.
Estimate the total value of the Lil Nouns in the Nouns DAO treasury, and analyze the value of the Lil Nouns DAO to Nouns DAO.
Feel free to include any other relevant trends you may find. Please use the core schema within the Ethereum database for this analysis.
*/
with eth_in AS (
select
date_trunc('day', BLOCK_TIMESTAMP) as date,
sum (ETH_value) as eth_in_volume
from ethereum.core.fact_traces where TO_ADDRESS=lower('0x0BC3807Ec262cB779b38D65b38158acC3bfedE10')
and TX_STATUS='SUCCESS'
group by date
order by date desc
),
eth_out as (
select
date_trunc('day', BLOCK_TIMESTAMP) as date,
sum (ETH_value) as eth_out_volume
from ethereum.core.fact_traces where FROM_ADDRESS=lower('0x0BC3807Ec262cB779b38D65b38158acC3bfedE10')
and TX_STATUS='SUCCESS'
group by date
order by date desc
)
select
a. date , (eth_in_volume - eth_out_volume ) as ETH_volume
from eth_in a join eth_out b on a.date=b.date
where a.date > CURRENT_DATE - 60
Run a query to Download Data