PREVIEW / futures_30min / 2009-11-23
file: by_date/futures_30min/2009/2009-11-23.parquet size: 65 KB rows: 2,351
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-11-23 00:00:00 | ES | Futures | 1059.96 | 1060.45 | 1059.72 | 1059.72 | 580.0 |
| 2009-11-23 00:30:00 | ES | Futures | 1059.72 | 1060.2 | 1059.24 | 1059.96 | 1105.0 |
| 2009-11-23 01:00:00 | ES | Futures | 1059.72 | 1059.96 | 1058.75 | 1059.24 | 1168.0 |
| 2009-11-23 01:30:00 | ES | Futures | 1059.48 | 1059.96 | 1059.24 | 1059.72 | 607.0 |
| 2009-11-23 02:00:00 | ES | Futures | 1059.72 | 1062.87 | 1059.72 | 1062.38 | 9508.0 |
| 2009-11-23 02:30:00 | ES | Futures | 1062.14 | 1064.56 | 1061.9 | 1062.87 | 12681.0 |
| 2009-11-23 03:00:00 | ES | Futures | 1062.87 | 1066.26 | 1062.87 | 1066.26 | 19172.0 |
| 2009-11-23 03:30:00 | ES | Futures | 1066.26 | 1067.71 | 1065.78 | 1066.26 | 13420.0 |
| 2009-11-23 04:00:00 | ES | Futures | 1066.26 | 1066.99 | 1065.53 | 1066.26 | 4980.0 |
| 2009-11-23 04:30:00 | ES | Futures | 1066.02 | 1067.47 | 1065.29 | 1066.5 | 8476.0 |
| 2009-11-23 05:00:00 | ES | Futures | 1066.74 | 1067.71 | 1066.26 | 1066.74 | 5605.0 |
| 2009-11-23 05:30:00 | ES | Futures | 1066.99 | 1067.47 | 1066.02 | 1067.47 | 3998.0 |
| 2009-11-23 06:00:00 | ES | Futures | 1067.23 | 1067.47 | 1066.26 | 1066.99 | 4871.0 |
| 2009-11-23 06:30:00 | ES | Futures | 1066.99 | 1067.71 | 1066.74 | 1067.23 | 3889.0 |
| 2009-11-23 07:00:00 | ES | Futures | 1066.99 | 1067.96 | 1066.74 | 1067.47 | 7124.0 |
| 2009-11-23 07:30:00 | ES | Futures | 1067.47 | 1067.71 | 1066.26 | 1066.74 | 8954.0 |
| 2009-11-23 08:00:00 | ES | Futures | 1066.74 | 1066.99 | 1065.53 | 1066.74 | 13689.0 |
| 2009-11-23 08:30:00 | ES | Futures | 1066.5 | 1066.99 | 1066.02 | 1066.99 | 8357.0 |
| 2009-11-23 09:00:00 | ES | Futures | 1066.99 | 1069.65 | 1066.74 | 1068.2 | 40509.0 |
| 2009-11-23 09:30:00 | ES | Futures | 1068.2 | 1076.92 | 1067.96 | 1076.19 | 251365.0 |
| 2009-11-23 10:00:00 | ES | Futures | 1075.95 | 1076.92 | 1074.01 | 1075.46 | 194809.0 |
| 2009-11-23 10:30:00 | ES | Futures | 1075.71 | 1076.19 | 1073.04 | 1073.53 | 126112.0 |
| 2009-11-23 11:00:00 | ES | Futures | 1073.77 | 1074.5 | 1073.04 | 1073.04 | 58901.0 |
| 2009-11-23 11:30:00 | ES | Futures | 1073.28 | 1074.25 | 1071.35 | 1071.59 | 61601.0 |
| 2009-11-23 12:00:00 | ES | Futures | 1071.83 | 1072.56 | 1070.62 | 1070.62 | 61837.0 |
| 2009-11-23 12:30:00 | ES | Futures | 1070.62 | 1071.59 | 1069.41 | 1070.86 | 79859.0 |
| 2009-11-23 13:00:00 | ES | Futures | 1070.86 | 1071.35 | 1069.41 | 1070.62 | 37691.0 |
| 2009-11-23 13:30:00 | ES | Futures | 1070.62 | 1071.35 | 1068.68 | 1069.41 | 51941.0 |
| 2009-11-23 14:00:00 | ES | Futures | 1069.41 | 1069.89 | 1067.71 | 1069.41 | 61929.0 |
| 2009-11-23 14:30:00 | ES | Futures | 1069.41 | 1070.38 | 1068.92 | 1069.41 | 44873.0 |
| 2009-11-23 15:00:00 | ES | Futures | 1069.41 | 1071.1 | 1069.17 | 1069.41 | 62812.0 |
| 2009-11-23 15:30:00 | ES | Futures | 1069.65 | 1070.62 | 1066.99 | 1069.65 | 158732.0 |
| 2009-11-23 16:00:00 | ES | Futures | 1069.89 | 1069.89 | 1068.44 | 1069.65 | 86599.0 |
| 2009-11-23 16:30:00 | ES | Futures | 1069.17 | 1069.65 | 1068.44 | 1068.68 | 3266.0 |
| 2009-11-23 17:00:00 | ES | Futures | 1068.68 | 1068.68 | 1068.2 | 1068.44 | 934.0 |
| 2009-11-23 18:00:00 | ES | Futures | 1068.68 | 1069.17 | 1068.44 | 1068.92 | 1447.0 |
| 2009-11-23 18:30:00 | ES | Futures | 1069.17 | 1069.41 | 1068.68 | 1068.68 | 845.0 |
| 2009-11-23 19:00:00 | ES | Futures | 1068.68 | 1068.92 | 1068.2 | 1068.44 | 1755.0 |
| 2009-11-23 19:30:00 | ES | Futures | 1068.2 | 1068.68 | 1067.71 | 1067.96 | 4847.0 |
| 2009-11-23 20:00:00 | ES | Futures | 1067.71 | 1068.2 | 1067.71 | 1067.96 | 1247.0 |
| 2009-11-23 20:30:00 | ES | Futures | 1067.96 | 1067.96 | 1066.99 | 1067.23 | 3018.0 |
| 2009-11-23 21:00:00 | ES | Futures | 1067.47 | 1067.96 | 1067.23 | 1067.47 | 1052.0 |
| 2009-11-23 21:30:00 | ES | Futures | 1067.47 | 1067.96 | 1067.23 | 1067.47 | 905.0 |
| 2009-11-23 22:00:00 | ES | Futures | 1067.23 | 1067.47 | 1066.99 | 1066.99 | 1924.0 |
| 2009-11-23 22:30:00 | ES | Futures | 1066.99 | 1067.23 | 1066.74 | 1067.23 | 2929.0 |
| 2009-11-23 23:00:00 | ES | Futures | 1067.23 | 1067.71 | 1066.99 | 1066.99 | 1290.0 |
| 2009-11-23 23:30:00 | ES | Futures | 1067.23 | 1067.23 | 1066.74 | 1066.74 | 2001.0 |
| 2009-11-23 00:00:00 | NQ | Futures | 2020.03 | 2020.03 | 2019.46 | 2019.46 | 7.0 |
| 2009-11-23 00:30:00 | NQ | Futures | 2019.17 | 2020.03 | 2018.89 | 2019.46 | 31.0 |
| 2009-11-23 01:00:00 | NQ | Futures | 2018.89 | 2018.89 | 2017.18 | 2018.6 | 38.0 |
> showing 50 of 2,351 rows — these rows as CSV