PREVIEW / futures_1hour / 2010-11-11
file: by_date/futures_1hour/2010/2010-11-11.parquet size: 49 KB rows: 1,440
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-11 00:00:00 | ES | Futures | 1193.7 | 1193.94 | 1193.2 | 1193.7 | 1921.0 |
| 2010-11-11 01:00:00 | ES | Futures | 1193.7 | 1194.93 | 1193.45 | 1194.68 | 3101.0 |
| 2010-11-11 02:00:00 | ES | Futures | 1194.68 | 1196.16 | 1193.45 | 1193.7 | 15325.0 |
| 2010-11-11 03:00:00 | ES | Futures | 1193.94 | 1194.44 | 1190.49 | 1191.23 | 40567.0 |
| 2010-11-11 04:00:00 | ES | Futures | 1191.23 | 1193.2 | 1190.0 | 1192.71 | 36391.0 |
| 2010-11-11 05:00:00 | ES | Futures | 1192.96 | 1194.93 | 1191.48 | 1194.44 | 21285.0 |
| 2010-11-11 06:00:00 | ES | Futures | 1194.44 | 1194.68 | 1190.74 | 1191.23 | 20695.0 |
| 2010-11-11 07:00:00 | ES | Futures | 1191.23 | 1192.46 | 1189.01 | 1189.75 | 29461.0 |
| 2010-11-11 08:00:00 | ES | Futures | 1189.51 | 1191.48 | 1188.27 | 1188.52 | 39981.0 |
| 2010-11-11 09:00:00 | ES | Futures | 1188.52 | 1190.25 | 1185.07 | 1188.52 | 272295.0 |
| 2010-11-11 10:00:00 | ES | Futures | 1188.52 | 1192.46 | 1187.04 | 1190.0 | 298780.0 |
| 2010-11-11 11:00:00 | ES | Futures | 1190.25 | 1190.99 | 1187.29 | 1190.25 | 222077.0 |
| 2010-11-11 12:00:00 | ES | Futures | 1190.25 | 1191.97 | 1189.75 | 1190.25 | 113006.0 |
| 2010-11-11 13:00:00 | ES | Futures | 1190.25 | 1193.94 | 1189.26 | 1193.2 | 139220.0 |
| 2010-11-11 14:00:00 | ES | Futures | 1193.2 | 1196.16 | 1192.22 | 1194.19 | 129135.0 |
| 2010-11-11 15:00:00 | ES | Futures | 1193.94 | 1195.18 | 1191.23 | 1194.44 | 222252.0 |
| 2010-11-11 16:00:00 | ES | Futures | 1194.44 | 1194.93 | 1192.46 | 1193.2 | 80212.0 |
| 2010-11-11 17:00:00 | ES | Futures | 1193.45 | 1194.44 | 1193.2 | 1194.19 | 3035.0 |
| 2010-11-11 18:00:00 | ES | Futures | 1194.19 | 1194.68 | 1190.74 | 1191.48 | 9239.0 |
| 2010-11-11 19:00:00 | ES | Futures | 1191.48 | 1194.19 | 1191.48 | 1192.22 | 7813.0 |
| 2010-11-11 20:00:00 | ES | Futures | 1191.97 | 1192.96 | 1188.03 | 1188.52 | 11920.0 |
| 2010-11-11 21:00:00 | ES | Futures | 1188.52 | 1189.01 | 1186.3 | 1187.78 | 16903.0 |
| 2010-11-11 22:00:00 | ES | Futures | 1187.54 | 1188.03 | 1183.59 | 1185.56 | 18049.0 |
| 2010-11-11 23:00:00 | ES | Futures | 1185.56 | 1186.55 | 1184.58 | 1186.3 | 4620.0 |
| 2010-11-11 00:00:00 | NQ | Futures | 2479.99 | 2480.56 | 2479.12 | 2480.27 | 139.0 |
| 2010-11-11 01:00:00 | NQ | Futures | 2479.99 | 2482.85 | 2479.7 | 2482.28 | 334.0 |
| 2010-11-11 02:00:00 | NQ | Futures | 2482.85 | 2486.87 | 2481.71 | 2482.28 | 2171.0 |
| 2010-11-11 03:00:00 | NQ | Futures | 2482.57 | 2483.71 | 2477.98 | 2478.26 | 4680.0 |
| 2010-11-11 04:00:00 | NQ | Futures | 2478.84 | 2479.7 | 2475.97 | 2478.84 | 2453.0 |
| 2010-11-11 05:00:00 | NQ | Futures | 2479.12 | 2481.42 | 2477.4 | 2480.85 | 1838.0 |
| 2010-11-11 06:00:00 | NQ | Futures | 2480.85 | 2481.42 | 2476.26 | 2477.69 | 2372.0 |
| 2010-11-11 07:00:00 | NQ | Futures | 2477.98 | 2479.12 | 2471.09 | 2471.95 | 3491.0 |
| 2010-11-11 08:00:00 | NQ | Futures | 2471.95 | 2475.39 | 2467.65 | 2469.08 | 7840.0 |
| 2010-11-11 09:00:00 | NQ | Futures | 2468.8 | 2473.1 | 2458.47 | 2471.95 | 64786.0 |
| 2010-11-11 10:00:00 | NQ | Futures | 2471.95 | 2484.29 | 2468.51 | 2481.99 | 63031.0 |
| 2010-11-11 11:00:00 | NQ | Futures | 2481.99 | 2483.14 | 2473.39 | 2481.42 | 29689.0 |
| 2010-11-11 12:00:00 | NQ | Futures | 2481.42 | 2489.45 | 2481.13 | 2485.72 | 27783.0 |
| 2010-11-11 13:00:00 | NQ | Futures | 2485.72 | 2495.19 | 2482.85 | 2493.18 | 28483.0 |
| 2010-11-11 14:00:00 | NQ | Futures | 2493.47 | 2496.63 | 2490.03 | 2491.17 | 20702.0 |
| 2010-11-11 15:00:00 | NQ | Futures | 2490.89 | 2493.76 | 2485.72 | 2492.61 | 34433.0 |
| 2010-11-11 16:00:00 | NQ | Futures | 2492.9 | 2495.48 | 2490.6 | 2492.9 | 10427.0 |
| 2010-11-11 17:00:00 | NQ | Futures | 2492.9 | 2494.33 | 2492.04 | 2494.33 | 147.0 |
| 2010-11-11 18:00:00 | NQ | Futures | 2493.18 | 2495.19 | 2487.44 | 2488.59 | 373.0 |
| 2010-11-11 19:00:00 | NQ | Futures | 2488.59 | 2493.47 | 2488.59 | 2490.31 | 479.0 |
| 2010-11-11 20:00:00 | NQ | Futures | 2489.74 | 2491.46 | 2483.14 | 2483.14 | 964.0 |
| 2010-11-11 21:00:00 | NQ | Futures | 2483.71 | 2484.0 | 2477.98 | 2480.85 | 1710.0 |
| 2010-11-11 22:00:00 | NQ | Futures | 2480.85 | 2481.13 | 2471.95 | 2475.97 | 1153.0 |
| 2010-11-11 23:00:00 | NQ | Futures | 2476.83 | 2479.41 | 2474.82 | 2478.84 | 280.0 |
| 2010-11-11 00:00:00 | YM | Futures | 10749.7 | 10754.5 | 10744.9 | 10753.5 | 215.0 |
| 2010-11-11 01:00:00 | YM | Futures | 10751.6 | 10758.3 | 10750.6 | 10757.3 | 298.0 |
> showing 50 of 1,440 rows — these rows as CSV