hbd1994Networks Overview - TXs, Users and Fee
Updated 2023-09-13
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
›
⌄
with price as (select
date(HOUR) as price_date,
symbol,
avg(price) as daily_Price
from crosschain.price.ez_hourly_token_prices
where symbol in ('osmo','sol','NEAR','MATIC','BNB','avax','WETH','atom')
and TOKEN_ADDRESS in
('uosmo',
'so11111111111111111111111111111111111111112',
'0x1fa4a73a3f0133f0025378af00236f3abdee5d63',
'0x0000000000000000000000000000000000001010',
'0xb8c77482e45f1f44de1745f52c74426c631bdd52',
'ibc/6F62F01D913E3FFE472A38C78235B8F021B511BC6596ADFF02615C8F83D3B373',
'0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2',
'ibc/27394FB092D2ECCD56123C74F36E4C1F926001CEADA9CA97EA622B25F41E5EB2')
and HOUR >= '2023-08-15'
and HOUR::date < current_date
group by 1 , 2
order by 1 , 2),
sei_price as (
SELECT
date(TO_TIMESTAMP(value[0]::string)) as price_date,
'SEI' as symbol
, value[1] as daily_price
from (
SELECT livequery.live.udf_api(
'https://api.coingecko.com/api/v3/coins/sei-network/market_chart?vs_currency=usd&days=90&interval=daily&precision=3') as resp
)
,LATERAL FLATTEN (input => resp:data:prices))
--Credit to @hess for this part and using live query for sei price in this query: https://flipsidecrypto.xyz/hess/q/1O73pVNX_AZF/overview-of-projects-sorted-based-on-consumed-fees
(
select
network as "Network",
Run a query to Download Data