boomer77pooly
Updated 2022-06-22
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
›
⌄
with supporter as (select date_trunc('day', block_timestamp) as dt, 'supporter' as nft, count(distinct tx_hash) as tx_count, count(distinct from_address) as minter_count, sum(eth_value) as volume_eth,
SUM(tx_count) OVER(ORDER BY dt asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_tx,
SUM(minter_count) OVER(ORDER BY dt asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS minter_tx,
SUM(volume_eth) OVER(ORDER BY dt asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_vol
from ethereum.core.fact_transactions
where to_address = '0x90b3832e2f2ade2fe382a911805b6933c056d6ed' and status = 'SUCCESS'
group by 1,2),
lawyer as (select date_trunc('day', block_timestamp) as dt, 'lawyer' as nft, count(distinct tx_hash) as tx_count, count(distinct from_address) as minter_count, sum(eth_value) as volume_eth,
SUM(tx_count) OVER(ORDER BY dt asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_tx,
SUM(minter_count) OVER(ORDER BY dt asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS minter_tx,
SUM(volume_eth) OVER(ORDER BY dt asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_vol
from ethereum.core.fact_transactions
where to_address = '0x3545192b340f50d77403dc0a64cf2b32f03d00a9' and status = 'SUCCESS'
group by 1),
judge as (select date_trunc('day', block_timestamp) as dt, 'judge' as nft, count(distinct tx_hash) as tx_count, count(distinct from_address) as minter_count, sum(eth_value) as volume_eth,
SUM(tx_count) OVER(ORDER BY dt asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_tx,
SUM(minter_count) OVER(ORDER BY dt asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS minter_tx,
SUM(volume_eth) OVER(ORDER BY dt asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_vol
from ethereum.core.fact_transactions
where to_address = '0x5663e3e096f1743e77b8f71b5de0cf9dfd058523' and status = 'SUCCESS'
group by 1)
select * from supporter
union all
select * from lawyer
union all
select * from judge
Run a query to Download Data