PREVIEW / futures_30min / 2008-01-18
file: by_date/futures_30min/2008/2008-01-18.parquet size: 37 KB rows: 1,126
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-01-18 00:00:00 | ES | Futures | 1258.11 | 1259.28 | 1257.88 | 1259.28 | 5728.0 |
| 2008-01-18 00:30:00 | ES | Futures | 1259.28 | 1259.98 | 1259.04 | 1259.74 | 2348.0 |
| 2008-01-18 01:00:00 | ES | Futures | 1259.98 | 1259.98 | 1258.81 | 1259.74 | 1242.0 |
| 2008-01-18 01:30:00 | ES | Futures | 1259.74 | 1260.21 | 1259.04 | 1259.04 | 2396.0 |
| 2008-01-18 02:00:00 | ES | Futures | 1259.04 | 1261.84 | 1258.11 | 1261.37 | 7237.0 |
| 2008-01-18 02:30:00 | ES | Futures | 1261.37 | 1262.31 | 1259.98 | 1262.07 | 5449.0 |
| 2008-01-18 03:00:00 | ES | Futures | 1261.84 | 1262.31 | 1255.55 | 1259.04 | 15384.0 |
| 2008-01-18 03:30:00 | ES | Futures | 1259.04 | 1259.51 | 1256.71 | 1257.64 | 7630.0 |
| 2008-01-18 04:00:00 | ES | Futures | 1257.88 | 1258.34 | 1254.15 | 1258.11 | 13980.0 |
| 2008-01-18 04:30:00 | ES | Futures | 1257.88 | 1259.28 | 1255.31 | 1258.58 | 13276.0 |
| 2008-01-18 05:00:00 | ES | Futures | 1258.58 | 1262.54 | 1258.11 | 1262.54 | 10850.0 |
| 2008-01-18 05:30:00 | ES | Futures | 1262.54 | 1265.8 | 1260.91 | 1262.07 | 23252.0 |
| 2008-01-18 06:00:00 | ES | Futures | 1262.07 | 1263.01 | 1260.21 | 1261.84 | 11446.0 |
| 2008-01-18 06:30:00 | ES | Futures | 1261.84 | 1265.34 | 1261.61 | 1264.64 | 13822.0 |
| 2008-01-18 07:00:00 | ES | Futures | 1264.87 | 1265.57 | 1262.07 | 1262.54 | 18070.0 |
| 2008-01-18 07:30:00 | ES | Futures | 1262.31 | 1268.37 | 1260.68 | 1267.2 | 29487.0 |
| 2008-01-18 08:00:00 | ES | Futures | 1267.2 | 1268.84 | 1265.57 | 1266.5 | 36156.0 |
| 2008-01-18 08:30:00 | ES | Futures | 1266.5 | 1267.67 | 1262.77 | 1264.17 | 30304.0 |
| 2008-01-18 09:00:00 | ES | Futures | 1264.17 | 1264.41 | 1254.38 | 1256.01 | 83162.0 |
| 2008-01-18 09:30:00 | ES | Futures | 1256.01 | 1259.98 | 1250.42 | 1252.51 | 327675.0 |
| 2008-01-18 10:00:00 | ES | Futures | 1252.51 | 1263.94 | 1249.95 | 1259.28 | 309065.0 |
| 2008-01-18 10:30:00 | ES | Futures | 1259.04 | 1260.21 | 1249.72 | 1251.35 | 193608.0 |
| 2008-01-18 11:00:00 | ES | Futures | 1251.12 | 1252.28 | 1236.89 | 1242.26 | 284842.0 |
| 2008-01-18 11:30:00 | ES | Futures | 1242.02 | 1244.12 | 1227.1 | 1230.37 | 327297.0 |
| 2008-01-18 12:00:00 | ES | Futures | 1230.13 | 1240.16 | 1229.2 | 1239.92 | 199825.0 |
| 2008-01-18 12:30:00 | ES | Futures | 1240.16 | 1244.12 | 1237.13 | 1238.99 | 159259.0 |
| 2008-01-18 13:00:00 | ES | Futures | 1238.99 | 1243.89 | 1231.53 | 1234.8 | 122476.0 |
| 2008-01-18 13:30:00 | ES | Futures | 1235.03 | 1240.16 | 1232.46 | 1235.49 | 109018.0 |
| 2008-01-18 14:00:00 | ES | Futures | 1235.26 | 1241.09 | 1234.1 | 1235.96 | 119279.0 |
| 2008-01-18 14:30:00 | ES | Futures | 1235.96 | 1236.43 | 1229.67 | 1235.49 | 150945.0 |
| 2008-01-18 15:00:00 | ES | Futures | 1235.49 | 1240.86 | 1231.3 | 1232.93 | 183206.0 |
| 2008-01-18 15:30:00 | ES | Futures | 1232.7 | 1242.02 | 1232.23 | 1240.16 | 221464.0 |
| 2008-01-18 16:00:00 | ES | Futures | 1240.16 | 1241.32 | 1235.26 | 1235.96 | 114467.0 |
| 2008-01-18 00:00:00 | NQ | Futures | 2123.72 | 2125.42 | 2123.15 | 2125.14 | 144.0 |
| 2008-01-18 00:30:00 | NQ | Futures | 2124.57 | 2125.42 | 2124.29 | 2125.42 | 124.0 |
| 2008-01-18 01:00:00 | NQ | Futures | 2125.14 | 2125.71 | 2123.72 | 2124.0 | 84.0 |
| 2008-01-18 01:30:00 | NQ | Futures | 2124.85 | 2126.27 | 2124.29 | 2125.42 | 104.0 |
| 2008-01-18 02:00:00 | NQ | Futures | 2125.42 | 2127.69 | 2123.72 | 2127.12 | 247.0 |
| 2008-01-18 02:30:00 | NQ | Futures | 2127.12 | 2127.69 | 2123.15 | 2126.56 | 740.0 |
| 2008-01-18 03:00:00 | NQ | Futures | 2127.69 | 2127.69 | 2117.47 | 2123.15 | 867.0 |
| 2008-01-18 03:30:00 | NQ | Futures | 2123.15 | 2124.29 | 2120.03 | 2121.73 | 445.0 |
| 2008-01-18 04:00:00 | NQ | Futures | 2122.02 | 2122.58 | 2115.2 | 2121.16 | 974.0 |
| 2008-01-18 04:30:00 | NQ | Futures | 2120.88 | 2124.57 | 2118.33 | 2124.29 | 932.0 |
| 2008-01-18 05:00:00 | NQ | Futures | 2124.0 | 2128.83 | 2123.15 | 2128.83 | 995.0 |
| 2008-01-18 05:30:00 | NQ | Futures | 2128.83 | 2133.37 | 2124.85 | 2127.12 | 1624.0 |
| 2008-01-18 06:00:00 | NQ | Futures | 2126.84 | 2128.26 | 2124.0 | 2125.99 | 450.0 |
| 2008-01-18 06:30:00 | NQ | Futures | 2126.27 | 2132.8 | 2125.99 | 2132.52 | 1033.0 |
| 2008-01-18 07:00:00 | NQ | Futures | 2132.52 | 2133.37 | 2126.56 | 2127.12 | 1593.0 |
| 2008-01-18 07:30:00 | NQ | Futures | 2127.12 | 2136.21 | 2124.29 | 2135.64 | 3100.0 |
| 2008-01-18 08:00:00 | NQ | Futures | 2135.64 | 2139.05 | 2131.67 | 2132.8 | 4509.0 |
> showing 50 of 1,126 rows — these rows as CSV