PREVIEW / futures_30min / 2018-12-30
file: by_date/futures_30min/2018/2018-12-30.parquet size: 21 KB rows: 554
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-30 18:00:00 | ES | Futures | 2710.96 | 2724.26 | 2710.96 | 2720.46 | 9670.0 |
| 2018-12-30 18:30:00 | ES | Futures | 2720.46 | 2721.82 | 2713.13 | 2716.66 | 3475.0 |
| 2018-12-30 19:00:00 | ES | Futures | 2716.39 | 2718.29 | 2714.22 | 2717.48 | 3334.0 |
| 2018-12-30 19:30:00 | ES | Futures | 2717.75 | 2721.01 | 2716.66 | 2719.65 | 2192.0 |
| 2018-12-30 20:00:00 | ES | Futures | 2719.38 | 2719.92 | 2715.3 | 2715.85 | 2863.0 |
| 2018-12-30 20:30:00 | ES | Futures | 2715.85 | 2717.2 | 2713.67 | 2716.93 | 3573.0 |
| 2018-12-30 21:00:00 | ES | Futures | 2716.93 | 2718.83 | 2716.12 | 2717.75 | 2388.0 |
| 2018-12-30 21:30:00 | ES | Futures | 2717.75 | 2723.45 | 2715.03 | 2721.55 | 4156.0 |
| 2018-12-30 22:00:00 | ES | Futures | 2721.55 | 2725.62 | 2719.38 | 2721.01 | 4287.0 |
| 2018-12-30 22:30:00 | ES | Futures | 2721.01 | 2721.28 | 2717.2 | 2718.02 | 2399.0 |
| 2018-12-30 23:00:00 | ES | Futures | 2718.02 | 2719.65 | 2716.39 | 2718.29 | 3705.0 |
| 2018-12-30 23:30:00 | ES | Futures | 2718.02 | 2720.19 | 2716.93 | 2718.02 | 2200.0 |
| 2018-12-30 18:00:00 | NQ | Futures | 7377.49 | 7429.21 | 7376.61 | 7421.61 | 4520.0 |
| 2018-12-30 18:30:00 | NQ | Futures | 7421.61 | 7426.87 | 7403.2 | 7413.14 | 1804.0 |
| 2018-12-30 19:00:00 | NQ | Futures | 7412.55 | 7421.32 | 7407.0 | 7418.69 | 1391.0 |
| 2018-12-30 19:30:00 | NQ | Futures | 7419.27 | 7424.82 | 7414.6 | 7421.61 | 1117.0 |
| 2018-12-30 20:00:00 | NQ | Futures | 7421.32 | 7423.65 | 7412.84 | 7414.3 | 1165.0 |
| 2018-12-30 20:30:00 | NQ | Futures | 7413.14 | 7414.01 | 7404.08 | 7411.38 | 1686.0 |
| 2018-12-30 21:00:00 | NQ | Futures | 7411.97 | 7417.52 | 7407.58 | 7414.3 | 1125.0 |
| 2018-12-30 21:30:00 | NQ | Futures | 7414.3 | 7428.62 | 7404.95 | 7423.65 | 2025.0 |
| 2018-12-30 22:00:00 | NQ | Futures | 7424.24 | 7435.63 | 7420.15 | 7423.65 | 2008.0 |
| 2018-12-30 22:30:00 | NQ | Futures | 7423.65 | 7426.28 | 7414.01 | 7416.06 | 1187.0 |
| 2018-12-30 23:00:00 | NQ | Futures | 7416.93 | 7424.82 | 7413.72 | 7416.35 | 1844.0 |
| 2018-12-30 23:30:00 | NQ | Futures | 7416.06 | 7422.19 | 7414.3 | 7416.64 | 881.0 |
| 2018-12-30 18:00:00 | YM | Futures | 25116.7 | 25234.0 | 25104.8 | 25203.6 | 2060.0 |
| 2018-12-30 18:30:00 | YM | Futures | 25203.6 | 25212.3 | 25141.7 | 25161.3 | 862.0 |
| 2018-12-30 19:00:00 | YM | Futures | 25164.5 | 25183.0 | 25143.9 | 25179.7 | 803.0 |
| 2018-12-30 19:30:00 | YM | Futures | 25179.7 | 25214.5 | 25171.0 | 25204.7 | 875.0 |
| 2018-12-30 20:00:00 | YM | Futures | 25201.4 | 25210.1 | 25161.3 | 25165.6 | 1066.0 |
| 2018-12-30 20:30:00 | YM | Futures | 25163.4 | 25183.0 | 25150.4 | 25179.7 | 882.0 |
| 2018-12-30 21:00:00 | YM | Futures | 25179.7 | 25192.7 | 25167.8 | 25185.1 | 778.0 |
| 2018-12-30 21:30:00 | YM | Futures | 25185.1 | 25247.0 | 25161.3 | 25229.7 | 1468.0 |
| 2018-12-30 22:00:00 | YM | Futures | 25230.7 | 25261.1 | 25206.9 | 25221.0 | 1407.0 |
| 2018-12-30 22:30:00 | YM | Futures | 25223.1 | 25226.4 | 25190.6 | 25199.3 | 665.0 |
| 2018-12-30 23:00:00 | YM | Futures | 25199.3 | 25212.3 | 25180.8 | 25200.3 | 1094.0 |
| 2018-12-30 23:30:00 | YM | Futures | 25197.1 | 25218.8 | 25188.4 | 25199.3 | 669.0 |
| 2018-12-30 18:00:00 | CL | Futures | 41.28 | 41.63 | 41.28 | 41.57 | 2741.0 |
| 2018-12-30 18:30:00 | CL | Futures | 41.57 | 41.61 | 41.48 | 41.53 | 1107.0 |
| 2018-12-30 19:00:00 | CL | Futures | 41.52 | 41.59 | 41.49 | 41.53 | 1364.0 |
| 2018-12-30 19:30:00 | CL | Futures | 41.54 | 41.6 | 41.52 | 41.59 | 1109.0 |
| 2018-12-30 20:00:00 | CL | Futures | 41.59 | 41.6 | 41.49 | 41.49 | 1432.0 |
| 2018-12-30 20:30:00 | CL | Futures | 41.5 | 41.5 | 41.39 | 41.47 | 2211.0 |
| 2018-12-30 21:00:00 | CL | Futures | 41.47 | 41.5 | 41.45 | 41.49 | 1215.0 |
| 2018-12-30 21:30:00 | CL | Futures | 41.49 | 41.85 | 41.48 | 41.78 | 5960.0 |
| 2018-12-30 22:00:00 | CL | Futures | 41.77 | 41.91 | 41.7 | 41.78 | 5334.0 |
| 2018-12-30 22:30:00 | CL | Futures | 41.79 | 41.8 | 41.71 | 41.74 | 1725.0 |
| 2018-12-30 23:00:00 | CL | Futures | 41.74 | 41.88 | 41.73 | 41.86 | 2705.0 |
| 2018-12-30 23:30:00 | CL | Futures | 41.86 | 41.9 | 41.79 | 41.84 | 1812.0 |
| 2018-12-30 18:00:00 | GC | Futures | 1662.1 | 1662.7 | 1660.0 | 1660.0 | 1092.0 |
| 2018-12-30 18:30:00 | GC | Futures | 1660.1 | 1660.9 | 1659.7 | 1660.9 | 600.0 |
> showing 50 of 554 rows — these rows as CSV