PREVIEW / futures_30min / 2012-11-11
file: by_date/futures_30min/2012/2012-11-11.parquet size: 19 KB rows: 514
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 | 1405.31 | 1405.56 | 5892.0 |
| 2012-11-11 18:30:00 | ES | Futures | 1405.82 | 1405.82 | 1402.75 | 1404.54 | 5939.0 |
| 2012-11-11 19:00:00 | ES | Futures | 1404.28 | 1405.31 | 1403.01 | 1403.26 | 3545.0 |
| 2012-11-11 19:30:00 | ES | Futures | 1403.26 | 1405.31 | 1402.5 | 1405.05 | 3609.0 |
| 2012-11-11 20:00:00 | ES | Futures | 1405.05 | 1406.84 | 1404.54 | 1406.07 | 3963.0 |
| 2012-11-11 20:30:00 | ES | Futures | 1406.07 | 1406.84 | 1404.03 | 1404.79 | 2846.0 |
| 2012-11-11 21:00:00 | ES | Futures | 1404.54 | 1405.82 | 1403.26 | 1405.56 | 2398.0 |
| 2012-11-11 21:30:00 | ES | Futures | 1405.31 | 1406.07 | 1404.79 | 1405.82 | 1977.0 |
| 2012-11-11 22:00:00 | ES | Futures | 1405.82 | 1406.84 | 1405.31 | 1406.58 | 691.0 |
| 2012-11-11 22:30:00 | ES | Futures | 1406.58 | 1406.84 | 1405.56 | 1406.84 | 1174.0 |
| 2012-11-11 23:00:00 | ES | Futures | 1406.58 | 1408.37 | 1406.58 | 1408.12 | 2210.0 |
| 2012-11-11 23:30:00 | ES | Futures | 1408.12 | 1408.63 | 1407.61 | 1408.37 | 1053.0 |
| 2012-11-11 18:00:00 | NQ | Futures | 3000.49 | 3005.43 | 2999.33 | 3001.65 | 516.0 |
| 2012-11-11 18:30:00 | NQ | Futures | 3001.65 | 3002.24 | 2995.55 | 2999.62 | 630.0 |
| 2012-11-11 19:00:00 | NQ | Futures | 2999.33 | 2999.91 | 2995.26 | 2995.84 | 373.0 |
| 2012-11-11 19:30:00 | NQ | Futures | 2995.84 | 3000.49 | 2994.68 | 2999.91 | 395.0 |
| 2012-11-11 20:00:00 | NQ | Futures | 2999.91 | 3003.4 | 2998.17 | 3001.94 | 515.0 |
| 2012-11-11 20:30:00 | NQ | Futures | 3001.94 | 3003.98 | 2997.59 | 2998.75 | 533.0 |
| 2012-11-11 21:00:00 | NQ | Futures | 2998.75 | 3001.36 | 2996.42 | 3001.36 | 325.0 |
| 2012-11-11 21:30:00 | NQ | Futures | 3001.36 | 3002.82 | 2999.62 | 3001.65 | 335.0 |
| 2012-11-11 22:00:00 | NQ | Futures | 3001.65 | 3003.69 | 3001.07 | 3003.69 | 119.0 |
| 2012-11-11 22:30:00 | NQ | Futures | 3003.69 | 3003.69 | 3000.78 | 3003.69 | 262.0 |
| 2012-11-11 23:00:00 | NQ | Futures | 3003.4 | 3006.88 | 3003.11 | 3006.59 | 204.0 |
| 2012-11-11 23:30:00 | NQ | Futures | 3006.3 | 3007.76 | 3005.72 | 3007.47 | 206.0 |
| 2012-11-11 18:00:00 | YM | Futures | 12770.6 | 12792.6 | 12769.6 | 12773.6 | 350.0 |
| 2012-11-11 18:30:00 | YM | Futures | 12773.6 | 12775.6 | 12749.6 | 12764.6 | 431.0 |
| 2012-11-11 19:00:00 | YM | Futures | 12763.6 | 12768.6 | 12754.6 | 12754.6 | 274.0 |
| 2012-11-11 19:30:00 | YM | Futures | 12754.6 | 12771.6 | 12748.6 | 12766.6 | 426.0 |
| 2012-11-11 20:00:00 | YM | Futures | 12766.6 | 12779.6 | 12762.6 | 12774.6 | 657.0 |
| 2012-11-11 20:30:00 | YM | Futures | 12772.6 | 12779.6 | 12758.6 | 12764.6 | 488.0 |
| 2012-11-11 21:00:00 | YM | Futures | 12764.6 | 12772.6 | 12754.6 | 12770.6 | 342.0 |
| 2012-11-11 21:30:00 | YM | Futures | 12772.6 | 12776.6 | 12763.6 | 12771.6 | 331.0 |
| 2012-11-11 22:00:00 | YM | Futures | 12773.6 | 12781.6 | 12769.6 | 12781.6 | 161.0 |
| 2012-11-11 22:30:00 | YM | Futures | 12780.6 | 12784.6 | 12773.6 | 12783.6 | 196.0 |
| 2012-11-11 23:00:00 | YM | Futures | 12783.6 | 12795.6 | 12782.6 | 12793.6 | 206.0 |
| 2012-11-11 23:30:00 | YM | Futures | 12791.6 | 12795.6 | 12788.6 | 12795.6 | 91.0 |
| 2012-11-11 18:00:00 | CL | Futures | 140.05 | 140.22 | 139.89 | 140.1 | 503.0 |
| 2012-11-11 18:30:00 | CL | Futures | 140.1 | 140.17 | 139.79 | 139.91 | 383.0 |
| 2012-11-11 19:00:00 | CL | Futures | 139.92 | 139.94 | 139.63 | 139.65 | 691.0 |
| 2012-11-11 19:30:00 | CL | Futures | 139.66 | 139.86 | 139.62 | 139.81 | 391.0 |
| 2012-11-11 20:00:00 | CL | Futures | 139.83 | 139.89 | 139.68 | 139.81 | 511.0 |
| 2012-11-11 20:30:00 | CL | Futures | 139.81 | 139.89 | 139.53 | 139.62 | 589.0 |
| 2012-11-11 21:00:00 | CL | Futures | 139.62 | 139.76 | 139.47 | 139.73 | 407.0 |
| 2012-11-11 21:30:00 | CL | Futures | 139.75 | 139.79 | 139.63 | 139.73 | 253.0 |
| 2012-11-11 22:00:00 | CL | Futures | 139.71 | 139.84 | 139.65 | 139.83 | 183.0 |
| 2012-11-11 22:30:00 | CL | Futures | 139.84 | 139.86 | 139.6 | 139.75 | 345.0 |
| 2012-11-11 23:00:00 | CL | Futures | 139.73 | 139.91 | 139.73 | 139.89 | 337.0 |
| 2012-11-11 23:30:00 | CL | Futures | 139.88 | 140.18 | 139.79 | 140.15 | 555.0 |
| 2012-11-11 18:00:00 | GC | Futures | 2389.1 | 2395.1 | 2388.8 | 2394.0 | 1363.0 |
| 2012-11-11 18:30:00 | GC | Futures | 2393.8 | 2396.0 | 2392.1 | 2393.2 | 805.0 |
> showing 50 of 514 rows — these rows as CSV