select

hour::date as date,

avg(price) as token_price_usd

from

kaia.price.ez_prices_hourly

where

token_address = '0x19aac5f612f524b754ca7e7c41cbfa2e981a4432'

group by 1

),

stake_events as (

select

tx_hash,

block_timestamp,

origin_from_address as user,

decoded_log:value::bigint / 1e18 as amount,

'Stake' as event_name

from

kaia.core.ez_decoded_event_logs

where

contract_address = '0x999999999939ba65abb254339eec0b2a0dac80e9'

and event_name = 'Transfer'

and tx_succeeded

and origin_from_address = decoded_log:to

and origin_to_address = '0xf50782a24afcb26acb85d086cf892bfffb5731b5'

and tx_hash in (

select distinct tx_hash

from kaia.core.ez_decoded_event_logs

where event_name = 'StakeKlay'

and decoded_log:from = '0x999999999939ba65abb254339eec0b2a0dac80e9'

)

),

first_stake as (

select