PREVIEW / futures_30min / 2010-02-24
file: by_date/futures_30min/2010/2010-02-24.parquet size: 69 KB rows: 2,547
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 |
|---|---|---|---|---|---|---|---|
| 2010-02-24 00:00:00 | ES | Futures | 1067.42 | 1068.39 | 1067.18 | 1067.91 | 1655.0 |
| 2010-02-24 00:30:00 | ES | Futures | 1067.66 | 1068.39 | 1067.42 | 1068.15 | 1222.0 |
| 2010-02-24 01:00:00 | ES | Futures | 1068.15 | 1068.64 | 1067.42 | 1067.66 | 827.0 |
| 2010-02-24 01:30:00 | ES | Futures | 1067.66 | 1069.12 | 1067.42 | 1068.64 | 2183.0 |
| 2010-02-24 02:00:00 | ES | Futures | 1068.88 | 1068.88 | 1067.66 | 1067.91 | 5737.0 |
| 2010-02-24 02:30:00 | ES | Futures | 1067.66 | 1068.15 | 1066.69 | 1067.18 | 3647.0 |
| 2010-02-24 03:00:00 | ES | Futures | 1067.18 | 1068.64 | 1066.69 | 1068.15 | 12332.0 |
| 2010-02-24 03:30:00 | ES | Futures | 1068.15 | 1068.39 | 1064.74 | 1064.99 | 13352.0 |
| 2010-02-24 04:00:00 | ES | Futures | 1064.99 | 1065.47 | 1063.04 | 1063.77 | 27660.0 |
| 2010-02-24 04:30:00 | ES | Futures | 1064.01 | 1064.99 | 1063.53 | 1064.99 | 8684.0 |
| 2010-02-24 05:00:00 | ES | Futures | 1065.23 | 1066.45 | 1064.74 | 1065.47 | 9414.0 |
| 2010-02-24 05:30:00 | ES | Futures | 1065.47 | 1066.45 | 1064.5 | 1066.2 | 6377.0 |
| 2010-02-24 06:00:00 | ES | Futures | 1066.2 | 1066.45 | 1064.99 | 1065.47 | 6935.0 |
| 2010-02-24 06:30:00 | ES | Futures | 1065.23 | 1068.64 | 1065.23 | 1068.39 | 17220.0 |
| 2010-02-24 07:00:00 | ES | Futures | 1068.39 | 1068.39 | 1067.42 | 1067.42 | 6007.0 |
| 2010-02-24 07:30:00 | ES | Futures | 1067.66 | 1069.85 | 1067.18 | 1068.88 | 25704.0 |
| 2010-02-24 08:00:00 | ES | Futures | 1069.12 | 1069.12 | 1068.39 | 1068.64 | 11704.0 |
| 2010-02-24 08:30:00 | ES | Futures | 1068.88 | 1069.12 | 1067.66 | 1068.39 | 20488.0 |
| 2010-02-24 09:00:00 | ES | Futures | 1068.64 | 1068.64 | 1066.69 | 1067.42 | 21644.0 |
| 2010-02-24 09:30:00 | ES | Futures | 1067.18 | 1072.28 | 1066.93 | 1070.58 | 162405.0 |
| 2010-02-24 10:00:00 | ES | Futures | 1070.58 | 1070.83 | 1064.26 | 1065.72 | 281079.0 |
| 2010-02-24 10:30:00 | ES | Futures | 1065.72 | 1074.72 | 1064.74 | 1073.26 | 291138.0 |
| 2010-02-24 11:00:00 | ES | Futures | 1073.01 | 1075.2 | 1071.07 | 1071.8 | 140849.0 |
| 2010-02-24 11:30:00 | ES | Futures | 1072.04 | 1073.26 | 1071.31 | 1072.53 | 65505.0 |
| 2010-02-24 12:00:00 | ES | Futures | 1072.77 | 1074.23 | 1071.31 | 1072.53 | 56299.0 |
| 2010-02-24 12:30:00 | ES | Futures | 1072.77 | 1073.74 | 1071.8 | 1072.28 | 30702.0 |
| 2010-02-24 13:00:00 | ES | Futures | 1072.53 | 1075.69 | 1071.55 | 1074.23 | 78081.0 |
| 2010-02-24 13:30:00 | ES | Futures | 1074.23 | 1075.2 | 1072.77 | 1073.99 | 39191.0 |
| 2010-02-24 14:00:00 | ES | Futures | 1073.99 | 1074.47 | 1072.04 | 1072.53 | 65281.0 |
| 2010-02-24 14:30:00 | ES | Futures | 1072.53 | 1072.77 | 1069.37 | 1070.58 | 120503.0 |
| 2010-02-24 15:00:00 | ES | Futures | 1070.58 | 1072.77 | 1070.34 | 1071.8 | 66175.0 |
| 2010-02-24 15:30:00 | ES | Futures | 1072.04 | 1074.47 | 1071.07 | 1073.74 | 159197.0 |
| 2010-02-24 16:00:00 | ES | Futures | 1073.74 | 1074.23 | 1073.01 | 1073.74 | 85874.0 |
| 2010-02-24 16:30:00 | ES | Futures | 1073.26 | 1073.5 | 1072.28 | 1072.77 | 5369.0 |
| 2010-02-24 17:00:00 | ES | Futures | 1072.53 | 1073.26 | 1072.53 | 1072.77 | 1175.0 |
| 2010-02-24 18:00:00 | ES | Futures | 1073.01 | 1073.74 | 1072.53 | 1073.01 | 3182.0 |
| 2010-02-24 18:30:00 | ES | Futures | 1073.01 | 1073.5 | 1072.53 | 1073.5 | 1320.0 |
| 2010-02-24 19:00:00 | ES | Futures | 1073.26 | 1073.5 | 1072.77 | 1072.77 | 1843.0 |
| 2010-02-24 19:30:00 | ES | Futures | 1073.01 | 1073.74 | 1072.53 | 1072.53 | 1582.0 |
| 2010-02-24 20:00:00 | ES | Futures | 1072.77 | 1073.01 | 1070.83 | 1071.55 | 4692.0 |
| 2010-02-24 20:30:00 | ES | Futures | 1071.55 | 1071.8 | 1070.34 | 1070.58 | 2517.0 |
| 2010-02-24 21:00:00 | ES | Futures | 1070.58 | 1072.04 | 1070.34 | 1071.31 | 2714.0 |
| 2010-02-24 21:30:00 | ES | Futures | 1071.31 | 1071.8 | 1069.61 | 1070.34 | 3359.0 |
| 2010-02-24 22:00:00 | ES | Futures | 1070.34 | 1071.31 | 1069.85 | 1070.1 | 1923.0 |
| 2010-02-24 22:30:00 | ES | Futures | 1070.34 | 1070.34 | 1067.66 | 1067.91 | 6991.0 |
| 2010-02-24 23:00:00 | ES | Futures | 1067.91 | 1068.15 | 1065.96 | 1066.2 | 6971.0 |
| 2010-02-24 23:30:00 | ES | Futures | 1065.96 | 1066.45 | 1064.74 | 1065.96 | 7670.0 |
| 2010-02-24 00:00:00 | NQ | Futures | 2058.53 | 2059.96 | 2057.67 | 2058.53 | 110.0 |
| 2010-02-24 00:30:00 | NQ | Futures | 2059.1 | 2059.96 | 2058.24 | 2059.1 | 65.0 |
| 2010-02-24 01:00:00 | NQ | Futures | 2059.39 | 2059.96 | 2059.1 | 2059.39 | 150.0 |
> showing 50 of 2,547 rows — these rows as CSV