PREVIEW / futures_1min / 2008-01-31
file: by_date/futures_1min/2008/2008-01-31.parquet size: 349 KB rows: 27,657
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-31 00:00:00 | ES | Futures | 1252.98 | 1252.98 | 1251.58 | 1251.82 | 230.0 |
| 2008-01-31 00:01:00 | ES | Futures | 1251.58 | 1252.05 | 1251.58 | 1251.82 | 77.0 |
| 2008-01-31 00:02:00 | ES | Futures | 1252.05 | 1252.05 | 1251.58 | 1251.82 | 73.0 |
| 2008-01-31 00:03:00 | ES | Futures | 1251.82 | 1252.05 | 1250.65 | 1251.35 | 148.0 |
| 2008-01-31 00:04:00 | ES | Futures | 1251.12 | 1251.35 | 1250.88 | 1251.35 | 28.0 |
| 2008-01-31 00:05:00 | ES | Futures | 1251.35 | 1251.58 | 1251.12 | 1251.35 | 104.0 |
| 2008-01-31 00:06:00 | ES | Futures | 1251.58 | 1251.58 | 1251.12 | 1251.58 | 45.0 |
| 2008-01-31 00:07:00 | ES | Futures | 1251.58 | 1251.82 | 1251.12 | 1251.82 | 64.0 |
| 2008-01-31 00:08:00 | ES | Futures | 1252.05 | 1252.05 | 1250.65 | 1250.88 | 337.0 |
| 2008-01-31 00:09:00 | ES | Futures | 1251.35 | 1251.35 | 1250.42 | 1250.88 | 49.0 |
| 2008-01-31 00:10:00 | ES | Futures | 1250.65 | 1250.88 | 1250.65 | 1250.65 | 24.0 |
| 2008-01-31 00:11:00 | ES | Futures | 1250.88 | 1250.88 | 1250.42 | 1250.88 | 53.0 |
| 2008-01-31 00:12:00 | ES | Futures | 1250.88 | 1250.88 | 1250.88 | 1250.88 | 4.0 |
| 2008-01-31 00:13:00 | ES | Futures | 1250.88 | 1250.88 | 1250.88 | 1250.88 | 8.0 |
| 2008-01-31 00:14:00 | ES | Futures | 1250.65 | 1250.88 | 1250.65 | 1250.88 | 24.0 |
| 2008-01-31 00:15:00 | ES | Futures | 1250.88 | 1251.82 | 1250.88 | 1251.35 | 60.0 |
| 2008-01-31 00:16:00 | ES | Futures | 1251.82 | 1251.82 | 1251.58 | 1251.82 | 41.0 |
| 2008-01-31 00:17:00 | ES | Futures | 1251.82 | 1251.82 | 1251.82 | 1251.82 | 24.0 |
| 2008-01-31 00:18:00 | ES | Futures | 1251.82 | 1253.45 | 1251.82 | 1253.45 | 253.0 |
| 2008-01-31 00:19:00 | ES | Futures | 1253.45 | 1253.45 | 1252.75 | 1252.75 | 99.0 |
| 2008-01-31 00:20:00 | ES | Futures | 1252.75 | 1252.75 | 1252.28 | 1252.51 | 54.0 |
| 2008-01-31 00:21:00 | ES | Futures | 1252.28 | 1252.51 | 1252.28 | 1252.28 | 21.0 |
| 2008-01-31 00:22:00 | ES | Futures | 1252.51 | 1252.75 | 1252.51 | 1252.75 | 38.0 |
| 2008-01-31 00:23:00 | ES | Futures | 1252.75 | 1252.75 | 1252.51 | 1252.51 | 8.0 |
| 2008-01-31 00:24:00 | ES | Futures | 1252.75 | 1253.21 | 1252.75 | 1252.98 | 64.0 |
| 2008-01-31 00:25:00 | ES | Futures | 1252.98 | 1253.21 | 1252.51 | 1252.75 | 142.0 |
| 2008-01-31 00:26:00 | ES | Futures | 1252.75 | 1252.98 | 1252.75 | 1252.75 | 36.0 |
| 2008-01-31 00:27:00 | ES | Futures | 1252.98 | 1252.98 | 1252.75 | 1252.75 | 80.0 |
| 2008-01-31 00:28:00 | ES | Futures | 1252.98 | 1253.21 | 1252.98 | 1253.21 | 4.0 |
| 2008-01-31 00:29:00 | ES | Futures | 1252.98 | 1253.68 | 1252.98 | 1253.45 | 67.0 |
| 2008-01-31 00:30:00 | ES | Futures | 1253.68 | 1253.68 | 1253.45 | 1253.45 | 55.0 |
| 2008-01-31 00:31:00 | ES | Futures | 1253.45 | 1253.68 | 1253.45 | 1253.45 | 72.0 |
| 2008-01-31 00:32:00 | ES | Futures | 1253.45 | 1253.45 | 1253.45 | 1253.45 | 36.0 |
| 2008-01-31 00:34:00 | ES | Futures | 1253.68 | 1253.68 | 1253.68 | 1253.68 | 48.0 |
| 2008-01-31 00:35:00 | ES | Futures | 1253.68 | 1253.68 | 1253.68 | 1253.68 | 3.0 |
| 2008-01-31 00:36:00 | ES | Futures | 1253.45 | 1253.68 | 1253.45 | 1253.68 | 62.0 |
| 2008-01-31 00:37:00 | ES | Futures | 1253.45 | 1254.15 | 1253.45 | 1254.15 | 237.0 |
| 2008-01-31 00:38:00 | ES | Futures | 1254.15 | 1254.15 | 1253.91 | 1254.15 | 9.0 |
| 2008-01-31 00:39:00 | ES | Futures | 1253.91 | 1253.91 | 1253.68 | 1253.68 | 16.0 |
| 2008-01-31 00:40:00 | ES | Futures | 1253.91 | 1253.91 | 1253.91 | 1253.91 | 23.0 |
| 2008-01-31 00:41:00 | ES | Futures | 1253.91 | 1254.15 | 1253.91 | 1254.15 | 3.0 |
| 2008-01-31 00:42:00 | ES | Futures | 1253.91 | 1254.15 | 1253.91 | 1253.91 | 25.0 |
| 2008-01-31 00:44:00 | ES | Futures | 1254.15 | 1254.15 | 1253.91 | 1253.91 | 26.0 |
| 2008-01-31 00:45:00 | ES | Futures | 1253.68 | 1254.38 | 1253.68 | 1254.38 | 45.0 |
| 2008-01-31 00:46:00 | ES | Futures | 1254.38 | 1254.85 | 1254.15 | 1254.61 | 187.0 |
| 2008-01-31 00:47:00 | ES | Futures | 1254.61 | 1254.61 | 1253.91 | 1254.38 | 35.0 |
| 2008-01-31 00:48:00 | ES | Futures | 1254.38 | 1254.61 | 1254.38 | 1254.38 | 11.0 |
| 2008-01-31 00:49:00 | ES | Futures | 1254.38 | 1254.38 | 1254.38 | 1254.38 | 40.0 |
| 2008-01-31 00:50:00 | ES | Futures | 1254.38 | 1254.38 | 1254.38 | 1254.38 | 3.0 |
| 2008-01-31 00:51:00 | ES | Futures | 1254.38 | 1254.38 | 1254.15 | 1254.15 | 8.0 |
> showing 50 of 27,657 rows — these rows as CSV