PREVIEW / futures_30min / 2018-07-26
file: by_date/futures_30min/2018/2018-07-26.parquet size: 82 KB rows: 3,119
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-26 00:00:00 | ES | Futures | 3089.22 | 3089.5 | 3088.68 | 3088.95 | 1042.0 |
| 2018-07-26 00:30:00 | ES | Futures | 3088.95 | 3089.5 | 3088.68 | 3089.5 | 1388.0 |
| 2018-07-26 01:00:00 | ES | Futures | 3089.5 | 3089.77 | 3088.13 | 3088.95 | 2206.0 |
| 2018-07-26 01:30:00 | ES | Futures | 3088.68 | 3089.22 | 3088.13 | 3088.68 | 2350.0 |
| 2018-07-26 02:00:00 | ES | Futures | 3088.68 | 3091.13 | 3088.68 | 3090.59 | 4968.0 |
| 2018-07-26 02:30:00 | ES | Futures | 3090.31 | 3090.86 | 3088.95 | 3089.77 | 3864.0 |
| 2018-07-26 03:00:00 | ES | Futures | 3090.04 | 3092.22 | 3089.22 | 3091.4 | 9871.0 |
| 2018-07-26 03:30:00 | ES | Futures | 3091.13 | 3092.22 | 3090.31 | 3091.4 | 4369.0 |
| 2018-07-26 04:00:00 | ES | Futures | 3091.13 | 3091.4 | 3089.22 | 3090.31 | 5453.0 |
| 2018-07-26 04:30:00 | ES | Futures | 3090.31 | 3091.13 | 3089.5 | 3089.5 | 4583.0 |
| 2018-07-26 05:00:00 | ES | Futures | 3089.77 | 3091.95 | 3089.5 | 3090.86 | 4187.0 |
| 2018-07-26 05:30:00 | ES | Futures | 3091.13 | 3092.76 | 3090.86 | 3091.95 | 7783.0 |
| 2018-07-26 06:00:00 | ES | Futures | 3092.22 | 3092.76 | 3090.31 | 3090.31 | 3546.0 |
| 2018-07-26 06:30:00 | ES | Futures | 3090.31 | 3090.86 | 3089.77 | 3090.31 | 3847.0 |
| 2018-07-26 07:00:00 | ES | Futures | 3090.31 | 3091.95 | 3089.77 | 3091.13 | 5518.0 |
| 2018-07-26 07:30:00 | ES | Futures | 3091.13 | 3092.22 | 3090.86 | 3091.13 | 7382.0 |
| 2018-07-26 08:00:00 | ES | Futures | 3091.13 | 3093.85 | 3090.86 | 3091.4 | 12979.0 |
| 2018-07-26 08:30:00 | ES | Futures | 3091.4 | 3092.49 | 3089.77 | 3090.04 | 12336.0 |
| 2018-07-26 09:00:00 | ES | Futures | 3090.31 | 3092.49 | 3090.04 | 3092.22 | 18726.0 |
| 2018-07-26 09:30:00 | ES | Futures | 3092.22 | 3099.3 | 3090.86 | 3094.67 | 161415.0 |
| 2018-07-26 10:00:00 | ES | Futures | 3094.67 | 3098.21 | 3093.85 | 3093.85 | 66791.0 |
| 2018-07-26 10:30:00 | ES | Futures | 3094.13 | 3099.3 | 3093.31 | 3099.03 | 63611.0 |
| 2018-07-26 11:00:00 | ES | Futures | 3099.03 | 3100.39 | 3097.67 | 3098.21 | 54191.0 |
| 2018-07-26 11:30:00 | ES | Futures | 3098.49 | 3100.12 | 3095.76 | 3100.12 | 40966.0 |
| 2018-07-26 12:00:00 | ES | Futures | 3099.85 | 3102.3 | 3094.94 | 3095.76 | 50683.0 |
| 2018-07-26 12:30:00 | ES | Futures | 3095.49 | 3096.31 | 3091.95 | 3092.76 | 36715.0 |
| 2018-07-26 13:00:00 | ES | Futures | 3093.04 | 3097.12 | 3091.68 | 3096.31 | 39633.0 |
| 2018-07-26 13:30:00 | ES | Futures | 3096.31 | 3096.31 | 3093.31 | 3094.13 | 32412.0 |
| 2018-07-26 14:00:00 | ES | Futures | 3094.4 | 3095.76 | 3092.76 | 3095.76 | 25521.0 |
| 2018-07-26 14:30:00 | ES | Futures | 3095.76 | 3096.85 | 3094.13 | 3094.4 | 29069.0 |
| 2018-07-26 15:00:00 | ES | Futures | 3094.4 | 3094.67 | 3091.13 | 3093.31 | 43931.0 |
| 2018-07-26 15:30:00 | ES | Futures | 3093.31 | 3095.49 | 3091.4 | 3093.31 | 92885.0 |
| 2018-07-26 16:00:00 | ES | Futures | 3093.04 | 3098.76 | 3088.13 | 3097.67 | 87975.0 |
| 2018-07-26 16:30:00 | ES | Futures | 3097.4 | 3097.4 | 3094.4 | 3095.49 | 9551.0 |
| 2018-07-26 18:00:00 | ES | Futures | 3095.49 | 3097.4 | 3094.4 | 3096.03 | 3104.0 |
| 2018-07-26 18:30:00 | ES | Futures | 3096.03 | 3096.31 | 3095.49 | 3096.03 | 662.0 |
| 2018-07-26 19:00:00 | ES | Futures | 3096.03 | 3097.94 | 3095.76 | 3097.12 | 1220.0 |
| 2018-07-26 19:30:00 | ES | Futures | 3096.85 | 3097.67 | 3096.31 | 3097.67 | 896.0 |
| 2018-07-26 20:00:00 | ES | Futures | 3097.67 | 3098.49 | 3097.12 | 3098.21 | 1742.0 |
| 2018-07-26 20:30:00 | ES | Futures | 3098.21 | 3099.03 | 3097.67 | 3097.94 | 1594.0 |
| 2018-07-26 21:00:00 | ES | Futures | 3097.94 | 3098.49 | 3096.58 | 3098.21 | 2779.0 |
| 2018-07-26 21:30:00 | ES | Futures | 3098.21 | 3098.76 | 3096.58 | 3096.58 | 2003.0 |
| 2018-07-26 22:00:00 | ES | Futures | 3096.85 | 3097.94 | 3095.76 | 3097.67 | 1458.0 |
| 2018-07-26 22:30:00 | ES | Futures | 3097.67 | 3098.76 | 3097.4 | 3098.76 | 918.0 |
| 2018-07-26 23:00:00 | ES | Futures | 3098.76 | 3100.39 | 3098.21 | 3099.03 | 2680.0 |
| 2018-07-26 23:30:00 | ES | Futures | 3099.3 | 3099.58 | 3098.76 | 3099.58 | 626.0 |
| 2018-07-26 00:00:00 | NQ | Futures | 8719.49 | 8720.67 | 8716.54 | 8720.67 | 358.0 |
| 2018-07-26 00:30:00 | NQ | Futures | 8720.37 | 8724.79 | 8718.6 | 8722.43 | 921.0 |
| 2018-07-26 01:00:00 | NQ | Futures | 8722.73 | 8723.9 | 8712.42 | 8714.48 | 1325.0 |
| 2018-07-26 01:30:00 | NQ | Futures | 8714.78 | 8718.02 | 8711.83 | 8715.66 | 958.0 |
> showing 50 of 3,119 rows — these rows as CSV