lidofor Daily comparison of amounts
Updated 2025-02-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
CONVERT_TIMEZONE('UTC',time) as time, amount, eth_balance
FROM (
SELECT
value[0]::date AS time,
value[1]::real AS amount,
value[2]::real AS eth_balance
FROM (
SELECT
livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/bfb8b722-842d-40ef-8643-852ce84cc365/latest-run') as response
), lateral FLATTEN (input => response:data:result:rows)
WHERE time >= '2025-02-05') -- change date here
QueryRunArchived: QueryRun has been archived