PREVIEW / futures_30min / 2010-04-28
file: by_date/futures_30min/2010/2010-04-28.parquet size: 73 KB rows: 2,581
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-28 00:00:00 | ES | Futures | 1156.87 | 1157.11 | 1156.14 | 1156.38 | 1517.0 |
| 2010-04-28 00:30:00 | ES | Futures | 1156.14 | 1156.87 | 1155.4 | 1155.4 | 1817.0 |
| 2010-04-28 01:00:00 | ES | Futures | 1155.89 | 1156.38 | 1155.4 | 1155.89 | 1618.0 |
| 2010-04-28 01:30:00 | ES | Futures | 1155.89 | 1156.87 | 1155.65 | 1155.89 | 4298.0 |
| 2010-04-28 02:00:00 | ES | Futures | 1155.89 | 1157.11 | 1155.65 | 1155.65 | 13499.0 |
| 2010-04-28 02:30:00 | ES | Futures | 1155.65 | 1156.38 | 1154.91 | 1155.65 | 8395.0 |
| 2010-04-28 03:00:00 | ES | Futures | 1155.65 | 1158.34 | 1155.4 | 1157.11 | 30241.0 |
| 2010-04-28 03:30:00 | ES | Futures | 1157.11 | 1157.36 | 1154.67 | 1155.16 | 28294.0 |
| 2010-04-28 04:00:00 | ES | Futures | 1155.16 | 1155.65 | 1152.47 | 1152.71 | 38465.0 |
| 2010-04-28 04:30:00 | ES | Futures | 1152.71 | 1153.2 | 1150.51 | 1152.47 | 43467.0 |
| 2010-04-28 05:00:00 | ES | Futures | 1152.71 | 1154.43 | 1151.49 | 1152.47 | 21420.0 |
| 2010-04-28 05:30:00 | ES | Futures | 1152.23 | 1154.18 | 1150.51 | 1153.94 | 35811.0 |
| 2010-04-28 06:00:00 | ES | Futures | 1153.94 | 1156.63 | 1153.2 | 1154.91 | 29827.0 |
| 2010-04-28 06:30:00 | ES | Futures | 1154.91 | 1156.63 | 1152.71 | 1156.63 | 22864.0 |
| 2010-04-28 07:00:00 | ES | Futures | 1156.63 | 1160.05 | 1156.38 | 1159.8 | 48641.0 |
| 2010-04-28 07:30:00 | ES | Futures | 1160.05 | 1161.02 | 1157.85 | 1158.09 | 39185.0 |
| 2010-04-28 08:00:00 | ES | Futures | 1157.85 | 1160.54 | 1157.36 | 1159.56 | 63117.0 |
| 2010-04-28 08:30:00 | ES | Futures | 1159.56 | 1162.49 | 1158.09 | 1161.51 | 64724.0 |
| 2010-04-28 09:00:00 | ES | Futures | 1161.76 | 1163.22 | 1158.82 | 1159.31 | 84019.0 |
| 2010-04-28 09:30:00 | ES | Futures | 1159.07 | 1162.0 | 1157.11 | 1158.34 | 290948.0 |
| 2010-04-28 10:00:00 | ES | Futures | 1158.34 | 1159.8 | 1155.4 | 1158.82 | 237987.0 |
| 2010-04-28 10:30:00 | ES | Futures | 1158.82 | 1160.05 | 1155.65 | 1160.05 | 183699.0 |
| 2010-04-28 11:00:00 | ES | Futures | 1160.05 | 1162.98 | 1156.14 | 1158.58 | 255412.0 |
| 2010-04-28 11:30:00 | ES | Futures | 1158.58 | 1159.07 | 1151.49 | 1157.36 | 277864.0 |
| 2010-04-28 12:00:00 | ES | Futures | 1157.36 | 1160.78 | 1153.69 | 1160.05 | 139784.0 |
| 2010-04-28 12:30:00 | ES | Futures | 1160.05 | 1161.27 | 1158.58 | 1160.54 | 53411.0 |
| 2010-04-28 13:00:00 | ES | Futures | 1160.54 | 1161.51 | 1159.31 | 1159.8 | 43076.0 |
| 2010-04-28 13:30:00 | ES | Futures | 1159.56 | 1161.27 | 1159.56 | 1160.78 | 26984.0 |
| 2010-04-28 14:00:00 | ES | Futures | 1160.78 | 1165.42 | 1159.8 | 1163.22 | 131719.0 |
| 2010-04-28 14:30:00 | ES | Futures | 1163.22 | 1164.45 | 1160.05 | 1163.47 | 147576.0 |
| 2010-04-28 15:00:00 | ES | Futures | 1163.47 | 1164.94 | 1161.27 | 1162.74 | 101837.0 |
| 2010-04-28 15:30:00 | ES | Futures | 1162.74 | 1163.96 | 1157.85 | 1162.0 | 211857.0 |
| 2010-04-28 16:00:00 | ES | Futures | 1162.0 | 1164.45 | 1161.76 | 1163.71 | 109912.0 |
| 2010-04-28 16:30:00 | ES | Futures | 1163.47 | 1164.2 | 1162.98 | 1163.96 | 5845.0 |
| 2010-04-28 17:00:00 | ES | Futures | 1163.96 | 1164.94 | 1163.71 | 1164.45 | 2996.0 |
| 2010-04-28 18:00:00 | ES | Futures | 1164.2 | 1165.42 | 1164.2 | 1165.18 | 3073.0 |
| 2010-04-28 18:30:00 | ES | Futures | 1164.94 | 1165.18 | 1163.96 | 1164.2 | 2356.0 |
| 2010-04-28 19:00:00 | ES | Futures | 1164.45 | 1164.94 | 1164.2 | 1164.69 | 675.0 |
| 2010-04-28 19:30:00 | ES | Futures | 1164.94 | 1165.18 | 1164.2 | 1164.45 | 733.0 |
| 2010-04-28 20:00:00 | ES | Futures | 1164.45 | 1164.45 | 1163.47 | 1163.71 | 1506.0 |
| 2010-04-28 20:30:00 | ES | Futures | 1163.96 | 1163.96 | 1162.74 | 1163.22 | 2855.0 |
| 2010-04-28 21:00:00 | ES | Futures | 1162.98 | 1163.22 | 1161.51 | 1162.0 | 3923.0 |
| 2010-04-28 21:30:00 | ES | Futures | 1162.0 | 1162.74 | 1161.76 | 1162.25 | 2410.0 |
| 2010-04-28 22:00:00 | ES | Futures | 1162.25 | 1162.74 | 1161.76 | 1162.0 | 2023.0 |
| 2010-04-28 22:30:00 | ES | Futures | 1161.76 | 1162.98 | 1161.76 | 1162.98 | 1775.0 |
| 2010-04-28 23:00:00 | ES | Futures | 1162.98 | 1163.47 | 1162.0 | 1162.98 | 2865.0 |
| 2010-04-28 23:30:00 | ES | Futures | 1162.74 | 1163.22 | 1162.49 | 1162.74 | 1050.0 |
| 2010-04-28 00:00:00 | NQ | Futures | 2303.58 | 2303.87 | 2302.72 | 2303.58 | 73.0 |
| 2010-04-28 00:30:00 | NQ | Futures | 2303.58 | 2303.87 | 2302.44 | 2302.44 | 117.0 |
| 2010-04-28 01:00:00 | NQ | Futures | 2302.44 | 2303.87 | 2302.44 | 2302.72 | 139.0 |
> showing 50 of 2,581 rows — these rows as CSV