USER_ADDRESSES | N_TXS | TOTAL_VOLUME_TON | TOTAL_VOLUME_USD | AVG_VOL_PER_USER | AVG_VOLUME_USD | MEDIAN_VOLUME_USD | |
|---|---|---|---|---|---|---|---|
1 | 1308320 | 1514461 | 11270627.750737 | 41338846.3400072 | 31.596892458 | 39.502682645 | 1.025920833 |
0xHaM-dTurnover in Ttl
Updated 2025-04-24
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 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
1
90B
139s