PREVIEW / futures_30min / 2018-12-16
file: by_date/futures_30min/2018/2018-12-16.parquet size: 22 KB rows: 618
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 |
|---|---|---|---|---|---|---|---|
| 2018-12-16 18:00:00 | ES | Futures | 2819.59 | 2829.91 | 2819.59 | 2827.47 | 4541.0 |
| 2018-12-16 18:30:00 | ES | Futures | 2827.47 | 2834.26 | 2826.92 | 2833.71 | 2415.0 |
| 2018-12-16 19:00:00 | ES | Futures | 2833.71 | 2835.34 | 2830.73 | 2835.34 | 3091.0 |
| 2018-12-16 19:30:00 | ES | Futures | 2835.61 | 2836.97 | 2833.17 | 2833.98 | 3105.0 |
| 2018-12-16 20:00:00 | ES | Futures | 2833.98 | 2837.24 | 2833.98 | 2835.89 | 2025.0 |
| 2018-12-16 20:30:00 | ES | Futures | 2835.89 | 2842.13 | 2834.53 | 2838.6 | 5958.0 |
| 2018-12-16 21:00:00 | ES | Futures | 2838.33 | 2841.05 | 2836.43 | 2839.69 | 5410.0 |
| 2018-12-16 21:30:00 | ES | Futures | 2839.69 | 2842.68 | 2839.15 | 2841.86 | 2753.0 |
| 2018-12-16 22:00:00 | ES | Futures | 2841.59 | 2842.13 | 2839.69 | 2839.96 | 2226.0 |
| 2018-12-16 22:30:00 | ES | Futures | 2839.96 | 2839.96 | 2837.24 | 2838.33 | 2258.0 |
| 2018-12-16 23:00:00 | ES | Futures | 2838.33 | 2839.42 | 2837.52 | 2838.6 | 1199.0 |
| 2018-12-16 23:30:00 | ES | Futures | 2838.6 | 2840.5 | 2838.33 | 2840.23 | 1106.0 |
| 2018-12-16 18:00:00 | NQ | Futures | 7712.92 | 7745.65 | 7711.46 | 7735.13 | 1210.0 |
| 2018-12-16 18:30:00 | NQ | Futures | 7734.84 | 7755.0 | 7734.54 | 7755.0 | 801.0 |
| 2018-12-16 19:00:00 | NQ | Futures | 7754.41 | 7761.72 | 7750.32 | 7761.72 | 781.0 |
| 2018-12-16 19:30:00 | NQ | Futures | 7761.13 | 7766.39 | 7754.12 | 7754.7 | 987.0 |
| 2018-12-16 20:00:00 | NQ | Futures | 7755.0 | 7762.89 | 7755.0 | 7760.55 | 599.0 |
| 2018-12-16 20:30:00 | NQ | Futures | 7760.84 | 7777.5 | 7757.33 | 7766.68 | 2370.0 |
| 2018-12-16 21:00:00 | NQ | Futures | 7766.39 | 7774.28 | 7760.55 | 7770.19 | 2273.0 |
| 2018-12-16 21:30:00 | NQ | Futures | 7769.9 | 7779.25 | 7768.73 | 7777.5 | 1519.0 |
| 2018-12-16 22:00:00 | NQ | Futures | 7777.79 | 7778.96 | 7767.85 | 7771.07 | 1131.0 |
| 2018-12-16 22:30:00 | NQ | Futures | 7770.78 | 7772.24 | 7765.81 | 7767.56 | 833.0 |
| 2018-12-16 23:00:00 | NQ | Futures | 7767.85 | 7770.78 | 7765.22 | 7767.56 | 497.0 |
| 2018-12-16 23:30:00 | NQ | Futures | 7768.15 | 7775.16 | 7766.68 | 7775.16 | 647.0 |
| 2018-12-16 18:00:00 | YM | Futures | 26076.5 | 26188.3 | 26068.9 | 26162.3 | 828.0 |
| 2018-12-16 18:30:00 | YM | Futures | 26160.1 | 26228.5 | 26160.1 | 26223.1 | 532.0 |
| 2018-12-16 19:00:00 | YM | Futures | 26223.1 | 26245.9 | 26198.1 | 26245.9 | 497.0 |
| 2018-12-16 19:30:00 | YM | Futures | 26247.0 | 26265.4 | 26233.9 | 26243.7 | 879.0 |
| 2018-12-16 20:00:00 | YM | Futures | 26241.5 | 26269.8 | 26239.4 | 26260.0 | 510.0 |
| 2018-12-16 20:30:00 | YM | Futures | 26262.2 | 26318.6 | 26249.1 | 26282.8 | 1657.0 |
| 2018-12-16 21:00:00 | YM | Futures | 26279.5 | 26296.9 | 26253.5 | 26285.0 | 1937.0 |
| 2018-12-16 21:30:00 | YM | Futures | 26282.8 | 26312.1 | 26280.6 | 26301.2 | 563.0 |
| 2018-12-16 22:00:00 | YM | Futures | 26299.1 | 26304.5 | 26279.5 | 26280.6 | 599.0 |
| 2018-12-16 22:30:00 | YM | Futures | 26281.7 | 26282.8 | 26257.8 | 26264.3 | 705.0 |
| 2018-12-16 23:00:00 | YM | Futures | 26266.5 | 26274.1 | 26254.6 | 26263.2 | 359.0 |
| 2018-12-16 23:30:00 | YM | Futures | 26263.2 | 26291.5 | 26261.1 | 26291.5 | 470.0 |
| 2018-12-16 18:00:00 | CL | Futures | 47.03 | 47.14 | 47.03 | 47.12 | 685.0 |
| 2018-12-16 18:30:00 | CL | Futures | 47.11 | 47.16 | 47.05 | 47.08 | 365.0 |
| 2018-12-16 19:00:00 | CL | Futures | 47.09 | 47.24 | 46.98 | 47.2 | 1015.0 |
| 2018-12-16 19:30:00 | CL | Futures | 47.21 | 47.22 | 47.15 | 47.2 | 845.0 |
| 2018-12-16 20:00:00 | CL | Futures | 47.19 | 47.26 | 47.17 | 47.2 | 1184.0 |
| 2018-12-16 20:30:00 | CL | Futures | 47.19 | 47.24 | 47.04 | 47.07 | 2702.0 |
| 2018-12-16 21:00:00 | CL | Futures | 47.06 | 47.08 | 46.93 | 47.04 | 2691.0 |
| 2018-12-16 21:30:00 | CL | Futures | 47.03 | 47.13 | 47.01 | 47.08 | 1658.0 |
| 2018-12-16 22:00:00 | CL | Futures | 47.08 | 47.14 | 47.08 | 47.13 | 891.0 |
| 2018-12-16 22:30:00 | CL | Futures | 47.13 | 47.14 | 47.04 | 47.06 | 1134.0 |
| 2018-12-16 23:00:00 | CL | Futures | 47.07 | 47.13 | 47.06 | 47.13 | 588.0 |
| 2018-12-16 23:30:00 | CL | Futures | 47.12 | 47.17 | 47.12 | 47.16 | 1033.0 |
| 2018-12-16 18:00:00 | GC | Futures | 1610.0 | 1610.1 | 1606.1 | 1607.9 | 1554.0 |
| 2018-12-16 18:30:00 | GC | Futures | 1607.9 | 1608.7 | 1607.3 | 1607.5 | 569.0 |
> showing 50 of 618 rows — these rows as CSV