PREVIEW / futures_1hour / 2010-11-16
file: by_date/futures_1hour/2010/2010-11-16.parquet size: 49 KB rows: 1,444
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-11-16 00:00:00 | ES | Futures | 1176.69 | 1177.68 | 1173.24 | 1174.47 | 9847.0 |
| 2010-11-16 01:00:00 | ES | Futures | 1174.47 | 1174.47 | 1171.76 | 1172.25 | 11935.0 |
| 2010-11-16 02:00:00 | ES | Futures | 1172.25 | 1176.2 | 1171.51 | 1175.46 | 17505.0 |
| 2010-11-16 03:00:00 | ES | Futures | 1175.21 | 1175.7 | 1172.01 | 1172.25 | 36381.0 |
| 2010-11-16 04:00:00 | ES | Futures | 1172.25 | 1173.73 | 1172.01 | 1172.01 | 21817.0 |
| 2010-11-16 05:00:00 | ES | Futures | 1172.25 | 1174.23 | 1171.76 | 1172.25 | 24898.0 |
| 2010-11-16 06:00:00 | ES | Futures | 1172.25 | 1172.5 | 1169.79 | 1170.28 | 43018.0 |
| 2010-11-16 07:00:00 | ES | Futures | 1170.28 | 1173.98 | 1170.04 | 1172.01 | 50978.0 |
| 2010-11-16 08:00:00 | ES | Futures | 1172.25 | 1175.21 | 1172.01 | 1172.25 | 93253.0 |
| 2010-11-16 09:00:00 | ES | Futures | 1172.25 | 1173.73 | 1167.82 | 1169.79 | 328482.0 |
| 2010-11-16 10:00:00 | ES | Futures | 1169.79 | 1172.5 | 1163.87 | 1165.6 | 473395.0 |
| 2010-11-16 11:00:00 | ES | Futures | 1165.85 | 1165.85 | 1155.74 | 1158.94 | 617686.0 |
| 2010-11-16 12:00:00 | ES | Futures | 1159.19 | 1160.92 | 1155.99 | 1159.68 | 307889.0 |
| 2010-11-16 13:00:00 | ES | Futures | 1159.68 | 1162.64 | 1156.97 | 1161.65 | 189020.0 |
| 2010-11-16 14:00:00 | ES | Futures | 1161.65 | 1162.15 | 1155.49 | 1158.45 | 237101.0 |
| 2010-11-16 15:00:00 | ES | Futures | 1158.7 | 1161.41 | 1154.51 | 1159.68 | 499142.0 |
| 2010-11-16 16:00:00 | ES | Futures | 1159.68 | 1160.18 | 1157.71 | 1159.44 | 144459.0 |
| 2010-11-16 17:00:00 | ES | Futures | 1159.44 | 1160.18 | 1159.19 | 1159.93 | 3187.0 |
| 2010-11-16 18:00:00 | ES | Futures | 1160.67 | 1161.65 | 1160.42 | 1161.16 | 11253.0 |
| 2010-11-16 19:00:00 | ES | Futures | 1161.16 | 1162.39 | 1160.92 | 1162.39 | 8043.0 |
| 2010-11-16 20:00:00 | ES | Futures | 1162.15 | 1162.64 | 1160.67 | 1161.65 | 12060.0 |
| 2010-11-16 21:00:00 | ES | Futures | 1161.9 | 1162.89 | 1161.41 | 1162.15 | 8668.0 |
| 2010-11-16 22:00:00 | ES | Futures | 1162.39 | 1162.64 | 1161.65 | 1162.15 | 3919.0 |
| 2010-11-16 23:00:00 | ES | Futures | 1162.15 | 1162.89 | 1161.9 | 1162.64 | 3599.0 |
| 2010-11-16 00:00:00 | NQ | Futures | 2432.93 | 2435.52 | 2426.91 | 2428.34 | 608.0 |
| 2010-11-16 01:00:00 | NQ | Futures | 2428.63 | 2428.92 | 2421.74 | 2422.6 | 1311.0 |
| 2010-11-16 02:00:00 | NQ | Futures | 2423.18 | 2430.64 | 2421.74 | 2428.92 | 1187.0 |
| 2010-11-16 03:00:00 | NQ | Futures | 2428.92 | 2428.92 | 2422.6 | 2423.47 | 3049.0 |
| 2010-11-16 04:00:00 | NQ | Futures | 2423.18 | 2426.05 | 2422.89 | 2422.89 | 1700.0 |
| 2010-11-16 05:00:00 | NQ | Futures | 2423.18 | 2426.62 | 2423.18 | 2423.75 | 2255.0 |
| 2010-11-16 06:00:00 | NQ | Futures | 2423.47 | 2424.33 | 2418.3 | 2419.74 | 3881.0 |
| 2010-11-16 07:00:00 | NQ | Futures | 2420.02 | 2426.05 | 2419.45 | 2422.6 | 2911.0 |
| 2010-11-16 08:00:00 | NQ | Futures | 2422.89 | 2430.35 | 2422.89 | 2424.9 | 8570.0 |
| 2010-11-16 09:00:00 | NQ | Futures | 2424.61 | 2438.1 | 2420.6 | 2429.78 | 59761.0 |
| 2010-11-16 10:00:00 | NQ | Futures | 2430.06 | 2434.94 | 2416.29 | 2419.74 | 68543.0 |
| 2010-11-16 11:00:00 | NQ | Futures | 2419.74 | 2420.02 | 2394.78 | 2402.23 | 80941.0 |
| 2010-11-16 12:00:00 | NQ | Futures | 2402.23 | 2407.97 | 2398.22 | 2406.25 | 34043.0 |
| 2010-11-16 13:00:00 | NQ | Futures | 2405.96 | 2411.7 | 2401.95 | 2410.27 | 23386.0 |
| 2010-11-16 14:00:00 | NQ | Futures | 2410.27 | 2411.7 | 2399.37 | 2403.38 | 29792.0 |
| 2010-11-16 15:00:00 | NQ | Futures | 2403.38 | 2405.39 | 2391.05 | 2400.8 | 64878.0 |
| 2010-11-16 16:00:00 | NQ | Futures | 2400.8 | 2404.82 | 2397.64 | 2403.67 | 13520.0 |
| 2010-11-16 17:00:00 | NQ | Futures | 2403.38 | 2404.82 | 2402.52 | 2404.82 | 415.0 |
| 2010-11-16 18:00:00 | NQ | Futures | 2405.39 | 2407.97 | 2405.39 | 2406.83 | 425.0 |
| 2010-11-16 19:00:00 | NQ | Futures | 2405.96 | 2407.97 | 2405.68 | 2407.97 | 569.0 |
| 2010-11-16 20:00:00 | NQ | Futures | 2407.97 | 2408.55 | 2405.1 | 2407.69 | 588.0 |
| 2010-11-16 21:00:00 | NQ | Futures | 2407.69 | 2409.12 | 2406.54 | 2408.26 | 482.0 |
| 2010-11-16 22:00:00 | NQ | Futures | 2407.97 | 2409.41 | 2405.96 | 2406.83 | 399.0 |
| 2010-11-16 23:00:00 | NQ | Futures | 2407.11 | 2409.41 | 2407.11 | 2409.12 | 183.0 |
| 2010-11-16 00:00:00 | YM | Futures | 10622.0 | 10628.7 | 10592.5 | 10600.1 | 577.0 |
| 2010-11-16 01:00:00 | YM | Futures | 10599.2 | 10601.1 | 10584.9 | 10585.9 | 736.0 |
> showing 50 of 1,444 rows — these rows as CSV