PREVIEW / futures_30min / 2018-01-30
file: by_date/futures_30min/2018/2018-01-30.parquet size: 90 KB rows: 3,247
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-01-30 00:00:00 | ES | Futures | 3104.19 | 3105.55 | 3101.45 | 3102.82 | 6397.0 |
| 2018-01-30 00:30:00 | ES | Futures | 3102.55 | 3103.64 | 3101.45 | 3102.27 | 5911.0 |
| 2018-01-30 01:00:00 | ES | Futures | 3102.27 | 3105.28 | 3102.27 | 3104.46 | 3154.0 |
| 2018-01-30 01:30:00 | ES | Futures | 3104.73 | 3109.38 | 3104.46 | 3109.11 | 4187.0 |
| 2018-01-30 02:00:00 | ES | Futures | 3109.38 | 3110.2 | 3102.55 | 3105.55 | 10078.0 |
| 2018-01-30 02:30:00 | ES | Futures | 3105.55 | 3107.74 | 3102.27 | 3104.19 | 7783.0 |
| 2018-01-30 03:00:00 | ES | Futures | 3104.46 | 3110.75 | 3104.19 | 3108.56 | 17084.0 |
| 2018-01-30 03:30:00 | ES | Futures | 3108.56 | 3109.38 | 3106.1 | 3106.65 | 9345.0 |
| 2018-01-30 04:00:00 | ES | Futures | 3106.65 | 3110.2 | 3105.28 | 3109.93 | 10189.0 |
| 2018-01-30 04:30:00 | ES | Futures | 3109.93 | 3111.02 | 3107.19 | 3111.02 | 6088.0 |
| 2018-01-30 05:00:00 | ES | Futures | 3110.75 | 3111.29 | 3106.65 | 3107.47 | 8095.0 |
| 2018-01-30 05:30:00 | ES | Futures | 3107.47 | 3107.74 | 3106.1 | 3106.37 | 7126.0 |
| 2018-01-30 06:00:00 | ES | Futures | 3106.37 | 3108.56 | 3105.28 | 3106.1 | 8754.0 |
| 2018-01-30 06:30:00 | ES | Futures | 3106.37 | 3107.74 | 3105.55 | 3105.83 | 5095.0 |
| 2018-01-30 07:00:00 | ES | Futures | 3105.83 | 3106.65 | 3104.73 | 3105.28 | 9132.0 |
| 2018-01-30 07:30:00 | ES | Futures | 3105.55 | 3106.37 | 3100.36 | 3104.46 | 23795.0 |
| 2018-01-30 08:00:00 | ES | Futures | 3104.73 | 3108.01 | 3103.09 | 3104.19 | 27667.0 |
| 2018-01-30 08:30:00 | ES | Futures | 3104.19 | 3104.73 | 3098.99 | 3099.27 | 29590.0 |
| 2018-01-30 09:00:00 | ES | Futures | 3099.27 | 3099.81 | 3092.71 | 3096.26 | 68211.0 |
| 2018-01-30 09:30:00 | ES | Futures | 3095.99 | 3104.46 | 3089.43 | 3090.25 | 299148.0 |
| 2018-01-30 10:00:00 | ES | Futures | 3090.25 | 3093.25 | 3081.5 | 3092.71 | 219302.0 |
| 2018-01-30 10:30:00 | ES | Futures | 3092.71 | 3099.81 | 3090.52 | 3098.45 | 152441.0 |
| 2018-01-30 11:00:00 | ES | Futures | 3098.45 | 3101.73 | 3092.16 | 3093.53 | 100923.0 |
| 2018-01-30 11:30:00 | ES | Futures | 3093.53 | 3098.99 | 3089.43 | 3089.97 | 92966.0 |
| 2018-01-30 12:00:00 | ES | Futures | 3090.25 | 3093.25 | 3088.33 | 3088.88 | 62694.0 |
| 2018-01-30 12:30:00 | ES | Futures | 3088.88 | 3091.61 | 3086.69 | 3089.43 | 67293.0 |
| 2018-01-30 13:00:00 | ES | Futures | 3089.43 | 3089.7 | 3083.69 | 3084.78 | 76029.0 |
| 2018-01-30 13:30:00 | ES | Futures | 3084.78 | 3093.8 | 3084.51 | 3092.16 | 63260.0 |
| 2018-01-30 14:00:00 | ES | Futures | 3091.89 | 3096.53 | 3090.25 | 3091.61 | 90102.0 |
| 2018-01-30 14:30:00 | ES | Futures | 3091.61 | 3091.89 | 3085.33 | 3086.69 | 80343.0 |
| 2018-01-30 15:00:00 | ES | Futures | 3086.97 | 3092.71 | 3085.33 | 3091.61 | 65503.0 |
| 2018-01-30 15:30:00 | ES | Futures | 3091.61 | 3095.99 | 3085.6 | 3086.97 | 165483.0 |
| 2018-01-30 16:00:00 | ES | Futures | 3086.97 | 3091.61 | 3085.87 | 3087.79 | 104806.0 |
| 2018-01-30 16:30:00 | ES | Futures | 3088.88 | 3089.43 | 3084.78 | 3086.69 | 10696.0 |
| 2018-01-30 18:00:00 | ES | Futures | 3086.69 | 3089.7 | 3085.87 | 3089.43 | 7811.0 |
| 2018-01-30 18:30:00 | ES | Futures | 3089.7 | 3089.7 | 3087.51 | 3087.51 | 3908.0 |
| 2018-01-30 19:00:00 | ES | Futures | 3087.79 | 3091.61 | 3087.51 | 3090.79 | 6098.0 |
| 2018-01-30 19:30:00 | ES | Futures | 3090.79 | 3091.89 | 3087.24 | 3087.51 | 6993.0 |
| 2018-01-30 20:00:00 | ES | Futures | 3087.24 | 3091.34 | 3087.24 | 3090.79 | 4387.0 |
| 2018-01-30 20:30:00 | ES | Futures | 3091.07 | 3093.8 | 3089.97 | 3092.98 | 5701.0 |
| 2018-01-30 21:00:00 | ES | Futures | 3092.71 | 3093.25 | 3091.61 | 3091.61 | 3235.0 |
| 2018-01-30 21:30:00 | ES | Futures | 3091.61 | 3094.35 | 3088.61 | 3093.25 | 10389.0 |
| 2018-01-30 22:00:00 | ES | Futures | 3093.25 | 3098.17 | 3092.71 | 3097.9 | 7923.0 |
| 2018-01-30 22:30:00 | ES | Futures | 3097.9 | 3100.09 | 3095.99 | 3098.99 | 9972.0 |
| 2018-01-30 23:00:00 | ES | Futures | 3098.72 | 3098.99 | 3095.99 | 3098.17 | 3853.0 |
| 2018-01-30 23:30:00 | ES | Futures | 3098.17 | 3098.72 | 3095.71 | 3097.08 | 2720.0 |
| 2018-01-30 00:00:00 | NQ | Futures | 8245.62 | 8247.1 | 8233.46 | 8237.91 | 2662.0 |
| 2018-01-30 00:30:00 | NQ | Futures | 8237.91 | 8242.06 | 8234.64 | 8238.2 | 1066.0 |
| 2018-01-30 01:00:00 | NQ | Futures | 8238.8 | 8247.1 | 8238.5 | 8244.43 | 985.0 |
| 2018-01-30 01:30:00 | NQ | Futures | 8244.43 | 8257.18 | 8244.43 | 8256.0 | 1581.0 |
> showing 50 of 3,247 rows — these rows as CSV