PREVIEW / futures_30min / 2008-07-11
file: by_date/futures_30min/2008/2008-07-11.parquet size: 60 KB rows: 1,840
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-11 00:00:00 | ES | Futures | 1165.8 | 1173.0 | 1165.56 | 1166.49 | 9545.0 |
| 2008-07-11 00:30:00 | ES | Futures | 1166.49 | 1167.42 | 1164.4 | 1165.8 | 2997.0 |
| 2008-07-11 01:00:00 | ES | Futures | 1165.8 | 1167.89 | 1165.1 | 1167.19 | 1490.0 |
| 2008-07-11 01:30:00 | ES | Futures | 1167.42 | 1167.65 | 1165.8 | 1167.42 | 1449.0 |
| 2008-07-11 02:00:00 | ES | Futures | 1167.42 | 1167.65 | 1165.33 | 1166.73 | 1467.0 |
| 2008-07-11 02:30:00 | ES | Futures | 1166.26 | 1168.12 | 1165.1 | 1165.33 | 2179.0 |
| 2008-07-11 03:00:00 | ES | Futures | 1165.56 | 1166.73 | 1163.24 | 1164.63 | 8051.0 |
| 2008-07-11 03:30:00 | ES | Futures | 1164.63 | 1165.8 | 1162.31 | 1162.54 | 6863.0 |
| 2008-07-11 04:00:00 | ES | Futures | 1162.54 | 1163.94 | 1162.08 | 1163.94 | 3656.0 |
| 2008-07-11 04:30:00 | ES | Futures | 1163.94 | 1166.49 | 1163.7 | 1164.4 | 6420.0 |
| 2008-07-11 05:00:00 | ES | Futures | 1164.4 | 1165.1 | 1163.47 | 1163.7 | 3930.0 |
| 2008-07-11 05:30:00 | ES | Futures | 1163.7 | 1164.17 | 1161.61 | 1161.84 | 23454.0 |
| 2008-07-11 06:00:00 | ES | Futures | 1161.84 | 1162.08 | 1157.43 | 1160.22 | 15840.0 |
| 2008-07-11 06:30:00 | ES | Futures | 1160.22 | 1163.01 | 1156.03 | 1159.29 | 24868.0 |
| 2008-07-11 07:00:00 | ES | Futures | 1159.06 | 1159.75 | 1152.55 | 1155.8 | 34928.0 |
| 2008-07-11 07:30:00 | ES | Futures | 1155.8 | 1156.96 | 1150.92 | 1154.41 | 34340.0 |
| 2008-07-11 08:00:00 | ES | Futures | 1154.41 | 1155.8 | 1149.99 | 1151.85 | 30080.0 |
| 2008-07-11 08:30:00 | ES | Futures | 1152.08 | 1153.94 | 1150.46 | 1151.85 | 39141.0 |
| 2008-07-11 09:00:00 | ES | Futures | 1151.85 | 1154.41 | 1149.76 | 1152.78 | 59283.0 |
| 2008-07-11 09:30:00 | ES | Futures | 1152.78 | 1157.66 | 1146.97 | 1156.5 | 308781.0 |
| 2008-07-11 10:00:00 | ES | Futures | 1156.5 | 1159.29 | 1145.58 | 1149.06 | 299757.0 |
| 2008-07-11 10:30:00 | ES | Futures | 1148.83 | 1152.08 | 1145.34 | 1150.22 | 235751.0 |
| 2008-07-11 11:00:00 | ES | Futures | 1150.46 | 1152.32 | 1144.41 | 1144.41 | 161055.0 |
| 2008-07-11 11:30:00 | ES | Futures | 1144.65 | 1149.06 | 1140.69 | 1148.6 | 232432.0 |
| 2008-07-11 12:00:00 | ES | Futures | 1148.83 | 1148.83 | 1143.95 | 1146.04 | 96276.0 |
| 2008-07-11 12:30:00 | ES | Futures | 1145.81 | 1146.04 | 1139.53 | 1142.32 | 103531.0 |
| 2008-07-11 13:00:00 | ES | Futures | 1142.09 | 1145.81 | 1139.3 | 1144.65 | 133353.0 |
| 2008-07-11 13:30:00 | ES | Futures | 1144.65 | 1151.39 | 1143.72 | 1148.6 | 148892.0 |
| 2008-07-11 14:00:00 | ES | Futures | 1148.6 | 1154.17 | 1144.88 | 1146.04 | 190262.0 |
| 2008-07-11 14:30:00 | ES | Futures | 1146.04 | 1163.47 | 1143.95 | 1162.08 | 280128.0 |
| 2008-07-11 15:00:00 | ES | Futures | 1162.08 | 1169.98 | 1152.08 | 1154.41 | 384021.0 |
| 2008-07-11 15:30:00 | ES | Futures | 1154.64 | 1156.73 | 1148.83 | 1153.71 | 262832.0 |
| 2008-07-11 16:00:00 | ES | Futures | 1153.94 | 1154.64 | 1152.32 | 1152.55 | 76671.0 |
| 2008-07-11 00:00:00 | NQ | Futures | 2077.32 | 2093.07 | 2077.32 | 2081.54 | 1443.0 |
| 2008-07-11 00:30:00 | NQ | Futures | 2081.54 | 2082.1 | 2077.04 | 2079.01 | 97.0 |
| 2008-07-11 01:00:00 | NQ | Futures | 2080.13 | 2083.51 | 2078.72 | 2083.22 | 85.0 |
| 2008-07-11 01:30:00 | NQ | Futures | 2082.66 | 2083.22 | 2080.97 | 2082.38 | 212.0 |
| 2008-07-11 02:00:00 | NQ | Futures | 2082.66 | 2082.66 | 2076.76 | 2078.44 | 334.0 |
| 2008-07-11 02:30:00 | NQ | Futures | 2078.16 | 2080.41 | 2075.07 | 2075.35 | 276.0 |
| 2008-07-11 03:00:00 | NQ | Futures | 2075.63 | 2077.6 | 2071.97 | 2073.38 | 448.0 |
| 2008-07-11 03:30:00 | NQ | Futures | 2072.54 | 2075.35 | 2068.6 | 2069.44 | 618.0 |
| 2008-07-11 04:00:00 | NQ | Futures | 2069.16 | 2072.25 | 2068.88 | 2072.25 | 228.0 |
| 2008-07-11 04:30:00 | NQ | Futures | 2071.97 | 2077.04 | 2071.97 | 2075.35 | 781.0 |
| 2008-07-11 05:00:00 | NQ | Futures | 2075.63 | 2077.88 | 2073.38 | 2074.22 | 634.0 |
| 2008-07-11 05:30:00 | NQ | Futures | 2073.1 | 2073.1 | 2065.78 | 2067.75 | 1156.0 |
| 2008-07-11 06:00:00 | NQ | Futures | 2067.75 | 2067.75 | 2061.57 | 2066.35 | 1383.0 |
| 2008-07-11 06:30:00 | NQ | Futures | 2066.63 | 2070.29 | 2059.88 | 2064.66 | 1945.0 |
| 2008-07-11 07:00:00 | NQ | Futures | 2064.66 | 2066.07 | 2050.88 | 2058.75 | 2681.0 |
| 2008-07-11 07:30:00 | NQ | Futures | 2059.03 | 2061.28 | 2051.72 | 2057.35 | 3871.0 |
| 2008-07-11 08:00:00 | NQ | Futures | 2057.35 | 2060.44 | 2049.19 | 2051.44 | 4755.0 |
> showing 50 of 1,840 rows — these rows as CSV