PREVIEW / futures_30min / 2008-08-12
file: by_date/futures_30min/2008/2008-08-12.parquet size: 68 KB rows: 2,314
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 |
|---|---|---|---|---|---|---|---|
| 2008-08-12 00:00:00 | ES | Futures | 1212.05 | 1212.98 | 1211.81 | 1212.74 | 293.0 |
| 2008-08-12 00:30:00 | ES | Futures | 1212.74 | 1212.98 | 1212.05 | 1212.28 | 287.0 |
| 2008-08-12 01:00:00 | ES | Futures | 1212.28 | 1212.28 | 1211.35 | 1211.35 | 569.0 |
| 2008-08-12 01:30:00 | ES | Futures | 1211.58 | 1211.58 | 1209.72 | 1210.19 | 3077.0 |
| 2008-08-12 02:00:00 | ES | Futures | 1209.95 | 1211.12 | 1209.72 | 1210.88 | 2155.0 |
| 2008-08-12 02:30:00 | ES | Futures | 1211.12 | 1211.58 | 1209.72 | 1210.42 | 2200.0 |
| 2008-08-12 03:00:00 | ES | Futures | 1210.42 | 1210.88 | 1209.26 | 1210.19 | 7558.0 |
| 2008-08-12 03:30:00 | ES | Futures | 1210.19 | 1210.19 | 1209.02 | 1209.26 | 6244.0 |
| 2008-08-12 04:00:00 | ES | Futures | 1209.26 | 1209.49 | 1208.56 | 1208.79 | 6881.0 |
| 2008-08-12 04:30:00 | ES | Futures | 1208.79 | 1211.58 | 1206.24 | 1211.35 | 18775.0 |
| 2008-08-12 05:00:00 | ES | Futures | 1211.35 | 1212.51 | 1210.88 | 1210.88 | 9181.0 |
| 2008-08-12 05:30:00 | ES | Futures | 1210.88 | 1211.58 | 1209.72 | 1210.42 | 4849.0 |
| 2008-08-12 06:00:00 | ES | Futures | 1210.42 | 1210.65 | 1209.49 | 1209.95 | 2840.0 |
| 2008-08-12 06:30:00 | ES | Futures | 1209.72 | 1213.67 | 1209.49 | 1212.74 | 7696.0 |
| 2008-08-12 07:00:00 | ES | Futures | 1212.74 | 1214.6 | 1212.51 | 1214.37 | 6976.0 |
| 2008-08-12 07:30:00 | ES | Futures | 1214.37 | 1215.76 | 1211.81 | 1212.51 | 17261.0 |
| 2008-08-12 08:00:00 | ES | Futures | 1212.51 | 1213.21 | 1210.65 | 1211.35 | 14831.0 |
| 2008-08-12 08:30:00 | ES | Futures | 1211.58 | 1212.74 | 1209.49 | 1211.35 | 23473.0 |
| 2008-08-12 09:00:00 | ES | Futures | 1211.35 | 1211.81 | 1207.86 | 1209.72 | 24888.0 |
| 2008-08-12 09:30:00 | ES | Futures | 1209.72 | 1210.19 | 1205.54 | 1207.63 | 196247.0 |
| 2008-08-12 10:00:00 | ES | Futures | 1207.63 | 1210.19 | 1204.38 | 1204.61 | 159737.0 |
| 2008-08-12 10:30:00 | ES | Futures | 1204.61 | 1206.24 | 1203.21 | 1205.07 | 116816.0 |
| 2008-08-12 11:00:00 | ES | Futures | 1205.07 | 1209.95 | 1204.38 | 1209.49 | 115829.0 |
| 2008-08-12 11:30:00 | ES | Futures | 1209.49 | 1210.19 | 1206.7 | 1207.17 | 78820.0 |
| 2008-08-12 12:00:00 | ES | Futures | 1207.17 | 1208.1 | 1206.24 | 1207.4 | 45475.0 |
| 2008-08-12 12:30:00 | ES | Futures | 1207.4 | 1208.33 | 1205.77 | 1208.33 | 68851.0 |
| 2008-08-12 13:00:00 | ES | Futures | 1208.1 | 1209.02 | 1204.84 | 1205.31 | 58741.0 |
| 2008-08-12 13:30:00 | ES | Futures | 1205.07 | 1206.7 | 1203.21 | 1204.38 | 85750.0 |
| 2008-08-12 14:00:00 | ES | Futures | 1204.38 | 1207.63 | 1203.21 | 1206.7 | 80722.0 |
| 2008-08-12 14:30:00 | ES | Futures | 1206.7 | 1206.93 | 1202.28 | 1202.52 | 62904.0 |
| 2008-08-12 15:00:00 | ES | Futures | 1202.75 | 1202.98 | 1197.4 | 1199.26 | 196952.0 |
| 2008-08-12 15:30:00 | ES | Futures | 1199.03 | 1200.19 | 1194.85 | 1199.96 | 211640.0 |
| 2008-08-12 16:00:00 | ES | Futures | 1199.96 | 1201.12 | 1199.03 | 1200.89 | 88575.0 |
| 2008-08-12 16:30:00 | ES | Futures | 1200.43 | 1201.82 | 1199.96 | 1201.59 | 8308.0 |
| 2008-08-12 17:00:00 | ES | Futures | 1201.35 | 1202.05 | 1200.89 | 1202.05 | 2131.0 |
| 2008-08-12 18:00:00 | ES | Futures | 1201.82 | 1202.05 | 1201.12 | 1201.12 | 1746.0 |
| 2008-08-12 18:30:00 | ES | Futures | 1201.12 | 1201.35 | 1200.66 | 1201.12 | 1067.0 |
| 2008-08-12 19:00:00 | ES | Futures | 1201.12 | 1201.35 | 1200.89 | 1201.35 | 168.0 |
| 2008-08-12 19:30:00 | ES | Futures | 1201.35 | 1201.59 | 1200.19 | 1200.43 | 1057.0 |
| 2008-08-12 20:00:00 | ES | Futures | 1200.43 | 1201.82 | 1200.19 | 1201.59 | 996.0 |
| 2008-08-12 20:30:00 | ES | Futures | 1201.59 | 1201.82 | 1201.12 | 1201.12 | 785.0 |
| 2008-08-12 21:00:00 | ES | Futures | 1201.12 | 1201.12 | 1200.19 | 1200.43 | 856.0 |
| 2008-08-12 21:30:00 | ES | Futures | 1200.66 | 1200.89 | 1200.19 | 1200.19 | 402.0 |
| 2008-08-12 22:00:00 | ES | Futures | 1200.19 | 1200.66 | 1199.96 | 1200.66 | 360.0 |
| 2008-08-12 22:30:00 | ES | Futures | 1200.66 | 1200.89 | 1200.19 | 1200.19 | 226.0 |
| 2008-08-12 23:00:00 | ES | Futures | 1200.43 | 1200.66 | 1199.96 | 1200.43 | 577.0 |
| 2008-08-12 23:30:00 | ES | Futures | 1200.43 | 1200.89 | 1199.96 | 1200.66 | 332.0 |
| 2008-08-12 00:00:00 | NQ | Futures | 2185.33 | 2186.74 | 2185.05 | 2186.18 | 29.0 |
| 2008-08-12 00:30:00 | NQ | Futures | 2187.02 | 2187.02 | 2184.77 | 2184.77 | 29.0 |
| 2008-08-12 01:00:00 | NQ | Futures | 2184.21 | 2185.05 | 2183.93 | 2183.93 | 15.0 |
> showing 50 of 2,314 rows — these rows as CSV