PREVIEW / futures_1hour / 2018-12-30
file: by_date/futures_1hour/2018/2018-12-30.parquet size: 15 KB rows: 293
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 |
|---|---|---|---|---|---|---|---|
| 2018-12-30 18:00:00 | ES | Futures | 2710.96 | 2724.26 | 2710.96 | 2716.66 | 13145.0 |
| 2018-12-30 19:00:00 | ES | Futures | 2716.39 | 2721.01 | 2714.22 | 2719.65 | 5526.0 |
| 2018-12-30 20:00:00 | ES | Futures | 2719.38 | 2719.92 | 2713.67 | 2716.93 | 6436.0 |
| 2018-12-30 21:00:00 | ES | Futures | 2716.93 | 2723.45 | 2715.03 | 2721.55 | 6544.0 |
| 2018-12-30 22:00:00 | ES | Futures | 2721.55 | 2725.62 | 2717.2 | 2718.02 | 6686.0 |
| 2018-12-30 23:00:00 | ES | Futures | 2718.02 | 2720.19 | 2716.39 | 2718.02 | 5905.0 |
| 2018-12-30 18:00:00 | NQ | Futures | 7377.49 | 7429.21 | 7376.61 | 7413.14 | 6324.0 |
| 2018-12-30 19:00:00 | NQ | Futures | 7412.55 | 7424.82 | 7407.0 | 7421.61 | 2508.0 |
| 2018-12-30 20:00:00 | NQ | Futures | 7421.32 | 7423.65 | 7404.08 | 7411.38 | 2851.0 |
| 2018-12-30 21:00:00 | NQ | Futures | 7411.97 | 7428.62 | 7404.95 | 7423.65 | 3150.0 |
| 2018-12-30 22:00:00 | NQ | Futures | 7424.24 | 7435.63 | 7414.01 | 7416.06 | 3195.0 |
| 2018-12-30 23:00:00 | NQ | Futures | 7416.93 | 7424.82 | 7413.72 | 7416.64 | 2725.0 |
| 2018-12-30 18:00:00 | YM | Futures | 25116.7 | 25234.0 | 25104.8 | 25161.3 | 2922.0 |
| 2018-12-30 19:00:00 | YM | Futures | 25164.5 | 25214.5 | 25143.9 | 25204.7 | 1678.0 |
| 2018-12-30 20:00:00 | YM | Futures | 25201.4 | 25210.1 | 25150.4 | 25179.7 | 1948.0 |
| 2018-12-30 21:00:00 | YM | Futures | 25179.7 | 25247.0 | 25161.3 | 25229.7 | 2246.0 |
| 2018-12-30 22:00:00 | YM | Futures | 25230.7 | 25261.1 | 25190.6 | 25199.3 | 2072.0 |
| 2018-12-30 23:00:00 | YM | Futures | 25199.3 | 25218.8 | 25180.8 | 25199.3 | 1763.0 |
| 2018-12-30 18:00:00 | CL | Futures | 41.28 | 41.63 | 41.28 | 41.53 | 3848.0 |
| 2018-12-30 19:00:00 | CL | Futures | 41.52 | 41.6 | 41.49 | 41.59 | 2473.0 |
| 2018-12-30 20:00:00 | CL | Futures | 41.59 | 41.6 | 41.39 | 41.47 | 3643.0 |
| 2018-12-30 21:00:00 | CL | Futures | 41.47 | 41.85 | 41.45 | 41.78 | 7175.0 |
| 2018-12-30 22:00:00 | CL | Futures | 41.77 | 41.91 | 41.7 | 41.74 | 7059.0 |
| 2018-12-30 23:00:00 | CL | Futures | 41.74 | 41.9 | 41.73 | 41.84 | 4517.0 |
| 2018-12-30 18:00:00 | GC | Futures | 1662.1 | 1662.7 | 1659.7 | 1660.9 | 1692.0 |
| 2018-12-30 19:00:00 | GC | Futures | 1660.8 | 1661.9 | 1660.1 | 1660.1 | 1589.0 |
| 2018-12-30 20:00:00 | GC | Futures | 1660.1 | 1660.9 | 1659.1 | 1659.3 | 2116.0 |
| 2018-12-30 21:00:00 | GC | Futures | 1659.3 | 1660.1 | 1658.7 | 1658.7 | 1805.0 |
| 2018-12-30 22:00:00 | GC | Futures | 1658.6 | 1659.5 | 1657.8 | 1657.9 | 2536.0 |
| 2018-12-30 23:00:00 | GC | Futures | 1658.0 | 1659.1 | 1657.8 | 1658.7 | 1420.0 |
| 2018-12-30 18:00:00 | ZN | Futures | 122.572837 | 122.572837 | 122.478392 | 122.525614 | 8908.0 |
| 2018-12-30 19:00:00 | ZN | Futures | 122.509874 | 122.541355 | 122.494133 | 122.541355 | 2663.0 |
| 2018-12-30 20:00:00 | ZN | Futures | 122.525614 | 122.572837 | 122.509874 | 122.557096 | 4102.0 |
| 2018-12-30 21:00:00 | ZN | Futures | 122.557096 | 122.588577 | 122.541355 | 122.588577 | 3443.0 |
| 2018-12-30 22:00:00 | ZN | Futures | 122.572837 | 122.620059 | 122.572837 | 122.604318 | 3993.0 |
| 2018-12-30 23:00:00 | ZN | Futures | 122.604318 | 122.620059 | 122.604318 | 122.604318 | 1325.0 |
> showing 36 of 293 rows — these rows as CSV