PREVIEW / futures_1hour / 2017-01-02
file: by_date/futures_1hour/2017/2017-01-02.parquet size: 21 KB rows: 521
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2017-01-02 18:00:00 | ES | Futures | 2444.83 | 2449.47 | 2444.83 | 2447.28 | 15014.0 |
| 2017-01-02 19:00:00 | ES | Futures | 2447.28 | 2447.56 | 2444.28 | 2445.1 | 8728.0 |
| 2017-01-02 20:00:00 | ES | Futures | 2445.1 | 2447.28 | 2444.28 | 2446.74 | 4985.0 |
| 2017-01-02 21:00:00 | ES | Futures | 2446.74 | 2448.37 | 2446.19 | 2447.83 | 3598.0 |
| 2017-01-02 22:00:00 | ES | Futures | 2448.1 | 2449.47 | 2447.83 | 2448.92 | 1893.0 |
| 2017-01-02 23:00:00 | ES | Futures | 2449.19 | 2449.47 | 2448.37 | 2449.19 | 2616.0 |
| 2017-01-02 18:00:00 | NQ | Futures | 5819.32 | 5838.12 | 5819.32 | 5832.75 | 2652.0 |
| 2017-01-02 19:00:00 | NQ | Futures | 5833.05 | 5833.35 | 5823.5 | 5824.99 | 2127.0 |
| 2017-01-02 20:00:00 | NQ | Futures | 5824.99 | 5831.26 | 5820.82 | 5829.47 | 1074.0 |
| 2017-01-02 21:00:00 | NQ | Futures | 5829.77 | 5835.73 | 5828.87 | 5833.35 | 803.0 |
| 2017-01-02 22:00:00 | NQ | Futures | 5833.64 | 5836.03 | 5831.56 | 5835.43 | 421.0 |
| 2017-01-02 23:00:00 | NQ | Futures | 5835.73 | 5836.63 | 5833.05 | 5836.03 | 468.0 |
| 2017-01-02 18:00:00 | YM | Futures | 21431.7 | 21478.4 | 21431.7 | 21455.6 | 2493.0 |
| 2017-01-02 19:00:00 | YM | Futures | 21456.7 | 21458.8 | 21439.3 | 21444.7 | 1899.0 |
| 2017-01-02 20:00:00 | YM | Futures | 21444.7 | 21466.4 | 21439.3 | 21463.2 | 1479.0 |
| 2017-01-02 21:00:00 | YM | Futures | 21463.2 | 21472.9 | 21458.8 | 21470.8 | 841.0 |
| 2017-01-02 22:00:00 | YM | Futures | 21470.8 | 21478.4 | 21467.5 | 21477.3 | 558.0 |
| 2017-01-02 23:00:00 | YM | Futures | 21478.4 | 21478.4 | 21469.7 | 21475.1 | 782.0 |
| 2017-01-02 18:00:00 | CL | Futures | 52.14 | 52.14 | 51.95 | 51.97 | 3960.0 |
| 2017-01-02 19:00:00 | CL | Futures | 51.97 | 52.04 | 51.9 | 51.97 | 2602.0 |
| 2017-01-02 20:00:00 | CL | Futures | 51.97 | 52.11 | 51.93 | 51.99 | 4901.0 |
| 2017-01-02 21:00:00 | CL | Futures | 51.99 | 52.04 | 51.97 | 52.01 | 1983.0 |
| 2017-01-02 22:00:00 | CL | Futures | 52.02 | 52.03 | 51.91 | 52.0 | 1785.0 |
| 2017-01-02 23:00:00 | CL | Futures | 51.99 | 52.02 | 51.97 | 52.01 | 805.0 |
| 2017-01-02 18:00:00 | GC | Futures | 1554.1 | 1556.8 | 1552.3 | 1553.7 | 3182.0 |
| 2017-01-02 19:00:00 | GC | Futures | 1553.6 | 1555.4 | 1552.6 | 1554.1 | 3128.0 |
| 2017-01-02 20:00:00 | GC | Futures | 1554.2 | 1562.3 | 1553.7 | 1561.4 | 8756.0 |
| 2017-01-02 21:00:00 | GC | Futures | 1561.4 | 1564.9 | 1559.8 | 1562.6 | 6613.0 |
| 2017-01-02 22:00:00 | GC | Futures | 1562.6 | 1562.9 | 1561.0 | 1562.3 | 2167.0 |
| 2017-01-02 23:00:00 | GC | Futures | 1562.2 | 1563.1 | 1562.1 | 1563.0 | 1387.0 |
| 2017-01-02 18:00:00 | ZN | Futures | 122.508651 | 122.508651 | 122.323592 | 122.431543 | 17992.0 |
| 2017-01-02 19:00:00 | ZN | Futures | 122.431543 | 122.477808 | 122.416121 | 122.462386 | 6352.0 |
| 2017-01-02 20:00:00 | ZN | Futures | 122.462386 | 122.493229 | 122.416121 | 122.477808 | 7433.0 |
| 2017-01-02 21:00:00 | ZN | Futures | 122.477808 | 122.554915 | 122.446965 | 122.493229 | 5896.0 |
| 2017-01-02 22:00:00 | ZN | Futures | 122.493229 | 122.508651 | 122.462386 | 122.508651 | 1778.0 |
| 2017-01-02 23:00:00 | ZN | Futures | 122.508651 | 122.554915 | 122.493229 | 122.539494 | 2498.0 |
> showing 36 of 521 rows — these rows as CSV