PREVIEW / futures_30min / 2010-02-18
file: by_date/futures_30min/2010/2010-02-18.parquet size: 73 KB rows: 2,544
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-18 00:00:00 | ES | Futures | 1067.66 | 1068.15 | 1067.18 | 1067.42 | 801.0 |
| 2010-02-18 00:30:00 | ES | Futures | 1067.42 | 1068.15 | 1067.42 | 1067.91 | 663.0 |
| 2010-02-18 01:00:00 | ES | Futures | 1068.15 | 1068.39 | 1067.42 | 1068.15 | 869.0 |
| 2010-02-18 01:30:00 | ES | Futures | 1068.15 | 1068.88 | 1067.42 | 1068.15 | 1350.0 |
| 2010-02-18 02:00:00 | ES | Futures | 1068.15 | 1068.15 | 1065.96 | 1066.2 | 6512.0 |
| 2010-02-18 02:30:00 | ES | Futures | 1066.45 | 1066.93 | 1065.23 | 1065.47 | 6885.0 |
| 2010-02-18 03:00:00 | ES | Futures | 1065.72 | 1066.69 | 1064.74 | 1064.99 | 13490.0 |
| 2010-02-18 03:30:00 | ES | Futures | 1064.99 | 1066.45 | 1064.74 | 1065.72 | 7152.0 |
| 2010-02-18 04:00:00 | ES | Futures | 1065.72 | 1066.2 | 1064.5 | 1065.96 | 8859.0 |
| 2010-02-18 04:30:00 | ES | Futures | 1066.2 | 1067.91 | 1065.72 | 1067.18 | 9613.0 |
| 2010-02-18 05:00:00 | ES | Futures | 1066.93 | 1069.61 | 1066.93 | 1068.88 | 9759.0 |
| 2010-02-18 05:30:00 | ES | Futures | 1068.64 | 1069.85 | 1068.64 | 1068.64 | 5759.0 |
| 2010-02-18 06:00:00 | ES | Futures | 1068.64 | 1069.12 | 1068.15 | 1068.15 | 5944.0 |
| 2010-02-18 06:30:00 | ES | Futures | 1068.15 | 1068.88 | 1067.42 | 1068.39 | 7316.0 |
| 2010-02-18 07:00:00 | ES | Futures | 1068.15 | 1068.64 | 1066.93 | 1068.39 | 13772.0 |
| 2010-02-18 07:30:00 | ES | Futures | 1068.39 | 1068.64 | 1067.42 | 1068.15 | 8394.0 |
| 2010-02-18 08:00:00 | ES | Futures | 1067.91 | 1069.12 | 1067.91 | 1068.88 | 12289.0 |
| 2010-02-18 08:30:00 | ES | Futures | 1068.64 | 1068.64 | 1063.53 | 1064.99 | 79850.0 |
| 2010-02-18 09:00:00 | ES | Futures | 1064.99 | 1066.93 | 1064.5 | 1066.69 | 36755.0 |
| 2010-02-18 09:30:00 | ES | Futures | 1066.69 | 1071.31 | 1066.2 | 1070.1 | 219632.0 |
| 2010-02-18 10:00:00 | ES | Futures | 1070.1 | 1072.28 | 1067.66 | 1068.39 | 167222.0 |
| 2010-02-18 10:30:00 | ES | Futures | 1068.39 | 1071.07 | 1066.69 | 1070.1 | 131136.0 |
| 2010-02-18 11:00:00 | ES | Futures | 1070.1 | 1070.83 | 1069.12 | 1069.37 | 96698.0 |
| 2010-02-18 11:30:00 | ES | Futures | 1069.61 | 1070.34 | 1068.15 | 1069.37 | 89941.0 |
| 2010-02-18 12:00:00 | ES | Futures | 1069.37 | 1070.34 | 1068.39 | 1069.37 | 47709.0 |
| 2010-02-18 12:30:00 | ES | Futures | 1069.37 | 1069.61 | 1068.39 | 1068.88 | 40550.0 |
| 2010-02-18 13:00:00 | ES | Futures | 1069.12 | 1070.1 | 1068.64 | 1069.37 | 50104.0 |
| 2010-02-18 13:30:00 | ES | Futures | 1069.61 | 1071.8 | 1069.37 | 1071.07 | 75442.0 |
| 2010-02-18 14:00:00 | ES | Futures | 1071.07 | 1074.72 | 1070.34 | 1073.74 | 124234.0 |
| 2010-02-18 14:30:00 | ES | Futures | 1073.74 | 1075.93 | 1073.5 | 1075.69 | 128262.0 |
| 2010-02-18 15:00:00 | ES | Futures | 1075.45 | 1076.18 | 1074.23 | 1074.96 | 103566.0 |
| 2010-02-18 15:30:00 | ES | Futures | 1074.96 | 1076.91 | 1074.47 | 1075.2 | 192158.0 |
| 2010-02-18 16:00:00 | ES | Futures | 1075.2 | 1076.18 | 1074.23 | 1075.93 | 100432.0 |
| 2010-02-18 16:30:00 | ES | Futures | 1075.69 | 1075.93 | 1064.99 | 1066.93 | 100427.0 |
| 2010-02-18 17:00:00 | ES | Futures | 1066.93 | 1068.88 | 1066.2 | 1068.39 | 13276.0 |
| 2010-02-18 18:00:00 | ES | Futures | 1067.66 | 1068.39 | 1065.47 | 1066.69 | 14081.0 |
| 2010-02-18 18:30:00 | ES | Futures | 1066.69 | 1067.42 | 1064.74 | 1065.47 | 5932.0 |
| 2010-02-18 19:00:00 | ES | Futures | 1065.47 | 1067.18 | 1064.5 | 1067.18 | 6370.0 |
| 2010-02-18 19:30:00 | ES | Futures | 1067.18 | 1067.42 | 1066.69 | 1067.18 | 4099.0 |
| 2010-02-18 20:00:00 | ES | Futures | 1067.42 | 1067.42 | 1066.45 | 1067.18 | 1473.0 |
| 2010-02-18 20:30:00 | ES | Futures | 1067.18 | 1067.18 | 1064.74 | 1064.99 | 5386.0 |
| 2010-02-18 21:00:00 | ES | Futures | 1064.99 | 1065.96 | 1063.53 | 1065.23 | 11445.0 |
| 2010-02-18 21:30:00 | ES | Futures | 1065.23 | 1065.47 | 1063.28 | 1063.77 | 4703.0 |
| 2010-02-18 22:00:00 | ES | Futures | 1063.77 | 1064.26 | 1063.28 | 1063.53 | 4048.0 |
| 2010-02-18 22:30:00 | ES | Futures | 1063.28 | 1064.74 | 1063.28 | 1063.77 | 3848.0 |
| 2010-02-18 23:00:00 | ES | Futures | 1063.77 | 1064.99 | 1063.53 | 1064.74 | 3112.0 |
| 2010-02-18 23:30:00 | ES | Futures | 1064.5 | 1065.96 | 1064.01 | 1065.23 | 3527.0 |
| 2010-02-18 00:00:00 | NQ | Futures | 2067.38 | 2067.38 | 2066.53 | 2067.38 | 54.0 |
| 2010-02-18 00:30:00 | NQ | Futures | 2067.1 | 2068.24 | 2067.1 | 2067.67 | 35.0 |
| 2010-02-18 01:00:00 | NQ | Futures | 2067.67 | 2068.53 | 2066.81 | 2067.95 | 44.0 |
> showing 50 of 2,544 rows — these rows as CSV