PREVIEW / futures_30min / 2019-05-27
file: by_date/futures_30min/2019/2019-05-27.parquet size: 60 KB rows: 2,351
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-27 00:00:00 | ES | Futures | 3068.61 | 3068.88 | 3066.98 | 3068.06 | 947.0 |
| 2019-05-27 00:30:00 | ES | Futures | 3068.06 | 3068.34 | 3066.44 | 3066.71 | 1038.0 |
| 2019-05-27 01:00:00 | ES | Futures | 3066.44 | 3069.15 | 3066.44 | 3068.61 | 1756.0 |
| 2019-05-27 01:30:00 | ES | Futures | 3068.88 | 3070.23 | 3067.52 | 3069.69 | 2258.0 |
| 2019-05-27 02:00:00 | ES | Futures | 3069.69 | 3074.03 | 3069.15 | 3071.86 | 4145.0 |
| 2019-05-27 02:30:00 | ES | Futures | 3071.86 | 3074.03 | 3071.05 | 3073.76 | 3044.0 |
| 2019-05-27 03:00:00 | ES | Futures | 3073.76 | 3078.91 | 3072.67 | 3075.93 | 7862.0 |
| 2019-05-27 03:30:00 | ES | Futures | 3075.93 | 3077.01 | 3073.76 | 3075.11 | 4689.0 |
| 2019-05-27 04:00:00 | ES | Futures | 3075.38 | 3075.93 | 3071.86 | 3072.13 | 5928.0 |
| 2019-05-27 04:30:00 | ES | Futures | 3072.4 | 3074.57 | 3070.78 | 3071.59 | 4710.0 |
| 2019-05-27 05:00:00 | ES | Futures | 3071.86 | 3071.86 | 3069.42 | 3070.78 | 3720.0 |
| 2019-05-27 05:30:00 | ES | Futures | 3070.5 | 3072.94 | 3068.34 | 3069.96 | 5232.0 |
| 2019-05-27 06:00:00 | ES | Futures | 3069.96 | 3069.96 | 3066.98 | 3067.52 | 3151.0 |
| 2019-05-27 06:30:00 | ES | Futures | 3067.52 | 3069.96 | 3066.98 | 3069.15 | 4343.0 |
| 2019-05-27 07:00:00 | ES | Futures | 3069.15 | 3069.96 | 3068.06 | 3069.42 | 1407.0 |
| 2019-05-27 07:30:00 | ES | Futures | 3069.69 | 3070.5 | 3068.61 | 3068.88 | 2018.0 |
| 2019-05-27 08:00:00 | ES | Futures | 3069.15 | 3070.5 | 3068.06 | 3069.42 | 2317.0 |
| 2019-05-27 08:30:00 | ES | Futures | 3069.69 | 3071.05 | 3069.15 | 3069.42 | 3358.0 |
| 2019-05-27 09:00:00 | ES | Futures | 3069.42 | 3070.78 | 3067.79 | 3068.06 | 3312.0 |
| 2019-05-27 09:30:00 | ES | Futures | 3067.79 | 3069.42 | 3067.52 | 3067.79 | 6689.0 |
| 2019-05-27 10:00:00 | ES | Futures | 3068.06 | 3068.61 | 3066.71 | 3068.06 | 7866.0 |
| 2019-05-27 10:30:00 | ES | Futures | 3068.06 | 3069.69 | 3068.06 | 3069.15 | 4965.0 |
| 2019-05-27 11:00:00 | ES | Futures | 3069.42 | 3069.69 | 3068.06 | 3068.61 | 7383.0 |
| 2019-05-27 11:30:00 | ES | Futures | 3068.61 | 3068.88 | 3066.17 | 3067.25 | 7711.0 |
| 2019-05-27 12:00:00 | ES | Futures | 3067.25 | 3068.88 | 3066.98 | 3068.34 | 2275.0 |
| 2019-05-27 12:30:00 | ES | Futures | 3068.61 | 3071.32 | 3068.34 | 3070.78 | 4058.0 |
| 2019-05-27 18:00:00 | ES | Futures | 3068.88 | 3072.67 | 3068.88 | 3072.4 | 3093.0 |
| 2019-05-27 18:30:00 | ES | Futures | 3072.67 | 3075.66 | 3071.59 | 3073.49 | 4038.0 |
| 2019-05-27 19:00:00 | ES | Futures | 3073.49 | 3073.76 | 3072.13 | 3073.49 | 3959.0 |
| 2019-05-27 19:30:00 | ES | Futures | 3073.22 | 3073.76 | 3071.86 | 3072.4 | 3076.0 |
| 2019-05-27 20:00:00 | ES | Futures | 3072.67 | 3076.74 | 3071.05 | 3074.57 | 6540.0 |
| 2019-05-27 20:30:00 | ES | Futures | 3074.84 | 3077.01 | 3074.84 | 3076.47 | 3154.0 |
| 2019-05-27 21:00:00 | ES | Futures | 3076.47 | 3076.47 | 3073.22 | 3074.03 | 3985.0 |
| 2019-05-27 21:30:00 | ES | Futures | 3074.03 | 3078.37 | 3073.22 | 3078.1 | 5131.0 |
| 2019-05-27 22:00:00 | ES | Futures | 3077.82 | 3078.37 | 3076.47 | 3077.01 | 3396.0 |
| 2019-05-27 22:30:00 | ES | Futures | 3077.01 | 3078.91 | 3075.93 | 3078.64 | 2849.0 |
| 2019-05-27 23:00:00 | ES | Futures | 3078.37 | 3078.64 | 3076.74 | 3077.28 | 2063.0 |
| 2019-05-27 23:30:00 | ES | Futures | 3077.55 | 3078.1 | 3077.01 | 3077.55 | 1659.0 |
| 2019-05-27 00:00:00 | NQ | Futures | 8505.25 | 8506.71 | 8497.97 | 8501.76 | 731.0 |
| 2019-05-27 00:30:00 | NQ | Futures | 8502.05 | 8502.34 | 8495.06 | 8495.06 | 851.0 |
| 2019-05-27 01:00:00 | NQ | Futures | 8495.06 | 8504.96 | 8495.06 | 8502.92 | 1148.0 |
| 2019-05-27 01:30:00 | NQ | Futures | 8502.92 | 8509.33 | 8497.1 | 8507.0 | 1434.0 |
| 2019-05-27 02:00:00 | NQ | Futures | 8507.29 | 8524.47 | 8506.12 | 8520.1 | 2530.0 |
| 2019-05-27 02:30:00 | NQ | Futures | 8519.81 | 8529.42 | 8517.77 | 8528.54 | 1948.0 |
| 2019-05-27 03:00:00 | NQ | Futures | 8528.54 | 8546.59 | 8525.63 | 8538.44 | 4082.0 |
| 2019-05-27 03:30:00 | NQ | Futures | 8537.86 | 8541.06 | 8531.16 | 8538.15 | 2437.0 |
| 2019-05-27 04:00:00 | NQ | Futures | 8538.44 | 8540.19 | 8527.09 | 8528.54 | 2153.0 |
| 2019-05-27 04:30:00 | NQ | Futures | 8528.54 | 8535.24 | 8522.43 | 8526.21 | 2168.0 |
| 2019-05-27 05:00:00 | NQ | Futures | 8526.8 | 8527.38 | 8516.9 | 8522.14 | 1731.0 |
| 2019-05-27 05:30:00 | NQ | Futures | 8522.14 | 8530.0 | 8519.23 | 8522.14 | 1859.0 |
> showing 50 of 2,351 rows — these rows as CSV