PREVIEW / futures_30min / 2018-11-25
file: by_date/futures_30min/2018/2018-11-25.parquet size: 22 KB rows: 586
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-11-25 18:00:00 | ES | Futures | 2865.23 | 2871.76 | 2863.05 | 2869.04 | 10925.0 |
| 2018-11-25 18:30:00 | ES | Futures | 2869.31 | 2871.21 | 2869.04 | 2870.13 | 2943.0 |
| 2018-11-25 19:00:00 | ES | Futures | 2870.13 | 2875.02 | 2867.95 | 2868.49 | 8401.0 |
| 2018-11-25 19:30:00 | ES | Futures | 2868.49 | 2869.85 | 2867.68 | 2868.77 | 2301.0 |
| 2018-11-25 20:00:00 | ES | Futures | 2868.77 | 2873.93 | 2867.95 | 2871.76 | 4335.0 |
| 2018-11-25 20:30:00 | ES | Futures | 2871.76 | 2873.12 | 2868.77 | 2870.94 | 5263.0 |
| 2018-11-25 21:00:00 | ES | Futures | 2870.94 | 2874.48 | 2869.31 | 2873.39 | 4581.0 |
| 2018-11-25 21:30:00 | ES | Futures | 2873.39 | 2874.21 | 2871.21 | 2872.57 | 2906.0 |
| 2018-11-25 22:00:00 | ES | Futures | 2872.3 | 2877.2 | 2872.03 | 2875.57 | 5357.0 |
| 2018-11-25 22:30:00 | ES | Futures | 2875.57 | 2876.65 | 2875.02 | 2875.57 | 2849.0 |
| 2018-11-25 23:00:00 | ES | Futures | 2875.57 | 2876.65 | 2874.48 | 2876.11 | 2280.0 |
| 2018-11-25 23:30:00 | ES | Futures | 2876.11 | 2876.93 | 2875.57 | 2876.93 | 1361.0 |
| 2018-11-25 18:00:00 | NQ | Futures | 7670.16 | 7693.34 | 7661.95 | 7687.18 | 6457.0 |
| 2018-11-25 18:30:00 | NQ | Futures | 7687.47 | 7691.58 | 7684.83 | 7689.23 | 1337.0 |
| 2018-11-25 19:00:00 | NQ | Futures | 7689.23 | 7703.02 | 7684.83 | 7686.59 | 3769.0 |
| 2018-11-25 19:30:00 | NQ | Futures | 7686.3 | 7690.11 | 7685.71 | 7688.64 | 1470.0 |
| 2018-11-25 20:00:00 | NQ | Futures | 7688.06 | 7702.14 | 7686.3 | 7693.34 | 2422.0 |
| 2018-11-25 20:30:00 | NQ | Futures | 7693.34 | 7701.84 | 7687.76 | 7695.39 | 2316.0 |
| 2018-11-25 21:00:00 | NQ | Futures | 7695.68 | 7707.71 | 7689.82 | 7700.67 | 1985.0 |
| 2018-11-25 21:30:00 | NQ | Futures | 7701.26 | 7704.78 | 7695.39 | 7698.62 | 1720.0 |
| 2018-11-25 22:00:00 | NQ | Futures | 7698.62 | 7712.7 | 7697.44 | 7707.42 | 2046.0 |
| 2018-11-25 22:30:00 | NQ | Futures | 7707.71 | 7712.7 | 7705.66 | 7707.71 | 1336.0 |
| 2018-11-25 23:00:00 | NQ | Futures | 7707.12 | 7716.22 | 7702.43 | 7714.75 | 2377.0 |
| 2018-11-25 23:30:00 | NQ | Futures | 7714.16 | 7715.34 | 7709.18 | 7713.87 | 739.0 |
| 2018-11-25 18:00:00 | YM | Futures | 26375.1 | 26457.7 | 26369.7 | 26427.2 | 1778.0 |
| 2018-11-25 18:30:00 | YM | Futures | 26429.4 | 26447.9 | 26421.8 | 26438.1 | 674.0 |
| 2018-11-25 19:00:00 | YM | Futures | 26438.1 | 26482.7 | 26413.1 | 26418.5 | 1848.0 |
| 2018-11-25 19:30:00 | YM | Futures | 26418.5 | 26432.7 | 26409.9 | 26421.8 | 621.0 |
| 2018-11-25 20:00:00 | YM | Futures | 26422.9 | 26475.0 | 26413.1 | 26452.2 | 1335.0 |
| 2018-11-25 20:30:00 | YM | Futures | 26452.2 | 26463.1 | 26426.2 | 26445.7 | 1276.0 |
| 2018-11-25 21:00:00 | YM | Futures | 26445.7 | 26472.9 | 26432.7 | 26463.1 | 998.0 |
| 2018-11-25 21:30:00 | YM | Futures | 26463.1 | 26470.7 | 26444.6 | 26452.2 | 709.0 |
| 2018-11-25 22:00:00 | YM | Futures | 26450.1 | 26497.9 | 26447.9 | 26489.2 | 1190.0 |
| 2018-11-25 22:30:00 | YM | Futures | 26489.2 | 26493.5 | 26480.5 | 26482.7 | 603.0 |
| 2018-11-25 23:00:00 | YM | Futures | 26482.7 | 26488.1 | 26470.7 | 26485.9 | 567.0 |
| 2018-11-25 23:30:00 | YM | Futures | 26483.7 | 26496.8 | 26477.2 | 26495.7 | 344.0 |
| 2018-11-25 18:00:00 | CL | Futures | 46.41 | 46.83 | 45.93 | 46.09 | 12310.0 |
| 2018-11-25 18:30:00 | CL | Futures | 46.09 | 46.42 | 45.99 | 46.38 | 5597.0 |
| 2018-11-25 19:00:00 | CL | Futures | 46.38 | 46.6 | 46.37 | 46.45 | 7026.0 |
| 2018-11-25 19:30:00 | CL | Futures | 46.45 | 46.71 | 46.32 | 46.55 | 5141.0 |
| 2018-11-25 20:00:00 | CL | Futures | 46.54 | 46.7 | 46.48 | 46.53 | 5017.0 |
| 2018-11-25 20:30:00 | CL | Futures | 46.53 | 46.56 | 46.33 | 46.43 | 4292.0 |
| 2018-11-25 21:00:00 | CL | Futures | 46.43 | 46.54 | 46.17 | 46.54 | 8037.0 |
| 2018-11-25 21:30:00 | CL | Futures | 46.53 | 46.62 | 46.42 | 46.5 | 4034.0 |
| 2018-11-25 22:00:00 | CL | Futures | 46.51 | 46.64 | 46.47 | 46.57 | 3582.0 |
| 2018-11-25 22:30:00 | CL | Futures | 46.58 | 46.61 | 46.49 | 46.5 | 1612.0 |
| 2018-11-25 23:00:00 | CL | Futures | 46.5 | 46.7 | 46.47 | 46.67 | 3803.0 |
| 2018-11-25 23:30:00 | CL | Futures | 46.68 | 46.71 | 46.62 | 46.7 | 2704.0 |
| 2018-11-25 18:00:00 | GC | Futures | 1593.9 | 1593.9 | 1592.7 | 1593.4 | 376.0 |
| 2018-11-25 18:30:00 | GC | Futures | 1593.3 | 1594.3 | 1593.1 | 1594.2 | 204.0 |
> showing 50 of 586 rows — these rows as CSV