PREVIEW / futures_30min / 2018-09-12
file: by_date/futures_30min/2018/2018-09-12.parquet size: 75 KB rows: 2,838
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-09-12 00:00:00 | ES | Futures | 3146.99 | 3147.8 | 3146.99 | 3147.26 | 1299.0 |
| 2018-09-12 00:30:00 | ES | Futures | 3147.26 | 3147.8 | 3146.71 | 3147.53 | 1077.0 |
| 2018-09-12 01:00:00 | ES | Futures | 3147.8 | 3149.17 | 3147.53 | 3147.8 | 2601.0 |
| 2018-09-12 01:30:00 | ES | Futures | 3147.8 | 3150.26 | 3147.53 | 3149.98 | 2799.0 |
| 2018-09-12 02:00:00 | ES | Futures | 3149.71 | 3151.35 | 3149.71 | 3150.53 | 2654.0 |
| 2018-09-12 02:30:00 | ES | Futures | 3150.8 | 3150.8 | 3148.89 | 3148.89 | 3353.0 |
| 2018-09-12 03:00:00 | ES | Futures | 3148.62 | 3151.62 | 3148.08 | 3150.8 | 6646.0 |
| 2018-09-12 03:30:00 | ES | Futures | 3150.8 | 3155.16 | 3149.71 | 3154.07 | 11739.0 |
| 2018-09-12 04:00:00 | ES | Futures | 3154.07 | 3155.16 | 3153.25 | 3154.34 | 8807.0 |
| 2018-09-12 04:30:00 | ES | Futures | 3154.07 | 3155.43 | 3153.8 | 3154.34 | 5749.0 |
| 2018-09-12 05:00:00 | ES | Futures | 3154.34 | 3154.61 | 3150.8 | 3151.07 | 5991.0 |
| 2018-09-12 05:30:00 | ES | Futures | 3150.8 | 3152.44 | 3150.53 | 3150.8 | 4455.0 |
| 2018-09-12 06:00:00 | ES | Futures | 3150.8 | 3151.62 | 3149.98 | 3151.07 | 3813.0 |
| 2018-09-12 06:30:00 | ES | Futures | 3150.8 | 3152.44 | 3150.26 | 3151.89 | 3520.0 |
| 2018-09-12 07:00:00 | ES | Futures | 3152.16 | 3152.71 | 3148.08 | 3150.53 | 12366.0 |
| 2018-09-12 07:30:00 | ES | Futures | 3150.26 | 3150.53 | 3146.71 | 3147.8 | 10477.0 |
| 2018-09-12 08:00:00 | ES | Futures | 3147.8 | 3149.17 | 3147.26 | 3148.62 | 10092.0 |
| 2018-09-12 08:30:00 | ES | Futures | 3148.62 | 3149.44 | 3145.9 | 3146.44 | 15114.0 |
| 2018-09-12 09:00:00 | ES | Futures | 3146.44 | 3148.35 | 3145.62 | 3147.53 | 20785.0 |
| 2018-09-12 09:30:00 | ES | Futures | 3147.53 | 3151.07 | 3144.53 | 3145.62 | 163814.0 |
| 2018-09-12 10:00:00 | ES | Futures | 3145.9 | 3149.98 | 3140.45 | 3142.35 | 122803.0 |
| 2018-09-12 10:30:00 | ES | Futures | 3142.35 | 3143.44 | 3138.27 | 3141.26 | 119912.0 |
| 2018-09-12 11:00:00 | ES | Futures | 3141.26 | 3153.25 | 3140.17 | 3153.25 | 205210.0 |
| 2018-09-12 11:30:00 | ES | Futures | 3153.25 | 3155.43 | 3141.81 | 3142.63 | 133787.0 |
| 2018-09-12 12:00:00 | ES | Futures | 3142.63 | 3148.89 | 3142.08 | 3146.71 | 87924.0 |
| 2018-09-12 12:30:00 | ES | Futures | 3146.99 | 3148.62 | 3144.81 | 3146.99 | 48045.0 |
| 2018-09-12 13:00:00 | ES | Futures | 3146.71 | 3149.44 | 3145.62 | 3148.35 | 40495.0 |
| 2018-09-12 13:30:00 | ES | Futures | 3148.62 | 3150.26 | 3143.44 | 3144.81 | 43328.0 |
| 2018-09-12 14:00:00 | ES | Futures | 3145.08 | 3145.9 | 3142.9 | 3144.26 | 53975.0 |
| 2018-09-12 14:30:00 | ES | Futures | 3144.26 | 3146.17 | 3141.81 | 3144.53 | 49718.0 |
| 2018-09-12 15:00:00 | ES | Futures | 3144.81 | 3150.8 | 3144.53 | 3150.8 | 45851.0 |
| 2018-09-12 15:30:00 | ES | Futures | 3150.8 | 3152.44 | 3148.08 | 3148.35 | 96135.0 |
| 2018-09-12 16:00:00 | ES | Futures | 3148.35 | 3148.89 | 3147.26 | 3148.35 | 36422.0 |
| 2018-09-12 16:30:00 | ES | Futures | 3147.8 | 3148.08 | 3146.44 | 3146.44 | 4924.0 |
| 2018-09-12 18:00:00 | ES | Futures | 3146.44 | 3146.71 | 3145.08 | 3145.9 | 2501.0 |
| 2018-09-12 18:30:00 | ES | Futures | 3145.9 | 3146.99 | 3145.08 | 3146.99 | 1466.0 |
| 2018-09-12 19:00:00 | ES | Futures | 3146.71 | 3147.53 | 3146.44 | 3146.44 | 931.0 |
| 2018-09-12 19:30:00 | ES | Futures | 3146.71 | 3147.26 | 3146.44 | 3146.99 | 739.0 |
| 2018-09-12 20:00:00 | ES | Futures | 3146.71 | 3149.71 | 3146.17 | 3149.44 | 6111.0 |
| 2018-09-12 20:30:00 | ES | Futures | 3149.17 | 3149.71 | 3148.62 | 3149.71 | 1649.0 |
| 2018-09-12 21:00:00 | ES | Futures | 3149.44 | 3149.71 | 3148.35 | 3149.17 | 2419.0 |
| 2018-09-12 21:30:00 | ES | Futures | 3148.89 | 3149.71 | 3147.26 | 3147.8 | 4588.0 |
| 2018-09-12 22:00:00 | ES | Futures | 3147.8 | 3147.8 | 3146.17 | 3146.44 | 3129.0 |
| 2018-09-12 22:30:00 | ES | Futures | 3146.71 | 3147.26 | 3145.35 | 3146.99 | 2622.0 |
| 2018-09-12 23:00:00 | ES | Futures | 3146.99 | 3146.99 | 3146.17 | 3146.17 | 1292.0 |
| 2018-09-12 23:30:00 | ES | Futures | 3145.9 | 3147.26 | 3145.9 | 3146.71 | 1229.0 |
| 2018-09-12 00:00:00 | NQ | Futures | 8843.44 | 8846.68 | 8842.85 | 8844.03 | 510.0 |
| 2018-09-12 00:30:00 | NQ | Futures | 8844.03 | 8845.79 | 8839.9 | 8844.32 | 1634.0 |
| 2018-09-12 01:00:00 | NQ | Futures | 8844.62 | 8849.03 | 8840.79 | 8842.85 | 1367.0 |
| 2018-09-12 01:30:00 | NQ | Futures | 8842.55 | 8856.1 | 8842.26 | 8853.74 | 1628.0 |
> showing 50 of 2,838 rows — these rows as CSV