PREVIEW / futures_5min / 2019-04-28
file: by_date/futures_5min/2019/2019-04-28.parquet size: 46 KB rows: 2,880
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-28 18:00:00 | ES | Futures | 3187.35 | 3190.06 | 3187.35 | 3189.25 | 2774.0 |
| 2019-04-28 18:05:00 | ES | Futures | 3189.25 | 3190.06 | 3188.7 | 3190.06 | 610.0 |
| 2019-04-28 18:10:00 | ES | Futures | 3189.79 | 3190.6 | 3189.79 | 3190.33 | 436.0 |
| 2019-04-28 18:15:00 | ES | Futures | 3190.06 | 3190.06 | 3189.25 | 3189.52 | 251.0 |
| 2019-04-28 18:20:00 | ES | Futures | 3189.52 | 3189.79 | 3189.25 | 3189.79 | 582.0 |
| 2019-04-28 18:25:00 | ES | Futures | 3189.79 | 3189.79 | 3189.52 | 3189.79 | 42.0 |
| 2019-04-28 18:30:00 | ES | Futures | 3189.79 | 3189.79 | 3189.25 | 3189.25 | 206.0 |
| 2019-04-28 18:35:00 | ES | Futures | 3189.25 | 3189.52 | 3189.25 | 3189.25 | 210.0 |
| 2019-04-28 18:40:00 | ES | Futures | 3189.25 | 3189.25 | 3188.7 | 3189.25 | 335.0 |
| 2019-04-28 18:45:00 | ES | Futures | 3189.25 | 3189.25 | 3188.7 | 3188.98 | 261.0 |
| 2019-04-28 18:50:00 | ES | Futures | 3188.7 | 3189.25 | 3188.7 | 3189.25 | 119.0 |
| 2019-04-28 18:55:00 | ES | Futures | 3189.25 | 3189.52 | 3188.7 | 3189.52 | 193.0 |
| 2019-04-28 19:00:00 | ES | Futures | 3189.52 | 3189.79 | 3189.25 | 3189.52 | 193.0 |
| 2019-04-28 19:05:00 | ES | Futures | 3189.52 | 3189.52 | 3188.98 | 3189.52 | 206.0 |
| 2019-04-28 19:10:00 | ES | Futures | 3189.52 | 3189.52 | 3188.98 | 3188.98 | 31.0 |
| 2019-04-28 19:15:00 | ES | Futures | 3188.98 | 3189.25 | 3188.7 | 3188.7 | 120.0 |
| 2019-04-28 19:20:00 | ES | Futures | 3188.7 | 3189.25 | 3188.7 | 3189.25 | 78.0 |
| 2019-04-28 19:25:00 | ES | Futures | 3189.25 | 3189.25 | 3188.7 | 3189.25 | 109.0 |
| 2019-04-28 19:30:00 | ES | Futures | 3189.25 | 3189.52 | 3188.98 | 3188.98 | 160.0 |
| 2019-04-28 19:35:00 | ES | Futures | 3188.98 | 3189.25 | 3188.7 | 3188.98 | 517.0 |
| 2019-04-28 19:40:00 | ES | Futures | 3189.25 | 3189.25 | 3188.7 | 3188.7 | 375.0 |
| 2019-04-28 19:45:00 | ES | Futures | 3188.7 | 3189.25 | 3188.7 | 3189.25 | 499.0 |
| 2019-04-28 19:50:00 | ES | Futures | 3188.98 | 3189.25 | 3188.16 | 3188.7 | 528.0 |
| 2019-04-28 19:55:00 | ES | Futures | 3188.98 | 3188.98 | 3188.43 | 3188.7 | 267.0 |
| 2019-04-28 20:00:00 | ES | Futures | 3188.7 | 3189.79 | 3188.7 | 3189.25 | 627.0 |
| 2019-04-28 20:05:00 | ES | Futures | 3189.25 | 3189.79 | 3188.43 | 3189.79 | 608.0 |
| 2019-04-28 20:10:00 | ES | Futures | 3189.79 | 3190.06 | 3189.52 | 3189.79 | 410.0 |
| 2019-04-28 20:15:00 | ES | Futures | 3189.79 | 3189.79 | 3188.7 | 3189.25 | 461.0 |
| 2019-04-28 20:20:00 | ES | Futures | 3189.25 | 3190.33 | 3188.7 | 3190.33 | 591.0 |
| 2019-04-28 20:25:00 | ES | Futures | 3190.33 | 3190.87 | 3190.33 | 3190.33 | 854.0 |
| 2019-04-28 20:30:00 | ES | Futures | 3190.33 | 3190.87 | 3190.06 | 3190.87 | 212.0 |
| 2019-04-28 20:35:00 | ES | Futures | 3190.6 | 3190.87 | 3190.33 | 3190.33 | 208.0 |
| 2019-04-28 20:40:00 | ES | Futures | 3190.33 | 3190.6 | 3190.06 | 3190.06 | 124.0 |
| 2019-04-28 20:45:00 | ES | Futures | 3190.06 | 3190.06 | 3189.52 | 3189.52 | 532.0 |
| 2019-04-28 20:50:00 | ES | Futures | 3189.52 | 3189.52 | 3188.7 | 3188.98 | 674.0 |
| 2019-04-28 20:55:00 | ES | Futures | 3188.98 | 3189.52 | 3188.7 | 3189.52 | 210.0 |
| 2019-04-28 21:00:00 | ES | Futures | 3189.52 | 3190.06 | 3189.25 | 3190.06 | 192.0 |
| 2019-04-28 21:05:00 | ES | Futures | 3190.06 | 3190.33 | 3189.25 | 3189.79 | 308.0 |
| 2019-04-28 21:10:00 | ES | Futures | 3189.52 | 3190.06 | 3189.25 | 3189.79 | 241.0 |
| 2019-04-28 21:15:00 | ES | Futures | 3189.79 | 3191.42 | 3189.52 | 3191.14 | 903.0 |
| 2019-04-28 21:20:00 | ES | Futures | 3191.14 | 3191.14 | 3190.06 | 3190.33 | 338.0 |
| 2019-04-28 21:25:00 | ES | Futures | 3190.33 | 3190.87 | 3190.06 | 3190.06 | 418.0 |
| 2019-04-28 21:30:00 | ES | Futures | 3190.06 | 3190.06 | 3189.25 | 3189.52 | 772.0 |
| 2019-04-28 21:35:00 | ES | Futures | 3189.25 | 3190.33 | 3189.25 | 3190.06 | 322.0 |
| 2019-04-28 21:40:00 | ES | Futures | 3190.06 | 3190.6 | 3188.7 | 3188.7 | 607.0 |
| 2019-04-28 21:45:00 | ES | Futures | 3188.7 | 3189.52 | 3188.7 | 3189.25 | 436.0 |
| 2019-04-28 21:50:00 | ES | Futures | 3189.25 | 3189.79 | 3188.98 | 3189.25 | 571.0 |
| 2019-04-28 21:55:00 | ES | Futures | 3189.25 | 3189.52 | 3188.98 | 3189.25 | 184.0 |
| 2019-04-28 22:00:00 | ES | Futures | 3189.52 | 3190.33 | 3189.25 | 3190.33 | 338.0 |
| 2019-04-28 22:05:00 | ES | Futures | 3190.33 | 3190.87 | 3190.06 | 3190.6 | 701.0 |
> showing 50 of 2,880 rows — these rows as CSV