PREVIEW / futures_30min / 2010-04-06
file: by_date/futures_30min/2010/2010-04-06.parquet size: 69 KB rows: 2,585
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-06 00:00:00 | ES | Futures | 1155.16 | 1155.16 | 1154.18 | 1155.16 | 1132.0 |
| 2010-04-06 00:30:00 | ES | Futures | 1154.91 | 1155.16 | 1154.18 | 1154.43 | 1366.0 |
| 2010-04-06 01:00:00 | ES | Futures | 1154.43 | 1154.67 | 1153.45 | 1153.94 | 2539.0 |
| 2010-04-06 01:30:00 | ES | Futures | 1153.94 | 1155.16 | 1153.69 | 1155.16 | 2851.0 |
| 2010-04-06 02:00:00 | ES | Futures | 1154.91 | 1155.4 | 1152.23 | 1153.69 | 14297.0 |
| 2010-04-06 02:30:00 | ES | Futures | 1153.69 | 1153.94 | 1152.96 | 1153.94 | 1991.0 |
| 2010-04-06 03:00:00 | ES | Futures | 1153.69 | 1153.94 | 1151.98 | 1153.2 | 10334.0 |
| 2010-04-06 03:30:00 | ES | Futures | 1152.96 | 1153.69 | 1152.23 | 1153.69 | 5028.0 |
| 2010-04-06 04:00:00 | ES | Futures | 1153.45 | 1155.4 | 1153.45 | 1155.4 | 6859.0 |
| 2010-04-06 04:30:00 | ES | Futures | 1155.4 | 1155.4 | 1154.18 | 1154.43 | 2642.0 |
| 2010-04-06 05:00:00 | ES | Futures | 1154.18 | 1154.67 | 1153.69 | 1153.94 | 3324.0 |
| 2010-04-06 05:30:00 | ES | Futures | 1153.94 | 1154.18 | 1153.45 | 1153.69 | 2762.0 |
| 2010-04-06 06:00:00 | ES | Futures | 1153.69 | 1154.18 | 1153.45 | 1154.18 | 3855.0 |
| 2010-04-06 06:30:00 | ES | Futures | 1154.18 | 1154.91 | 1153.94 | 1154.43 | 2798.0 |
| 2010-04-06 07:00:00 | ES | Futures | 1154.43 | 1154.67 | 1153.94 | 1154.18 | 3887.0 |
| 2010-04-06 07:30:00 | ES | Futures | 1154.43 | 1154.91 | 1153.69 | 1154.43 | 8338.0 |
| 2010-04-06 08:00:00 | ES | Futures | 1154.18 | 1154.43 | 1151.25 | 1151.74 | 28869.0 |
| 2010-04-06 08:30:00 | ES | Futures | 1151.74 | 1152.47 | 1151.25 | 1151.49 | 27345.0 |
| 2010-04-06 09:00:00 | ES | Futures | 1151.49 | 1153.45 | 1151.0 | 1153.45 | 30244.0 |
| 2010-04-06 09:30:00 | ES | Futures | 1153.45 | 1154.91 | 1151.98 | 1154.43 | 159527.0 |
| 2010-04-06 10:00:00 | ES | Futures | 1154.43 | 1155.65 | 1153.2 | 1155.65 | 97040.0 |
| 2010-04-06 10:30:00 | ES | Futures | 1155.65 | 1156.38 | 1155.16 | 1155.89 | 107774.0 |
| 2010-04-06 11:00:00 | ES | Futures | 1156.14 | 1157.85 | 1155.4 | 1157.11 | 112520.0 |
| 2010-04-06 11:30:00 | ES | Futures | 1157.36 | 1158.09 | 1156.14 | 1156.87 | 86010.0 |
| 2010-04-06 12:00:00 | ES | Futures | 1156.63 | 1157.6 | 1156.38 | 1157.11 | 37576.0 |
| 2010-04-06 12:30:00 | ES | Futures | 1156.87 | 1157.11 | 1155.89 | 1157.11 | 35927.0 |
| 2010-04-06 13:00:00 | ES | Futures | 1157.11 | 1158.09 | 1156.87 | 1157.6 | 44531.0 |
| 2010-04-06 13:30:00 | ES | Futures | 1157.6 | 1157.85 | 1156.38 | 1157.11 | 27606.0 |
| 2010-04-06 14:00:00 | ES | Futures | 1157.11 | 1160.29 | 1156.87 | 1160.05 | 121468.0 |
| 2010-04-06 14:30:00 | ES | Futures | 1160.05 | 1161.51 | 1159.8 | 1160.29 | 104825.0 |
| 2010-04-06 15:00:00 | ES | Futures | 1160.54 | 1160.78 | 1158.09 | 1158.34 | 74208.0 |
| 2010-04-06 15:30:00 | ES | Futures | 1158.34 | 1159.56 | 1158.09 | 1158.82 | 118492.0 |
| 2010-04-06 16:00:00 | ES | Futures | 1159.07 | 1159.8 | 1158.82 | 1159.56 | 77882.0 |
| 2010-04-06 16:30:00 | ES | Futures | 1159.31 | 1159.56 | 1158.58 | 1158.58 | 6234.0 |
| 2010-04-06 17:00:00 | ES | Futures | 1158.58 | 1159.07 | 1158.09 | 1158.58 | 3985.0 |
| 2010-04-06 18:00:00 | ES | Futures | 1158.58 | 1158.82 | 1158.34 | 1158.58 | 1351.0 |
| 2010-04-06 18:30:00 | ES | Futures | 1158.82 | 1158.82 | 1158.09 | 1158.58 | 923.0 |
| 2010-04-06 19:00:00 | ES | Futures | 1158.58 | 1158.58 | 1157.85 | 1157.85 | 1535.0 |
| 2010-04-06 19:30:00 | ES | Futures | 1158.09 | 1158.09 | 1157.36 | 1157.85 | 3774.0 |
| 2010-04-06 20:00:00 | ES | Futures | 1157.85 | 1157.85 | 1157.11 | 1157.36 | 2133.0 |
| 2010-04-06 20:30:00 | ES | Futures | 1157.36 | 1157.36 | 1157.11 | 1157.36 | 818.0 |
| 2010-04-06 21:00:00 | ES | Futures | 1157.36 | 1157.6 | 1156.87 | 1157.6 | 993.0 |
| 2010-04-06 21:30:00 | ES | Futures | 1157.6 | 1157.85 | 1157.11 | 1157.36 | 1837.0 |
| 2010-04-06 22:00:00 | ES | Futures | 1157.36 | 1158.09 | 1157.36 | 1157.85 | 1668.0 |
| 2010-04-06 22:30:00 | ES | Futures | 1157.6 | 1158.58 | 1157.36 | 1158.34 | 1503.0 |
| 2010-04-06 23:00:00 | ES | Futures | 1158.34 | 1158.34 | 1157.11 | 1157.11 | 1304.0 |
| 2010-04-06 23:30:00 | ES | Futures | 1157.11 | 1157.85 | 1157.11 | 1157.36 | 1252.0 |
| 2010-04-06 00:00:00 | NQ | Futures | 2257.48 | 2257.48 | 2256.62 | 2257.48 | 43.0 |
| 2010-04-06 00:30:00 | NQ | Futures | 2257.76 | 2257.76 | 2256.62 | 2257.19 | 59.0 |
| 2010-04-06 01:00:00 | NQ | Futures | 2257.19 | 2257.48 | 2256.04 | 2257.19 | 123.0 |
> showing 50 of 2,585 rows — these rows as CSV