SocioCryptoRaw Historical Data
Updated 2024-04-10
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
›
⌄
-- TVL
with tvl as (
WITH json as (
SELECT
defillama.get('/v2/historicalChainTvl/arbitrum', { }) as resp
)
SELECT
TO_TIMESTAMP(value:date :: string) as date,
value:tvl as tvl_usd
FROM
json,
LATERAL FLATTEN(input => resp:data)
),
-- $ARB Price
arb_price as (
SELECT
date_trunc('d', hour) as date,
median (price) as price,
STDDEV (price) as priceSTDDEV
FROM
arbitrum.price.ez_hourly_token_prices
WHERE
token_address = '0x912ce59144191c1204e64559fe8253a0e49e6548'
GROUP BY
1
),
-- arb_price as (
-- SELECT
-- TO_TIMESTAMP(value[0]::string) as date,
-- value[1] as price
-- FROM (
-- SELECT livequery.live.udf_api(
-- 'https://api.coingecko.com/api/v3/coins/arbitrum/market_chart?vs_currency=usd&days=365&interval=daily&precision=3') as response
-- ),LATERAL FLATTEN (input => response:data:prices)
-- ),
-- trading volume
QueryRunArchived: QueryRun has been archived