PREVIEW / futures_1hour / 2012-02-19
file: by_date/futures_1hour/2012/2012-02-19.parquet size: 12 KB rows: 209
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-19 18:00:00 | ES | Futures | 1377.62 | 1380.39 | 1377.37 | 1379.13 | 23913.0 |
| 2012-02-19 19:00:00 | ES | Futures | 1379.38 | 1379.63 | 1378.37 | 1379.13 | 8025.0 |
| 2012-02-19 20:00:00 | ES | Futures | 1378.88 | 1379.13 | 1377.87 | 1378.37 | 4152.0 |
| 2012-02-19 21:00:00 | ES | Futures | 1378.37 | 1379.38 | 1378.12 | 1378.12 | 2631.0 |
| 2012-02-19 22:00:00 | ES | Futures | 1378.12 | 1379.13 | 1377.87 | 1378.37 | 3077.0 |
| 2012-02-19 23:00:00 | ES | Futures | 1378.37 | 1378.63 | 1376.61 | 1377.87 | 3957.0 |
| 2012-02-19 18:00:00 | NQ | Futures | 2996.28 | 3000.33 | 2995.99 | 2999.46 | 1530.0 |
| 2012-02-19 19:00:00 | NQ | Futures | 2999.75 | 3000.33 | 2998.59 | 2999.46 | 578.0 |
| 2012-02-19 20:00:00 | NQ | Futures | 2999.75 | 3000.04 | 2998.88 | 2999.46 | 406.0 |
| 2012-02-19 21:00:00 | NQ | Futures | 2999.46 | 3000.61 | 2999.17 | 2999.46 | 232.0 |
| 2012-02-19 22:00:00 | NQ | Futures | 2999.46 | 3000.33 | 2999.17 | 2999.75 | 139.0 |
| 2012-02-19 23:00:00 | NQ | Futures | 2999.75 | 3000.33 | 2997.15 | 3000.33 | 422.0 |
| 2012-02-19 18:00:00 | YM | Futures | 12877.8 | 12908.5 | 12875.8 | 12891.7 | 3011.0 |
| 2012-02-19 19:00:00 | YM | Futures | 12891.7 | 12893.7 | 12885.8 | 12889.7 | 384.0 |
| 2012-02-19 20:00:00 | YM | Futures | 12889.7 | 12889.7 | 12878.8 | 12882.8 | 309.0 |
| 2012-02-19 21:00:00 | YM | Futures | 12882.8 | 12887.7 | 12877.8 | 12878.8 | 188.0 |
| 2012-02-19 22:00:00 | YM | Futures | 12877.8 | 12883.8 | 12875.8 | 12880.8 | 228.0 |
| 2012-02-19 23:00:00 | YM | Futures | 12878.8 | 12881.8 | 12870.9 | 12878.8 | 139.0 |
| 2012-02-19 18:00:00 | CL | Futures | 175.75 | 177.11 | 175.67 | 176.44 | 5097.0 |
| 2012-02-19 19:00:00 | CL | Futures | 176.42 | 176.71 | 176.34 | 176.57 | 1178.0 |
| 2012-02-19 20:00:00 | CL | Futures | 176.56 | 176.86 | 176.41 | 176.86 | 1040.0 |
| 2012-02-19 21:00:00 | CL | Futures | 176.86 | 176.88 | 176.57 | 176.74 | 943.0 |
| 2012-02-19 22:00:00 | CL | Futures | 176.73 | 176.83 | 176.54 | 176.74 | 751.0 |
| 2012-02-19 23:00:00 | CL | Futures | 176.74 | 176.78 | 176.59 | 176.76 | 404.0 |
| 2012-02-19 18:00:00 | GC | Futures | 2398.9 | 2408.9 | 2397.0 | 2408.8 | 3130.0 |
| 2012-02-19 19:00:00 | GC | Futures | 2408.8 | 2411.1 | 2406.0 | 2409.8 | 2449.0 |
| 2012-02-19 20:00:00 | GC | Futures | 2409.9 | 2413.2 | 2409.9 | 2412.5 | 2518.0 |
| 2012-02-19 21:00:00 | GC | Futures | 2412.3 | 2413.6 | 2410.6 | 2412.3 | 1357.0 |
| 2012-02-19 22:00:00 | GC | Futures | 2412.1 | 2412.3 | 2409.9 | 2409.9 | 589.0 |
| 2012-02-19 23:00:00 | GC | Futures | 2409.9 | 2411.4 | 2409.1 | 2410.4 | 694.0 |
| 2012-02-19 18:00:00 | ZN | Futures | 114.178755 | 114.192395 | 113.987798 | 114.015077 | 8573.0 |
| 2012-02-19 19:00:00 | ZN | Futures | 114.001437 | 114.055997 | 114.001437 | 114.028717 | 3652.0 |
| 2012-02-19 20:00:00 | ZN | Futures | 114.028717 | 114.096916 | 114.015077 | 114.096916 | 2303.0 |
| 2012-02-19 21:00:00 | ZN | Futures | 114.096916 | 114.096916 | 114.015077 | 114.028717 | 4134.0 |
| 2012-02-19 22:00:00 | ZN | Futures | 114.028717 | 114.055997 | 114.015077 | 114.015077 | 2113.0 |
| 2012-02-19 23:00:00 | ZN | Futures | 114.015077 | 114.069636 | 114.015077 | 114.055997 | 1562.0 |
> showing 36 of 209 rows — these rows as CSV