PREVIEW / futures_30min / 2019-07-17
file: by_date/futures_30min/2019/2019-07-17.parquet size: 93 KB rows: 3,422
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-07-17 00:00:00 | ES | Futures | 3257.39 | 3257.94 | 3257.12 | 3257.66 | 1274.0 |
| 2019-07-17 00:30:00 | ES | Futures | 3257.66 | 3258.75 | 3257.66 | 3258.48 | 824.0 |
| 2019-07-17 01:00:00 | ES | Futures | 3258.48 | 3258.48 | 3257.66 | 3258.21 | 1034.0 |
| 2019-07-17 01:30:00 | ES | Futures | 3257.94 | 3259.29 | 3257.66 | 3258.48 | 1574.0 |
| 2019-07-17 02:00:00 | ES | Futures | 3258.48 | 3259.02 | 3257.12 | 3258.48 | 4395.0 |
| 2019-07-17 02:30:00 | ES | Futures | 3258.48 | 3258.48 | 3257.39 | 3258.48 | 2587.0 |
| 2019-07-17 03:00:00 | ES | Futures | 3258.75 | 3260.37 | 3257.94 | 3259.56 | 11329.0 |
| 2019-07-17 03:30:00 | ES | Futures | 3259.29 | 3260.37 | 3258.48 | 3259.83 | 6529.0 |
| 2019-07-17 04:00:00 | ES | Futures | 3259.83 | 3262.54 | 3259.56 | 3261.73 | 9634.0 |
| 2019-07-17 04:30:00 | ES | Futures | 3261.45 | 3261.73 | 3259.83 | 3260.1 | 6913.0 |
| 2019-07-17 05:00:00 | ES | Futures | 3260.1 | 3261.73 | 3259.83 | 3261.18 | 5998.0 |
| 2019-07-17 05:30:00 | ES | Futures | 3261.45 | 3262.27 | 3260.91 | 3262.27 | 5422.0 |
| 2019-07-17 06:00:00 | ES | Futures | 3262.0 | 3262.27 | 3259.29 | 3259.83 | 6546.0 |
| 2019-07-17 06:30:00 | ES | Futures | 3259.56 | 3259.83 | 3257.39 | 3258.75 | 5451.0 |
| 2019-07-17 07:00:00 | ES | Futures | 3258.48 | 3258.75 | 3256.58 | 3257.39 | 4842.0 |
| 2019-07-17 07:30:00 | ES | Futures | 3257.12 | 3258.75 | 3255.23 | 3258.75 | 7473.0 |
| 2019-07-17 08:00:00 | ES | Futures | 3258.48 | 3258.75 | 3257.39 | 3257.94 | 4622.0 |
| 2019-07-17 08:30:00 | ES | Futures | 3257.94 | 3258.21 | 3254.42 | 3255.23 | 14733.0 |
| 2019-07-17 09:00:00 | ES | Futures | 3255.5 | 3257.66 | 3254.42 | 3256.58 | 19652.0 |
| 2019-07-17 09:30:00 | ES | Futures | 3256.31 | 3258.48 | 3252.52 | 3254.42 | 105716.0 |
| 2019-07-17 10:00:00 | ES | Futures | 3254.15 | 3255.5 | 3248.46 | 3248.46 | 80230.0 |
| 2019-07-17 10:30:00 | ES | Futures | 3248.46 | 3250.36 | 3240.88 | 3244.67 | 106814.0 |
| 2019-07-17 11:00:00 | ES | Futures | 3244.67 | 3247.92 | 3244.4 | 3246.02 | 60927.0 |
| 2019-07-17 11:30:00 | ES | Futures | 3245.75 | 3251.17 | 3245.21 | 3249.0 | 52600.0 |
| 2019-07-17 12:00:00 | ES | Futures | 3249.0 | 3249.54 | 3245.48 | 3246.3 | 36434.0 |
| 2019-07-17 12:30:00 | ES | Futures | 3246.3 | 3248.46 | 3246.3 | 3247.38 | 23383.0 |
| 2019-07-17 13:00:00 | ES | Futures | 3247.38 | 3248.19 | 3245.48 | 3246.57 | 23797.0 |
| 2019-07-17 13:30:00 | ES | Futures | 3246.57 | 3249.81 | 3246.57 | 3247.92 | 22025.0 |
| 2019-07-17 14:00:00 | ES | Futures | 3247.92 | 3248.19 | 3242.23 | 3244.67 | 39446.0 |
| 2019-07-17 14:30:00 | ES | Futures | 3244.67 | 3246.02 | 3243.05 | 3243.86 | 32363.0 |
| 2019-07-17 15:00:00 | ES | Futures | 3243.59 | 3244.67 | 3238.99 | 3239.26 | 59384.0 |
| 2019-07-17 15:30:00 | ES | Futures | 3239.26 | 3242.23 | 3234.38 | 3234.65 | 123099.0 |
| 2019-07-17 16:00:00 | ES | Futures | 3234.65 | 3238.17 | 3231.68 | 3232.49 | 71832.0 |
| 2019-07-17 16:30:00 | ES | Futures | 3232.76 | 3233.03 | 3227.35 | 3228.16 | 15566.0 |
| 2019-07-17 18:00:00 | ES | Futures | 3227.62 | 3231.14 | 3227.35 | 3230.59 | 4515.0 |
| 2019-07-17 18:30:00 | ES | Futures | 3230.59 | 3230.86 | 3229.78 | 3229.78 | 1283.0 |
| 2019-07-17 19:00:00 | ES | Futures | 3230.05 | 3230.05 | 3228.7 | 3229.51 | 1856.0 |
| 2019-07-17 19:30:00 | ES | Futures | 3229.51 | 3231.14 | 3227.62 | 3228.97 | 3225.0 |
| 2019-07-17 20:00:00 | ES | Futures | 3229.24 | 3229.78 | 3225.18 | 3225.72 | 8696.0 |
| 2019-07-17 20:30:00 | ES | Futures | 3225.45 | 3225.99 | 3220.85 | 3223.01 | 8986.0 |
| 2019-07-17 21:00:00 | ES | Futures | 3223.01 | 3225.18 | 3220.85 | 3225.18 | 9879.0 |
| 2019-07-17 21:30:00 | ES | Futures | 3225.18 | 3225.99 | 3223.29 | 3224.1 | 7090.0 |
| 2019-07-17 22:00:00 | ES | Futures | 3223.83 | 3224.37 | 3222.2 | 3222.47 | 4927.0 |
| 2019-07-17 22:30:00 | ES | Futures | 3222.47 | 3226.53 | 3222.47 | 3225.72 | 6008.0 |
| 2019-07-17 23:00:00 | ES | Futures | 3225.99 | 3227.35 | 3225.72 | 3226.8 | 2836.0 |
| 2019-07-17 23:30:00 | ES | Futures | 3226.8 | 3227.08 | 3224.64 | 3225.18 | 2848.0 |
| 2019-07-17 00:00:00 | NQ | Futures | 9220.44 | 9222.76 | 9219.57 | 9219.86 | 340.0 |
| 2019-07-17 00:30:00 | NQ | Futures | 9219.86 | 9224.21 | 9219.86 | 9222.76 | 334.0 |
| 2019-07-17 01:00:00 | NQ | Futures | 9222.76 | 9223.05 | 9218.99 | 9221.6 | 488.0 |
| 2019-07-17 01:30:00 | NQ | Futures | 9221.31 | 9225.95 | 9220.44 | 9223.63 | 704.0 |
> showing 50 of 3,422 rows — these rows as CSV