PREVIEW / futures_30min / 2018-11-08
file: by_date/futures_30min/2018/2018-11-08.parquet size: 88 KB rows: 3,258
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-08 00:00:00 | ES | Futures | 3063.24 | 3063.24 | 3059.44 | 3059.44 | 3265.0 |
| 2018-11-08 00:30:00 | ES | Futures | 3059.44 | 3061.07 | 3058.89 | 3060.25 | 3168.0 |
| 2018-11-08 01:00:00 | ES | Futures | 3060.25 | 3061.07 | 3057.8 | 3057.8 | 3293.0 |
| 2018-11-08 01:30:00 | ES | Futures | 3058.08 | 3059.44 | 3057.53 | 3058.62 | 2477.0 |
| 2018-11-08 02:00:00 | ES | Futures | 3058.62 | 3059.44 | 3057.8 | 3058.89 | 6058.0 |
| 2018-11-08 02:30:00 | ES | Futures | 3059.16 | 3062.7 | 3058.35 | 3062.7 | 6216.0 |
| 2018-11-08 03:00:00 | ES | Futures | 3062.7 | 3064.33 | 3061.88 | 3062.16 | 17176.0 |
| 2018-11-08 03:30:00 | ES | Futures | 3062.43 | 3062.7 | 3059.44 | 3060.52 | 8904.0 |
| 2018-11-08 04:00:00 | ES | Futures | 3060.8 | 3061.61 | 3058.62 | 3058.62 | 7979.0 |
| 2018-11-08 04:30:00 | ES | Futures | 3058.62 | 3059.44 | 3052.36 | 3052.64 | 11445.0 |
| 2018-11-08 05:00:00 | ES | Futures | 3052.64 | 3053.18 | 3049.92 | 3051.0 | 14301.0 |
| 2018-11-08 05:30:00 | ES | Futures | 3051.0 | 3052.09 | 3048.56 | 3049.1 | 12234.0 |
| 2018-11-08 06:00:00 | ES | Futures | 3049.1 | 3053.18 | 3048.83 | 3051.55 | 7336.0 |
| 2018-11-08 06:30:00 | ES | Futures | 3051.55 | 3051.82 | 3048.01 | 3051.55 | 10502.0 |
| 2018-11-08 07:00:00 | ES | Futures | 3051.55 | 3054.81 | 3051.55 | 3052.09 | 8833.0 |
| 2018-11-08 07:30:00 | ES | Futures | 3052.36 | 3055.36 | 3051.82 | 3054.27 | 9214.0 |
| 2018-11-08 08:00:00 | ES | Futures | 3054.54 | 3056.17 | 3052.09 | 3053.45 | 12076.0 |
| 2018-11-08 08:30:00 | ES | Futures | 3053.45 | 3054.81 | 3051.0 | 3053.45 | 17968.0 |
| 2018-11-08 09:00:00 | ES | Futures | 3053.72 | 3053.72 | 3050.46 | 3051.55 | 22208.0 |
| 2018-11-08 09:30:00 | ES | Futures | 3051.28 | 3060.8 | 3050.73 | 3059.71 | 145189.0 |
| 2018-11-08 10:00:00 | ES | Futures | 3059.71 | 3060.8 | 3051.28 | 3052.91 | 98918.0 |
| 2018-11-08 10:30:00 | ES | Futures | 3052.91 | 3058.62 | 3052.09 | 3057.8 | 77392.0 |
| 2018-11-08 11:00:00 | ES | Futures | 3057.8 | 3060.25 | 3054.27 | 3057.26 | 49218.0 |
| 2018-11-08 11:30:00 | ES | Futures | 3057.26 | 3062.16 | 3056.99 | 3059.98 | 45509.0 |
| 2018-11-08 12:00:00 | ES | Futures | 3060.25 | 3062.97 | 3058.62 | 3059.44 | 33990.0 |
| 2018-11-08 12:30:00 | ES | Futures | 3059.16 | 3061.61 | 3056.44 | 3056.44 | 38936.0 |
| 2018-11-08 13:00:00 | ES | Futures | 3056.72 | 3058.08 | 3051.55 | 3051.55 | 38802.0 |
| 2018-11-08 13:30:00 | ES | Futures | 3051.55 | 3055.63 | 3050.73 | 3055.63 | 32256.0 |
| 2018-11-08 14:00:00 | ES | Futures | 3055.36 | 3059.71 | 3047.47 | 3049.37 | 95526.0 |
| 2018-11-08 14:30:00 | ES | Futures | 3049.37 | 3050.46 | 3040.94 | 3047.74 | 103481.0 |
| 2018-11-08 15:00:00 | ES | Futures | 3048.01 | 3052.36 | 3043.66 | 3046.38 | 88554.0 |
| 2018-11-08 15:30:00 | ES | Futures | 3046.38 | 3054.54 | 3042.57 | 3054.54 | 134644.0 |
| 2018-11-08 16:00:00 | ES | Futures | 3054.27 | 3058.08 | 3054.0 | 3056.44 | 63687.0 |
| 2018-11-08 16:30:00 | ES | Futures | 3055.9 | 3056.44 | 3052.09 | 3052.36 | 8363.0 |
| 2018-11-08 18:00:00 | ES | Futures | 3050.73 | 3052.64 | 3049.1 | 3049.64 | 4354.0 |
| 2018-11-08 18:30:00 | ES | Futures | 3049.64 | 3053.18 | 3049.37 | 3052.91 | 2507.0 |
| 2018-11-08 19:00:00 | ES | Futures | 3052.91 | 3055.9 | 3052.64 | 3055.08 | 4198.0 |
| 2018-11-08 19:30:00 | ES | Futures | 3055.08 | 3056.99 | 3053.72 | 3053.72 | 3874.0 |
| 2018-11-08 20:00:00 | ES | Futures | 3054.0 | 3054.0 | 3049.64 | 3052.91 | 5373.0 |
| 2018-11-08 20:30:00 | ES | Futures | 3052.91 | 3055.08 | 3050.19 | 3051.0 | 6751.0 |
| 2018-11-08 21:00:00 | ES | Futures | 3051.0 | 3052.36 | 3048.83 | 3050.19 | 4488.0 |
| 2018-11-08 21:30:00 | ES | Futures | 3050.19 | 3050.19 | 3046.11 | 3048.83 | 4670.0 |
| 2018-11-08 22:00:00 | ES | Futures | 3048.83 | 3051.55 | 3048.83 | 3049.64 | 3494.0 |
| 2018-11-08 22:30:00 | ES | Futures | 3049.64 | 3051.28 | 3046.92 | 3051.0 | 4052.0 |
| 2018-11-08 23:00:00 | ES | Futures | 3051.0 | 3054.0 | 3050.73 | 3053.72 | 3377.0 |
| 2018-11-08 23:30:00 | ES | Futures | 3054.0 | 3058.62 | 3054.0 | 3055.9 | 6074.0 |
| 2018-11-08 00:00:00 | NQ | Futures | 8459.47 | 8459.47 | 8444.22 | 8445.69 | 1398.0 |
| 2018-11-08 00:30:00 | NQ | Futures | 8445.69 | 8449.79 | 8440.99 | 8448.62 | 1332.0 |
| 2018-11-08 01:00:00 | NQ | Futures | 8448.62 | 8452.43 | 8437.47 | 8438.94 | 1329.0 |
| 2018-11-08 01:30:00 | NQ | Futures | 8438.94 | 8448.03 | 8438.35 | 8445.69 | 991.0 |
> showing 50 of 3,258 rows — these rows as CSV