h4wkbonk 2
Updated 2023-08-14
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
›
⌄
-- forked from bonk @ https://flipsidecrypto.xyz/edit/queries/d4e25ab3-1c08-46a9-bb52-1be4567a8963
-- forked from base histogram @ https://flipsidecrypto.xyz/edit/queries/6355b419-6073-4db1-bc7c-edd791529b00
-- forked from base swap @ https://flipsidecrypto.xyz/edit/queries/3e622b27-4f07-405a-837a-eb01c5c6385b
-- DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263 -- BONK
-- hntyVP6YFm1Hg25TN9WGLqM12b8TQmcknKrdu1oxWux -- HNT
-- iotEVVZLEywoTn1QdwNPddxPWszn3zFhEot3MfL9fns -- IOT
-- mb1eu7TzEc71KxDpsmsKoucSSuuoGLv1drys1oP2jh6 -- MOBILE
with tokens as (
select * from (
values
('DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263', 'BONK'),
('hntyVP6YFm1Hg25TN9WGLqM12b8TQmcknKrdu1oxWux', 'HNT'),
('iotEVVZLEywoTn1QdwNPddxPWszn3zFhEot3MfL9fns', 'IOT'),
('mb1eu7TzEc71KxDpsmsKoucSSuuoGLv1drys1oP2jh6', 'MOBILE')
) as t(address, symbol)
)
, curr_price as (
select
symbol,
address,
avg(close) as price
from solana.price.fact_token_prices_hourly
join tokens using(symbol)
group by 1,2, recorded_hour
qualify row_number() over (partition by symbol order by recorded_hour desc) = 1
)
, token_holdings as (
select block_timestamp,
post_tokens.value:owner as wallet,
post_tokens.value:mint as token,
symbol,
post_tokens.value:uiTokenAmount:uiAmount as amount,
Run a query to Download Data