PREVIEW / futures_30min / 2008-03-11
file: by_date/futures_30min/2008/2008-03-11.parquet size: 66 KB rows: 2,148
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-03-11 00:00:00 | ES | Futures | 1193.29 | 1193.76 | 1191.19 | 1192.36 | 2009.0 |
| 2008-03-11 00:30:00 | ES | Futures | 1192.36 | 1194.23 | 1192.36 | 1193.99 | 682.0 |
| 2008-03-11 01:00:00 | ES | Futures | 1194.23 | 1194.69 | 1193.53 | 1193.53 | 1071.0 |
| 2008-03-11 01:30:00 | ES | Futures | 1193.53 | 1194.69 | 1192.36 | 1193.76 | 1199.0 |
| 2008-03-11 02:00:00 | ES | Futures | 1194.23 | 1194.69 | 1193.99 | 1194.69 | 830.0 |
| 2008-03-11 02:30:00 | ES | Futures | 1194.69 | 1195.16 | 1193.76 | 1194.69 | 2871.0 |
| 2008-03-11 03:00:00 | ES | Futures | 1194.93 | 1197.26 | 1194.69 | 1195.86 | 6105.0 |
| 2008-03-11 03:30:00 | ES | Futures | 1195.86 | 1196.32 | 1194.69 | 1195.39 | 3093.0 |
| 2008-03-11 04:00:00 | ES | Futures | 1195.39 | 1196.32 | 1191.89 | 1193.53 | 11229.0 |
| 2008-03-11 04:30:00 | ES | Futures | 1193.53 | 1194.69 | 1192.13 | 1193.29 | 7891.0 |
| 2008-03-11 05:00:00 | ES | Futures | 1193.29 | 1197.96 | 1193.29 | 1197.02 | 12006.0 |
| 2008-03-11 05:30:00 | ES | Futures | 1197.02 | 1198.89 | 1196.56 | 1197.96 | 12772.0 |
| 2008-03-11 06:00:00 | ES | Futures | 1197.96 | 1199.59 | 1197.02 | 1197.26 | 13046.0 |
| 2008-03-11 06:30:00 | ES | Futures | 1197.26 | 1199.12 | 1196.09 | 1198.89 | 8769.0 |
| 2008-03-11 07:00:00 | ES | Futures | 1198.66 | 1200.29 | 1197.26 | 1197.26 | 16040.0 |
| 2008-03-11 07:30:00 | ES | Futures | 1197.26 | 1199.82 | 1196.32 | 1196.79 | 20864.0 |
| 2008-03-11 08:00:00 | ES | Futures | 1196.79 | 1197.02 | 1194.46 | 1196.32 | 22003.0 |
| 2008-03-11 08:30:00 | ES | Futures | 1196.32 | 1221.27 | 1196.32 | 1217.31 | 244956.0 |
| 2008-03-11 09:00:00 | ES | Futures | 1217.31 | 1218.94 | 1213.81 | 1215.91 | 73558.0 |
| 2008-03-11 09:30:00 | ES | Futures | 1215.91 | 1218.24 | 1210.55 | 1210.78 | 265338.0 |
| 2008-03-11 10:00:00 | ES | Futures | 1210.55 | 1214.28 | 1208.68 | 1212.65 | 211321.0 |
| 2008-03-11 10:30:00 | ES | Futures | 1212.65 | 1212.88 | 1208.22 | 1211.95 | 151142.0 |
| 2008-03-11 11:00:00 | ES | Futures | 1211.95 | 1213.11 | 1205.88 | 1209.61 | 152772.0 |
| 2008-03-11 11:30:00 | ES | Futures | 1209.61 | 1210.78 | 1199.82 | 1201.92 | 206816.0 |
| 2008-03-11 12:00:00 | ES | Futures | 1202.15 | 1207.28 | 1201.69 | 1204.72 | 157012.0 |
| 2008-03-11 12:30:00 | ES | Futures | 1204.72 | 1206.35 | 1199.59 | 1204.95 | 165164.0 |
| 2008-03-11 13:00:00 | ES | Futures | 1205.18 | 1211.01 | 1202.39 | 1210.55 | 171514.0 |
| 2008-03-11 13:30:00 | ES | Futures | 1210.55 | 1212.88 | 1206.82 | 1212.18 | 136294.0 |
| 2008-03-11 14:00:00 | ES | Futures | 1212.18 | 1215.91 | 1211.25 | 1213.58 | 128365.0 |
| 2008-03-11 14:30:00 | ES | Futures | 1213.58 | 1223.6 | 1212.65 | 1221.27 | 230916.0 |
| 2008-03-11 15:00:00 | ES | Futures | 1221.27 | 1226.87 | 1219.17 | 1226.4 | 216733.0 |
| 2008-03-11 15:30:00 | ES | Futures | 1226.4 | 1232.46 | 1222.44 | 1231.53 | 293675.0 |
| 2008-03-11 16:00:00 | ES | Futures | 1231.53 | 1235.03 | 1230.83 | 1234.56 | 142305.0 |
| 2008-03-11 16:30:00 | ES | Futures | 1233.86 | 1235.26 | 1233.4 | 1235.26 | 10654.0 |
| 2008-03-11 17:00:00 | ES | Futures | 1235.03 | 1237.36 | 1234.8 | 1237.36 | 5338.0 |
| 2008-03-11 18:00:00 | ES | Futures | 1237.13 | 1238.76 | 1236.66 | 1236.89 | 5256.0 |
| 2008-03-11 18:30:00 | ES | Futures | 1236.89 | 1237.83 | 1235.96 | 1236.66 | 1912.0 |
| 2008-03-11 19:00:00 | ES | Futures | 1236.43 | 1237.59 | 1236.19 | 1236.89 | 1094.0 |
| 2008-03-11 19:30:00 | ES | Futures | 1236.89 | 1236.89 | 1234.8 | 1235.96 | 2295.0 |
| 2008-03-11 20:00:00 | ES | Futures | 1235.96 | 1236.19 | 1235.03 | 1235.49 | 1150.0 |
| 2008-03-11 20:30:00 | ES | Futures | 1235.49 | 1235.96 | 1234.56 | 1234.56 | 1801.0 |
| 2008-03-11 21:00:00 | ES | Futures | 1234.56 | 1235.03 | 1234.1 | 1234.56 | 1719.0 |
| 2008-03-11 21:30:00 | ES | Futures | 1234.8 | 1235.03 | 1234.1 | 1234.56 | 815.0 |
| 2008-03-11 22:00:00 | ES | Futures | 1234.56 | 1235.03 | 1234.33 | 1234.33 | 856.0 |
| 2008-03-11 22:30:00 | ES | Futures | 1234.56 | 1234.8 | 1234.1 | 1234.56 | 948.0 |
| 2008-03-11 23:00:00 | ES | Futures | 1234.33 | 1234.56 | 1233.86 | 1234.1 | 1061.0 |
| 2008-03-11 23:30:00 | ES | Futures | 1234.33 | 1234.33 | 1233.16 | 1233.16 | 1905.0 |
| 2008-03-11 00:00:00 | NQ | Futures | 1905.16 | 1905.44 | 1902.6 | 1903.74 | 204.0 |
| 2008-03-11 00:30:00 | NQ | Futures | 1904.59 | 1907.71 | 1904.59 | 1907.71 | 64.0 |
| 2008-03-11 01:00:00 | NQ | Futures | 1907.71 | 1909.42 | 1907.71 | 1908.56 | 92.0 |
> showing 50 of 2,148 rows — these rows as CSV