PREVIEW / futures_30min / 2010-08-02
file: by_date/futures_30min/2010/2010-08-02.parquet size: 68 KB rows: 2,476
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-08-02 00:00:00 | ES | Futures | 1086.3 | 1087.03 | 1085.8 | 1086.54 | 1341.0 |
| 2010-08-02 00:30:00 | ES | Futures | 1086.54 | 1086.79 | 1085.07 | 1085.8 | 1674.0 |
| 2010-08-02 01:00:00 | ES | Futures | 1085.8 | 1086.54 | 1085.56 | 1086.05 | 1134.0 |
| 2010-08-02 01:30:00 | ES | Futures | 1086.05 | 1086.3 | 1084.58 | 1084.82 | 1604.0 |
| 2010-08-02 02:00:00 | ES | Futures | 1084.82 | 1086.05 | 1084.82 | 1085.8 | 3275.0 |
| 2010-08-02 02:30:00 | ES | Futures | 1086.05 | 1086.05 | 1085.07 | 1085.07 | 2585.0 |
| 2010-08-02 03:00:00 | ES | Futures | 1085.07 | 1087.03 | 1084.33 | 1086.79 | 11317.0 |
| 2010-08-02 03:30:00 | ES | Futures | 1086.79 | 1088.75 | 1086.3 | 1088.5 | 17452.0 |
| 2010-08-02 04:00:00 | ES | Futures | 1088.5 | 1090.96 | 1088.01 | 1090.47 | 18998.0 |
| 2010-08-02 04:30:00 | ES | Futures | 1090.47 | 1090.71 | 1089.24 | 1089.49 | 7580.0 |
| 2010-08-02 05:00:00 | ES | Futures | 1089.49 | 1090.22 | 1089.24 | 1090.22 | 5297.0 |
| 2010-08-02 05:30:00 | ES | Futures | 1090.22 | 1091.45 | 1089.73 | 1090.96 | 6118.0 |
| 2010-08-02 06:00:00 | ES | Futures | 1090.96 | 1091.2 | 1089.98 | 1090.47 | 4870.0 |
| 2010-08-02 06:30:00 | ES | Futures | 1090.47 | 1090.71 | 1089.98 | 1090.22 | 3219.0 |
| 2010-08-02 07:00:00 | ES | Futures | 1090.22 | 1091.94 | 1090.22 | 1091.45 | 13111.0 |
| 2010-08-02 07:30:00 | ES | Futures | 1091.45 | 1091.94 | 1090.47 | 1090.71 | 8772.0 |
| 2010-08-02 08:00:00 | ES | Futures | 1090.47 | 1091.45 | 1089.73 | 1090.71 | 14351.0 |
| 2010-08-02 08:30:00 | ES | Futures | 1090.47 | 1091.69 | 1090.22 | 1090.96 | 21830.0 |
| 2010-08-02 09:00:00 | ES | Futures | 1091.2 | 1094.39 | 1090.96 | 1093.9 | 55295.0 |
| 2010-08-02 09:30:00 | ES | Futures | 1093.9 | 1094.88 | 1089.73 | 1091.94 | 221160.0 |
| 2010-08-02 10:00:00 | ES | Futures | 1091.94 | 1098.32 | 1091.45 | 1097.58 | 207416.0 |
| 2010-08-02 10:30:00 | ES | Futures | 1097.83 | 1099.05 | 1096.85 | 1098.32 | 104567.0 |
| 2010-08-02 11:00:00 | ES | Futures | 1098.07 | 1099.05 | 1097.09 | 1098.07 | 90178.0 |
| 2010-08-02 11:30:00 | ES | Futures | 1098.07 | 1101.02 | 1098.07 | 1100.53 | 95418.0 |
| 2010-08-02 12:00:00 | ES | Futures | 1100.53 | 1100.53 | 1097.83 | 1098.07 | 52739.0 |
| 2010-08-02 12:30:00 | ES | Futures | 1098.07 | 1099.3 | 1096.85 | 1098.56 | 62297.0 |
| 2010-08-02 13:00:00 | ES | Futures | 1098.32 | 1099.55 | 1098.32 | 1098.32 | 30726.0 |
| 2010-08-02 13:30:00 | ES | Futures | 1098.32 | 1100.04 | 1097.34 | 1099.3 | 49059.0 |
| 2010-08-02 14:00:00 | ES | Futures | 1099.3 | 1101.02 | 1098.56 | 1099.3 | 41763.0 |
| 2010-08-02 14:30:00 | ES | Futures | 1099.55 | 1102.74 | 1099.55 | 1102.0 | 75298.0 |
| 2010-08-02 15:00:00 | ES | Futures | 1102.24 | 1102.98 | 1100.77 | 1102.74 | 72226.0 |
| 2010-08-02 15:30:00 | ES | Futures | 1102.49 | 1103.47 | 1101.02 | 1101.51 | 174908.0 |
| 2010-08-02 16:00:00 | ES | Futures | 1101.51 | 1102.0 | 1100.77 | 1100.77 | 100501.0 |
| 2010-08-02 16:30:00 | ES | Futures | 1101.02 | 1101.26 | 1100.28 | 1100.77 | 4938.0 |
| 2010-08-02 17:00:00 | ES | Futures | 1101.02 | 1101.26 | 1100.77 | 1101.26 | 1088.0 |
| 2010-08-02 18:00:00 | ES | Futures | 1101.02 | 1101.26 | 1100.28 | 1100.77 | 1008.0 |
| 2010-08-02 18:30:00 | ES | Futures | 1100.53 | 1101.02 | 1100.53 | 1100.77 | 731.0 |
| 2010-08-02 19:00:00 | ES | Futures | 1100.77 | 1101.26 | 1100.77 | 1100.77 | 544.0 |
| 2010-08-02 19:30:00 | ES | Futures | 1100.77 | 1101.51 | 1100.77 | 1101.26 | 2599.0 |
| 2010-08-02 20:00:00 | ES | Futures | 1101.02 | 1101.51 | 1100.77 | 1101.26 | 1479.0 |
| 2010-08-02 20:30:00 | ES | Futures | 1101.26 | 1101.51 | 1100.28 | 1101.02 | 1706.0 |
| 2010-08-02 21:00:00 | ES | Futures | 1101.02 | 1101.51 | 1100.53 | 1101.26 | 1164.0 |
| 2010-08-02 21:30:00 | ES | Futures | 1101.02 | 1101.02 | 1098.81 | 1099.79 | 4616.0 |
| 2010-08-02 22:00:00 | ES | Futures | 1099.55 | 1099.55 | 1098.32 | 1098.32 | 3184.0 |
| 2010-08-02 22:30:00 | ES | Futures | 1098.32 | 1099.05 | 1098.07 | 1098.56 | 3059.0 |
| 2010-08-02 23:00:00 | ES | Futures | 1098.56 | 1099.05 | 1098.56 | 1098.81 | 710.0 |
| 2010-08-02 23:30:00 | ES | Futures | 1098.56 | 1099.3 | 1098.32 | 1098.81 | 1148.0 |
| 2010-08-02 00:00:00 | NQ | Futures | 2149.82 | 2150.96 | 2148.96 | 2150.1 | 236.0 |
| 2010-08-02 00:30:00 | NQ | Futures | 2149.82 | 2150.39 | 2147.81 | 2149.25 | 94.0 |
| 2010-08-02 01:00:00 | NQ | Futures | 2148.96 | 2150.1 | 2148.1 | 2148.67 | 86.0 |
> showing 50 of 2,476 rows — these rows as CSV