nits$APE Stake Pool Based Distribution
Updated 2022-12-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
--credit : https://app.flipsidecrypto.com/velocity/queries/d73ac744-63a7-4178-99a0-3bee361d3b58
select case when origin_function_signature = '0x9dcaafb4' then '$APE Only Pool'
when origin_function_signature = '0x8ecbffa7' then 'MAYC Pool'
when origin_function_signature = '0x46583a05' then 'BAYC Pool'
when origin_function_signature = '0xd346cbd9' then 'BAKC Pool'
else null end as pool_type,
count (distinct tx_hash) as TX_Count,
count (distinct origin_from_address) as Users_Count,
sum (event_inputs:value/1e18) as Total_Staked_Volume,
avg (event_inputs:value/1e18) as Average_Staked_Volume,
median (event_inputs:value/1e18) as Median_Staked_Volume,
min (event_inputs:value/1e18) as Minimum_Staked_Volume,
max (event_inputs:value/1e18) as Maximum_Staked_Volume
from ethereum.core.fact_event_logs
where origin_to_address = '0x5954ab967bc958940b7eb73ee84797dc8a2afbb9'
and event_name = 'Transfer'
and tx_status = 'SUCCESS'
and pool_type is not null
group by 1
order by 2 desc
Run a query to Download Data