PREVIEW / futures_30min / 2009-12-01
file: by_date/futures_30min/2009/2009-12-01.parquet size: 70 KB rows: 2,529
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-01 00:00:00 | ES | Futures | 1061.9 | 1061.9 | 1059.96 | 1060.69 | 2239.0 |
| 2009-12-01 00:30:00 | ES | Futures | 1060.69 | 1062.38 | 1060.45 | 1062.14 | 2025.0 |
| 2009-12-01 01:00:00 | ES | Futures | 1062.38 | 1062.38 | 1061.17 | 1061.66 | 1379.0 |
| 2009-12-01 01:30:00 | ES | Futures | 1061.9 | 1062.38 | 1059.96 | 1061.66 | 3853.0 |
| 2009-12-01 02:00:00 | ES | Futures | 1061.66 | 1063.84 | 1061.42 | 1063.35 | 7692.0 |
| 2009-12-01 02:30:00 | ES | Futures | 1063.6 | 1063.6 | 1061.9 | 1061.9 | 7348.0 |
| 2009-12-01 03:00:00 | ES | Futures | 1062.14 | 1068.2 | 1061.9 | 1066.74 | 31759.0 |
| 2009-12-01 03:30:00 | ES | Futures | 1066.5 | 1068.92 | 1066.02 | 1068.44 | 20916.0 |
| 2009-12-01 04:00:00 | ES | Futures | 1068.44 | 1070.62 | 1067.96 | 1070.38 | 15377.0 |
| 2009-12-01 04:30:00 | ES | Futures | 1070.14 | 1070.62 | 1068.68 | 1068.92 | 10975.0 |
| 2009-12-01 05:00:00 | ES | Futures | 1069.17 | 1070.14 | 1068.68 | 1069.41 | 5331.0 |
| 2009-12-01 05:30:00 | ES | Futures | 1069.65 | 1069.89 | 1067.47 | 1068.44 | 13514.0 |
| 2009-12-01 06:00:00 | ES | Futures | 1068.44 | 1068.92 | 1067.47 | 1068.2 | 8032.0 |
| 2009-12-01 06:30:00 | ES | Futures | 1068.44 | 1070.14 | 1068.2 | 1070.14 | 7541.0 |
| 2009-12-01 07:00:00 | ES | Futures | 1069.89 | 1070.62 | 1069.41 | 1070.14 | 9566.0 |
| 2009-12-01 07:30:00 | ES | Futures | 1069.89 | 1070.14 | 1068.68 | 1068.68 | 10785.0 |
| 2009-12-01 08:00:00 | ES | Futures | 1068.92 | 1070.14 | 1068.2 | 1069.41 | 13787.0 |
| 2009-12-01 08:30:00 | ES | Futures | 1069.41 | 1069.89 | 1068.44 | 1069.65 | 12779.0 |
| 2009-12-01 09:00:00 | ES | Futures | 1069.41 | 1070.14 | 1068.92 | 1069.89 | 17604.0 |
| 2009-12-01 09:30:00 | ES | Futures | 1069.89 | 1074.01 | 1069.65 | 1072.32 | 232852.0 |
| 2009-12-01 10:00:00 | ES | Futures | 1072.07 | 1073.53 | 1067.96 | 1070.38 | 216451.0 |
| 2009-12-01 10:30:00 | ES | Futures | 1070.62 | 1072.32 | 1069.65 | 1070.86 | 108758.0 |
| 2009-12-01 11:00:00 | ES | Futures | 1071.1 | 1074.25 | 1070.86 | 1073.28 | 128106.0 |
| 2009-12-01 11:30:00 | ES | Futures | 1073.28 | 1074.01 | 1072.56 | 1073.53 | 80680.0 |
| 2009-12-01 12:00:00 | ES | Futures | 1073.28 | 1074.98 | 1073.04 | 1073.53 | 77188.0 |
| 2009-12-01 12:30:00 | ES | Futures | 1073.28 | 1074.25 | 1072.8 | 1073.53 | 44724.0 |
| 2009-12-01 13:00:00 | ES | Futures | 1073.53 | 1076.68 | 1073.53 | 1075.95 | 69032.0 |
| 2009-12-01 13:30:00 | ES | Futures | 1075.71 | 1077.16 | 1075.71 | 1075.95 | 68301.0 |
| 2009-12-01 14:00:00 | ES | Futures | 1075.95 | 1076.43 | 1074.98 | 1076.19 | 50622.0 |
| 2009-12-01 14:30:00 | ES | Futures | 1076.43 | 1076.92 | 1073.77 | 1074.74 | 98166.0 |
| 2009-12-01 15:00:00 | ES | Futures | 1074.74 | 1075.46 | 1073.04 | 1074.5 | 88927.0 |
| 2009-12-01 15:30:00 | ES | Futures | 1074.25 | 1075.22 | 1072.07 | 1073.04 | 203530.0 |
| 2009-12-01 16:00:00 | ES | Futures | 1073.04 | 1074.25 | 1072.32 | 1074.25 | 111160.0 |
| 2009-12-01 16:30:00 | ES | Futures | 1073.77 | 1073.77 | 1073.28 | 1073.28 | 2737.0 |
| 2009-12-01 17:00:00 | ES | Futures | 1073.28 | 1073.77 | 1073.28 | 1073.28 | 794.0 |
| 2009-12-01 18:00:00 | ES | Futures | 1073.28 | 1074.5 | 1073.28 | 1074.25 | 2245.0 |
| 2009-12-01 18:30:00 | ES | Futures | 1074.5 | 1074.5 | 1073.04 | 1074.01 | 2301.0 |
| 2009-12-01 19:00:00 | ES | Futures | 1074.01 | 1074.01 | 1072.8 | 1072.8 | 2872.0 |
| 2009-12-01 19:30:00 | ES | Futures | 1073.04 | 1074.5 | 1072.8 | 1074.01 | 1852.0 |
| 2009-12-01 20:00:00 | ES | Futures | 1074.01 | 1074.5 | 1073.28 | 1073.53 | 1891.0 |
| 2009-12-01 20:30:00 | ES | Futures | 1073.77 | 1073.77 | 1072.56 | 1072.8 | 2006.0 |
| 2009-12-01 21:00:00 | ES | Futures | 1072.8 | 1073.77 | 1072.8 | 1073.77 | 1438.0 |
| 2009-12-01 21:30:00 | ES | Futures | 1073.77 | 1073.77 | 1073.28 | 1073.28 | 679.0 |
| 2009-12-01 22:00:00 | ES | Futures | 1073.28 | 1074.01 | 1073.28 | 1073.77 | 891.0 |
| 2009-12-01 22:30:00 | ES | Futures | 1074.01 | 1074.01 | 1073.28 | 1073.53 | 1247.0 |
| 2009-12-01 23:00:00 | ES | Futures | 1073.77 | 1074.01 | 1073.53 | 1073.77 | 504.0 |
| 2009-12-01 23:30:00 | ES | Futures | 1073.77 | 1073.77 | 1073.04 | 1073.53 | 598.0 |
| 2009-12-01 00:00:00 | NQ | Futures | 2018.89 | 2019.17 | 2015.47 | 2016.32 | 279.0 |
| 2009-12-01 00:30:00 | NQ | Futures | 2016.32 | 2020.89 | 2016.32 | 2020.6 | 270.0 |
| 2009-12-01 01:00:00 | NQ | Futures | 2020.32 | 2020.89 | 2018.03 | 2019.75 | 189.0 |
> showing 50 of 2,529 rows — these rows as CSV