PREVIEW / futures_30min / 2011-04-17
file: by_date/futures_30min/2011/2011-04-17.parquet size: 20 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-04-17 18:00:00 | ES | Futures | 1309.97 | 1310.47 | 1308.48 | 1308.73 | 6740.0 |
| 2011-04-17 18:30:00 | ES | Futures | 1308.73 | 1309.73 | 1308.48 | 1309.73 | 1320.0 |
| 2011-04-17 19:00:00 | ES | Futures | 1309.73 | 1309.73 | 1308.48 | 1308.73 | 1701.0 |
| 2011-04-17 19:30:00 | ES | Futures | 1308.73 | 1308.98 | 1307.49 | 1308.24 | 3193.0 |
| 2011-04-17 20:00:00 | ES | Futures | 1308.24 | 1309.23 | 1307.24 | 1307.49 | 6157.0 |
| 2011-04-17 20:30:00 | ES | Futures | 1307.74 | 1307.99 | 1306.99 | 1307.49 | 4280.0 |
| 2011-04-17 21:00:00 | ES | Futures | 1307.24 | 1307.49 | 1306.25 | 1306.5 | 5101.0 |
| 2011-04-17 21:30:00 | ES | Futures | 1306.5 | 1307.99 | 1306.25 | 1307.74 | 3587.0 |
| 2011-04-17 22:00:00 | ES | Futures | 1307.74 | 1309.23 | 1307.49 | 1308.48 | 3399.0 |
| 2011-04-17 22:30:00 | ES | Futures | 1308.24 | 1309.23 | 1308.24 | 1308.98 | 1019.0 |
| 2011-04-17 23:00:00 | ES | Futures | 1308.98 | 1309.48 | 1308.73 | 1308.98 | 1339.0 |
| 2011-04-17 23:30:00 | ES | Futures | 1309.23 | 1309.23 | 1307.74 | 1307.74 | 2007.0 |
| 2011-04-17 18:00:00 | NQ | Futures | 2652.49 | 2654.21 | 2650.48 | 2652.2 | 400.0 |
| 2011-04-17 18:30:00 | NQ | Futures | 2652.2 | 2654.5 | 2651.92 | 2653.93 | 264.0 |
| 2011-04-17 19:00:00 | NQ | Futures | 2654.21 | 2654.79 | 2652.78 | 2653.35 | 307.0 |
| 2011-04-17 19:30:00 | NQ | Futures | 2653.64 | 2653.93 | 2650.77 | 2651.63 | 455.0 |
| 2011-04-17 20:00:00 | NQ | Futures | 2651.92 | 2653.64 | 2650.19 | 2650.48 | 255.0 |
| 2011-04-17 20:30:00 | NQ | Futures | 2650.77 | 2651.63 | 2649.62 | 2650.19 | 147.0 |
| 2011-04-17 21:00:00 | NQ | Futures | 2650.48 | 2650.77 | 2648.18 | 2648.76 | 459.0 |
| 2011-04-17 21:30:00 | NQ | Futures | 2649.04 | 2651.92 | 2648.47 | 2651.92 | 193.0 |
| 2011-04-17 22:00:00 | NQ | Futures | 2651.92 | 2654.79 | 2651.34 | 2653.93 | 884.0 |
| 2011-04-17 22:30:00 | NQ | Futures | 2653.93 | 2654.79 | 2652.78 | 2654.5 | 299.0 |
| 2011-04-17 23:00:00 | NQ | Futures | 2654.5 | 2654.79 | 2654.21 | 2654.5 | 208.0 |
| 2011-04-17 23:30:00 | NQ | Futures | 2654.79 | 2654.79 | 2651.34 | 2651.34 | 187.0 |
| 2011-04-17 18:00:00 | YM | Futures | 11846.2 | 11849.1 | 11836.6 | 11839.5 | 322.0 |
| 2011-04-17 18:30:00 | YM | Futures | 11839.5 | 11849.1 | 11838.5 | 11849.1 | 168.0 |
| 2011-04-17 19:00:00 | YM | Futures | 11848.2 | 11848.2 | 11839.5 | 11841.4 | 71.0 |
| 2011-04-17 19:30:00 | YM | Futures | 11841.4 | 11841.4 | 11831.8 | 11836.6 | 123.0 |
| 2011-04-17 20:00:00 | YM | Futures | 11837.6 | 11845.3 | 11831.8 | 11831.8 | 147.0 |
| 2011-04-17 20:30:00 | YM | Futures | 11830.8 | 11836.6 | 11829.9 | 11829.9 | 148.0 |
| 2011-04-17 21:00:00 | YM | Futures | 11831.8 | 11832.8 | 11823.1 | 11824.1 | 270.0 |
| 2011-04-17 21:30:00 | YM | Futures | 11825.1 | 11833.7 | 11823.1 | 11832.8 | 101.0 |
| 2011-04-17 22:00:00 | YM | Futures | 11833.7 | 11844.3 | 11831.8 | 11836.6 | 208.0 |
| 2011-04-17 22:30:00 | YM | Futures | 11836.6 | 11842.4 | 11833.7 | 11842.4 | 79.0 |
| 2011-04-17 23:00:00 | YM | Futures | 11842.4 | 11842.4 | 11838.5 | 11840.5 | 18.0 |
| 2011-04-17 23:30:00 | YM | Futures | 11841.4 | 11841.4 | 11831.8 | 11831.8 | 81.0 |
| 2011-04-17 18:00:00 | CL | Futures | 190.71 | 190.73 | 190.1 | 190.17 | 735.0 |
| 2011-04-17 18:30:00 | CL | Futures | 190.17 | 190.45 | 190.17 | 190.17 | 256.0 |
| 2011-04-17 19:00:00 | CL | Futures | 190.17 | 190.31 | 190.15 | 190.22 | 100.0 |
| 2011-04-17 19:30:00 | CL | Futures | 190.24 | 190.43 | 190.17 | 190.43 | 224.0 |
| 2011-04-17 20:00:00 | CL | Futures | 190.41 | 190.45 | 190.12 | 190.14 | 228.0 |
| 2011-04-17 20:30:00 | CL | Futures | 190.12 | 190.26 | 189.76 | 189.76 | 623.0 |
| 2011-04-17 21:00:00 | CL | Futures | 189.76 | 189.91 | 189.43 | 189.51 | 1258.0 |
| 2011-04-17 21:30:00 | CL | Futures | 189.51 | 189.89 | 189.43 | 189.67 | 480.0 |
| 2011-04-17 22:00:00 | CL | Futures | 189.67 | 189.98 | 189.67 | 189.83 | 376.0 |
| 2011-04-17 22:30:00 | CL | Futures | 189.84 | 190.05 | 189.83 | 190.03 | 148.0 |
| 2011-04-17 23:00:00 | CL | Futures | 190.03 | 190.28 | 190.02 | 190.14 | 310.0 |
| 2011-04-17 23:30:00 | CL | Futures | 190.14 | 190.17 | 189.95 | 189.96 | 174.0 |
| 2011-04-17 18:00:00 | GC | Futures | 2076.9 | 2077.2 | 2074.8 | 2076.0 | 905.0 |
| 2011-04-17 18:30:00 | GC | Futures | 2076.2 | 2076.3 | 2074.8 | 2074.8 | 258.0 |
> showing 50 of 489 rows — these rows as CSV