PREVIEW / futures_1hour / 2019-12-15
file: by_date/futures_1hour/2019/2019-12-15.parquet size: 16 KB rows: 337
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 |
|---|---|---|---|---|---|---|---|
| 2019-12-15 18:00:00 | ES | Futures | 3446.5 | 3447.5 | 3443.7 | 3445.4 | 8538.0 |
| 2019-12-15 19:00:00 | ES | Futures | 3445.4 | 3448.1 | 3445.1 | 3447.0 | 5839.0 |
| 2019-12-15 20:00:00 | ES | Futures | 3447.0 | 3449.7 | 3446.7 | 3449.2 | 7772.0 |
| 2019-12-15 21:00:00 | ES | Futures | 3449.2 | 3451.9 | 3449.2 | 3450.5 | 8996.0 |
| 2019-12-15 22:00:00 | ES | Futures | 3450.5 | 3452.1 | 3450.2 | 3451.1 | 3278.0 |
| 2019-12-15 23:00:00 | ES | Futures | 3451.3 | 3452.4 | 3451.1 | 3451.3 | 1735.0 |
| 2019-12-15 18:00:00 | NQ | Futures | 9871.22 | 9878.16 | 9866.59 | 9872.95 | 3275.0 |
| 2019-12-15 19:00:00 | NQ | Futures | 9872.95 | 9881.34 | 9872.66 | 9878.45 | 2726.0 |
| 2019-12-15 20:00:00 | NQ | Futures | 9878.74 | 9883.94 | 9876.42 | 9881.92 | 3315.0 |
| 2019-12-15 21:00:00 | NQ | Futures | 9882.21 | 9889.73 | 9882.21 | 9883.36 | 3564.0 |
| 2019-12-15 22:00:00 | NQ | Futures | 9883.36 | 9888.86 | 9882.79 | 9886.83 | 1360.0 |
| 2019-12-15 23:00:00 | NQ | Futures | 9886.83 | 9888.86 | 9885.1 | 9885.97 | 794.0 |
| 2019-12-15 18:00:00 | YM | Futures | 30689.5 | 30702.5 | 30663.3 | 30673.1 | 2821.0 |
| 2019-12-15 19:00:00 | YM | Futures | 30673.1 | 30693.8 | 30672.1 | 30684.0 | 1580.0 |
| 2019-12-15 20:00:00 | YM | Futures | 30685.1 | 30691.6 | 30671.0 | 30678.6 | 2301.0 |
| 2019-12-15 21:00:00 | YM | Futures | 30679.7 | 30690.6 | 30671.0 | 30677.5 | 2155.0 |
| 2019-12-15 22:00:00 | YM | Futures | 30677.5 | 30688.4 | 30674.2 | 30681.9 | 859.0 |
| 2019-12-15 23:00:00 | YM | Futures | 30682.9 | 30686.2 | 30675.3 | 30678.6 | 689.0 |
| 2019-12-15 18:00:00 | CL | Futures | 53.01 | 53.02 | 52.83 | 52.88 | 1462.0 |
| 2019-12-15 19:00:00 | CL | Futures | 52.88 | 52.96 | 52.87 | 52.96 | 576.0 |
| 2019-12-15 20:00:00 | CL | Futures | 52.96 | 53.0 | 52.91 | 52.95 | 1531.0 |
| 2019-12-15 21:00:00 | CL | Futures | 52.96 | 52.98 | 52.93 | 52.94 | 723.0 |
| 2019-12-15 22:00:00 | CL | Futures | 52.93 | 52.96 | 52.93 | 52.94 | 450.0 |
| 2019-12-15 23:00:00 | CL | Futures | 52.93 | 52.97 | 52.92 | 52.95 | 396.0 |
| 2019-12-15 18:00:00 | GC | Futures | 1866.0 | 1867.0 | 1863.6 | 1864.0 | 2717.0 |
| 2019-12-15 19:00:00 | GC | Futures | 1864.1 | 1864.9 | 1863.6 | 1864.4 | 2614.0 |
| 2019-12-15 20:00:00 | GC | Futures | 1864.4 | 1864.9 | 1862.7 | 1864.4 | 4509.0 |
| 2019-12-15 21:00:00 | GC | Futures | 1864.3 | 1865.4 | 1864.0 | 1865.3 | 3317.0 |
| 2019-12-15 22:00:00 | GC | Futures | 1865.1 | 1865.6 | 1864.3 | 1864.9 | 1965.0 |
| 2019-12-15 23:00:00 | GC | Futures | 1864.8 | 1865.3 | 1864.6 | 1865.3 | 1212.0 |
| 2019-12-15 18:00:00 | ZN | Futures | 129.04456 | 129.091491 | 129.028916 | 129.060204 | 15357.0 |
| 2019-12-15 19:00:00 | ZN | Futures | 129.075847 | 129.091491 | 129.013273 | 129.028916 | 18047.0 |
| 2019-12-15 20:00:00 | ZN | Futures | 129.04456 | 129.04456 | 128.997629 | 128.997629 | 11343.0 |
| 2019-12-15 21:00:00 | ZN | Futures | 128.997629 | 129.013273 | 128.966342 | 128.997629 | 14271.0 |
| 2019-12-15 22:00:00 | ZN | Futures | 128.981985 | 129.013273 | 128.981985 | 129.013273 | 7048.0 |
| 2019-12-15 23:00:00 | ZN | Futures | 128.997629 | 129.04456 | 128.981985 | 129.028916 | 4976.0 |
> showing 36 of 337 rows — these rows as CSV