PREVIEW / futures_1hour / 2010-10-12
file: by_date/futures_1hour/2010/2010-10-12.parquet size: 48 KB rows: 1,441
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-12 00:00:00 | ES | Futures | 1137.5 | 1140.21 | 1137.01 | 1137.99 | 14465.0 |
| 2010-10-12 01:00:00 | ES | Futures | 1137.99 | 1138.98 | 1137.5 | 1137.75 | 8079.0 |
| 2010-10-12 02:00:00 | ES | Futures | 1137.99 | 1140.21 | 1137.5 | 1139.23 | 14657.0 |
| 2010-10-12 03:00:00 | ES | Futures | 1139.47 | 1140.21 | 1137.01 | 1137.5 | 37351.0 |
| 2010-10-12 04:00:00 | ES | Futures | 1137.5 | 1137.75 | 1135.53 | 1137.01 | 35321.0 |
| 2010-10-12 05:00:00 | ES | Futures | 1136.76 | 1139.72 | 1136.27 | 1138.98 | 24647.0 |
| 2010-10-12 06:00:00 | ES | Futures | 1138.98 | 1139.47 | 1137.25 | 1139.23 | 14727.0 |
| 2010-10-12 07:00:00 | ES | Futures | 1138.98 | 1142.18 | 1138.73 | 1141.44 | 29892.0 |
| 2010-10-12 08:00:00 | ES | Futures | 1141.44 | 1143.17 | 1139.23 | 1142.68 | 57081.0 |
| 2010-10-12 09:00:00 | ES | Futures | 1142.92 | 1143.17 | 1135.53 | 1137.75 | 240426.0 |
| 2010-10-12 10:00:00 | ES | Futures | 1137.99 | 1144.4 | 1137.01 | 1142.92 | 324999.0 |
| 2010-10-12 11:00:00 | ES | Futures | 1143.17 | 1145.14 | 1142.43 | 1143.66 | 169836.0 |
| 2010-10-12 12:00:00 | ES | Futures | 1143.66 | 1145.14 | 1142.18 | 1142.68 | 92750.0 |
| 2010-10-12 13:00:00 | ES | Futures | 1142.43 | 1143.66 | 1141.94 | 1143.42 | 51031.0 |
| 2010-10-12 14:00:00 | ES | Futures | 1143.42 | 1149.33 | 1141.94 | 1147.36 | 335756.0 |
| 2010-10-12 15:00:00 | ES | Futures | 1147.61 | 1152.54 | 1145.39 | 1149.33 | 315444.0 |
| 2010-10-12 16:00:00 | ES | Futures | 1149.33 | 1150.56 | 1147.61 | 1149.58 | 95865.0 |
| 2010-10-12 17:00:00 | ES | Futures | 1149.58 | 1150.07 | 1149.08 | 1150.07 | 2827.0 |
| 2010-10-12 18:00:00 | ES | Futures | 1150.07 | 1150.07 | 1148.59 | 1149.33 | 3377.0 |
| 2010-10-12 19:00:00 | ES | Futures | 1149.58 | 1150.32 | 1148.84 | 1149.58 | 4389.0 |
| 2010-10-12 20:00:00 | ES | Futures | 1149.58 | 1149.82 | 1147.85 | 1149.58 | 9236.0 |
| 2010-10-12 21:00:00 | ES | Futures | 1149.33 | 1152.78 | 1149.33 | 1151.06 | 10267.0 |
| 2010-10-12 22:00:00 | ES | Futures | 1151.06 | 1151.8 | 1150.56 | 1151.3 | 4078.0 |
| 2010-10-12 23:00:00 | ES | Futures | 1151.3 | 1151.55 | 1148.84 | 1149.33 | 5706.0 |
| 2010-10-12 00:00:00 | NQ | Futures | 2308.7 | 2312.15 | 2307.56 | 2309.28 | 937.0 |
| 2010-10-12 01:00:00 | NQ | Futures | 2309.28 | 2310.43 | 2308.7 | 2308.7 | 256.0 |
| 2010-10-12 02:00:00 | NQ | Futures | 2308.99 | 2313.01 | 2308.13 | 2311.29 | 877.0 |
| 2010-10-12 03:00:00 | NQ | Futures | 2311.0 | 2314.73 | 2307.84 | 2308.99 | 2494.0 |
| 2010-10-12 04:00:00 | NQ | Futures | 2308.42 | 2308.7 | 2303.54 | 2306.12 | 1998.0 |
| 2010-10-12 05:00:00 | NQ | Futures | 2306.12 | 2312.15 | 2304.97 | 2310.43 | 1129.0 |
| 2010-10-12 06:00:00 | NQ | Futures | 2310.71 | 2313.87 | 2308.13 | 2312.72 | 1329.0 |
| 2010-10-12 07:00:00 | NQ | Futures | 2312.72 | 2318.17 | 2312.43 | 2316.74 | 2148.0 |
| 2010-10-12 08:00:00 | NQ | Futures | 2316.45 | 2323.34 | 2313.58 | 2322.76 | 4282.0 |
| 2010-10-12 09:00:00 | NQ | Futures | 2322.76 | 2322.76 | 2300.1 | 2304.69 | 58152.0 |
| 2010-10-12 10:00:00 | NQ | Futures | 2304.69 | 2333.66 | 2303.25 | 2331.08 | 72854.0 |
| 2010-10-12 11:00:00 | NQ | Futures | 2331.08 | 2333.95 | 2327.64 | 2329.36 | 29100.0 |
| 2010-10-12 12:00:00 | NQ | Futures | 2329.65 | 2333.66 | 2328.21 | 2329.36 | 16783.0 |
| 2010-10-12 13:00:00 | NQ | Futures | 2329.36 | 2331.37 | 2327.64 | 2329.94 | 8970.0 |
| 2010-10-12 14:00:00 | NQ | Futures | 2330.22 | 2340.26 | 2326.49 | 2335.39 | 54150.0 |
| 2010-10-12 15:00:00 | NQ | Futures | 2335.1 | 2345.14 | 2330.8 | 2340.55 | 51675.0 |
| 2010-10-12 16:00:00 | NQ | Futures | 2340.55 | 2346.29 | 2337.68 | 2342.85 | 9799.0 |
| 2010-10-12 17:00:00 | NQ | Futures | 2342.85 | 2342.85 | 2339.12 | 2341.41 | 477.0 |
| 2010-10-12 18:00:00 | NQ | Futures | 2341.7 | 2341.99 | 2339.4 | 2339.69 | 276.0 |
| 2010-10-12 19:00:00 | NQ | Futures | 2339.69 | 2340.84 | 2338.83 | 2339.98 | 562.0 |
| 2010-10-12 20:00:00 | NQ | Futures | 2339.98 | 2340.55 | 2336.25 | 2338.54 | 436.0 |
| 2010-10-12 21:00:00 | NQ | Futures | 2338.83 | 2345.14 | 2338.54 | 2342.27 | 617.0 |
| 2010-10-12 22:00:00 | NQ | Futures | 2342.27 | 2343.71 | 2341.99 | 2342.27 | 229.0 |
| 2010-10-12 23:00:00 | NQ | Futures | 2343.13 | 2343.13 | 2337.97 | 2339.69 | 370.0 |
| 2010-10-12 00:00:00 | YM | Futures | 10377.2 | 10396.3 | 10374.4 | 10381.0 | 549.0 |
| 2010-10-12 01:00:00 | YM | Futures | 10381.0 | 10387.7 | 10375.3 | 10379.1 | 243.0 |
> showing 50 of 1,441 rows — these rows as CSV