PREVIEW / futures_1hour / 2018-06-03
file: by_date/futures_1hour/2018/2018-06-03.parquet size: 15 KB rows: 298
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-06-03 18:00:00 | ES | Futures | 2981.25 | 2983.43 | 2979.06 | 2979.34 | 6874.0 |
| 2018-06-03 19:00:00 | ES | Futures | 2979.61 | 2984.52 | 2979.06 | 2984.52 | 3701.0 |
| 2018-06-03 20:00:00 | ES | Futures | 2984.52 | 2987.52 | 2983.7 | 2986.98 | 9628.0 |
| 2018-06-03 21:00:00 | ES | Futures | 2986.98 | 2989.16 | 2986.16 | 2988.89 | 6409.0 |
| 2018-06-03 22:00:00 | ES | Futures | 2988.89 | 2990.8 | 2988.34 | 2988.62 | 5155.0 |
| 2018-06-03 23:00:00 | ES | Futures | 2988.62 | 2989.71 | 2987.25 | 2987.8 | 3316.0 |
| 2018-06-03 18:00:00 | NQ | Futures | 8369.17 | 8371.83 | 8359.72 | 8363.26 | 1852.0 |
| 2018-06-03 19:00:00 | NQ | Futures | 8363.56 | 8379.22 | 8360.9 | 8378.34 | 1269.0 |
| 2018-06-03 20:00:00 | NQ | Futures | 8378.63 | 8386.61 | 8375.97 | 8386.02 | 2508.0 |
| 2018-06-03 21:00:00 | NQ | Futures | 8385.72 | 8399.02 | 8383.66 | 8398.14 | 3710.0 |
| 2018-06-03 22:00:00 | NQ | Futures | 8398.14 | 8404.93 | 8395.77 | 8395.77 | 1981.0 |
| 2018-06-03 23:00:00 | NQ | Futures | 8396.66 | 8401.98 | 8394.59 | 8395.18 | 1353.0 |
| 2018-06-03 18:00:00 | YM | Futures | 26736.8 | 26744.4 | 26684.7 | 26706.4 | 1200.0 |
| 2018-06-03 19:00:00 | YM | Futures | 26706.4 | 26753.1 | 26702.1 | 26750.9 | 658.0 |
| 2018-06-03 20:00:00 | YM | Futures | 26752.0 | 26785.7 | 26744.4 | 26785.7 | 2072.0 |
| 2018-06-03 21:00:00 | YM | Futures | 26783.5 | 26810.7 | 26775.9 | 26808.5 | 2107.0 |
| 2018-06-03 22:00:00 | YM | Futures | 26808.5 | 26828.0 | 26804.1 | 26804.1 | 1721.0 |
| 2018-06-03 23:00:00 | YM | Futures | 26806.3 | 26819.3 | 26799.8 | 26803.1 | 897.0 |
| 2018-06-03 18:00:00 | CL | Futures | 58.76 | 58.82 | 58.63 | 58.69 | 4742.0 |
| 2018-06-03 19:00:00 | CL | Futures | 58.69 | 58.82 | 58.68 | 58.8 | 1892.0 |
| 2018-06-03 20:00:00 | CL | Futures | 58.81 | 58.93 | 58.79 | 58.85 | 6264.0 |
| 2018-06-03 21:00:00 | CL | Futures | 58.85 | 58.96 | 58.82 | 58.9 | 5622.0 |
| 2018-06-03 22:00:00 | CL | Futures | 58.9 | 58.93 | 58.74 | 58.79 | 6316.0 |
| 2018-06-03 23:00:00 | CL | Futures | 58.79 | 58.86 | 58.76 | 58.79 | 3767.0 |
| 2018-06-03 18:00:00 | GC | Futures | 1702.6 | 1704.3 | 1702.1 | 1703.5 | 1396.0 |
| 2018-06-03 19:00:00 | GC | Futures | 1703.5 | 1705.1 | 1702.3 | 1702.7 | 2506.0 |
| 2018-06-03 20:00:00 | GC | Futures | 1702.6 | 1704.2 | 1701.3 | 1703.0 | 5663.0 |
| 2018-06-03 21:00:00 | GC | Futures | 1703.0 | 1704.3 | 1702.6 | 1703.4 | 5280.0 |
| 2018-06-03 22:00:00 | GC | Futures | 1703.2 | 1703.6 | 1702.6 | 1702.7 | 3924.0 |
| 2018-06-03 23:00:00 | GC | Futures | 1702.7 | 1704.0 | 1702.7 | 1703.6 | 2550.0 |
| 2018-06-03 18:00:00 | ZN | Futures | 120.494685 | 120.526031 | 120.479012 | 120.510358 | 31.0 |
| 2018-06-03 19:00:00 | ZN | Futures | 120.526031 | 120.526031 | 120.479012 | 120.479012 | 74.0 |
| 2018-06-03 20:00:00 | ZN | Futures | 120.400647 | 120.431993 | 120.337954 | 120.337954 | 519.0 |
| 2018-06-03 21:00:00 | ZN | Futures | 120.337954 | 120.384973 | 120.337954 | 120.3693 | 1119.0 |
| 2018-06-03 22:00:00 | ZN | Futures | 120.3693 | 120.3693 | 120.337954 | 120.337954 | 250.0 |
| 2018-06-03 23:00:00 | ZN | Futures | 120.384973 | 120.431993 | 120.384973 | 120.400647 | 521.0 |
> showing 36 of 298 rows — these rows as CSV