PREVIEW / futures_30min / 2019-04-02
file: by_date/futures_30min/2019/2019-04-02.parquet size: 86 KB rows: 3,315
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-02 00:00:00 | ES | Futures | 3108.46 | 3109.27 | 3107.65 | 3108.46 | 2665.0 |
| 2019-04-02 00:30:00 | ES | Futures | 3108.19 | 3108.73 | 3107.65 | 3108.19 | 1262.0 |
| 2019-04-02 01:00:00 | ES | Futures | 3108.46 | 3109.27 | 3107.65 | 3109.0 | 2258.0 |
| 2019-04-02 01:30:00 | ES | Futures | 3109.0 | 3109.54 | 3108.19 | 3108.19 | 1272.0 |
| 2019-04-02 02:00:00 | ES | Futures | 3108.46 | 3109.27 | 3107.37 | 3108.46 | 3658.0 |
| 2019-04-02 02:30:00 | ES | Futures | 3108.73 | 3109.0 | 3107.65 | 3108.46 | 1948.0 |
| 2019-04-02 03:00:00 | ES | Futures | 3108.73 | 3109.54 | 3106.83 | 3107.1 | 7333.0 |
| 2019-04-02 03:30:00 | ES | Futures | 3107.37 | 3109.27 | 3106.29 | 3108.46 | 6347.0 |
| 2019-04-02 04:00:00 | ES | Futures | 3108.46 | 3110.63 | 3107.92 | 3110.09 | 4363.0 |
| 2019-04-02 04:30:00 | ES | Futures | 3110.09 | 3110.63 | 3108.19 | 3109.27 | 5552.0 |
| 2019-04-02 05:00:00 | ES | Futures | 3109.0 | 3111.71 | 3108.46 | 3111.44 | 5891.0 |
| 2019-04-02 05:30:00 | ES | Futures | 3111.17 | 3112.53 | 3110.63 | 3112.25 | 4502.0 |
| 2019-04-02 06:00:00 | ES | Futures | 3111.98 | 3113.34 | 3111.17 | 3112.8 | 3678.0 |
| 2019-04-02 06:30:00 | ES | Futures | 3112.8 | 3113.88 | 3112.53 | 3113.07 | 5512.0 |
| 2019-04-02 07:00:00 | ES | Futures | 3113.07 | 3114.97 | 3112.8 | 3113.07 | 6442.0 |
| 2019-04-02 07:30:00 | ES | Futures | 3113.07 | 3114.97 | 3113.07 | 3114.42 | 4998.0 |
| 2019-04-02 08:00:00 | ES | Futures | 3114.42 | 3116.32 | 3113.88 | 3114.42 | 9477.0 |
| 2019-04-02 08:30:00 | ES | Futures | 3114.42 | 3115.78 | 3113.61 | 3115.24 | 8725.0 |
| 2019-04-02 09:00:00 | ES | Futures | 3114.97 | 3115.24 | 3112.8 | 3114.15 | 13559.0 |
| 2019-04-02 09:30:00 | ES | Futures | 3114.15 | 3114.69 | 3109.0 | 3113.34 | 121970.0 |
| 2019-04-02 10:00:00 | ES | Futures | 3113.07 | 3114.15 | 3107.65 | 3114.15 | 76270.0 |
| 2019-04-02 10:30:00 | ES | Futures | 3113.88 | 3114.15 | 3109.81 | 3110.09 | 56331.0 |
| 2019-04-02 11:00:00 | ES | Futures | 3109.81 | 3110.9 | 3103.85 | 3110.36 | 90694.0 |
| 2019-04-02 11:30:00 | ES | Futures | 3110.63 | 3112.8 | 3107.65 | 3111.71 | 47120.0 |
| 2019-04-02 12:00:00 | ES | Futures | 3111.44 | 3113.34 | 3107.92 | 3109.27 | 38407.0 |
| 2019-04-02 12:30:00 | ES | Futures | 3109.0 | 3110.9 | 3108.73 | 3110.09 | 27633.0 |
| 2019-04-02 13:00:00 | ES | Futures | 3110.36 | 3112.8 | 3108.73 | 3111.44 | 32206.0 |
| 2019-04-02 13:30:00 | ES | Futures | 3111.71 | 3113.34 | 3110.63 | 3111.44 | 23279.0 |
| 2019-04-02 14:00:00 | ES | Futures | 3111.44 | 3113.07 | 3110.63 | 3112.8 | 19718.0 |
| 2019-04-02 14:30:00 | ES | Futures | 3112.53 | 3113.88 | 3111.71 | 3113.88 | 21419.0 |
| 2019-04-02 15:00:00 | ES | Futures | 3113.88 | 3114.97 | 3113.61 | 3114.42 | 26654.0 |
| 2019-04-02 15:30:00 | ES | Futures | 3114.42 | 3116.32 | 3113.07 | 3113.88 | 80347.0 |
| 2019-04-02 16:00:00 | ES | Futures | 3113.61 | 3113.88 | 3108.73 | 3109.27 | 42732.0 |
| 2019-04-02 16:30:00 | ES | Futures | 3109.0 | 3109.0 | 3107.92 | 3108.46 | 5166.0 |
| 2019-04-02 18:00:00 | ES | Futures | 3107.92 | 3110.63 | 3107.65 | 3109.81 | 2749.0 |
| 2019-04-02 18:30:00 | ES | Futures | 3110.09 | 3110.63 | 3109.54 | 3109.81 | 1022.0 |
| 2019-04-02 19:00:00 | ES | Futures | 3110.09 | 3110.09 | 3108.46 | 3108.46 | 1757.0 |
| 2019-04-02 19:30:00 | ES | Futures | 3108.46 | 3110.36 | 3108.46 | 3109.0 | 1647.0 |
| 2019-04-02 20:00:00 | ES | Futures | 3109.0 | 3109.54 | 3107.1 | 3109.27 | 4152.0 |
| 2019-04-02 20:30:00 | ES | Futures | 3109.27 | 3121.74 | 3109.27 | 3120.12 | 20850.0 |
| 2019-04-02 21:00:00 | ES | Futures | 3120.39 | 3120.93 | 3115.51 | 3119.03 | 12502.0 |
| 2019-04-02 21:30:00 | ES | Futures | 3119.03 | 3125.54 | 3118.22 | 3122.83 | 15382.0 |
| 2019-04-02 22:00:00 | ES | Futures | 3122.83 | 3123.64 | 3121.47 | 3123.1 | 4767.0 |
| 2019-04-02 22:30:00 | ES | Futures | 3123.1 | 3124.18 | 3122.28 | 3122.83 | 2443.0 |
| 2019-04-02 23:00:00 | ES | Futures | 3122.83 | 3123.1 | 3121.2 | 3122.01 | 2231.0 |
| 2019-04-02 23:30:00 | ES | Futures | 3122.01 | 3122.56 | 3121.2 | 3121.74 | 1669.0 |
| 2019-04-02 00:00:00 | NQ | Futures | 8720.41 | 8722.16 | 8717.5 | 8720.12 | 1175.0 |
| 2019-04-02 00:30:00 | NQ | Futures | 8719.83 | 8720.71 | 8717.5 | 8719.83 | 810.0 |
| 2019-04-02 01:00:00 | NQ | Futures | 8719.83 | 8722.74 | 8717.5 | 8722.74 | 1036.0 |
| 2019-04-02 01:30:00 | NQ | Futures | 8722.74 | 8724.49 | 8718.96 | 8720.71 | 937.0 |
> showing 50 of 3,315 rows — these rows as CSV