with pools_details as (

select

-- case

-- when owner = 'LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo' then 'Meteora DLMM'

-- when owner = 'whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc' then 'Orca'

-- end as program_name

account_address as pool_address

from solana.core.fact_token_account_owners

where 1 = 1

and owner = 'whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc'

-- and owner in (

-- 'LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo' -- Meteora DLMM Program

-- , 'whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc' -- ORCA

-- )

, pools_tvl as (

select

block_timestamp

, date_trunc(week, block_timestamp) as week_

, 'Orca' as program_name

, account_address

, owner

, mint

, symbol

, price

, balance

, balance - pre_balance as delta

, balance * price as token_usd_tvl

, delta * price as transfer_usd_value

, tx_id

from solana.core.fact_token_balances

inner join pools_details on owner = pool_address

left join solana.price.ez_prices_hourly on token_address = mint and date_trunc(hour, block_timestamp) = hour