kaibladecur_work
    Updated 2023-12-16
    ----- Mercato
    WITH mercato_buy_events_raw AS (
    SELECT
    *
    FROM
    aptos.core.fact_events
    WHERE
    event_address = '0xe11c12ec495f3989c35e1c6a0af414451223305b579291fc8f3d9d0575a23c26'
    AND event_resource = 'BuyEvent'
    ORDER BY
    event_index
    ),

    mercato_bid_events_raw AS
    (SELECT
    *
    FROM
    aptos.core.fact_events
    WHERE
    event_address = '0xe11c12ec495f3989c35e1c6a0af414451223305b579291fc8f3d9d0575a23c26'
    AND event_resource = 'AcceptTokenBidEvent'

    UNION

    SELECT
    *
    FROM
    aptos.core.fact_events
    WHERE
    event_address = '0xe11c12ec495f3989c35e1c6a0af414451223305b579291fc8f3d9d0575a23c26'
    AND event_resource = 'AcceptCollectionBidEvent'
    ),

    mercato_bids_sales_events_raw AS
    (SELECT *, 'sale' AS event_kind
    FROM mercato_buy_events_raw
    Run a query to Download Data