DATE | NUMBER_OF_MEME_TOKENS | TOTAL_NUMBER_OF_MEME_TOKENS | |
|---|---|---|---|
1 | 2025-01-13 00:00:00.000 | 1 | 571 |
2 | 2025-01-12 00:00:00.000 | 3 | 570 |
3 | 2025-01-11 00:00:00.000 | 8 | 567 |
4 | 2025-01-10 00:00:00.000 | 3 | 559 |
5 | 2025-01-09 00:00:00.000 | 1 | 556 |
6 | 2025-01-08 00:00:00.000 | 1 | 555 |
7 | 2025-01-07 00:00:00.000 | 6 | 554 |
8 | 2025-01-06 00:00:00.000 | 7 | 548 |
9 | 2025-01-05 00:00:00.000 | 1 | 541 |
10 | 2025-01-04 00:00:00.000 | 2 | 540 |
11 | 2025-01-03 00:00:00.000 | 7 | 538 |
12 | 2025-01-02 00:00:00.000 | 3 | 531 |
13 | 2024-12-31 00:00:00.000 | 2 | 528 |
14 | 2024-12-30 00:00:00.000 | 5 | 526 |
15 | 2024-12-29 00:00:00.000 | 6 | 521 |
16 | 2024-12-28 00:00:00.000 | 2 | 515 |
17 | 2024-12-27 00:00:00.000 | 1 | 513 |
18 | 2024-12-26 00:00:00.000 | 3 | 512 |
19 | 2024-12-25 00:00:00.000 | 2 | 509 |
20 | 2024-12-24 00:00:00.000 | 3 | 507 |
Sandeshagent tokens daily
Updated 2025-03-03
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
›
⌄
with agent_tokens AS (
SELECT
block_timestamp,
tx_hash AS deploy_tx_hash,
signer_id AS deployer_address,
TRY_PARSE_JSON(clean_log):"data" AS parsed_data,
parsed_data:"name" AS token_name,
parsed_data:"symbol" AS symbol,
parsed_data:"meme_id" AS meme_id,
parsed_data:"soft_cap"/1e24 AS min_near_amount,
parsed_data:"hard_cap"/1e24 AS max_near_amount,
parsed_data:"total_supply"/power(10,parsed_data:"decimals") AS total_supply,
block_timestamp AS start_time,
to_timestamp(parsed_data:"end_timestamp_ms") AS end_time,
'Agent' AS type
FROM near.core.fact_logs
WHERE block_timestamp >= '2024-11-01'
AND signer_id = 'memecoinscash.near'
AND TRY_PARSE_JSON(clean_log) IS NOT NULL
)
select
block_timestamp::date as date
, count(meme_id) as number_of_meme_tokens
, sum(number_of_meme_tokens) over (order by date asc) as total_number_of_meme_tokens
from agent_tokens
group by date
order by date desc
Last run: about 2 months ago
62
2KB
3s