PREVIEW / futures_30min / 2010-05-14
file: by_date/futures_30min/2010/2010-05-14.parquet size: 65 KB rows: 2,099
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-05-14 00:00:00 | ES | Futures | 1131.2 | 1132.92 | 1130.72 | 1132.18 | 2255.0 |
| 2010-05-14 00:30:00 | ES | Futures | 1132.18 | 1133.16 | 1131.69 | 1132.67 | 1606.0 |
| 2010-05-14 01:00:00 | ES | Futures | 1132.67 | 1133.65 | 1132.43 | 1133.4 | 2087.0 |
| 2010-05-14 01:30:00 | ES | Futures | 1133.16 | 1133.65 | 1130.47 | 1131.94 | 2991.0 |
| 2010-05-14 02:00:00 | ES | Futures | 1131.94 | 1132.67 | 1130.23 | 1130.47 | 4707.0 |
| 2010-05-14 02:30:00 | ES | Futures | 1130.72 | 1133.16 | 1130.47 | 1132.18 | 5265.0 |
| 2010-05-14 03:00:00 | ES | Futures | 1132.18 | 1132.43 | 1129.25 | 1129.25 | 19836.0 |
| 2010-05-14 03:30:00 | ES | Futures | 1129.25 | 1129.25 | 1126.56 | 1127.29 | 25994.0 |
| 2010-05-14 04:00:00 | ES | Futures | 1127.29 | 1128.03 | 1124.61 | 1125.83 | 19294.0 |
| 2010-05-14 04:30:00 | ES | Futures | 1125.83 | 1128.52 | 1123.63 | 1123.87 | 15366.0 |
| 2010-05-14 05:00:00 | ES | Futures | 1123.87 | 1124.61 | 1121.18 | 1124.12 | 22897.0 |
| 2010-05-14 05:30:00 | ES | Futures | 1124.12 | 1124.61 | 1119.96 | 1121.92 | 18164.0 |
| 2010-05-14 06:00:00 | ES | Futures | 1121.92 | 1123.38 | 1119.96 | 1122.65 | 12502.0 |
| 2010-05-14 06:30:00 | ES | Futures | 1122.41 | 1123.87 | 1120.69 | 1123.63 | 13803.0 |
| 2010-05-14 07:00:00 | ES | Futures | 1123.63 | 1124.85 | 1122.65 | 1123.38 | 16050.0 |
| 2010-05-14 07:30:00 | ES | Futures | 1123.63 | 1124.85 | 1121.92 | 1122.41 | 16469.0 |
| 2010-05-14 08:00:00 | ES | Futures | 1122.41 | 1122.89 | 1119.47 | 1120.94 | 32235.0 |
| 2010-05-14 08:30:00 | ES | Futures | 1120.94 | 1124.36 | 1118.74 | 1122.16 | 64503.0 |
| 2010-05-14 09:00:00 | ES | Futures | 1121.92 | 1122.16 | 1118.49 | 1120.69 | 56655.0 |
| 2010-05-14 09:30:00 | ES | Futures | 1120.69 | 1122.89 | 1109.45 | 1111.9 | 351743.0 |
| 2010-05-14 10:00:00 | ES | Futures | 1111.9 | 1116.54 | 1107.01 | 1113.61 | 276242.0 |
| 2010-05-14 10:30:00 | ES | Futures | 1113.61 | 1114.58 | 1108.96 | 1111.41 | 160156.0 |
| 2010-05-14 11:00:00 | ES | Futures | 1111.41 | 1111.65 | 1100.41 | 1104.32 | 334700.0 |
| 2010-05-14 11:30:00 | ES | Futures | 1104.56 | 1107.5 | 1102.12 | 1103.58 | 177024.0 |
| 2010-05-14 12:00:00 | ES | Futures | 1103.83 | 1105.54 | 1098.7 | 1103.58 | 173820.0 |
| 2010-05-14 12:30:00 | ES | Futures | 1103.34 | 1107.98 | 1102.85 | 1107.5 | 110950.0 |
| 2010-05-14 13:00:00 | ES | Futures | 1107.5 | 1109.21 | 1103.58 | 1104.81 | 90308.0 |
| 2010-05-14 13:30:00 | ES | Futures | 1105.05 | 1106.52 | 1101.87 | 1104.32 | 108476.0 |
| 2010-05-14 14:00:00 | ES | Futures | 1104.56 | 1105.54 | 1099.43 | 1103.34 | 112098.0 |
| 2010-05-14 14:30:00 | ES | Futures | 1103.34 | 1106.27 | 1101.87 | 1102.85 | 100953.0 |
| 2010-05-14 15:00:00 | ES | Futures | 1102.61 | 1104.81 | 1098.94 | 1101.63 | 135635.0 |
| 2010-05-14 15:30:00 | ES | Futures | 1101.87 | 1110.92 | 1100.41 | 1108.96 | 316779.0 |
| 2010-05-14 16:00:00 | ES | Futures | 1108.72 | 1110.67 | 1107.98 | 1109.94 | 110915.0 |
| 2010-05-14 00:00:00 | NQ | Futures | 2230.27 | 2232.56 | 2229.7 | 2231.42 | 144.0 |
| 2010-05-14 00:30:00 | NQ | Futures | 2231.42 | 2233.13 | 2230.84 | 2232.85 | 138.0 |
| 2010-05-14 01:00:00 | NQ | Futures | 2232.27 | 2233.99 | 2231.7 | 2233.71 | 101.0 |
| 2010-05-14 01:30:00 | NQ | Futures | 2233.71 | 2233.99 | 2229.41 | 2231.7 | 191.0 |
| 2010-05-14 02:00:00 | NQ | Futures | 2231.42 | 2232.85 | 2229.12 | 2229.12 | 468.0 |
| 2010-05-14 02:30:00 | NQ | Futures | 2229.12 | 2234.28 | 2228.84 | 2233.13 | 475.0 |
| 2010-05-14 03:00:00 | NQ | Futures | 2232.85 | 2233.13 | 2227.98 | 2227.98 | 1420.0 |
| 2010-05-14 03:30:00 | NQ | Futures | 2227.98 | 2227.98 | 2223.97 | 2225.4 | 1206.0 |
| 2010-05-14 04:00:00 | NQ | Futures | 2225.4 | 2226.55 | 2220.53 | 2222.25 | 1252.0 |
| 2010-05-14 04:30:00 | NQ | Futures | 2222.25 | 2226.83 | 2218.81 | 2219.1 | 977.0 |
| 2010-05-14 05:00:00 | NQ | Futures | 2219.1 | 2220.82 | 2213.95 | 2218.53 | 1776.0 |
| 2010-05-14 05:30:00 | NQ | Futures | 2218.24 | 2218.81 | 2211.66 | 2214.52 | 1063.0 |
| 2010-05-14 06:00:00 | NQ | Futures | 2214.81 | 2218.24 | 2211.94 | 2217.1 | 946.0 |
| 2010-05-14 06:30:00 | NQ | Futures | 2216.81 | 2218.53 | 2213.09 | 2218.24 | 526.0 |
| 2010-05-14 07:00:00 | NQ | Futures | 2218.53 | 2219.96 | 2215.38 | 2217.1 | 1079.0 |
| 2010-05-14 07:30:00 | NQ | Futures | 2217.38 | 2219.67 | 2214.81 | 2215.38 | 1073.0 |
| 2010-05-14 08:00:00 | NQ | Futures | 2215.66 | 2216.24 | 2209.94 | 2211.94 | 3067.0 |
> showing 50 of 2,099 rows — these rows as CSV