PREVIEW / futures_30min / 2018-08-13
file: by_date/futures_30min/2018/2018-08-13.parquet size: 88 KB rows: 3,211
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-08-13 00:00:00 | ES | Futures | 3077.23 | 3077.78 | 3073.96 | 3075.33 | 5151.0 |
| 2018-08-13 00:30:00 | ES | Futures | 3075.33 | 3076.42 | 3074.51 | 3075.33 | 2685.0 |
| 2018-08-13 01:00:00 | ES | Futures | 3075.6 | 3081.05 | 3075.05 | 3079.96 | 7106.0 |
| 2018-08-13 01:30:00 | ES | Futures | 3079.96 | 3079.96 | 3077.23 | 3078.87 | 5035.0 |
| 2018-08-13 02:00:00 | ES | Futures | 3078.87 | 3083.5 | 3078.87 | 3083.23 | 8591.0 |
| 2018-08-13 02:30:00 | ES | Futures | 3082.96 | 3086.23 | 3079.96 | 3080.5 | 12410.0 |
| 2018-08-13 03:00:00 | ES | Futures | 3080.5 | 3082.41 | 3078.6 | 3080.23 | 12771.0 |
| 2018-08-13 03:30:00 | ES | Futures | 3079.96 | 3080.5 | 3076.14 | 3077.51 | 12247.0 |
| 2018-08-13 04:00:00 | ES | Futures | 3077.23 | 3082.96 | 3076.96 | 3081.87 | 10980.0 |
| 2018-08-13 04:30:00 | ES | Futures | 3082.14 | 3084.59 | 3080.78 | 3084.32 | 7261.0 |
| 2018-08-13 05:00:00 | ES | Futures | 3084.32 | 3084.59 | 3081.87 | 3083.77 | 9638.0 |
| 2018-08-13 05:30:00 | ES | Futures | 3083.77 | 3085.68 | 3080.78 | 3081.32 | 8239.0 |
| 2018-08-13 06:00:00 | ES | Futures | 3081.05 | 3083.5 | 3079.96 | 3082.41 | 8132.0 |
| 2018-08-13 06:30:00 | ES | Futures | 3082.41 | 3085.14 | 3081.87 | 3082.41 | 5707.0 |
| 2018-08-13 07:00:00 | ES | Futures | 3082.14 | 3084.59 | 3082.14 | 3082.68 | 3457.0 |
| 2018-08-13 07:30:00 | ES | Futures | 3082.96 | 3090.86 | 3082.41 | 3089.5 | 24307.0 |
| 2018-08-13 08:00:00 | ES | Futures | 3089.77 | 3093.04 | 3086.5 | 3092.76 | 24977.0 |
| 2018-08-13 08:30:00 | ES | Futures | 3092.76 | 3093.04 | 3089.22 | 3090.04 | 13738.0 |
| 2018-08-13 09:00:00 | ES | Futures | 3090.04 | 3091.95 | 3089.22 | 3091.95 | 9273.0 |
| 2018-08-13 09:30:00 | ES | Futures | 3091.95 | 3096.85 | 3090.59 | 3096.31 | 102475.0 |
| 2018-08-13 10:00:00 | ES | Futures | 3096.58 | 3099.3 | 3094.94 | 3097.12 | 67022.0 |
| 2018-08-13 10:30:00 | ES | Futures | 3097.4 | 3099.03 | 3094.67 | 3095.22 | 48140.0 |
| 2018-08-13 11:00:00 | ES | Futures | 3095.49 | 3096.85 | 3087.04 | 3087.32 | 76149.0 |
| 2018-08-13 11:30:00 | ES | Futures | 3087.04 | 3088.13 | 3080.23 | 3080.23 | 78676.0 |
| 2018-08-13 12:00:00 | ES | Futures | 3080.23 | 3083.77 | 3076.42 | 3078.87 | 66948.0 |
| 2018-08-13 12:30:00 | ES | Futures | 3078.87 | 3081.05 | 3076.69 | 3077.78 | 63417.0 |
| 2018-08-13 13:00:00 | ES | Futures | 3077.51 | 3081.87 | 3073.42 | 3081.32 | 74022.0 |
| 2018-08-13 13:30:00 | ES | Futures | 3081.32 | 3084.32 | 3079.14 | 3080.5 | 51486.0 |
| 2018-08-13 14:00:00 | ES | Futures | 3080.78 | 3087.86 | 3080.5 | 3087.32 | 51631.0 |
| 2018-08-13 14:30:00 | ES | Futures | 3087.59 | 3088.13 | 3079.96 | 3081.05 | 62747.0 |
| 2018-08-13 15:00:00 | ES | Futures | 3081.05 | 3084.59 | 3078.32 | 3079.69 | 59928.0 |
| 2018-08-13 15:30:00 | ES | Futures | 3079.69 | 3081.59 | 3075.05 | 3076.42 | 128426.0 |
| 2018-08-13 16:00:00 | ES | Futures | 3076.69 | 3079.96 | 3076.42 | 3079.69 | 59887.0 |
| 2018-08-13 16:30:00 | ES | Futures | 3079.96 | 3081.05 | 3079.14 | 3080.23 | 8366.0 |
| 2018-08-13 18:00:00 | ES | Futures | 3080.78 | 3082.68 | 3079.69 | 3082.41 | 3171.0 |
| 2018-08-13 18:30:00 | ES | Futures | 3082.41 | 3083.23 | 3081.59 | 3082.41 | 1605.0 |
| 2018-08-13 19:00:00 | ES | Futures | 3082.68 | 3082.68 | 3081.05 | 3081.87 | 867.0 |
| 2018-08-13 19:30:00 | ES | Futures | 3081.87 | 3082.96 | 3080.78 | 3081.05 | 1830.0 |
| 2018-08-13 20:00:00 | ES | Futures | 3081.05 | 3084.59 | 3081.05 | 3083.5 | 7011.0 |
| 2018-08-13 20:30:00 | ES | Futures | 3083.5 | 3085.14 | 3082.68 | 3084.86 | 3140.0 |
| 2018-08-13 21:00:00 | ES | Futures | 3085.14 | 3085.95 | 3082.96 | 3082.96 | 4344.0 |
| 2018-08-13 21:30:00 | ES | Futures | 3082.96 | 3083.77 | 3082.14 | 3082.96 | 4336.0 |
| 2018-08-13 22:00:00 | ES | Futures | 3082.68 | 3084.59 | 3080.5 | 3083.5 | 5755.0 |
| 2018-08-13 22:30:00 | ES | Futures | 3083.5 | 3084.86 | 3082.68 | 3083.77 | 2978.0 |
| 2018-08-13 23:00:00 | ES | Futures | 3083.77 | 3084.05 | 3081.87 | 3082.68 | 2436.0 |
| 2018-08-13 23:30:00 | ES | Futures | 3082.96 | 3086.23 | 3082.96 | 3085.68 | 4638.0 |
| 2018-08-13 00:00:00 | NQ | Futures | 8701.53 | 8703.88 | 8692.4 | 8695.64 | 1428.0 |
| 2018-08-13 00:30:00 | NQ | Futures | 8696.23 | 8700.35 | 8689.16 | 8696.52 | 1367.0 |
| 2018-08-13 01:00:00 | NQ | Futures | 8696.82 | 8712.72 | 8693.87 | 8708.01 | 2048.0 |
| 2018-08-13 01:30:00 | NQ | Futures | 8708.3 | 8709.77 | 8699.17 | 8707.12 | 1497.0 |
> showing 50 of 3,211 rows — these rows as CSV