TOTAL_TRANSACTIONS | TOTAL_DISTINCT_USERS | TOKEN_INVOLVED | TOTAL_VOLUME_PLATFORM | TOTAL_BUY_VOLUME | TOTAL_SELL_VOLUME | |
|---|---|---|---|---|---|---|
1 | 832365 | 19913 | 17252 | 40752413.7852245 | 21304606.4754176 | 19447807.3098068 |
pepperatziMetrics on Tama
Updated 2025-02-17
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
›
⌄
--Trade --TokenCreated --TokenMigrated --FirstBuyerFeePaid
with raw as (
select
block_timestamp,
tx_hash,
'0x'|| substr(topics[1], 27) as token_address,
'0x'|| substr(topics[2], 27) as creator,
regexp_substr_all(substr(data, 3), '.{64}') as segmented,
livequery.utils.udf_hex_to_int(segmented[7]) * 2 as one,
livequery.utils.udf_hex_to_int(segmented[9]) * 2 as two,
livequery.utils.udf_hex_to_int(segmented[11]) * 2 as three,
from ronin.core.fact_event_logs
where contract_address = '0xa54b0184d12349cf65281c6f965a74828ddd9e8f'
and topics[0] = '0xf372df0af3c16a1deb41b25691dd807a3836ba8f443e83d24c1406ae3748232e'
),
tokencreated as (
SELECT
block_timestamp as created_date,
tx_hash as created_transaction,
token_address,
creator,
livequery.utils.udf_hex_to_string(left(segmented[8], one)) as token_created,
livequery.utils.udf_hex_to_string(left(segmented[10], two)) as symbol,
livequery.utils.udf_hex_to_string(left(segmented[12], three)) as description
from raw
),
-- 1 is buy
--0 is sell
trades as (
SELECT
block_timestamp,
tx_hash,
origin_from_address as user,
'0x' || substr(topics[1], 27) as token,
Last run: about 1 month ago
1
73B
20s