binhachonInteractive Users - Terra Station data
    Updated 2022-05-07
    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"},{"datetime":1564239600000,"value":"11616"},{"datetime":1564326000000,"value":"15557"},{"datetime":156441
    )
    as json_data
    ),
    terra_station as (
    select
    value:datetime,
    to_timestamp(value:datetime::integer/1e3) as time,
    value:value::float as value
    from json,
    lateral flatten (input => json_data)
    )
    select * from terra_station order by time desc
    Run a query to Download Data