bonk_daily_price as (

select

recorded_hour::date as days,

avg(close) as price

from

solana.core.ez_token_prices_hourly

where

token_address = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

group by

days

),

active_user as (

select

signers[0] as active_address

from

solana.core.fact_transactions

where

block_timestamp >= current_date - 30

),

bonk_transfer as (

select

transfers.*

from

solana.core.fact_transfers transfers

where

mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

and block_timestamp::date >= '2022-12-24'

),

transfer_bonk_from_user as (

select

block_timestamp::date as days,

tx_from as address,

- (sum(amount)) as amount

from

bonk_transfer