PREVIEW / futures_1hour / 2012-02-05
file: by_date/futures_1hour/2012/2012-02-05.parquet size: 14 KB rows: 265
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 |
|---|---|---|---|---|---|---|---|
| 2012-02-05 18:00:00 | ES | Futures | 1347.13 | 1347.88 | 1345.36 | 1347.38 | 9357.0 |
| 2012-02-05 19:00:00 | ES | Futures | 1347.63 | 1348.14 | 1346.88 | 1347.13 | 3529.0 |
| 2012-02-05 20:00:00 | ES | Futures | 1347.38 | 1347.63 | 1345.62 | 1345.87 | 5865.0 |
| 2012-02-05 21:00:00 | ES | Futures | 1346.12 | 1346.37 | 1344.61 | 1345.11 | 4624.0 |
| 2012-02-05 22:00:00 | ES | Futures | 1345.36 | 1346.37 | 1344.61 | 1346.12 | 4350.0 |
| 2012-02-05 23:00:00 | ES | Futures | 1345.87 | 1346.37 | 1345.36 | 1345.62 | 2444.0 |
| 2012-02-05 18:00:00 | NQ | Futures | 2910.8 | 2912.24 | 2900.11 | 2911.66 | 929.0 |
| 2012-02-05 19:00:00 | NQ | Futures | 2911.66 | 2912.24 | 2910.51 | 2910.51 | 205.0 |
| 2012-02-05 20:00:00 | NQ | Futures | 2910.8 | 2911.09 | 2908.78 | 2909.35 | 269.0 |
| 2012-02-05 21:00:00 | NQ | Futures | 2909.93 | 2910.22 | 2907.62 | 2908.2 | 321.0 |
| 2012-02-05 22:00:00 | NQ | Futures | 2908.2 | 2911.38 | 2907.62 | 2910.51 | 359.0 |
| 2012-02-05 23:00:00 | NQ | Futures | 2910.51 | 2910.8 | 2909.35 | 2909.93 | 250.0 |
| 2012-02-05 18:00:00 | YM | Futures | 12666.7 | 12667.7 | 12646.9 | 12661.8 | 805.0 |
| 2012-02-05 19:00:00 | YM | Futures | 12663.7 | 12667.7 | 12658.8 | 12662.7 | 340.0 |
| 2012-02-05 20:00:00 | YM | Futures | 12663.7 | 12663.7 | 12648.9 | 12653.8 | 356.0 |
| 2012-02-05 21:00:00 | YM | Futures | 12654.8 | 12655.8 | 12642.9 | 12646.9 | 233.0 |
| 2012-02-05 22:00:00 | YM | Futures | 12646.9 | 12657.8 | 12642.9 | 12653.8 | 546.0 |
| 2012-02-05 23:00:00 | YM | Futures | 12653.8 | 12655.8 | 12646.9 | 12652.8 | 329.0 |
| 2012-02-05 18:00:00 | CL | Futures | 164.8 | 164.82 | 164.52 | 164.72 | 1088.0 |
| 2012-02-05 19:00:00 | CL | Futures | 164.7 | 164.72 | 164.46 | 164.53 | 583.0 |
| 2012-02-05 20:00:00 | CL | Futures | 164.55 | 164.62 | 164.13 | 164.14 | 593.0 |
| 2012-02-05 21:00:00 | CL | Futures | 164.13 | 164.18 | 163.66 | 163.81 | 1151.0 |
| 2012-02-05 22:00:00 | CL | Futures | 163.81 | 164.31 | 163.72 | 164.25 | 783.0 |
| 2012-02-05 23:00:00 | CL | Futures | 164.23 | 164.38 | 164.03 | 164.06 | 678.0 |
| 2012-02-05 18:00:00 | GC | Futures | 2402.5 | 2407.4 | 2400.0 | 2405.9 | 1489.0 |
| 2012-02-05 19:00:00 | GC | Futures | 2405.9 | 2407.4 | 2401.7 | 2404.9 | 1505.0 |
| 2012-02-05 20:00:00 | GC | Futures | 2404.9 | 2412.9 | 2404.6 | 2411.0 | 3990.0 |
| 2012-02-05 21:00:00 | GC | Futures | 2410.9 | 2414.2 | 2408.6 | 2412.9 | 2987.0 |
| 2012-02-05 22:00:00 | GC | Futures | 2412.9 | 2416.3 | 2408.5 | 2409.3 | 4656.0 |
| 2012-02-05 23:00:00 | GC | Futures | 2409.3 | 2412.1 | 2407.8 | 2410.0 | 1912.0 |
| 2012-02-05 18:00:00 | ZN | Futures | 114.833465 | 114.833465 | 114.765266 | 114.806185 | 4217.0 |
| 2012-02-05 19:00:00 | ZN | Futures | 114.806185 | 114.847105 | 114.778906 | 114.806185 | 4326.0 |
| 2012-02-05 20:00:00 | ZN | Futures | 114.806185 | 114.819825 | 114.778906 | 114.819825 | 4006.0 |
| 2012-02-05 21:00:00 | ZN | Futures | 114.806185 | 114.860745 | 114.806185 | 114.833465 | 4930.0 |
| 2012-02-05 22:00:00 | ZN | Futures | 114.819825 | 114.847105 | 114.778906 | 114.806185 | 5778.0 |
| 2012-02-05 23:00:00 | ZN | Futures | 114.806185 | 114.806185 | 114.778906 | 114.778906 | 2496.0 |
> showing 36 of 265 rows — these rows as CSV