PREVIEW / futures_30min / 2008-09-04
file: by_date/futures_30min/2008/2008-09-04.parquet size: 72 KB rows: 2,290
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-04 00:00:00 | ES | Futures | 1185.09 | 1185.09 | 1184.39 | 1185.09 | 556.0 |
| 2008-09-04 00:30:00 | ES | Futures | 1185.09 | 1185.55 | 1184.16 | 1184.62 | 515.0 |
| 2008-09-04 01:00:00 | ES | Futures | 1184.85 | 1185.55 | 1184.39 | 1184.85 | 805.0 |
| 2008-09-04 01:30:00 | ES | Futures | 1185.09 | 1185.09 | 1183.92 | 1184.16 | 356.0 |
| 2008-09-04 02:00:00 | ES | Futures | 1184.39 | 1185.32 | 1183.46 | 1185.32 | 1531.0 |
| 2008-09-04 02:30:00 | ES | Futures | 1185.55 | 1185.55 | 1183.46 | 1184.85 | 1677.0 |
| 2008-09-04 03:00:00 | ES | Futures | 1184.85 | 1187.18 | 1182.99 | 1183.46 | 8585.0 |
| 2008-09-04 03:30:00 | ES | Futures | 1183.46 | 1184.16 | 1182.06 | 1183.69 | 6934.0 |
| 2008-09-04 04:00:00 | ES | Futures | 1183.69 | 1184.39 | 1182.76 | 1183.23 | 3150.0 |
| 2008-09-04 04:30:00 | ES | Futures | 1182.99 | 1182.99 | 1180.21 | 1180.44 | 9100.0 |
| 2008-09-04 05:00:00 | ES | Futures | 1180.44 | 1181.13 | 1178.81 | 1180.21 | 9320.0 |
| 2008-09-04 05:30:00 | ES | Futures | 1179.97 | 1180.67 | 1179.74 | 1180.21 | 2918.0 |
| 2008-09-04 06:00:00 | ES | Futures | 1180.21 | 1181.13 | 1179.28 | 1180.9 | 3597.0 |
| 2008-09-04 06:30:00 | ES | Futures | 1180.9 | 1183.69 | 1180.21 | 1183.23 | 6387.0 |
| 2008-09-04 07:00:00 | ES | Futures | 1183.23 | 1183.46 | 1180.44 | 1182.3 | 10679.0 |
| 2008-09-04 07:30:00 | ES | Futures | 1182.3 | 1183.46 | 1180.67 | 1182.53 | 10076.0 |
| 2008-09-04 08:00:00 | ES | Futures | 1182.53 | 1182.76 | 1179.28 | 1180.9 | 23417.0 |
| 2008-09-04 08:30:00 | ES | Futures | 1180.67 | 1182.99 | 1177.65 | 1179.51 | 33135.0 |
| 2008-09-04 09:00:00 | ES | Futures | 1179.51 | 1179.97 | 1175.32 | 1176.49 | 43437.0 |
| 2008-09-04 09:30:00 | ES | Futures | 1176.25 | 1178.58 | 1172.77 | 1175.09 | 213357.0 |
| 2008-09-04 10:00:00 | ES | Futures | 1175.09 | 1179.04 | 1174.16 | 1175.09 | 213233.0 |
| 2008-09-04 10:30:00 | ES | Futures | 1175.32 | 1175.32 | 1163.47 | 1165.8 | 344208.0 |
| 2008-09-04 11:00:00 | ES | Futures | 1165.56 | 1166.96 | 1159.99 | 1161.38 | 241843.0 |
| 2008-09-04 11:30:00 | ES | Futures | 1161.61 | 1164.63 | 1160.91 | 1161.61 | 142612.0 |
| 2008-09-04 12:00:00 | ES | Futures | 1161.61 | 1164.4 | 1161.61 | 1161.84 | 78848.0 |
| 2008-09-04 12:30:00 | ES | Futures | 1162.08 | 1162.54 | 1158.36 | 1159.29 | 112789.0 |
| 2008-09-04 13:00:00 | ES | Futures | 1159.29 | 1159.99 | 1154.17 | 1154.87 | 159669.0 |
| 2008-09-04 13:30:00 | ES | Futures | 1154.87 | 1157.2 | 1153.94 | 1156.73 | 111942.0 |
| 2008-09-04 14:00:00 | ES | Futures | 1156.73 | 1156.73 | 1149.53 | 1153.48 | 195868.0 |
| 2008-09-04 14:30:00 | ES | Futures | 1153.48 | 1154.41 | 1150.92 | 1154.17 | 145501.0 |
| 2008-09-04 15:00:00 | ES | Futures | 1154.41 | 1158.13 | 1153.01 | 1155.1 | 194405.0 |
| 2008-09-04 15:30:00 | ES | Futures | 1154.87 | 1156.03 | 1148.6 | 1149.76 | 334727.0 |
| 2008-09-04 16:00:00 | ES | Futures | 1149.76 | 1150.22 | 1148.13 | 1149.29 | 130414.0 |
| 2008-09-04 16:30:00 | ES | Futures | 1149.53 | 1150.46 | 1149.06 | 1150.22 | 6140.0 |
| 2008-09-04 17:00:00 | ES | Futures | 1150.22 | 1150.69 | 1148.6 | 1149.06 | 2945.0 |
| 2008-09-04 18:00:00 | ES | Futures | 1148.83 | 1149.06 | 1141.86 | 1143.02 | 14342.0 |
| 2008-09-04 18:30:00 | ES | Futures | 1143.02 | 1143.02 | 1139.76 | 1142.09 | 5897.0 |
| 2008-09-04 19:00:00 | ES | Futures | 1142.09 | 1144.18 | 1142.09 | 1143.72 | 2974.0 |
| 2008-09-04 19:30:00 | ES | Futures | 1143.95 | 1145.11 | 1142.55 | 1144.41 | 2461.0 |
| 2008-09-04 20:00:00 | ES | Futures | 1144.18 | 1144.41 | 1143.02 | 1143.48 | 1661.0 |
| 2008-09-04 20:30:00 | ES | Futures | 1143.48 | 1144.65 | 1143.25 | 1143.95 | 1629.0 |
| 2008-09-04 21:00:00 | ES | Futures | 1143.95 | 1146.74 | 1143.95 | 1146.27 | 2013.0 |
| 2008-09-04 21:30:00 | ES | Futures | 1146.04 | 1146.74 | 1145.11 | 1145.58 | 2150.0 |
| 2008-09-04 22:00:00 | ES | Futures | 1145.81 | 1147.43 | 1145.81 | 1146.97 | 1622.0 |
| 2008-09-04 22:30:00 | ES | Futures | 1146.74 | 1146.97 | 1146.04 | 1146.04 | 474.0 |
| 2008-09-04 23:00:00 | ES | Futures | 1146.04 | 1146.5 | 1145.34 | 1146.5 | 493.0 |
| 2008-09-04 23:30:00 | ES | Futures | 1146.27 | 1147.67 | 1145.81 | 1146.04 | 1220.0 |
| 2008-09-04 00:00:00 | NQ | Futures | 2061.57 | 2062.69 | 2061.28 | 2061.28 | 13.0 |
| 2008-09-04 00:30:00 | NQ | Futures | 2062.41 | 2063.25 | 2061.28 | 2061.28 | 46.0 |
| 2008-09-04 01:00:00 | NQ | Futures | 2061.28 | 2062.41 | 2061.0 | 2061.0 | 32.0 |
> showing 50 of 2,290 rows — these rows as CSV