PREVIEW / futures_1hour / 2010-10-19
file: by_date/futures_1hour/2010/2010-10-19.parquet size: 50 KB rows: 1,465
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-19 00:00:00 | ES | Futures | 1155.25 | 1155.74 | 1154.26 | 1154.26 | 5036.0 |
| 2010-10-19 01:00:00 | ES | Futures | 1154.26 | 1155.49 | 1154.01 | 1155.49 | 5715.0 |
| 2010-10-19 02:00:00 | ES | Futures | 1155.49 | 1157.22 | 1155.49 | 1155.74 | 10217.0 |
| 2010-10-19 03:00:00 | ES | Futures | 1155.74 | 1159.19 | 1155.0 | 1157.71 | 23375.0 |
| 2010-10-19 04:00:00 | ES | Futures | 1157.71 | 1159.19 | 1157.46 | 1157.46 | 10651.0 |
| 2010-10-19 05:00:00 | ES | Futures | 1157.46 | 1159.93 | 1157.46 | 1159.19 | 21747.0 |
| 2010-10-19 06:00:00 | ES | Futures | 1159.19 | 1161.41 | 1158.2 | 1159.44 | 27234.0 |
| 2010-10-19 07:00:00 | ES | Futures | 1159.44 | 1159.93 | 1152.54 | 1154.75 | 116330.0 |
| 2010-10-19 08:00:00 | ES | Futures | 1154.75 | 1156.23 | 1152.54 | 1153.03 | 95338.0 |
| 2010-10-19 09:00:00 | ES | Futures | 1153.03 | 1153.27 | 1146.37 | 1148.59 | 397959.0 |
| 2010-10-19 10:00:00 | ES | Futures | 1148.59 | 1155.99 | 1147.61 | 1153.77 | 471752.0 |
| 2010-10-19 11:00:00 | ES | Futures | 1153.77 | 1157.22 | 1151.3 | 1156.48 | 267011.0 |
| 2010-10-19 12:00:00 | ES | Futures | 1156.48 | 1157.22 | 1153.03 | 1155.0 | 120727.0 |
| 2010-10-19 13:00:00 | ES | Futures | 1155.0 | 1155.0 | 1146.62 | 1147.36 | 210227.0 |
| 2010-10-19 14:00:00 | ES | Futures | 1147.36 | 1147.61 | 1140.95 | 1144.65 | 562651.0 |
| 2010-10-19 15:00:00 | ES | Futures | 1144.65 | 1146.37 | 1139.23 | 1146.13 | 472906.0 |
| 2010-10-19 16:00:00 | ES | Futures | 1146.13 | 1147.85 | 1145.63 | 1146.37 | 139503.0 |
| 2010-10-19 17:00:00 | ES | Futures | 1146.37 | 1147.36 | 1146.37 | 1146.62 | 2685.0 |
| 2010-10-19 18:00:00 | ES | Futures | 1146.37 | 1146.87 | 1145.39 | 1145.39 | 4679.0 |
| 2010-10-19 19:00:00 | ES | Futures | 1145.39 | 1145.88 | 1144.15 | 1144.4 | 5584.0 |
| 2010-10-19 20:00:00 | ES | Futures | 1144.65 | 1145.88 | 1144.15 | 1145.39 | 9769.0 |
| 2010-10-19 21:00:00 | ES | Futures | 1145.39 | 1149.08 | 1145.14 | 1147.85 | 15751.0 |
| 2010-10-19 22:00:00 | ES | Futures | 1147.85 | 1149.82 | 1147.61 | 1149.58 | 6954.0 |
| 2010-10-19 23:00:00 | ES | Futures | 1149.58 | 1150.56 | 1148.59 | 1150.32 | 6001.0 |
| 2010-10-19 00:00:00 | NQ | Futures | 2370.39 | 2372.4 | 2369.81 | 2371.54 | 755.0 |
| 2010-10-19 01:00:00 | NQ | Futures | 2371.82 | 2374.12 | 2370.68 | 2374.12 | 421.0 |
| 2010-10-19 02:00:00 | NQ | Futures | 2374.12 | 2378.71 | 2373.83 | 2375.55 | 1540.0 |
| 2010-10-19 03:00:00 | NQ | Futures | 2375.55 | 2378.42 | 2374.41 | 2376.41 | 3107.0 |
| 2010-10-19 04:00:00 | NQ | Futures | 2376.41 | 2379.0 | 2376.13 | 2376.99 | 1199.0 |
| 2010-10-19 05:00:00 | NQ | Futures | 2376.99 | 2380.72 | 2376.99 | 2379.86 | 1594.0 |
| 2010-10-19 06:00:00 | NQ | Futures | 2379.57 | 2384.45 | 2378.71 | 2381.58 | 2773.0 |
| 2010-10-19 07:00:00 | NQ | Futures | 2381.58 | 2382.15 | 2370.96 | 2374.41 | 5632.0 |
| 2010-10-19 08:00:00 | NQ | Futures | 2374.69 | 2380.72 | 2371.54 | 2373.54 | 11279.0 |
| 2010-10-19 09:00:00 | NQ | Futures | 2373.54 | 2377.85 | 2354.32 | 2362.93 | 85296.0 |
| 2010-10-19 10:00:00 | NQ | Futures | 2362.64 | 2389.9 | 2358.91 | 2384.45 | 82627.0 |
| 2010-10-19 11:00:00 | NQ | Futures | 2384.73 | 2391.62 | 2376.13 | 2389.32 | 40336.0 |
| 2010-10-19 12:00:00 | NQ | Futures | 2389.61 | 2392.48 | 2384.16 | 2389.9 | 20714.0 |
| 2010-10-19 13:00:00 | NQ | Futures | 2389.61 | 2389.9 | 2371.25 | 2373.26 | 33058.0 |
| 2010-10-19 14:00:00 | NQ | Futures | 2372.97 | 2373.26 | 2359.2 | 2368.38 | 69126.0 |
| 2010-10-19 15:00:00 | NQ | Futures | 2368.09 | 2373.83 | 2354.9 | 2373.26 | 68425.0 |
| 2010-10-19 16:00:00 | NQ | Futures | 2373.26 | 2377.27 | 2370.68 | 2371.54 | 11889.0 |
| 2010-10-19 17:00:00 | NQ | Futures | 2371.25 | 2372.68 | 2370.96 | 2372.11 | 341.0 |
| 2010-10-19 18:00:00 | NQ | Futures | 2371.54 | 2372.68 | 2369.53 | 2369.53 | 245.0 |
| 2010-10-19 19:00:00 | NQ | Futures | 2369.53 | 2370.1 | 2367.23 | 2367.52 | 456.0 |
| 2010-10-19 20:00:00 | NQ | Futures | 2368.09 | 2370.96 | 2366.95 | 2369.81 | 541.0 |
| 2010-10-19 21:00:00 | NQ | Futures | 2369.81 | 2378.71 | 2369.24 | 2375.84 | 848.0 |
| 2010-10-19 22:00:00 | NQ | Futures | 2375.55 | 2379.57 | 2375.27 | 2379.0 | 487.0 |
| 2010-10-19 23:00:00 | NQ | Futures | 2379.0 | 2381.86 | 2379.0 | 2381.86 | 542.0 |
| 2010-10-19 00:00:00 | YM | Futures | 10486.8 | 10488.7 | 10478.2 | 10481.1 | 347.0 |
| 2010-10-19 01:00:00 | YM | Futures | 10481.1 | 10487.7 | 10479.2 | 10487.7 | 401.0 |
> showing 50 of 1,465 rows — these rows as CSV