PREVIEW / futures_30min / 2018-08-07
file: by_date/futures_30min/2018/2018-08-07.parquet size: 80 KB rows: 3,133
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-07 00:00:00 | ES | Futures | 3108.57 | 3108.84 | 3107.75 | 3108.3 | 810.0 |
| 2018-08-07 00:30:00 | ES | Futures | 3108.02 | 3108.57 | 3107.75 | 3108.02 | 918.0 |
| 2018-08-07 01:00:00 | ES | Futures | 3107.75 | 3108.57 | 3107.75 | 3108.3 | 998.0 |
| 2018-08-07 01:30:00 | ES | Futures | 3108.57 | 3108.84 | 3108.02 | 3108.84 | 1366.0 |
| 2018-08-07 02:00:00 | ES | Futures | 3108.84 | 3111.02 | 3108.57 | 3110.75 | 3856.0 |
| 2018-08-07 02:30:00 | ES | Futures | 3110.75 | 3113.2 | 3110.2 | 3111.29 | 6522.0 |
| 2018-08-07 03:00:00 | ES | Futures | 3111.57 | 3113.2 | 3111.02 | 3111.84 | 7310.0 |
| 2018-08-07 03:30:00 | ES | Futures | 3111.57 | 3113.47 | 3111.29 | 3113.2 | 4794.0 |
| 2018-08-07 04:00:00 | ES | Futures | 3113.47 | 3113.74 | 3111.84 | 3113.74 | 5628.0 |
| 2018-08-07 04:30:00 | ES | Futures | 3113.74 | 3115.38 | 3113.2 | 3114.02 | 7153.0 |
| 2018-08-07 05:00:00 | ES | Futures | 3114.02 | 3114.56 | 3112.93 | 3112.93 | 5404.0 |
| 2018-08-07 05:30:00 | ES | Futures | 3113.2 | 3113.74 | 3112.11 | 3112.93 | 3395.0 |
| 2018-08-07 06:00:00 | ES | Futures | 3112.65 | 3113.2 | 3111.57 | 3112.38 | 3911.0 |
| 2018-08-07 06:30:00 | ES | Futures | 3112.38 | 3113.74 | 3112.11 | 3113.2 | 4011.0 |
| 2018-08-07 07:00:00 | ES | Futures | 3113.2 | 3113.74 | 3112.65 | 3113.2 | 3878.0 |
| 2018-08-07 07:30:00 | ES | Futures | 3113.2 | 3113.2 | 3111.57 | 3111.84 | 4531.0 |
| 2018-08-07 08:00:00 | ES | Futures | 3111.57 | 3112.93 | 3111.57 | 3112.11 | 5687.0 |
| 2018-08-07 08:30:00 | ES | Futures | 3112.38 | 3113.2 | 3112.11 | 3112.65 | 5177.0 |
| 2018-08-07 09:00:00 | ES | Futures | 3112.93 | 3114.29 | 3112.93 | 3114.02 | 11691.0 |
| 2018-08-07 09:30:00 | ES | Futures | 3113.74 | 3117.29 | 3112.38 | 3116.74 | 110891.0 |
| 2018-08-07 10:00:00 | ES | Futures | 3116.74 | 3118.65 | 3115.38 | 3118.65 | 60801.0 |
| 2018-08-07 10:30:00 | ES | Futures | 3118.65 | 3121.1 | 3116.74 | 3117.29 | 73020.0 |
| 2018-08-07 11:00:00 | ES | Futures | 3117.56 | 3119.74 | 3115.65 | 3116.47 | 45810.0 |
| 2018-08-07 11:30:00 | ES | Futures | 3116.2 | 3118.38 | 3114.83 | 3117.83 | 39996.0 |
| 2018-08-07 12:00:00 | ES | Futures | 3117.83 | 3120.56 | 3117.56 | 3118.92 | 34790.0 |
| 2018-08-07 12:30:00 | ES | Futures | 3118.92 | 3120.01 | 3117.29 | 3119.47 | 19865.0 |
| 2018-08-07 13:00:00 | ES | Futures | 3119.47 | 3120.28 | 3116.74 | 3117.56 | 26450.0 |
| 2018-08-07 13:30:00 | ES | Futures | 3117.56 | 3120.01 | 3115.92 | 3119.19 | 26209.0 |
| 2018-08-07 14:00:00 | ES | Futures | 3118.92 | 3120.28 | 3117.56 | 3119.19 | 26517.0 |
| 2018-08-07 14:30:00 | ES | Futures | 3119.19 | 3119.19 | 3117.29 | 3119.19 | 26298.0 |
| 2018-08-07 15:00:00 | ES | Futures | 3118.92 | 3119.74 | 3117.01 | 3118.1 | 24903.0 |
| 2018-08-07 15:30:00 | ES | Futures | 3118.38 | 3118.38 | 3114.56 | 3115.65 | 77966.0 |
| 2018-08-07 16:00:00 | ES | Futures | 3115.92 | 3117.56 | 3115.38 | 3116.47 | 51363.0 |
| 2018-08-07 16:30:00 | ES | Futures | 3116.47 | 3118.38 | 3116.2 | 3117.83 | 6936.0 |
| 2018-08-07 18:00:00 | ES | Futures | 3117.56 | 3117.83 | 3115.92 | 3116.47 | 2080.0 |
| 2018-08-07 18:30:00 | ES | Futures | 3116.47 | 3117.29 | 3115.38 | 3115.65 | 1030.0 |
| 2018-08-07 19:00:00 | ES | Futures | 3115.65 | 3116.74 | 3115.65 | 3116.47 | 1058.0 |
| 2018-08-07 19:30:00 | ES | Futures | 3116.2 | 3116.47 | 3115.38 | 3115.92 | 1246.0 |
| 2018-08-07 20:00:00 | ES | Futures | 3115.65 | 3118.38 | 3115.65 | 3117.56 | 3283.0 |
| 2018-08-07 20:30:00 | ES | Futures | 3117.56 | 3118.1 | 3116.74 | 3116.74 | 1432.0 |
| 2018-08-07 21:00:00 | ES | Futures | 3116.74 | 3118.38 | 3116.47 | 3116.74 | 2441.0 |
| 2018-08-07 21:30:00 | ES | Futures | 3116.74 | 3117.83 | 3115.92 | 3117.01 | 2507.0 |
| 2018-08-07 22:00:00 | ES | Futures | 3117.29 | 3117.29 | 3116.2 | 3116.47 | 1486.0 |
| 2018-08-07 22:30:00 | ES | Futures | 3116.47 | 3117.56 | 3116.2 | 3117.01 | 830.0 |
| 2018-08-07 23:00:00 | ES | Futures | 3117.01 | 3117.56 | 3117.01 | 3117.29 | 744.0 |
| 2018-08-07 23:30:00 | ES | Futures | 3117.29 | 3118.1 | 3117.29 | 3117.83 | 1210.0 |
| 2018-08-07 00:00:00 | NQ | Futures | 8781.61 | 8784.26 | 8780.73 | 8783.08 | 403.0 |
| 2018-08-07 00:30:00 | NQ | Futures | 8783.08 | 8785.44 | 8781.9 | 8782.79 | 424.0 |
| 2018-08-07 01:00:00 | NQ | Futures | 8782.49 | 8784.26 | 8780.73 | 8782.2 | 545.0 |
| 2018-08-07 01:30:00 | NQ | Futures | 8782.2 | 8784.55 | 8780.73 | 8784.55 | 400.0 |
> showing 50 of 3,133 rows — these rows as CSV