PREVIEW / futures_30min / 2010-09-29
file: by_date/futures_30min/2010/2010-09-29.parquet size: 69 KB rows: 2,614
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-09-29 00:00:00 | ES | Futures | 1127.64 | 1128.13 | 1126.16 | 1126.41 | 1918.0 |
| 2010-09-29 00:30:00 | ES | Futures | 1126.41 | 1126.9 | 1125.92 | 1126.16 | 1726.0 |
| 2010-09-29 01:00:00 | ES | Futures | 1126.16 | 1126.9 | 1125.18 | 1125.42 | 1895.0 |
| 2010-09-29 01:30:00 | ES | Futures | 1125.18 | 1125.67 | 1124.44 | 1124.93 | 3656.0 |
| 2010-09-29 02:00:00 | ES | Futures | 1124.93 | 1126.41 | 1124.93 | 1125.92 | 3381.0 |
| 2010-09-29 02:30:00 | ES | Futures | 1125.67 | 1128.38 | 1124.93 | 1128.13 | 5560.0 |
| 2010-09-29 03:00:00 | ES | Futures | 1128.13 | 1130.6 | 1126.65 | 1128.38 | 21572.0 |
| 2010-09-29 03:30:00 | ES | Futures | 1128.38 | 1128.63 | 1123.2 | 1124.68 | 18317.0 |
| 2010-09-29 04:00:00 | ES | Futures | 1124.68 | 1124.93 | 1121.48 | 1123.7 | 21571.0 |
| 2010-09-29 04:30:00 | ES | Futures | 1123.94 | 1125.42 | 1121.23 | 1121.73 | 15690.0 |
| 2010-09-29 05:00:00 | ES | Futures | 1121.48 | 1123.94 | 1121.48 | 1122.46 | 11257.0 |
| 2010-09-29 05:30:00 | ES | Futures | 1122.46 | 1126.9 | 1121.48 | 1125.92 | 12659.0 |
| 2010-09-29 06:00:00 | ES | Futures | 1125.92 | 1126.41 | 1123.45 | 1124.68 | 7994.0 |
| 2010-09-29 06:30:00 | ES | Futures | 1124.93 | 1125.42 | 1123.7 | 1124.44 | 6299.0 |
| 2010-09-29 07:00:00 | ES | Futures | 1124.68 | 1125.42 | 1123.45 | 1124.19 | 8452.0 |
| 2010-09-29 07:30:00 | ES | Futures | 1124.44 | 1126.16 | 1124.19 | 1126.16 | 12332.0 |
| 2010-09-29 08:00:00 | ES | Futures | 1126.16 | 1127.64 | 1124.93 | 1125.42 | 27825.0 |
| 2010-09-29 08:30:00 | ES | Futures | 1125.18 | 1126.41 | 1123.2 | 1123.7 | 27979.0 |
| 2010-09-29 09:00:00 | ES | Futures | 1123.45 | 1124.19 | 1122.22 | 1123.45 | 34881.0 |
| 2010-09-29 09:30:00 | ES | Futures | 1123.45 | 1126.16 | 1121.23 | 1122.71 | 222197.0 |
| 2010-09-29 10:00:00 | ES | Futures | 1122.46 | 1125.92 | 1119.51 | 1121.73 | 223360.0 |
| 2010-09-29 10:30:00 | ES | Futures | 1121.48 | 1123.45 | 1120.0 | 1121.73 | 152931.0 |
| 2010-09-29 11:00:00 | ES | Futures | 1121.73 | 1124.19 | 1121.23 | 1123.45 | 94122.0 |
| 2010-09-29 11:30:00 | ES | Futures | 1123.7 | 1126.9 | 1123.45 | 1125.92 | 113181.0 |
| 2010-09-29 12:00:00 | ES | Futures | 1125.92 | 1127.89 | 1124.93 | 1126.65 | 67898.0 |
| 2010-09-29 12:30:00 | ES | Futures | 1126.9 | 1126.9 | 1124.93 | 1126.16 | 54964.0 |
| 2010-09-29 13:00:00 | ES | Futures | 1126.16 | 1126.9 | 1124.68 | 1124.93 | 47389.0 |
| 2010-09-29 13:30:00 | ES | Futures | 1124.68 | 1127.15 | 1123.7 | 1126.41 | 73141.0 |
| 2010-09-29 14:00:00 | ES | Futures | 1126.65 | 1128.38 | 1125.92 | 1126.16 | 77158.0 |
| 2010-09-29 14:30:00 | ES | Futures | 1126.16 | 1128.38 | 1125.92 | 1127.64 | 43442.0 |
| 2010-09-29 15:00:00 | ES | Futures | 1127.64 | 1127.89 | 1120.99 | 1122.71 | 143245.0 |
| 2010-09-29 15:30:00 | ES | Futures | 1122.71 | 1124.19 | 1120.0 | 1123.45 | 172826.0 |
| 2010-09-29 16:00:00 | ES | Futures | 1123.7 | 1125.18 | 1122.71 | 1124.93 | 90096.0 |
| 2010-09-29 16:30:00 | ES | Futures | 1124.93 | 1125.18 | 1123.7 | 1124.44 | 4781.0 |
| 2010-09-29 17:00:00 | ES | Futures | 1124.68 | 1124.68 | 1123.7 | 1123.94 | 1123.0 |
| 2010-09-29 18:00:00 | ES | Futures | 1124.19 | 1124.93 | 1123.94 | 1124.44 | 1935.0 |
| 2010-09-29 18:30:00 | ES | Futures | 1124.44 | 1124.68 | 1123.94 | 1124.44 | 430.0 |
| 2010-09-29 19:00:00 | ES | Futures | 1124.44 | 1124.68 | 1123.45 | 1123.7 | 1191.0 |
| 2010-09-29 19:30:00 | ES | Futures | 1123.94 | 1123.94 | 1123.7 | 1123.94 | 737.0 |
| 2010-09-29 20:00:00 | ES | Futures | 1123.7 | 1124.68 | 1123.45 | 1123.94 | 2755.0 |
| 2010-09-29 20:30:00 | ES | Futures | 1124.19 | 1125.18 | 1123.7 | 1124.68 | 2321.0 |
| 2010-09-29 21:00:00 | ES | Futures | 1124.68 | 1125.18 | 1124.19 | 1124.44 | 1790.0 |
| 2010-09-29 21:30:00 | ES | Futures | 1124.68 | 1124.68 | 1123.45 | 1123.7 | 3495.0 |
| 2010-09-29 22:00:00 | ES | Futures | 1123.94 | 1124.19 | 1122.71 | 1122.96 | 2828.0 |
| 2010-09-29 22:30:00 | ES | Futures | 1122.96 | 1123.2 | 1122.22 | 1123.2 | 2469.0 |
| 2010-09-29 23:00:00 | ES | Futures | 1123.2 | 1123.2 | 1122.46 | 1122.96 | 1649.0 |
| 2010-09-29 23:30:00 | ES | Futures | 1123.2 | 1123.94 | 1122.71 | 1122.96 | 1906.0 |
| 2010-09-29 00:00:00 | NQ | Futures | 2310.71 | 2311.57 | 2308.42 | 2308.42 | 156.0 |
| 2010-09-29 00:30:00 | NQ | Futures | 2308.13 | 2308.99 | 2307.56 | 2308.13 | 77.0 |
| 2010-09-29 01:00:00 | NQ | Futures | 2308.13 | 2308.99 | 2306.7 | 2306.7 | 116.0 |
> showing 50 of 2,614 rows — these rows as CSV