PREVIEW / futures_30min / 2008-06-22
file: by_date/futures_30min/2008/2008-06-22.parquet size: 17 KB rows: 374
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 |
|---|---|---|---|---|---|---|---|
| 2008-06-22 18:00:00 | ES | Futures | 1227.85 | 1229.01 | 1226.22 | 1227.62 | 3181.0 |
| 2008-06-22 18:30:00 | ES | Futures | 1227.39 | 1228.08 | 1227.39 | 1228.08 | 317.0 |
| 2008-06-22 19:00:00 | ES | Futures | 1228.32 | 1228.78 | 1228.32 | 1228.55 | 404.0 |
| 2008-06-22 19:30:00 | ES | Futures | 1228.55 | 1229.71 | 1228.55 | 1228.78 | 931.0 |
| 2008-06-22 20:00:00 | ES | Futures | 1228.55 | 1228.78 | 1228.32 | 1228.55 | 1017.0 |
| 2008-06-22 20:30:00 | ES | Futures | 1228.55 | 1229.01 | 1228.32 | 1228.55 | 615.0 |
| 2008-06-22 21:00:00 | ES | Futures | 1228.55 | 1228.55 | 1227.62 | 1228.08 | 697.0 |
| 2008-06-22 21:30:00 | ES | Futures | 1228.32 | 1229.48 | 1228.08 | 1229.24 | 571.0 |
| 2008-06-22 22:00:00 | ES | Futures | 1229.48 | 1229.71 | 1229.01 | 1229.71 | 469.0 |
| 2008-06-22 22:30:00 | ES | Futures | 1229.48 | 1229.71 | 1228.55 | 1228.78 | 814.0 |
| 2008-06-22 23:00:00 | ES | Futures | 1228.78 | 1229.48 | 1228.32 | 1229.24 | 662.0 |
| 2008-06-22 23:30:00 | ES | Futures | 1229.48 | 1230.64 | 1229.48 | 1230.17 | 1262.0 |
| 2008-06-22 18:00:00 | NQ | Futures | 2186.18 | 2189.55 | 2184.49 | 2186.18 | 301.0 |
| 2008-06-22 18:30:00 | NQ | Futures | 2186.18 | 2187.3 | 2185.61 | 2187.3 | 68.0 |
| 2008-06-22 19:00:00 | NQ | Futures | 2187.58 | 2188.43 | 2187.02 | 2188.15 | 26.0 |
| 2008-06-22 19:30:00 | NQ | Futures | 2187.02 | 2189.27 | 2186.74 | 2187.58 | 144.0 |
| 2008-06-22 20:00:00 | NQ | Futures | 2187.58 | 2188.43 | 2186.46 | 2186.74 | 23.0 |
| 2008-06-22 20:30:00 | NQ | Futures | 2187.86 | 2187.86 | 2187.02 | 2187.58 | 28.0 |
| 2008-06-22 21:00:00 | NQ | Futures | 2187.02 | 2187.3 | 2185.61 | 2186.74 | 23.0 |
| 2008-06-22 21:30:00 | NQ | Futures | 2187.58 | 2189.27 | 2187.58 | 2189.27 | 74.0 |
| 2008-06-22 22:00:00 | NQ | Futures | 2188.99 | 2190.4 | 2188.15 | 2188.71 | 175.0 |
| 2008-06-22 22:30:00 | NQ | Futures | 2188.99 | 2189.55 | 2187.3 | 2187.86 | 183.0 |
| 2008-06-22 23:00:00 | NQ | Futures | 2187.3 | 2188.43 | 2186.74 | 2188.43 | 24.0 |
| 2008-06-22 23:30:00 | NQ | Futures | 2188.43 | 2190.4 | 2188.43 | 2190.11 | 66.0 |
| 2008-06-22 18:00:00 | YM | Futures | 10771.1 | 10792.0 | 10769.3 | 10780.2 | 180.0 |
| 2008-06-22 18:30:00 | YM | Futures | 10781.1 | 10782.9 | 10777.4 | 10779.2 | 49.0 |
| 2008-06-22 19:00:00 | YM | Futures | 10782.9 | 10783.8 | 10780.2 | 10781.1 | 23.0 |
| 2008-06-22 19:30:00 | YM | Futures | 10782.9 | 10792.0 | 10782.9 | 10787.4 | 57.0 |
| 2008-06-22 20:00:00 | YM | Futures | 10787.4 | 10787.4 | 10782.9 | 10785.6 | 47.0 |
| 2008-06-22 20:30:00 | YM | Futures | 10784.7 | 10790.2 | 10784.7 | 10786.5 | 41.0 |
| 2008-06-22 21:00:00 | YM | Futures | 10785.6 | 10786.5 | 10780.2 | 10784.7 | 30.0 |
| 2008-06-22 21:30:00 | YM | Futures | 10785.6 | 10792.9 | 10785.6 | 10792.0 | 87.0 |
| 2008-06-22 22:00:00 | YM | Futures | 10792.9 | 10794.7 | 10792.0 | 10792.9 | 21.0 |
| 2008-06-22 22:30:00 | YM | Futures | 10792.9 | 10796.5 | 10791.1 | 10791.1 | 57.0 |
| 2008-06-22 23:00:00 | YM | Futures | 10790.2 | 10793.8 | 10787.4 | 10792.9 | 78.0 |
| 2008-06-22 23:30:00 | YM | Futures | 10792.9 | 10802.9 | 10792.9 | 10798.3 | 131.0 |
| 2008-06-22 18:00:00 | CL | Futures | 511.57 | 513.69 | 509.71 | 511.8 | 1367.0 |
| 2008-06-22 18:30:00 | CL | Futures | 511.87 | 512.4 | 511.61 | 512.1 | 210.0 |
| 2008-06-22 19:00:00 | CL | Futures | 511.99 | 512.78 | 511.95 | 512.25 | 184.0 |
| 2008-06-22 19:30:00 | CL | Futures | 512.37 | 512.71 | 511.76 | 512.52 | 93.0 |
| 2008-06-22 20:00:00 | CL | Futures | 512.37 | 513.66 | 512.25 | 513.5 | 161.0 |
| 2008-06-22 20:30:00 | CL | Futures | 513.5 | 514.8 | 513.28 | 514.26 | 424.0 |
| 2008-06-22 21:00:00 | CL | Futures | 514.42 | 515.36 | 514.23 | 514.98 | 406.0 |
| 2008-06-22 21:30:00 | CL | Futures | 514.95 | 515.06 | 514.45 | 515.02 | 226.0 |
| 2008-06-22 22:00:00 | CL | Futures | 515.02 | 515.06 | 514.61 | 514.72 | 149.0 |
| 2008-06-22 22:30:00 | CL | Futures | 514.72 | 515.67 | 514.61 | 514.72 | 289.0 |
| 2008-06-22 23:00:00 | CL | Futures | 514.72 | 515.63 | 514.61 | 515.4 | 172.0 |
| 2008-06-22 23:30:00 | CL | Futures | 515.44 | 515.55 | 515.33 | 515.55 | 58.0 |
| 2008-06-22 18:00:00 | GC | Futures | 1302.7 | 1307.0 | 1302.3 | 1306.9 | 278.0 |
| 2008-06-22 18:30:00 | GC | Futures | 1306.7 | 1308.0 | 1306.4 | 1307.0 | 221.0 |
> showing 50 of 374 rows — these rows as CSV