PREVIEW / futures_1hour / 2013-03-03
file: by_date/futures_1hour/2013/2013-03-03.parquet size: 14 KB rows: 264
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 |
|---|---|---|---|---|---|---|---|
| 2013-03-03 18:00:00 | ES | Futures | 1554.69 | 1555.46 | 1553.66 | 1554.43 | 6969.0 |
| 2013-03-03 19:00:00 | ES | Futures | 1554.43 | 1555.2 | 1553.15 | 1553.4 | 8502.0 |
| 2013-03-03 20:00:00 | ES | Futures | 1553.15 | 1553.92 | 1551.86 | 1552.38 | 6900.0 |
| 2013-03-03 21:00:00 | ES | Futures | 1552.38 | 1552.38 | 1550.58 | 1550.84 | 5790.0 |
| 2013-03-03 22:00:00 | ES | Futures | 1551.09 | 1551.35 | 1550.32 | 1551.09 | 4316.0 |
| 2013-03-03 23:00:00 | ES | Futures | 1551.09 | 1551.09 | 1547.5 | 1547.5 | 9899.0 |
| 2013-03-03 18:00:00 | NQ | Futures | 3196.52 | 3197.39 | 3194.77 | 3196.23 | 608.0 |
| 2013-03-03 19:00:00 | NQ | Futures | 3195.94 | 3197.39 | 3193.61 | 3193.9 | 648.0 |
| 2013-03-03 20:00:00 | NQ | Futures | 3194.19 | 3194.77 | 3191.28 | 3192.15 | 482.0 |
| 2013-03-03 21:00:00 | NQ | Futures | 3191.86 | 3191.86 | 3188.66 | 3189.24 | 342.0 |
| 2013-03-03 22:00:00 | NQ | Futures | 3189.24 | 3190.41 | 3188.37 | 3190.12 | 385.0 |
| 2013-03-03 23:00:00 | NQ | Futures | 3189.83 | 3189.83 | 3183.13 | 3183.13 | 646.0 |
| 2013-03-03 18:00:00 | YM | Futures | 14142.7 | 14149.7 | 14136.7 | 14143.7 | 534.0 |
| 2013-03-03 19:00:00 | YM | Futures | 14143.7 | 14148.7 | 14137.7 | 14138.7 | 745.0 |
| 2013-03-03 20:00:00 | YM | Futures | 14138.7 | 14141.7 | 14126.6 | 14128.6 | 684.0 |
| 2013-03-03 21:00:00 | YM | Futures | 14128.6 | 14128.6 | 14115.5 | 14119.6 | 503.0 |
| 2013-03-03 22:00:00 | YM | Futures | 14120.6 | 14123.6 | 14115.5 | 14117.5 | 561.0 |
| 2013-03-03 23:00:00 | YM | Futures | 14117.5 | 14117.5 | 14091.4 | 14091.4 | 659.0 |
| 2013-03-03 18:00:00 | CL | Futures | 144.12 | 144.41 | 143.82 | 143.92 | 1612.0 |
| 2013-03-03 19:00:00 | CL | Futures | 143.93 | 143.98 | 143.87 | 143.98 | 867.0 |
| 2013-03-03 20:00:00 | CL | Futures | 144.0 | 144.11 | 143.95 | 143.96 | 951.0 |
| 2013-03-03 21:00:00 | CL | Futures | 143.98 | 144.0 | 143.81 | 143.82 | 724.0 |
| 2013-03-03 22:00:00 | CL | Futures | 143.82 | 143.95 | 143.6 | 143.84 | 1097.0 |
| 2013-03-03 23:00:00 | CL | Futures | 143.85 | 143.9 | 143.57 | 143.57 | 643.0 |
| 2013-03-03 18:00:00 | GC | Futures | 2170.0 | 2175.1 | 2169.6 | 2170.6 | 2462.0 |
| 2013-03-03 19:00:00 | GC | Futures | 2170.7 | 2174.4 | 2169.9 | 2174.2 | 2160.0 |
| 2013-03-03 20:00:00 | GC | Futures | 2174.3 | 2178.7 | 2173.3 | 2175.3 | 4058.0 |
| 2013-03-03 21:00:00 | GC | Futures | 2175.4 | 2175.5 | 2169.9 | 2170.2 | 3331.0 |
| 2013-03-03 22:00:00 | GC | Futures | 2170.3 | 2170.6 | 2167.6 | 2168.0 | 2856.0 |
| 2013-03-03 23:00:00 | GC | Futures | 2168.1 | 2169.8 | 2166.7 | 2167.3 | 1781.0 |
| 2013-03-03 18:00:00 | ZN | Futures | 118.421387 | 118.435296 | 118.37966 | 118.407478 | 38.0 |
| 2013-03-03 19:00:00 | ZN | Futures | 118.407478 | 118.407478 | 118.337933 | 118.351842 | 671.0 |
| 2013-03-03 20:00:00 | ZN | Futures | 118.351842 | 118.393569 | 118.351842 | 118.393569 | 91.0 |
| 2013-03-03 21:00:00 | ZN | Futures | 118.393569 | 118.393569 | 118.393569 | 118.393569 | 1.0 |
| 2013-03-03 22:00:00 | ZN | Futures | 118.421387 | 118.421387 | 118.421387 | 118.421387 | 5.0 |
| 2013-03-03 23:00:00 | ZN | Futures | 118.37966 | 118.449205 | 118.37966 | 118.449205 | 199.0 |
> showing 36 of 264 rows — these rows as CSV