PREVIEW / futures_30min / 2019-07-10
file: by_date/futures_30min/2019/2019-07-10.parquet size: 97 KB rows: 3,460
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-10 00:00:00 | ES | Futures | 3229.24 | 3229.51 | 3228.43 | 3229.51 | 1232.0 |
| 2019-07-10 00:30:00 | ES | Futures | 3229.51 | 3229.51 | 3227.35 | 3227.62 | 1754.0 |
| 2019-07-10 01:00:00 | ES | Futures | 3227.62 | 3228.97 | 3227.08 | 3228.43 | 2279.0 |
| 2019-07-10 01:30:00 | ES | Futures | 3228.16 | 3228.7 | 3226.53 | 3227.08 | 3304.0 |
| 2019-07-10 02:00:00 | ES | Futures | 3227.08 | 3227.08 | 3222.74 | 3223.56 | 6366.0 |
| 2019-07-10 02:30:00 | ES | Futures | 3223.29 | 3224.1 | 3220.85 | 3222.2 | 6842.0 |
| 2019-07-10 03:00:00 | ES | Futures | 3221.93 | 3223.29 | 3220.31 | 3221.39 | 11953.0 |
| 2019-07-10 03:30:00 | ES | Futures | 3221.39 | 3224.37 | 3221.12 | 3224.1 | 10055.0 |
| 2019-07-10 04:00:00 | ES | Futures | 3224.1 | 3226.53 | 3224.1 | 3225.45 | 8374.0 |
| 2019-07-10 04:30:00 | ES | Futures | 3225.45 | 3225.45 | 3222.74 | 3224.37 | 7829.0 |
| 2019-07-10 05:00:00 | ES | Futures | 3224.1 | 3226.53 | 3223.01 | 3225.18 | 8488.0 |
| 2019-07-10 05:30:00 | ES | Futures | 3224.91 | 3225.72 | 3220.04 | 3221.93 | 9655.0 |
| 2019-07-10 06:00:00 | ES | Futures | 3221.66 | 3221.66 | 3217.33 | 3219.77 | 11696.0 |
| 2019-07-10 06:30:00 | ES | Futures | 3219.77 | 3221.12 | 3218.41 | 3220.58 | 7947.0 |
| 2019-07-10 07:00:00 | ES | Futures | 3220.85 | 3223.01 | 3220.85 | 3222.74 | 9620.0 |
| 2019-07-10 07:30:00 | ES | Futures | 3222.74 | 3223.01 | 3220.85 | 3221.66 | 6379.0 |
| 2019-07-10 08:00:00 | ES | Futures | 3221.66 | 3224.64 | 3221.12 | 3223.29 | 11729.0 |
| 2019-07-10 08:30:00 | ES | Futures | 3223.29 | 3244.4 | 3223.01 | 3242.51 | 88733.0 |
| 2019-07-10 09:00:00 | ES | Futures | 3242.51 | 3244.67 | 3240.88 | 3242.78 | 31134.0 |
| 2019-07-10 09:30:00 | ES | Futures | 3242.51 | 3256.58 | 3241.69 | 3253.87 | 219385.0 |
| 2019-07-10 10:00:00 | ES | Futures | 3253.87 | 3254.69 | 3244.94 | 3245.75 | 122597.0 |
| 2019-07-10 10:30:00 | ES | Futures | 3245.48 | 3250.09 | 3241.69 | 3241.96 | 117241.0 |
| 2019-07-10 11:00:00 | ES | Futures | 3242.23 | 3243.59 | 3236.01 | 3238.99 | 132080.0 |
| 2019-07-10 11:30:00 | ES | Futures | 3238.99 | 3246.02 | 3238.72 | 3245.21 | 68713.0 |
| 2019-07-10 12:00:00 | ES | Futures | 3245.48 | 3246.84 | 3241.69 | 3243.86 | 51234.0 |
| 2019-07-10 12:30:00 | ES | Futures | 3243.59 | 3246.84 | 3243.59 | 3246.84 | 35986.0 |
| 2019-07-10 13:00:00 | ES | Futures | 3246.84 | 3248.19 | 3246.02 | 3247.11 | 27285.0 |
| 2019-07-10 13:30:00 | ES | Futures | 3247.11 | 3250.36 | 3246.84 | 3248.73 | 27804.0 |
| 2019-07-10 14:00:00 | ES | Futures | 3248.73 | 3252.52 | 3243.05 | 3243.32 | 61853.0 |
| 2019-07-10 14:30:00 | ES | Futures | 3243.05 | 3245.75 | 3241.69 | 3244.4 | 39784.0 |
| 2019-07-10 15:00:00 | ES | Futures | 3244.4 | 3245.48 | 3241.42 | 3243.59 | 50842.0 |
| 2019-07-10 15:30:00 | ES | Futures | 3243.59 | 3246.84 | 3243.05 | 3244.94 | 98818.0 |
| 2019-07-10 16:00:00 | ES | Futures | 3245.21 | 3246.57 | 3244.67 | 3245.75 | 42085.0 |
| 2019-07-10 16:30:00 | ES | Futures | 3245.75 | 3246.3 | 3244.13 | 3244.4 | 4406.0 |
| 2019-07-10 18:00:00 | ES | Futures | 3244.13 | 3246.57 | 3243.32 | 3246.57 | 2982.0 |
| 2019-07-10 18:30:00 | ES | Futures | 3246.57 | 3248.46 | 3246.02 | 3246.84 | 1892.0 |
| 2019-07-10 19:00:00 | ES | Futures | 3247.11 | 3247.38 | 3246.02 | 3246.57 | 781.0 |
| 2019-07-10 19:30:00 | ES | Futures | 3246.3 | 3246.57 | 3244.67 | 3245.75 | 2189.0 |
| 2019-07-10 20:00:00 | ES | Futures | 3245.75 | 3249.54 | 3244.67 | 3248.73 | 7192.0 |
| 2019-07-10 20:30:00 | ES | Futures | 3248.73 | 3249.54 | 3247.65 | 3247.92 | 3168.0 |
| 2019-07-10 21:00:00 | ES | Futures | 3247.92 | 3250.09 | 3247.11 | 3250.09 | 3334.0 |
| 2019-07-10 21:30:00 | ES | Futures | 3249.81 | 3251.98 | 3249.0 | 3251.98 | 7679.0 |
| 2019-07-10 22:00:00 | ES | Futures | 3251.98 | 3253.33 | 3250.9 | 3252.52 | 5875.0 |
| 2019-07-10 22:30:00 | ES | Futures | 3252.25 | 3253.6 | 3251.98 | 3252.79 | 2815.0 |
| 2019-07-10 23:00:00 | ES | Futures | 3252.79 | 3253.33 | 3251.98 | 3252.52 | 3647.0 |
| 2019-07-10 23:30:00 | ES | Futures | 3252.79 | 3255.77 | 3252.52 | 3254.42 | 5723.0 |
| 2019-07-10 00:00:00 | NQ | Futures | 9110.76 | 9111.05 | 9107.86 | 9110.18 | 777.0 |
| 2019-07-10 00:30:00 | NQ | Futures | 9110.18 | 9110.47 | 9103.22 | 9104.09 | 1010.0 |
| 2019-07-10 01:00:00 | NQ | Futures | 9104.38 | 9111.63 | 9101.48 | 9108.73 | 1418.0 |
| 2019-07-10 01:30:00 | NQ | Futures | 9108.15 | 9109.6 | 9101.19 | 9103.51 | 975.0 |
> showing 50 of 3,460 rows — these rows as CSV