kaibladeParas Marketplace Total Gross Sales Per Day
Updated 2023-06-27
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
›
⌄
-- forked from 10ee9d9f-489f-40d6-a2c4-2c474b659d03
-- forked from a371f03d-ccdf-4e58-81cb-1c1aaff87b27
WITH paras_marketplace_receipts AS
(SELECT *, TRY_PARSE_JSON(logs[0]) as log
FROM near.core.fact_receipts
WHERE receiver_id = 'marketplace.paras.near'
AND block_timestamp::date >= CURRENT_DATE() - INTERVAL '30 days'
ORDER BY block_timestamp DESC
),
paras_calls AS
(SELECT call.*, tx.tx_signer,
COALESCE
(call.args:nft_contract_id,
call.args:market_data.nft_contract_id,
call.args:offer_data.nft_contract_id,
log:params.nft_contract_id) AS "NFT Contract ID"
FROM near.core.fact_actions_events_function_call call
JOIN near.core.fact_transactions tx
ON call.tx_hash = tx.tx_hash
JOIN paras_marketplace_receipts rec
ON call.tx_hash = rec.tx_hash
WHERE call.tx_hash IN (SELECT tx_hash FROM paras_marketplace_receipts)
),
create_nft AS
(SELECT tx_hash, args:token_metadata.copies AS total_minted,
args:token_metadata.title AS nft_name, split(nft_name,'#')[0] AS collection
FROM near.core.fact_actions_events_function_call
WHERE method_name = 'nft_create_series'
ORDER BY block_timestamp DESC
),
Run a query to Download Data