full_stepn_wallet_table as (

SELECT

BLOCK_TIMESTAMP, TX_FROM, TX_TO, AMOUNT, MINT, PRICE

FROM

solana.core.fact_transfers as token_transfers

INNER JOIN solana.price.ez_prices_hourly as token_prices ON (

token_prices.TOKEN_ADDRESS = token_transfers.MINT

AND DATE_TRUNC('hour', token_transfers.BLOCK_TIMESTAMP) = token_prices.HOUR

)

WHERE

BLOCK_TIMESTAMP >= TIMESTAMP '2022-03-04'

AND (

TX_FROM = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'

OR TX_TO = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'

)

AND MINT IN (

'7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx',

'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB'

)

) (

SELECT

SUM(AMOUNT * PRICE) AS TOTAL_AMOUNT_USD,

DATE_TRUNC('DAY', BLOCK_TIMESTAMP) as DAY,

'OUT_GMT' AS

TYPE

FROM

full_stepn_wallet_table

WHERE

TX_FROM = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'

AND MINT = '7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx'

GROUP BY

DAY

)