SELECT

t1.block_id,

t1.block_timestamp,

t1.tx_id,

t1.index,

t1.inner_index,

t1.succeeded,

t1.event_type,

t1.mint as token_address,

t1.mint_authority,

t1.inserted_timestamp

FROM solana.defi.fact_token_mint_actions AS t1

WHERE t1.succeeded = 'TRUE'

AND t1.event_type = 'initializeMint2'

AND t1.mint_authority = 'TSLvdd1pWpHVjahSpsvCXUbgwsL3JAcvokwaKt1eokM' -- pump.fun Token Mint Authority

--AND t1.block_id = '299488189'

--AND t1.block_timestamp BETWEEN '2024-11-04 00:00:00.000' AND '2024-11-04 23:59:59.000'

ORDER BY t1.block_id DESC

LIMIT 5;