PREVIEW / futures_5min / 2009-12-18
file: by_date/futures_5min/2009/2009-12-18.parquet size: 170 KB rows: 9,932
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-18 00:00:00 | ES | Futures | 1067.18 | 1067.42 | 1067.18 | 1067.18 | 53.0 |
| 2009-12-18 00:05:00 | ES | Futures | 1067.42 | 1067.42 | 1067.18 | 1067.42 | 54.0 |
| 2009-12-18 00:10:00 | ES | Futures | 1067.42 | 1067.42 | 1067.18 | 1067.18 | 105.0 |
| 2009-12-18 00:15:00 | ES | Futures | 1067.42 | 1067.42 | 1066.93 | 1066.93 | 78.0 |
| 2009-12-18 00:20:00 | ES | Futures | 1066.93 | 1067.42 | 1066.93 | 1067.18 | 246.0 |
| 2009-12-18 00:25:00 | ES | Futures | 1067.18 | 1067.42 | 1066.69 | 1066.69 | 578.0 |
| 2009-12-18 00:30:00 | ES | Futures | 1066.93 | 1067.18 | 1066.69 | 1066.93 | 149.0 |
| 2009-12-18 00:35:00 | ES | Futures | 1067.18 | 1067.42 | 1067.18 | 1067.42 | 95.0 |
| 2009-12-18 00:40:00 | ES | Futures | 1067.42 | 1067.42 | 1067.18 | 1067.42 | 11.0 |
| 2009-12-18 00:45:00 | ES | Futures | 1067.18 | 1067.42 | 1067.18 | 1067.42 | 45.0 |
| 2009-12-18 00:50:00 | ES | Futures | 1067.18 | 1067.42 | 1067.18 | 1067.42 | 52.0 |
| 2009-12-18 00:55:00 | ES | Futures | 1067.42 | 1067.66 | 1067.42 | 1067.66 | 178.0 |
| 2009-12-18 01:00:00 | ES | Futures | 1067.42 | 1067.91 | 1067.42 | 1067.42 | 260.0 |
| 2009-12-18 01:05:00 | ES | Futures | 1067.66 | 1067.91 | 1067.42 | 1067.66 | 103.0 |
| 2009-12-18 01:10:00 | ES | Futures | 1067.91 | 1068.15 | 1067.66 | 1068.15 | 185.0 |
| 2009-12-18 01:15:00 | ES | Futures | 1067.91 | 1068.88 | 1067.91 | 1068.88 | 1503.0 |
| 2009-12-18 01:20:00 | ES | Futures | 1068.64 | 1069.37 | 1068.64 | 1069.37 | 1193.0 |
| 2009-12-18 01:25:00 | ES | Futures | 1069.37 | 1069.37 | 1068.88 | 1068.88 | 142.0 |
| 2009-12-18 01:30:00 | ES | Futures | 1068.88 | 1069.37 | 1068.64 | 1068.88 | 242.0 |
| 2009-12-18 01:35:00 | ES | Futures | 1068.88 | 1069.12 | 1068.88 | 1068.88 | 195.0 |
| 2009-12-18 01:40:00 | ES | Futures | 1068.88 | 1069.12 | 1068.64 | 1068.88 | 293.0 |
| 2009-12-18 01:45:00 | ES | Futures | 1068.64 | 1069.12 | 1068.64 | 1068.64 | 112.0 |
| 2009-12-18 01:50:00 | ES | Futures | 1068.64 | 1068.88 | 1068.15 | 1068.39 | 510.0 |
| 2009-12-18 01:55:00 | ES | Futures | 1068.64 | 1068.88 | 1067.66 | 1067.66 | 366.0 |
| 2009-12-18 02:00:00 | ES | Futures | 1067.91 | 1067.91 | 1066.93 | 1067.91 | 1113.0 |
| 2009-12-18 02:05:00 | ES | Futures | 1067.91 | 1068.15 | 1067.42 | 1067.66 | 627.0 |
| 2009-12-18 02:10:00 | ES | Futures | 1067.66 | 1067.91 | 1067.42 | 1067.66 | 347.0 |
| 2009-12-18 02:15:00 | ES | Futures | 1067.42 | 1067.66 | 1067.18 | 1067.18 | 294.0 |
| 2009-12-18 02:20:00 | ES | Futures | 1067.18 | 1069.37 | 1067.18 | 1069.12 | 2781.0 |
| 2009-12-18 02:25:00 | ES | Futures | 1069.12 | 1069.12 | 1068.88 | 1069.12 | 146.0 |
| 2009-12-18 02:30:00 | ES | Futures | 1068.88 | 1069.37 | 1068.88 | 1069.37 | 1032.0 |
| 2009-12-18 02:35:00 | ES | Futures | 1069.12 | 1069.37 | 1068.88 | 1068.88 | 767.0 |
| 2009-12-18 02:40:00 | ES | Futures | 1068.88 | 1069.12 | 1067.91 | 1068.39 | 574.0 |
| 2009-12-18 02:45:00 | ES | Futures | 1068.15 | 1068.88 | 1068.15 | 1068.39 | 676.0 |
| 2009-12-18 02:50:00 | ES | Futures | 1068.15 | 1068.64 | 1068.15 | 1068.64 | 267.0 |
| 2009-12-18 02:55:00 | ES | Futures | 1068.64 | 1069.12 | 1068.15 | 1068.39 | 938.0 |
| 2009-12-18 03:00:00 | ES | Futures | 1068.15 | 1069.37 | 1068.15 | 1069.12 | 2200.0 |
| 2009-12-18 03:05:00 | ES | Futures | 1069.12 | 1069.12 | 1068.64 | 1068.88 | 1290.0 |
| 2009-12-18 03:10:00 | ES | Futures | 1068.64 | 1069.37 | 1068.15 | 1069.12 | 2314.0 |
| 2009-12-18 03:15:00 | ES | Futures | 1069.12 | 1069.12 | 1068.39 | 1068.88 | 987.0 |
| 2009-12-18 03:20:00 | ES | Futures | 1068.88 | 1069.85 | 1068.88 | 1069.61 | 2589.0 |
| 2009-12-18 03:25:00 | ES | Futures | 1069.61 | 1070.1 | 1069.37 | 1069.85 | 1645.0 |
| 2009-12-18 03:30:00 | ES | Futures | 1069.85 | 1070.34 | 1069.61 | 1069.61 | 1452.0 |
| 2009-12-18 03:35:00 | ES | Futures | 1069.61 | 1070.1 | 1069.61 | 1069.61 | 1456.0 |
| 2009-12-18 03:40:00 | ES | Futures | 1069.61 | 1070.1 | 1069.61 | 1069.85 | 1412.0 |
| 2009-12-18 03:45:00 | ES | Futures | 1069.85 | 1070.34 | 1069.37 | 1069.61 | 2873.0 |
| 2009-12-18 03:50:00 | ES | Futures | 1069.61 | 1069.61 | 1068.39 | 1068.88 | 2449.0 |
| 2009-12-18 03:55:00 | ES | Futures | 1068.64 | 1068.88 | 1068.39 | 1068.64 | 551.0 |
| 2009-12-18 04:00:00 | ES | Futures | 1068.39 | 1068.88 | 1068.39 | 1068.88 | 762.0 |
| 2009-12-18 04:05:00 | ES | Futures | 1069.12 | 1069.12 | 1068.64 | 1068.64 | 1350.0 |
> showing 50 of 9,932 rows — these rows as CSV