PREVIEW / futures_5min / 2018-09-24
file: by_date/futures_5min/2018/2018-09-24.parquet size: 235 KB rows: 15,244
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-24 00:00:00 | ES | Futures | 3185.64 | 3185.92 | 3185.64 | 3185.64 | 18.0 |
| 2018-09-24 00:05:00 | ES | Futures | 3185.64 | 3185.92 | 3185.37 | 3185.37 | 264.0 |
| 2018-09-24 00:10:00 | ES | Futures | 3185.37 | 3185.64 | 3185.1 | 3185.37 | 166.0 |
| 2018-09-24 00:15:00 | ES | Futures | 3185.37 | 3185.37 | 3185.1 | 3185.1 | 144.0 |
| 2018-09-24 00:20:00 | ES | Futures | 3185.1 | 3185.37 | 3184.83 | 3184.83 | 151.0 |
| 2018-09-24 00:25:00 | ES | Futures | 3184.83 | 3185.1 | 3184.83 | 3185.1 | 208.0 |
| 2018-09-24 00:30:00 | ES | Futures | 3185.1 | 3185.37 | 3184.83 | 3185.37 | 62.0 |
| 2018-09-24 00:35:00 | ES | Futures | 3185.1 | 3185.37 | 3185.1 | 3185.1 | 65.0 |
| 2018-09-24 00:40:00 | ES | Futures | 3185.1 | 3185.37 | 3184.83 | 3185.1 | 137.0 |
| 2018-09-24 00:45:00 | ES | Futures | 3185.1 | 3185.37 | 3185.1 | 3185.1 | 62.0 |
| 2018-09-24 00:50:00 | ES | Futures | 3185.1 | 3185.37 | 3185.1 | 3185.1 | 63.0 |
| 2018-09-24 00:55:00 | ES | Futures | 3185.37 | 3185.37 | 3184.83 | 3184.83 | 74.0 |
| 2018-09-24 01:00:00 | ES | Futures | 3185.1 | 3185.64 | 3184.83 | 3185.64 | 245.0 |
| 2018-09-24 01:05:00 | ES | Futures | 3185.92 | 3185.92 | 3185.64 | 3185.92 | 340.0 |
| 2018-09-24 01:10:00 | ES | Futures | 3185.92 | 3185.92 | 3185.1 | 3185.37 | 256.0 |
| 2018-09-24 01:15:00 | ES | Futures | 3185.64 | 3185.64 | 3185.1 | 3185.1 | 69.0 |
| 2018-09-24 01:20:00 | ES | Futures | 3185.37 | 3185.37 | 3185.1 | 3185.37 | 291.0 |
| 2018-09-24 01:25:00 | ES | Futures | 3185.37 | 3185.37 | 3184.83 | 3185.1 | 127.0 |
| 2018-09-24 01:30:00 | ES | Futures | 3185.1 | 3185.37 | 3184.83 | 3185.37 | 81.0 |
| 2018-09-24 01:35:00 | ES | Futures | 3185.1 | 3185.37 | 3185.1 | 3185.1 | 71.0 |
| 2018-09-24 01:40:00 | ES | Futures | 3185.1 | 3185.64 | 3184.83 | 3185.1 | 790.0 |
| 2018-09-24 01:45:00 | ES | Futures | 3185.1 | 3185.64 | 3185.1 | 3185.37 | 900.0 |
| 2018-09-24 01:50:00 | ES | Futures | 3185.37 | 3185.37 | 3185.1 | 3185.37 | 473.0 |
| 2018-09-24 01:55:00 | ES | Futures | 3185.1 | 3185.64 | 3184.56 | 3185.64 | 462.0 |
| 2018-09-24 02:00:00 | ES | Futures | 3185.64 | 3185.92 | 3184.83 | 3185.37 | 499.0 |
| 2018-09-24 02:05:00 | ES | Futures | 3185.1 | 3185.1 | 3184.28 | 3184.56 | 357.0 |
| 2018-09-24 02:10:00 | ES | Futures | 3184.56 | 3184.56 | 3184.28 | 3184.28 | 254.0 |
| 2018-09-24 02:15:00 | ES | Futures | 3184.28 | 3184.56 | 3183.2 | 3183.2 | 740.0 |
| 2018-09-24 02:20:00 | ES | Futures | 3183.2 | 3183.47 | 3182.65 | 3182.65 | 658.0 |
| 2018-09-24 02:25:00 | ES | Futures | 3182.65 | 3183.74 | 3182.65 | 3183.47 | 687.0 |
| 2018-09-24 02:30:00 | ES | Futures | 3183.47 | 3184.01 | 3182.65 | 3182.92 | 906.0 |
| 2018-09-24 02:35:00 | ES | Futures | 3182.65 | 3183.2 | 3182.38 | 3182.65 | 982.0 |
| 2018-09-24 02:40:00 | ES | Futures | 3182.65 | 3182.65 | 3181.84 | 3182.11 | 895.0 |
| 2018-09-24 02:45:00 | ES | Futures | 3182.38 | 3182.65 | 3182.11 | 3182.38 | 747.0 |
| 2018-09-24 02:50:00 | ES | Futures | 3182.65 | 3182.92 | 3182.38 | 3182.38 | 325.0 |
| 2018-09-24 02:55:00 | ES | Futures | 3182.38 | 3183.74 | 3182.38 | 3183.74 | 1905.0 |
| 2018-09-24 03:00:00 | ES | Futures | 3183.47 | 3184.83 | 3183.47 | 3184.56 | 2372.0 |
| 2018-09-24 03:05:00 | ES | Futures | 3184.83 | 3185.1 | 3184.28 | 3184.56 | 1932.0 |
| 2018-09-24 03:10:00 | ES | Futures | 3184.56 | 3185.1 | 3184.28 | 3184.56 | 551.0 |
| 2018-09-24 03:15:00 | ES | Futures | 3184.83 | 3186.19 | 3184.56 | 3185.64 | 1923.0 |
| 2018-09-24 03:20:00 | ES | Futures | 3185.64 | 3185.64 | 3184.56 | 3185.1 | 754.0 |
| 2018-09-24 03:25:00 | ES | Futures | 3185.1 | 3185.1 | 3184.28 | 3184.83 | 1887.0 |
| 2018-09-24 03:30:00 | ES | Futures | 3184.83 | 3185.1 | 3184.28 | 3184.83 | 1818.0 |
| 2018-09-24 03:35:00 | ES | Futures | 3185.1 | 3185.37 | 3184.83 | 3184.83 | 839.0 |
| 2018-09-24 03:40:00 | ES | Futures | 3184.83 | 3184.83 | 3184.56 | 3184.83 | 1037.0 |
| 2018-09-24 03:45:00 | ES | Futures | 3184.83 | 3185.37 | 3184.56 | 3185.1 | 743.0 |
| 2018-09-24 03:50:00 | ES | Futures | 3185.1 | 3185.1 | 3184.56 | 3184.83 | 1647.0 |
| 2018-09-24 03:55:00 | ES | Futures | 3184.56 | 3184.83 | 3184.01 | 3184.56 | 740.0 |
| 2018-09-24 04:00:00 | ES | Futures | 3184.28 | 3185.92 | 3184.28 | 3185.64 | 1010.0 |
| 2018-09-24 04:05:00 | ES | Futures | 3185.92 | 3186.19 | 3185.37 | 3185.64 | 960.0 |
> showing 50 of 15,244 rows — these rows as CSV