damidezCandy box token distribution
Updated 2024-08-05
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 sender_logs_users AS (
SELECT
BLOCK_TIMESTAMP,
try_parse_json(CLEAN_LOG) AS log,
TX_HASH
FROM
near.core.fact_logs
WHERE
RECEIVER_ID = 'signin2.sendercommunity.near'
AND log:event = 'open_box'
AND log:data[0]:meme != ''
AND to_number(log:data[0]:amount) > 0
AND BLOCK_TIMESTAMP::date >= '2024-05-22'
),
meme_covert AS (
SELECT
BLOCK_TIMESTAMP,
log:data[0]:meme AS meme,
CASE log:data[0]:meme
WHEN 'token.lonkingnearbackto2024.near' THEN 'Lonk'
WHEN 'nearnvidia.near' THEN 'Nearvidia'
WHEN 'touched.tkn.near' THEN 'Touched'
WHEN 'blackdragon.tkn.near' THEN 'BlackDragon'
WHEN 'ftv2.nekotoken.near' THEN 'Neko'
WHEN 'token.v2.ref-finance.near' THEN 'Ref Finance (REF)'
WHEN '802d89b6e511b335f05024a65161bce7efc3f311.factory.bridge.near' THEN 'Linear
(LNR)'
WHEN 'token.burrow.near' THEN 'Burrow Token
(BRRR)'
ELSE 'Near'
END AS Meme_Token
FROM
sender_logs_users
)
SELECT
Meme_Token,
QueryRunArchived: QueryRun has been archived