Skip to content
Dune Analytics

@Brecht / Loopring Exchange Balance

Loopring Exchange Balance

Loading
 

About queries and results

Dune Analytics lets you explore, create, and share Ethereum analytics. You can find an endless amount of great queries and dashboards on Dune.

We have decoded Ethereum smart contract data so you can do powerful analysis with simple SQL queries and visualise the query results into beautiful graphs.

Dune Analytics is free for everyone forever. If you want extra features like private queries, export your results and more check out our Pro plan.

SQL query

1WITH token_prices AS (
2    SELECT day::date as day, 'KEEP' AS "symbol", 0.93 as price
3    FROM generate_series('20200215', now(), INTERVAL '1 day') day
4    UNION
5    SELECT day::date as day, 'DXD' AS "symbol", 424 as price
6    FROM generate_series('20200215', now(), INTERVAL '1 day') day
7    UNION
8    SELECT day::date as day, 'TRB' AS "symbol", 67 as price
9    FROM generate_series('20200215', now(), INTERVAL '1 day') day
10    UNION
11    SELECT day::date as day, 'BZRX' AS "symbol", 1.36 as price
12    FROM generate_series('20200215', now(), INTERVAL '1 day') day
13    UNION
14    SELECT day::date as day, 'TON' AS "symbol", 0.012 as price
15    FROM generate_series('20200215', now(), INTERVAL '1 day') day
16    UNION
17    SELECT day::date as day, 'QCAD' AS "symbol", 0.75 as price
18    FROM generate_series('20200215', now(), INTERVAL '1 day') day
19    UNION
20    SELECT day::date as day, 'ADX' AS "symbol", 0.14 as price
21    FROM generate_series('20200215', now(), INTERVAL '1 day') day
22    UNION
23    SELECT day::date as day, 'NIOX' AS "symbol", 0.014 as price
24    FROM generate_series('20200215', now(), INTERVAL '1 day') day
25    UNION...

SQL query results

Loading