User Distribution by Stake Volume _date

SalehUser Distribution by Stake Volume _date

Updated 2025-05-12

-- forked from User Distribution by Stake Volume @ https://flipsidecrypto.xyz/studio/queries/31303efa-4b9d-4176-ad6f-5cc847591653

----------------------------------------------Price------------------------------------

with lst_aptos_price_last as (

select

median(price) as aptos_price

from aptos.price.ez_prices_hourly

where symbol='APT'

and hour::date=current_date

)

,lst_aptos_price_all as (

select

hour::date as price_date

,median(price) as "APT Price"

from aptos.price.ez_prices_hourly

where symbol='APT'

group by 1

order by 1

)

---------------------------------------------Stake-------------------------------------

,lst_stake as (

select

block_timestamp::date as date_a

,tx_hash

,event_data:delegator as staker

,event_data:amount/1e8 as amount

,event_data:t_apt_coins/1e8 as tAPT_amount

from aptos.core.fact_events

where block_timestamp::date >='2022-10-19'

and SUCCESS=true

and TX_TYPE='user_transaction'

and event_module='stake_router'

and EVENT_RESOURCE='StakeEvent'

and event_address='0x8f396e4246b2ba87b51c0739ef5ea4f26515a98375308c31ac2ec1e42142a57f'

group by all

)

Last run: 12 days ago

2KB