datavortexresulting-fuchsia
Updated 2024-12-23
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
›
⌄
/*
WITH
-- Swaps
Swaps AS (
SELECT
COUNT(DISTINCT tx_hash) AS distinct_tx_hash_count,
COUNT(DISTINCT sender) AS active_users
FROM aptos.core.fact_transactions
WHERE DATE(block_timestamp) = CURRENT_DATE - INTERVAL '1 DAY'
AND LOWER(SPLIT_PART(payload_function, '::', 3)) LIKE '%swap%'
AND success = TRUE
),
-- Bridges
Bridges AS (
SELECT
COUNT(DISTINCT tx_hash) AS distinct_tx_hash_count,
COUNT(DISTINCT sender) AS active_users
FROM aptos.core.fact_transactions
WHERE DATE(block_timestamp) = CURRENT_DATE - INTERVAL '1 DAY'
AND LOWER(SPLIT_PART(payload_function, '::', 2)) LIKE '%bridge%'
AND success = TRUE
),
-- NFT Sales
NFTSales AS (
SELECT
COUNT(DISTINCT tx_hash) AS distinct_tx_hash_count,
COUNT(DISTINCT sender) AS active_users
FROM aptos.core.fact_transactions
WHERE DATE(block_timestamp) = CURRENT_DATE - INTERVAL '1 DAY'
AND LOWER(SPLIT_PART(payload_function, '::', 3)) IN (
'purchase',
'unlist_and_accept_token_bid',
'sell_instantly_token_v2',
'accept_collection_bid',
QueryRunArchived: QueryRun has been archived