SELECT

TO_ADDRESS as address,

BLOCK_NUMBER as block_number,

'constant' as blockchain_id,

BLOCK_TIMESTAMP as block_time,

OUTPUT as bytecode,

'calculated' as bytecode_hash,

FROM_ADDRESS as creator_address,

'?' as creator_address_tx,

INPUT as creator_bytecode,

'calculated' as creator_bytecode_hash,

'calculated' as received_at,

TX_HASH as transaction_hash,

'flipside' as source,

TX_STATUS as status,

TRACE_STATUS as trace_status

FROM bsc.core.fact_traces

WHERE BLOCK_TIMESTAMP BETWEEN '2024-06-01' AND '2024-06-02'

AND TYPE IN ('CREATE2', 'CREATE')

AND TX_STATUS = 'SUCCESS'

AND TRACE_STATUS = 'SUCCESS'

LIMIT 10