PREVIEW / futures_30min / 2010-10-21
file: by_date/futures_30min/2010/2010-10-21.parquet size: 75 KB rows: 2,645
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-21 00:00:00 | ES | Futures | 1158.45 | 1158.94 | 1157.71 | 1157.96 | 1129.0 |
| 2010-10-21 00:30:00 | ES | Futures | 1158.2 | 1158.2 | 1157.22 | 1157.71 | 1441.0 |
| 2010-10-21 01:00:00 | ES | Futures | 1157.96 | 1157.96 | 1156.48 | 1157.46 | 2831.0 |
| 2010-10-21 01:30:00 | ES | Futures | 1157.46 | 1158.45 | 1157.22 | 1157.71 | 1536.0 |
| 2010-10-21 02:00:00 | ES | Futures | 1157.71 | 1158.7 | 1157.46 | 1158.2 | 4300.0 |
| 2010-10-21 02:30:00 | ES | Futures | 1158.2 | 1158.2 | 1156.23 | 1156.48 | 4547.0 |
| 2010-10-21 03:00:00 | ES | Futures | 1156.48 | 1159.44 | 1155.49 | 1159.19 | 15698.0 |
| 2010-10-21 03:30:00 | ES | Futures | 1159.19 | 1161.65 | 1159.19 | 1160.92 | 18338.0 |
| 2010-10-21 04:00:00 | ES | Futures | 1160.92 | 1162.39 | 1160.92 | 1161.9 | 16011.0 |
| 2010-10-21 04:30:00 | ES | Futures | 1161.9 | 1162.15 | 1160.92 | 1161.16 | 6427.0 |
| 2010-10-21 05:00:00 | ES | Futures | 1161.16 | 1162.39 | 1160.92 | 1161.41 | 7313.0 |
| 2010-10-21 05:30:00 | ES | Futures | 1161.41 | 1162.64 | 1161.41 | 1161.41 | 9220.0 |
| 2010-10-21 06:00:00 | ES | Futures | 1161.16 | 1162.64 | 1161.16 | 1162.39 | 8444.0 |
| 2010-10-21 06:30:00 | ES | Futures | 1162.39 | 1164.12 | 1162.15 | 1163.63 | 15991.0 |
| 2010-10-21 07:00:00 | ES | Futures | 1163.87 | 1164.86 | 1163.38 | 1164.37 | 12514.0 |
| 2010-10-21 07:30:00 | ES | Futures | 1164.12 | 1165.85 | 1163.63 | 1163.87 | 30137.0 |
| 2010-10-21 08:00:00 | ES | Futures | 1164.12 | 1164.12 | 1162.89 | 1163.38 | 18141.0 |
| 2010-10-21 08:30:00 | ES | Futures | 1163.38 | 1165.35 | 1161.65 | 1163.13 | 57801.0 |
| 2010-10-21 09:00:00 | ES | Futures | 1163.38 | 1163.38 | 1160.92 | 1162.89 | 38441.0 |
| 2010-10-21 09:30:00 | ES | Futures | 1162.64 | 1165.11 | 1160.67 | 1164.86 | 167143.0 |
| 2010-10-21 10:00:00 | ES | Futures | 1164.61 | 1169.05 | 1161.9 | 1166.83 | 249875.0 |
| 2010-10-21 10:30:00 | ES | Futures | 1167.08 | 1169.54 | 1166.83 | 1169.05 | 157976.0 |
| 2010-10-21 11:00:00 | ES | Futures | 1169.05 | 1169.54 | 1162.89 | 1164.37 | 158593.0 |
| 2010-10-21 11:30:00 | ES | Futures | 1164.37 | 1165.11 | 1159.44 | 1163.13 | 202244.0 |
| 2010-10-21 12:00:00 | ES | Futures | 1163.13 | 1163.63 | 1161.16 | 1163.13 | 90030.0 |
| 2010-10-21 12:30:00 | ES | Futures | 1163.13 | 1163.13 | 1158.2 | 1159.68 | 147034.0 |
| 2010-10-21 13:00:00 | ES | Futures | 1159.68 | 1162.15 | 1159.68 | 1161.16 | 84033.0 |
| 2010-10-21 13:30:00 | ES | Futures | 1160.92 | 1161.16 | 1151.3 | 1152.29 | 191167.0 |
| 2010-10-21 14:00:00 | ES | Futures | 1152.29 | 1155.0 | 1150.81 | 1154.26 | 153397.0 |
| 2010-10-21 14:30:00 | ES | Futures | 1154.51 | 1157.46 | 1154.01 | 1156.73 | 111206.0 |
| 2010-10-21 15:00:00 | ES | Futures | 1156.73 | 1160.92 | 1155.74 | 1159.93 | 142812.0 |
| 2010-10-21 15:30:00 | ES | Futures | 1159.68 | 1160.92 | 1157.46 | 1159.93 | 145390.0 |
| 2010-10-21 16:00:00 | ES | Futures | 1159.93 | 1160.42 | 1158.7 | 1159.19 | 75634.0 |
| 2010-10-21 16:30:00 | ES | Futures | 1158.7 | 1158.7 | 1157.71 | 1158.45 | 3894.0 |
| 2010-10-21 17:00:00 | ES | Futures | 1158.45 | 1159.19 | 1158.2 | 1158.94 | 2433.0 |
| 2010-10-21 18:00:00 | ES | Futures | 1158.94 | 1159.68 | 1158.45 | 1159.44 | 1838.0 |
| 2010-10-21 18:30:00 | ES | Futures | 1159.44 | 1159.44 | 1158.7 | 1158.94 | 1042.0 |
| 2010-10-21 19:00:00 | ES | Futures | 1159.19 | 1159.44 | 1158.7 | 1158.94 | 1201.0 |
| 2010-10-21 19:30:00 | ES | Futures | 1158.94 | 1159.44 | 1158.94 | 1159.44 | 1248.0 |
| 2010-10-21 20:00:00 | ES | Futures | 1159.44 | 1159.93 | 1159.19 | 1159.68 | 4796.0 |
| 2010-10-21 20:30:00 | ES | Futures | 1159.93 | 1160.67 | 1159.68 | 1160.18 | 3307.0 |
| 2010-10-21 21:00:00 | ES | Futures | 1160.18 | 1160.67 | 1159.44 | 1160.42 | 2229.0 |
| 2010-10-21 21:30:00 | ES | Futures | 1160.42 | 1160.67 | 1159.44 | 1159.68 | 1273.0 |
| 2010-10-21 22:00:00 | ES | Futures | 1159.93 | 1160.18 | 1159.44 | 1159.68 | 938.0 |
| 2010-10-21 22:30:00 | ES | Futures | 1159.93 | 1160.42 | 1159.68 | 1160.18 | 561.0 |
| 2010-10-21 23:00:00 | ES | Futures | 1160.18 | 1160.92 | 1160.18 | 1160.42 | 1017.0 |
| 2010-10-21 23:30:00 | ES | Futures | 1160.42 | 1160.67 | 1160.18 | 1160.18 | 477.0 |
| 2010-10-21 00:00:00 | NQ | Futures | 2392.48 | 2393.34 | 2391.91 | 2392.77 | 69.0 |
| 2010-10-21 00:30:00 | NQ | Futures | 2392.48 | 2392.77 | 2391.05 | 2392.48 | 95.0 |
| 2010-10-21 01:00:00 | NQ | Futures | 2392.19 | 2392.77 | 2390.76 | 2391.33 | 205.0 |
> showing 50 of 2,645 rows — these rows as CSV