PREVIEW / futures_30min / 2019-04-29
file: by_date/futures_30min/2019/2019-04-29.parquet size: 82 KB rows: 3,286
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-04-29 00:00:00 | ES | Futures | 3190.6 | 3191.14 | 3190.33 | 3191.14 | 949.0 |
| 2019-04-29 00:30:00 | ES | Futures | 3191.14 | 3191.14 | 3190.33 | 3190.87 | 690.0 |
| 2019-04-29 01:00:00 | ES | Futures | 3190.6 | 3191.14 | 3190.06 | 3190.87 | 1743.0 |
| 2019-04-29 01:30:00 | ES | Futures | 3191.14 | 3193.31 | 3190.87 | 3192.23 | 3280.0 |
| 2019-04-29 02:00:00 | ES | Futures | 3191.96 | 3192.5 | 3190.87 | 3191.14 | 3210.0 |
| 2019-04-29 02:30:00 | ES | Futures | 3191.42 | 3191.42 | 3190.06 | 3190.06 | 2351.0 |
| 2019-04-29 03:00:00 | ES | Futures | 3190.33 | 3191.14 | 3189.52 | 3190.6 | 5686.0 |
| 2019-04-29 03:30:00 | ES | Futures | 3190.6 | 3192.23 | 3190.33 | 3191.96 | 4260.0 |
| 2019-04-29 04:00:00 | ES | Futures | 3191.96 | 3195.48 | 3191.69 | 3193.58 | 9468.0 |
| 2019-04-29 04:30:00 | ES | Futures | 3193.58 | 3193.58 | 3191.69 | 3192.23 | 5296.0 |
| 2019-04-29 05:00:00 | ES | Futures | 3192.23 | 3192.77 | 3188.43 | 3189.52 | 6497.0 |
| 2019-04-29 05:30:00 | ES | Futures | 3189.79 | 3190.06 | 3188.16 | 3188.98 | 6065.0 |
| 2019-04-29 06:00:00 | ES | Futures | 3188.98 | 3190.06 | 3188.43 | 3188.7 | 4033.0 |
| 2019-04-29 06:30:00 | ES | Futures | 3188.7 | 3188.7 | 3186.54 | 3187.08 | 5302.0 |
| 2019-04-29 07:00:00 | ES | Futures | 3187.08 | 3188.43 | 3185.72 | 3186.54 | 6884.0 |
| 2019-04-29 07:30:00 | ES | Futures | 3186.54 | 3188.43 | 3186.54 | 3187.89 | 4116.0 |
| 2019-04-29 08:00:00 | ES | Futures | 3187.89 | 3189.25 | 3187.62 | 3189.25 | 5945.0 |
| 2019-04-29 08:30:00 | ES | Futures | 3188.98 | 3190.33 | 3187.35 | 3190.06 | 10525.0 |
| 2019-04-29 09:00:00 | ES | Futures | 3190.06 | 3191.42 | 3188.98 | 3190.33 | 15794.0 |
| 2019-04-29 09:30:00 | ES | Futures | 3190.33 | 3196.57 | 3190.06 | 3193.31 | 150750.0 |
| 2019-04-29 10:00:00 | ES | Futures | 3193.31 | 3194.13 | 3189.25 | 3193.58 | 90682.0 |
| 2019-04-29 10:30:00 | ES | Futures | 3193.58 | 3197.11 | 3192.77 | 3194.67 | 75370.0 |
| 2019-04-29 11:00:00 | ES | Futures | 3194.94 | 3196.3 | 3192.5 | 3193.86 | 51310.0 |
| 2019-04-29 11:30:00 | ES | Futures | 3193.86 | 3194.94 | 3192.77 | 3193.86 | 28791.0 |
| 2019-04-29 12:00:00 | ES | Futures | 3193.86 | 3197.92 | 3192.5 | 3197.92 | 39157.0 |
| 2019-04-29 12:30:00 | ES | Futures | 3197.92 | 3199.01 | 3196.84 | 3198.46 | 30369.0 |
| 2019-04-29 13:00:00 | ES | Futures | 3198.46 | 3198.74 | 3196.84 | 3198.19 | 21682.0 |
| 2019-04-29 13:30:00 | ES | Futures | 3198.19 | 3198.46 | 3196.3 | 3197.92 | 24578.0 |
| 2019-04-29 14:00:00 | ES | Futures | 3198.19 | 3200.63 | 3197.65 | 3199.01 | 43186.0 |
| 2019-04-29 14:30:00 | ES | Futures | 3199.28 | 3199.28 | 3197.11 | 3197.65 | 32614.0 |
| 2019-04-29 15:00:00 | ES | Futures | 3197.92 | 3199.01 | 3196.57 | 3197.11 | 23768.0 |
| 2019-04-29 15:30:00 | ES | Futures | 3197.11 | 3198.19 | 3193.04 | 3193.58 | 101470.0 |
| 2019-04-29 16:00:00 | ES | Futures | 3193.58 | 3194.4 | 3190.33 | 3190.87 | 55270.0 |
| 2019-04-29 16:30:00 | ES | Futures | 3190.33 | 3192.23 | 3190.06 | 3191.69 | 8091.0 |
| 2019-04-29 18:00:00 | ES | Futures | 3190.87 | 3191.69 | 3189.79 | 3189.79 | 3532.0 |
| 2019-04-29 18:30:00 | ES | Futures | 3189.79 | 3191.42 | 3189.79 | 3190.6 | 1392.0 |
| 2019-04-29 19:00:00 | ES | Futures | 3190.87 | 3190.87 | 3190.06 | 3190.33 | 694.0 |
| 2019-04-29 19:30:00 | ES | Futures | 3190.33 | 3190.87 | 3188.98 | 3189.25 | 2634.0 |
| 2019-04-29 20:00:00 | ES | Futures | 3189.52 | 3189.79 | 3187.89 | 3188.98 | 3146.0 |
| 2019-04-29 20:30:00 | ES | Futures | 3189.25 | 3189.79 | 3188.7 | 3189.25 | 2043.0 |
| 2019-04-29 21:00:00 | ES | Futures | 3189.25 | 3189.52 | 3184.1 | 3184.91 | 14864.0 |
| 2019-04-29 21:30:00 | ES | Futures | 3184.91 | 3186.81 | 3183.55 | 3185.99 | 9016.0 |
| 2019-04-29 22:00:00 | ES | Futures | 3185.72 | 3188.7 | 3185.45 | 3187.89 | 5325.0 |
| 2019-04-29 22:30:00 | ES | Futures | 3187.89 | 3189.25 | 3187.62 | 3188.7 | 3121.0 |
| 2019-04-29 23:00:00 | ES | Futures | 3188.7 | 3189.25 | 3187.62 | 3188.43 | 2210.0 |
| 2019-04-29 23:30:00 | ES | Futures | 3188.43 | 3188.7 | 3187.89 | 3188.16 | 944.0 |
| 2019-04-29 00:00:00 | NQ | Futures | 9135.02 | 9137.35 | 9133.86 | 9136.77 | 521.0 |
| 2019-04-29 00:30:00 | NQ | Futures | 9136.77 | 9137.06 | 9134.44 | 9135.6 | 343.0 |
| 2019-04-29 01:00:00 | NQ | Futures | 9135.6 | 9137.35 | 9133.57 | 9137.06 | 785.0 |
| 2019-04-29 01:30:00 | NQ | Futures | 9137.06 | 9142.88 | 9135.89 | 9139.97 | 1521.0 |
> showing 50 of 3,286 rows — these rows as CSV