Total Transactions | Total Users | Direct Sales | Wallet Transfers | Offers Accepted | Total Supply | Total Sales | |
|---|---|---|---|---|---|---|---|
1 | 17194 | 4112 | 4726 | 2579 | 1651 | 6969 | 6377 |
i_danRONKE: Total Metrics
Updated 8 days ago
99
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 main_data AS (
SELECT
block_timestamp
, tx_hash
, is_mint
, origin_function_signature
, origin_from_address
, quantity
, token_id
FROM ronin.nft.ez_nft_transfers
WHERE
contract_address = lower('0x810b6d1374ac7ba0e83612e7d49f49a13f1de019')
-- AND is_mint = 'FALSE'
--GROUP BY 1
--ORDER BY 2 DESC
--LIMIT 1000
)
SELECT
COUNT(tx_hash) AS "Total Transactions"
, COUNT(DISTINCT origin_from_address) AS "Total Users"
, COUNT(CASE WHEN origin_function_signature = '0x95a4ec00' THEN tx_hash
WHEN origin_function_signature = '0x2beee4c7' THEN tx_hash END) AS "Direct Sales"
, COUNT(CASE WHEN origin_function_signature = '0x42842e0e' THEN tx_hash END) AS "Wallet Transfers"
, COUNT(CASE WHEN origin_function_signature = '0x17246d5d' THEN tx_hash END) AS "Offers Accepted"
, COUNT(CASE WHEN origin_function_signature = '0xfb4d364c' THEN tx_hash END) AS "Total Supply"
, "Direct Sales" + "Offers Accepted" AS "Total Sales"
FROM main_data
--GROUP BY 1
--ORDER BY 2 DESC
--transfer 0x42842e0e
--sale 0x95a4ec00
--multi-sale 0x2beee4c7
--offers 0x17246d5d
Last run: 8 days ago
1
39B
1s