PREVIEW / futures_1hour / 2017-03-12
file: by_date/futures_1hour/2017/2017-03-12.parquet size: 14 KB rows: 279
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-03-12 18:00:00 | ES | Futures | 2586.67 | 2588.58 | 2585.03 | 2586.12 | 3377.0 |
| 2017-03-12 19:00:00 | ES | Futures | 2585.85 | 2586.12 | 2583.67 | 2584.21 | 1035.0 |
| 2017-03-12 20:00:00 | ES | Futures | 2584.49 | 2585.85 | 2584.21 | 2585.3 | 1335.0 |
| 2017-03-12 21:00:00 | ES | Futures | 2585.3 | 2586.94 | 2585.03 | 2585.3 | 1902.0 |
| 2017-03-12 22:00:00 | ES | Futures | 2585.3 | 2586.67 | 2585.3 | 2586.4 | 823.0 |
| 2017-03-12 23:00:00 | ES | Futures | 2586.67 | 2586.67 | 2585.58 | 2586.12 | 660.0 |
| 2017-03-12 18:00:00 | NQ | Futures | 6421.04 | 6423.42 | 6414.77 | 6417.46 | 202.0 |
| 2017-03-12 19:00:00 | NQ | Futures | 6416.86 | 6416.86 | 6410.0 | 6412.09 | 317.0 |
| 2017-03-12 20:00:00 | NQ | Futures | 6412.09 | 6416.86 | 6411.79 | 6414.77 | 385.0 |
| 2017-03-12 21:00:00 | NQ | Futures | 6414.77 | 6419.25 | 6413.88 | 6414.17 | 240.0 |
| 2017-03-12 22:00:00 | NQ | Futures | 6414.77 | 6419.54 | 6414.47 | 6418.95 | 207.0 |
| 2017-03-12 23:00:00 | NQ | Futures | 6419.84 | 6420.14 | 6418.35 | 6419.54 | 122.0 |
| 2017-03-12 18:00:00 | YM | Futures | 22661.8 | 22670.5 | 22645.5 | 22654.2 | 1117.0 |
| 2017-03-12 19:00:00 | YM | Futures | 22654.2 | 22654.2 | 22634.6 | 22643.3 | 618.0 |
| 2017-03-12 20:00:00 | YM | Futures | 22643.3 | 22656.3 | 22640.0 | 22653.1 | 760.0 |
| 2017-03-12 21:00:00 | YM | Futures | 22652.0 | 22671.6 | 22649.8 | 22649.8 | 1748.0 |
| 2017-03-12 22:00:00 | YM | Futures | 22652.0 | 22667.2 | 22649.8 | 22666.1 | 795.0 |
| 2017-03-12 23:00:00 | YM | Futures | 22666.1 | 22666.1 | 22658.5 | 22660.7 | 423.0 |
| 2017-03-12 18:00:00 | CL | Futures | 45.52 | 45.61 | 45.22 | 45.27 | 6607.0 |
| 2017-03-12 19:00:00 | CL | Futures | 45.26 | 45.29 | 45.01 | 45.14 | 9718.0 |
| 2017-03-12 20:00:00 | CL | Futures | 45.14 | 45.18 | 45.05 | 45.16 | 6503.0 |
| 2017-03-12 21:00:00 | CL | Futures | 45.17 | 45.31 | 45.15 | 45.21 | 7112.0 |
| 2017-03-12 22:00:00 | CL | Futures | 45.2 | 45.24 | 45.07 | 45.18 | 4607.0 |
| 2017-03-12 23:00:00 | CL | Futures | 45.17 | 45.22 | 45.15 | 45.18 | 3056.0 |
| 2017-03-12 18:00:00 | GC | Futures | 1622.8 | 1625.3 | 1622.0 | 1623.6 | 2991.0 |
| 2017-03-12 19:00:00 | GC | Futures | 1623.7 | 1625.5 | 1622.9 | 1623.9 | 2457.0 |
| 2017-03-12 20:00:00 | GC | Futures | 1623.9 | 1624.1 | 1622.2 | 1622.2 | 2413.0 |
| 2017-03-12 21:00:00 | GC | Futures | 1622.2 | 1622.9 | 1620.9 | 1622.9 | 6390.0 |
| 2017-03-12 22:00:00 | GC | Futures | 1622.9 | 1624.4 | 1621.4 | 1624.0 | 3936.0 |
| 2017-03-12 23:00:00 | GC | Futures | 1624.0 | 1625.2 | 1623.9 | 1624.3 | 2579.0 |
| 2017-03-12 18:00:00 | ZN | Futures | 122.07489 | 122.105889 | 122.043891 | 122.043891 | 6841.0 |
| 2017-03-12 19:00:00 | ZN | Futures | 122.05939 | 122.07489 | 121.966393 | 121.981892 | 4984.0 |
| 2017-03-12 20:00:00 | ZN | Futures | 121.981892 | 121.997392 | 121.950893 | 121.981892 | 7967.0 |
| 2017-03-12 21:00:00 | ZN | Futures | 121.966393 | 122.028391 | 121.950893 | 122.012892 | 9677.0 |
| 2017-03-12 22:00:00 | ZN | Futures | 122.012892 | 122.028391 | 121.981892 | 121.997392 | 4618.0 |
| 2017-03-12 23:00:00 | ZN | Futures | 122.012892 | 122.043891 | 122.012892 | 122.012892 | 3978.0 |
> showing 36 of 279 rows — these rows as CSV