PREVIEW / futures_30min / 2011-12-04
file: by_date/futures_30min/2011/2011-12-04.parquet size: 18 KB rows: 467
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-12-04 18:00:00 | ES | Futures | 1251.78 | 1258.55 | 1251.78 | 1256.8 | 14075.0 |
| 2011-12-04 18:30:00 | ES | Futures | 1257.05 | 1257.3 | 1255.8 | 1255.8 | 3805.0 |
| 2011-12-04 19:00:00 | ES | Futures | 1256.05 | 1256.8 | 1254.04 | 1255.55 | 5112.0 |
| 2011-12-04 19:30:00 | ES | Futures | 1255.55 | 1255.55 | 1254.04 | 1254.54 | 2385.0 |
| 2011-12-04 20:00:00 | ES | Futures | 1254.54 | 1256.3 | 1254.29 | 1255.29 | 2986.0 |
| 2011-12-04 20:30:00 | ES | Futures | 1255.55 | 1256.3 | 1254.04 | 1255.8 | 4323.0 |
| 2011-12-04 21:00:00 | ES | Futures | 1256.05 | 1256.8 | 1255.29 | 1256.3 | 3123.0 |
| 2011-12-04 21:30:00 | ES | Futures | 1256.3 | 1257.8 | 1255.8 | 1256.3 | 4046.0 |
| 2011-12-04 22:00:00 | ES | Futures | 1256.05 | 1257.55 | 1255.8 | 1257.3 | 1517.0 |
| 2011-12-04 22:30:00 | ES | Futures | 1257.3 | 1257.55 | 1256.3 | 1256.3 | 2061.0 |
| 2011-12-04 23:00:00 | ES | Futures | 1256.55 | 1257.3 | 1256.3 | 1256.8 | 972.0 |
| 2011-12-04 23:30:00 | ES | Futures | 1256.55 | 1257.55 | 1256.3 | 1256.55 | 2947.0 |
| 2011-12-04 18:00:00 | NQ | Futures | 2662.95 | 2676.5 | 2662.95 | 2673.33 | 918.0 |
| 2011-12-04 18:30:00 | NQ | Futures | 2673.61 | 2673.61 | 2669.29 | 2669.87 | 345.0 |
| 2011-12-04 19:00:00 | NQ | Futures | 2669.58 | 2670.73 | 2666.98 | 2668.71 | 465.0 |
| 2011-12-04 19:30:00 | NQ | Futures | 2669.0 | 2669.0 | 2667.27 | 2668.71 | 134.0 |
| 2011-12-04 20:00:00 | NQ | Futures | 2668.71 | 2670.73 | 2666.69 | 2669.87 | 258.0 |
| 2011-12-04 20:30:00 | NQ | Futures | 2668.71 | 2670.73 | 2665.83 | 2669.87 | 184.0 |
| 2011-12-04 21:00:00 | NQ | Futures | 2669.87 | 2672.75 | 2669.0 | 2671.6 | 238.0 |
| 2011-12-04 21:30:00 | NQ | Futures | 2671.6 | 2674.48 | 2670.73 | 2672.17 | 169.0 |
| 2011-12-04 22:00:00 | NQ | Futures | 2671.02 | 2672.75 | 2671.02 | 2672.46 | 136.0 |
| 2011-12-04 22:30:00 | NQ | Futures | 2672.17 | 2673.04 | 2671.02 | 2671.88 | 70.0 |
| 2011-12-04 23:00:00 | NQ | Futures | 2671.88 | 2673.33 | 2671.31 | 2671.31 | 42.0 |
| 2011-12-04 23:30:00 | NQ | Futures | 2671.6 | 2673.04 | 2670.44 | 2671.88 | 194.0 |
| 2011-12-04 18:00:00 | YM | Futures | 11849.2 | 11913.2 | 11849.2 | 11895.5 | 605.0 |
| 2011-12-04 18:30:00 | YM | Futures | 11900.4 | 11900.4 | 11885.6 | 11887.6 | 267.0 |
| 2011-12-04 19:00:00 | YM | Futures | 11888.6 | 11894.5 | 11874.8 | 11886.6 | 348.0 |
| 2011-12-04 19:30:00 | YM | Futures | 11883.6 | 11883.6 | 11870.8 | 11877.7 | 135.0 |
| 2011-12-04 20:00:00 | YM | Futures | 11877.7 | 11889.5 | 11872.8 | 11882.7 | 222.0 |
| 2011-12-04 20:30:00 | YM | Futures | 11882.7 | 11888.6 | 11870.8 | 11886.6 | 202.0 |
| 2011-12-04 21:00:00 | YM | Futures | 11884.6 | 11896.4 | 11882.7 | 11893.5 | 159.0 |
| 2011-12-04 21:30:00 | YM | Futures | 11892.5 | 11903.3 | 11871.8 | 11893.5 | 1187.0 |
| 2011-12-04 22:00:00 | YM | Futures | 11889.5 | 11898.4 | 11887.6 | 11895.5 | 157.0 |
| 2011-12-04 22:30:00 | YM | Futures | 11897.4 | 11900.4 | 11889.5 | 11891.5 | 102.0 |
| 2011-12-04 23:00:00 | YM | Futures | 11891.5 | 11897.4 | 11890.5 | 11890.5 | 85.0 |
| 2011-12-04 23:30:00 | YM | Futures | 11891.5 | 11905.3 | 11886.6 | 11896.4 | 629.0 |
| 2011-12-04 18:00:00 | CL | Futures | 171.05 | 171.89 | 171.05 | 171.6 | 1257.0 |
| 2011-12-04 18:30:00 | CL | Futures | 171.57 | 171.69 | 171.4 | 171.47 | 279.0 |
| 2011-12-04 19:00:00 | CL | Futures | 171.45 | 171.67 | 171.33 | 171.4 | 397.0 |
| 2011-12-04 19:30:00 | CL | Futures | 171.4 | 171.43 | 171.3 | 171.3 | 190.0 |
| 2011-12-04 20:00:00 | CL | Futures | 171.33 | 171.35 | 171.1 | 171.25 | 367.0 |
| 2011-12-04 20:30:00 | CL | Futures | 171.21 | 171.28 | 170.94 | 171.21 | 424.0 |
| 2011-12-04 21:00:00 | CL | Futures | 171.21 | 171.38 | 171.08 | 171.26 | 340.0 |
| 2011-12-04 21:30:00 | CL | Futures | 171.26 | 171.62 | 171.1 | 171.54 | 517.0 |
| 2011-12-04 22:00:00 | CL | Futures | 171.48 | 171.6 | 171.23 | 171.55 | 176.0 |
| 2011-12-04 22:30:00 | CL | Futures | 171.52 | 171.6 | 171.38 | 171.48 | 117.0 |
| 2011-12-04 23:00:00 | CL | Futures | 171.45 | 171.5 | 171.38 | 171.38 | 69.0 |
| 2011-12-04 23:30:00 | CL | Futures | 171.38 | 171.5 | 171.13 | 171.4 | 384.0 |
| 2011-12-04 18:00:00 | GC | Futures | 2434.7 | 2445.5 | 2434.0 | 2443.0 | 1296.0 |
| 2011-12-04 18:30:00 | GC | Futures | 2442.3 | 2444.4 | 2441.0 | 2443.9 | 302.0 |
> showing 50 of 467 rows — these rows as CSV