0xHaM-d$NEKO Top Holders Type
Updated 2024-08-15
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
›
⌄
-- forked from $UWON Top Holders Type @ https://flipsidecrypto.xyz/edit/queries/6da436e5-0e2a-44b8-a2c2-5a60f84e3d84
-- forked from Power Users Among $UWON Top Holders @ https://flipsidecrypto.xyz/edit/queries/ac87daf5-1f35-4777-b851-b7511b777cc3
-- forked from MoDeFi / $UWON Top Holders @ https://flipsidecrypto.xyz/MoDeFi/q/wVpTxNNQF4Xs/uwon-top-holders
with succeeded_txs as (
select tx_hash as tx
from near.core.fact_transactions
where tx_succeeded=true
),
price as (
select
value[0]::string as hour,
value[1]::float as price
from (select livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/8f8bb378-76ea-43d4-8afe-432aaa76a585/latest-run')
as response), lateral FLATTEN (input => response:data:result:rows)),
date_start as (
with dates AS (
SELECT CAST('2023-10-28' AS DATE) AS start_date
UNION ALL
SELECT DATEADD(day, 1, start_date)
FROM dates
WHERE start_date < CURRENT_DATE())
SELECT date_trunc(day, start_date) AS start_date
FROM dates),
----------------------- ft transfers -----------------------
--$neko token transfers
neko_transfers as (
select block_id, block_timestamp,
event_json:data[0]:old_owner_id::string as from_address,
event_json:data[0]:new_owner_id::string as to_address,
event_json:data[0]:amount as amount_raw,
QueryRunArchived: QueryRun has been archived