PREVIEW / futures_30min / 2019-04-01
file: by_date/futures_30min/2019/2019-04-01.parquet size: 89 KB rows: 3,339
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-04-01 00:00:00 | ES | Futures | 3098.7 | 3098.7 | 3096.26 | 3096.8 | 3208.0 |
| 2019-04-01 00:30:00 | ES | Futures | 3096.8 | 3097.89 | 3096.26 | 3097.07 | 2021.0 |
| 2019-04-01 01:00:00 | ES | Futures | 3097.34 | 3098.43 | 3096.53 | 3098.16 | 2673.0 |
| 2019-04-01 01:30:00 | ES | Futures | 3098.16 | 3098.43 | 3097.07 | 3098.16 | 2943.0 |
| 2019-04-01 02:00:00 | ES | Futures | 3098.43 | 3098.97 | 3095.45 | 3096.26 | 6251.0 |
| 2019-04-01 02:30:00 | ES | Futures | 3096.26 | 3098.16 | 3095.99 | 3097.61 | 3099.0 |
| 2019-04-01 03:00:00 | ES | Futures | 3097.61 | 3098.97 | 3095.72 | 3097.07 | 10244.0 |
| 2019-04-01 03:30:00 | ES | Futures | 3096.8 | 3100.87 | 3096.26 | 3100.6 | 8249.0 |
| 2019-04-01 04:00:00 | ES | Futures | 3100.6 | 3101.95 | 3098.43 | 3101.14 | 10514.0 |
| 2019-04-01 04:30:00 | ES | Futures | 3101.41 | 3102.77 | 3100.33 | 3100.87 | 8302.0 |
| 2019-04-01 05:00:00 | ES | Futures | 3100.6 | 3101.41 | 3097.89 | 3097.89 | 10034.0 |
| 2019-04-01 05:30:00 | ES | Futures | 3098.16 | 3098.97 | 3097.07 | 3097.34 | 5028.0 |
| 2019-04-01 06:00:00 | ES | Futures | 3097.34 | 3099.51 | 3095.45 | 3096.26 | 6742.0 |
| 2019-04-01 06:30:00 | ES | Futures | 3096.26 | 3097.61 | 3095.45 | 3095.72 | 5235.0 |
| 2019-04-01 07:00:00 | ES | Futures | 3095.45 | 3099.24 | 3095.45 | 3098.43 | 6180.0 |
| 2019-04-01 07:30:00 | ES | Futures | 3098.7 | 3099.51 | 3097.07 | 3099.24 | 6356.0 |
| 2019-04-01 08:00:00 | ES | Futures | 3099.24 | 3100.87 | 3097.89 | 3099.78 | 13515.0 |
| 2019-04-01 08:30:00 | ES | Futures | 3099.51 | 3100.33 | 3094.63 | 3098.16 | 18653.0 |
| 2019-04-01 09:00:00 | ES | Futures | 3098.43 | 3100.87 | 3097.89 | 3100.6 | 15802.0 |
| 2019-04-01 09:30:00 | ES | Futures | 3100.33 | 3102.22 | 3097.07 | 3098.16 | 162167.0 |
| 2019-04-01 10:00:00 | ES | Futures | 3098.43 | 3105.21 | 3098.43 | 3101.14 | 140805.0 |
| 2019-04-01 10:30:00 | ES | Futures | 3100.87 | 3103.04 | 3100.05 | 3102.22 | 66137.0 |
| 2019-04-01 11:00:00 | ES | Futures | 3102.22 | 3106.29 | 3101.41 | 3104.66 | 73856.0 |
| 2019-04-01 11:30:00 | ES | Futures | 3104.39 | 3105.48 | 3100.6 | 3104.12 | 51270.0 |
| 2019-04-01 12:00:00 | ES | Futures | 3104.39 | 3106.02 | 3101.41 | 3104.93 | 42929.0 |
| 2019-04-01 12:30:00 | ES | Futures | 3104.93 | 3107.65 | 3104.39 | 3107.65 | 33593.0 |
| 2019-04-01 13:00:00 | ES | Futures | 3107.65 | 3108.46 | 3104.93 | 3106.83 | 39663.0 |
| 2019-04-01 13:30:00 | ES | Futures | 3106.83 | 3109.27 | 3106.29 | 3109.27 | 31780.0 |
| 2019-04-01 14:00:00 | ES | Futures | 3109.0 | 3112.25 | 3108.73 | 3109.27 | 52570.0 |
| 2019-04-01 14:30:00 | ES | Futures | 3109.27 | 3111.71 | 3108.46 | 3110.09 | 33513.0 |
| 2019-04-01 15:00:00 | ES | Futures | 3109.81 | 3111.71 | 3106.83 | 3111.71 | 56368.0 |
| 2019-04-01 15:30:00 | ES | Futures | 3111.71 | 3116.05 | 3110.09 | 3113.34 | 136833.0 |
| 2019-04-01 16:00:00 | ES | Futures | 3113.07 | 3113.34 | 3108.46 | 3113.34 | 65709.0 |
| 2019-04-01 16:30:00 | ES | Futures | 3113.34 | 3114.42 | 3112.53 | 3112.8 | 8573.0 |
| 2019-04-01 18:00:00 | ES | Futures | 3110.63 | 3111.98 | 3109.54 | 3111.44 | 2974.0 |
| 2019-04-01 18:30:00 | ES | Futures | 3111.17 | 3111.44 | 3109.81 | 3110.63 | 2788.0 |
| 2019-04-01 19:00:00 | ES | Futures | 3110.9 | 3111.44 | 3109.81 | 3110.36 | 1286.0 |
| 2019-04-01 19:30:00 | ES | Futures | 3110.63 | 3114.42 | 3110.09 | 3114.15 | 4311.0 |
| 2019-04-01 20:00:00 | ES | Futures | 3114.15 | 3114.42 | 3111.44 | 3112.8 | 5557.0 |
| 2019-04-01 20:30:00 | ES | Futures | 3112.8 | 3113.61 | 3111.17 | 3111.44 | 3195.0 |
| 2019-04-01 21:00:00 | ES | Futures | 3111.17 | 3112.25 | 3110.63 | 3111.17 | 3150.0 |
| 2019-04-01 21:30:00 | ES | Futures | 3111.17 | 3111.44 | 3109.27 | 3110.63 | 4290.0 |
| 2019-04-01 22:00:00 | ES | Futures | 3110.63 | 3110.9 | 3109.0 | 3109.27 | 2511.0 |
| 2019-04-01 22:30:00 | ES | Futures | 3109.54 | 3110.36 | 3108.19 | 3109.0 | 3627.0 |
| 2019-04-01 23:00:00 | ES | Futures | 3109.0 | 3110.63 | 3109.0 | 3109.54 | 2297.0 |
| 2019-04-01 23:30:00 | ES | Futures | 3109.81 | 3110.09 | 3106.83 | 3108.46 | 3466.0 |
| 2019-04-01 00:00:00 | NQ | Futures | 8712.55 | 8712.55 | 8703.82 | 8704.69 | 1518.0 |
| 2019-04-01 00:30:00 | NQ | Futures | 8704.69 | 8707.9 | 8703.53 | 8704.98 | 1049.0 |
| 2019-04-01 01:00:00 | NQ | Futures | 8704.98 | 8709.35 | 8703.53 | 8708.19 | 1126.0 |
| 2019-04-01 01:30:00 | NQ | Futures | 8708.19 | 8709.06 | 8703.53 | 8707.31 | 1281.0 |
> showing 50 of 3,339 rows — these rows as CSV