PREVIEW / futures_30min / 2012-06-17
file: by_date/futures_30min/2012/2012-06-17.parquet size: 20 KB rows: 517
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 |
|---|---|---|---|---|---|---|---|
| 2012-06-17 18:00:00 | ES | Futures | 1368.3 | 1370.59 | 1366.26 | 1369.82 | 28472.0 |
| 2012-06-17 18:30:00 | ES | Futures | 1369.82 | 1370.59 | 1362.7 | 1364.23 | 12277.0 |
| 2012-06-17 19:00:00 | ES | Futures | 1364.48 | 1366.77 | 1364.23 | 1366.52 | 4736.0 |
| 2012-06-17 19:30:00 | ES | Futures | 1366.26 | 1367.79 | 1365.76 | 1367.03 | 3614.0 |
| 2012-06-17 20:00:00 | ES | Futures | 1366.77 | 1370.08 | 1366.77 | 1368.81 | 7019.0 |
| 2012-06-17 20:30:00 | ES | Futures | 1368.55 | 1370.08 | 1368.3 | 1369.32 | 4647.0 |
| 2012-06-17 21:00:00 | ES | Futures | 1369.32 | 1369.57 | 1366.01 | 1366.01 | 6838.0 |
| 2012-06-17 21:30:00 | ES | Futures | 1366.01 | 1366.52 | 1363.98 | 1364.74 | 6760.0 |
| 2012-06-17 22:00:00 | ES | Futures | 1364.74 | 1366.77 | 1364.74 | 1365.5 | 3601.0 |
| 2012-06-17 22:30:00 | ES | Futures | 1365.5 | 1367.03 | 1365.25 | 1366.01 | 2165.0 |
| 2012-06-17 23:00:00 | ES | Futures | 1366.01 | 1367.54 | 1365.76 | 1367.28 | 2380.0 |
| 2012-06-17 23:30:00 | ES | Futures | 1367.28 | 1368.55 | 1366.77 | 1367.28 | 2547.0 |
| 2012-06-17 18:00:00 | NQ | Futures | 2991.9 | 2997.99 | 2987.55 | 2996.25 | 2135.0 |
| 2012-06-17 18:30:00 | NQ | Futures | 2996.25 | 2998.57 | 2981.76 | 2985.82 | 1404.0 |
| 2012-06-17 19:00:00 | NQ | Futures | 2985.82 | 2990.45 | 2984.95 | 2987.26 | 435.0 |
| 2012-06-17 19:30:00 | NQ | Futures | 2986.97 | 2990.74 | 2985.82 | 2988.71 | 309.0 |
| 2012-06-17 20:00:00 | NQ | Futures | 2989.29 | 2995.67 | 2989.0 | 2992.77 | 394.0 |
| 2012-06-17 20:30:00 | NQ | Futures | 2992.77 | 2995.96 | 2991.9 | 2995.09 | 254.0 |
| 2012-06-17 21:00:00 | NQ | Futures | 2994.8 | 2995.09 | 2987.26 | 2987.55 | 398.0 |
| 2012-06-17 21:30:00 | NQ | Futures | 2987.55 | 2987.84 | 2984.66 | 2986.68 | 421.0 |
| 2012-06-17 22:00:00 | NQ | Futures | 2986.39 | 2987.84 | 2985.82 | 2986.39 | 372.0 |
| 2012-06-17 22:30:00 | NQ | Futures | 2986.1 | 2989.29 | 2985.24 | 2986.39 | 273.0 |
| 2012-06-17 23:00:00 | NQ | Futures | 2986.1 | 2990.45 | 2985.82 | 2989.87 | 294.0 |
| 2012-06-17 23:30:00 | NQ | Futures | 2990.16 | 2991.9 | 2989.29 | 2989.87 | 207.0 |
| 2012-06-17 18:00:00 | YM | Futures | 12706.5 | 12731.3 | 12692.6 | 12721.4 | 1785.0 |
| 2012-06-17 18:30:00 | YM | Futures | 12723.4 | 12729.3 | 12671.7 | 12679.6 | 1155.0 |
| 2012-06-17 19:00:00 | YM | Futures | 12679.6 | 12702.5 | 12679.6 | 12696.5 | 367.0 |
| 2012-06-17 19:30:00 | YM | Futures | 12697.5 | 12710.5 | 12694.5 | 12702.5 | 159.0 |
| 2012-06-17 20:00:00 | YM | Futures | 12702.5 | 12726.4 | 12702.5 | 12715.4 | 337.0 |
| 2012-06-17 20:30:00 | YM | Futures | 12714.4 | 12725.4 | 12711.4 | 12718.4 | 164.0 |
| 2012-06-17 21:00:00 | YM | Futures | 12720.4 | 12720.4 | 12696.5 | 12696.5 | 315.0 |
| 2012-06-17 21:30:00 | YM | Futures | 12697.5 | 12698.5 | 12682.6 | 12689.6 | 430.0 |
| 2012-06-17 22:00:00 | YM | Futures | 12689.6 | 12700.5 | 12687.6 | 12692.6 | 225.0 |
| 2012-06-17 22:30:00 | YM | Futures | 12692.6 | 12701.5 | 12689.6 | 12694.5 | 176.0 |
| 2012-06-17 23:00:00 | YM | Futures | 12692.6 | 12705.5 | 12690.6 | 12703.5 | 166.0 |
| 2012-06-17 23:30:00 | YM | Futures | 12704.5 | 12710.5 | 12699.5 | 12701.5 | 307.0 |
| 2012-06-17 18:00:00 | CL | Futures | 141.12 | 141.76 | 140.77 | 141.33 | 1466.0 |
| 2012-06-17 18:30:00 | CL | Futures | 141.18 | 141.18 | 139.86 | 140.24 | 790.0 |
| 2012-06-17 19:00:00 | CL | Futures | 140.21 | 140.62 | 140.21 | 140.32 | 426.0 |
| 2012-06-17 19:30:00 | CL | Futures | 140.34 | 140.55 | 140.32 | 140.46 | 341.0 |
| 2012-06-17 20:00:00 | CL | Futures | 140.46 | 140.93 | 140.46 | 140.84 | 554.0 |
| 2012-06-17 20:30:00 | CL | Futures | 140.82 | 141.13 | 140.77 | 141.05 | 600.0 |
| 2012-06-17 21:00:00 | CL | Futures | 141.05 | 141.05 | 140.62 | 140.72 | 659.0 |
| 2012-06-17 21:30:00 | CL | Futures | 140.7 | 140.82 | 140.54 | 140.57 | 361.0 |
| 2012-06-17 22:00:00 | CL | Futures | 140.59 | 140.69 | 140.52 | 140.54 | 248.0 |
| 2012-06-17 22:30:00 | CL | Futures | 140.55 | 140.77 | 140.46 | 140.62 | 330.0 |
| 2012-06-17 23:00:00 | CL | Futures | 140.54 | 140.69 | 140.47 | 140.69 | 182.0 |
| 2012-06-17 23:30:00 | CL | Futures | 140.67 | 140.74 | 140.47 | 140.47 | 121.0 |
| 2012-06-17 18:00:00 | GC | Futures | 2255.5 | 2257.3 | 2243.8 | 2245.4 | 2683.0 |
| 2012-06-17 18:30:00 | GC | Futures | 2245.6 | 2247.2 | 2223.6 | 2237.5 | 4065.0 |
> showing 50 of 517 rows — these rows as CSV