PREVIEW / futures_30min / 2019-07-11
file: by_date/futures_30min/2019/2019-07-11.parquet size: 93 KB rows: 3,443
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-11 00:00:00 | ES | Futures | 3254.42 | 3254.96 | 3253.87 | 3254.42 | 1867.0 |
| 2019-07-11 00:30:00 | ES | Futures | 3254.69 | 3254.96 | 3254.15 | 3254.42 | 1583.0 |
| 2019-07-11 01:00:00 | ES | Futures | 3254.42 | 3254.96 | 3253.87 | 3254.42 | 2516.0 |
| 2019-07-11 01:30:00 | ES | Futures | 3254.42 | 3254.96 | 3253.6 | 3254.15 | 2735.0 |
| 2019-07-11 02:00:00 | ES | Futures | 3254.15 | 3254.96 | 3251.98 | 3252.25 | 4979.0 |
| 2019-07-11 02:30:00 | ES | Futures | 3252.25 | 3253.87 | 3251.44 | 3252.79 | 5144.0 |
| 2019-07-11 03:00:00 | ES | Futures | 3252.52 | 3253.06 | 3249.54 | 3252.52 | 11276.0 |
| 2019-07-11 03:30:00 | ES | Futures | 3252.25 | 3252.79 | 3250.63 | 3252.25 | 7059.0 |
| 2019-07-11 04:00:00 | ES | Futures | 3251.98 | 3253.06 | 3250.63 | 3251.71 | 5214.0 |
| 2019-07-11 04:30:00 | ES | Futures | 3251.71 | 3252.25 | 3251.17 | 3251.44 | 5183.0 |
| 2019-07-11 05:00:00 | ES | Futures | 3251.44 | 3255.77 | 3250.9 | 3254.42 | 13255.0 |
| 2019-07-11 05:30:00 | ES | Futures | 3254.69 | 3255.77 | 3253.87 | 3254.96 | 6172.0 |
| 2019-07-11 06:00:00 | ES | Futures | 3254.96 | 3255.23 | 3251.17 | 3251.17 | 11264.0 |
| 2019-07-11 06:30:00 | ES | Futures | 3251.17 | 3254.42 | 3249.81 | 3254.42 | 10768.0 |
| 2019-07-11 07:00:00 | ES | Futures | 3254.42 | 3254.69 | 3252.52 | 3252.79 | 9160.0 |
| 2019-07-11 07:30:00 | ES | Futures | 3252.79 | 3253.33 | 3251.71 | 3253.06 | 6555.0 |
| 2019-07-11 08:00:00 | ES | Futures | 3252.79 | 3254.96 | 3252.52 | 3253.87 | 13840.0 |
| 2019-07-11 08:30:00 | ES | Futures | 3254.15 | 3254.69 | 3247.38 | 3251.17 | 32283.0 |
| 2019-07-11 09:00:00 | ES | Futures | 3251.17 | 3253.6 | 3250.63 | 3252.52 | 17754.0 |
| 2019-07-11 09:30:00 | ES | Futures | 3252.25 | 3255.23 | 3248.73 | 3251.98 | 148292.0 |
| 2019-07-11 10:00:00 | ES | Futures | 3252.25 | 3253.87 | 3246.57 | 3247.38 | 103941.0 |
| 2019-07-11 10:30:00 | ES | Futures | 3247.11 | 3248.19 | 3243.59 | 3246.3 | 86940.0 |
| 2019-07-11 11:00:00 | ES | Futures | 3246.3 | 3253.06 | 3245.48 | 3252.25 | 67099.0 |
| 2019-07-11 11:30:00 | ES | Futures | 3252.25 | 3254.42 | 3251.44 | 3253.6 | 45594.0 |
| 2019-07-11 12:00:00 | ES | Futures | 3253.87 | 3254.69 | 3251.17 | 3252.25 | 32112.0 |
| 2019-07-11 12:30:00 | ES | Futures | 3252.52 | 3253.06 | 3250.9 | 3252.79 | 23331.0 |
| 2019-07-11 13:00:00 | ES | Futures | 3252.79 | 3253.06 | 3245.48 | 3245.75 | 55149.0 |
| 2019-07-11 13:30:00 | ES | Futures | 3246.02 | 3247.11 | 3241.15 | 3243.32 | 87138.0 |
| 2019-07-11 14:00:00 | ES | Futures | 3243.32 | 3244.67 | 3240.34 | 3242.23 | 35992.0 |
| 2019-07-11 14:30:00 | ES | Futures | 3242.23 | 3247.38 | 3241.96 | 3246.57 | 44812.0 |
| 2019-07-11 15:00:00 | ES | Futures | 3246.57 | 3247.65 | 3245.75 | 3246.3 | 33187.0 |
| 2019-07-11 15:30:00 | ES | Futures | 3246.3 | 3252.52 | 3246.02 | 3252.25 | 113954.0 |
| 2019-07-11 16:00:00 | ES | Futures | 3251.98 | 3253.87 | 3251.44 | 3253.06 | 44476.0 |
| 2019-07-11 16:30:00 | ES | Futures | 3252.79 | 3253.6 | 3252.25 | 3252.79 | 5986.0 |
| 2019-07-11 18:00:00 | ES | Futures | 3251.71 | 3253.33 | 3251.44 | 3252.79 | 2366.0 |
| 2019-07-11 18:30:00 | ES | Futures | 3252.79 | 3253.06 | 3251.17 | 3252.52 | 1259.0 |
| 2019-07-11 19:00:00 | ES | Futures | 3252.52 | 3252.52 | 3250.9 | 3251.44 | 1062.0 |
| 2019-07-11 19:30:00 | ES | Futures | 3251.71 | 3254.96 | 3251.44 | 3254.42 | 2786.0 |
| 2019-07-11 20:00:00 | ES | Futures | 3254.42 | 3255.5 | 3253.6 | 3254.15 | 5870.0 |
| 2019-07-11 20:30:00 | ES | Futures | 3254.15 | 3261.45 | 3253.6 | 3261.45 | 13812.0 |
| 2019-07-11 21:00:00 | ES | Futures | 3261.45 | 3262.0 | 3256.85 | 3259.29 | 11489.0 |
| 2019-07-11 21:30:00 | ES | Futures | 3259.56 | 3261.45 | 3259.02 | 3260.91 | 7148.0 |
| 2019-07-11 22:00:00 | ES | Futures | 3260.91 | 3261.45 | 3259.83 | 3260.37 | 3985.0 |
| 2019-07-11 22:30:00 | ES | Futures | 3260.37 | 3260.37 | 3258.21 | 3259.56 | 4636.0 |
| 2019-07-11 23:00:00 | ES | Futures | 3259.83 | 3262.0 | 3259.29 | 3260.91 | 4992.0 |
| 2019-07-11 23:30:00 | ES | Futures | 3260.91 | 3261.45 | 3260.37 | 3260.37 | 1971.0 |
| 2019-07-11 00:00:00 | NQ | Futures | 9233.78 | 9239.01 | 9232.33 | 9237.85 | 1177.0 |
| 2019-07-11 00:30:00 | NQ | Futures | 9238.14 | 9239.88 | 9234.36 | 9236.68 | 813.0 |
| 2019-07-11 01:00:00 | NQ | Futures | 9237.26 | 9239.59 | 9232.91 | 9235.81 | 1196.0 |
| 2019-07-11 01:30:00 | NQ | Futures | 9235.52 | 9237.85 | 9232.33 | 9236.39 | 1433.0 |
> showing 50 of 3,443 rows — these rows as CSV