PREVIEW / futures_30min / 2010-02-22
file: by_date/futures_30min/2010/2010-02-22.parquet size: 64 KB rows: 2,425
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-02-22 00:00:00 | ES | Futures | 1079.34 | 1079.58 | 1079.1 | 1079.58 | 560.0 |
| 2010-02-22 00:30:00 | ES | Futures | 1079.34 | 1079.58 | 1078.85 | 1079.34 | 715.0 |
| 2010-02-22 01:00:00 | ES | Futures | 1079.1 | 1080.31 | 1079.1 | 1079.83 | 1713.0 |
| 2010-02-22 01:30:00 | ES | Futures | 1079.83 | 1080.31 | 1078.37 | 1078.85 | 3113.0 |
| 2010-02-22 02:00:00 | ES | Futures | 1078.85 | 1079.58 | 1078.12 | 1079.1 | 3835.0 |
| 2010-02-22 02:30:00 | ES | Futures | 1079.1 | 1080.8 | 1078.85 | 1080.8 | 7775.0 |
| 2010-02-22 03:00:00 | ES | Futures | 1080.8 | 1081.04 | 1078.37 | 1080.07 | 14149.0 |
| 2010-02-22 03:30:00 | ES | Futures | 1080.31 | 1080.8 | 1077.15 | 1077.39 | 12269.0 |
| 2010-02-22 04:00:00 | ES | Futures | 1077.64 | 1077.64 | 1076.42 | 1077.15 | 9270.0 |
| 2010-02-22 04:30:00 | ES | Futures | 1077.15 | 1079.58 | 1077.15 | 1077.88 | 9731.0 |
| 2010-02-22 05:00:00 | ES | Futures | 1078.12 | 1078.85 | 1077.15 | 1078.12 | 6088.0 |
| 2010-02-22 05:30:00 | ES | Futures | 1078.37 | 1079.34 | 1077.39 | 1078.37 | 5859.0 |
| 2010-02-22 06:00:00 | ES | Futures | 1078.37 | 1078.85 | 1077.64 | 1078.12 | 4189.0 |
| 2010-02-22 06:30:00 | ES | Futures | 1078.12 | 1078.85 | 1077.64 | 1078.12 | 5554.0 |
| 2010-02-22 07:00:00 | ES | Futures | 1078.12 | 1081.04 | 1078.12 | 1079.34 | 13541.0 |
| 2010-02-22 07:30:00 | ES | Futures | 1079.58 | 1082.74 | 1079.34 | 1082.26 | 18063.0 |
| 2010-02-22 08:00:00 | ES | Futures | 1082.26 | 1082.26 | 1080.56 | 1080.8 | 14089.0 |
| 2010-02-22 08:30:00 | ES | Futures | 1080.8 | 1081.29 | 1080.31 | 1080.8 | 12016.0 |
| 2010-02-22 09:00:00 | ES | Futures | 1080.8 | 1081.04 | 1080.07 | 1080.8 | 14862.0 |
| 2010-02-22 09:30:00 | ES | Futures | 1080.56 | 1081.04 | 1075.45 | 1077.64 | 175591.0 |
| 2010-02-22 10:00:00 | ES | Futures | 1077.64 | 1077.88 | 1073.74 | 1077.15 | 156680.0 |
| 2010-02-22 10:30:00 | ES | Futures | 1076.91 | 1078.61 | 1075.93 | 1076.18 | 92189.0 |
| 2010-02-22 11:00:00 | ES | Futures | 1076.18 | 1076.91 | 1074.72 | 1075.69 | 88326.0 |
| 2010-02-22 11:30:00 | ES | Futures | 1075.45 | 1076.66 | 1074.47 | 1075.2 | 66900.0 |
| 2010-02-22 12:00:00 | ES | Futures | 1075.2 | 1076.66 | 1074.72 | 1075.69 | 35063.0 |
| 2010-02-22 12:30:00 | ES | Futures | 1075.45 | 1077.88 | 1075.45 | 1077.39 | 43440.0 |
| 2010-02-22 13:00:00 | ES | Futures | 1077.15 | 1077.64 | 1075.93 | 1076.42 | 28376.0 |
| 2010-02-22 13:30:00 | ES | Futures | 1076.66 | 1078.61 | 1076.18 | 1076.66 | 49771.0 |
| 2010-02-22 14:00:00 | ES | Futures | 1076.66 | 1079.1 | 1076.66 | 1078.37 | 39657.0 |
| 2010-02-22 14:30:00 | ES | Futures | 1078.12 | 1079.83 | 1078.12 | 1079.1 | 53713.0 |
| 2010-02-22 15:00:00 | ES | Futures | 1079.1 | 1080.31 | 1078.61 | 1079.58 | 48552.0 |
| 2010-02-22 15:30:00 | ES | Futures | 1079.34 | 1079.58 | 1074.96 | 1076.66 | 163916.0 |
| 2010-02-22 16:00:00 | ES | Futures | 1076.66 | 1078.12 | 1076.66 | 1077.88 | 75356.0 |
| 2010-02-22 16:30:00 | ES | Futures | 1077.15 | 1077.64 | 1076.66 | 1076.66 | 5015.0 |
| 2010-02-22 17:00:00 | ES | Futures | 1076.91 | 1077.64 | 1076.66 | 1077.39 | 1860.0 |
| 2010-02-22 18:00:00 | ES | Futures | 1076.91 | 1077.15 | 1076.42 | 1076.66 | 2030.0 |
| 2010-02-22 18:30:00 | ES | Futures | 1076.66 | 1077.64 | 1076.66 | 1077.15 | 733.0 |
| 2010-02-22 19:00:00 | ES | Futures | 1077.39 | 1077.88 | 1076.91 | 1077.39 | 1558.0 |
| 2010-02-22 19:30:00 | ES | Futures | 1077.39 | 1077.64 | 1076.42 | 1076.66 | 1328.0 |
| 2010-02-22 20:00:00 | ES | Futures | 1076.42 | 1076.91 | 1076.18 | 1076.42 | 1360.0 |
| 2010-02-22 20:30:00 | ES | Futures | 1076.42 | 1076.66 | 1075.69 | 1075.69 | 1878.0 |
| 2010-02-22 21:00:00 | ES | Futures | 1075.69 | 1076.18 | 1075.45 | 1075.93 | 1580.0 |
| 2010-02-22 21:30:00 | ES | Futures | 1075.93 | 1076.42 | 1075.45 | 1075.93 | 1760.0 |
| 2010-02-22 22:00:00 | ES | Futures | 1076.18 | 1076.42 | 1075.45 | 1076.18 | 1707.0 |
| 2010-02-22 22:30:00 | ES | Futures | 1075.93 | 1077.39 | 1075.93 | 1077.15 | 2623.0 |
| 2010-02-22 23:00:00 | ES | Futures | 1076.91 | 1078.85 | 1076.91 | 1078.61 | 3181.0 |
| 2010-02-22 23:30:00 | ES | Futures | 1078.37 | 1078.61 | 1077.88 | 1078.12 | 662.0 |
| 2010-02-22 00:00:00 | NQ | Futures | 2085.38 | 2085.66 | 2084.81 | 2085.09 | 24.0 |
| 2010-02-22 00:30:00 | NQ | Futures | 2085.09 | 2085.38 | 2084.81 | 2085.09 | 23.0 |
| 2010-02-22 01:00:00 | NQ | Futures | 2085.09 | 2088.81 | 2085.09 | 2087.95 | 342.0 |
> showing 50 of 2,425 rows — these rows as CSV