PREVIEW / futures_30min / 2010-04-09
file: by_date/futures_30min/2010/2010-04-09.parquet size: 59 KB rows: 2,061
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-04-09 00:00:00 | ES | Futures | 1157.36 | 1157.6 | 1157.11 | 1157.36 | 725.0 |
| 2010-04-09 00:30:00 | ES | Futures | 1157.36 | 1157.36 | 1156.87 | 1156.87 | 392.0 |
| 2010-04-09 01:00:00 | ES | Futures | 1157.11 | 1157.36 | 1156.87 | 1157.36 | 283.0 |
| 2010-04-09 01:30:00 | ES | Futures | 1157.11 | 1157.6 | 1157.11 | 1157.11 | 606.0 |
| 2010-04-09 02:00:00 | ES | Futures | 1157.36 | 1157.36 | 1156.87 | 1157.36 | 1531.0 |
| 2010-04-09 02:30:00 | ES | Futures | 1157.11 | 1158.09 | 1157.11 | 1157.85 | 4198.0 |
| 2010-04-09 03:00:00 | ES | Futures | 1158.09 | 1160.78 | 1158.09 | 1160.29 | 17235.0 |
| 2010-04-09 03:30:00 | ES | Futures | 1160.29 | 1160.78 | 1159.8 | 1160.05 | 8591.0 |
| 2010-04-09 04:00:00 | ES | Futures | 1159.8 | 1160.54 | 1159.8 | 1160.05 | 3861.0 |
| 2010-04-09 04:30:00 | ES | Futures | 1160.05 | 1160.54 | 1159.8 | 1159.8 | 4480.0 |
| 2010-04-09 05:00:00 | ES | Futures | 1159.8 | 1160.05 | 1159.31 | 1159.56 | 3768.0 |
| 2010-04-09 05:30:00 | ES | Futures | 1159.31 | 1159.31 | 1158.58 | 1159.07 | 4662.0 |
| 2010-04-09 06:00:00 | ES | Futures | 1159.07 | 1159.8 | 1158.82 | 1159.56 | 3084.0 |
| 2010-04-09 06:30:00 | ES | Futures | 1159.8 | 1160.05 | 1159.31 | 1160.05 | 4441.0 |
| 2010-04-09 07:00:00 | ES | Futures | 1160.05 | 1160.78 | 1159.8 | 1160.05 | 9471.0 |
| 2010-04-09 07:30:00 | ES | Futures | 1160.05 | 1160.29 | 1159.56 | 1159.8 | 8411.0 |
| 2010-04-09 08:00:00 | ES | Futures | 1159.8 | 1160.29 | 1159.56 | 1160.05 | 9665.0 |
| 2010-04-09 08:30:00 | ES | Futures | 1160.29 | 1160.29 | 1159.31 | 1159.31 | 13910.0 |
| 2010-04-09 09:00:00 | ES | Futures | 1159.31 | 1159.56 | 1158.58 | 1159.07 | 20189.0 |
| 2010-04-09 09:30:00 | ES | Futures | 1158.82 | 1160.29 | 1156.87 | 1160.05 | 221803.0 |
| 2010-04-09 10:00:00 | ES | Futures | 1160.29 | 1161.76 | 1156.63 | 1158.09 | 166766.0 |
| 2010-04-09 10:30:00 | ES | Futures | 1158.34 | 1160.54 | 1157.36 | 1158.58 | 150788.0 |
| 2010-04-09 11:00:00 | ES | Futures | 1158.82 | 1161.51 | 1158.34 | 1161.27 | 89434.0 |
| 2010-04-09 11:30:00 | ES | Futures | 1161.51 | 1162.25 | 1160.54 | 1161.27 | 92488.0 |
| 2010-04-09 12:00:00 | ES | Futures | 1161.51 | 1162.25 | 1161.02 | 1161.76 | 30917.0 |
| 2010-04-09 12:30:00 | ES | Futures | 1161.76 | 1162.0 | 1160.29 | 1160.78 | 29767.0 |
| 2010-04-09 13:00:00 | ES | Futures | 1160.54 | 1161.02 | 1158.82 | 1160.54 | 57632.0 |
| 2010-04-09 13:30:00 | ES | Futures | 1160.78 | 1161.27 | 1159.07 | 1159.56 | 36854.0 |
| 2010-04-09 14:00:00 | ES | Futures | 1159.56 | 1161.27 | 1158.58 | 1160.78 | 54370.0 |
| 2010-04-09 14:30:00 | ES | Futures | 1160.78 | 1161.51 | 1160.05 | 1160.78 | 35664.0 |
| 2010-04-09 15:00:00 | ES | Futures | 1161.02 | 1162.25 | 1160.05 | 1162.25 | 53706.0 |
| 2010-04-09 15:30:00 | ES | Futures | 1162.0 | 1164.69 | 1161.51 | 1164.2 | 169349.0 |
| 2010-04-09 16:00:00 | ES | Futures | 1164.2 | 1166.4 | 1163.96 | 1166.4 | 114997.0 |
| 2010-04-09 00:00:00 | NQ | Futures | 2267.21 | 2267.21 | 2266.64 | 2267.21 | 39.0 |
| 2010-04-09 00:30:00 | NQ | Futures | 2267.21 | 2267.21 | 2266.93 | 2266.93 | 11.0 |
| 2010-04-09 01:00:00 | NQ | Futures | 2266.93 | 2267.5 | 2266.64 | 2266.93 | 62.0 |
| 2010-04-09 01:30:00 | NQ | Futures | 2266.93 | 2267.78 | 2266.93 | 2267.21 | 81.0 |
| 2010-04-09 02:00:00 | NQ | Futures | 2266.93 | 2267.78 | 2266.35 | 2266.93 | 148.0 |
| 2010-04-09 02:30:00 | NQ | Futures | 2266.93 | 2268.36 | 2266.93 | 2267.78 | 160.0 |
| 2010-04-09 03:00:00 | NQ | Futures | 2268.07 | 2273.51 | 2267.78 | 2272.94 | 1263.0 |
| 2010-04-09 03:30:00 | NQ | Futures | 2273.23 | 2274.66 | 2272.65 | 2273.51 | 1046.0 |
| 2010-04-09 04:00:00 | NQ | Futures | 2273.23 | 2274.37 | 2273.23 | 2273.8 | 279.0 |
| 2010-04-09 04:30:00 | NQ | Futures | 2273.23 | 2274.37 | 2273.23 | 2273.51 | 246.0 |
| 2010-04-09 05:00:00 | NQ | Futures | 2273.23 | 2273.23 | 2272.08 | 2272.37 | 140.0 |
| 2010-04-09 05:30:00 | NQ | Futures | 2272.08 | 2272.08 | 2270.65 | 2271.51 | 279.0 |
| 2010-04-09 06:00:00 | NQ | Futures | 2271.79 | 2271.79 | 2271.22 | 2271.79 | 170.0 |
| 2010-04-09 06:30:00 | NQ | Futures | 2272.08 | 2272.65 | 2271.51 | 2272.65 | 190.0 |
| 2010-04-09 07:00:00 | NQ | Futures | 2272.65 | 2273.51 | 2272.37 | 2272.94 | 440.0 |
| 2010-04-09 07:30:00 | NQ | Futures | 2272.94 | 2273.51 | 2272.08 | 2272.08 | 335.0 |
| 2010-04-09 08:00:00 | NQ | Futures | 2272.37 | 2272.94 | 2271.79 | 2272.08 | 477.0 |
> showing 50 of 2,061 rows — these rows as CSV