PREVIEW / futures_30min / 2012-03-11
file: by_date/futures_30min/2012/2012-03-11.parquet size: 18 KB rows: 461
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-03-11 18:00:00 | ES | Futures | 1383.67 | 1383.67 | 1380.89 | 1382.66 | 1128.0 |
| 2012-03-11 18:30:00 | ES | Futures | 1382.66 | 1382.66 | 1381.9 | 1381.9 | 161.0 |
| 2012-03-11 19:00:00 | ES | Futures | 1382.15 | 1382.41 | 1381.9 | 1381.9 | 271.0 |
| 2012-03-11 19:30:00 | ES | Futures | 1382.41 | 1383.16 | 1381.65 | 1382.91 | 601.0 |
| 2012-03-11 20:00:00 | ES | Futures | 1382.91 | 1382.91 | 1380.89 | 1381.15 | 1838.0 |
| 2012-03-11 20:30:00 | ES | Futures | 1381.15 | 1381.4 | 1380.39 | 1380.89 | 1358.0 |
| 2012-03-11 21:00:00 | ES | Futures | 1380.89 | 1381.15 | 1379.89 | 1380.89 | 1385.0 |
| 2012-03-11 21:30:00 | ES | Futures | 1381.15 | 1381.4 | 1380.14 | 1380.89 | 646.0 |
| 2012-03-11 22:00:00 | ES | Futures | 1380.89 | 1380.89 | 1379.89 | 1380.14 | 1096.0 |
| 2012-03-11 22:30:00 | ES | Futures | 1380.14 | 1380.39 | 1379.13 | 1380.14 | 2097.0 |
| 2012-03-11 23:00:00 | ES | Futures | 1380.14 | 1380.64 | 1379.63 | 1380.14 | 624.0 |
| 2012-03-11 23:30:00 | ES | Futures | 1380.14 | 1380.64 | 1379.13 | 1379.63 | 642.0 |
| 2012-03-11 18:00:00 | NQ | Futures | 3060.4 | 3060.4 | 3050.58 | 3057.8 | 116.0 |
| 2012-03-11 18:30:00 | NQ | Futures | 3057.51 | 3057.51 | 3056.06 | 3056.06 | 55.0 |
| 2012-03-11 19:00:00 | NQ | Futures | 3056.06 | 3056.93 | 3055.78 | 3056.06 | 41.0 |
| 2012-03-11 19:30:00 | NQ | Futures | 3056.64 | 3057.51 | 3056.06 | 3057.51 | 29.0 |
| 2012-03-11 20:00:00 | NQ | Futures | 3057.51 | 3057.8 | 3054.33 | 3054.91 | 64.0 |
| 2012-03-11 20:30:00 | NQ | Futures | 3055.2 | 3055.2 | 3052.02 | 3053.18 | 72.0 |
| 2012-03-11 21:00:00 | NQ | Futures | 3053.18 | 3053.46 | 3051.44 | 3052.89 | 68.0 |
| 2012-03-11 21:30:00 | NQ | Futures | 3053.18 | 3054.04 | 3052.31 | 3053.46 | 43.0 |
| 2012-03-11 22:00:00 | NQ | Futures | 3052.02 | 3053.75 | 3051.73 | 3052.02 | 52.0 |
| 2012-03-11 22:30:00 | NQ | Futures | 3052.6 | 3052.6 | 3050.29 | 3052.02 | 101.0 |
| 2012-03-11 23:00:00 | NQ | Futures | 3052.6 | 3052.89 | 3051.73 | 3052.31 | 67.0 |
| 2012-03-11 23:30:00 | NQ | Futures | 3052.6 | 3052.6 | 3050.58 | 3050.87 | 49.0 |
| 2012-03-11 18:00:00 | YM | Futures | 12811.4 | 12816.4 | 12799.5 | 12807.4 | 74.0 |
| 2012-03-11 18:30:00 | YM | Futures | 12809.4 | 12810.4 | 12801.5 | 12801.5 | 49.0 |
| 2012-03-11 19:00:00 | YM | Futures | 12803.4 | 12808.4 | 12802.4 | 12804.4 | 41.0 |
| 2012-03-11 19:30:00 | YM | Futures | 12807.4 | 12812.4 | 12803.4 | 12811.4 | 60.0 |
| 2012-03-11 20:00:00 | YM | Futures | 12812.4 | 12812.4 | 12797.5 | 12800.5 | 72.0 |
| 2012-03-11 20:30:00 | YM | Futures | 12799.5 | 12799.5 | 12791.5 | 12796.5 | 115.0 |
| 2012-03-11 21:00:00 | YM | Futures | 12795.5 | 12795.5 | 12787.5 | 12795.5 | 147.0 |
| 2012-03-11 21:30:00 | YM | Futures | 12797.5 | 12798.5 | 12791.5 | 12796.5 | 166.0 |
| 2012-03-11 22:00:00 | YM | Futures | 12796.5 | 12796.5 | 12786.5 | 12790.5 | 134.0 |
| 2012-03-11 22:30:00 | YM | Futures | 12789.5 | 12790.5 | 12782.5 | 12790.5 | 192.0 |
| 2012-03-11 23:00:00 | YM | Futures | 12791.5 | 12793.5 | 12787.5 | 12791.5 | 64.0 |
| 2012-03-11 23:30:00 | YM | Futures | 12791.5 | 12793.5 | 12784.5 | 12786.5 | 80.0 |
| 2012-03-11 18:00:00 | CL | Futures | 180.37 | 180.47 | 179.78 | 180.03 | 698.0 |
| 2012-03-11 18:30:00 | CL | Futures | 180.0 | 180.01 | 179.8 | 179.88 | 262.0 |
| 2012-03-11 19:00:00 | CL | Futures | 179.93 | 179.93 | 179.71 | 179.76 | 308.0 |
| 2012-03-11 19:30:00 | CL | Futures | 179.73 | 179.85 | 179.58 | 179.76 | 525.0 |
| 2012-03-11 20:00:00 | CL | Futures | 179.73 | 179.81 | 179.43 | 179.51 | 551.0 |
| 2012-03-11 20:30:00 | CL | Futures | 179.46 | 179.56 | 179.41 | 179.54 | 258.0 |
| 2012-03-11 21:00:00 | CL | Futures | 179.49 | 179.56 | 179.26 | 179.41 | 657.0 |
| 2012-03-11 21:30:00 | CL | Futures | 179.44 | 179.51 | 179.31 | 179.39 | 319.0 |
| 2012-03-11 22:00:00 | CL | Futures | 179.39 | 179.39 | 179.01 | 179.24 | 753.0 |
| 2012-03-11 22:30:00 | CL | Futures | 179.21 | 179.46 | 178.97 | 179.24 | 870.0 |
| 2012-03-11 23:00:00 | CL | Futures | 179.26 | 179.31 | 179.07 | 179.26 | 163.0 |
| 2012-03-11 23:30:00 | CL | Futures | 179.28 | 179.34 | 179.16 | 179.24 | 199.0 |
| 2012-03-11 18:00:00 | GC | Futures | 2380.3 | 2383.7 | 2379.2 | 2381.7 | 502.0 |
| 2012-03-11 18:30:00 | GC | Futures | 2382.0 | 2382.4 | 2379.1 | 2379.6 | 287.0 |
> showing 50 of 461 rows — these rows as CSV