kaibladecur_work
Updated 2023-12-16
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
----- 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