cloudr3nFX Avax - TJ Xave exchange rate
Updated 2025-02-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
›
⌄
with feddata as (
SELECT
fred.get_series({
'series_id': 'DEXUSEU',
'file_type': 'json',
'observation_start': '2023-01-01' -- modify this for start date
}) as resp
),
parseddata as (
select
PARSE_JSON(resp:data:observations)::variant as json_object --data:observations
from feddata
),
finaldata as (
SELECT
to_date(value:date) as day,
value:value as value
--json_object:data:observations
--json_object:date as date,
--json_object:value as value
from parseddata,
lateral FLATTEN(input=>parse_json(json_object)) f
),
actual as (
select
day,
value -- as value
from
finaldata
where value>0
),
tj as (
QueryRunArchived: QueryRun has been archived