PREVIEW / futures_30min / 2008-07-14
file: by_date/futures_30min/2008/2008-07-14.parquet size: 66 KB rows: 2,208
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-14 00:00:00 | ES | Futures | 1163.24 | 1163.47 | 1160.91 | 1161.15 | 1787.0 |
| 2008-07-14 00:30:00 | ES | Futures | 1161.38 | 1162.31 | 1160.68 | 1161.15 | 738.0 |
| 2008-07-14 01:00:00 | ES | Futures | 1161.15 | 1163.01 | 1160.91 | 1161.38 | 879.0 |
| 2008-07-14 01:30:00 | ES | Futures | 1161.38 | 1164.17 | 1160.68 | 1163.01 | 1358.0 |
| 2008-07-14 02:00:00 | ES | Futures | 1163.01 | 1164.87 | 1160.68 | 1161.38 | 3897.0 |
| 2008-07-14 02:30:00 | ES | Futures | 1161.61 | 1164.87 | 1160.91 | 1164.4 | 3373.0 |
| 2008-07-14 03:00:00 | ES | Futures | 1164.4 | 1166.26 | 1162.31 | 1165.1 | 10999.0 |
| 2008-07-14 03:30:00 | ES | Futures | 1165.33 | 1165.56 | 1163.24 | 1164.17 | 4576.0 |
| 2008-07-14 04:00:00 | ES | Futures | 1164.4 | 1165.1 | 1163.24 | 1164.4 | 5074.0 |
| 2008-07-14 04:30:00 | ES | Futures | 1164.17 | 1164.63 | 1160.91 | 1160.91 | 10496.0 |
| 2008-07-14 05:00:00 | ES | Futures | 1161.15 | 1161.15 | 1159.06 | 1159.75 | 6098.0 |
| 2008-07-14 05:30:00 | ES | Futures | 1159.75 | 1163.47 | 1159.52 | 1163.24 | 5030.0 |
| 2008-07-14 06:00:00 | ES | Futures | 1163.01 | 1165.8 | 1162.31 | 1165.56 | 9780.0 |
| 2008-07-14 06:30:00 | ES | Futures | 1165.56 | 1167.65 | 1165.56 | 1167.19 | 11007.0 |
| 2008-07-14 07:00:00 | ES | Futures | 1167.42 | 1171.84 | 1167.19 | 1169.51 | 29861.0 |
| 2008-07-14 07:30:00 | ES | Futures | 1169.51 | 1169.51 | 1166.73 | 1167.65 | 12214.0 |
| 2008-07-14 08:00:00 | ES | Futures | 1167.65 | 1169.05 | 1167.19 | 1168.12 | 13528.0 |
| 2008-07-14 08:30:00 | ES | Futures | 1168.35 | 1168.35 | 1166.73 | 1166.96 | 14912.0 |
| 2008-07-14 09:00:00 | ES | Futures | 1166.96 | 1167.42 | 1164.87 | 1165.56 | 39260.0 |
| 2008-07-14 09:30:00 | ES | Futures | 1165.33 | 1167.65 | 1155.57 | 1155.8 | 320933.0 |
| 2008-07-14 10:00:00 | ES | Futures | 1156.03 | 1159.52 | 1150.92 | 1153.01 | 296486.0 |
| 2008-07-14 10:30:00 | ES | Futures | 1152.78 | 1156.73 | 1150.46 | 1156.27 | 218270.0 |
| 2008-07-14 11:00:00 | ES | Futures | 1156.27 | 1157.2 | 1148.6 | 1150.92 | 165759.0 |
| 2008-07-14 11:30:00 | ES | Futures | 1150.69 | 1151.62 | 1139.53 | 1144.41 | 218372.0 |
| 2008-07-14 12:00:00 | ES | Futures | 1144.41 | 1146.04 | 1141.39 | 1143.72 | 163595.0 |
| 2008-07-14 12:30:00 | ES | Futures | 1143.72 | 1145.58 | 1140.46 | 1143.02 | 109669.0 |
| 2008-07-14 13:00:00 | ES | Futures | 1143.02 | 1143.48 | 1138.6 | 1142.55 | 130052.0 |
| 2008-07-14 13:30:00 | ES | Futures | 1142.79 | 1147.67 | 1140.69 | 1145.11 | 120910.0 |
| 2008-07-14 14:00:00 | ES | Futures | 1145.11 | 1147.9 | 1143.95 | 1146.04 | 88933.0 |
| 2008-07-14 14:30:00 | ES | Futures | 1146.04 | 1147.9 | 1141.16 | 1143.02 | 110565.0 |
| 2008-07-14 15:00:00 | ES | Futures | 1143.02 | 1149.06 | 1140.0 | 1147.67 | 147954.0 |
| 2008-07-14 15:30:00 | ES | Futures | 1147.43 | 1151.62 | 1141.39 | 1142.55 | 248700.0 |
| 2008-07-14 16:00:00 | ES | Futures | 1142.79 | 1143.25 | 1140.69 | 1142.09 | 87975.0 |
| 2008-07-14 16:30:00 | ES | Futures | 1142.55 | 1142.79 | 1140.93 | 1142.32 | 6219.0 |
| 2008-07-14 17:00:00 | ES | Futures | 1142.32 | 1142.79 | 1140.93 | 1141.62 | 2741.0 |
| 2008-07-14 18:00:00 | ES | Futures | 1141.62 | 1143.02 | 1141.62 | 1142.32 | 1242.0 |
| 2008-07-14 18:30:00 | ES | Futures | 1142.55 | 1143.02 | 1141.62 | 1142.09 | 1167.0 |
| 2008-07-14 19:00:00 | ES | Futures | 1142.09 | 1142.09 | 1141.16 | 1141.86 | 526.0 |
| 2008-07-14 19:30:00 | ES | Futures | 1142.09 | 1142.79 | 1141.86 | 1142.55 | 693.0 |
| 2008-07-14 20:00:00 | ES | Futures | 1142.32 | 1142.79 | 1141.39 | 1141.62 | 783.0 |
| 2008-07-14 20:30:00 | ES | Futures | 1141.62 | 1141.86 | 1141.16 | 1141.39 | 615.0 |
| 2008-07-14 21:00:00 | ES | Futures | 1141.39 | 1141.62 | 1140.69 | 1141.39 | 1294.0 |
| 2008-07-14 21:30:00 | ES | Futures | 1141.39 | 1141.39 | 1140.46 | 1141.16 | 825.0 |
| 2008-07-14 22:00:00 | ES | Futures | 1141.16 | 1141.62 | 1140.46 | 1141.16 | 1045.0 |
| 2008-07-14 22:30:00 | ES | Futures | 1141.16 | 1141.39 | 1134.65 | 1136.28 | 8574.0 |
| 2008-07-14 23:00:00 | ES | Futures | 1136.28 | 1137.91 | 1135.12 | 1137.67 | 2140.0 |
| 2008-07-14 23:30:00 | ES | Futures | 1137.67 | 1137.67 | 1136.51 | 1136.51 | 766.0 |
| 2008-07-14 00:00:00 | NQ | Futures | 2066.35 | 2066.35 | 2062.69 | 2063.25 | 146.0 |
| 2008-07-14 00:30:00 | NQ | Futures | 2063.25 | 2064.1 | 2062.69 | 2062.69 | 56.0 |
| 2008-07-14 01:00:00 | NQ | Futures | 2064.38 | 2066.35 | 2063.25 | 2063.25 | 40.0 |
> showing 50 of 2,208 rows — these rows as CSV