PREVIEW / futures_30min / 2010-10-01
file: by_date/futures_30min/2010/2010-10-01.parquet size: 63 KB rows: 2,152
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.46 | 1121.48 | 1122.22 | 1956.0 |
| 2010-10-01 00:30:00 | ES | Futures | 1122.22 | 1122.96 | 1121.48 | 1122.71 | 1723.0 |
| 2010-10-01 01:00:00 | ES | Futures | 1122.71 | 1123.94 | 1121.97 | 1123.2 | 2148.0 |
| 2010-10-01 01:30:00 | ES | Futures | 1123.45 | 1123.7 | 1121.97 | 1122.46 | 3087.0 |
| 2010-10-01 02:00:00 | ES | Futures | 1122.22 | 1123.7 | 1121.97 | 1122.96 | 4673.0 |
| 2010-10-01 02:30:00 | ES | Futures | 1122.96 | 1123.45 | 1122.22 | 1122.46 | 3629.0 |
| 2010-10-01 03:00:00 | ES | Futures | 1122.46 | 1126.41 | 1122.46 | 1124.93 | 23710.0 |
| 2010-10-01 03:30:00 | ES | Futures | 1124.68 | 1125.42 | 1121.73 | 1124.93 | 18539.0 |
| 2010-10-01 04:00:00 | ES | Futures | 1124.93 | 1126.65 | 1124.68 | 1126.16 | 11926.0 |
| 2010-10-01 04:30:00 | ES | Futures | 1126.41 | 1126.65 | 1125.18 | 1126.41 | 5534.0 |
| 2010-10-01 05:00:00 | ES | Futures | 1126.16 | 1127.89 | 1125.67 | 1127.39 | 11365.0 |
| 2010-10-01 05:30:00 | ES | Futures | 1127.15 | 1127.39 | 1125.67 | 1126.65 | 6306.0 |
| 2010-10-01 06:00:00 | ES | Futures | 1126.41 | 1128.13 | 1126.16 | 1127.39 | 10029.0 |
| 2010-10-01 06:30:00 | ES | Futures | 1127.39 | 1127.89 | 1122.96 | 1123.7 | 13904.0 |
| 2010-10-01 07:00:00 | ES | Futures | 1123.94 | 1125.42 | 1121.73 | 1124.44 | 21591.0 |
| 2010-10-01 07:30:00 | ES | Futures | 1124.68 | 1126.9 | 1124.19 | 1126.9 | 14857.0 |
| 2010-10-01 08:00:00 | ES | Futures | 1126.65 | 1127.39 | 1125.67 | 1126.41 | 31621.0 |
| 2010-10-01 08:30:00 | ES | Futures | 1126.16 | 1128.13 | 1125.67 | 1127.64 | 43218.0 |
| 2010-10-01 09:00:00 | ES | Futures | 1127.64 | 1128.87 | 1126.9 | 1128.87 | 30685.0 |
| 2010-10-01 09:30:00 | ES | Futures | 1128.87 | 1130.35 | 1126.41 | 1127.89 | 200544.0 |
| 2010-10-01 10:00:00 | ES | Futures | 1127.89 | 1129.61 | 1120.25 | 1121.73 | 372681.0 |
| 2010-10-01 10:30:00 | ES | Futures | 1121.48 | 1123.2 | 1118.52 | 1121.97 | 264763.0 |
| 2010-10-01 11:00:00 | ES | Futures | 1122.22 | 1122.96 | 1120.0 | 1120.99 | 151200.0 |
| 2010-10-01 11:30:00 | ES | Futures | 1120.99 | 1125.18 | 1119.75 | 1123.7 | 106453.0 |
| 2010-10-01 12:00:00 | ES | Futures | 1123.94 | 1124.68 | 1122.22 | 1123.2 | 61131.0 |
| 2010-10-01 12:30:00 | ES | Futures | 1123.45 | 1123.7 | 1121.48 | 1123.2 | 47186.0 |
| 2010-10-01 13:00:00 | ES | Futures | 1123.2 | 1126.16 | 1122.96 | 1124.93 | 62284.0 |
| 2010-10-01 13:30:00 | ES | Futures | 1124.93 | 1124.93 | 1122.22 | 1124.19 | 55727.0 |
| 2010-10-01 14:00:00 | ES | Futures | 1124.19 | 1126.9 | 1123.94 | 1125.92 | 59092.0 |
| 2010-10-01 14:30:00 | ES | Futures | 1125.92 | 1127.15 | 1125.18 | 1126.16 | 52272.0 |
| 2010-10-01 15:00:00 | ES | Futures | 1126.16 | 1127.89 | 1124.68 | 1125.18 | 96305.0 |
| 2010-10-01 15:30:00 | ES | Futures | 1125.18 | 1126.65 | 1123.94 | 1125.18 | 141217.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 | 2295.79 | 2294.65 | 2295.51 | 110.0 |
| 2010-10-01 00:30:00 | NQ | Futures | 2295.79 | 2296.65 | 2294.65 | 2295.79 | 96.0 |
| 2010-10-01 01:00:00 | NQ | Futures | 2296.08 | 2298.66 | 2295.79 | 2297.23 | 230.0 |
| 2010-10-01 01:30:00 | NQ | Futures | 2297.8 | 2298.66 | 2295.22 | 2295.79 | 85.0 |
| 2010-10-01 02:00:00 | NQ | Futures | 2296.08 | 2298.95 | 2295.22 | 2298.09 | 433.0 |
| 2010-10-01 02:30:00 | NQ | Futures | 2297.52 | 2298.09 | 2295.51 | 2296.37 | 203.0 |
| 2010-10-01 03:00:00 | NQ | Futures | 2295.79 | 2304.97 | 2295.79 | 2301.24 | 2140.0 |
| 2010-10-01 03:30:00 | NQ | Futures | 2300.96 | 2302.68 | 2294.93 | 2301.53 | 1532.0 |
| 2010-10-01 04:00:00 | NQ | Futures | 2301.82 | 2304.97 | 2301.24 | 2303.54 | 871.0 |
| 2010-10-01 04:30:00 | NQ | Futures | 2303.83 | 2304.4 | 2301.82 | 2303.83 | 400.0 |
| 2010-10-01 05:00:00 | NQ | Futures | 2303.54 | 2307.56 | 2302.39 | 2305.84 | 949.0 |
| 2010-10-01 05:30:00 | NQ | Futures | 2305.84 | 2306.12 | 2302.39 | 2304.69 | 460.0 |
| 2010-10-01 06:00:00 | NQ | Futures | 2304.4 | 2307.84 | 2303.83 | 2306.7 | 472.0 |
| 2010-10-01 06:30:00 | NQ | Futures | 2306.12 | 2306.98 | 2298.95 | 2300.38 | 1095.0 |
| 2010-10-01 07:00:00 | NQ | Futures | 2300.1 | 2303.83 | 2295.51 | 2302.68 | 3670.0 |
| 2010-10-01 07:30:00 | NQ | Futures | 2302.68 | 2306.7 | 2302.11 | 2306.12 | 1528.0 |
| 2010-10-01 08:00:00 | NQ | Futures | 2306.12 | 2308.13 | 2304.11 | 2305.84 | 2815.0 |
> showing 50 of 2,152 rows — these rows as CSV