PREVIEW / futures_1hour / 2010-10-22
file: by_date/futures_1hour/2010/2010-10-22.parquet size: 39 KB rows: 1,141
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-10-22 00:00:00 | ES | Futures | 1159.93 | 1161.9 | 1159.93 | 1161.41 | 2403.0 |
| 2010-10-22 01:00:00 | ES | Futures | 1161.65 | 1162.39 | 1161.41 | 1161.9 | 3744.0 |
| 2010-10-22 02:00:00 | ES | Futures | 1161.9 | 1162.15 | 1160.42 | 1160.92 | 7439.0 |
| 2010-10-22 03:00:00 | ES | Futures | 1160.67 | 1161.41 | 1157.71 | 1158.94 | 31915.0 |
| 2010-10-22 04:00:00 | ES | Futures | 1159.19 | 1160.18 | 1156.73 | 1157.71 | 25690.0 |
| 2010-10-22 05:00:00 | ES | Futures | 1157.71 | 1158.7 | 1157.46 | 1158.2 | 9590.0 |
| 2010-10-22 06:00:00 | ES | Futures | 1158.2 | 1160.42 | 1157.71 | 1160.18 | 11256.0 |
| 2010-10-22 07:00:00 | ES | Futures | 1160.18 | 1162.89 | 1159.44 | 1162.39 | 29068.0 |
| 2010-10-22 08:00:00 | ES | Futures | 1162.64 | 1163.63 | 1160.92 | 1163.38 | 44342.0 |
| 2010-10-22 09:00:00 | ES | Futures | 1163.38 | 1164.37 | 1159.44 | 1159.93 | 233583.0 |
| 2010-10-22 10:00:00 | ES | Futures | 1159.93 | 1162.89 | 1158.94 | 1162.15 | 215797.0 |
| 2010-10-22 11:00:00 | ES | Futures | 1161.9 | 1162.64 | 1159.68 | 1160.18 | 125553.0 |
| 2010-10-22 12:00:00 | ES | Futures | 1160.18 | 1162.39 | 1159.93 | 1161.65 | 71445.0 |
| 2010-10-22 13:00:00 | ES | Futures | 1161.65 | 1162.39 | 1159.68 | 1159.93 | 60466.0 |
| 2010-10-22 14:00:00 | ES | Futures | 1159.93 | 1162.15 | 1159.68 | 1160.92 | 75523.0 |
| 2010-10-22 15:00:00 | ES | Futures | 1160.92 | 1163.13 | 1160.18 | 1162.64 | 156987.0 |
| 2010-10-22 16:00:00 | ES | Futures | 1162.39 | 1164.86 | 1162.39 | 1164.61 | 72750.0 |
| 2010-10-22 00:00:00 | NQ | Futures | 2391.33 | 2393.34 | 2390.76 | 2393.34 | 193.0 |
| 2010-10-22 01:00:00 | NQ | Futures | 2393.34 | 2395.06 | 2393.34 | 2394.78 | 204.0 |
| 2010-10-22 02:00:00 | NQ | Futures | 2394.2 | 2394.78 | 2391.33 | 2392.19 | 320.0 |
| 2010-10-22 03:00:00 | NQ | Futures | 2391.91 | 2393.34 | 2385.02 | 2387.6 | 2214.0 |
| 2010-10-22 04:00:00 | NQ | Futures | 2387.89 | 2389.32 | 2383.59 | 2385.31 | 1957.0 |
| 2010-10-22 05:00:00 | NQ | Futures | 2385.59 | 2387.89 | 2385.59 | 2386.74 | 757.0 |
| 2010-10-22 06:00:00 | NQ | Futures | 2387.03 | 2391.05 | 2386.46 | 2390.47 | 1085.0 |
| 2010-10-22 07:00:00 | NQ | Futures | 2390.76 | 2397.07 | 2389.61 | 2395.92 | 3079.0 |
| 2010-10-22 08:00:00 | NQ | Futures | 2396.21 | 2399.65 | 2393.91 | 2399.37 | 4848.0 |
| 2010-10-22 09:00:00 | NQ | Futures | 2399.08 | 2406.25 | 2391.33 | 2399.65 | 39383.0 |
| 2010-10-22 10:00:00 | NQ | Futures | 2399.37 | 2406.83 | 2394.78 | 2405.39 | 36558.0 |
| 2010-10-22 11:00:00 | NQ | Futures | 2405.68 | 2409.69 | 2403.1 | 2405.39 | 25775.0 |
| 2010-10-22 12:00:00 | NQ | Futures | 2405.39 | 2412.56 | 2405.1 | 2410.27 | 20363.0 |
| 2010-10-22 13:00:00 | NQ | Futures | 2410.55 | 2412.56 | 2406.25 | 2406.83 | 13165.0 |
| 2010-10-22 14:00:00 | NQ | Futures | 2406.83 | 2414.0 | 2405.96 | 2409.98 | 15468.0 |
| 2010-10-22 15:00:00 | NQ | Futures | 2409.98 | 2414.0 | 2407.11 | 2411.42 | 29397.0 |
| 2010-10-22 16:00:00 | NQ | Futures | 2411.7 | 2415.15 | 2411.13 | 2415.15 | 8956.0 |
| 2010-10-22 00:00:00 | YM | Futures | 10568.7 | 10581.1 | 10565.8 | 10579.2 | 116.0 |
| 2010-10-22 01:00:00 | YM | Futures | 10581.1 | 10585.9 | 10574.4 | 10583.0 | 177.0 |
| 2010-10-22 02:00:00 | YM | Futures | 10581.1 | 10581.1 | 10569.7 | 10571.6 | 261.0 |
| 2010-10-22 03:00:00 | YM | Futures | 10570.6 | 10578.2 | 10550.6 | 10562.0 | 1313.0 |
| 2010-10-22 04:00:00 | YM | Futures | 10563.0 | 10569.7 | 10543.0 | 10548.7 | 1188.0 |
| 2010-10-22 05:00:00 | YM | Futures | 10547.7 | 10554.4 | 10546.8 | 10549.7 | 546.0 |
| 2010-10-22 06:00:00 | YM | Futures | 10549.7 | 10566.8 | 10548.7 | 10564.9 | 471.0 |
| 2010-10-22 07:00:00 | YM | Futures | 10564.9 | 10585.9 | 10562.0 | 10583.9 | 983.0 |
| 2010-10-22 08:00:00 | YM | Futures | 10584.9 | 10586.8 | 10572.5 | 10585.9 | 1955.0 |
| 2010-10-22 09:00:00 | YM | Futures | 10586.8 | 10595.4 | 10543.9 | 10547.7 | 15129.0 |
| 2010-10-22 10:00:00 | YM | Futures | 10547.7 | 10567.8 | 10539.2 | 10560.1 | 13524.0 |
| 2010-10-22 11:00:00 | YM | Futures | 10560.1 | 10565.8 | 10537.3 | 10540.1 | 8658.0 |
| 2010-10-22 12:00:00 | YM | Futures | 10539.2 | 10558.2 | 10539.2 | 10549.7 | 4802.0 |
| 2010-10-22 13:00:00 | YM | Futures | 10550.6 | 10554.4 | 10535.4 | 10537.3 | 4183.0 |
| 2010-10-22 14:00:00 | YM | Futures | 10537.3 | 10550.6 | 10535.4 | 10541.1 | 5896.0 |
| 2010-10-22 15:00:00 | YM | Futures | 10541.1 | 10558.2 | 10537.3 | 10555.4 | 10219.0 |
> showing 50 of 1,141 rows — these rows as CSV