PREVIEW / futures_30min / 2010-01-21
file: by_date/futures_30min/2010/2010-01-21.parquet size: 76 KB rows: 2,611
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-21 00:00:00 | ES | Futures | 1106.83 | 1106.83 | 1105.85 | 1106.83 | 1432.0 |
| 2010-01-21 00:30:00 | ES | Futures | 1106.58 | 1108.29 | 1106.58 | 1108.29 | 4303.0 |
| 2010-01-21 01:00:00 | ES | Futures | 1108.29 | 1108.53 | 1106.34 | 1106.34 | 2491.0 |
| 2010-01-21 01:30:00 | ES | Futures | 1106.58 | 1106.58 | 1105.85 | 1106.1 | 1983.0 |
| 2010-01-21 02:00:00 | ES | Futures | 1106.1 | 1107.56 | 1105.37 | 1105.85 | 6290.0 |
| 2010-01-21 02:30:00 | ES | Futures | 1105.85 | 1106.1 | 1103.91 | 1104.64 | 7015.0 |
| 2010-01-21 03:00:00 | ES | Futures | 1104.64 | 1105.85 | 1103.91 | 1105.85 | 13938.0 |
| 2010-01-21 03:30:00 | ES | Futures | 1105.61 | 1106.34 | 1102.94 | 1103.42 | 16127.0 |
| 2010-01-21 04:00:00 | ES | Futures | 1103.42 | 1104.64 | 1102.45 | 1102.69 | 15860.0 |
| 2010-01-21 04:30:00 | ES | Futures | 1102.69 | 1104.15 | 1102.69 | 1103.18 | 10053.0 |
| 2010-01-21 05:00:00 | ES | Futures | 1103.18 | 1103.67 | 1102.21 | 1102.45 | 9422.0 |
| 2010-01-21 05:30:00 | ES | Futures | 1102.45 | 1103.18 | 1100.26 | 1100.75 | 17606.0 |
| 2010-01-21 06:00:00 | ES | Futures | 1100.5 | 1102.94 | 1100.5 | 1102.21 | 13331.0 |
| 2010-01-21 06:30:00 | ES | Futures | 1102.21 | 1104.15 | 1101.96 | 1104.15 | 8887.0 |
| 2010-01-21 07:00:00 | ES | Futures | 1103.91 | 1105.61 | 1103.91 | 1105.37 | 15246.0 |
| 2010-01-21 07:30:00 | ES | Futures | 1105.12 | 1106.83 | 1104.64 | 1105.12 | 21009.0 |
| 2010-01-21 08:00:00 | ES | Futures | 1105.37 | 1107.8 | 1102.45 | 1104.88 | 69783.0 |
| 2010-01-21 08:30:00 | ES | Futures | 1104.88 | 1104.88 | 1100.26 | 1101.96 | 62553.0 |
| 2010-01-21 09:00:00 | ES | Futures | 1101.96 | 1104.64 | 1101.48 | 1103.91 | 27993.0 |
| 2010-01-21 09:30:00 | ES | Futures | 1104.15 | 1107.56 | 1102.21 | 1103.42 | 248129.0 |
| 2010-01-21 10:00:00 | ES | Futures | 1103.42 | 1106.34 | 1091.99 | 1092.23 | 343686.0 |
| 2010-01-21 10:30:00 | ES | Futures | 1092.48 | 1093.2 | 1088.83 | 1091.02 | 354222.0 |
| 2010-01-21 11:00:00 | ES | Futures | 1091.26 | 1091.75 | 1086.39 | 1087.85 | 250817.0 |
| 2010-01-21 11:30:00 | ES | Futures | 1087.85 | 1088.83 | 1081.53 | 1084.2 | 382593.0 |
| 2010-01-21 12:00:00 | ES | Futures | 1084.2 | 1088.34 | 1082.74 | 1083.47 | 177762.0 |
| 2010-01-21 12:30:00 | ES | Futures | 1083.23 | 1084.93 | 1081.77 | 1082.74 | 108567.0 |
| 2010-01-21 13:00:00 | ES | Futures | 1082.99 | 1084.69 | 1080.8 | 1083.96 | 141140.0 |
| 2010-01-21 13:30:00 | ES | Futures | 1084.2 | 1086.64 | 1083.96 | 1085.66 | 95876.0 |
| 2010-01-21 14:00:00 | ES | Futures | 1085.91 | 1088.1 | 1082.99 | 1087.61 | 144427.0 |
| 2010-01-21 14:30:00 | ES | Futures | 1087.85 | 1089.31 | 1084.93 | 1086.15 | 150376.0 |
| 2010-01-21 15:00:00 | ES | Futures | 1086.39 | 1086.64 | 1081.77 | 1083.47 | 177829.0 |
| 2010-01-21 15:30:00 | ES | Futures | 1083.47 | 1086.88 | 1081.77 | 1082.26 | 296068.0 |
| 2010-01-21 16:00:00 | ES | Futures | 1082.26 | 1082.74 | 1080.31 | 1080.56 | 197970.0 |
| 2010-01-21 16:30:00 | ES | Futures | 1079.83 | 1080.31 | 1078.61 | 1079.83 | 15528.0 |
| 2010-01-21 17:00:00 | ES | Futures | 1079.83 | 1080.31 | 1078.61 | 1078.85 | 3161.0 |
| 2010-01-21 18:00:00 | ES | Futures | 1078.85 | 1080.56 | 1078.61 | 1080.56 | 4814.0 |
| 2010-01-21 18:30:00 | ES | Futures | 1080.56 | 1080.8 | 1079.58 | 1080.56 | 2833.0 |
| 2010-01-21 19:00:00 | ES | Futures | 1080.56 | 1080.56 | 1079.83 | 1080.56 | 3216.0 |
| 2010-01-21 19:30:00 | ES | Futures | 1080.31 | 1081.29 | 1080.07 | 1081.04 | 2530.0 |
| 2010-01-21 20:00:00 | ES | Futures | 1080.8 | 1081.29 | 1079.34 | 1080.31 | 3232.0 |
| 2010-01-21 20:30:00 | ES | Futures | 1080.31 | 1082.02 | 1080.07 | 1081.77 | 3000.0 |
| 2010-01-21 21:00:00 | ES | Futures | 1081.77 | 1082.99 | 1081.29 | 1081.53 | 4039.0 |
| 2010-01-21 21:30:00 | ES | Futures | 1081.53 | 1082.26 | 1081.29 | 1081.77 | 2116.0 |
| 2010-01-21 22:00:00 | ES | Futures | 1081.77 | 1082.26 | 1080.31 | 1081.04 | 2533.0 |
| 2010-01-21 22:30:00 | ES | Futures | 1081.04 | 1081.53 | 1080.31 | 1081.53 | 2351.0 |
| 2010-01-21 23:00:00 | ES | Futures | 1081.53 | 1081.53 | 1079.58 | 1080.56 | 2712.0 |
| 2010-01-21 23:30:00 | ES | Futures | 1080.8 | 1082.02 | 1080.56 | 1082.02 | 1600.0 |
| 2010-01-21 00:00:00 | NQ | Futures | 2140.22 | 2140.5 | 2138.79 | 2140.5 | 139.0 |
| 2010-01-21 00:30:00 | NQ | Futures | 2140.5 | 2143.08 | 2140.5 | 2142.79 | 365.0 |
| 2010-01-21 01:00:00 | NQ | Futures | 2142.79 | 2143.08 | 2139.65 | 2139.93 | 237.0 |
> showing 50 of 2,611 rows — these rows as CSV