binhachonCopy of Copy of Copy of Untitled Query
Updated 2022-05-07
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
›
⌄
with json as (
select
parse_json(
'[{"datetime":1559746800000,"value":"23"},{"datetime":1559833200000,"value":"30"},{"datetime":1559919600000,"value":"26"},{"datetime":1560006000000,"value":"20"},{"datetime":1560092400000,"value":"41"},{"datetime":1560178800000,"value":"80"},{"datetime":1560265200000,"value":"87"},{"datetime":1560351600000,"value":"1950"},{"datetime":1560438000000,"value":"6099"},{"datetime":1560524400000,"value":"14533"},{"datetime":1560610800000,"value":"7851"},{"datetime":1560697200000,"value":"9552"},{"datetime":1560783600000,"value":"8900"},{"datetime":1560870000000,"value":"7820"},{"datetime":1560956400000,"value":"7614"},{"datetime":1561042800000,"value":"7033"},{"datetime":1561129200000,"value":"5233"},{"datetime":1561215600000,"value":"6196"},{"datetime":1561302000000,"value":"6479"},{"datetime":1561388400000,"value":"8612"},{"datetime":1561474800000,"value":"8786"},{"datetime":1561561200000,"value":"7214"},{"datetime":1561647600000,"value":"8441"},{"datetime":1561734000000,"value":"6030"},{"datetime":1561820400000,"value":"7866"},{"datetime":1561906800000,"value":"9506"},{"datetime":1561993200000,"value":"7327"},{"datetime":1562079600000,"value":"6529"},{"datetime":1562166000000,"value":"6329"},{"datetime":1562252400000,"value":"7686"},{"datetime":1562338800000,"value":"5728"},{"datetime":1562425200000,"value":"6872"},{"datetime":1562511600000,"value":"8846"},{"datetime":1562598000000,"value":"7373"},{"datetime":1562684400000,"value":"7976"},{"datetime":1562770800000,"value":"7469"},{"datetime":1562857200000,"value":"7974"},{"datetime":1562943600000,"value":"5716"},{"datetime":1563030000000,"value":"6813"},{"datetime":1563116400000,"value":"11450"},{"datetime":1563202800000,"value":"8386"},{"datetime":1563289200000,"value":"9249"},{"datetime":1563375600000,"value":"8558"},{"datetime":1563462000000,"value":"6352"},{"datetime":1563548400000,"value":"37"},{"datetime":1563634800000,"value":"34"},{"datetime":1563721200000,"value":"12646"},{"datetime":1563807600000,"value":"31593"},{"datetime":1563894000000,"value":"11741"},{"datetime":1563980400000,"value":"10260"},{"datetime":1564066800000,"value":"15706"},{"datetime":1564153200000,"value":"10662"},{"da![]()
![]()
)
as json_data
),
terra_station as (
select
value:datetime,
date_trunc('day', to_timestamp(value:datetime::integer/1e3)) as time,
value:value::float as value
from json,
lateral flatten (input => json_data)
),
tx_from as (
select
block_timestamp + interval'8 hours' as block_timestamp,
'Active user' as symbol,
value as user_address
from terra.transactions,
lateral flatten (input => tx_from)
--where tx_id = '625A7FCB6AAB442E08C065AE701C4580FB6F9DA1CB446A193523185AD005EA66'
),
tx_to as (
select
block_timestamp + interval'8 hours' as block_timestamp,
'Passive user' as symbol,
value as user_address
from terra.transactions,
lateral flatten (input => tx_to)
--where tx_id = '625A7FCB6AAB442E08C065AE701C4580FB6F9DA1CB446A193523185AD005EA66'
),
total as (
select
*
Run a query to Download Data