PREVIEW / futures_30min / 2019-04-22
file: by_date/futures_30min/2019/2019-04-22.parquet size: 61 KB rows: 2,537
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-22 00:00:00 | ES | Futures | 3149.4 | 3149.94 | 3148.58 | 3149.4 | 1746.0 |
| 2019-04-22 00:30:00 | ES | Futures | 3149.4 | 3150.75 | 3148.85 | 3149.12 | 1738.0 |
| 2019-04-22 01:00:00 | ES | Futures | 3149.4 | 3150.48 | 3148.58 | 3149.67 | 1830.0 |
| 2019-04-22 01:30:00 | ES | Futures | 3149.4 | 3150.48 | 3148.85 | 3149.12 | 1530.0 |
| 2019-04-22 02:00:00 | ES | Futures | 3149.4 | 3150.48 | 3148.31 | 3149.4 | 2262.0 |
| 2019-04-22 02:30:00 | ES | Futures | 3149.12 | 3149.67 | 3148.85 | 3149.4 | 1214.0 |
| 2019-04-22 03:00:00 | ES | Futures | 3149.67 | 3149.94 | 3147.5 | 3148.04 | 3060.0 |
| 2019-04-22 03:30:00 | ES | Futures | 3148.04 | 3148.58 | 3147.23 | 3147.77 | 1717.0 |
| 2019-04-22 04:00:00 | ES | Futures | 3148.04 | 3148.04 | 3147.23 | 3147.5 | 2234.0 |
| 2019-04-22 04:30:00 | ES | Futures | 3147.77 | 3147.77 | 3146.14 | 3147.23 | 1789.0 |
| 2019-04-22 05:00:00 | ES | Futures | 3146.96 | 3147.23 | 3145.87 | 3146.96 | 1448.0 |
| 2019-04-22 05:30:00 | ES | Futures | 3147.23 | 3147.23 | 3146.41 | 3146.96 | 972.0 |
| 2019-04-22 06:00:00 | ES | Futures | 3146.96 | 3149.12 | 3146.96 | 3148.31 | 3003.0 |
| 2019-04-22 06:30:00 | ES | Futures | 3148.04 | 3148.85 | 3147.77 | 3147.77 | 1229.0 |
| 2019-04-22 07:00:00 | ES | Futures | 3147.77 | 3148.31 | 3146.68 | 3147.23 | 2487.0 |
| 2019-04-22 07:30:00 | ES | Futures | 3147.23 | 3148.31 | 3146.96 | 3147.77 | 3783.0 |
| 2019-04-22 08:00:00 | ES | Futures | 3148.04 | 3148.31 | 3144.24 | 3145.33 | 12641.0 |
| 2019-04-22 08:30:00 | ES | Futures | 3145.33 | 3145.87 | 3143.7 | 3144.24 | 6522.0 |
| 2019-04-22 09:00:00 | ES | Futures | 3144.24 | 3146.41 | 3143.7 | 3144.79 | 9036.0 |
| 2019-04-22 09:30:00 | ES | Futures | 3144.79 | 3152.65 | 3143.7 | 3152.38 | 108825.0 |
| 2019-04-22 10:00:00 | ES | Futures | 3152.11 | 3154.55 | 3148.85 | 3151.56 | 70592.0 |
| 2019-04-22 10:30:00 | ES | Futures | 3151.56 | 3154.27 | 3149.4 | 3153.46 | 49920.0 |
| 2019-04-22 11:00:00 | ES | Futures | 3153.73 | 3154.82 | 3150.21 | 3154.55 | 42020.0 |
| 2019-04-22 11:30:00 | ES | Futures | 3154.55 | 3156.44 | 3153.46 | 3154.82 | 30575.0 |
| 2019-04-22 12:00:00 | ES | Futures | 3154.55 | 3155.09 | 3152.92 | 3155.09 | 28454.0 |
| 2019-04-22 12:30:00 | ES | Futures | 3154.82 | 3155.36 | 3154.0 | 3154.82 | 21475.0 |
| 2019-04-22 13:00:00 | ES | Futures | 3154.82 | 3155.09 | 3152.92 | 3154.27 | 16244.0 |
| 2019-04-22 13:30:00 | ES | Futures | 3154.27 | 3155.9 | 3153.73 | 3155.09 | 22058.0 |
| 2019-04-22 14:00:00 | ES | Futures | 3155.36 | 3155.9 | 3154.0 | 3154.82 | 22074.0 |
| 2019-04-22 14:30:00 | ES | Futures | 3155.09 | 3155.09 | 3153.19 | 3154.27 | 22186.0 |
| 2019-04-22 15:00:00 | ES | Futures | 3154.55 | 3155.36 | 3152.92 | 3153.73 | 30972.0 |
| 2019-04-22 15:30:00 | ES | Futures | 3154.0 | 3158.61 | 3154.0 | 3157.26 | 58236.0 |
| 2019-04-22 16:00:00 | ES | Futures | 3157.53 | 3159.15 | 3155.63 | 3158.61 | 36282.0 |
| 2019-04-22 16:30:00 | ES | Futures | 3158.61 | 3161.05 | 3158.34 | 3158.88 | 7428.0 |
| 2019-04-22 18:00:00 | ES | Futures | 3157.53 | 3159.43 | 3157.53 | 3158.88 | 3916.0 |
| 2019-04-22 18:30:00 | ES | Futures | 3158.88 | 3159.43 | 3158.61 | 3159.15 | 641.0 |
| 2019-04-22 19:00:00 | ES | Futures | 3159.15 | 3159.97 | 3159.15 | 3159.15 | 949.0 |
| 2019-04-22 19:30:00 | ES | Futures | 3159.15 | 3159.15 | 3157.8 | 3158.61 | 1945.0 |
| 2019-04-22 20:00:00 | ES | Futures | 3158.88 | 3159.97 | 3156.44 | 3156.71 | 5854.0 |
| 2019-04-22 20:30:00 | ES | Futures | 3156.99 | 3156.99 | 3154.82 | 3155.09 | 4181.0 |
| 2019-04-22 21:00:00 | ES | Futures | 3155.36 | 3155.9 | 3153.46 | 3154.55 | 6472.0 |
| 2019-04-22 21:30:00 | ES | Futures | 3154.27 | 3156.71 | 3153.73 | 3156.71 | 6071.0 |
| 2019-04-22 22:00:00 | ES | Futures | 3156.71 | 3157.8 | 3155.9 | 3156.71 | 4807.0 |
| 2019-04-22 22:30:00 | ES | Futures | 3156.71 | 3157.53 | 3156.17 | 3156.71 | 2199.0 |
| 2019-04-22 23:00:00 | ES | Futures | 3156.71 | 3158.07 | 3156.17 | 3157.53 | 2033.0 |
| 2019-04-22 23:30:00 | ES | Futures | 3157.53 | 3157.53 | 3156.99 | 3157.26 | 1185.0 |
| 2019-04-22 00:00:00 | NQ | Futures | 8960.91 | 8963.82 | 8959.16 | 8961.49 | 1201.0 |
| 2019-04-22 00:30:00 | NQ | Futures | 8961.49 | 8965.57 | 8960.04 | 8960.91 | 1144.0 |
| 2019-04-22 01:00:00 | NQ | Futures | 8960.91 | 8966.44 | 8958.58 | 8962.95 | 1272.0 |
| 2019-04-22 01:30:00 | NQ | Futures | 8962.95 | 8965.57 | 8957.71 | 8959.16 | 1052.0 |
> showing 50 of 2,537 rows — these rows as CSV