PREVIEW / futures_30min / 2010-03-02
file: by_date/futures_30min/2010/2010-03-02.parquet size: 68 KB rows: 2,504
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-03-02 00:00:00 | ES | Futures | 1084.45 | 1084.93 | 1084.2 | 1084.45 | 1037.0 |
| 2010-03-02 00:30:00 | ES | Futures | 1084.45 | 1084.69 | 1083.72 | 1083.96 | 722.0 |
| 2010-03-02 01:00:00 | ES | Futures | 1083.96 | 1084.69 | 1083.72 | 1083.96 | 486.0 |
| 2010-03-02 01:30:00 | ES | Futures | 1083.96 | 1084.93 | 1083.47 | 1084.45 | 1702.0 |
| 2010-03-02 02:00:00 | ES | Futures | 1084.69 | 1085.18 | 1083.72 | 1084.2 | 4145.0 |
| 2010-03-02 02:30:00 | ES | Futures | 1083.96 | 1085.18 | 1083.96 | 1084.2 | 3505.0 |
| 2010-03-02 03:00:00 | ES | Futures | 1083.96 | 1085.18 | 1083.47 | 1084.45 | 14095.0 |
| 2010-03-02 03:30:00 | ES | Futures | 1084.2 | 1084.69 | 1082.74 | 1082.99 | 10418.0 |
| 2010-03-02 04:00:00 | ES | Futures | 1082.74 | 1084.2 | 1082.74 | 1083.47 | 8623.0 |
| 2010-03-02 04:30:00 | ES | Futures | 1083.47 | 1085.18 | 1083.23 | 1084.69 | 6920.0 |
| 2010-03-02 05:00:00 | ES | Futures | 1084.93 | 1085.18 | 1083.96 | 1084.2 | 5162.0 |
| 2010-03-02 05:30:00 | ES | Futures | 1084.2 | 1087.12 | 1084.2 | 1086.88 | 13649.0 |
| 2010-03-02 06:00:00 | ES | Futures | 1086.88 | 1088.34 | 1086.64 | 1087.85 | 13112.0 |
| 2010-03-02 06:30:00 | ES | Futures | 1087.85 | 1092.48 | 1087.85 | 1089.8 | 37517.0 |
| 2010-03-02 07:00:00 | ES | Futures | 1089.8 | 1090.77 | 1089.07 | 1090.04 | 12589.0 |
| 2010-03-02 07:30:00 | ES | Futures | 1089.8 | 1091.02 | 1088.83 | 1090.77 | 12012.0 |
| 2010-03-02 08:00:00 | ES | Futures | 1090.53 | 1091.5 | 1089.56 | 1091.02 | 16879.0 |
| 2010-03-02 08:30:00 | ES | Futures | 1091.02 | 1091.5 | 1089.8 | 1090.04 | 17307.0 |
| 2010-03-02 09:00:00 | ES | Futures | 1090.04 | 1090.77 | 1088.58 | 1088.58 | 24638.0 |
| 2010-03-02 09:30:00 | ES | Futures | 1088.58 | 1090.53 | 1087.12 | 1089.07 | 165162.0 |
| 2010-03-02 10:00:00 | ES | Futures | 1089.07 | 1090.29 | 1086.15 | 1087.85 | 130820.0 |
| 2010-03-02 10:30:00 | ES | Futures | 1088.1 | 1090.77 | 1087.61 | 1089.56 | 109604.0 |
| 2010-03-02 11:00:00 | ES | Futures | 1089.8 | 1091.75 | 1089.56 | 1091.26 | 85813.0 |
| 2010-03-02 11:30:00 | ES | Futures | 1091.26 | 1091.75 | 1090.04 | 1090.77 | 70483.0 |
| 2010-03-02 12:00:00 | ES | Futures | 1091.02 | 1091.5 | 1089.07 | 1089.8 | 56264.0 |
| 2010-03-02 12:30:00 | ES | Futures | 1089.8 | 1090.29 | 1088.58 | 1090.04 | 48560.0 |
| 2010-03-02 13:00:00 | ES | Futures | 1090.04 | 1090.77 | 1089.56 | 1090.04 | 27444.0 |
| 2010-03-02 13:30:00 | ES | Futures | 1090.29 | 1092.48 | 1089.8 | 1091.5 | 56733.0 |
| 2010-03-02 14:00:00 | ES | Futures | 1091.75 | 1092.48 | 1089.07 | 1089.07 | 90614.0 |
| 2010-03-02 14:30:00 | ES | Futures | 1089.31 | 1090.53 | 1087.12 | 1087.61 | 95686.0 |
| 2010-03-02 15:00:00 | ES | Futures | 1087.61 | 1089.07 | 1086.15 | 1086.15 | 83995.0 |
| 2010-03-02 15:30:00 | ES | Futures | 1086.15 | 1087.61 | 1085.18 | 1086.64 | 159675.0 |
| 2010-03-02 16:00:00 | ES | Futures | 1086.64 | 1088.1 | 1086.64 | 1087.12 | 70371.0 |
| 2010-03-02 16:30:00 | ES | Futures | 1087.37 | 1088.34 | 1087.12 | 1088.1 | 4040.0 |
| 2010-03-02 17:00:00 | ES | Futures | 1088.1 | 1088.58 | 1087.85 | 1087.85 | 1803.0 |
| 2010-03-02 18:00:00 | ES | Futures | 1087.85 | 1088.34 | 1087.61 | 1087.85 | 1620.0 |
| 2010-03-02 18:30:00 | ES | Futures | 1087.61 | 1087.85 | 1087.37 | 1087.37 | 702.0 |
| 2010-03-02 19:00:00 | ES | Futures | 1087.37 | 1088.1 | 1087.37 | 1088.1 | 1339.0 |
| 2010-03-02 19:30:00 | ES | Futures | 1088.1 | 1088.34 | 1087.61 | 1087.85 | 1304.0 |
| 2010-03-02 20:00:00 | ES | Futures | 1087.85 | 1088.1 | 1087.37 | 1087.61 | 2983.0 |
| 2010-03-02 20:30:00 | ES | Futures | 1087.37 | 1087.85 | 1087.12 | 1087.37 | 2874.0 |
| 2010-03-02 21:00:00 | ES | Futures | 1087.37 | 1087.37 | 1085.91 | 1085.91 | 5037.0 |
| 2010-03-02 21:30:00 | ES | Futures | 1086.15 | 1086.64 | 1085.91 | 1086.64 | 1568.0 |
| 2010-03-02 22:00:00 | ES | Futures | 1086.64 | 1086.88 | 1085.91 | 1086.39 | 761.0 |
| 2010-03-02 22:30:00 | ES | Futures | 1086.15 | 1086.64 | 1085.91 | 1086.39 | 792.0 |
| 2010-03-02 23:00:00 | ES | Futures | 1086.39 | 1087.12 | 1086.39 | 1086.88 | 1029.0 |
| 2010-03-02 23:30:00 | ES | Futures | 1086.88 | 1087.12 | 1086.39 | 1086.39 | 502.0 |
| 2010-03-02 00:00:00 | NQ | Futures | 2109.09 | 2110.23 | 2109.09 | 2109.66 | 160.0 |
| 2010-03-02 00:30:00 | NQ | Futures | 2109.66 | 2109.66 | 2107.94 | 2108.23 | 45.0 |
| 2010-03-02 01:00:00 | NQ | Futures | 2108.23 | 2109.37 | 2108.23 | 2108.51 | 105.0 |
> showing 50 of 2,504 rows — these rows as CSV