with marketplace_sales as (

select

tx_hash

,block_timestamp

,decoded_log:matcher::STRING AS buyer

,decoded_log:order[0][0]::STRING AS seller

,decoded_log:order[0][1]::NUMBER AS order_kind

,decoded_log:order[0][2][0][1]::STRING AS nft_address

,decoded_log:order[0][2][0][2]::NUMBER AS token_id

,decoded_log:order[0][2][0][3]::NUMBER AS token_quantity

,decoded_log:order[0][3]::NUMBER AS order_expiredAt

,decoded_log:order[0][4]::STRING AS order_paymentToken

,decoded_log:order[0][6]::NUMBER / 1e6 AS sale_price

,decoded_log:order[0][12]::BOOLEAN AS order_verified

,decoded_log:order[3]::STRING AS order_recipient

,decoded_log:order[4]::STRING AS order_refunder

,decoded_log:receivedAllocs[1][1]::STRING AS receivedAllocs_recipient2 -- no idea who

,decoded_log:receivedAllocs[1][3]::NUMBER / 1e2 AS receivedAllocs_ratio2

,decoded_log:receivedAllocs[1][4]::NUMBER / 1e6 AS receivedAllocs_amount2

,decoded_log:receivedAllocs[2][1]::STRING AS receivedAllocs_recipient3 --axie community treasury no idea why is here but it doesn't get anything

,decoded_log:receivedAllocs[2][3]::NUMBER / 1e2 AS receivedAllocs_ratio3

,decoded_log:receivedAllocs[2][4]::NUMBER / 1e6 AS receivedAllocs_amount3

,decoded_log:receivedAllocs[3][1]::STRING AS receivedAllocs_recipient4 --contract: Ronin Treasury

,decoded_log:receivedAllocs[3][3]::NUMBER / 1e2 AS receivedAllocs_ratio4

,decoded_log:receivedAllocs[3][4]::NUMBER / 1e6 AS receivedAllocs_amount4

,decoded_log:receivedAllocs[4][1]::STRING AS receivedAllocs_recipient5

,decoded_log:receivedAllocs[4][3]::NUMBER / 1e2 AS receivedAllocs_ratio5 --unknown contract

,decoded_log:receivedAllocs[4][4]::NUMBER / 1e6 AS receivedAllocs_amount5

,decoded_log:receivedAllocs[5][1]::STRING AS seller_address

,decoded_log:receivedAllocs[5][3]::NUMBER / 1e2 AS seller_ratio

,decoded_log:receivedAllocs[5][4]::NUMBER / 1e6 AS effective_earning

from ronin.core.ez_decoded_event_logs

where 1=1

and block_timestamp > '2025-03-03'

and event_name = 'OrderMatched'