SocioCryptoTrading Volume
Updated 2024-11-27
9
1
2
3
4
5
6
7
8
›
⌄
SELECT TO_TIMESTAMP(value[0]::string) as date,
value[1] as trading_volume_usd
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 response
),LATERAL FLATTEN (input => response:data:total_volumes)
WHERE date < current_date
ORDER BY date DESC
QueryRunArchived: QueryRun has been archived