PREVIEW / futures_30min / 2008-09-09
file: by_date/futures_30min/2008/2008-09-09.parquet size: 71 KB rows: 2,280
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-09 00:00:00 | ES | Futures | 1174.16 | 1174.63 | 1174.16 | 1174.39 | 431.0 |
| 2008-09-09 00:30:00 | ES | Futures | 1174.39 | 1174.63 | 1173.7 | 1173.93 | 852.0 |
| 2008-09-09 01:00:00 | ES | Futures | 1174.16 | 1174.16 | 1173.23 | 1173.93 | 794.0 |
| 2008-09-09 01:30:00 | ES | Futures | 1173.93 | 1173.93 | 1173.0 | 1173.93 | 2464.0 |
| 2008-09-09 02:00:00 | ES | Futures | 1173.7 | 1174.16 | 1172.77 | 1174.16 | 2712.0 |
| 2008-09-09 02:30:00 | ES | Futures | 1174.16 | 1177.65 | 1174.16 | 1176.25 | 4380.0 |
| 2008-09-09 03:00:00 | ES | Futures | 1176.25 | 1178.11 | 1173.93 | 1177.65 | 10389.0 |
| 2008-09-09 03:30:00 | ES | Futures | 1177.65 | 1179.74 | 1176.72 | 1178.58 | 9291.0 |
| 2008-09-09 04:00:00 | ES | Futures | 1178.81 | 1182.53 | 1178.58 | 1181.83 | 14529.0 |
| 2008-09-09 04:30:00 | ES | Futures | 1182.06 | 1182.06 | 1179.97 | 1181.83 | 6336.0 |
| 2008-09-09 05:00:00 | ES | Futures | 1181.83 | 1183.46 | 1180.9 | 1181.13 | 8118.0 |
| 2008-09-09 05:30:00 | ES | Futures | 1181.13 | 1182.3 | 1180.44 | 1181.13 | 3725.0 |
| 2008-09-09 06:00:00 | ES | Futures | 1180.67 | 1183.92 | 1180.67 | 1183.23 | 7209.0 |
| 2008-09-09 06:30:00 | ES | Futures | 1182.99 | 1183.69 | 1181.13 | 1181.37 | 7266.0 |
| 2008-09-09 07:00:00 | ES | Futures | 1181.37 | 1185.32 | 1181.13 | 1183.69 | 10899.0 |
| 2008-09-09 07:30:00 | ES | Futures | 1183.46 | 1184.62 | 1182.53 | 1184.16 | 9212.0 |
| 2008-09-09 08:00:00 | ES | Futures | 1184.16 | 1184.39 | 1180.9 | 1181.13 | 23273.0 |
| 2008-09-09 08:30:00 | ES | Futures | 1181.37 | 1181.83 | 1177.42 | 1177.65 | 29968.0 |
| 2008-09-09 09:00:00 | ES | Futures | 1177.65 | 1179.74 | 1176.72 | 1177.88 | 34765.0 |
| 2008-09-09 09:30:00 | ES | Futures | 1177.88 | 1179.74 | 1169.98 | 1179.28 | 346620.0 |
| 2008-09-09 10:00:00 | ES | Futures | 1179.28 | 1180.21 | 1169.51 | 1170.44 | 276193.0 |
| 2008-09-09 10:30:00 | ES | Futures | 1170.44 | 1170.44 | 1160.45 | 1161.84 | 285693.0 |
| 2008-09-09 11:00:00 | ES | Futures | 1161.84 | 1165.8 | 1157.89 | 1165.56 | 232433.0 |
| 2008-09-09 11:30:00 | ES | Futures | 1165.56 | 1166.26 | 1161.15 | 1161.15 | 111597.0 |
| 2008-09-09 12:00:00 | ES | Futures | 1161.38 | 1163.01 | 1158.82 | 1160.68 | 110829.0 |
| 2008-09-09 12:30:00 | ES | Futures | 1160.68 | 1165.8 | 1159.29 | 1162.54 | 112023.0 |
| 2008-09-09 13:00:00 | ES | Futures | 1162.54 | 1166.26 | 1160.22 | 1160.68 | 136883.0 |
| 2008-09-09 13:30:00 | ES | Futures | 1160.68 | 1161.61 | 1154.64 | 1155.8 | 197231.0 |
| 2008-09-09 14:00:00 | ES | Futures | 1155.8 | 1157.2 | 1152.55 | 1154.41 | 189655.0 |
| 2008-09-09 14:30:00 | ES | Futures | 1154.41 | 1154.87 | 1147.9 | 1148.83 | 234861.0 |
| 2008-09-09 15:00:00 | ES | Futures | 1148.83 | 1149.53 | 1145.34 | 1149.29 | 222906.0 |
| 2008-09-09 15:30:00 | ES | Futures | 1149.29 | 1151.62 | 1138.37 | 1138.84 | 371260.0 |
| 2008-09-09 16:00:00 | ES | Futures | 1138.84 | 1142.09 | 1137.44 | 1140.93 | 189272.0 |
| 2008-09-09 16:30:00 | ES | Futures | 1141.62 | 1143.02 | 1138.6 | 1139.07 | 18928.0 |
| 2008-09-09 17:00:00 | ES | Futures | 1139.3 | 1141.86 | 1138.84 | 1140.46 | 4946.0 |
| 2008-09-09 18:00:00 | ES | Futures | 1140.0 | 1141.62 | 1140.0 | 1140.69 | 2711.0 |
| 2008-09-09 18:30:00 | ES | Futures | 1140.93 | 1143.25 | 1140.23 | 1143.02 | 2897.0 |
| 2008-09-09 19:00:00 | ES | Futures | 1143.02 | 1143.95 | 1142.79 | 1143.48 | 3245.0 |
| 2008-09-09 19:30:00 | ES | Futures | 1143.25 | 1143.48 | 1141.39 | 1142.09 | 2584.0 |
| 2008-09-09 20:00:00 | ES | Futures | 1142.32 | 1142.79 | 1141.39 | 1142.09 | 1294.0 |
| 2008-09-09 20:30:00 | ES | Futures | 1142.09 | 1143.25 | 1141.86 | 1143.02 | 2529.0 |
| 2008-09-09 21:00:00 | ES | Futures | 1143.25 | 1144.41 | 1143.02 | 1144.18 | 2626.0 |
| 2008-09-09 21:30:00 | ES | Futures | 1144.18 | 1144.65 | 1143.72 | 1144.41 | 2750.0 |
| 2008-09-09 22:00:00 | ES | Futures | 1144.65 | 1144.88 | 1143.95 | 1144.65 | 1018.0 |
| 2008-09-09 22:30:00 | ES | Futures | 1144.65 | 1145.11 | 1143.95 | 1144.88 | 1363.0 |
| 2008-09-09 23:00:00 | ES | Futures | 1144.88 | 1144.88 | 1144.18 | 1144.18 | 755.0 |
| 2008-09-09 23:30:00 | ES | Futures | 1144.41 | 1145.11 | 1144.18 | 1144.88 | 966.0 |
| 2008-09-09 00:00:00 | NQ | Futures | 1972.68 | 1973.8 | 1972.12 | 1973.8 | 102.0 |
| 2008-09-09 00:30:00 | NQ | Futures | 1973.52 | 1973.52 | 1972.68 | 1972.96 | 34.0 |
| 2008-09-09 01:00:00 | NQ | Futures | 1972.4 | 1972.4 | 1970.15 | 1971.83 | 126.0 |
> showing 50 of 2,280 rows — these rows as CSV