PREVIEW / futures_30min / 2010-04-29
file: by_date/futures_30min/2010/2010-04-29.parquet size: 70 KB rows: 2,528
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-04-29 00:00:00 | ES | Futures | 1162.74 | 1162.98 | 1162.25 | 1162.74 | 303.0 |
| 2010-04-29 00:30:00 | ES | Futures | 1162.49 | 1162.98 | 1162.25 | 1162.74 | 618.0 |
| 2010-04-29 01:00:00 | ES | Futures | 1162.49 | 1162.98 | 1162.49 | 1162.74 | 750.0 |
| 2010-04-29 01:30:00 | ES | Futures | 1162.74 | 1162.98 | 1162.0 | 1162.49 | 1253.0 |
| 2010-04-29 02:00:00 | ES | Futures | 1162.25 | 1164.94 | 1161.51 | 1164.45 | 7817.0 |
| 2010-04-29 02:30:00 | ES | Futures | 1164.45 | 1166.4 | 1164.45 | 1165.42 | 7388.0 |
| 2010-04-29 03:00:00 | ES | Futures | 1165.42 | 1165.67 | 1162.98 | 1163.96 | 24621.0 |
| 2010-04-29 03:30:00 | ES | Futures | 1163.96 | 1165.91 | 1163.47 | 1164.45 | 21623.0 |
| 2010-04-29 04:00:00 | ES | Futures | 1164.2 | 1167.87 | 1163.96 | 1167.38 | 24611.0 |
| 2010-04-29 04:30:00 | ES | Futures | 1167.14 | 1168.11 | 1166.4 | 1166.65 | 12401.0 |
| 2010-04-29 05:00:00 | ES | Futures | 1166.89 | 1168.6 | 1165.67 | 1166.65 | 15507.0 |
| 2010-04-29 05:30:00 | ES | Futures | 1166.4 | 1169.09 | 1166.4 | 1168.6 | 10791.0 |
| 2010-04-29 06:00:00 | ES | Futures | 1168.6 | 1170.8 | 1168.36 | 1170.31 | 22858.0 |
| 2010-04-29 06:30:00 | ES | Futures | 1170.31 | 1170.31 | 1168.85 | 1169.34 | 12765.0 |
| 2010-04-29 07:00:00 | ES | Futures | 1169.09 | 1170.07 | 1168.6 | 1168.85 | 10734.0 |
| 2010-04-29 07:30:00 | ES | Futures | 1168.85 | 1170.31 | 1168.85 | 1170.07 | 16397.0 |
| 2010-04-29 08:00:00 | ES | Futures | 1170.07 | 1171.78 | 1169.34 | 1171.54 | 39711.0 |
| 2010-04-29 08:30:00 | ES | Futures | 1171.54 | 1171.54 | 1169.82 | 1170.31 | 33623.0 |
| 2010-04-29 09:00:00 | ES | Futures | 1170.31 | 1171.05 | 1169.34 | 1169.34 | 34834.0 |
| 2010-04-29 09:30:00 | ES | Futures | 1169.34 | 1172.76 | 1169.09 | 1170.31 | 245644.0 |
| 2010-04-29 10:00:00 | ES | Futures | 1170.07 | 1174.47 | 1169.34 | 1173.98 | 174402.0 |
| 2010-04-29 10:30:00 | ES | Futures | 1174.22 | 1177.65 | 1173.25 | 1176.18 | 163793.0 |
| 2010-04-29 11:00:00 | ES | Futures | 1176.42 | 1176.91 | 1173.0 | 1176.42 | 159280.0 |
| 2010-04-29 11:30:00 | ES | Futures | 1176.18 | 1177.65 | 1175.45 | 1176.67 | 84454.0 |
| 2010-04-29 12:00:00 | ES | Futures | 1176.67 | 1177.89 | 1175.2 | 1176.18 | 76445.0 |
| 2010-04-29 12:30:00 | ES | Futures | 1176.18 | 1178.87 | 1175.45 | 1177.4 | 75446.0 |
| 2010-04-29 13:00:00 | ES | Futures | 1177.16 | 1178.38 | 1176.42 | 1176.67 | 59004.0 |
| 2010-04-29 13:30:00 | ES | Futures | 1176.42 | 1178.62 | 1176.42 | 1178.62 | 35452.0 |
| 2010-04-29 14:00:00 | ES | Futures | 1178.62 | 1179.11 | 1177.65 | 1178.38 | 58159.0 |
| 2010-04-29 14:30:00 | ES | Futures | 1178.38 | 1179.36 | 1175.45 | 1176.18 | 109316.0 |
| 2010-04-29 15:00:00 | ES | Futures | 1176.18 | 1177.4 | 1174.71 | 1177.16 | 96911.0 |
| 2010-04-29 15:30:00 | ES | Futures | 1177.16 | 1177.65 | 1175.69 | 1176.42 | 169710.0 |
| 2010-04-29 16:00:00 | ES | Futures | 1176.42 | 1178.87 | 1175.93 | 1178.62 | 137173.0 |
| 2010-04-29 16:30:00 | ES | Futures | 1178.62 | 1178.87 | 1177.65 | 1177.89 | 5980.0 |
| 2010-04-29 17:00:00 | ES | Futures | 1177.89 | 1179.11 | 1177.89 | 1179.11 | 2860.0 |
| 2010-04-29 18:00:00 | ES | Futures | 1178.87 | 1178.87 | 1178.38 | 1178.62 | 1044.0 |
| 2010-04-29 18:30:00 | ES | Futures | 1178.62 | 1178.87 | 1178.38 | 1178.62 | 1084.0 |
| 2010-04-29 19:00:00 | ES | Futures | 1178.62 | 1178.62 | 1177.4 | 1177.65 | 2879.0 |
| 2010-04-29 19:30:00 | ES | Futures | 1177.65 | 1177.89 | 1175.93 | 1176.42 | 4285.0 |
| 2010-04-29 20:00:00 | ES | Futures | 1176.18 | 1176.67 | 1175.2 | 1175.45 | 4733.0 |
| 2010-04-29 20:30:00 | ES | Futures | 1175.2 | 1175.93 | 1175.2 | 1175.69 | 1839.0 |
| 2010-04-29 21:00:00 | ES | Futures | 1175.69 | 1176.18 | 1175.45 | 1175.69 | 1773.0 |
| 2010-04-29 21:30:00 | ES | Futures | 1175.93 | 1176.42 | 1174.71 | 1175.2 | 2896.0 |
| 2010-04-29 22:00:00 | ES | Futures | 1174.96 | 1175.69 | 1174.71 | 1175.45 | 2366.0 |
| 2010-04-29 22:30:00 | ES | Futures | 1175.45 | 1176.18 | 1174.71 | 1174.96 | 2064.0 |
| 2010-04-29 23:00:00 | ES | Futures | 1174.96 | 1176.18 | 1174.71 | 1175.2 | 2255.0 |
| 2010-04-29 23:30:00 | ES | Futures | 1174.96 | 1177.65 | 1174.96 | 1177.4 | 3957.0 |
| 2010-04-29 00:00:00 | NQ | Futures | 2297.85 | 2298.14 | 2297.57 | 2298.14 | 23.0 |
| 2010-04-29 00:30:00 | NQ | Futures | 2297.85 | 2298.43 | 2297.85 | 2298.14 | 6.0 |
| 2010-04-29 01:00:00 | NQ | Futures | 2297.85 | 2298.14 | 2297.28 | 2298.14 | 50.0 |
> showing 50 of 2,528 rows — these rows as CSV