PREVIEW / futures_30min / 2019-05-14
file: by_date/futures_30min/2019/2019-05-14.parquet size: 89 KB rows: 3,448
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 |
|---|---|---|---|---|---|---|---|
| 2019-05-14 00:00:00 | ES | Futures | 3059.93 | 3059.93 | 3058.58 | 3059.39 | 2629.0 |
| 2019-05-14 00:30:00 | ES | Futures | 3059.66 | 3061.02 | 3059.39 | 3059.93 | 2907.0 |
| 2019-05-14 01:00:00 | ES | Futures | 3060.2 | 3061.56 | 3059.66 | 3059.66 | 5942.0 |
| 2019-05-14 01:30:00 | ES | Futures | 3059.66 | 3060.74 | 3058.85 | 3060.47 | 3996.0 |
| 2019-05-14 02:00:00 | ES | Futures | 3060.47 | 3061.29 | 3055.05 | 3055.59 | 12928.0 |
| 2019-05-14 02:30:00 | ES | Futures | 3055.86 | 3060.2 | 3055.59 | 3057.22 | 9364.0 |
| 2019-05-14 03:00:00 | ES | Futures | 3056.95 | 3062.1 | 3055.86 | 3062.1 | 14963.0 |
| 2019-05-14 03:30:00 | ES | Futures | 3062.1 | 3062.64 | 3059.66 | 3059.66 | 11966.0 |
| 2019-05-14 04:00:00 | ES | Futures | 3059.66 | 3059.93 | 3054.24 | 3056.14 | 14524.0 |
| 2019-05-14 04:30:00 | ES | Futures | 3056.41 | 3059.66 | 3053.97 | 3059.12 | 13694.0 |
| 2019-05-14 05:00:00 | ES | Futures | 3059.12 | 3063.18 | 3057.76 | 3061.83 | 16957.0 |
| 2019-05-14 05:30:00 | ES | Futures | 3061.83 | 3065.62 | 3061.02 | 3063.73 | 16116.0 |
| 2019-05-14 06:00:00 | ES | Futures | 3063.73 | 3067.52 | 3061.83 | 3065.9 | 13787.0 |
| 2019-05-14 06:30:00 | ES | Futures | 3066.17 | 3069.42 | 3062.64 | 3064.27 | 15996.0 |
| 2019-05-14 07:00:00 | ES | Futures | 3064.0 | 3070.5 | 3063.73 | 3068.61 | 19641.0 |
| 2019-05-14 07:30:00 | ES | Futures | 3068.61 | 3068.88 | 3065.35 | 3067.52 | 13088.0 |
| 2019-05-14 08:00:00 | ES | Futures | 3067.52 | 3069.15 | 3063.73 | 3065.08 | 28623.0 |
| 2019-05-14 08:30:00 | ES | Futures | 3064.81 | 3065.08 | 3059.39 | 3064.0 | 42194.0 |
| 2019-05-14 09:00:00 | ES | Futures | 3064.0 | 3065.08 | 3058.58 | 3061.02 | 37536.0 |
| 2019-05-14 09:30:00 | ES | Futures | 3061.02 | 3071.86 | 3059.12 | 3064.81 | 222860.0 |
| 2019-05-14 10:00:00 | ES | Futures | 3064.54 | 3078.1 | 3064.54 | 3076.47 | 166861.0 |
| 2019-05-14 10:30:00 | ES | Futures | 3076.47 | 3078.91 | 3072.94 | 3075.93 | 110133.0 |
| 2019-05-14 11:00:00 | ES | Futures | 3075.66 | 3085.96 | 3072.13 | 3082.98 | 115669.0 |
| 2019-05-14 11:30:00 | ES | Futures | 3082.7 | 3090.57 | 3082.43 | 3088.67 | 89945.0 |
| 2019-05-14 12:00:00 | ES | Futures | 3088.67 | 3091.11 | 3084.06 | 3084.33 | 62392.0 |
| 2019-05-14 12:30:00 | ES | Futures | 3084.33 | 3088.67 | 3082.98 | 3085.96 | 51116.0 |
| 2019-05-14 13:00:00 | ES | Futures | 3086.23 | 3093.82 | 3085.96 | 3091.92 | 59253.0 |
| 2019-05-14 13:30:00 | ES | Futures | 3091.92 | 3094.63 | 3091.65 | 3091.92 | 46264.0 |
| 2019-05-14 14:00:00 | ES | Futures | 3091.92 | 3094.36 | 3085.96 | 3091.92 | 64238.0 |
| 2019-05-14 14:30:00 | ES | Futures | 3091.92 | 3093.01 | 3082.7 | 3085.96 | 70701.0 |
| 2019-05-14 15:00:00 | ES | Futures | 3085.69 | 3091.11 | 3084.06 | 3086.5 | 55599.0 |
| 2019-05-14 15:30:00 | ES | Futures | 3086.77 | 3086.77 | 3073.22 | 3075.11 | 169124.0 |
| 2019-05-14 16:00:00 | ES | Futures | 3075.38 | 3079.45 | 3074.57 | 3079.18 | 62745.0 |
| 2019-05-14 16:30:00 | ES | Futures | 3078.91 | 3080.81 | 3078.37 | 3079.99 | 6999.0 |
| 2019-05-14 18:00:00 | ES | Futures | 3080.54 | 3082.7 | 3078.91 | 3081.89 | 4070.0 |
| 2019-05-14 18:30:00 | ES | Futures | 3081.89 | 3082.43 | 3080.54 | 3080.81 | 4668.0 |
| 2019-05-14 19:00:00 | ES | Futures | 3080.81 | 3082.16 | 3079.45 | 3081.08 | 4877.0 |
| 2019-05-14 19:30:00 | ES | Futures | 3081.35 | 3082.16 | 3079.72 | 3081.89 | 3235.0 |
| 2019-05-14 20:00:00 | ES | Futures | 3081.89 | 3081.89 | 3072.67 | 3073.76 | 13013.0 |
| 2019-05-14 20:30:00 | ES | Futures | 3073.76 | 3078.1 | 3073.76 | 3077.55 | 7778.0 |
| 2019-05-14 21:00:00 | ES | Futures | 3077.28 | 3080.26 | 3075.11 | 3079.99 | 6431.0 |
| 2019-05-14 21:30:00 | ES | Futures | 3079.99 | 3086.5 | 3078.37 | 3084.33 | 11578.0 |
| 2019-05-14 22:00:00 | ES | Futures | 3084.06 | 3084.06 | 3079.45 | 3080.54 | 9290.0 |
| 2019-05-14 22:30:00 | ES | Futures | 3080.54 | 3084.87 | 3078.91 | 3083.79 | 9078.0 |
| 2019-05-14 23:00:00 | ES | Futures | 3083.79 | 3085.96 | 3082.7 | 3084.87 | 7295.0 |
| 2019-05-14 23:30:00 | ES | Futures | 3085.14 | 3085.96 | 3083.25 | 3084.06 | 2073.0 |
| 2019-05-14 00:00:00 | NQ | Futures | 8576.29 | 8576.58 | 8570.18 | 8574.25 | 1048.0 |
| 2019-05-14 00:30:00 | NQ | Futures | 8574.55 | 8582.99 | 8574.55 | 8577.75 | 1689.0 |
| 2019-05-14 01:00:00 | NQ | Futures | 8578.04 | 8586.19 | 8577.46 | 8579.79 | 1838.0 |
| 2019-05-14 01:30:00 | NQ | Futures | 8579.5 | 8581.24 | 8570.76 | 8575.71 | 1682.0 |
> showing 50 of 3,448 rows — these rows as CSV