Flipside TeamCapybara APY
Updated 2024-08-29
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_tab AS (
SELECT
TO_TIMESTAMP(log.value[0] :: string) as date,
log.value[1]::string as price,
'WETH' :: string AS token_symbol,
'0x98a8345bb9d3dda9d808ca1c9142a28f6b0430e1' :: string AS token_contract,
'0x3ce1aa52eeaf57a355939c09ac76f03f01988f13' :: string AS pool_contract_address
FROM (SELECT livequery.live.udf_api('https://api.coingecko.com/api/v3/coins/weth/market_chart?vs_currency=usd&days=365&interval=daily&precision=3') as resp)
,LATERAL FLATTEN (input => resp:data:prices) log
UNION all
SELECT
TO_TIMESTAMP(log.value[0] :: string) as date,
log.value[1]::string as price,
'WKLAY' :: string AS token_symbol,
'0x19aac5f612f524b754ca7e7c41cbfa2e981a4432' :: string AS token_contract,
'0x8a5562d2a17488647381c1a0e9cf527a01b6f3bd' :: string AS pool_contract_address
FROM (SELECT livequery.live.udf_api('https://api.coingecko.com/api/v3/coins/klay-token/market_chart?vs_currency=usd&days=365&interval=daily&precision=3') as resp)
,LATERAL FLATTEN (input => resp:data:prices) log
UNION all
SELECT
TO_TIMESTAMP(log.value[0] :: string) as date,
'1'::string as price,
'USDT' :: string AS token_symbol,
'0x5c13e303a62fc5dedf5b52d66873f2e59fedadc2' :: string AS token_contract,
'0xa856b5da8e85b23395c17783954edda010317fce' :: string AS pool_contract_address
FROM (SELECT livequery.live.udf_api('https://api.coingecko.com/api/v3/coins/klay-token/market_chart?vs_currency=usd&days=365&interval=daily&precision=3') as resp)
,LATERAL FLATTEN (input => resp:data:prices) log
),
QueryRunArchived: QueryRun has been archived