PREVIEW / futures_30min / 2010-01-05
file: by_date/futures_30min/2010/2010-01-05.parquet size: 69 KB rows: 2,537
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-01-05 00:00:00 | ES | Futures | 1097.58 | 1097.58 | 1096.85 | 1097.1 | 1797.0 |
| 2010-01-05 00:30:00 | ES | Futures | 1097.1 | 1097.83 | 1097.1 | 1097.34 | 1207.0 |
| 2010-01-05 01:00:00 | ES | Futures | 1097.34 | 1097.83 | 1097.1 | 1097.58 | 744.0 |
| 2010-01-05 01:30:00 | ES | Futures | 1097.83 | 1098.07 | 1097.34 | 1097.83 | 597.0 |
| 2010-01-05 02:00:00 | ES | Futures | 1097.83 | 1098.31 | 1097.58 | 1098.07 | 1831.0 |
| 2010-01-05 02:30:00 | ES | Futures | 1097.83 | 1098.56 | 1097.58 | 1098.56 | 4925.0 |
| 2010-01-05 03:00:00 | ES | Futures | 1098.56 | 1098.56 | 1096.85 | 1097.1 | 9680.0 |
| 2010-01-05 03:30:00 | ES | Futures | 1097.34 | 1097.34 | 1096.12 | 1097.1 | 7194.0 |
| 2010-01-05 04:00:00 | ES | Futures | 1097.1 | 1097.83 | 1096.61 | 1097.58 | 4857.0 |
| 2010-01-05 04:30:00 | ES | Futures | 1097.58 | 1098.31 | 1097.34 | 1097.58 | 4295.0 |
| 2010-01-05 05:00:00 | ES | Futures | 1097.83 | 1098.56 | 1097.1 | 1098.31 | 3733.0 |
| 2010-01-05 05:30:00 | ES | Futures | 1098.07 | 1099.29 | 1097.83 | 1098.56 | 5966.0 |
| 2010-01-05 06:00:00 | ES | Futures | 1098.56 | 1098.56 | 1097.34 | 1098.31 | 6021.0 |
| 2010-01-05 06:30:00 | ES | Futures | 1098.31 | 1099.29 | 1098.07 | 1098.31 | 4974.0 |
| 2010-01-05 07:00:00 | ES | Futures | 1098.56 | 1099.04 | 1098.07 | 1099.04 | 3505.0 |
| 2010-01-05 07:30:00 | ES | Futures | 1099.04 | 1100.26 | 1098.8 | 1099.77 | 12915.0 |
| 2010-01-05 08:00:00 | ES | Futures | 1100.02 | 1100.26 | 1097.83 | 1097.83 | 19210.0 |
| 2010-01-05 08:30:00 | ES | Futures | 1097.83 | 1098.8 | 1097.83 | 1098.07 | 15274.0 |
| 2010-01-05 09:00:00 | ES | Futures | 1098.31 | 1098.8 | 1097.34 | 1098.07 | 21261.0 |
| 2010-01-05 09:30:00 | ES | Futures | 1097.83 | 1099.04 | 1094.91 | 1094.91 | 154813.0 |
| 2010-01-05 10:00:00 | ES | Futures | 1094.91 | 1100.99 | 1094.66 | 1100.5 | 165681.0 |
| 2010-01-05 10:30:00 | ES | Futures | 1100.5 | 1102.21 | 1100.02 | 1100.75 | 112891.0 |
| 2010-01-05 11:00:00 | ES | Futures | 1100.75 | 1101.48 | 1098.31 | 1098.31 | 92592.0 |
| 2010-01-05 11:30:00 | ES | Futures | 1098.56 | 1099.04 | 1097.58 | 1098.56 | 67691.0 |
| 2010-01-05 12:00:00 | ES | Futures | 1098.8 | 1100.26 | 1098.56 | 1099.29 | 52845.0 |
| 2010-01-05 12:30:00 | ES | Futures | 1099.53 | 1099.53 | 1098.07 | 1098.8 | 41996.0 |
| 2010-01-05 13:00:00 | ES | Futures | 1098.8 | 1099.04 | 1096.61 | 1097.34 | 55540.0 |
| 2010-01-05 13:30:00 | ES | Futures | 1097.58 | 1098.8 | 1096.85 | 1097.83 | 55561.0 |
| 2010-01-05 14:00:00 | ES | Futures | 1097.83 | 1098.31 | 1095.64 | 1097.1 | 86027.0 |
| 2010-01-05 14:30:00 | ES | Futures | 1097.1 | 1099.04 | 1096.85 | 1098.8 | 59000.0 |
| 2010-01-05 15:00:00 | ES | Futures | 1098.8 | 1100.26 | 1098.56 | 1099.77 | 65764.0 |
| 2010-01-05 15:30:00 | ES | Futures | 1100.02 | 1101.96 | 1099.77 | 1101.23 | 148541.0 |
| 2010-01-05 16:00:00 | ES | Futures | 1101.48 | 1102.45 | 1101.23 | 1101.72 | 65378.0 |
| 2010-01-05 16:30:00 | ES | Futures | 1101.48 | 1101.72 | 1100.99 | 1101.23 | 5187.0 |
| 2010-01-05 17:00:00 | ES | Futures | 1101.23 | 1101.48 | 1100.99 | 1100.99 | 1345.0 |
| 2010-01-05 18:00:00 | ES | Futures | 1100.99 | 1101.23 | 1100.75 | 1100.75 | 1178.0 |
| 2010-01-05 18:30:00 | ES | Futures | 1100.75 | 1101.23 | 1100.5 | 1100.5 | 637.0 |
| 2010-01-05 19:00:00 | ES | Futures | 1100.5 | 1100.75 | 1100.26 | 1100.5 | 1090.0 |
| 2010-01-05 19:30:00 | ES | Futures | 1100.5 | 1100.99 | 1100.02 | 1100.99 | 1526.0 |
| 2010-01-05 20:00:00 | ES | Futures | 1100.75 | 1101.23 | 1100.5 | 1100.75 | 1537.0 |
| 2010-01-05 20:30:00 | ES | Futures | 1100.75 | 1100.99 | 1099.29 | 1099.53 | 4680.0 |
| 2010-01-05 21:00:00 | ES | Futures | 1099.29 | 1099.53 | 1098.56 | 1098.8 | 3210.0 |
| 2010-01-05 21:30:00 | ES | Futures | 1098.8 | 1099.53 | 1098.56 | 1099.29 | 1315.0 |
| 2010-01-05 22:00:00 | ES | Futures | 1099.53 | 1100.26 | 1099.04 | 1099.53 | 1861.0 |
| 2010-01-05 22:30:00 | ES | Futures | 1099.29 | 1100.02 | 1099.29 | 1100.02 | 1060.0 |
| 2010-01-05 23:00:00 | ES | Futures | 1099.77 | 1100.5 | 1099.29 | 1099.29 | 3522.0 |
| 2010-01-05 23:30:00 | ES | Futures | 1099.29 | 1099.53 | 1099.04 | 1099.53 | 586.0 |
| 2010-01-05 00:00:00 | NQ | Futures | 2153.93 | 2154.21 | 2153.07 | 2153.36 | 306.0 |
| 2010-01-05 00:30:00 | NQ | Futures | 2153.36 | 2154.5 | 2153.36 | 2153.93 | 105.0 |
| 2010-01-05 01:00:00 | NQ | Futures | 2153.93 | 2154.79 | 2153.93 | 2154.21 | 43.0 |
> showing 50 of 2,537 rows — these rows as CSV