PREVIEW / futures_30min / 2010-04-16
file: by_date/futures_30min/2010/2010-04-16.parquet size: 61 KB rows: 2,082
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-16 00:00:00 | ES | Futures | 1174.96 | 1175.93 | 1174.96 | 1175.69 | 1575.0 |
| 2010-04-16 00:30:00 | ES | Futures | 1175.69 | 1176.18 | 1175.45 | 1175.69 | 1434.0 |
| 2010-04-16 01:00:00 | ES | Futures | 1175.69 | 1175.93 | 1175.2 | 1175.69 | 1101.0 |
| 2010-04-16 01:30:00 | ES | Futures | 1175.69 | 1176.18 | 1175.69 | 1175.69 | 1435.0 |
| 2010-04-16 02:00:00 | ES | Futures | 1175.93 | 1176.42 | 1175.45 | 1175.93 | 5022.0 |
| 2010-04-16 02:30:00 | ES | Futures | 1175.93 | 1176.18 | 1174.96 | 1175.45 | 4512.0 |
| 2010-04-16 03:00:00 | ES | Futures | 1175.45 | 1177.16 | 1174.96 | 1176.67 | 9022.0 |
| 2010-04-16 03:30:00 | ES | Futures | 1176.42 | 1177.16 | 1176.18 | 1176.91 | 7150.0 |
| 2010-04-16 04:00:00 | ES | Futures | 1177.16 | 1177.65 | 1176.67 | 1177.65 | 6213.0 |
| 2010-04-16 04:30:00 | ES | Futures | 1177.4 | 1179.36 | 1177.4 | 1179.11 | 10113.0 |
| 2010-04-16 05:00:00 | ES | Futures | 1179.11 | 1179.6 | 1178.87 | 1178.87 | 7356.0 |
| 2010-04-16 05:30:00 | ES | Futures | 1178.87 | 1180.09 | 1178.62 | 1179.6 | 7256.0 |
| 2010-04-16 06:00:00 | ES | Futures | 1179.6 | 1179.85 | 1177.65 | 1177.89 | 7913.0 |
| 2010-04-16 06:30:00 | ES | Futures | 1177.89 | 1179.11 | 1177.65 | 1178.38 | 17146.0 |
| 2010-04-16 07:00:00 | ES | Futures | 1178.62 | 1180.58 | 1178.13 | 1179.6 | 21716.0 |
| 2010-04-16 07:30:00 | ES | Futures | 1179.6 | 1179.6 | 1178.38 | 1179.11 | 18590.0 |
| 2010-04-16 08:00:00 | ES | Futures | 1178.87 | 1179.6 | 1178.38 | 1179.11 | 14035.0 |
| 2010-04-16 08:30:00 | ES | Futures | 1179.11 | 1179.6 | 1176.67 | 1177.4 | 41696.0 |
| 2010-04-16 09:00:00 | ES | Futures | 1177.4 | 1177.65 | 1175.2 | 1176.91 | 68956.0 |
| 2010-04-16 09:30:00 | ES | Futures | 1177.16 | 1179.11 | 1173.25 | 1173.73 | 276439.0 |
| 2010-04-16 10:00:00 | ES | Futures | 1173.98 | 1179.11 | 1173.49 | 1177.4 | 202435.0 |
| 2010-04-16 10:30:00 | ES | Futures | 1177.65 | 1178.62 | 1165.91 | 1168.85 | 532916.0 |
| 2010-04-16 11:00:00 | ES | Futures | 1169.09 | 1171.05 | 1159.31 | 1162.74 | 445518.0 |
| 2010-04-16 11:30:00 | ES | Futures | 1162.74 | 1164.45 | 1159.56 | 1161.02 | 329242.0 |
| 2010-04-16 12:00:00 | ES | Futures | 1161.27 | 1161.51 | 1158.09 | 1160.29 | 197501.0 |
| 2010-04-16 12:30:00 | ES | Futures | 1160.05 | 1162.0 | 1156.38 | 1161.51 | 206711.0 |
| 2010-04-16 13:00:00 | ES | Futures | 1161.51 | 1162.98 | 1160.29 | 1160.78 | 125395.0 |
| 2010-04-16 13:30:00 | ES | Futures | 1160.78 | 1162.25 | 1159.8 | 1161.76 | 92455.0 |
| 2010-04-16 14:00:00 | ES | Futures | 1162.0 | 1166.89 | 1161.51 | 1165.91 | 171132.0 |
| 2010-04-16 14:30:00 | ES | Futures | 1165.91 | 1166.65 | 1162.49 | 1162.74 | 111584.0 |
| 2010-04-16 15:00:00 | ES | Futures | 1162.98 | 1164.45 | 1161.76 | 1163.22 | 143500.0 |
| 2010-04-16 15:30:00 | ES | Futures | 1163.22 | 1166.89 | 1161.51 | 1162.25 | 291993.0 |
| 2010-04-16 16:00:00 | ES | Futures | 1162.25 | 1164.94 | 1162.25 | 1163.22 | 142738.0 |
| 2010-04-16 00:00:00 | NQ | Futures | 2319.62 | 2320.48 | 2319.05 | 2320.19 | 156.0 |
| 2010-04-16 00:30:00 | NQ | Futures | 2320.48 | 2321.34 | 2320.48 | 2321.05 | 146.0 |
| 2010-04-16 01:00:00 | NQ | Futures | 2320.76 | 2321.62 | 2320.19 | 2321.34 | 67.0 |
| 2010-04-16 01:30:00 | NQ | Futures | 2321.34 | 2322.2 | 2321.05 | 2321.62 | 58.0 |
| 2010-04-16 02:00:00 | NQ | Futures | 2321.34 | 2321.62 | 2320.48 | 2321.62 | 301.0 |
| 2010-04-16 02:30:00 | NQ | Futures | 2321.62 | 2321.62 | 2318.47 | 2319.62 | 767.0 |
| 2010-04-16 03:00:00 | NQ | Futures | 2319.9 | 2323.34 | 2319.33 | 2322.77 | 779.0 |
| 2010-04-16 03:30:00 | NQ | Futures | 2322.48 | 2323.91 | 2322.2 | 2323.34 | 461.0 |
| 2010-04-16 04:00:00 | NQ | Futures | 2323.63 | 2324.49 | 2323.05 | 2324.2 | 411.0 |
| 2010-04-16 04:30:00 | NQ | Futures | 2324.49 | 2326.78 | 2324.49 | 2326.2 | 672.0 |
| 2010-04-16 05:00:00 | NQ | Futures | 2326.49 | 2327.35 | 2325.92 | 2326.2 | 510.0 |
| 2010-04-16 05:30:00 | NQ | Futures | 2325.92 | 2327.92 | 2325.63 | 2327.35 | 429.0 |
| 2010-04-16 06:00:00 | NQ | Futures | 2327.06 | 2327.35 | 2323.63 | 2323.63 | 452.0 |
| 2010-04-16 06:30:00 | NQ | Futures | 2323.91 | 2325.35 | 2323.63 | 2324.77 | 984.0 |
| 2010-04-16 07:00:00 | NQ | Futures | 2325.06 | 2327.35 | 2324.49 | 2325.63 | 2345.0 |
| 2010-04-16 07:30:00 | NQ | Futures | 2325.63 | 2325.63 | 2323.63 | 2325.35 | 921.0 |
| 2010-04-16 08:00:00 | NQ | Futures | 2325.06 | 2325.92 | 2324.77 | 2325.63 | 1010.0 |
> showing 50 of 2,082 rows — these rows as CSV