PREVIEW / futures_30min / 2008-08-18
file: by_date/futures_30min/2008/2008-08-18.parquet size: 63 KB rows: 2,143
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-18 00:00:00 | ES | Futures | 1206.47 | 1206.7 | 1206.24 | 1206.47 | 476.0 |
| 2008-08-18 00:30:00 | ES | Futures | 1206.47 | 1207.17 | 1206.24 | 1207.17 | 417.0 |
| 2008-08-18 01:00:00 | ES | Futures | 1206.93 | 1207.17 | 1206.47 | 1206.7 | 122.0 |
| 2008-08-18 01:30:00 | ES | Futures | 1206.7 | 1207.17 | 1206.47 | 1206.93 | 472.0 |
| 2008-08-18 02:00:00 | ES | Futures | 1206.93 | 1207.86 | 1206.24 | 1207.17 | 1325.0 |
| 2008-08-18 02:30:00 | ES | Futures | 1206.93 | 1207.17 | 1204.38 | 1204.38 | 3056.0 |
| 2008-08-18 03:00:00 | ES | Futures | 1204.38 | 1205.07 | 1203.45 | 1204.38 | 7010.0 |
| 2008-08-18 03:30:00 | ES | Futures | 1204.14 | 1205.77 | 1203.91 | 1204.84 | 4142.0 |
| 2008-08-18 04:00:00 | ES | Futures | 1204.84 | 1204.84 | 1202.98 | 1204.61 | 6214.0 |
| 2008-08-18 04:30:00 | ES | Futures | 1204.61 | 1205.77 | 1204.38 | 1205.54 | 2617.0 |
| 2008-08-18 05:00:00 | ES | Futures | 1205.77 | 1206.0 | 1204.84 | 1205.54 | 2126.0 |
| 2008-08-18 05:30:00 | ES | Futures | 1205.54 | 1207.4 | 1205.54 | 1205.77 | 3095.0 |
| 2008-08-18 06:00:00 | ES | Futures | 1205.77 | 1214.14 | 1205.54 | 1212.51 | 13048.0 |
| 2008-08-18 06:30:00 | ES | Futures | 1212.51 | 1213.67 | 1209.26 | 1212.98 | 13239.0 |
| 2008-08-18 07:00:00 | ES | Futures | 1213.21 | 1213.91 | 1211.12 | 1212.51 | 8031.0 |
| 2008-08-18 07:30:00 | ES | Futures | 1212.74 | 1212.74 | 1211.12 | 1211.58 | 4139.0 |
| 2008-08-18 08:00:00 | ES | Futures | 1211.35 | 1212.28 | 1210.65 | 1211.35 | 4451.0 |
| 2008-08-18 08:30:00 | ES | Futures | 1211.35 | 1213.91 | 1210.88 | 1213.67 | 12598.0 |
| 2008-08-18 09:00:00 | ES | Futures | 1213.67 | 1213.91 | 1210.65 | 1210.65 | 25358.0 |
| 2008-08-18 09:30:00 | ES | Futures | 1210.88 | 1211.12 | 1201.12 | 1202.98 | 188769.0 |
| 2008-08-18 10:00:00 | ES | Futures | 1202.98 | 1203.45 | 1199.73 | 1202.52 | 141365.0 |
| 2008-08-18 10:30:00 | ES | Futures | 1202.52 | 1204.61 | 1201.12 | 1203.68 | 106200.0 |
| 2008-08-18 11:00:00 | ES | Futures | 1203.91 | 1205.07 | 1202.28 | 1203.45 | 89650.0 |
| 2008-08-18 11:30:00 | ES | Futures | 1203.45 | 1203.45 | 1197.87 | 1197.87 | 69105.0 |
| 2008-08-18 12:00:00 | ES | Futures | 1198.1 | 1198.1 | 1195.31 | 1197.64 | 109862.0 |
| 2008-08-18 12:30:00 | ES | Futures | 1197.4 | 1197.87 | 1191.83 | 1192.52 | 111781.0 |
| 2008-08-18 13:00:00 | ES | Futures | 1192.52 | 1194.38 | 1191.36 | 1193.45 | 82260.0 |
| 2008-08-18 13:30:00 | ES | Futures | 1193.45 | 1194.15 | 1189.5 | 1189.5 | 73064.0 |
| 2008-08-18 14:00:00 | ES | Futures | 1189.5 | 1189.97 | 1186.95 | 1188.11 | 120094.0 |
| 2008-08-18 14:30:00 | ES | Futures | 1188.11 | 1189.27 | 1186.02 | 1188.8 | 86446.0 |
| 2008-08-18 15:00:00 | ES | Futures | 1188.8 | 1190.2 | 1184.85 | 1188.34 | 125076.0 |
| 2008-08-18 15:30:00 | ES | Futures | 1188.34 | 1190.66 | 1184.39 | 1189.97 | 179597.0 |
| 2008-08-18 16:00:00 | ES | Futures | 1189.97 | 1192.29 | 1189.27 | 1192.06 | 85513.0 |
| 2008-08-18 16:30:00 | ES | Futures | 1191.83 | 1192.76 | 1191.59 | 1192.06 | 2837.0 |
| 2008-08-18 17:00:00 | ES | Futures | 1192.06 | 1192.76 | 1192.06 | 1192.52 | 743.0 |
| 2008-08-18 18:00:00 | ES | Futures | 1192.29 | 1192.76 | 1191.36 | 1191.59 | 883.0 |
| 2008-08-18 18:30:00 | ES | Futures | 1191.83 | 1192.06 | 1191.36 | 1192.06 | 854.0 |
| 2008-08-18 19:00:00 | ES | Futures | 1192.06 | 1192.06 | 1191.59 | 1191.83 | 315.0 |
| 2008-08-18 19:30:00 | ES | Futures | 1191.59 | 1192.06 | 1191.13 | 1191.13 | 699.0 |
| 2008-08-18 20:00:00 | ES | Futures | 1191.13 | 1191.36 | 1190.2 | 1190.9 | 926.0 |
| 2008-08-18 20:30:00 | ES | Futures | 1190.66 | 1190.9 | 1190.2 | 1190.66 | 443.0 |
| 2008-08-18 21:00:00 | ES | Futures | 1190.66 | 1190.66 | 1189.73 | 1190.2 | 1124.0 |
| 2008-08-18 21:30:00 | ES | Futures | 1190.2 | 1190.66 | 1189.97 | 1190.2 | 385.0 |
| 2008-08-18 22:00:00 | ES | Futures | 1190.43 | 1190.9 | 1189.97 | 1190.9 | 641.0 |
| 2008-08-18 22:30:00 | ES | Futures | 1190.9 | 1191.36 | 1190.43 | 1190.9 | 468.0 |
| 2008-08-18 23:00:00 | ES | Futures | 1190.9 | 1191.83 | 1190.9 | 1191.83 | 501.0 |
| 2008-08-18 23:30:00 | ES | Futures | 1191.83 | 1192.29 | 1191.59 | 1192.06 | 612.0 |
| 2008-08-18 00:00:00 | NQ | Futures | 2207.55 | 2208.4 | 2207.55 | 2208.12 | 79.0 |
| 2008-08-18 00:30:00 | NQ | Futures | 2208.12 | 2208.4 | 2207.84 | 2208.4 | 43.0 |
| 2008-08-18 01:00:00 | NQ | Futures | 2208.68 | 2208.68 | 2207.55 | 2207.55 | 44.0 |
> showing 50 of 2,143 rows — these rows as CSV