PREVIEW / futures_30min / 2010-07-26
file: by_date/futures_30min/2010/2010-07-26.parquet size: 68 KB rows: 2,468
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-07-26 00:00:00 | ES | Futures | 1082.37 | 1082.61 | 1081.39 | 1082.12 | 1024.0 |
| 2010-07-26 00:30:00 | ES | Futures | 1082.12 | 1082.61 | 1081.39 | 1082.37 | 1346.0 |
| 2010-07-26 01:00:00 | ES | Futures | 1082.37 | 1082.61 | 1081.14 | 1081.63 | 1779.0 |
| 2010-07-26 01:30:00 | ES | Futures | 1081.63 | 1082.12 | 1081.14 | 1081.63 | 1435.0 |
| 2010-07-26 02:00:00 | ES | Futures | 1081.39 | 1082.61 | 1080.9 | 1082.37 | 3755.0 |
| 2010-07-26 02:30:00 | ES | Futures | 1082.37 | 1083.6 | 1082.12 | 1082.12 | 4181.0 |
| 2010-07-26 03:00:00 | ES | Futures | 1081.88 | 1082.12 | 1079.18 | 1079.42 | 20256.0 |
| 2010-07-26 03:30:00 | ES | Futures | 1079.67 | 1080.65 | 1077.95 | 1079.67 | 16728.0 |
| 2010-07-26 04:00:00 | ES | Futures | 1079.92 | 1080.65 | 1076.73 | 1077.22 | 16209.0 |
| 2010-07-26 04:30:00 | ES | Futures | 1077.22 | 1079.18 | 1076.73 | 1078.2 | 8424.0 |
| 2010-07-26 05:00:00 | ES | Futures | 1077.95 | 1079.42 | 1077.46 | 1078.69 | 5749.0 |
| 2010-07-26 05:30:00 | ES | Futures | 1078.69 | 1079.42 | 1077.71 | 1078.44 | 5180.0 |
| 2010-07-26 06:00:00 | ES | Futures | 1078.44 | 1079.67 | 1077.46 | 1079.42 | 7449.0 |
| 2010-07-26 06:30:00 | ES | Futures | 1079.18 | 1080.16 | 1078.69 | 1079.67 | 5733.0 |
| 2010-07-26 07:00:00 | ES | Futures | 1079.92 | 1079.92 | 1077.71 | 1077.95 | 9376.0 |
| 2010-07-26 07:30:00 | ES | Futures | 1077.95 | 1078.69 | 1076.73 | 1078.44 | 13255.0 |
| 2010-07-26 08:00:00 | ES | Futures | 1078.44 | 1078.69 | 1077.22 | 1077.95 | 16546.0 |
| 2010-07-26 08:30:00 | ES | Futures | 1077.71 | 1079.42 | 1077.46 | 1079.42 | 13267.0 |
| 2010-07-26 09:00:00 | ES | Futures | 1079.42 | 1082.61 | 1079.18 | 1080.41 | 47392.0 |
| 2010-07-26 09:30:00 | ES | Futures | 1080.41 | 1081.39 | 1077.46 | 1080.9 | 149417.0 |
| 2010-07-26 10:00:00 | ES | Futures | 1080.9 | 1087.03 | 1080.65 | 1084.82 | 204590.0 |
| 2010-07-26 10:30:00 | ES | Futures | 1085.07 | 1085.56 | 1082.37 | 1085.56 | 124910.0 |
| 2010-07-26 11:00:00 | ES | Futures | 1085.56 | 1088.01 | 1084.09 | 1087.52 | 107955.0 |
| 2010-07-26 11:30:00 | ES | Futures | 1087.77 | 1088.99 | 1087.03 | 1087.77 | 84716.0 |
| 2010-07-26 12:00:00 | ES | Futures | 1088.01 | 1089.24 | 1087.28 | 1088.5 | 49650.0 |
| 2010-07-26 12:30:00 | ES | Futures | 1088.5 | 1088.75 | 1086.3 | 1087.52 | 54605.0 |
| 2010-07-26 13:00:00 | ES | Futures | 1087.52 | 1088.01 | 1086.3 | 1087.52 | 37268.0 |
| 2010-07-26 13:30:00 | ES | Futures | 1087.52 | 1088.75 | 1086.79 | 1088.01 | 48988.0 |
| 2010-07-26 14:00:00 | ES | Futures | 1088.26 | 1088.26 | 1085.56 | 1085.8 | 42823.0 |
| 2010-07-26 14:30:00 | ES | Futures | 1085.56 | 1085.8 | 1084.09 | 1085.31 | 59660.0 |
| 2010-07-26 15:00:00 | ES | Futures | 1085.31 | 1089.49 | 1084.82 | 1088.75 | 82305.0 |
| 2010-07-26 15:30:00 | ES | Futures | 1088.75 | 1091.2 | 1087.52 | 1090.22 | 162966.0 |
| 2010-07-26 16:00:00 | ES | Futures | 1090.22 | 1090.47 | 1088.5 | 1088.99 | 93526.0 |
| 2010-07-26 16:30:00 | ES | Futures | 1088.75 | 1089.24 | 1088.5 | 1088.99 | 2570.0 |
| 2010-07-26 17:00:00 | ES | Futures | 1088.99 | 1089.24 | 1088.75 | 1088.99 | 1192.0 |
| 2010-07-26 18:00:00 | ES | Futures | 1088.99 | 1089.24 | 1087.77 | 1087.77 | 1944.0 |
| 2010-07-26 18:30:00 | ES | Futures | 1087.77 | 1088.26 | 1087.77 | 1088.01 | 559.0 |
| 2010-07-26 19:00:00 | ES | Futures | 1088.26 | 1088.5 | 1087.77 | 1088.01 | 836.0 |
| 2010-07-26 19:30:00 | ES | Futures | 1087.77 | 1088.5 | 1087.52 | 1087.77 | 946.0 |
| 2010-07-26 20:00:00 | ES | Futures | 1087.77 | 1088.99 | 1087.52 | 1088.75 | 2351.0 |
| 2010-07-26 20:30:00 | ES | Futures | 1088.99 | 1089.24 | 1088.26 | 1088.99 | 1406.0 |
| 2010-07-26 21:00:00 | ES | Futures | 1088.99 | 1090.47 | 1088.5 | 1089.73 | 1894.0 |
| 2010-07-26 21:30:00 | ES | Futures | 1089.73 | 1089.98 | 1088.01 | 1088.26 | 2542.0 |
| 2010-07-26 22:00:00 | ES | Futures | 1088.26 | 1088.75 | 1087.77 | 1087.77 | 1203.0 |
| 2010-07-26 22:30:00 | ES | Futures | 1087.77 | 1088.26 | 1087.28 | 1087.77 | 1981.0 |
| 2010-07-26 23:00:00 | ES | Futures | 1087.77 | 1088.01 | 1087.28 | 1087.52 | 762.0 |
| 2010-07-26 23:30:00 | ES | Futures | 1087.28 | 1087.77 | 1087.28 | 1087.28 | 697.0 |
| 2010-07-26 00:00:00 | NQ | Futures | 2155.26 | 2155.26 | 2153.26 | 2154.4 | 47.0 |
| 2010-07-26 00:30:00 | NQ | Futures | 2154.4 | 2154.98 | 2152.97 | 2154.4 | 143.0 |
| 2010-07-26 01:00:00 | NQ | Futures | 2154.69 | 2154.69 | 2152.4 | 2152.97 | 83.0 |
> showing 50 of 2,468 rows — these rows as CSV