MARKETPLACE_NAME | USER_ADDR | N_TXS | TOTAL_VOLUME_TON | TOTAL_VOLUME_USD | |
|---|---|---|---|---|---|
1 | TONNEL Marketplace | 995884 | 1165000 | 8688867.6892 | 30748916.2561376 |
2 | OTC ELF | 155360 | 225656 | 1081626.746588 | 5082380.44245947 |
3 | Getgems | 68510 | 37092 | 582328.107831 | 2083107.04830071 |
4 | Fragment | 34047 | 17233 | 519024.552609 | 1741697.64802274 |
5 | Giftpot | 8047 | 11457 | 176779.080795 | 837055.349990135 |
6 | Marketapp | 7125 | 3785 | 138527.88858 | 520485.501202975 |
7 | GiftON Market | 20408 | 29326 | 27876.926598 | 92359.961783649 |
8 | Nest Store | 2919 | 3606 | 17360.59866 | 88538.480262284 |
9 | other on-chain marketplaces | 962 | 544 | 17700.409278 | 70775.129243264 |
10 | Market | 2203 | 3455 | 11551.6816 | 35257.02984225 |
11 | WTS | 6170 | 8019 | 1581.072829 | 5429.046163713 |
0xHaM-dTurnover in Ttl Breakdown by marketplace name
Updated 2025-04-24
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 marketplaces as (
select * from (values
('Fragment', '0:408DA3B28B6C065A593E10391269BAAA9C5F8CAEBC0C69D9F0AABBAB2A99256B', 'onchain_marketplace'),
('Marketapp', '0:9A9CB80ADFBD1662F5108766D73355AC2C03304FDA1D25A479670E34EFCD72B3', 'onchain_marketplace'),
('Giftpot', '0:4A65B3AB29951A2AF941C2BFF1CF5C023F156CB4B33E59E5C437342E287AF435', 'offchain_marketplace'),
('TONNEL Marketplace', '0:59B357B68790B09B143198024B18DA843DC43D894DC10838F4352CDBC138866B', 'offchain_marketplace'),
('GiftON Market', '0:3A127974BAF796039DB8BF5C55FEECF808E2622D439B866EF5EC0848075E77AC', 'offchain_marketplace'),
('Nest Store', '0:835E549F3148722EED4A5E4526207D9C76BEE38578B742C1D61A1245E68966FE', 'offchain_marketplace'),
('OTC ELF', '0:77624EC871B5B041367733CBCE52C38263BA8EDA3D9249183DFDE0432A5F7761', 'offchain_marketplace'),
('Getgems', '0:584EE61B2DFF0837116D0FCB5078D93964BCBE9C05FD6A141B1BFCA5D6A43E18', 'onchain_marketplace'),
('Market', '0:5BCAB0124D1CE78261171FB0073A2870431C458BDAAB9F973877F6ACC7A5E7D4', 'offchain_marketplace'),
('WTS', '0:2F110AE2FEB3CA85CBA7A088E03864776968486FCB7B8E338223B57EE0D6C846', 'offchain_marketplace')
) as b (marketplace_name, marketplace_address, subcategory)
)
,
ton_price as (
select
hour::date as p_date,
avg(price) as price
from crosschain.price.ez_prices_hourly
where symbol = 'WTON'
group by 1
)
,
offchain_data AS (
SELECT
BLOCK_TIMESTAMP,
'offchain' AS type,
mp.marketplace_name,
iff(destination = mp.marketplace_address, source, destination) AS user_addr,
case
WHEN (direction = 'in'
AND destination = mp.marketplace_address
AND source != mp.marketplace_address)
OR
(direction = 'out'
Last run: about 2 months ago
11
619B
70s