PREVIEW / futures_1hour / 2010-10-14
file: by_date/futures_1hour/2010/2010-10-14.parquet size: 48 KB rows: 1,460
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-14 00:00:00 | ES | Futures | 1161.65 | 1162.64 | 1160.67 | 1161.41 | 7472.0 |
| 2010-10-14 01:00:00 | ES | Futures | 1161.41 | 1162.64 | 1160.92 | 1161.65 | 4588.0 |
| 2010-10-14 02:00:00 | ES | Futures | 1161.65 | 1162.89 | 1161.41 | 1162.15 | 12766.0 |
| 2010-10-14 03:00:00 | ES | Futures | 1162.39 | 1164.12 | 1161.41 | 1163.63 | 43278.0 |
| 2010-10-14 04:00:00 | ES | Futures | 1163.63 | 1164.12 | 1161.41 | 1161.9 | 26144.0 |
| 2010-10-14 05:00:00 | ES | Futures | 1161.9 | 1162.64 | 1159.44 | 1160.42 | 30498.0 |
| 2010-10-14 06:00:00 | ES | Futures | 1160.42 | 1160.92 | 1157.96 | 1160.18 | 33536.0 |
| 2010-10-14 07:00:00 | ES | Futures | 1160.18 | 1161.16 | 1158.45 | 1159.68 | 35689.0 |
| 2010-10-14 08:00:00 | ES | Futures | 1159.68 | 1162.39 | 1158.2 | 1158.7 | 117680.0 |
| 2010-10-14 09:00:00 | ES | Futures | 1158.45 | 1158.7 | 1153.03 | 1154.01 | 386108.0 |
| 2010-10-14 10:00:00 | ES | Futures | 1153.77 | 1158.94 | 1153.52 | 1157.96 | 281587.0 |
| 2010-10-14 11:00:00 | ES | Futures | 1157.71 | 1158.2 | 1150.81 | 1152.54 | 301551.0 |
| 2010-10-14 12:00:00 | ES | Futures | 1152.54 | 1153.77 | 1149.58 | 1151.8 | 184078.0 |
| 2010-10-14 13:00:00 | ES | Futures | 1152.04 | 1152.54 | 1148.1 | 1152.04 | 192516.0 |
| 2010-10-14 14:00:00 | ES | Futures | 1152.04 | 1152.29 | 1146.87 | 1147.36 | 195840.0 |
| 2010-10-14 15:00:00 | ES | Futures | 1147.36 | 1154.26 | 1146.13 | 1154.01 | 347301.0 |
| 2010-10-14 16:00:00 | ES | Futures | 1154.26 | 1159.93 | 1154.01 | 1158.94 | 159698.0 |
| 2010-10-14 17:00:00 | ES | Futures | 1158.94 | 1159.19 | 1157.96 | 1158.2 | 4097.0 |
| 2010-10-14 18:00:00 | ES | Futures | 1158.2 | 1159.19 | 1157.96 | 1158.45 | 4027.0 |
| 2010-10-14 19:00:00 | ES | Futures | 1158.2 | 1158.45 | 1155.0 | 1155.49 | 7590.0 |
| 2010-10-14 20:00:00 | ES | Futures | 1155.25 | 1155.49 | 1154.01 | 1154.75 | 8608.0 |
| 2010-10-14 21:00:00 | ES | Futures | 1155.0 | 1156.73 | 1154.26 | 1154.51 | 7192.0 |
| 2010-10-14 22:00:00 | ES | Futures | 1154.51 | 1157.71 | 1154.51 | 1157.46 | 5820.0 |
| 2010-10-14 23:00:00 | ES | Futures | 1157.46 | 1158.2 | 1156.48 | 1157.22 | 4531.0 |
| 2010-10-14 00:00:00 | NQ | Futures | 2366.66 | 2369.81 | 2365.22 | 2367.23 | 775.0 |
| 2010-10-14 01:00:00 | NQ | Futures | 2367.23 | 2368.95 | 2366.66 | 2367.23 | 165.0 |
| 2010-10-14 02:00:00 | NQ | Futures | 2367.23 | 2370.96 | 2367.23 | 2368.67 | 1152.0 |
| 2010-10-14 03:00:00 | NQ | Futures | 2368.67 | 2371.25 | 2366.37 | 2371.25 | 2248.0 |
| 2010-10-14 04:00:00 | NQ | Futures | 2370.96 | 2372.4 | 2366.37 | 2366.95 | 2051.0 |
| 2010-10-14 05:00:00 | NQ | Futures | 2366.66 | 2368.95 | 2362.64 | 2363.5 | 2014.0 |
| 2010-10-14 06:00:00 | NQ | Futures | 2363.5 | 2365.22 | 2359.77 | 2363.79 | 1620.0 |
| 2010-10-14 07:00:00 | NQ | Futures | 2364.08 | 2366.66 | 2361.49 | 2364.36 | 2445.0 |
| 2010-10-14 08:00:00 | NQ | Futures | 2364.36 | 2367.23 | 2360.06 | 2362.36 | 7820.0 |
| 2010-10-14 09:00:00 | NQ | Futures | 2362.07 | 2362.64 | 2350.88 | 2352.6 | 54684.0 |
| 2010-10-14 10:00:00 | NQ | Futures | 2352.6 | 2364.65 | 2352.03 | 2362.64 | 41419.0 |
| 2010-10-14 11:00:00 | NQ | Futures | 2362.93 | 2363.22 | 2350.59 | 2354.04 | 41057.0 |
| 2010-10-14 12:00:00 | NQ | Futures | 2354.32 | 2357.19 | 2348.58 | 2354.32 | 26058.0 |
| 2010-10-14 13:00:00 | NQ | Futures | 2354.32 | 2355.47 | 2346.0 | 2354.32 | 30068.0 |
| 2010-10-14 14:00:00 | NQ | Futures | 2354.32 | 2354.32 | 2343.42 | 2344.57 | 26835.0 |
| 2010-10-14 15:00:00 | NQ | Futures | 2344.28 | 2354.9 | 2342.56 | 2354.61 | 43932.0 |
| 2010-10-14 16:00:00 | NQ | Futures | 2354.61 | 2376.7 | 2352.03 | 2376.7 | 30900.0 |
| 2010-10-14 17:00:00 | NQ | Futures | 2376.41 | 2377.27 | 2374.69 | 2376.13 | 1472.0 |
| 2010-10-14 18:00:00 | NQ | Futures | 2376.13 | 2377.27 | 2375.27 | 2375.84 | 464.0 |
| 2010-10-14 19:00:00 | NQ | Futures | 2375.55 | 2375.84 | 2371.25 | 2372.11 | 740.0 |
| 2010-10-14 20:00:00 | NQ | Futures | 2372.11 | 2372.4 | 2369.24 | 2371.25 | 806.0 |
| 2010-10-14 21:00:00 | NQ | Futures | 2370.96 | 2375.27 | 2370.68 | 2371.54 | 533.0 |
| 2010-10-14 22:00:00 | NQ | Futures | 2371.25 | 2376.41 | 2370.96 | 2375.84 | 707.0 |
| 2010-10-14 23:00:00 | NQ | Futures | 2375.84 | 2376.41 | 2374.12 | 2375.27 | 245.0 |
| 2010-10-14 00:00:00 | YM | Futures | 10554.4 | 10559.2 | 10544.9 | 10549.7 | 223.0 |
| 2010-10-14 01:00:00 | YM | Futures | 10550.6 | 10562.0 | 10547.7 | 10552.5 | 256.0 |
> showing 50 of 1,460 rows — these rows as CSV