PREVIEW / futures_30min / 2010-06-17
file: by_date/futures_30min/2010/2010-06-17.parquet size: 69 KB rows: 2,478
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-06-17 00:00:00 | ES | Futures | 1084.33 | 1084.58 | 1083.6 | 1084.33 | 1666.0 |
| 2010-06-17 00:30:00 | ES | Futures | 1084.33 | 1084.58 | 1083.6 | 1083.84 | 838.0 |
| 2010-06-17 01:00:00 | ES | Futures | 1083.84 | 1084.09 | 1083.11 | 1083.84 | 2033.0 |
| 2010-06-17 01:30:00 | ES | Futures | 1083.6 | 1084.58 | 1083.11 | 1084.33 | 2228.0 |
| 2010-06-17 02:00:00 | ES | Futures | 1084.58 | 1085.56 | 1083.84 | 1085.07 | 6389.0 |
| 2010-06-17 02:30:00 | ES | Futures | 1085.31 | 1086.05 | 1084.58 | 1085.07 | 3926.0 |
| 2010-06-17 03:00:00 | ES | Futures | 1085.07 | 1086.05 | 1083.11 | 1084.58 | 17856.0 |
| 2010-06-17 03:30:00 | ES | Futures | 1084.33 | 1086.54 | 1084.09 | 1084.82 | 19041.0 |
| 2010-06-17 04:00:00 | ES | Futures | 1084.82 | 1088.01 | 1084.33 | 1088.01 | 15313.0 |
| 2010-06-17 04:30:00 | ES | Futures | 1088.01 | 1090.22 | 1088.01 | 1088.5 | 17119.0 |
| 2010-06-17 05:00:00 | ES | Futures | 1088.5 | 1092.92 | 1088.26 | 1091.69 | 20074.0 |
| 2010-06-17 05:30:00 | ES | Futures | 1091.69 | 1094.15 | 1091.69 | 1092.43 | 15617.0 |
| 2010-06-17 06:00:00 | ES | Futures | 1092.43 | 1093.41 | 1091.45 | 1092.18 | 8449.0 |
| 2010-06-17 06:30:00 | ES | Futures | 1092.43 | 1093.17 | 1091.45 | 1093.17 | 10513.0 |
| 2010-06-17 07:00:00 | ES | Futures | 1093.17 | 1094.64 | 1092.92 | 1094.15 | 17494.0 |
| 2010-06-17 07:30:00 | ES | Futures | 1094.15 | 1094.88 | 1093.66 | 1093.9 | 13001.0 |
| 2010-06-17 08:00:00 | ES | Futures | 1093.66 | 1095.37 | 1093.41 | 1094.64 | 24066.0 |
| 2010-06-17 08:30:00 | ES | Futures | 1094.39 | 1096.85 | 1089.49 | 1092.18 | 97918.0 |
| 2010-06-17 09:00:00 | ES | Futures | 1092.43 | 1094.15 | 1091.2 | 1092.67 | 44706.0 |
| 2010-06-17 09:30:00 | ES | Futures | 1092.43 | 1093.17 | 1087.77 | 1090.71 | 232273.0 |
| 2010-06-17 10:00:00 | ES | Futures | 1090.71 | 1090.71 | 1082.12 | 1083.84 | 328358.0 |
| 2010-06-17 10:30:00 | ES | Futures | 1084.09 | 1084.09 | 1080.9 | 1082.86 | 195589.0 |
| 2010-06-17 11:00:00 | ES | Futures | 1082.86 | 1086.05 | 1080.41 | 1084.82 | 158493.0 |
| 2010-06-17 11:30:00 | ES | Futures | 1085.07 | 1087.52 | 1084.82 | 1086.54 | 97119.0 |
| 2010-06-17 12:00:00 | ES | Futures | 1086.54 | 1087.52 | 1084.33 | 1084.82 | 82843.0 |
| 2010-06-17 12:30:00 | ES | Futures | 1085.07 | 1085.8 | 1083.11 | 1085.31 | 55810.0 |
| 2010-06-17 13:00:00 | ES | Futures | 1085.07 | 1087.03 | 1083.6 | 1085.8 | 63028.0 |
| 2010-06-17 13:30:00 | ES | Futures | 1086.05 | 1089.24 | 1084.82 | 1088.99 | 93182.0 |
| 2010-06-17 14:00:00 | ES | Futures | 1088.99 | 1089.98 | 1086.54 | 1086.79 | 92078.0 |
| 2010-06-17 14:30:00 | ES | Futures | 1086.79 | 1088.01 | 1084.33 | 1085.8 | 99692.0 |
| 2010-06-17 15:00:00 | ES | Futures | 1085.8 | 1086.05 | 1081.63 | 1082.61 | 163010.0 |
| 2010-06-17 15:30:00 | ES | Futures | 1082.61 | 1091.94 | 1082.37 | 1090.96 | 293758.0 |
| 2010-06-17 16:00:00 | ES | Futures | 1090.96 | 1091.94 | 1089.98 | 1091.2 | 92556.0 |
| 2010-06-17 16:30:00 | ES | Futures | 1090.96 | 1091.2 | 1089.98 | 1090.71 | 5599.0 |
| 2010-06-17 17:00:00 | ES | Futures | 1090.47 | 1091.2 | 1089.98 | 1090.47 | 2781.0 |
| 2010-06-17 18:00:00 | ES | Futures | 1090.47 | 1091.2 | 1089.73 | 1089.98 | 1946.0 |
| 2010-06-17 18:30:00 | ES | Futures | 1089.73 | 1090.22 | 1089.73 | 1089.98 | 735.0 |
| 2010-06-17 19:00:00 | ES | Futures | 1089.98 | 1090.22 | 1089.73 | 1089.98 | 569.0 |
| 2010-06-17 19:30:00 | ES | Futures | 1089.98 | 1090.47 | 1089.73 | 1090.22 | 706.0 |
| 2010-06-17 20:00:00 | ES | Futures | 1089.98 | 1090.47 | 1088.99 | 1089.24 | 2412.0 |
| 2010-06-17 20:30:00 | ES | Futures | 1088.99 | 1090.71 | 1088.75 | 1090.71 | 2250.0 |
| 2010-06-17 21:00:00 | ES | Futures | 1090.71 | 1091.2 | 1089.98 | 1090.47 | 2043.0 |
| 2010-06-17 21:30:00 | ES | Futures | 1090.47 | 1090.47 | 1089.24 | 1089.98 | 1670.0 |
| 2010-06-17 22:00:00 | ES | Futures | 1090.22 | 1091.45 | 1089.73 | 1091.45 | 1904.0 |
| 2010-06-17 22:30:00 | ES | Futures | 1091.2 | 1091.45 | 1090.96 | 1091.2 | 995.0 |
| 2010-06-17 23:00:00 | ES | Futures | 1091.2 | 1091.45 | 1090.96 | 1090.96 | 495.0 |
| 2010-06-17 23:30:00 | ES | Futures | 1090.96 | 1091.94 | 1090.96 | 1091.69 | 1820.0 |
| 2010-06-17 00:00:00 | NQ | Futures | 2175.9 | 2175.9 | 2174.75 | 2175.61 | 134.0 |
| 2010-06-17 00:30:00 | NQ | Futures | 2175.9 | 2176.47 | 2175.32 | 2175.32 | 251.0 |
| 2010-06-17 01:00:00 | NQ | Futures | 2175.32 | 2175.32 | 2174.46 | 2174.75 | 148.0 |
> showing 50 of 2,478 rows — these rows as CSV