PREVIEW / futures_30min / 2018-07-16
file: by_date/futures_30min/2018/2018-07-16.parquet size: 81 KB rows: 3,089
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-07-16 00:00:00 | ES | Futures | 3057.89 | 3057.89 | 3057.34 | 3057.62 | 339.0 |
| 2018-07-16 00:30:00 | ES | Futures | 3057.34 | 3057.62 | 3057.07 | 3057.62 | 489.0 |
| 2018-07-16 01:00:00 | ES | Futures | 3057.62 | 3057.89 | 3056.53 | 3056.8 | 1148.0 |
| 2018-07-16 01:30:00 | ES | Futures | 3056.53 | 3058.16 | 3056.53 | 3057.07 | 1257.0 |
| 2018-07-16 02:00:00 | ES | Futures | 3056.8 | 3057.34 | 3055.71 | 3056.25 | 3105.0 |
| 2018-07-16 02:30:00 | ES | Futures | 3055.98 | 3057.89 | 3055.98 | 3057.34 | 2094.0 |
| 2018-07-16 03:00:00 | ES | Futures | 3057.34 | 3059.8 | 3057.07 | 3058.16 | 5417.0 |
| 2018-07-16 03:30:00 | ES | Futures | 3058.43 | 3059.52 | 3057.89 | 3059.25 | 3206.0 |
| 2018-07-16 04:00:00 | ES | Futures | 3059.25 | 3059.8 | 3056.53 | 3058.16 | 4913.0 |
| 2018-07-16 04:30:00 | ES | Futures | 3058.16 | 3059.25 | 3057.89 | 3058.43 | 2688.0 |
| 2018-07-16 05:00:00 | ES | Futures | 3058.43 | 3058.98 | 3056.8 | 3057.62 | 3138.0 |
| 2018-07-16 05:30:00 | ES | Futures | 3057.62 | 3058.16 | 3055.98 | 3056.53 | 3149.0 |
| 2018-07-16 06:00:00 | ES | Futures | 3056.8 | 3057.34 | 3054.35 | 3054.35 | 3842.0 |
| 2018-07-16 06:30:00 | ES | Futures | 3054.35 | 3056.25 | 3054.07 | 3055.98 | 4373.0 |
| 2018-07-16 07:00:00 | ES | Futures | 3055.98 | 3056.53 | 3052.44 | 3052.44 | 7428.0 |
| 2018-07-16 07:30:00 | ES | Futures | 3052.44 | 3054.89 | 3052.17 | 3054.89 | 6671.0 |
| 2018-07-16 08:00:00 | ES | Futures | 3054.89 | 3055.44 | 3053.53 | 3055.16 | 5618.0 |
| 2018-07-16 08:30:00 | ES | Futures | 3055.16 | 3055.71 | 3051.89 | 3053.8 | 11141.0 |
| 2018-07-16 09:00:00 | ES | Futures | 3053.8 | 3055.98 | 3052.98 | 3054.89 | 15906.0 |
| 2018-07-16 09:30:00 | ES | Futures | 3054.89 | 3056.8 | 3049.72 | 3052.44 | 108894.0 |
| 2018-07-16 10:00:00 | ES | Futures | 3052.71 | 3053.8 | 3048.08 | 3050.81 | 63185.0 |
| 2018-07-16 10:30:00 | ES | Futures | 3050.53 | 3053.53 | 3046.45 | 3046.45 | 60586.0 |
| 2018-07-16 11:00:00 | ES | Futures | 3046.45 | 3051.08 | 3046.17 | 3050.53 | 47898.0 |
| 2018-07-16 11:30:00 | ES | Futures | 3050.81 | 3051.62 | 3048.35 | 3050.26 | 33790.0 |
| 2018-07-16 12:00:00 | ES | Futures | 3050.53 | 3054.07 | 3048.08 | 3053.8 | 38106.0 |
| 2018-07-16 12:30:00 | ES | Futures | 3054.07 | 3054.35 | 3052.17 | 3053.8 | 17238.0 |
| 2018-07-16 13:00:00 | ES | Futures | 3054.07 | 3055.16 | 3051.62 | 3052.71 | 25175.0 |
| 2018-07-16 13:30:00 | ES | Futures | 3052.71 | 3053.8 | 3051.62 | 3052.71 | 11892.0 |
| 2018-07-16 14:00:00 | ES | Futures | 3052.44 | 3053.26 | 3051.08 | 3051.62 | 21590.0 |
| 2018-07-16 14:30:00 | ES | Futures | 3051.35 | 3051.89 | 3046.45 | 3047.81 | 53612.0 |
| 2018-07-16 15:00:00 | ES | Futures | 3047.81 | 3050.81 | 3047.26 | 3049.99 | 35824.0 |
| 2018-07-16 15:30:00 | ES | Futures | 3049.99 | 3052.98 | 3049.44 | 3052.17 | 79510.0 |
| 2018-07-16 16:00:00 | ES | Futures | 3051.89 | 3052.98 | 3047.26 | 3048.35 | 58170.0 |
| 2018-07-16 16:30:00 | ES | Futures | 3048.35 | 3048.63 | 3046.17 | 3047.81 | 10486.0 |
| 2018-07-16 18:00:00 | ES | Futures | 3046.99 | 3048.9 | 3045.36 | 3048.63 | 4072.0 |
| 2018-07-16 18:30:00 | ES | Futures | 3048.9 | 3049.17 | 3047.81 | 3048.08 | 1846.0 |
| 2018-07-16 19:00:00 | ES | Futures | 3047.81 | 3048.9 | 3047.54 | 3048.63 | 816.0 |
| 2018-07-16 19:30:00 | ES | Futures | 3048.35 | 3049.99 | 3047.81 | 3049.17 | 1820.0 |
| 2018-07-16 20:00:00 | ES | Futures | 3048.9 | 3050.26 | 3048.35 | 3049.17 | 3011.0 |
| 2018-07-16 20:30:00 | ES | Futures | 3049.17 | 3051.08 | 3049.17 | 3049.99 | 2430.0 |
| 2018-07-16 21:00:00 | ES | Futures | 3049.99 | 3053.26 | 3049.72 | 3051.62 | 4378.0 |
| 2018-07-16 21:30:00 | ES | Futures | 3051.62 | 3051.89 | 3047.54 | 3048.35 | 4850.0 |
| 2018-07-16 22:00:00 | ES | Futures | 3048.63 | 3048.9 | 3046.72 | 3048.35 | 4348.0 |
| 2018-07-16 22:30:00 | ES | Futures | 3048.08 | 3048.35 | 3046.99 | 3047.81 | 1938.0 |
| 2018-07-16 23:00:00 | ES | Futures | 3047.54 | 3049.72 | 3047.54 | 3049.17 | 1697.0 |
| 2018-07-16 23:30:00 | ES | Futures | 3049.17 | 3049.72 | 3048.63 | 3049.44 | 2163.0 |
| 2018-07-16 00:00:00 | NQ | Futures | 8716.84 | 8717.43 | 8715.37 | 8715.37 | 249.0 |
| 2018-07-16 00:30:00 | NQ | Futures | 8715.95 | 8716.84 | 8713.6 | 8715.66 | 528.0 |
| 2018-07-16 01:00:00 | NQ | Futures | 8715.95 | 8718.02 | 8709.48 | 8709.77 | 883.0 |
| 2018-07-16 01:30:00 | NQ | Futures | 8710.07 | 8714.19 | 8709.18 | 8711.24 | 665.0 |
> showing 50 of 3,089 rows — these rows as CSV