StangFAST02 - overview new [ number ]
Updated 2023-09-01
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 01 - overview new @ https://flipsidecrypto.xyz/edit/queries/9cf10364-a528-441c-8edc-81c4f8939193
-- forked from 01 - overview @ https://flipsidecrypto.xyz/edit/queries/e29d2701-2ae2-4028-90fb-53f724d1cb1a
--- sei usei
--- atom ibc/C4CFF46FD6DE35CA4CF4CE031E643C8FDC9BA4B99AE598E9B0ED98FE3A2319F9
--- osmo ibc/ED07A3391A112B175915CD8FAF43A2DA8E4790EDE12566649D0C2F97716B8518
--- weth factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/4tLQqCLaoKKfNFuPjA9o39YbKUwhR1F8N29Tz3hEbfP2
--- usdc factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/Hq4tuDzhRBnxw3tFA5n6M52NVMVcC19XggbyDiJKCD6H
--- wbtc factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/7omXa4gryZ5NiBmLep7JsTtTtANCVKXwT9vbN91aS1br
with
fuzio AS
(
SELECT
a.address
, a.label
, a.label_type
, a.label_subtype
, a.address_name
FROM
sei.core.dim_labels a
WHERE
a.label = 'fuzio'
GROUP BY 1 , 2 , 3 , 4 , 5
)
,
token_factory AS
(
SELECT
a.hour::date AS date
, avg( a.price ) AS price
, a.symbol AS token
FROM
ethereum.price.fact_hourly_token_prices a
Run a query to Download Data