PREVIEW / futures_30min / 2010-11-23
file: by_date/futures_30min/2010/2010-11-23.parquet size: 76 KB rows: 2,597
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-23 00:00:00 | ES | Futures | 1176.44 | 1176.69 | 1175.95 | 1176.2 | 2055.0 |
| 2010-11-23 00:30:00 | ES | Futures | 1176.2 | 1177.43 | 1176.2 | 1176.69 | 2992.0 |
| 2010-11-23 01:00:00 | ES | Futures | 1176.69 | 1176.69 | 1170.77 | 1171.02 | 20974.0 |
| 2010-11-23 01:30:00 | ES | Futures | 1170.77 | 1173.24 | 1169.3 | 1171.02 | 12824.0 |
| 2010-11-23 02:00:00 | ES | Futures | 1171.27 | 1172.99 | 1170.28 | 1170.77 | 12118.0 |
| 2010-11-23 02:30:00 | ES | Futures | 1171.02 | 1171.51 | 1169.79 | 1170.77 | 10117.0 |
| 2010-11-23 03:00:00 | ES | Futures | 1171.02 | 1172.01 | 1168.31 | 1171.27 | 24701.0 |
| 2010-11-23 03:30:00 | ES | Futures | 1171.51 | 1173.24 | 1169.79 | 1172.75 | 17557.0 |
| 2010-11-23 04:00:00 | ES | Futures | 1172.5 | 1174.72 | 1171.76 | 1173.24 | 16494.0 |
| 2010-11-23 04:30:00 | ES | Futures | 1173.49 | 1174.47 | 1172.01 | 1172.5 | 9516.0 |
| 2010-11-23 05:00:00 | ES | Futures | 1172.75 | 1172.99 | 1170.53 | 1172.5 | 7939.0 |
| 2010-11-23 05:30:00 | ES | Futures | 1172.25 | 1172.99 | 1170.77 | 1172.75 | 10706.0 |
| 2010-11-23 06:00:00 | ES | Futures | 1172.75 | 1174.96 | 1172.01 | 1172.25 | 14200.0 |
| 2010-11-23 06:30:00 | ES | Futures | 1172.25 | 1172.5 | 1171.02 | 1172.01 | 17884.0 |
| 2010-11-23 07:00:00 | ES | Futures | 1172.01 | 1172.75 | 1167.57 | 1168.31 | 24337.0 |
| 2010-11-23 07:30:00 | ES | Futures | 1168.06 | 1168.8 | 1166.34 | 1166.83 | 33429.0 |
| 2010-11-23 08:00:00 | ES | Futures | 1166.83 | 1168.8 | 1165.85 | 1168.06 | 34593.0 |
| 2010-11-23 08:30:00 | ES | Futures | 1168.31 | 1169.79 | 1166.58 | 1167.57 | 62684.0 |
| 2010-11-23 09:00:00 | ES | Futures | 1167.82 | 1169.3 | 1165.85 | 1166.09 | 35771.0 |
| 2010-11-23 09:30:00 | ES | Futures | 1166.09 | 1168.31 | 1160.92 | 1161.9 | 322458.0 |
| 2010-11-23 10:00:00 | ES | Futures | 1161.65 | 1165.11 | 1160.42 | 1163.63 | 210962.0 |
| 2010-11-23 10:30:00 | ES | Futures | 1163.63 | 1166.34 | 1162.89 | 1165.6 | 144492.0 |
| 2010-11-23 11:00:00 | ES | Futures | 1165.6 | 1165.6 | 1159.44 | 1159.68 | 184210.0 |
| 2010-11-23 11:30:00 | ES | Futures | 1159.68 | 1161.9 | 1158.2 | 1161.41 | 154360.0 |
| 2010-11-23 12:00:00 | ES | Futures | 1161.41 | 1163.13 | 1159.93 | 1162.15 | 108349.0 |
| 2010-11-23 12:30:00 | ES | Futures | 1162.15 | 1164.86 | 1160.67 | 1164.61 | 100086.0 |
| 2010-11-23 13:00:00 | ES | Futures | 1164.61 | 1164.86 | 1162.64 | 1164.86 | 67542.0 |
| 2010-11-23 13:30:00 | ES | Futures | 1164.86 | 1165.6 | 1161.16 | 1161.9 | 92839.0 |
| 2010-11-23 14:00:00 | ES | Futures | 1161.9 | 1163.87 | 1159.93 | 1161.41 | 124469.0 |
| 2010-11-23 14:30:00 | ES | Futures | 1161.41 | 1162.89 | 1159.93 | 1161.9 | 76627.0 |
| 2010-11-23 15:00:00 | ES | Futures | 1161.65 | 1163.87 | 1161.16 | 1162.39 | 143697.0 |
| 2010-11-23 15:30:00 | ES | Futures | 1162.39 | 1163.87 | 1161.16 | 1162.39 | 190124.0 |
| 2010-11-23 16:00:00 | ES | Futures | 1162.64 | 1163.38 | 1161.16 | 1161.16 | 108783.0 |
| 2010-11-23 16:30:00 | ES | Futures | 1161.41 | 1162.15 | 1159.44 | 1160.18 | 11466.0 |
| 2010-11-23 17:00:00 | ES | Futures | 1160.18 | 1160.42 | 1159.19 | 1160.18 | 4088.0 |
| 2010-11-23 18:00:00 | ES | Futures | 1160.42 | 1163.38 | 1160.42 | 1162.89 | 9461.0 |
| 2010-11-23 18:30:00 | ES | Futures | 1162.89 | 1165.11 | 1161.9 | 1164.61 | 10420.0 |
| 2010-11-23 19:00:00 | ES | Futures | 1164.37 | 1165.35 | 1163.87 | 1165.11 | 14926.0 |
| 2010-11-23 19:30:00 | ES | Futures | 1164.86 | 1166.09 | 1164.86 | 1165.6 | 12993.0 |
| 2010-11-23 20:00:00 | ES | Futures | 1165.35 | 1166.83 | 1165.11 | 1166.34 | 7784.0 |
| 2010-11-23 20:30:00 | ES | Futures | 1166.34 | 1167.57 | 1166.09 | 1167.32 | 8910.0 |
| 2010-11-23 21:00:00 | ES | Futures | 1167.57 | 1168.56 | 1166.58 | 1168.06 | 7449.0 |
| 2010-11-23 21:30:00 | ES | Futures | 1168.31 | 1168.56 | 1167.32 | 1167.32 | 4345.0 |
| 2010-11-23 22:00:00 | ES | Futures | 1167.32 | 1167.82 | 1166.34 | 1166.58 | 6065.0 |
| 2010-11-23 22:30:00 | ES | Futures | 1166.34 | 1166.83 | 1166.09 | 1166.58 | 1993.0 |
| 2010-11-23 23:00:00 | ES | Futures | 1166.34 | 1166.83 | 1165.6 | 1166.58 | 1181.0 |
| 2010-11-23 23:30:00 | ES | Futures | 1166.34 | 1167.32 | 1165.85 | 1167.32 | 1769.0 |
| 2010-11-23 00:00:00 | NQ | Futures | 2465.07 | 2465.35 | 2464.21 | 2465.35 | 94.0 |
| 2010-11-23 00:30:00 | NQ | Futures | 2465.35 | 2466.79 | 2465.07 | 2465.64 | 357.0 |
| 2010-11-23 01:00:00 | NQ | Futures | 2465.64 | 2465.64 | 2456.46 | 2456.46 | 1230.0 |
> showing 50 of 2,597 rows — these rows as CSV