PREVIEW / futures_5min / 2019-07-28
file: by_date/futures_5min/2019/2019-07-28.parquet size: 56 KB rows: 3,148
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-07-28 18:00:00 | ES | Futures | 3272.28 | 3276.34 | 3272.28 | 3275.53 | 2383.0 |
| 2019-07-28 18:05:00 | ES | Futures | 3275.53 | 3275.8 | 3275.53 | 3275.8 | 324.0 |
| 2019-07-28 18:10:00 | ES | Futures | 3275.53 | 3276.34 | 3275.53 | 3276.07 | 756.0 |
| 2019-07-28 18:15:00 | ES | Futures | 3276.07 | 3276.61 | 3275.8 | 3276.34 | 284.0 |
| 2019-07-28 18:20:00 | ES | Futures | 3276.34 | 3276.61 | 3276.07 | 3276.34 | 130.0 |
| 2019-07-28 18:25:00 | ES | Futures | 3276.34 | 3276.61 | 3276.07 | 3276.34 | 114.0 |
| 2019-07-28 18:30:00 | ES | Futures | 3276.34 | 3276.61 | 3275.53 | 3275.53 | 576.0 |
| 2019-07-28 18:35:00 | ES | Futures | 3275.53 | 3275.8 | 3274.99 | 3274.99 | 303.0 |
| 2019-07-28 18:40:00 | ES | Futures | 3274.99 | 3275.53 | 3274.99 | 3275.26 | 182.0 |
| 2019-07-28 18:45:00 | ES | Futures | 3275.26 | 3275.26 | 3274.72 | 3274.99 | 113.0 |
| 2019-07-28 18:50:00 | ES | Futures | 3275.26 | 3275.53 | 3274.99 | 3275.26 | 110.0 |
| 2019-07-28 18:55:00 | ES | Futures | 3275.53 | 3275.53 | 3274.72 | 3274.99 | 105.0 |
| 2019-07-28 19:00:00 | ES | Futures | 3274.99 | 3274.99 | 3274.45 | 3274.72 | 350.0 |
| 2019-07-28 19:05:00 | ES | Futures | 3274.72 | 3274.99 | 3274.72 | 3274.99 | 91.0 |
| 2019-07-28 19:10:00 | ES | Futures | 3274.72 | 3274.99 | 3274.72 | 3274.72 | 246.0 |
| 2019-07-28 19:15:00 | ES | Futures | 3274.72 | 3274.99 | 3274.45 | 3274.72 | 36.0 |
| 2019-07-28 19:20:00 | ES | Futures | 3274.72 | 3274.99 | 3274.45 | 3274.72 | 56.0 |
| 2019-07-28 19:25:00 | ES | Futures | 3274.72 | 3274.72 | 3274.45 | 3274.45 | 23.0 |
| 2019-07-28 19:30:00 | ES | Futures | 3274.45 | 3274.72 | 3274.18 | 3274.45 | 174.0 |
| 2019-07-28 19:35:00 | ES | Futures | 3274.45 | 3274.99 | 3274.18 | 3274.72 | 337.0 |
| 2019-07-28 19:40:00 | ES | Futures | 3274.99 | 3274.99 | 3274.18 | 3274.45 | 222.0 |
| 2019-07-28 19:45:00 | ES | Futures | 3274.18 | 3274.45 | 3273.64 | 3273.64 | 441.0 |
| 2019-07-28 19:50:00 | ES | Futures | 3273.64 | 3273.91 | 3273.37 | 3273.91 | 176.0 |
| 2019-07-28 19:55:00 | ES | Futures | 3273.91 | 3274.18 | 3273.64 | 3273.91 | 218.0 |
| 2019-07-28 20:00:00 | ES | Futures | 3274.18 | 3274.18 | 3273.09 | 3273.37 | 836.0 |
| 2019-07-28 20:05:00 | ES | Futures | 3273.37 | 3273.37 | 3271.47 | 3272.01 | 1329.0 |
| 2019-07-28 20:10:00 | ES | Futures | 3272.28 | 3273.37 | 3271.74 | 3273.09 | 1015.0 |
| 2019-07-28 20:15:00 | ES | Futures | 3273.09 | 3273.64 | 3272.82 | 3273.37 | 309.0 |
| 2019-07-28 20:20:00 | ES | Futures | 3273.64 | 3274.45 | 3273.37 | 3273.64 | 585.0 |
| 2019-07-28 20:25:00 | ES | Futures | 3273.37 | 3273.64 | 3273.09 | 3273.37 | 354.0 |
| 2019-07-28 20:30:00 | ES | Futures | 3273.64 | 3273.91 | 3273.09 | 3273.09 | 288.0 |
| 2019-07-28 20:35:00 | ES | Futures | 3273.37 | 3273.64 | 3273.09 | 3273.37 | 370.0 |
| 2019-07-28 20:40:00 | ES | Futures | 3273.37 | 3273.64 | 3273.09 | 3273.09 | 167.0 |
| 2019-07-28 20:45:00 | ES | Futures | 3273.37 | 3273.37 | 3271.47 | 3271.74 | 1076.0 |
| 2019-07-28 20:50:00 | ES | Futures | 3271.47 | 3272.82 | 3271.47 | 3272.55 | 502.0 |
| 2019-07-28 20:55:00 | ES | Futures | 3272.28 | 3272.28 | 3271.2 | 3271.74 | 470.0 |
| 2019-07-28 21:00:00 | ES | Futures | 3271.74 | 3272.55 | 3271.2 | 3272.28 | 995.0 |
| 2019-07-28 21:05:00 | ES | Futures | 3272.28 | 3272.82 | 3272.28 | 3272.28 | 656.0 |
| 2019-07-28 21:10:00 | ES | Futures | 3272.55 | 3273.09 | 3272.01 | 3272.55 | 454.0 |
| 2019-07-28 21:15:00 | ES | Futures | 3272.82 | 3273.09 | 3271.74 | 3272.28 | 790.0 |
| 2019-07-28 21:20:00 | ES | Futures | 3272.28 | 3272.82 | 3271.74 | 3272.82 | 403.0 |
| 2019-07-28 21:25:00 | ES | Futures | 3272.82 | 3273.37 | 3272.82 | 3273.09 | 459.0 |
| 2019-07-28 21:30:00 | ES | Futures | 3273.09 | 3273.91 | 3272.82 | 3272.82 | 1119.0 |
| 2019-07-28 21:35:00 | ES | Futures | 3273.09 | 3273.09 | 3272.01 | 3272.01 | 697.0 |
| 2019-07-28 21:40:00 | ES | Futures | 3272.28 | 3273.09 | 3272.28 | 3273.09 | 656.0 |
| 2019-07-28 21:45:00 | ES | Futures | 3272.82 | 3273.64 | 3272.82 | 3273.37 | 441.0 |
| 2019-07-28 21:50:00 | ES | Futures | 3273.37 | 3273.37 | 3272.01 | 3272.01 | 617.0 |
| 2019-07-28 21:55:00 | ES | Futures | 3272.28 | 3272.82 | 3272.01 | 3272.82 | 624.0 |
| 2019-07-28 22:00:00 | ES | Futures | 3272.82 | 3272.82 | 3271.74 | 3272.01 | 574.0 |
| 2019-07-28 22:05:00 | ES | Futures | 3272.01 | 3272.01 | 3271.2 | 3271.47 | 498.0 |
> showing 50 of 3,148 rows — these rows as CSV