PREVIEW / futures_30min / 2009-12-22
file: by_date/futures_30min/2009/2009-12-22.parquet size: 66 KB rows: 2,421
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-22 00:00:00 | ES | Futures | 1080.8 | 1081.29 | 1080.07 | 1080.8 | 916.0 |
| 2009-12-22 00:30:00 | ES | Futures | 1081.04 | 1082.02 | 1080.8 | 1081.77 | 1608.0 |
| 2009-12-22 01:00:00 | ES | Futures | 1081.53 | 1082.02 | 1081.53 | 1081.53 | 622.0 |
| 2009-12-22 01:30:00 | ES | Futures | 1081.77 | 1082.02 | 1081.29 | 1081.77 | 2074.0 |
| 2009-12-22 02:00:00 | ES | Futures | 1081.77 | 1082.26 | 1081.04 | 1082.26 | 3532.0 |
| 2009-12-22 02:30:00 | ES | Futures | 1082.26 | 1082.5 | 1080.8 | 1080.8 | 3308.0 |
| 2009-12-22 03:00:00 | ES | Futures | 1080.8 | 1082.5 | 1080.8 | 1082.02 | 9743.0 |
| 2009-12-22 03:30:00 | ES | Futures | 1082.02 | 1082.26 | 1081.04 | 1081.29 | 6521.0 |
| 2009-12-22 04:00:00 | ES | Futures | 1081.53 | 1082.02 | 1080.56 | 1081.04 | 3923.0 |
| 2009-12-22 04:30:00 | ES | Futures | 1081.04 | 1082.5 | 1080.56 | 1081.77 | 5346.0 |
| 2009-12-22 05:00:00 | ES | Futures | 1081.77 | 1082.99 | 1081.53 | 1082.5 | 6477.0 |
| 2009-12-22 05:30:00 | ES | Futures | 1082.5 | 1083.23 | 1081.53 | 1082.5 | 11047.0 |
| 2009-12-22 06:00:00 | ES | Futures | 1082.5 | 1082.99 | 1081.77 | 1081.77 | 10245.0 |
| 2009-12-22 06:30:00 | ES | Futures | 1081.77 | 1082.74 | 1081.53 | 1082.5 | 6220.0 |
| 2009-12-22 07:00:00 | ES | Futures | 1082.5 | 1084.69 | 1082.26 | 1083.72 | 11589.0 |
| 2009-12-22 07:30:00 | ES | Futures | 1083.72 | 1084.45 | 1082.26 | 1082.74 | 9939.0 |
| 2009-12-22 08:00:00 | ES | Futures | 1082.74 | 1083.72 | 1082.26 | 1082.99 | 9925.0 |
| 2009-12-22 08:30:00 | ES | Futures | 1082.74 | 1082.74 | 1080.07 | 1081.53 | 25771.0 |
| 2009-12-22 09:00:00 | ES | Futures | 1081.29 | 1082.26 | 1081.29 | 1081.77 | 8634.0 |
| 2009-12-22 09:30:00 | ES | Futures | 1081.77 | 1084.69 | 1080.8 | 1082.26 | 117844.0 |
| 2009-12-22 10:00:00 | ES | Futures | 1082.5 | 1085.66 | 1081.77 | 1084.93 | 124968.0 |
| 2009-12-22 10:30:00 | ES | Futures | 1084.93 | 1085.18 | 1082.02 | 1082.26 | 73334.0 |
| 2009-12-22 11:00:00 | ES | Futures | 1082.5 | 1082.99 | 1081.29 | 1081.53 | 55528.0 |
| 2009-12-22 11:30:00 | ES | Futures | 1081.53 | 1082.26 | 1080.56 | 1082.02 | 43481.0 |
| 2009-12-22 12:00:00 | ES | Futures | 1082.26 | 1082.74 | 1081.77 | 1082.5 | 20180.0 |
| 2009-12-22 12:30:00 | ES | Futures | 1082.74 | 1084.2 | 1082.26 | 1083.72 | 31702.0 |
| 2009-12-22 13:00:00 | ES | Futures | 1083.72 | 1084.93 | 1083.23 | 1083.96 | 31655.0 |
| 2009-12-22 13:30:00 | ES | Futures | 1084.2 | 1085.18 | 1083.72 | 1084.2 | 32031.0 |
| 2009-12-22 14:00:00 | ES | Futures | 1084.45 | 1084.45 | 1083.23 | 1083.72 | 25508.0 |
| 2009-12-22 14:30:00 | ES | Futures | 1083.47 | 1083.96 | 1082.99 | 1083.23 | 20102.0 |
| 2009-12-22 15:00:00 | ES | Futures | 1083.23 | 1083.47 | 1082.02 | 1082.74 | 42791.0 |
| 2009-12-22 15:30:00 | ES | Futures | 1082.99 | 1083.96 | 1082.5 | 1083.47 | 90393.0 |
| 2009-12-22 16:00:00 | ES | Futures | 1083.47 | 1084.2 | 1083.23 | 1083.72 | 62657.0 |
| 2009-12-22 16:30:00 | ES | Futures | 1083.72 | 1083.96 | 1083.47 | 1083.72 | 2360.0 |
| 2009-12-22 17:00:00 | ES | Futures | 1083.72 | 1083.72 | 1083.23 | 1083.47 | 970.0 |
| 2009-12-22 18:00:00 | ES | Futures | 1083.23 | 1083.47 | 1082.99 | 1083.23 | 960.0 |
| 2009-12-22 18:30:00 | ES | Futures | 1083.23 | 1083.47 | 1083.23 | 1083.47 | 185.0 |
| 2009-12-22 19:00:00 | ES | Futures | 1083.47 | 1083.47 | 1082.99 | 1082.99 | 707.0 |
| 2009-12-22 19:30:00 | ES | Futures | 1082.99 | 1084.45 | 1082.99 | 1083.96 | 1560.0 |
| 2009-12-22 20:00:00 | ES | Futures | 1084.2 | 1084.45 | 1083.72 | 1084.2 | 880.0 |
| 2009-12-22 20:30:00 | ES | Futures | 1084.2 | 1084.45 | 1083.72 | 1084.2 | 735.0 |
| 2009-12-22 21:00:00 | ES | Futures | 1084.2 | 1084.45 | 1083.72 | 1083.96 | 1321.0 |
| 2009-12-22 21:30:00 | ES | Futures | 1083.96 | 1084.69 | 1083.96 | 1084.45 | 586.0 |
| 2009-12-22 22:00:00 | ES | Futures | 1084.2 | 1084.45 | 1084.2 | 1084.45 | 249.0 |
| 2009-12-22 22:30:00 | ES | Futures | 1084.2 | 1084.69 | 1084.2 | 1084.45 | 217.0 |
| 2009-12-22 23:00:00 | ES | Futures | 1084.45 | 1084.93 | 1084.45 | 1084.93 | 585.0 |
| 2009-12-22 23:30:00 | ES | Futures | 1084.69 | 1085.18 | 1084.45 | 1084.69 | 487.0 |
| 2009-12-22 00:00:00 | NQ | Futures | 2089.95 | 2090.52 | 2089.09 | 2089.95 | 25.0 |
| 2009-12-22 00:30:00 | NQ | Futures | 2090.23 | 2092.8 | 2090.23 | 2092.52 | 64.0 |
| 2009-12-22 01:00:00 | NQ | Futures | 2092.8 | 2093.09 | 2091.95 | 2091.95 | 68.0 |
> showing 50 of 2,421 rows — these rows as CSV