No Data to Display
RayyykLiFi (Swap + Bridge Vol)
Updated 6 days ago
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
›
⌄
-- BSC & Base
with res1 as(select livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/203ede5c-4f00-416e-8d03-30f1c5c9f617/data/latest') as result), --Base Code - (Volume) - BSC & Base
data1 as (select result:data as json_result_must_pivot from res1),
table_1 as (select to_timestamp(value:DATE) as day,
value:INTEGRATORS as integrators,
value:USD_VOLUME as usd_volume,
value:CUMU_USD_VOLUME as cumu_usd_volume
from data1,
LATERAL FLATTEN(input => data1.json_result_must_pivot::VARIANT) d),
-- Ethereum & Polygon
res2 as(select livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/5bf55615-c7c2-4ef9-8c41-522f7a685ee5/data/latest') as result), --Base Code - (Volume) - Ethereum & Polygon
data2 as (select result:data as json_result_must_pivot from res2),
table_2 as (select to_timestamp(value:DATE) as day,
value:INTEGRATORS as integrators,
value:USD_VOLUME as usd_volume,
value:CUMU_USD_VOLUME as cumu_usd_volume
from data2,
LATERAL FLATTEN(input => data2.json_result_must_pivot::VARIANT) d),
-- Arbitrum, Optimism, Gnosis & Avalanche
res3 as(select livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/129a5189-e9af-414c-a9fd-1b4885af9c57/data/latest') as result), --Base Code - (Volume) - Arbitrum, Optimism, Gnosis & Avalanche
data3 as (select result:data as json_result_must_pivot from res3),
table_3 as (select to_timestamp(value:DATE) as day,
value:INTEGRATORS as integrators,
value:USD_VOLUME as usd_volume,
value:CUMU_USD_VOLUME as cumu_usd_volume
from data3,
LATERAL FLATTEN(input => data3.json_result_must_pivot::VARIANT) d),
Last run: 6 days ago
0
2B
2s