flipside

    base nfts sales
    jackguybase nfts sales
    Updated 2023-08-03
    SELECT *
    -- block_timestamp,
    -- tx_hash,
    -- FULL_DECODED_LOG['data'][6]['value'] as token_address,
    -- FULL_DECODED_LOG['data'][1]['value'] as seller,
    -- FULL_DECODED_LOG['data'][2]['value'] as buyer
    -- FULL_DECODED_LOG
    --FROM base.core.fact_decoded_event_logs
    FROM base.core.fact_event_logs
    --WHERE contract_address LIKE '0x1fc10ef15e041c5d3c54042e52eb0c54cb9b710c'
    --where FULL_DECODED_LOG:name LIKE 'ERC721OrderFilled'
    --AND contract_address LIKE lower('0xdef1c0ded9bec7f1a1670819833240f027b25eff')
    WHERE tx_hash LIKE '0x228234eea7ad802cf776d99607aaab8b21db151ffe1ac23df2dd7d1a70e65e7b'
    ORDER by block_timestamp
    Run a query to Download Data