with solana_fee_transactions as (

select

block_timestamp,

tx_id as tx_hash,

block_id as block_number,

(fee / 1e9) as fee,

signers[0] as from_address

from solana.core.fact_transactions

where block_timestamp::date > current_date - 31

),

sol_price_usd as (

select

recorded_hour::date as days,

avg(close) as price_usd

from solana.core.fact_token_prices_hourly

where symbol = 'MSOL'

and recorded_hour::date > current_date - 31

group by days

),

solana_fee_transactions_with_price as (

select

gas.*,

price.price_usd

from solana_fee_transactions gas

join sol_price_usd price

on gas.block_timestamp::date = price.days

),

solana_fee_transactions_fix_price as (

select

*,

fee * price_usd as fee_spent

from solana_fee_transactions_with_price

),

solana_final_result as (