PREVIEW / futures_1hour / 2010-12-02
file: by_date/futures_1hour/2010/2010-12-02.parquet size: 47 KB rows: 1,429
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-12-02 00:00:00 | ES | Futures | 1187.78 | 1188.77 | 1187.04 | 1188.52 | 3014.0 |
| 2010-12-02 01:00:00 | ES | Futures | 1188.52 | 1189.75 | 1188.03 | 1188.52 | 4281.0 |
| 2010-12-02 02:00:00 | ES | Futures | 1188.52 | 1190.49 | 1188.03 | 1190.0 | 10766.0 |
| 2010-12-02 03:00:00 | ES | Futures | 1189.75 | 1190.0 | 1186.55 | 1187.78 | 23474.0 |
| 2010-12-02 04:00:00 | ES | Futures | 1187.54 | 1194.68 | 1186.8 | 1193.45 | 44667.0 |
| 2010-12-02 05:00:00 | ES | Futures | 1193.7 | 1193.7 | 1190.99 | 1191.23 | 19021.0 |
| 2010-12-02 06:00:00 | ES | Futures | 1191.48 | 1192.71 | 1189.75 | 1191.73 | 36180.0 |
| 2010-12-02 07:00:00 | ES | Futures | 1191.73 | 1193.7 | 1191.23 | 1193.2 | 32661.0 |
| 2010-12-02 08:00:00 | ES | Futures | 1193.2 | 1193.7 | 1186.3 | 1186.8 | 129357.0 |
| 2010-12-02 09:00:00 | ES | Futures | 1186.8 | 1196.16 | 1185.07 | 1196.16 | 306310.0 |
| 2010-12-02 10:00:00 | ES | Futures | 1196.16 | 1199.86 | 1194.93 | 1199.61 | 393723.0 |
| 2010-12-02 11:00:00 | ES | Futures | 1199.61 | 1202.08 | 1198.38 | 1200.6 | 247698.0 |
| 2010-12-02 12:00:00 | ES | Futures | 1200.6 | 1202.32 | 1199.86 | 1200.6 | 129051.0 |
| 2010-12-02 13:00:00 | ES | Futures | 1200.6 | 1202.08 | 1199.61 | 1201.09 | 112759.0 |
| 2010-12-02 14:00:00 | ES | Futures | 1201.34 | 1204.54 | 1201.09 | 1201.83 | 151440.0 |
| 2010-12-02 15:00:00 | ES | Futures | 1202.08 | 1204.3 | 1201.09 | 1203.31 | 217303.0 |
| 2010-12-02 16:00:00 | ES | Futures | 1203.56 | 1206.02 | 1203.31 | 1205.04 | 129856.0 |
| 2010-12-02 17:00:00 | ES | Futures | 1205.04 | 1206.27 | 1204.3 | 1206.02 | 4271.0 |
| 2010-12-02 18:00:00 | ES | Futures | 1205.53 | 1205.53 | 1204.54 | 1204.54 | 4475.0 |
| 2010-12-02 19:00:00 | ES | Futures | 1204.79 | 1205.04 | 1203.8 | 1204.3 | 6776.0 |
| 2010-12-02 20:00:00 | ES | Futures | 1204.3 | 1204.54 | 1202.57 | 1202.82 | 7536.0 |
| 2010-12-02 21:00:00 | ES | Futures | 1202.82 | 1203.56 | 1202.32 | 1202.57 | 4039.0 |
| 2010-12-02 22:00:00 | ES | Futures | 1202.82 | 1203.56 | 1202.57 | 1203.06 | 2361.0 |
| 2010-12-02 23:00:00 | ES | Futures | 1203.06 | 1203.31 | 1202.57 | 1203.06 | 1848.0 |
| 2010-12-02 00:00:00 | NQ | Futures | 2477.69 | 2480.85 | 2477.12 | 2479.99 | 134.0 |
| 2010-12-02 01:00:00 | NQ | Futures | 2479.99 | 2481.42 | 2478.84 | 2479.41 | 296.0 |
| 2010-12-02 02:00:00 | NQ | Futures | 2479.12 | 2483.43 | 2478.55 | 2482.57 | 662.0 |
| 2010-12-02 03:00:00 | NQ | Futures | 2482.85 | 2483.14 | 2475.39 | 2478.55 | 2085.0 |
| 2010-12-02 04:00:00 | NQ | Futures | 2478.26 | 2491.17 | 2476.83 | 2488.88 | 3737.0 |
| 2010-12-02 05:00:00 | NQ | Futures | 2489.17 | 2489.74 | 2484.86 | 2486.58 | 2047.0 |
| 2010-12-02 06:00:00 | NQ | Futures | 2486.3 | 2488.88 | 2484.58 | 2488.02 | 2682.0 |
| 2010-12-02 07:00:00 | NQ | Futures | 2487.73 | 2493.76 | 2486.58 | 2492.61 | 2904.0 |
| 2010-12-02 08:00:00 | NQ | Futures | 2492.32 | 2493.18 | 2476.83 | 2477.98 | 11319.0 |
| 2010-12-02 09:00:00 | NQ | Futures | 2477.98 | 2495.76 | 2475.97 | 2495.76 | 42603.0 |
| 2010-12-02 10:00:00 | NQ | Futures | 2496.05 | 2502.08 | 2490.89 | 2497.2 | 46816.0 |
| 2010-12-02 11:00:00 | NQ | Futures | 2497.49 | 2504.66 | 2494.9 | 2503.51 | 27496.0 |
| 2010-12-02 12:00:00 | NQ | Futures | 2503.22 | 2505.81 | 2500.07 | 2502.08 | 15270.0 |
| 2010-12-02 13:00:00 | NQ | Futures | 2502.08 | 2506.95 | 2500.93 | 2504.95 | 15174.0 |
| 2010-12-02 14:00:00 | NQ | Futures | 2504.66 | 2509.54 | 2504.09 | 2504.95 | 17945.0 |
| 2010-12-02 15:00:00 | NQ | Futures | 2505.23 | 2511.26 | 2504.66 | 2507.53 | 32071.0 |
| 2010-12-02 16:00:00 | NQ | Futures | 2507.53 | 2511.83 | 2506.09 | 2510.11 | 8967.0 |
| 2010-12-02 17:00:00 | NQ | Futures | 2510.4 | 2512.69 | 2509.25 | 2512.69 | 333.0 |
| 2010-12-02 18:00:00 | NQ | Futures | 2511.54 | 2512.41 | 2509.25 | 2509.82 | 308.0 |
| 2010-12-02 19:00:00 | NQ | Futures | 2509.54 | 2510.68 | 2507.81 | 2510.4 | 348.0 |
| 2010-12-02 20:00:00 | NQ | Futures | 2510.4 | 2511.54 | 2507.81 | 2508.39 | 398.0 |
| 2010-12-02 21:00:00 | NQ | Futures | 2508.1 | 2509.25 | 2507.53 | 2507.81 | 146.0 |
| 2010-12-02 22:00:00 | NQ | Futures | 2507.81 | 2508.96 | 2507.24 | 2508.1 | 154.0 |
| 2010-12-02 23:00:00 | NQ | Futures | 2508.1 | 2508.96 | 2507.81 | 2508.68 | 57.0 |
| 2010-12-02 00:00:00 | YM | Futures | 10706.8 | 10712.5 | 10703.0 | 10708.7 | 278.0 |
| 2010-12-02 01:00:00 | YM | Futures | 10707.8 | 10717.3 | 10704.0 | 10704.9 | 489.0 |
> showing 50 of 1,429 rows — these rows as CSV