PREVIEW / futures_30min / 2019-04-30
file: by_date/futures_30min/2019/2019-04-30.parquet size: 84 KB rows: 3,274
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-30 00:00:00 | ES | Futures | 3188.16 | 3188.7 | 3187.62 | 3187.89 | 736.0 |
| 2019-04-30 00:30:00 | ES | Futures | 3187.62 | 3188.43 | 3187.35 | 3187.35 | 1375.0 |
| 2019-04-30 01:00:00 | ES | Futures | 3187.62 | 3189.52 | 3187.08 | 3188.7 | 2640.0 |
| 2019-04-30 01:30:00 | ES | Futures | 3188.7 | 3188.98 | 3187.89 | 3188.16 | 1524.0 |
| 2019-04-30 02:00:00 | ES | Futures | 3188.16 | 3188.7 | 3187.08 | 3187.89 | 3880.0 |
| 2019-04-30 02:30:00 | ES | Futures | 3188.16 | 3189.25 | 3187.62 | 3189.25 | 2565.0 |
| 2019-04-30 03:00:00 | ES | Futures | 3189.25 | 3190.6 | 3188.7 | 3189.25 | 8527.0 |
| 2019-04-30 03:30:00 | ES | Futures | 3189.25 | 3189.25 | 3186.54 | 3187.62 | 5617.0 |
| 2019-04-30 04:00:00 | ES | Futures | 3187.89 | 3189.25 | 3187.62 | 3188.98 | 6086.0 |
| 2019-04-30 04:30:00 | ES | Futures | 3188.98 | 3190.33 | 3188.7 | 3189.79 | 4255.0 |
| 2019-04-30 05:00:00 | ES | Futures | 3189.79 | 3190.6 | 3188.98 | 3190.06 | 4716.0 |
| 2019-04-30 05:30:00 | ES | Futures | 3190.06 | 3191.69 | 3190.06 | 3190.33 | 5179.0 |
| 2019-04-30 06:00:00 | ES | Futures | 3190.33 | 3191.14 | 3189.25 | 3189.25 | 3829.0 |
| 2019-04-30 06:30:00 | ES | Futures | 3189.25 | 3192.23 | 3189.25 | 3191.69 | 4197.0 |
| 2019-04-30 07:00:00 | ES | Futures | 3191.42 | 3192.23 | 3190.6 | 3192.23 | 5368.0 |
| 2019-04-30 07:30:00 | ES | Futures | 3191.96 | 3192.23 | 3190.6 | 3191.69 | 5263.0 |
| 2019-04-30 08:00:00 | ES | Futures | 3191.96 | 3194.13 | 3191.14 | 3191.96 | 10389.0 |
| 2019-04-30 08:30:00 | ES | Futures | 3191.96 | 3192.5 | 3187.08 | 3188.7 | 26992.0 |
| 2019-04-30 09:00:00 | ES | Futures | 3188.7 | 3190.33 | 3187.08 | 3189.79 | 22216.0 |
| 2019-04-30 09:30:00 | ES | Futures | 3189.79 | 3190.06 | 3183.55 | 3184.91 | 145568.0 |
| 2019-04-30 10:00:00 | ES | Futures | 3184.64 | 3187.89 | 3182.74 | 3184.1 | 108539.0 |
| 2019-04-30 10:30:00 | ES | Futures | 3184.37 | 3187.62 | 3182.74 | 3182.74 | 67032.0 |
| 2019-04-30 11:00:00 | ES | Futures | 3183.01 | 3183.01 | 3172.98 | 3178.67 | 161547.0 |
| 2019-04-30 11:30:00 | ES | Futures | 3178.95 | 3187.89 | 3178.67 | 3185.45 | 96480.0 |
| 2019-04-30 12:00:00 | ES | Futures | 3185.45 | 3188.7 | 3184.91 | 3187.62 | 50289.0 |
| 2019-04-30 12:30:00 | ES | Futures | 3187.62 | 3189.25 | 3185.18 | 3187.89 | 41768.0 |
| 2019-04-30 13:00:00 | ES | Futures | 3187.62 | 3190.6 | 3187.62 | 3188.16 | 46029.0 |
| 2019-04-30 13:30:00 | ES | Futures | 3188.16 | 3195.21 | 3187.08 | 3194.94 | 63171.0 |
| 2019-04-30 14:00:00 | ES | Futures | 3194.94 | 3195.75 | 3192.23 | 3193.86 | 42108.0 |
| 2019-04-30 14:30:00 | ES | Futures | 3193.86 | 3195.21 | 3191.96 | 3193.31 | 50643.0 |
| 2019-04-30 15:00:00 | ES | Futures | 3193.58 | 3195.21 | 3191.69 | 3191.96 | 60952.0 |
| 2019-04-30 15:30:00 | ES | Futures | 3192.23 | 3199.28 | 3191.69 | 3195.21 | 216786.0 |
| 2019-04-30 16:00:00 | ES | Futures | 3195.21 | 3200.63 | 3193.31 | 3199.55 | 87011.0 |
| 2019-04-30 16:30:00 | ES | Futures | 3199.55 | 3206.06 | 3199.55 | 3204.43 | 23234.0 |
| 2019-04-30 18:00:00 | ES | Futures | 3204.43 | 3204.97 | 3203.07 | 3203.07 | 3197.0 |
| 2019-04-30 18:30:00 | ES | Futures | 3203.34 | 3204.16 | 3202.26 | 3203.07 | 2934.0 |
| 2019-04-30 19:00:00 | ES | Futures | 3202.8 | 3203.07 | 3201.72 | 3202.53 | 1693.0 |
| 2019-04-30 19:30:00 | ES | Futures | 3202.8 | 3204.43 | 3202.26 | 3204.43 | 2591.0 |
| 2019-04-30 20:00:00 | ES | Futures | 3204.43 | 3205.24 | 3203.62 | 3204.97 | 2198.0 |
| 2019-04-30 20:30:00 | ES | Futures | 3204.7 | 3206.33 | 3203.89 | 3206.33 | 2906.0 |
| 2019-04-30 21:00:00 | ES | Futures | 3206.33 | 3206.6 | 3204.97 | 3205.24 | 3260.0 |
| 2019-04-30 21:30:00 | ES | Futures | 3205.51 | 3207.95 | 3205.24 | 3207.68 | 3881.0 |
| 2019-04-30 22:00:00 | ES | Futures | 3207.68 | 3209.85 | 3207.41 | 3208.77 | 4022.0 |
| 2019-04-30 22:30:00 | ES | Futures | 3208.77 | 3210.66 | 3208.77 | 3210.12 | 2732.0 |
| 2019-04-30 23:00:00 | ES | Futures | 3210.12 | 3211.21 | 3209.58 | 3209.85 | 2216.0 |
| 2019-04-30 23:30:00 | ES | Futures | 3209.85 | 3210.12 | 3209.04 | 3209.31 | 1348.0 |
| 2019-04-30 00:00:00 | NQ | Futures | 9078.54 | 9079.99 | 9074.75 | 9075.33 | 757.0 |
| 2019-04-30 00:30:00 | NQ | Futures | 9075.33 | 9076.79 | 9070.97 | 9071.55 | 1616.0 |
| 2019-04-30 01:00:00 | NQ | Futures | 9071.55 | 9081.45 | 9070.68 | 9078.54 | 1280.0 |
| 2019-04-30 01:30:00 | NQ | Futures | 9078.25 | 9079.99 | 9075.92 | 9077.95 | 659.0 |
> showing 50 of 3,274 rows — these rows as CSV