PREVIEW / futures_30min / 2008-07-10
file: by_date/futures_30min/2008/2008-07-10.parquet size: 63 KB rows: 2,196
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-07-10 00:00:00 | ES | Futures | 1160.45 | 1161.38 | 1159.99 | 1161.15 | 1098.0 |
| 2008-07-10 00:30:00 | ES | Futures | 1160.91 | 1161.61 | 1160.22 | 1161.38 | 1894.0 |
| 2008-07-10 01:00:00 | ES | Futures | 1161.38 | 1162.08 | 1160.91 | 1161.84 | 1873.0 |
| 2008-07-10 01:30:00 | ES | Futures | 1161.84 | 1162.08 | 1160.91 | 1160.91 | 921.0 |
| 2008-07-10 02:00:00 | ES | Futures | 1160.91 | 1162.08 | 1159.99 | 1161.38 | 3626.0 |
| 2008-07-10 02:30:00 | ES | Futures | 1160.91 | 1162.31 | 1160.45 | 1161.38 | 2186.0 |
| 2008-07-10 03:00:00 | ES | Futures | 1161.38 | 1163.7 | 1161.15 | 1162.08 | 6871.0 |
| 2008-07-10 03:30:00 | ES | Futures | 1161.84 | 1163.94 | 1160.45 | 1162.54 | 7569.0 |
| 2008-07-10 04:00:00 | ES | Futures | 1162.31 | 1163.01 | 1161.15 | 1161.61 | 7262.0 |
| 2008-07-10 04:30:00 | ES | Futures | 1161.61 | 1163.94 | 1159.99 | 1163.24 | 7677.0 |
| 2008-07-10 05:00:00 | ES | Futures | 1163.24 | 1164.17 | 1162.31 | 1162.77 | 5161.0 |
| 2008-07-10 05:30:00 | ES | Futures | 1162.54 | 1163.24 | 1161.61 | 1162.31 | 3635.0 |
| 2008-07-10 06:00:00 | ES | Futures | 1162.08 | 1163.01 | 1161.84 | 1162.08 | 2691.0 |
| 2008-07-10 06:30:00 | ES | Futures | 1162.08 | 1162.08 | 1159.75 | 1159.99 | 5310.0 |
| 2008-07-10 07:00:00 | ES | Futures | 1160.22 | 1169.51 | 1159.75 | 1168.35 | 31373.0 |
| 2008-07-10 07:30:00 | ES | Futures | 1168.35 | 1170.68 | 1166.26 | 1166.49 | 28484.0 |
| 2008-07-10 08:00:00 | ES | Futures | 1166.49 | 1168.12 | 1165.56 | 1166.49 | 16927.0 |
| 2008-07-10 08:30:00 | ES | Futures | 1166.49 | 1170.21 | 1159.29 | 1159.52 | 74204.0 |
| 2008-07-10 09:00:00 | ES | Futures | 1159.52 | 1159.52 | 1154.87 | 1158.13 | 65275.0 |
| 2008-07-10 09:30:00 | ES | Futures | 1157.89 | 1165.8 | 1156.27 | 1158.59 | 336312.0 |
| 2008-07-10 10:00:00 | ES | Futures | 1158.82 | 1160.22 | 1150.46 | 1155.34 | 367454.0 |
| 2008-07-10 10:30:00 | ES | Futures | 1155.57 | 1161.61 | 1153.71 | 1156.73 | 269048.0 |
| 2008-07-10 11:00:00 | ES | Futures | 1156.5 | 1161.61 | 1154.64 | 1157.2 | 205220.0 |
| 2008-07-10 11:30:00 | ES | Futures | 1156.96 | 1163.7 | 1156.5 | 1160.91 | 160484.0 |
| 2008-07-10 12:00:00 | ES | Futures | 1160.91 | 1166.49 | 1160.91 | 1162.08 | 132038.0 |
| 2008-07-10 12:30:00 | ES | Futures | 1162.08 | 1163.7 | 1158.36 | 1159.29 | 71330.0 |
| 2008-07-10 13:00:00 | ES | Futures | 1159.29 | 1166.03 | 1159.29 | 1165.33 | 105958.0 |
| 2008-07-10 13:30:00 | ES | Futures | 1165.33 | 1170.21 | 1165.1 | 1166.49 | 137847.0 |
| 2008-07-10 14:00:00 | ES | Futures | 1166.73 | 1166.96 | 1155.1 | 1157.43 | 184825.0 |
| 2008-07-10 14:30:00 | ES | Futures | 1157.2 | 1159.29 | 1149.99 | 1152.55 | 202395.0 |
| 2008-07-10 15:00:00 | ES | Futures | 1152.78 | 1163.01 | 1152.08 | 1161.15 | 235352.0 |
| 2008-07-10 15:30:00 | ES | Futures | 1160.91 | 1166.96 | 1155.57 | 1166.49 | 233125.0 |
| 2008-07-10 16:00:00 | ES | Futures | 1166.49 | 1167.42 | 1165.1 | 1166.73 | 68980.0 |
| 2008-07-10 16:30:00 | ES | Futures | 1166.49 | 1169.51 | 1165.8 | 1168.82 | 6023.0 |
| 2008-07-10 17:00:00 | ES | Futures | 1168.58 | 1169.28 | 1166.96 | 1168.35 | 1799.0 |
| 2008-07-10 18:00:00 | ES | Futures | 1167.89 | 1168.12 | 1166.96 | 1167.65 | 1152.0 |
| 2008-07-10 18:30:00 | ES | Futures | 1167.42 | 1168.58 | 1167.19 | 1168.35 | 637.0 |
| 2008-07-10 19:00:00 | ES | Futures | 1168.35 | 1168.82 | 1167.65 | 1167.89 | 577.0 |
| 2008-07-10 19:30:00 | ES | Futures | 1168.12 | 1169.51 | 1166.96 | 1167.42 | 1223.0 |
| 2008-07-10 20:00:00 | ES | Futures | 1167.65 | 1167.89 | 1165.1 | 1165.56 | 1996.0 |
| 2008-07-10 20:30:00 | ES | Futures | 1165.8 | 1166.26 | 1163.7 | 1163.7 | 4084.0 |
| 2008-07-10 21:00:00 | ES | Futures | 1163.94 | 1164.63 | 1163.47 | 1164.4 | 2067.0 |
| 2008-07-10 21:30:00 | ES | Futures | 1164.4 | 1164.87 | 1163.7 | 1164.4 | 954.0 |
| 2008-07-10 22:00:00 | ES | Futures | 1164.63 | 1164.87 | 1162.54 | 1163.01 | 2907.0 |
| 2008-07-10 22:30:00 | ES | Futures | 1163.01 | 1163.94 | 1162.31 | 1163.7 | 1065.0 |
| 2008-07-10 23:00:00 | ES | Futures | 1163.7 | 1164.4 | 1163.47 | 1164.17 | 387.0 |
| 2008-07-10 23:30:00 | ES | Futures | 1164.17 | 1166.03 | 1163.01 | 1165.56 | 1839.0 |
| 2008-07-10 00:00:00 | NQ | Futures | 2061.57 | 2064.1 | 2061.57 | 2063.53 | 100.0 |
| 2008-07-10 00:30:00 | NQ | Futures | 2062.97 | 2064.1 | 2062.41 | 2064.1 | 72.0 |
| 2008-07-10 01:00:00 | NQ | Futures | 2063.82 | 2063.82 | 2062.69 | 2063.53 | 68.0 |
> showing 50 of 2,196 rows — these rows as CSV