PREVIEW / futures_30min / 2011-11-06
file: by_date/futures_30min/2011/2011-11-06.parquet size: 20 KB rows: 521
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-11-06 18:00:00 | ES | Futures | 1257.05 | 1263.32 | 1256.8 | 1260.06 | 12727.0 |
| 2011-11-06 18:30:00 | ES | Futures | 1260.31 | 1260.56 | 1255.29 | 1257.55 | 6882.0 |
| 2011-11-06 19:00:00 | ES | Futures | 1257.55 | 1258.3 | 1256.05 | 1256.8 | 4700.0 |
| 2011-11-06 19:30:00 | ES | Futures | 1256.8 | 1257.55 | 1255.04 | 1256.05 | 2728.0 |
| 2011-11-06 20:00:00 | ES | Futures | 1256.3 | 1258.05 | 1253.29 | 1253.54 | 4131.0 |
| 2011-11-06 20:30:00 | ES | Futures | 1254.04 | 1254.04 | 1250.28 | 1252.54 | 4931.0 |
| 2011-11-06 21:00:00 | ES | Futures | 1252.29 | 1255.55 | 1250.28 | 1255.29 | 4005.0 |
| 2011-11-06 21:30:00 | ES | Futures | 1255.29 | 1255.55 | 1252.79 | 1253.04 | 1650.0 |
| 2011-11-06 22:00:00 | ES | Futures | 1252.79 | 1253.54 | 1251.53 | 1252.79 | 1666.0 |
| 2011-11-06 22:30:00 | ES | Futures | 1253.04 | 1254.04 | 1252.03 | 1252.79 | 2158.0 |
| 2011-11-06 23:00:00 | ES | Futures | 1253.04 | 1253.54 | 1252.54 | 1253.29 | 386.0 |
| 2011-11-06 23:30:00 | ES | Futures | 1253.54 | 1253.79 | 1251.28 | 1253.54 | 1498.0 |
| 2011-11-06 18:00:00 | NQ | Futures | 2717.73 | 2728.68 | 2717.73 | 2725.8 | 584.0 |
| 2011-11-06 18:30:00 | NQ | Futures | 2725.8 | 2725.8 | 2714.84 | 2718.59 | 459.0 |
| 2011-11-06 19:00:00 | NQ | Futures | 2718.59 | 2721.48 | 2716.0 | 2718.3 | 284.0 |
| 2011-11-06 19:30:00 | NQ | Futures | 2718.3 | 2720.32 | 2716.29 | 2717.73 | 272.0 |
| 2011-11-06 20:00:00 | NQ | Futures | 2718.3 | 2721.19 | 2710.52 | 2711.67 | 416.0 |
| 2011-11-06 20:30:00 | NQ | Futures | 2711.1 | 2712.54 | 2705.33 | 2708.79 | 514.0 |
| 2011-11-06 21:00:00 | NQ | Futures | 2707.92 | 2714.27 | 2705.62 | 2714.27 | 306.0 |
| 2011-11-06 21:30:00 | NQ | Futures | 2713.69 | 2713.98 | 2709.37 | 2710.23 | 77.0 |
| 2011-11-06 22:00:00 | NQ | Futures | 2710.23 | 2711.38 | 2706.19 | 2710.23 | 194.0 |
| 2011-11-06 22:30:00 | NQ | Futures | 2710.81 | 2712.83 | 2708.5 | 2711.1 | 183.0 |
| 2011-11-06 23:00:00 | NQ | Futures | 2710.52 | 2711.96 | 2709.94 | 2711.38 | 77.0 |
| 2011-11-06 23:30:00 | NQ | Futures | 2711.96 | 2712.25 | 2707.35 | 2711.67 | 121.0 |
| 2011-11-06 18:00:00 | YM | Futures | 11773.4 | 11832.4 | 11773.4 | 11807.8 | 374.0 |
| 2011-11-06 18:30:00 | YM | Futures | 11807.8 | 11808.8 | 11767.5 | 11783.2 | 363.0 |
| 2011-11-06 19:00:00 | YM | Futures | 11783.2 | 11790.1 | 11772.4 | 11777.3 | 274.0 |
| 2011-11-06 19:30:00 | YM | Futures | 11772.4 | 11780.3 | 11764.5 | 11771.4 | 213.0 |
| 2011-11-06 20:00:00 | YM | Futures | 11771.4 | 11784.2 | 11748.8 | 11753.7 | 313.0 |
| 2011-11-06 20:30:00 | YM | Futures | 11750.7 | 11756.6 | 11721.2 | 11741.9 | 454.0 |
| 2011-11-06 21:00:00 | YM | Futures | 11740.9 | 11765.5 | 11725.1 | 11765.5 | 299.0 |
| 2011-11-06 21:30:00 | YM | Futures | 11765.5 | 11765.5 | 11742.9 | 11746.8 | 127.0 |
| 2011-11-06 22:00:00 | YM | Futures | 11746.8 | 11750.7 | 11733.0 | 11747.8 | 218.0 |
| 2011-11-06 22:30:00 | YM | Futures | 11745.8 | 11754.7 | 11736.9 | 11744.8 | 271.0 |
| 2011-11-06 23:00:00 | YM | Futures | 11745.8 | 11749.7 | 11741.9 | 11749.7 | 105.0 |
| 2011-11-06 23:30:00 | YM | Futures | 11750.7 | 11753.7 | 11735.0 | 11752.7 | 233.0 |
| 2011-11-06 18:00:00 | CL | Futures | 159.25 | 159.75 | 159.21 | 159.67 | 828.0 |
| 2011-11-06 18:30:00 | CL | Futures | 159.67 | 159.75 | 159.3 | 159.65 | 584.0 |
| 2011-11-06 19:00:00 | CL | Futures | 159.67 | 159.74 | 159.5 | 159.65 | 232.0 |
| 2011-11-06 19:30:00 | CL | Futures | 159.64 | 160.06 | 159.58 | 159.85 | 758.0 |
| 2011-11-06 20:00:00 | CL | Futures | 159.84 | 159.92 | 159.37 | 159.48 | 413.0 |
| 2011-11-06 20:30:00 | CL | Futures | 159.47 | 159.6 | 159.08 | 159.4 | 730.0 |
| 2011-11-06 21:00:00 | CL | Futures | 159.4 | 160.16 | 159.4 | 160.12 | 1045.0 |
| 2011-11-06 21:30:00 | CL | Futures | 160.12 | 160.19 | 159.87 | 159.97 | 401.0 |
| 2011-11-06 22:00:00 | CL | Futures | 159.96 | 160.04 | 159.69 | 160.01 | 360.0 |
| 2011-11-06 22:30:00 | CL | Futures | 159.96 | 160.09 | 159.72 | 159.75 | 307.0 |
| 2011-11-06 23:00:00 | CL | Futures | 159.75 | 159.84 | 159.45 | 159.69 | 285.0 |
| 2011-11-06 23:30:00 | CL | Futures | 159.69 | 159.7 | 159.5 | 159.7 | 177.0 |
| 2011-11-06 18:00:00 | GC | Futures | 2444.3 | 2452.6 | 2442.6 | 2451.2 | 829.0 |
| 2011-11-06 18:30:00 | GC | Futures | 2451.5 | 2452.8 | 2447.5 | 2448.0 | 648.0 |
> showing 50 of 521 rows — these rows as CSV