PREVIEW / futures_30min / 2018-07-12
file: by_date/futures_30min/2018/2018-07-12.parquet size: 82 KB rows: 3,110
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-12 00:00:00 | ES | Futures | 3033.64 | 3035.27 | 3033.37 | 3034.18 | 2872.0 |
| 2018-07-12 00:30:00 | ES | Futures | 3033.91 | 3034.18 | 3033.09 | 3033.64 | 1128.0 |
| 2018-07-12 01:00:00 | ES | Futures | 3033.37 | 3035.27 | 3033.09 | 3034.46 | 3503.0 |
| 2018-07-12 01:30:00 | ES | Futures | 3034.46 | 3035.27 | 3033.37 | 3033.64 | 2821.0 |
| 2018-07-12 02:00:00 | ES | Futures | 3033.64 | 3035.27 | 3033.09 | 3034.18 | 4877.0 |
| 2018-07-12 02:30:00 | ES | Futures | 3034.46 | 3035.27 | 3033.64 | 3035.0 | 2716.0 |
| 2018-07-12 03:00:00 | ES | Futures | 3034.73 | 3035.0 | 3032.0 | 3033.64 | 6498.0 |
| 2018-07-12 03:30:00 | ES | Futures | 3033.64 | 3034.46 | 3031.46 | 3034.18 | 6350.0 |
| 2018-07-12 04:00:00 | ES | Futures | 3034.18 | 3035.27 | 3032.82 | 3032.82 | 4830.0 |
| 2018-07-12 04:30:00 | ES | Futures | 3032.82 | 3034.46 | 3028.19 | 3032.0 | 11546.0 |
| 2018-07-12 05:00:00 | ES | Futures | 3032.0 | 3038.27 | 3031.73 | 3036.91 | 17704.0 |
| 2018-07-12 05:30:00 | ES | Futures | 3037.18 | 3038.0 | 3035.55 | 3036.91 | 4390.0 |
| 2018-07-12 06:00:00 | ES | Futures | 3037.18 | 3038.0 | 3034.73 | 3037.73 | 5767.0 |
| 2018-07-12 06:30:00 | ES | Futures | 3037.73 | 3041.81 | 3037.45 | 3041.54 | 12114.0 |
| 2018-07-12 07:00:00 | ES | Futures | 3041.54 | 3041.81 | 3039.09 | 3039.91 | 8340.0 |
| 2018-07-12 07:30:00 | ES | Futures | 3039.91 | 3040.72 | 3038.54 | 3039.63 | 6513.0 |
| 2018-07-12 08:00:00 | ES | Futures | 3039.63 | 3040.45 | 3038.54 | 3038.54 | 6036.0 |
| 2018-07-12 08:30:00 | ES | Futures | 3038.82 | 3042.36 | 3038.27 | 3041.27 | 21566.0 |
| 2018-07-12 09:00:00 | ES | Futures | 3041.0 | 3041.54 | 3039.36 | 3040.18 | 13101.0 |
| 2018-07-12 09:30:00 | ES | Futures | 3040.18 | 3041.81 | 3032.82 | 3039.09 | 131476.0 |
| 2018-07-12 10:00:00 | ES | Futures | 3039.09 | 3044.54 | 3038.82 | 3044.54 | 81178.0 |
| 2018-07-12 10:30:00 | ES | Futures | 3044.54 | 3045.63 | 3038.82 | 3040.72 | 65818.0 |
| 2018-07-12 11:00:00 | ES | Futures | 3041.0 | 3044.27 | 3041.0 | 3042.63 | 42864.0 |
| 2018-07-12 11:30:00 | ES | Futures | 3042.63 | 3047.54 | 3039.91 | 3046.99 | 64721.0 |
| 2018-07-12 12:00:00 | ES | Futures | 3046.99 | 3048.35 | 3045.63 | 3048.35 | 36011.0 |
| 2018-07-12 12:30:00 | ES | Futures | 3048.08 | 3051.35 | 3043.18 | 3049.99 | 67312.0 |
| 2018-07-12 13:00:00 | ES | Futures | 3050.26 | 3052.17 | 3047.81 | 3051.08 | 48360.0 |
| 2018-07-12 13:30:00 | ES | Futures | 3051.08 | 3051.89 | 3046.45 | 3047.26 | 38131.0 |
| 2018-07-12 14:00:00 | ES | Futures | 3047.26 | 3048.9 | 3045.63 | 3048.08 | 22777.0 |
| 2018-07-12 14:30:00 | ES | Futures | 3048.35 | 3048.9 | 3046.17 | 3047.54 | 33588.0 |
| 2018-07-12 15:00:00 | ES | Futures | 3047.81 | 3049.72 | 3044.27 | 3049.17 | 48195.0 |
| 2018-07-12 15:30:00 | ES | Futures | 3049.17 | 3052.71 | 3047.54 | 3051.62 | 155391.0 |
| 2018-07-12 16:00:00 | ES | Futures | 3051.35 | 3051.62 | 3046.72 | 3050.26 | 68122.0 |
| 2018-07-12 16:30:00 | ES | Futures | 3049.44 | 3050.53 | 3048.35 | 3049.72 | 6201.0 |
| 2018-07-12 18:00:00 | ES | Futures | 3049.99 | 3051.08 | 3049.44 | 3051.08 | 1493.0 |
| 2018-07-12 18:30:00 | ES | Futures | 3051.08 | 3051.35 | 3048.63 | 3049.99 | 1443.0 |
| 2018-07-12 19:00:00 | ES | Futures | 3049.99 | 3052.17 | 3049.99 | 3051.08 | 2094.0 |
| 2018-07-12 19:30:00 | ES | Futures | 3051.35 | 3055.16 | 3051.08 | 3054.07 | 4389.0 |
| 2018-07-12 20:00:00 | ES | Futures | 3054.07 | 3056.8 | 3053.26 | 3055.71 | 5937.0 |
| 2018-07-12 20:30:00 | ES | Futures | 3055.44 | 3056.25 | 3054.89 | 3055.98 | 1693.0 |
| 2018-07-12 21:00:00 | ES | Futures | 3055.71 | 3056.53 | 3055.16 | 3055.71 | 2343.0 |
| 2018-07-12 21:30:00 | ES | Futures | 3055.44 | 3056.53 | 3053.8 | 3055.44 | 3373.0 |
| 2018-07-12 22:00:00 | ES | Futures | 3055.71 | 3056.53 | 3055.44 | 3055.98 | 2094.0 |
| 2018-07-12 22:30:00 | ES | Futures | 3055.71 | 3056.53 | 3054.89 | 3056.25 | 1886.0 |
| 2018-07-12 23:00:00 | ES | Futures | 3056.25 | 3057.89 | 3055.71 | 3056.25 | 2861.0 |
| 2018-07-12 23:30:00 | ES | Futures | 3056.25 | 3058.43 | 3055.98 | 3057.89 | 3223.0 |
| 2018-07-12 00:00:00 | NQ | Futures | 8581.7 | 8589.36 | 8580.23 | 8584.94 | 1124.0 |
| 2018-07-12 00:30:00 | NQ | Futures | 8584.64 | 8585.53 | 8579.93 | 8580.82 | 710.0 |
| 2018-07-12 01:00:00 | NQ | Futures | 8580.52 | 8590.53 | 8579.93 | 8587.29 | 1284.0 |
| 2018-07-12 01:30:00 | NQ | Futures | 8587.59 | 8591.71 | 8584.06 | 8585.23 | 1024.0 |
> showing 50 of 3,110 rows — these rows as CSV