alirsBAAS-02
    Updated 2022-12-08
    select
    count (distinct tx_hash) as "Number of Stake",
    count (distinct origin_from_address) as"Number of Stakers",
    sum (event_inputs:value/pow(10,18)) as "APE Stake Volume",
    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
    from ethereum.core.fact_event_logs
    where origin_to_address = '0x5954ab967bc958940b7eb73ee84797dc8a2afbb9'
    and event_name = 'Transfer'
    and tx_status = 'SUCCESS'
    and pool is not null
    group by pool
    order by 1 desc
    Run a query to Download Data