PREVIEW / futures_1hour / 2010-10-01
file: by_date/futures_1hour/2010/2010-10-01.parquet size: 40 KB rows: 1,147
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-01 00:00:00 | ES | Futures | 1122.22 | 1122.96 | 1121.48 | 1122.71 | 3679.0 |
| 2010-10-01 01:00:00 | ES | Futures | 1122.71 | 1123.94 | 1121.97 | 1122.46 | 5235.0 |
| 2010-10-01 02:00:00 | ES | Futures | 1122.22 | 1123.7 | 1121.97 | 1122.46 | 8302.0 |
| 2010-10-01 03:00:00 | ES | Futures | 1122.46 | 1126.41 | 1121.73 | 1124.93 | 42249.0 |
| 2010-10-01 04:00:00 | ES | Futures | 1124.93 | 1126.65 | 1124.68 | 1126.41 | 17460.0 |
| 2010-10-01 05:00:00 | ES | Futures | 1126.16 | 1127.89 | 1125.67 | 1126.65 | 17671.0 |
| 2010-10-01 06:00:00 | ES | Futures | 1126.41 | 1128.13 | 1122.96 | 1123.7 | 23933.0 |
| 2010-10-01 07:00:00 | ES | Futures | 1123.94 | 1126.9 | 1121.73 | 1126.9 | 36448.0 |
| 2010-10-01 08:00:00 | ES | Futures | 1126.65 | 1128.13 | 1125.67 | 1127.64 | 74839.0 |
| 2010-10-01 09:00:00 | ES | Futures | 1127.64 | 1130.35 | 1126.41 | 1127.89 | 231229.0 |
| 2010-10-01 10:00:00 | ES | Futures | 1127.89 | 1129.61 | 1118.52 | 1121.97 | 637444.0 |
| 2010-10-01 11:00:00 | ES | Futures | 1122.22 | 1125.18 | 1119.75 | 1123.7 | 257653.0 |
| 2010-10-01 12:00:00 | ES | Futures | 1123.94 | 1124.68 | 1121.48 | 1123.2 | 108317.0 |
| 2010-10-01 13:00:00 | ES | Futures | 1123.2 | 1126.16 | 1122.22 | 1124.19 | 118011.0 |
| 2010-10-01 14:00:00 | ES | Futures | 1124.19 | 1127.15 | 1123.94 | 1126.16 | 111364.0 |
| 2010-10-01 15:00:00 | ES | Futures | 1126.16 | 1127.89 | 1123.94 | 1125.18 | 237522.0 |
| 2010-10-01 16:00:00 | ES | Futures | 1125.42 | 1126.65 | 1124.68 | 1126.16 | 92424.0 |
| 2010-10-01 00:00:00 | NQ | Futures | 2294.93 | 2296.65 | 2294.65 | 2295.79 | 206.0 |
| 2010-10-01 01:00:00 | NQ | Futures | 2296.08 | 2298.66 | 2295.22 | 2295.79 | 315.0 |
| 2010-10-01 02:00:00 | NQ | Futures | 2296.08 | 2298.95 | 2295.22 | 2296.37 | 636.0 |
| 2010-10-01 03:00:00 | NQ | Futures | 2295.79 | 2304.97 | 2294.93 | 2301.53 | 3672.0 |
| 2010-10-01 04:00:00 | NQ | Futures | 2301.82 | 2304.97 | 2301.24 | 2303.83 | 1271.0 |
| 2010-10-01 05:00:00 | NQ | Futures | 2303.54 | 2307.56 | 2302.39 | 2304.69 | 1409.0 |
| 2010-10-01 06:00:00 | NQ | Futures | 2304.4 | 2307.84 | 2298.95 | 2300.38 | 1567.0 |
| 2010-10-01 07:00:00 | NQ | Futures | 2300.1 | 2306.7 | 2295.51 | 2306.12 | 5198.0 |
| 2010-10-01 08:00:00 | NQ | Futures | 2306.12 | 2310.14 | 2304.11 | 2307.27 | 8061.0 |
| 2010-10-01 09:00:00 | NQ | Futures | 2307.56 | 2313.01 | 2302.68 | 2308.42 | 47025.0 |
| 2010-10-01 10:00:00 | NQ | Futures | 2308.42 | 2311.29 | 2278.01 | 2285.18 | 94793.0 |
| 2010-10-01 11:00:00 | NQ | Futures | 2285.18 | 2293.21 | 2280.59 | 2290.06 | 43340.0 |
| 2010-10-01 12:00:00 | NQ | Futures | 2290.34 | 2291.2 | 2284.03 | 2289.2 | 21143.0 |
| 2010-10-01 13:00:00 | NQ | Futures | 2289.2 | 2294.07 | 2284.32 | 2287.47 | 22997.0 |
| 2010-10-01 14:00:00 | NQ | Futures | 2287.76 | 2294.07 | 2287.76 | 2290.63 | 21242.0 |
| 2010-10-01 15:00:00 | NQ | Futures | 2290.63 | 2296.08 | 2288.05 | 2288.91 | 35931.0 |
| 2010-10-01 16:00:00 | NQ | Futures | 2288.91 | 2289.48 | 2286.33 | 2288.33 | 9424.0 |
| 2010-10-01 00:00:00 | YM | Futures | 10228.6 | 10232.4 | 10222.9 | 10231.5 | 178.0 |
| 2010-10-01 01:00:00 | YM | Futures | 10232.4 | 10242.0 | 10226.7 | 10229.6 | 209.0 |
| 2010-10-01 02:00:00 | YM | Futures | 10229.6 | 10242.0 | 10226.7 | 10234.4 | 839.0 |
| 2010-10-01 03:00:00 | YM | Futures | 10235.3 | 10266.7 | 10227.7 | 10255.3 | 3673.0 |
| 2010-10-01 04:00:00 | YM | Futures | 10255.3 | 10268.6 | 10252.5 | 10262.9 | 1355.0 |
| 2010-10-01 05:00:00 | YM | Futures | 10263.9 | 10274.4 | 10254.4 | 10267.7 | 1387.0 |
| 2010-10-01 06:00:00 | YM | Futures | 10265.8 | 10279.1 | 10236.3 | 10240.1 | 1352.0 |
| 2010-10-01 07:00:00 | YM | Futures | 10239.1 | 10262.0 | 10224.8 | 10260.1 | 1890.0 |
| 2010-10-01 08:00:00 | YM | Futures | 10260.1 | 10272.5 | 10249.6 | 10268.6 | 3571.0 |
| 2010-10-01 09:00:00 | YM | Futures | 10269.6 | 10294.4 | 10255.3 | 10275.3 | 16839.0 |
| 2010-10-01 10:00:00 | YM | Futures | 10275.3 | 10286.7 | 10209.6 | 10235.3 | 42870.0 |
| 2010-10-01 11:00:00 | YM | Futures | 10237.2 | 10255.3 | 10211.5 | 10245.8 | 19135.0 |
| 2010-10-01 12:00:00 | YM | Futures | 10245.8 | 10248.6 | 10232.4 | 10242.9 | 8220.0 |
| 2010-10-01 13:00:00 | YM | Futures | 10242.9 | 10264.8 | 10230.5 | 10244.8 | 10203.0 |
| 2010-10-01 14:00:00 | YM | Futures | 10244.8 | 10271.5 | 10243.9 | 10263.9 | 11081.0 |
| 2010-10-01 15:00:00 | YM | Futures | 10263.9 | 10275.3 | 10242.9 | 10255.3 | 16081.0 |
> showing 50 of 1,147 rows — these rows as CSV