PREVIEW / futures_30min / 2008-09-18
file: by_date/futures_30min/2008/2008-09-18.parquet size: 76 KB rows: 2,339
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-18 00:00:00 | ES | Futures | 1102.79 | 1104.21 | 1101.13 | 1102.55 | 3143.0 |
| 2008-09-18 00:30:00 | ES | Futures | 1102.79 | 1105.63 | 1102.31 | 1105.63 | 1049.0 |
| 2008-09-18 01:00:00 | ES | Futures | 1105.63 | 1106.57 | 1105.15 | 1106.34 | 1534.0 |
| 2008-09-18 01:30:00 | ES | Futures | 1106.1 | 1107.52 | 1103.73 | 1107.28 | 3615.0 |
| 2008-09-18 02:00:00 | ES | Futures | 1107.28 | 1108.94 | 1105.86 | 1108.47 | 7382.0 |
| 2008-09-18 02:30:00 | ES | Futures | 1108.7 | 1109.41 | 1102.31 | 1104.68 | 8809.0 |
| 2008-09-18 03:00:00 | ES | Futures | 1104.92 | 1117.93 | 1103.26 | 1106.34 | 45269.0 |
| 2008-09-18 03:30:00 | ES | Futures | 1106.1 | 1117.93 | 1105.39 | 1116.99 | 44459.0 |
| 2008-09-18 04:00:00 | ES | Futures | 1116.51 | 1118.17 | 1111.07 | 1116.51 | 28452.0 |
| 2008-09-18 04:30:00 | ES | Futures | 1116.51 | 1118.17 | 1112.96 | 1116.04 | 17931.0 |
| 2008-09-18 05:00:00 | ES | Futures | 1115.8 | 1116.28 | 1111.54 | 1114.38 | 18901.0 |
| 2008-09-18 05:30:00 | ES | Futures | 1114.38 | 1116.28 | 1113.2 | 1114.15 | 11598.0 |
| 2008-09-18 06:00:00 | ES | Futures | 1113.91 | 1117.46 | 1111.07 | 1116.28 | 17198.0 |
| 2008-09-18 06:30:00 | ES | Futures | 1116.28 | 1119.35 | 1112.02 | 1118.41 | 19145.0 |
| 2008-09-18 07:00:00 | ES | Futures | 1118.64 | 1119.59 | 1114.15 | 1115.8 | 24390.0 |
| 2008-09-18 07:30:00 | ES | Futures | 1116.04 | 1116.28 | 1112.49 | 1113.67 | 18143.0 |
| 2008-09-18 08:00:00 | ES | Futures | 1113.67 | 1115.09 | 1104.21 | 1110.6 | 65956.0 |
| 2008-09-18 08:30:00 | ES | Futures | 1110.6 | 1113.67 | 1107.28 | 1108.94 | 56488.0 |
| 2008-09-18 09:00:00 | ES | Futures | 1108.94 | 1116.04 | 1105.39 | 1114.38 | 72992.0 |
| 2008-09-18 09:30:00 | ES | Futures | 1114.62 | 1120.77 | 1107.76 | 1118.88 | 462995.0 |
| 2008-09-18 10:00:00 | ES | Futures | 1119.12 | 1124.09 | 1112.25 | 1117.46 | 303932.0 |
| 2008-09-18 10:30:00 | ES | Futures | 1117.7 | 1118.17 | 1104.44 | 1105.15 | 228337.0 |
| 2008-09-18 11:00:00 | ES | Futures | 1105.15 | 1107.28 | 1095.45 | 1099.71 | 318114.0 |
| 2008-09-18 11:30:00 | ES | Futures | 1099.95 | 1105.39 | 1090.48 | 1099.24 | 298244.0 |
| 2008-09-18 12:00:00 | ES | Futures | 1099.24 | 1100.42 | 1090.95 | 1094.98 | 251991.0 |
| 2008-09-18 12:30:00 | ES | Futures | 1094.98 | 1095.21 | 1075.57 | 1076.05 | 391130.0 |
| 2008-09-18 13:00:00 | ES | Futures | 1075.81 | 1100.42 | 1075.81 | 1097.34 | 446005.0 |
| 2008-09-18 13:30:00 | ES | Futures | 1097.58 | 1115.57 | 1097.34 | 1109.41 | 378487.0 |
| 2008-09-18 14:00:00 | ES | Futures | 1109.41 | 1111.07 | 1096.63 | 1101.13 | 287900.0 |
| 2008-09-18 14:30:00 | ES | Futures | 1101.13 | 1111.78 | 1095.92 | 1109.89 | 295152.0 |
| 2008-09-18 15:00:00 | ES | Futures | 1109.89 | 1145.62 | 1108.7 | 1138.99 | 669492.0 |
| 2008-09-18 15:30:00 | ES | Futures | 1138.99 | 1153.67 | 1136.86 | 1141.6 | 523939.0 |
| 2008-09-18 16:00:00 | ES | Futures | 1141.36 | 1143.49 | 1137.81 | 1139.94 | 194824.0 |
| 2008-09-18 16:30:00 | ES | Futures | 1138.99 | 1142.07 | 1138.28 | 1139.23 | 23351.0 |
| 2008-09-18 17:00:00 | ES | Futures | 1139.47 | 1141.12 | 1138.99 | 1140.89 | 6106.0 |
| 2008-09-18 18:00:00 | ES | Futures | 1141.6 | 1146.8 | 1139.94 | 1145.38 | 21499.0 |
| 2008-09-18 18:30:00 | ES | Futures | 1145.38 | 1155.56 | 1145.38 | 1154.14 | 18238.0 |
| 2008-09-18 19:00:00 | ES | Futures | 1154.14 | 1155.56 | 1152.01 | 1152.48 | 10116.0 |
| 2008-09-18 19:30:00 | ES | Futures | 1152.48 | 1166.92 | 1151.77 | 1163.61 | 30807.0 |
| 2008-09-18 20:00:00 | ES | Futures | 1163.61 | 1166.45 | 1156.51 | 1165.97 | 23455.0 |
| 2008-09-18 20:30:00 | ES | Futures | 1166.21 | 1174.26 | 1164.32 | 1171.42 | 36181.0 |
| 2008-09-18 21:00:00 | ES | Futures | 1171.18 | 1171.65 | 1167.39 | 1169.52 | 17059.0 |
| 2008-09-18 21:30:00 | ES | Futures | 1169.76 | 1173.55 | 1169.05 | 1170.0 | 16209.0 |
| 2008-09-18 22:00:00 | ES | Futures | 1169.52 | 1170.0 | 1164.32 | 1165.26 | 12000.0 |
| 2008-09-18 22:30:00 | ES | Futures | 1165.03 | 1167.16 | 1163.37 | 1164.32 | 7914.0 |
| 2008-09-18 23:00:00 | ES | Futures | 1164.08 | 1166.21 | 1163.84 | 1164.32 | 2137.0 |
| 2008-09-18 23:30:00 | ES | Futures | 1164.08 | 1168.58 | 1163.84 | 1167.87 | 4280.0 |
| 2008-09-18 00:00:00 | NQ | Futures | 1863.03 | 1865.29 | 1860.48 | 1861.9 | 114.0 |
| 2008-09-18 00:30:00 | NQ | Futures | 1863.88 | 1867.56 | 1862.18 | 1867.56 | 170.0 |
| 2008-09-18 01:00:00 | NQ | Futures | 1867.56 | 1867.84 | 1866.43 | 1867.84 | 280.0 |
> showing 50 of 2,339 rows — these rows as CSV