PREVIEW / futures_30min / 2011-06-19
file: by_date/futures_30min/2011/2011-06-19.parquet size: 19 KB rows: 489
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 |
|---|---|---|---|---|---|---|---|
| 2011-06-19 18:00:00 | ES | Futures | 1261.99 | 1261.99 | 1257.25 | 1258.5 | 12022.0 |
| 2011-06-19 18:30:00 | ES | Futures | 1258.75 | 1259.5 | 1258.25 | 1259.25 | 3010.0 |
| 2011-06-19 19:00:00 | ES | Futures | 1259.0 | 1259.5 | 1259.0 | 1259.5 | 1541.0 |
| 2011-06-19 19:30:00 | ES | Futures | 1259.5 | 1261.99 | 1259.0 | 1259.5 | 3765.0 |
| 2011-06-19 20:00:00 | ES | Futures | 1259.25 | 1260.74 | 1259.0 | 1260.74 | 4494.0 |
| 2011-06-19 20:30:00 | ES | Futures | 1260.5 | 1262.99 | 1260.0 | 1261.24 | 6437.0 |
| 2011-06-19 21:00:00 | ES | Futures | 1260.99 | 1261.74 | 1260.5 | 1260.99 | 4682.0 |
| 2011-06-19 21:30:00 | ES | Futures | 1261.24 | 1262.99 | 1260.74 | 1262.49 | 3050.0 |
| 2011-06-19 22:00:00 | ES | Futures | 1262.74 | 1262.74 | 1261.24 | 1261.49 | 1949.0 |
| 2011-06-19 22:30:00 | ES | Futures | 1261.24 | 1261.49 | 1259.0 | 1259.5 | 3135.0 |
| 2011-06-19 23:00:00 | ES | Futures | 1259.5 | 1260.0 | 1258.5 | 1258.75 | 1186.0 |
| 2011-06-19 23:30:00 | ES | Futures | 1259.0 | 1259.25 | 1258.0 | 1258.5 | 1832.0 |
| 2011-06-19 18:00:00 | NQ | Futures | 2520.25 | 2520.25 | 2509.03 | 2513.05 | 790.0 |
| 2011-06-19 18:30:00 | NQ | Futures | 2513.34 | 2514.78 | 2513.05 | 2514.21 | 224.0 |
| 2011-06-19 19:00:00 | NQ | Futures | 2514.49 | 2515.64 | 2514.49 | 2515.64 | 133.0 |
| 2011-06-19 19:30:00 | NQ | Futures | 2515.64 | 2519.1 | 2515.07 | 2515.36 | 497.0 |
| 2011-06-19 20:00:00 | NQ | Futures | 2515.07 | 2517.37 | 2514.49 | 2517.08 | 191.0 |
| 2011-06-19 20:30:00 | NQ | Futures | 2517.08 | 2522.26 | 2516.8 | 2518.23 | 402.0 |
| 2011-06-19 21:00:00 | NQ | Futures | 2518.23 | 2519.1 | 2517.66 | 2518.81 | 223.0 |
| 2011-06-19 21:30:00 | NQ | Futures | 2517.95 | 2521.97 | 2517.95 | 2521.11 | 220.0 |
| 2011-06-19 22:00:00 | NQ | Futures | 2521.11 | 2521.11 | 2518.52 | 2518.52 | 346.0 |
| 2011-06-19 22:30:00 | NQ | Futures | 2518.52 | 2518.52 | 2513.92 | 2515.07 | 274.0 |
| 2011-06-19 23:00:00 | NQ | Futures | 2514.78 | 2514.78 | 2513.34 | 2513.63 | 104.0 |
| 2011-06-19 23:30:00 | NQ | Futures | 2513.92 | 2514.21 | 2512.48 | 2512.77 | 175.0 |
| 2011-06-19 18:00:00 | YM | Futures | 11547.2 | 11547.2 | 11511.4 | 11524.0 | 201.0 |
| 2011-06-19 18:30:00 | YM | Futures | 11524.0 | 11531.7 | 11522.0 | 11525.9 | 58.0 |
| 2011-06-19 19:00:00 | YM | Futures | 11529.8 | 11531.7 | 11526.9 | 11531.7 | 27.0 |
| 2011-06-19 19:30:00 | YM | Futures | 11529.8 | 11551.1 | 11529.8 | 11531.7 | 99.0 |
| 2011-06-19 20:00:00 | YM | Futures | 11530.7 | 11542.4 | 11529.8 | 11542.4 | 121.0 |
| 2011-06-19 20:30:00 | YM | Futures | 11540.4 | 11557.8 | 11531.7 | 11541.4 | 298.0 |
| 2011-06-19 21:00:00 | YM | Futures | 11543.3 | 11547.2 | 11539.4 | 11546.2 | 131.0 |
| 2011-06-19 21:30:00 | YM | Futures | 11543.3 | 11559.8 | 11543.3 | 11555.9 | 167.0 |
| 2011-06-19 22:00:00 | YM | Futures | 11554.9 | 11554.9 | 11540.4 | 11543.3 | 200.0 |
| 2011-06-19 22:30:00 | YM | Futures | 11542.4 | 11542.4 | 11524.0 | 11532.7 | 205.0 |
| 2011-06-19 23:00:00 | YM | Futures | 11533.6 | 11534.6 | 11520.1 | 11520.1 | 122.0 |
| 2011-06-19 23:30:00 | YM | Futures | 11523.0 | 11524.0 | 11516.2 | 11519.1 | 85.0 |
| 2011-06-19 18:00:00 | CL | Futures | 159.62 | 160.18 | 159.36 | 159.58 | 884.0 |
| 2011-06-19 18:30:00 | CL | Futures | 159.6 | 159.74 | 159.46 | 159.74 | 261.0 |
| 2011-06-19 19:00:00 | CL | Futures | 159.74 | 159.99 | 159.62 | 159.7 | 188.0 |
| 2011-06-19 19:30:00 | CL | Futures | 159.7 | 159.7 | 159.36 | 159.36 | 303.0 |
| 2011-06-19 20:00:00 | CL | Futures | 159.36 | 159.7 | 159.33 | 159.65 | 405.0 |
| 2011-06-19 20:30:00 | CL | Futures | 159.65 | 159.84 | 159.21 | 159.39 | 373.0 |
| 2011-06-19 21:00:00 | CL | Futures | 159.39 | 159.58 | 159.17 | 159.5 | 452.0 |
| 2011-06-19 21:30:00 | CL | Futures | 159.53 | 159.53 | 158.9 | 159.15 | 463.0 |
| 2011-06-19 22:00:00 | CL | Futures | 159.21 | 159.29 | 158.79 | 158.85 | 457.0 |
| 2011-06-19 22:30:00 | CL | Futures | 158.88 | 158.95 | 158.73 | 158.83 | 271.0 |
| 2011-06-19 23:00:00 | CL | Futures | 158.83 | 158.95 | 158.55 | 158.55 | 418.0 |
| 2011-06-19 23:30:00 | CL | Futures | 158.57 | 158.62 | 158.14 | 158.21 | 771.0 |
| 2011-06-19 18:00:00 | GC | Futures | 2149.7 | 2151.8 | 2146.5 | 2146.7 | 851.0 |
| 2011-06-19 18:30:00 | GC | Futures | 2147.1 | 2149.7 | 2146.5 | 2149.0 | 274.0 |
> showing 50 of 489 rows — these rows as CSV