tx.block_timestamp::date as fecha,

tx.tx_id,

tx.program_id,

e.pretokenbalances,

e.posttokenbalances,

e.inner_instruction,

e.instruction,

e.event_type

FROM solana.transactions tx

INNER JOIN solana.events e

ON tx.tx_id = e.tx_id

where fecha >= '2022-01-01' and fecha <= '2022-02-27'

and tx.succeeded = 'TRUE'

and (pre_mint = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB'

or post_mint = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB')

LIMIT 100