PREVIEW / futures_30min / 2018-10-03
file: by_date/futures_30min/2018/2018-10-03.parquet size: 90 KB rows: 3,173
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-10-03 00:00:00 | ES | Futures | 3190.0 | 3190.54 | 3188.91 | 3189.45 | 2551.0 |
| 2018-10-03 00:30:00 | ES | Futures | 3189.45 | 3190.81 | 3189.18 | 3189.72 | 2151.0 |
| 2018-10-03 01:00:00 | ES | Futures | 3189.72 | 3192.17 | 3189.45 | 3191.9 | 2597.0 |
| 2018-10-03 01:30:00 | ES | Futures | 3191.9 | 3192.17 | 3188.91 | 3189.18 | 3553.0 |
| 2018-10-03 02:00:00 | ES | Futures | 3189.18 | 3192.17 | 3189.18 | 3191.9 | 3668.0 |
| 2018-10-03 02:30:00 | ES | Futures | 3191.63 | 3194.08 | 3191.63 | 3192.99 | 3889.0 |
| 2018-10-03 03:00:00 | ES | Futures | 3192.99 | 3193.8 | 3192.44 | 3192.72 | 4447.0 |
| 2018-10-03 03:30:00 | ES | Futures | 3192.72 | 3193.53 | 3191.9 | 3192.99 | 3770.0 |
| 2018-10-03 04:00:00 | ES | Futures | 3193.26 | 3194.08 | 3191.9 | 3193.26 | 4090.0 |
| 2018-10-03 04:30:00 | ES | Futures | 3193.26 | 3194.35 | 3192.72 | 3193.53 | 3172.0 |
| 2018-10-03 05:00:00 | ES | Futures | 3193.53 | 3193.8 | 3190.27 | 3190.81 | 5921.0 |
| 2018-10-03 05:30:00 | ES | Futures | 3190.81 | 3193.53 | 3190.81 | 3193.26 | 6852.0 |
| 2018-10-03 06:00:00 | ES | Futures | 3193.26 | 3194.62 | 3193.26 | 3193.8 | 5817.0 |
| 2018-10-03 06:30:00 | ES | Futures | 3194.08 | 3194.62 | 3193.26 | 3193.8 | 4489.0 |
| 2018-10-03 07:00:00 | ES | Futures | 3193.8 | 3197.07 | 3193.53 | 3195.98 | 9917.0 |
| 2018-10-03 07:30:00 | ES | Futures | 3196.25 | 3196.8 | 3195.44 | 3196.25 | 7779.0 |
| 2018-10-03 08:00:00 | ES | Futures | 3196.52 | 3198.43 | 3196.25 | 3196.52 | 13207.0 |
| 2018-10-03 08:30:00 | ES | Futures | 3196.25 | 3198.7 | 3196.25 | 3198.43 | 9807.0 |
| 2018-10-03 09:00:00 | ES | Futures | 3198.16 | 3198.43 | 3196.52 | 3198.16 | 10148.0 |
| 2018-10-03 09:30:00 | ES | Futures | 3198.16 | 3199.79 | 3195.16 | 3195.71 | 103409.0 |
| 2018-10-03 10:00:00 | ES | Futures | 3195.71 | 3203.87 | 3195.44 | 3200.88 | 105288.0 |
| 2018-10-03 10:30:00 | ES | Futures | 3200.6 | 3200.88 | 3196.8 | 3197.61 | 73224.0 |
| 2018-10-03 11:00:00 | ES | Futures | 3197.34 | 3198.97 | 3194.08 | 3198.7 | 62982.0 |
| 2018-10-03 11:30:00 | ES | Futures | 3198.7 | 3200.06 | 3194.35 | 3199.79 | 54457.0 |
| 2018-10-03 12:00:00 | ES | Futures | 3199.79 | 3200.88 | 3197.34 | 3200.33 | 38353.0 |
| 2018-10-03 12:30:00 | ES | Futures | 3200.06 | 3200.6 | 3196.8 | 3199.24 | 40454.0 |
| 2018-10-03 13:00:00 | ES | Futures | 3198.97 | 3200.88 | 3197.34 | 3198.97 | 48435.0 |
| 2018-10-03 13:30:00 | ES | Futures | 3199.24 | 3199.79 | 3197.07 | 3198.97 | 30100.0 |
| 2018-10-03 14:00:00 | ES | Futures | 3198.97 | 3200.6 | 3197.07 | 3197.88 | 39291.0 |
| 2018-10-03 14:30:00 | ES | Futures | 3197.88 | 3198.16 | 3185.92 | 3189.45 | 150751.0 |
| 2018-10-03 15:00:00 | ES | Futures | 3189.18 | 3190.81 | 3182.92 | 3185.37 | 105285.0 |
| 2018-10-03 15:30:00 | ES | Futures | 3185.64 | 3189.45 | 3185.1 | 3188.09 | 152712.0 |
| 2018-10-03 16:00:00 | ES | Futures | 3188.09 | 3190.0 | 3186.73 | 3189.45 | 49301.0 |
| 2018-10-03 16:30:00 | ES | Futures | 3189.45 | 3189.72 | 3182.11 | 3184.01 | 14612.0 |
| 2018-10-03 18:00:00 | ES | Futures | 3183.47 | 3183.74 | 3181.02 | 3182.11 | 5641.0 |
| 2018-10-03 18:30:00 | ES | Futures | 3181.84 | 3182.65 | 3180.75 | 3182.38 | 2796.0 |
| 2018-10-03 19:00:00 | ES | Futures | 3182.38 | 3182.92 | 3181.29 | 3182.38 | 2202.0 |
| 2018-10-03 19:30:00 | ES | Futures | 3182.38 | 3182.65 | 3181.29 | 3182.38 | 2727.0 |
| 2018-10-03 20:00:00 | ES | Futures | 3182.38 | 3182.92 | 3177.76 | 3178.84 | 8909.0 |
| 2018-10-03 20:30:00 | ES | Futures | 3178.84 | 3180.75 | 3178.3 | 3179.93 | 4816.0 |
| 2018-10-03 21:00:00 | ES | Futures | 3180.2 | 3180.2 | 3177.48 | 3179.12 | 4490.0 |
| 2018-10-03 21:30:00 | ES | Futures | 3179.12 | 3179.39 | 3176.4 | 3177.21 | 6061.0 |
| 2018-10-03 22:00:00 | ES | Futures | 3176.94 | 3177.21 | 3175.04 | 3176.4 | 5217.0 |
| 2018-10-03 22:30:00 | ES | Futures | 3176.67 | 3178.57 | 3176.12 | 3178.57 | 3646.0 |
| 2018-10-03 23:00:00 | ES | Futures | 3178.3 | 3179.39 | 3177.76 | 3177.76 | 3037.0 |
| 2018-10-03 23:30:00 | ES | Futures | 3177.76 | 3177.76 | 3174.76 | 3174.76 | 7364.0 |
| 2018-10-03 00:00:00 | NQ | Futures | 8990.08 | 8992.13 | 8985.97 | 8990.37 | 1217.0 |
| 2018-10-03 00:30:00 | NQ | Futures | 8989.79 | 8994.18 | 8988.03 | 8990.67 | 1149.0 |
| 2018-10-03 01:00:00 | NQ | Futures | 8990.37 | 8998.29 | 8988.61 | 8997.7 | 1345.0 |
| 2018-10-03 01:30:00 | NQ | Futures | 8998.0 | 8998.0 | 8979.52 | 8981.87 | 2477.0 |
> showing 50 of 3,173 rows — these rows as CSV