PREVIEW / futures_1hour / 2012-11-11
file: by_date/futures_1hour/2012/2012-11-11.parquet size: 14 KB rows: 271
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-11-11 18:00:00 | ES | Futures | 1405.31 | 1407.86 | 1402.75 | 1404.54 | 11831.0 |
| 2012-11-11 19:00:00 | ES | Futures | 1404.28 | 1405.31 | 1402.5 | 1405.05 | 7154.0 |
| 2012-11-11 20:00:00 | ES | Futures | 1405.05 | 1406.84 | 1404.03 | 1404.79 | 6809.0 |
| 2012-11-11 21:00:00 | ES | Futures | 1404.54 | 1406.07 | 1403.26 | 1405.82 | 4375.0 |
| 2012-11-11 22:00:00 | ES | Futures | 1405.82 | 1406.84 | 1405.31 | 1406.84 | 1865.0 |
| 2012-11-11 23:00:00 | ES | Futures | 1406.58 | 1408.63 | 1406.58 | 1408.37 | 3263.0 |
| 2012-11-11 18:00:00 | NQ | Futures | 3000.49 | 3005.43 | 2995.55 | 2999.62 | 1146.0 |
| 2012-11-11 19:00:00 | NQ | Futures | 2999.33 | 3000.49 | 2994.68 | 2999.91 | 768.0 |
| 2012-11-11 20:00:00 | NQ | Futures | 2999.91 | 3003.98 | 2997.59 | 2998.75 | 1048.0 |
| 2012-11-11 21:00:00 | NQ | Futures | 2998.75 | 3002.82 | 2996.42 | 3001.65 | 660.0 |
| 2012-11-11 22:00:00 | NQ | Futures | 3001.65 | 3003.69 | 3000.78 | 3003.69 | 381.0 |
| 2012-11-11 23:00:00 | NQ | Futures | 3003.4 | 3007.76 | 3003.11 | 3007.47 | 410.0 |
| 2012-11-11 18:00:00 | YM | Futures | 12770.6 | 12792.6 | 12749.6 | 12764.6 | 781.0 |
| 2012-11-11 19:00:00 | YM | Futures | 12763.6 | 12771.6 | 12748.6 | 12766.6 | 700.0 |
| 2012-11-11 20:00:00 | YM | Futures | 12766.6 | 12779.6 | 12758.6 | 12764.6 | 1145.0 |
| 2012-11-11 21:00:00 | YM | Futures | 12764.6 | 12776.6 | 12754.6 | 12771.6 | 673.0 |
| 2012-11-11 22:00:00 | YM | Futures | 12773.6 | 12784.6 | 12769.6 | 12783.6 | 357.0 |
| 2012-11-11 23:00:00 | YM | Futures | 12783.6 | 12795.6 | 12782.6 | 12795.6 | 297.0 |
| 2012-11-11 18:00:00 | CL | Futures | 140.05 | 140.22 | 139.79 | 139.91 | 886.0 |
| 2012-11-11 19:00:00 | CL | Futures | 139.92 | 139.94 | 139.62 | 139.81 | 1082.0 |
| 2012-11-11 20:00:00 | CL | Futures | 139.83 | 139.89 | 139.53 | 139.62 | 1100.0 |
| 2012-11-11 21:00:00 | CL | Futures | 139.62 | 139.79 | 139.47 | 139.73 | 660.0 |
| 2012-11-11 22:00:00 | CL | Futures | 139.71 | 139.86 | 139.6 | 139.75 | 528.0 |
| 2012-11-11 23:00:00 | CL | Futures | 139.73 | 140.18 | 139.73 | 140.15 | 892.0 |
| 2012-11-11 18:00:00 | GC | Futures | 2389.1 | 2396.0 | 2388.8 | 2393.2 | 2168.0 |
| 2012-11-11 19:00:00 | GC | Futures | 2393.1 | 2394.7 | 2391.4 | 2394.7 | 1617.0 |
| 2012-11-11 20:00:00 | GC | Futures | 2394.9 | 2394.9 | 2390.0 | 2392.2 | 3338.0 |
| 2012-11-11 21:00:00 | GC | Futures | 2392.2 | 2392.4 | 2390.0 | 2391.8 | 1235.0 |
| 2012-11-11 22:00:00 | GC | Futures | 2391.6 | 2393.5 | 2391.0 | 2392.8 | 869.0 |
| 2012-11-11 23:00:00 | GC | Futures | 2392.7 | 2394.3 | 2391.7 | 2394.2 | 1171.0 |
| 2012-11-11 18:00:00 | ZN | Futures | 118.811198 | 118.852789 | 118.783471 | 118.838926 | 3779.0 |
| 2012-11-11 19:00:00 | ZN | Futures | 118.825062 | 118.838926 | 118.755744 | 118.783471 | 4973.0 |
| 2012-11-11 20:00:00 | ZN | Futures | 118.769607 | 118.783471 | 118.74188 | 118.783471 | 3759.0 |
| 2012-11-11 21:00:00 | ZN | Futures | 118.783471 | 118.811198 | 118.755744 | 118.783471 | 1955.0 |
| 2012-11-11 22:00:00 | ZN | Futures | 118.783471 | 118.811198 | 118.755744 | 118.769607 | 2546.0 |
| 2012-11-11 23:00:00 | ZN | Futures | 118.769607 | 118.783471 | 118.755744 | 118.755744 | 1284.0 |
> showing 36 of 271 rows — these rows as CSV