PREVIEW / futures_30min / 2018-07-10
file: by_date/futures_30min/2018/2018-07-10.parquet size: 85 KB rows: 3,151
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-07-10 00:00:00 | ES | Futures | 3043.18 | 3043.99 | 3042.9 | 3043.45 | 1612.0 |
| 2018-07-10 00:30:00 | ES | Futures | 3043.45 | 3043.99 | 3043.18 | 3043.72 | 1342.0 |
| 2018-07-10 01:00:00 | ES | Futures | 3043.72 | 3044.81 | 3043.45 | 3043.72 | 2110.0 |
| 2018-07-10 01:30:00 | ES | Futures | 3043.45 | 3043.72 | 3041.0 | 3041.27 | 3590.0 |
| 2018-07-10 02:00:00 | ES | Futures | 3041.54 | 3041.54 | 3038.82 | 3040.45 | 6940.0 |
| 2018-07-10 02:30:00 | ES | Futures | 3040.45 | 3041.54 | 3039.91 | 3041.54 | 3494.0 |
| 2018-07-10 03:00:00 | ES | Futures | 3041.54 | 3042.36 | 3039.91 | 3040.45 | 5398.0 |
| 2018-07-10 03:30:00 | ES | Futures | 3040.45 | 3041.0 | 3038.27 | 3039.36 | 5000.0 |
| 2018-07-10 04:00:00 | ES | Futures | 3039.36 | 3041.54 | 3038.82 | 3041.54 | 5417.0 |
| 2018-07-10 04:30:00 | ES | Futures | 3041.54 | 3041.54 | 3039.09 | 3039.63 | 4891.0 |
| 2018-07-10 05:00:00 | ES | Futures | 3039.91 | 3041.27 | 3039.63 | 3040.72 | 3517.0 |
| 2018-07-10 05:30:00 | ES | Futures | 3040.45 | 3043.18 | 3040.45 | 3042.63 | 4147.0 |
| 2018-07-10 06:00:00 | ES | Futures | 3042.36 | 3043.72 | 3042.09 | 3043.18 | 3933.0 |
| 2018-07-10 06:30:00 | ES | Futures | 3043.18 | 3045.08 | 3041.81 | 3041.81 | 5862.0 |
| 2018-07-10 07:00:00 | ES | Futures | 3041.81 | 3045.63 | 3041.54 | 3044.81 | 7393.0 |
| 2018-07-10 07:30:00 | ES | Futures | 3045.08 | 3045.36 | 3042.9 | 3043.18 | 5329.0 |
| 2018-07-10 08:00:00 | ES | Futures | 3042.9 | 3043.18 | 3039.09 | 3039.09 | 10912.0 |
| 2018-07-10 08:30:00 | ES | Futures | 3039.09 | 3042.9 | 3038.82 | 3042.36 | 11337.0 |
| 2018-07-10 09:00:00 | ES | Futures | 3042.09 | 3043.72 | 3041.54 | 3042.63 | 13037.0 |
| 2018-07-10 09:30:00 | ES | Futures | 3042.63 | 3044.81 | 3039.63 | 3044.27 | 129694.0 |
| 2018-07-10 10:00:00 | ES | Futures | 3043.99 | 3046.99 | 3042.09 | 3044.54 | 87239.0 |
| 2018-07-10 10:30:00 | ES | Futures | 3044.54 | 3049.17 | 3044.27 | 3047.81 | 61922.0 |
| 2018-07-10 11:00:00 | ES | Futures | 3047.81 | 3049.17 | 3042.36 | 3043.72 | 58130.0 |
| 2018-07-10 11:30:00 | ES | Futures | 3043.72 | 3047.81 | 3042.63 | 3047.81 | 32457.0 |
| 2018-07-10 12:00:00 | ES | Futures | 3047.54 | 3047.81 | 3045.08 | 3046.99 | 29796.0 |
| 2018-07-10 12:30:00 | ES | Futures | 3046.72 | 3047.26 | 3043.45 | 3044.81 | 22716.0 |
| 2018-07-10 13:00:00 | ES | Futures | 3044.54 | 3045.9 | 3042.63 | 3042.9 | 38221.0 |
| 2018-07-10 13:30:00 | ES | Futures | 3042.63 | 3043.18 | 3039.09 | 3042.36 | 40419.0 |
| 2018-07-10 14:00:00 | ES | Futures | 3042.36 | 3046.17 | 3042.09 | 3044.54 | 24104.0 |
| 2018-07-10 14:30:00 | ES | Futures | 3044.81 | 3046.72 | 3043.72 | 3046.45 | 27427.0 |
| 2018-07-10 15:00:00 | ES | Futures | 3046.45 | 3047.54 | 3044.81 | 3045.9 | 27380.0 |
| 2018-07-10 15:30:00 | ES | Futures | 3045.9 | 3048.9 | 3044.81 | 3046.99 | 97977.0 |
| 2018-07-10 16:00:00 | ES | Futures | 3046.72 | 3049.17 | 3046.17 | 3047.81 | 49837.0 |
| 2018-07-10 16:30:00 | ES | Futures | 3048.08 | 3049.17 | 3030.37 | 3036.36 | 26220.0 |
| 2018-07-10 18:00:00 | ES | Futures | 3030.64 | 3037.45 | 3022.74 | 3025.74 | 35282.0 |
| 2018-07-10 18:30:00 | ES | Futures | 3026.01 | 3028.74 | 3021.65 | 3022.2 | 14783.0 |
| 2018-07-10 19:00:00 | ES | Futures | 3022.2 | 3028.46 | 3022.2 | 3023.01 | 9555.0 |
| 2018-07-10 19:30:00 | ES | Futures | 3023.01 | 3025.47 | 3021.65 | 3024.38 | 6440.0 |
| 2018-07-10 20:00:00 | ES | Futures | 3024.65 | 3025.47 | 3023.01 | 3024.1 | 7502.0 |
| 2018-07-10 20:30:00 | ES | Futures | 3024.38 | 3024.38 | 3019.47 | 3020.29 | 10714.0 |
| 2018-07-10 21:00:00 | ES | Futures | 3020.29 | 3020.29 | 3014.29 | 3019.47 | 18633.0 |
| 2018-07-10 21:30:00 | ES | Futures | 3019.74 | 3024.38 | 3018.38 | 3024.1 | 12712.0 |
| 2018-07-10 22:00:00 | ES | Futures | 3024.1 | 3026.56 | 3022.74 | 3026.28 | 9755.0 |
| 2018-07-10 22:30:00 | ES | Futures | 3026.28 | 3029.28 | 3025.47 | 3027.65 | 9779.0 |
| 2018-07-10 23:00:00 | ES | Futures | 3027.92 | 3028.46 | 3026.28 | 3027.65 | 4481.0 |
| 2018-07-10 23:30:00 | ES | Futures | 3027.65 | 3030.92 | 3027.65 | 3029.28 | 4222.0 |
| 2018-07-10 00:00:00 | NQ | Futures | 8626.45 | 8627.63 | 8624.69 | 8625.27 | 509.0 |
| 2018-07-10 00:30:00 | NQ | Futures | 8625.27 | 8628.81 | 8624.98 | 8627.63 | 452.0 |
| 2018-07-10 01:00:00 | NQ | Futures | 8627.34 | 8629.98 | 8624.98 | 8626.16 | 649.0 |
| 2018-07-10 01:30:00 | NQ | Futures | 8625.86 | 8626.16 | 8614.68 | 8617.91 | 1480.0 |
> showing 50 of 3,151 rows — these rows as CSV