SELECT DISTINCT date_trunc('day',block_timestamp) as date

FROM solana.core.fact_transfers

WHERE date>='2023-01-01'

),

sent as (

SELECT date_Trunc('day',block_timestamp) as date,

sum(amount) as vol,

sum(vol)over(ORDER BY date) as cum,

count(DISTINCT tx_to) as n_address,

count(DISTINCT tx_id) as n_payments

FROM solana.core.fact_transfers

WHERE tx_from = 'J2mcf6NpWdy6oPiEeD4hb2SrWt8NXGrgQMZspWPoUgFL'

AND mint = 'So11111111111111111111111111111111111111112'

GROUP BY date--, symbol

),

received as (

SELECT date_Trunc('day',block_timestamp) as date,

sum(amount) as vol,

sum(vol)over(ORDER BY date) as cum,

count(DISTINCT tx_from) as n_address,

count(DISTINCT tx_id) as n_payments

FROM solana.core.fact_transfers

WHERE tx_to = 'J2mcf6NpWdy6oPiEeD4hb2SrWt8NXGrgQMZspWPoUgFL'

AND mint = 'So11111111111111111111111111111111111111112'

GROUP BY date--, symbol

),

price as (

SELECT date_trunc('day', block_timestamp) as date,

median(swap_to_amount/swap_from_amount) as sol_price

FROM solana.core.fact_swaps

WHERE swap_from_mint = 'So11111111111111111111111111111111111111112'

and (swap_to_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' or swap_to_mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'

or swap_to_mint = 'BQcdHdAQW1hczDbBi9hiegXAR7A98Q9jx3X3iBBBDiq4')

and succeeded = 'TRUE'

AND swap_from_amount is not NULL