PREVIEW / futures_30min / 2010-05-03
file: by_date/futures_30min/2010/2010-05-03.parquet size: 65 KB rows: 2,367
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-03 00:00:00 | ES | Futures | 1158.09 | 1158.34 | 1157.6 | 1157.85 | 1274.0 |
| 2010-05-03 00:30:00 | ES | Futures | 1157.85 | 1159.07 | 1157.36 | 1158.82 | 1553.0 |
| 2010-05-03 01:00:00 | ES | Futures | 1159.07 | 1159.56 | 1158.82 | 1159.31 | 1365.0 |
| 2010-05-03 01:30:00 | ES | Futures | 1159.31 | 1160.05 | 1158.09 | 1158.58 | 2295.0 |
| 2010-05-03 02:00:00 | ES | Futures | 1158.34 | 1161.02 | 1158.34 | 1160.54 | 7427.0 |
| 2010-05-03 02:30:00 | ES | Futures | 1160.29 | 1161.76 | 1160.29 | 1161.76 | 4819.0 |
| 2010-05-03 03:00:00 | ES | Futures | 1161.76 | 1162.0 | 1157.85 | 1158.58 | 16349.0 |
| 2010-05-03 03:30:00 | ES | Futures | 1158.58 | 1161.27 | 1158.34 | 1160.78 | 7801.0 |
| 2010-05-03 04:00:00 | ES | Futures | 1160.78 | 1161.51 | 1159.8 | 1161.02 | 6730.0 |
| 2010-05-03 04:30:00 | ES | Futures | 1160.78 | 1161.76 | 1160.29 | 1160.54 | 12278.0 |
| 2010-05-03 05:00:00 | ES | Futures | 1160.54 | 1161.02 | 1158.09 | 1158.82 | 8317.0 |
| 2010-05-03 05:30:00 | ES | Futures | 1159.07 | 1160.05 | 1158.82 | 1159.07 | 6100.0 |
| 2010-05-03 06:00:00 | ES | Futures | 1159.07 | 1161.02 | 1158.58 | 1161.02 | 5040.0 |
| 2010-05-03 06:30:00 | ES | Futures | 1161.02 | 1162.0 | 1160.54 | 1161.76 | 5268.0 |
| 2010-05-03 07:00:00 | ES | Futures | 1161.76 | 1163.22 | 1161.76 | 1162.25 | 9909.0 |
| 2010-05-03 07:30:00 | ES | Futures | 1162.25 | 1162.25 | 1161.27 | 1162.0 | 7494.0 |
| 2010-05-03 08:00:00 | ES | Futures | 1162.0 | 1162.98 | 1161.27 | 1161.76 | 14119.0 |
| 2010-05-03 08:30:00 | ES | Futures | 1161.76 | 1163.47 | 1161.76 | 1162.25 | 15579.0 |
| 2010-05-03 09:00:00 | ES | Futures | 1162.0 | 1162.74 | 1161.51 | 1162.49 | 20160.0 |
| 2010-05-03 09:30:00 | ES | Futures | 1162.49 | 1165.67 | 1162.0 | 1165.18 | 163027.0 |
| 2010-05-03 10:00:00 | ES | Futures | 1165.18 | 1166.65 | 1162.74 | 1165.18 | 146228.0 |
| 2010-05-03 10:30:00 | ES | Futures | 1165.42 | 1165.42 | 1160.54 | 1162.0 | 156477.0 |
| 2010-05-03 11:00:00 | ES | Futures | 1161.76 | 1164.94 | 1161.51 | 1164.69 | 80811.0 |
| 2010-05-03 11:30:00 | ES | Futures | 1164.45 | 1167.14 | 1163.96 | 1166.16 | 84469.0 |
| 2010-05-03 12:00:00 | ES | Futures | 1166.4 | 1171.29 | 1165.42 | 1171.05 | 127007.0 |
| 2010-05-03 12:30:00 | ES | Futures | 1170.8 | 1173.98 | 1170.8 | 1173.98 | 148339.0 |
| 2010-05-03 13:00:00 | ES | Futures | 1173.73 | 1173.98 | 1171.54 | 1171.78 | 75638.0 |
| 2010-05-03 13:30:00 | ES | Futures | 1171.78 | 1175.2 | 1171.78 | 1173.73 | 83671.0 |
| 2010-05-03 14:00:00 | ES | Futures | 1173.73 | 1175.2 | 1172.27 | 1175.2 | 70893.0 |
| 2010-05-03 14:30:00 | ES | Futures | 1175.2 | 1175.2 | 1172.76 | 1174.47 | 64415.0 |
| 2010-05-03 15:00:00 | ES | Futures | 1174.71 | 1175.2 | 1170.31 | 1171.29 | 146678.0 |
| 2010-05-03 15:30:00 | ES | Futures | 1171.29 | 1173.0 | 1171.05 | 1172.27 | 154673.0 |
| 2010-05-03 16:00:00 | ES | Futures | 1172.02 | 1172.76 | 1171.54 | 1171.78 | 98206.0 |
| 2010-05-03 16:30:00 | ES | Futures | 1171.54 | 1171.78 | 1169.82 | 1171.05 | 5846.0 |
| 2010-05-03 17:00:00 | ES | Futures | 1171.05 | 1171.54 | 1170.56 | 1171.29 | 1261.0 |
| 2010-05-03 18:00:00 | ES | Futures | 1171.05 | 1171.54 | 1170.56 | 1171.29 | 1867.0 |
| 2010-05-03 18:30:00 | ES | Futures | 1171.29 | 1171.78 | 1171.05 | 1171.54 | 900.0 |
| 2010-05-03 19:00:00 | ES | Futures | 1171.29 | 1172.02 | 1171.05 | 1171.05 | 1083.0 |
| 2010-05-03 19:30:00 | ES | Futures | 1171.29 | 1171.29 | 1170.8 | 1171.05 | 622.0 |
| 2010-05-03 20:00:00 | ES | Futures | 1171.29 | 1171.78 | 1171.05 | 1171.29 | 929.0 |
| 2010-05-03 20:30:00 | ES | Futures | 1171.29 | 1173.0 | 1171.05 | 1172.76 | 2516.0 |
| 2010-05-03 21:00:00 | ES | Futures | 1172.51 | 1173.0 | 1172.02 | 1172.02 | 1485.0 |
| 2010-05-03 21:30:00 | ES | Futures | 1172.02 | 1172.27 | 1171.54 | 1171.78 | 1213.0 |
| 2010-05-03 22:00:00 | ES | Futures | 1171.78 | 1171.78 | 1170.8 | 1171.05 | 1639.0 |
| 2010-05-03 22:30:00 | ES | Futures | 1171.05 | 1171.05 | 1170.07 | 1170.31 | 2334.0 |
| 2010-05-03 23:00:00 | ES | Futures | 1170.56 | 1170.8 | 1170.31 | 1170.8 | 762.0 |
| 2010-05-03 23:30:00 | ES | Futures | 1170.8 | 1170.8 | 1170.56 | 1170.8 | 279.0 |
| 2010-05-03 00:00:00 | NQ | Futures | 2293.27 | 2294.13 | 2292.99 | 2293.56 | 57.0 |
| 2010-05-03 00:30:00 | NQ | Futures | 2293.27 | 2294.99 | 2292.99 | 2294.99 | 89.0 |
| 2010-05-03 01:00:00 | NQ | Futures | 2295.28 | 2295.85 | 2294.99 | 2294.99 | 99.0 |
> showing 50 of 2,367 rows — these rows as CSV