PREVIEW / futures_1hour / 2018-09-16
file: by_date/futures_1hour/2018/2018-09-16.parquet size: 14 KB rows: 289
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-09-16 18:00:00 | ES | Futures | 3164.97 | 3164.97 | 3159.53 | 3161.44 | 10339.0 |
| 2018-09-16 19:00:00 | ES | Futures | 3161.16 | 3162.8 | 3160.89 | 3161.44 | 3089.0 |
| 2018-09-16 20:00:00 | ES | Futures | 3161.16 | 3162.25 | 3159.53 | 3161.44 | 4258.0 |
| 2018-09-16 21:00:00 | ES | Futures | 3161.44 | 3163.88 | 3160.89 | 3161.98 | 5321.0 |
| 2018-09-16 22:00:00 | ES | Futures | 3161.98 | 3162.8 | 3160.62 | 3162.8 | 4316.0 |
| 2018-09-16 23:00:00 | ES | Futures | 3162.8 | 3162.8 | 3161.16 | 3162.52 | 1995.0 |
| 2018-09-16 18:00:00 | NQ | Futures | 8877.15 | 8877.45 | 8859.85 | 8866.3 | 2359.0 |
| 2018-09-16 19:00:00 | NQ | Futures | 8866.3 | 8874.51 | 8866.01 | 8866.01 | 1621.0 |
| 2018-09-16 20:00:00 | NQ | Futures | 8866.01 | 8870.41 | 8860.14 | 8865.71 | 1889.0 |
| 2018-09-16 21:00:00 | NQ | Futures | 8865.71 | 8876.27 | 8864.25 | 8866.89 | 2740.0 |
| 2018-09-16 22:00:00 | NQ | Futures | 8866.59 | 8875.98 | 8862.19 | 8874.51 | 2959.0 |
| 2018-09-16 23:00:00 | NQ | Futures | 8874.51 | 8874.81 | 8865.42 | 8872.75 | 1459.0 |
| 2018-09-16 18:00:00 | YM | Futures | 28454.7 | 28454.7 | 28386.2 | 28405.8 | 1642.0 |
| 2018-09-16 19:00:00 | YM | Futures | 28405.8 | 28419.9 | 28401.4 | 28403.6 | 681.0 |
| 2018-09-16 20:00:00 | YM | Futures | 28402.5 | 28411.2 | 28391.7 | 28410.1 | 906.0 |
| 2018-09-16 21:00:00 | YM | Futures | 28410.1 | 28427.5 | 28400.3 | 28406.9 | 1479.0 |
| 2018-09-16 22:00:00 | YM | Futures | 28405.8 | 28415.6 | 28393.8 | 28414.5 | 970.0 |
| 2018-09-16 23:00:00 | YM | Futures | 28415.6 | 28415.6 | 28400.3 | 28414.5 | 543.0 |
| 2018-09-16 18:00:00 | CL | Futures | 63.29 | 63.42 | 63.21 | 63.24 | 663.0 |
| 2018-09-16 19:00:00 | CL | Futures | 63.23 | 63.24 | 63.16 | 63.16 | 317.0 |
| 2018-09-16 20:00:00 | CL | Futures | 63.16 | 63.26 | 63.13 | 63.25 | 511.0 |
| 2018-09-16 21:00:00 | CL | Futures | 63.25 | 63.31 | 63.17 | 63.3 | 832.0 |
| 2018-09-16 22:00:00 | CL | Futures | 63.31 | 63.34 | 63.24 | 63.34 | 492.0 |
| 2018-09-16 23:00:00 | CL | Futures | 63.34 | 63.36 | 63.27 | 63.3 | 371.0 |
| 2018-09-16 18:00:00 | GC | Futures | 1563.2 | 1563.2 | 1560.7 | 1562.1 | 1728.0 |
| 2018-09-16 19:00:00 | GC | Futures | 1562.0 | 1562.4 | 1560.4 | 1561.1 | 2465.0 |
| 2018-09-16 20:00:00 | GC | Futures | 1561.1 | 1561.7 | 1560.2 | 1561.5 | 4242.0 |
| 2018-09-16 21:00:00 | GC | Futures | 1561.5 | 1563.4 | 1561.5 | 1562.0 | 10039.0 |
| 2018-09-16 22:00:00 | GC | Futures | 1561.9 | 1563.3 | 1561.2 | 1563.2 | 4663.0 |
| 2018-09-16 23:00:00 | GC | Futures | 1563.3 | 1564.1 | 1562.8 | 1563.2 | 3822.0 |
| 2018-09-16 18:00:00 | ZN | Futures | 120.023063 | 120.038801 | 119.991585 | 119.991585 | 8417.0 |
| 2018-09-16 19:00:00 | ZN | Futures | 120.007324 | 120.007324 | 119.991585 | 120.007324 | 5841.0 |
| 2018-09-16 20:00:00 | ZN | Futures | 120.007324 | 120.007324 | 119.975847 | 119.991585 | 8907.0 |
| 2018-09-16 21:00:00 | ZN | Futures | 119.975847 | 120.038801 | 119.975847 | 120.038801 | 8851.0 |
| 2018-09-16 22:00:00 | ZN | Futures | 120.023063 | 120.101756 | 120.023063 | 120.070279 | 14765.0 |
| 2018-09-16 23:00:00 | ZN | Futures | 120.070279 | 120.086017 | 120.05454 | 120.070279 | 2393.0 |
> showing 36 of 289 rows — these rows as CSV