PREVIEW / futures_30min / 2010-11-17
file: by_date/futures_30min/2010/2010-11-17.parquet size: 76 KB rows: 2,693
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-11-17 00:00:00 | ES | Futures | 1162.64 | 1162.89 | 1161.65 | 1161.9 | 2536.0 |
| 2010-11-17 00:30:00 | ES | Futures | 1161.65 | 1162.89 | 1161.65 | 1162.64 | 1565.0 |
| 2010-11-17 01:00:00 | ES | Futures | 1162.64 | 1163.13 | 1161.65 | 1161.65 | 2711.0 |
| 2010-11-17 01:30:00 | ES | Futures | 1161.9 | 1161.9 | 1160.67 | 1160.92 | 4169.0 |
| 2010-11-17 02:00:00 | ES | Futures | 1160.67 | 1161.16 | 1159.19 | 1159.93 | 7130.0 |
| 2010-11-17 02:30:00 | ES | Futures | 1159.93 | 1160.18 | 1157.22 | 1157.46 | 13626.0 |
| 2010-11-17 03:00:00 | ES | Futures | 1157.46 | 1159.93 | 1156.73 | 1159.68 | 21024.0 |
| 2010-11-17 03:30:00 | ES | Futures | 1159.93 | 1160.42 | 1158.7 | 1160.18 | 15550.0 |
| 2010-11-17 04:00:00 | ES | Futures | 1160.18 | 1163.13 | 1159.68 | 1162.64 | 25090.0 |
| 2010-11-17 04:30:00 | ES | Futures | 1162.64 | 1163.13 | 1161.65 | 1162.15 | 13183.0 |
| 2010-11-17 05:00:00 | ES | Futures | 1162.15 | 1163.13 | 1161.65 | 1162.64 | 11275.0 |
| 2010-11-17 05:30:00 | ES | Futures | 1162.64 | 1164.37 | 1162.15 | 1163.87 | 19223.0 |
| 2010-11-17 06:00:00 | ES | Futures | 1163.87 | 1164.37 | 1161.16 | 1161.41 | 14310.0 |
| 2010-11-17 06:30:00 | ES | Futures | 1161.41 | 1161.9 | 1160.18 | 1160.67 | 10978.0 |
| 2010-11-17 07:00:00 | ES | Futures | 1160.92 | 1160.92 | 1158.7 | 1158.94 | 18620.0 |
| 2010-11-17 07:30:00 | ES | Futures | 1158.7 | 1163.13 | 1158.7 | 1161.41 | 27303.0 |
| 2010-11-17 08:00:00 | ES | Futures | 1161.65 | 1162.15 | 1160.92 | 1161.16 | 15436.0 |
| 2010-11-17 08:30:00 | ES | Futures | 1161.16 | 1164.12 | 1159.19 | 1160.67 | 69932.0 |
| 2010-11-17 09:00:00 | ES | Futures | 1160.67 | 1161.9 | 1159.44 | 1160.42 | 31346.0 |
| 2010-11-17 09:30:00 | ES | Futures | 1160.42 | 1162.15 | 1156.97 | 1161.41 | 255116.0 |
| 2010-11-17 10:00:00 | ES | Futures | 1161.41 | 1165.11 | 1161.16 | 1164.37 | 168858.0 |
| 2010-11-17 10:30:00 | ES | Futures | 1164.61 | 1165.35 | 1161.41 | 1162.15 | 179571.0 |
| 2010-11-17 11:00:00 | ES | Futures | 1162.15 | 1164.37 | 1160.92 | 1163.63 | 138510.0 |
| 2010-11-17 11:30:00 | ES | Futures | 1163.63 | 1164.61 | 1161.16 | 1163.87 | 121256.0 |
| 2010-11-17 12:00:00 | ES | Futures | 1163.87 | 1164.61 | 1161.9 | 1162.64 | 64149.0 |
| 2010-11-17 12:30:00 | ES | Futures | 1162.89 | 1163.38 | 1161.9 | 1162.15 | 46951.0 |
| 2010-11-17 13:00:00 | ES | Futures | 1162.15 | 1164.12 | 1161.41 | 1164.12 | 49982.0 |
| 2010-11-17 13:30:00 | ES | Futures | 1163.87 | 1164.86 | 1161.65 | 1163.13 | 63493.0 |
| 2010-11-17 14:00:00 | ES | Futures | 1163.13 | 1163.87 | 1161.65 | 1162.64 | 52670.0 |
| 2010-11-17 14:30:00 | ES | Futures | 1162.64 | 1163.87 | 1161.65 | 1162.39 | 62236.0 |
| 2010-11-17 15:00:00 | ES | Futures | 1162.15 | 1162.89 | 1157.22 | 1157.71 | 199138.0 |
| 2010-11-17 15:30:00 | ES | Futures | 1157.71 | 1161.9 | 1157.71 | 1160.42 | 168415.0 |
| 2010-11-17 16:00:00 | ES | Futures | 1160.67 | 1161.41 | 1160.18 | 1161.16 | 60363.0 |
| 2010-11-17 16:30:00 | ES | Futures | 1161.16 | 1161.41 | 1160.42 | 1160.67 | 5856.0 |
| 2010-11-17 17:00:00 | ES | Futures | 1160.67 | 1160.92 | 1160.42 | 1160.92 | 1437.0 |
| 2010-11-17 18:00:00 | ES | Futures | 1161.16 | 1162.64 | 1160.92 | 1161.9 | 4292.0 |
| 2010-11-17 18:30:00 | ES | Futures | 1162.15 | 1163.13 | 1162.15 | 1162.64 | 2559.0 |
| 2010-11-17 19:00:00 | ES | Futures | 1162.64 | 1163.13 | 1162.64 | 1163.13 | 1516.0 |
| 2010-11-17 19:30:00 | ES | Futures | 1162.89 | 1164.86 | 1162.89 | 1164.37 | 4885.0 |
| 2010-11-17 20:00:00 | ES | Futures | 1164.12 | 1166.58 | 1164.12 | 1166.58 | 8960.0 |
| 2010-11-17 20:30:00 | ES | Futures | 1166.58 | 1167.57 | 1165.35 | 1165.35 | 8467.0 |
| 2010-11-17 21:00:00 | ES | Futures | 1165.6 | 1168.06 | 1165.35 | 1167.57 | 11993.0 |
| 2010-11-17 21:30:00 | ES | Futures | 1167.32 | 1168.06 | 1166.58 | 1167.08 | 7423.0 |
| 2010-11-17 22:00:00 | ES | Futures | 1166.83 | 1169.79 | 1166.83 | 1169.05 | 10738.0 |
| 2010-11-17 22:30:00 | ES | Futures | 1169.05 | 1169.79 | 1168.56 | 1169.05 | 7619.0 |
| 2010-11-17 23:00:00 | ES | Futures | 1169.05 | 1169.3 | 1168.06 | 1169.3 | 2794.0 |
| 2010-11-17 23:30:00 | ES | Futures | 1169.3 | 1170.04 | 1168.8 | 1169.54 | 2785.0 |
| 2010-11-17 00:00:00 | NQ | Futures | 2409.12 | 2409.12 | 2407.69 | 2408.26 | 46.0 |
| 2010-11-17 00:30:00 | NQ | Futures | 2407.69 | 2408.55 | 2407.69 | 2407.97 | 52.0 |
| 2010-11-17 01:00:00 | NQ | Futures | 2408.55 | 2409.12 | 2407.4 | 2407.4 | 82.0 |
> showing 50 of 2,693 rows — these rows as CSV