PREVIEW / futures_30min / 2018-06-07
file: by_date/futures_30min/2018/2018-06-07.parquet size: 88 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-06-07 00:00:00 | ES | Futures | 3028.46 | 3029.01 | 3028.19 | 3028.46 | 921.0 |
| 2018-06-07 00:30:00 | ES | Futures | 3028.73 | 3028.73 | 3028.19 | 3028.19 | 737.0 |
| 2018-06-07 01:00:00 | ES | Futures | 3028.19 | 3028.73 | 3028.19 | 3028.19 | 1017.0 |
| 2018-06-07 01:30:00 | ES | Futures | 3028.19 | 3029.55 | 3028.19 | 3029.55 | 1560.0 |
| 2018-06-07 02:00:00 | ES | Futures | 3029.55 | 3032.01 | 3028.73 | 3031.74 | 4778.0 |
| 2018-06-07 02:30:00 | ES | Futures | 3031.74 | 3033.37 | 3031.46 | 3032.01 | 5294.0 |
| 2018-06-07 03:00:00 | ES | Futures | 3032.01 | 3033.37 | 3029.83 | 3033.1 | 6678.0 |
| 2018-06-07 03:30:00 | ES | Futures | 3033.1 | 3034.46 | 3031.74 | 3032.55 | 10103.0 |
| 2018-06-07 04:00:00 | ES | Futures | 3032.55 | 3033.1 | 3029.55 | 3030.92 | 7656.0 |
| 2018-06-07 04:30:00 | ES | Futures | 3031.19 | 3031.19 | 3027.64 | 3027.64 | 8086.0 |
| 2018-06-07 05:00:00 | ES | Futures | 3027.64 | 3029.55 | 3027.1 | 3029.01 | 4199.0 |
| 2018-06-07 05:30:00 | ES | Futures | 3029.28 | 3029.55 | 3027.1 | 3028.73 | 3491.0 |
| 2018-06-07 06:00:00 | ES | Futures | 3028.46 | 3028.73 | 3026.28 | 3027.37 | 6263.0 |
| 2018-06-07 06:30:00 | ES | Futures | 3027.1 | 3030.1 | 3026.82 | 3030.1 | 4783.0 |
| 2018-06-07 07:00:00 | ES | Futures | 3030.1 | 3031.19 | 3029.28 | 3029.55 | 5363.0 |
| 2018-06-07 07:30:00 | ES | Futures | 3029.55 | 3030.1 | 3027.1 | 3028.46 | 5053.0 |
| 2018-06-07 08:00:00 | ES | Futures | 3028.46 | 3030.64 | 3027.91 | 3029.01 | 6191.0 |
| 2018-06-07 08:30:00 | ES | Futures | 3029.01 | 3029.55 | 3027.64 | 3029.01 | 7238.0 |
| 2018-06-07 09:00:00 | ES | Futures | 3029.01 | 3030.92 | 3027.91 | 3030.92 | 11203.0 |
| 2018-06-07 09:30:00 | ES | Futures | 3030.64 | 3034.19 | 3027.37 | 3031.46 | 120161.0 |
| 2018-06-07 10:00:00 | ES | Futures | 3031.74 | 3033.92 | 3024.91 | 3026.0 | 100982.0 |
| 2018-06-07 10:30:00 | ES | Futures | 3026.0 | 3026.55 | 3019.18 | 3025.73 | 119245.0 |
| 2018-06-07 11:00:00 | ES | Futures | 3025.73 | 3030.37 | 3022.18 | 3026.82 | 78455.0 |
| 2018-06-07 11:30:00 | ES | Futures | 3026.55 | 3028.73 | 3022.18 | 3024.37 | 56063.0 |
| 2018-06-07 12:00:00 | ES | Futures | 3024.37 | 3028.46 | 3024.37 | 3027.37 | 32760.0 |
| 2018-06-07 12:30:00 | ES | Futures | 3027.37 | 3027.64 | 3020.27 | 3023.28 | 57973.0 |
| 2018-06-07 13:00:00 | ES | Futures | 3023.28 | 3024.09 | 3017.54 | 3018.09 | 60684.0 |
| 2018-06-07 13:30:00 | ES | Futures | 3017.82 | 3020.82 | 3012.9 | 3014.54 | 108595.0 |
| 2018-06-07 14:00:00 | ES | Futures | 3014.82 | 3021.36 | 3012.9 | 3020.55 | 76402.0 |
| 2018-06-07 14:30:00 | ES | Futures | 3020.55 | 3024.64 | 3019.45 | 3022.46 | 58825.0 |
| 2018-06-07 15:00:00 | ES | Futures | 3022.46 | 3025.46 | 3018.09 | 3023.82 | 56388.0 |
| 2018-06-07 15:30:00 | ES | Futures | 3023.82 | 3026.28 | 3020.27 | 3023.55 | 125234.0 |
| 2018-06-07 16:00:00 | ES | Futures | 3023.82 | 3029.01 | 3023.28 | 3025.73 | 62673.0 |
| 2018-06-07 16:30:00 | ES | Futures | 3025.46 | 3027.37 | 3024.64 | 3027.1 | 6197.0 |
| 2018-06-07 18:00:00 | ES | Futures | 3024.91 | 3026.55 | 3024.37 | 3026.0 | 2158.0 |
| 2018-06-07 18:30:00 | ES | Futures | 3026.0 | 3026.28 | 3024.91 | 3025.19 | 789.0 |
| 2018-06-07 19:00:00 | ES | Futures | 3025.19 | 3025.46 | 3023.55 | 3024.09 | 560.0 |
| 2018-06-07 19:30:00 | ES | Futures | 3024.37 | 3027.37 | 3024.37 | 3026.55 | 1448.0 |
| 2018-06-07 20:00:00 | ES | Futures | 3026.82 | 3027.37 | 3024.64 | 3026.28 | 2268.0 |
| 2018-06-07 20:30:00 | ES | Futures | 3026.28 | 3028.19 | 3026.28 | 3027.64 | 1535.0 |
| 2018-06-07 21:00:00 | ES | Futures | 3027.91 | 3029.28 | 3026.55 | 3027.37 | 2376.0 |
| 2018-06-07 21:30:00 | ES | Futures | 3027.37 | 3028.19 | 3025.73 | 3025.73 | 1946.0 |
| 2018-06-07 22:00:00 | ES | Futures | 3026.0 | 3026.55 | 3024.09 | 3025.19 | 2182.0 |
| 2018-06-07 22:30:00 | ES | Futures | 3024.91 | 3026.0 | 3024.64 | 3025.19 | 750.0 |
| 2018-06-07 23:00:00 | ES | Futures | 3025.46 | 3025.73 | 3023.82 | 3024.64 | 1142.0 |
| 2018-06-07 23:30:00 | ES | Futures | 3024.37 | 3024.37 | 3022.73 | 3023.28 | 1372.0 |
| 2018-06-07 00:00:00 | NQ | Futures | 8541.77 | 8542.36 | 8541.17 | 8542.06 | 258.0 |
| 2018-06-07 00:30:00 | NQ | Futures | 8542.06 | 8542.95 | 8539.4 | 8540.58 | 448.0 |
| 2018-06-07 01:00:00 | NQ | Futures | 8540.29 | 8541.77 | 8538.81 | 8538.81 | 434.0 |
| 2018-06-07 01:30:00 | NQ | Futures | 8538.81 | 8541.47 | 8537.92 | 8540.88 | 458.0 |
> showing 50 of 3,133 rows — these rows as CSV