PREVIEW / futures_30min / 2019-05-24
file: by_date/futures_30min/2019/2019-05-24.parquet size: 75 KB rows: 2,780
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-05-24 00:00:00 | ES | Futures | 3066.71 | 3067.25 | 3066.17 | 3066.44 | 2102.0 |
| 2019-05-24 00:30:00 | ES | Futures | 3066.44 | 3067.79 | 3066.17 | 3067.25 | 2036.0 |
| 2019-05-24 01:00:00 | ES | Futures | 3067.25 | 3068.61 | 3066.98 | 3068.34 | 3091.0 |
| 2019-05-24 01:30:00 | ES | Futures | 3068.34 | 3069.42 | 3067.79 | 3069.15 | 4714.0 |
| 2019-05-24 02:00:00 | ES | Futures | 3068.88 | 3068.88 | 3067.25 | 3068.34 | 5229.0 |
| 2019-05-24 02:30:00 | ES | Futures | 3068.34 | 3072.67 | 3067.79 | 3071.05 | 8907.0 |
| 2019-05-24 03:00:00 | ES | Futures | 3071.05 | 3072.67 | 3068.61 | 3071.86 | 14261.0 |
| 2019-05-24 03:30:00 | ES | Futures | 3071.59 | 3074.84 | 3071.32 | 3074.03 | 11149.0 |
| 2019-05-24 04:00:00 | ES | Futures | 3073.76 | 3077.82 | 3073.49 | 3075.66 | 12596.0 |
| 2019-05-24 04:30:00 | ES | Futures | 3075.66 | 3078.1 | 3075.38 | 3075.93 | 8365.0 |
| 2019-05-24 05:00:00 | ES | Futures | 3075.66 | 3078.1 | 3074.84 | 3075.38 | 8480.0 |
| 2019-05-24 05:30:00 | ES | Futures | 3075.66 | 3076.2 | 3072.94 | 3075.93 | 7627.0 |
| 2019-05-24 06:00:00 | ES | Futures | 3075.93 | 3078.91 | 3075.93 | 3078.64 | 9799.0 |
| 2019-05-24 06:30:00 | ES | Futures | 3078.64 | 3079.18 | 3076.2 | 3076.74 | 10324.0 |
| 2019-05-24 07:00:00 | ES | Futures | 3076.74 | 3078.1 | 3075.93 | 3076.74 | 7789.0 |
| 2019-05-24 07:30:00 | ES | Futures | 3076.74 | 3078.91 | 3071.32 | 3071.59 | 31844.0 |
| 2019-05-24 08:00:00 | ES | Futures | 3071.59 | 3073.76 | 3069.69 | 3073.49 | 19171.0 |
| 2019-05-24 08:30:00 | ES | Futures | 3073.22 | 3073.76 | 3069.96 | 3073.49 | 16587.0 |
| 2019-05-24 09:00:00 | ES | Futures | 3073.49 | 3077.55 | 3072.4 | 3077.01 | 26015.0 |
| 2019-05-24 09:30:00 | ES | Futures | 3077.01 | 3081.89 | 3072.67 | 3075.38 | 149057.0 |
| 2019-05-24 10:00:00 | ES | Futures | 3075.38 | 3077.82 | 3069.69 | 3069.69 | 87808.0 |
| 2019-05-24 10:30:00 | ES | Futures | 3069.96 | 3072.4 | 3061.02 | 3061.83 | 104605.0 |
| 2019-05-24 11:00:00 | ES | Futures | 3061.56 | 3064.81 | 3058.85 | 3062.37 | 77910.0 |
| 2019-05-24 11:30:00 | ES | Futures | 3062.1 | 3068.34 | 3062.1 | 3066.17 | 61516.0 |
| 2019-05-24 12:00:00 | ES | Futures | 3066.44 | 3069.15 | 3063.18 | 3068.88 | 43735.0 |
| 2019-05-24 12:30:00 | ES | Futures | 3068.88 | 3072.94 | 3068.61 | 3072.94 | 42770.0 |
| 2019-05-24 13:00:00 | ES | Futures | 3072.94 | 3074.3 | 3068.88 | 3068.88 | 34730.0 |
| 2019-05-24 13:30:00 | ES | Futures | 3069.15 | 3073.49 | 3068.88 | 3069.96 | 24127.0 |
| 2019-05-24 14:00:00 | ES | Futures | 3069.96 | 3070.5 | 3065.35 | 3067.25 | 37816.0 |
| 2019-05-24 14:30:00 | ES | Futures | 3067.25 | 3070.23 | 3066.98 | 3068.34 | 23758.0 |
| 2019-05-24 15:00:00 | ES | Futures | 3068.34 | 3070.78 | 3067.52 | 3070.23 | 40583.0 |
| 2019-05-24 15:30:00 | ES | Futures | 3069.96 | 3070.23 | 3063.73 | 3066.71 | 99234.0 |
| 2019-05-24 16:00:00 | ES | Futures | 3066.71 | 3071.32 | 3065.9 | 3070.78 | 47020.0 |
| 2019-05-24 16:30:00 | ES | Futures | 3071.05 | 3071.32 | 3069.15 | 3069.96 | 4607.0 |
| 2019-05-24 00:00:00 | NQ | Futures | 8543.68 | 8546.59 | 8543.1 | 8543.68 | 528.0 |
| 2019-05-24 00:30:00 | NQ | Futures | 8543.68 | 8550.67 | 8543.39 | 8547.76 | 798.0 |
| 2019-05-24 01:00:00 | NQ | Futures | 8548.34 | 8553.87 | 8546.89 | 8552.71 | 946.0 |
| 2019-05-24 01:30:00 | NQ | Futures | 8552.42 | 8556.79 | 8549.8 | 8553.87 | 1531.0 |
| 2019-05-24 02:00:00 | NQ | Futures | 8553.87 | 8553.87 | 8544.27 | 8547.18 | 2227.0 |
| 2019-05-24 02:30:00 | NQ | Futures | 8547.18 | 8562.32 | 8545.43 | 8558.24 | 4046.0 |
| 2019-05-24 03:00:00 | NQ | Futures | 8557.95 | 8562.9 | 8544.85 | 8555.91 | 5154.0 |
| 2019-05-24 03:30:00 | NQ | Futures | 8555.62 | 8566.39 | 8554.75 | 8564.06 | 3858.0 |
| 2019-05-24 04:00:00 | NQ | Futures | 8564.06 | 8573.96 | 8562.61 | 8566.98 | 4814.0 |
| 2019-05-24 04:30:00 | NQ | Futures | 8566.68 | 8572.51 | 8562.9 | 8564.36 | 3775.0 |
| 2019-05-24 05:00:00 | NQ | Futures | 8563.77 | 8572.51 | 8560.28 | 8563.19 | 2575.0 |
| 2019-05-24 05:30:00 | NQ | Futures | 8563.19 | 8564.36 | 8556.49 | 8562.32 | 2498.0 |
| 2019-05-24 06:00:00 | NQ | Futures | 8562.32 | 8571.34 | 8562.32 | 8570.47 | 2566.0 |
| 2019-05-24 06:30:00 | NQ | Futures | 8569.89 | 8571.63 | 8560.57 | 8563.48 | 3131.0 |
| 2019-05-24 07:00:00 | NQ | Futures | 8563.48 | 8568.14 | 8561.44 | 8563.48 | 1741.0 |
| 2019-05-24 07:30:00 | NQ | Futures | 8563.77 | 8568.14 | 8540.48 | 8544.56 | 8905.0 |
> showing 50 of 2,780 rows — these rows as CSV