Sei AnalysisTransfers and Stakes for Select Addresses -- SEI copy copy
Updated 2024-11-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
›
⌄
-- forked from Transfers and Stakes for Select Addresses -- SEI copy @ https://flipsidecrypto.xyz/studio/queries/96c872ff-8866-4fe0-9498-e25856e1c009
-- forked from graham / Transfers and Stakes for Select Addresses -- SEI @ https://flipsidecrypto.xyz/graham/q/mKr67mFeebh0/transfers-and-stakes-for-select-addresses----sei
-- Read Google Sheet
with res AS (
SELECT
livequery.live.udf_api(
'GET',
'https://science.flipsidecrypto.xyz/googlesheets/readsheet',
{ 'Content-Type': 'application/json' },
{ 'sheets_id': '1xUNsWuDAsn-8Et4y3RKmqS5L8bWdWKnfqQDmC0l6kso',
'tab_name': 'SEI' }
) as result
from
DUAL
),
data AS (
select
result:data as json_result_must_pivot
from
res
),
base_addresses as (
SELECT
d.value:"address" :: VARCHAR as address,
d.value:"name" :: VARCHAR as name,
d.value:"type" :: VARCHAR as type
FROM
data,
LATERAL FLATTEN(input => data.json_result_must_pivot :: VARIANT) d
),
sei_prices as (
Select
TO_TIMESTAMP(value [0] :: string) as hour,
QueryRunArchived: QueryRun has been archived