PREVIEW / futures_30min / 2016-06-05
file: by_date/futures_30min/2016/2016-06-05.parquet size: 20 KB rows: 519
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 |
|---|---|---|---|---|---|---|---|
| 2016-06-05 18:00:00 | ES | Futures | 2265.13 | 2267.02 | 2264.59 | 2266.48 | 4120.0 |
| 2016-06-05 18:30:00 | ES | Futures | 2266.75 | 2266.75 | 2265.67 | 2265.94 | 712.0 |
| 2016-06-05 19:00:00 | ES | Futures | 2266.21 | 2266.21 | 2263.78 | 2264.05 | 4473.0 |
| 2016-06-05 19:30:00 | ES | Futures | 2264.05 | 2264.32 | 2261.35 | 2262.7 | 5775.0 |
| 2016-06-05 20:00:00 | ES | Futures | 2262.43 | 2264.05 | 2261.62 | 2262.43 | 4475.0 |
| 2016-06-05 20:30:00 | ES | Futures | 2262.43 | 2263.24 | 2262.16 | 2262.7 | 2305.0 |
| 2016-06-05 21:00:00 | ES | Futures | 2262.7 | 2264.59 | 2262.16 | 2264.05 | 3124.0 |
| 2016-06-05 21:30:00 | ES | Futures | 2264.05 | 2264.32 | 2262.97 | 2263.51 | 2685.0 |
| 2016-06-05 22:00:00 | ES | Futures | 2263.78 | 2264.05 | 2262.97 | 2263.51 | 1333.0 |
| 2016-06-05 22:30:00 | ES | Futures | 2263.24 | 2263.78 | 2263.24 | 2263.51 | 1255.0 |
| 2016-06-05 23:00:00 | ES | Futures | 2263.51 | 2264.59 | 2263.51 | 2264.59 | 1756.0 |
| 2016-06-05 23:30:00 | ES | Futures | 2264.59 | 2265.13 | 2263.78 | 2264.86 | 2208.0 |
| 2016-06-05 18:00:00 | NQ | Futures | 5368.63 | 5370.71 | 5366.25 | 5370.11 | 958.0 |
| 2016-06-05 18:30:00 | NQ | Futures | 5370.41 | 5370.41 | 5368.03 | 5368.92 | 114.0 |
| 2016-06-05 19:00:00 | NQ | Futures | 5368.63 | 5369.22 | 5365.35 | 5366.25 | 714.0 |
| 2016-06-05 19:30:00 | NQ | Futures | 5365.95 | 5365.95 | 5360.3 | 5362.97 | 577.0 |
| 2016-06-05 20:00:00 | NQ | Futures | 5362.97 | 5367.44 | 5361.78 | 5363.27 | 470.0 |
| 2016-06-05 20:30:00 | NQ | Futures | 5363.27 | 5365.06 | 5362.38 | 5363.87 | 164.0 |
| 2016-06-05 21:00:00 | NQ | Futures | 5363.87 | 5368.92 | 5362.97 | 5368.33 | 309.0 |
| 2016-06-05 21:30:00 | NQ | Futures | 5368.33 | 5368.33 | 5363.57 | 5365.65 | 477.0 |
| 2016-06-05 22:00:00 | NQ | Futures | 5366.54 | 5367.14 | 5363.57 | 5364.46 | 170.0 |
| 2016-06-05 22:30:00 | NQ | Futures | 5364.46 | 5365.95 | 5363.57 | 5364.76 | 243.0 |
| 2016-06-05 23:00:00 | NQ | Futures | 5365.06 | 5367.44 | 5365.06 | 5366.84 | 117.0 |
| 2016-06-05 23:30:00 | NQ | Futures | 5366.84 | 5370.71 | 5366.84 | 5370.41 | 359.0 |
| 2016-06-05 18:00:00 | YM | Futures | 19061.5 | 19069.0 | 19054.0 | 19064.7 | 288.0 |
| 2016-06-05 18:30:00 | YM | Futures | 19062.6 | 19066.9 | 19061.5 | 19065.8 | 279.0 |
| 2016-06-05 19:00:00 | YM | Futures | 19065.8 | 19065.8 | 19048.7 | 19049.7 | 909.0 |
| 2016-06-05 19:30:00 | YM | Futures | 19049.7 | 19050.8 | 19030.5 | 19034.7 | 788.0 |
| 2016-06-05 20:00:00 | YM | Futures | 19034.7 | 19048.7 | 19031.5 | 19039.0 | 727.0 |
| 2016-06-05 20:30:00 | YM | Futures | 19038.0 | 19041.2 | 19033.7 | 19039.0 | 241.0 |
| 2016-06-05 21:00:00 | YM | Futures | 19038.0 | 19052.9 | 19035.8 | 19049.7 | 387.0 |
| 2016-06-05 21:30:00 | YM | Futures | 19050.8 | 19050.8 | 19038.0 | 19047.6 | 429.0 |
| 2016-06-05 22:00:00 | YM | Futures | 19046.5 | 19049.7 | 19040.1 | 19042.2 | 299.0 |
| 2016-06-05 22:30:00 | YM | Futures | 19042.2 | 19044.4 | 19040.1 | 19044.4 | 183.0 |
| 2016-06-05 23:00:00 | YM | Futures | 19044.4 | 19052.9 | 19043.3 | 19049.7 | 218.0 |
| 2016-06-05 23:30:00 | YM | Futures | 19049.7 | 19058.3 | 19046.5 | 19055.1 | 328.0 |
| 2016-06-05 18:00:00 | CL | Futures | 51.86 | 51.95 | 51.78 | 51.87 | 920.0 |
| 2016-06-05 18:30:00 | CL | Futures | 51.87 | 51.88 | 51.85 | 51.85 | 213.0 |
| 2016-06-05 19:00:00 | CL | Futures | 51.84 | 51.84 | 51.68 | 51.73 | 1074.0 |
| 2016-06-05 19:30:00 | CL | Futures | 51.72 | 51.78 | 51.69 | 51.73 | 802.0 |
| 2016-06-05 20:00:00 | CL | Futures | 51.74 | 51.9 | 51.74 | 51.9 | 1514.0 |
| 2016-06-05 20:30:00 | CL | Futures | 51.9 | 51.99 | 51.88 | 51.97 | 1859.0 |
| 2016-06-05 21:00:00 | CL | Futures | 51.98 | 52.16 | 51.9 | 52.13 | 4366.0 |
| 2016-06-05 21:30:00 | CL | Futures | 52.11 | 52.14 | 52.02 | 52.05 | 1816.0 |
| 2016-06-05 22:00:00 | CL | Futures | 52.06 | 52.08 | 52.01 | 52.03 | 709.0 |
| 2016-06-05 22:30:00 | CL | Futures | 52.02 | 52.06 | 52.02 | 52.05 | 408.0 |
| 2016-06-05 23:00:00 | CL | Futures | 52.06 | 52.08 | 52.04 | 52.06 | 522.0 |
| 2016-06-05 23:30:00 | CL | Futures | 52.06 | 52.08 | 52.04 | 52.08 | 420.0 |
| 2016-06-05 18:00:00 | GC | Futures | 1695.0 | 1699.7 | 1693.9 | 1698.9 | 3407.0 |
| 2016-06-05 18:30:00 | GC | Futures | 1698.5 | 1699.6 | 1697.3 | 1698.1 | 1284.0 |
> showing 50 of 519 rows — these rows as CSV