with my_sol_wallet as (

select 'GwLV8LoFmjgJ7tXrpRPbPZ8bUVuQuXWHdYm8J9wBd9mz' UNION

select '6xhfwVepgUNamSmAiJfh5aiQ2YtUX1hKYcphGqfLeKAg' UNION

select '6edtSGjXyx6Ljya61jtCLHED26hhCSBrdTFMbdLZa2Mr'

), sol_price as (

select recorded_hour::date as price_date,

avg(close) as price

from solana.core.fact_token_prices_hourly

where SYMBOL = 'SOL' group by 1

), tx_h4wk as (

select tx_id, block_timestamp, signers

from solana.core.fact_transactions where block_timestamp >= '2022-03-01'

and signers[0] in (select * from my_sol_wallet)

), transfer_h4wk as (

select *

FROM solana.core.fact_transfers

where block_timestamp >= '2022-03-01'

and tx_to in (select * from my_sol_wallet)

and tx_from not in (select * from my_sol_wallet)

and tx_from not in ('5tzFkiKscXHK5ZXCGbXZxdw7gTjjD1mBwuoFbhUvuAi9') -- Binance

and mint = 'So11111111111111111111111111111111111111112'