PREVIEW / futures_30min / 2018-08-08
file: by_date/futures_30min/2018/2018-08-08.parquet size: 81 KB rows: 3,132
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-08 00:00:00 | ES | Futures | 3117.56 | 3117.83 | 3117.29 | 3117.29 | 525.0 |
| 2018-08-08 00:30:00 | ES | Futures | 3117.29 | 3117.56 | 3115.38 | 3115.65 | 2291.0 |
| 2018-08-08 01:00:00 | ES | Futures | 3115.92 | 3117.01 | 3115.65 | 3116.2 | 1525.0 |
| 2018-08-08 01:30:00 | ES | Futures | 3115.92 | 3116.47 | 3115.65 | 3115.65 | 1545.0 |
| 2018-08-08 02:00:00 | ES | Futures | 3115.65 | 3115.92 | 3114.56 | 3115.11 | 3718.0 |
| 2018-08-08 02:30:00 | ES | Futures | 3114.83 | 3114.83 | 3112.93 | 3114.02 | 3612.0 |
| 2018-08-08 03:00:00 | ES | Futures | 3114.29 | 3116.47 | 3114.02 | 3115.11 | 6520.0 |
| 2018-08-08 03:30:00 | ES | Futures | 3115.38 | 3117.01 | 3114.83 | 3116.74 | 3819.0 |
| 2018-08-08 04:00:00 | ES | Futures | 3116.74 | 3116.74 | 3114.56 | 3115.92 | 4586.0 |
| 2018-08-08 04:30:00 | ES | Futures | 3115.92 | 3117.01 | 3115.11 | 3116.47 | 3082.0 |
| 2018-08-08 05:00:00 | ES | Futures | 3116.47 | 3117.29 | 3115.65 | 3115.92 | 3160.0 |
| 2018-08-08 05:30:00 | ES | Futures | 3115.92 | 3117.01 | 3115.11 | 3116.47 | 3060.0 |
| 2018-08-08 06:00:00 | ES | Futures | 3116.74 | 3118.1 | 3116.2 | 3117.56 | 3482.0 |
| 2018-08-08 06:30:00 | ES | Futures | 3117.56 | 3118.1 | 3117.01 | 3117.83 | 4540.0 |
| 2018-08-08 07:00:00 | ES | Futures | 3117.83 | 3118.1 | 3117.29 | 3117.56 | 3145.0 |
| 2018-08-08 07:30:00 | ES | Futures | 3117.56 | 3118.65 | 3116.47 | 3116.47 | 4861.0 |
| 2018-08-08 08:00:00 | ES | Futures | 3116.74 | 3117.01 | 3114.02 | 3114.29 | 10965.0 |
| 2018-08-08 08:30:00 | ES | Futures | 3114.29 | 3114.29 | 3111.57 | 3112.93 | 12621.0 |
| 2018-08-08 09:00:00 | ES | Futures | 3112.65 | 3114.29 | 3112.38 | 3113.74 | 10976.0 |
| 2018-08-08 09:30:00 | ES | Futures | 3113.74 | 3115.11 | 3110.2 | 3111.84 | 98727.0 |
| 2018-08-08 10:00:00 | ES | Futures | 3111.57 | 3113.74 | 3109.93 | 3111.84 | 51190.0 |
| 2018-08-08 10:30:00 | ES | Futures | 3111.84 | 3116.47 | 3109.39 | 3116.2 | 70022.0 |
| 2018-08-08 11:00:00 | ES | Futures | 3116.2 | 3117.01 | 3115.11 | 3116.47 | 39718.0 |
| 2018-08-08 11:30:00 | ES | Futures | 3116.47 | 3118.1 | 3114.02 | 3114.56 | 32683.0 |
| 2018-08-08 12:00:00 | ES | Futures | 3114.56 | 3114.83 | 3112.11 | 3113.2 | 31063.0 |
| 2018-08-08 12:30:00 | ES | Futures | 3112.93 | 3116.47 | 3112.93 | 3114.56 | 21245.0 |
| 2018-08-08 13:00:00 | ES | Futures | 3114.29 | 3115.65 | 3113.74 | 3114.83 | 15715.0 |
| 2018-08-08 13:30:00 | ES | Futures | 3114.56 | 3117.56 | 3113.74 | 3117.01 | 24806.0 |
| 2018-08-08 14:00:00 | ES | Futures | 3117.29 | 3118.1 | 3115.92 | 3118.1 | 18144.0 |
| 2018-08-08 14:30:00 | ES | Futures | 3118.1 | 3118.1 | 3115.92 | 3116.74 | 22283.0 |
| 2018-08-08 15:00:00 | ES | Futures | 3116.74 | 3118.65 | 3116.2 | 3118.38 | 26897.0 |
| 2018-08-08 15:30:00 | ES | Futures | 3118.65 | 3119.74 | 3114.02 | 3114.56 | 92749.0 |
| 2018-08-08 16:00:00 | ES | Futures | 3114.83 | 3115.38 | 3111.57 | 3111.84 | 55205.0 |
| 2018-08-08 16:30:00 | ES | Futures | 3111.57 | 3112.11 | 3108.84 | 3109.93 | 10558.0 |
| 2018-08-08 18:00:00 | ES | Futures | 3109.93 | 3111.84 | 3109.11 | 3111.02 | 3605.0 |
| 2018-08-08 18:30:00 | ES | Futures | 3111.02 | 3111.57 | 3110.75 | 3111.57 | 642.0 |
| 2018-08-08 19:00:00 | ES | Futures | 3111.29 | 3111.57 | 3110.48 | 3111.02 | 556.0 |
| 2018-08-08 19:30:00 | ES | Futures | 3111.02 | 3111.84 | 3110.75 | 3111.57 | 1232.0 |
| 2018-08-08 20:00:00 | ES | Futures | 3111.29 | 3111.84 | 3109.93 | 3110.2 | 2755.0 |
| 2018-08-08 20:30:00 | ES | Futures | 3110.2 | 3111.02 | 3109.39 | 3110.48 | 2350.0 |
| 2018-08-08 21:00:00 | ES | Futures | 3110.48 | 3111.29 | 3109.11 | 3109.39 | 2479.0 |
| 2018-08-08 21:30:00 | ES | Futures | 3109.39 | 3112.93 | 3109.11 | 3112.65 | 4686.0 |
| 2018-08-08 22:00:00 | ES | Futures | 3112.65 | 3114.02 | 3112.65 | 3113.47 | 2856.0 |
| 2018-08-08 22:30:00 | ES | Futures | 3113.74 | 3115.11 | 3113.2 | 3114.56 | 3584.0 |
| 2018-08-08 23:00:00 | ES | Futures | 3114.29 | 3115.11 | 3114.02 | 3114.56 | 1348.0 |
| 2018-08-08 23:30:00 | ES | Futures | 3114.83 | 3115.38 | 3114.29 | 3114.29 | 802.0 |
| 2018-08-08 00:00:00 | NQ | Futures | 8806.64 | 8809.87 | 8804.87 | 8806.34 | 343.0 |
| 2018-08-08 00:30:00 | NQ | Futures | 8806.05 | 8806.05 | 8795.74 | 8797.8 | 841.0 |
| 2018-08-08 01:00:00 | NQ | Futures | 8797.8 | 8802.22 | 8797.21 | 8798.98 | 565.0 |
| 2018-08-08 01:30:00 | NQ | Futures | 8798.98 | 8801.04 | 8798.39 | 8798.98 | 345.0 |
> showing 50 of 3,132 rows — these rows as CSV