PREVIEW / futures_30min / 2008-04-01
file: by_date/futures_30min/2008/2008-04-01.parquet size: 71 KB rows: 2,318
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-04-01 00:00:00 | ES | Futures | 1233.61 | 1233.84 | 1232.44 | 1232.67 | 684.0 |
| 2008-04-01 00:30:00 | ES | Futures | 1232.44 | 1233.14 | 1232.21 | 1232.91 | 550.0 |
| 2008-04-01 01:00:00 | ES | Futures | 1232.91 | 1234.07 | 1230.11 | 1230.58 | 3672.0 |
| 2008-04-01 01:30:00 | ES | Futures | 1230.58 | 1231.28 | 1229.18 | 1230.35 | 2924.0 |
| 2008-04-01 02:00:00 | ES | Futures | 1230.11 | 1230.81 | 1228.72 | 1230.58 | 2711.0 |
| 2008-04-01 02:30:00 | ES | Futures | 1230.58 | 1230.81 | 1225.46 | 1226.39 | 7914.0 |
| 2008-04-01 03:00:00 | ES | Futures | 1226.15 | 1233.61 | 1225.69 | 1233.61 | 15061.0 |
| 2008-04-01 03:30:00 | ES | Futures | 1233.37 | 1237.56 | 1232.44 | 1237.56 | 11995.0 |
| 2008-04-01 04:00:00 | ES | Futures | 1237.56 | 1237.8 | 1235.93 | 1237.56 | 11497.0 |
| 2008-04-01 04:30:00 | ES | Futures | 1237.56 | 1239.19 | 1237.56 | 1238.5 | 14271.0 |
| 2008-04-01 05:00:00 | ES | Futures | 1238.26 | 1238.73 | 1237.56 | 1238.26 | 3894.0 |
| 2008-04-01 05:30:00 | ES | Futures | 1238.03 | 1243.39 | 1238.03 | 1241.52 | 17388.0 |
| 2008-04-01 06:00:00 | ES | Futures | 1241.29 | 1242.69 | 1239.43 | 1241.76 | 10051.0 |
| 2008-04-01 06:30:00 | ES | Futures | 1241.76 | 1242.45 | 1240.82 | 1241.76 | 7273.0 |
| 2008-04-01 07:00:00 | ES | Futures | 1241.76 | 1242.22 | 1240.13 | 1240.82 | 6621.0 |
| 2008-04-01 07:30:00 | ES | Futures | 1240.82 | 1243.15 | 1239.89 | 1242.22 | 13804.0 |
| 2008-04-01 08:00:00 | ES | Futures | 1241.99 | 1245.02 | 1241.52 | 1243.85 | 24589.0 |
| 2008-04-01 08:30:00 | ES | Futures | 1243.85 | 1247.58 | 1243.39 | 1245.95 | 35064.0 |
| 2008-04-01 09:00:00 | ES | Futures | 1245.95 | 1248.74 | 1245.95 | 1246.88 | 44194.0 |
| 2008-04-01 09:30:00 | ES | Futures | 1246.88 | 1252.7 | 1246.18 | 1251.3 | 200379.0 |
| 2008-04-01 10:00:00 | ES | Futures | 1251.3 | 1258.05 | 1251.3 | 1255.03 | 214432.0 |
| 2008-04-01 10:30:00 | ES | Futures | 1255.03 | 1261.31 | 1254.56 | 1260.62 | 207614.0 |
| 2008-04-01 11:00:00 | ES | Futures | 1260.85 | 1261.78 | 1258.75 | 1259.22 | 115645.0 |
| 2008-04-01 11:30:00 | ES | Futures | 1258.99 | 1262.71 | 1258.52 | 1262.25 | 91542.0 |
| 2008-04-01 12:00:00 | ES | Futures | 1262.25 | 1267.14 | 1261.31 | 1266.44 | 164984.0 |
| 2008-04-01 12:30:00 | ES | Futures | 1266.44 | 1266.67 | 1263.64 | 1264.11 | 84081.0 |
| 2008-04-01 13:00:00 | ES | Futures | 1264.11 | 1269.23 | 1263.41 | 1268.53 | 102841.0 |
| 2008-04-01 13:30:00 | ES | Futures | 1268.53 | 1268.77 | 1264.34 | 1265.74 | 74015.0 |
| 2008-04-01 14:00:00 | ES | Futures | 1265.74 | 1269.46 | 1263.88 | 1266.9 | 114960.0 |
| 2008-04-01 14:30:00 | ES | Futures | 1266.9 | 1274.35 | 1266.9 | 1270.16 | 185826.0 |
| 2008-04-01 15:00:00 | ES | Futures | 1270.4 | 1274.59 | 1270.16 | 1272.96 | 110576.0 |
| 2008-04-01 15:30:00 | ES | Futures | 1272.96 | 1278.31 | 1268.3 | 1278.08 | 299758.0 |
| 2008-04-01 16:00:00 | ES | Futures | 1277.85 | 1278.08 | 1275.98 | 1276.22 | 94597.0 |
| 2008-04-01 16:30:00 | ES | Futures | 1276.22 | 1276.68 | 1275.05 | 1276.45 | 8941.0 |
| 2008-04-01 17:00:00 | ES | Futures | 1276.45 | 1278.31 | 1275.98 | 1278.08 | 4097.0 |
| 2008-04-01 18:00:00 | ES | Futures | 1277.85 | 1278.08 | 1275.75 | 1275.98 | 2438.0 |
| 2008-04-01 18:30:00 | ES | Futures | 1275.98 | 1276.45 | 1275.28 | 1276.45 | 1276.0 |
| 2008-04-01 19:00:00 | ES | Futures | 1276.22 | 1276.68 | 1275.75 | 1275.98 | 788.0 |
| 2008-04-01 19:30:00 | ES | Futures | 1275.98 | 1275.98 | 1274.59 | 1274.82 | 1296.0 |
| 2008-04-01 20:00:00 | ES | Futures | 1274.82 | 1275.05 | 1273.66 | 1274.59 | 1527.0 |
| 2008-04-01 20:30:00 | ES | Futures | 1274.82 | 1276.45 | 1274.35 | 1275.98 | 1318.0 |
| 2008-04-01 21:00:00 | ES | Futures | 1276.22 | 1276.68 | 1275.75 | 1276.45 | 1038.0 |
| 2008-04-01 21:30:00 | ES | Futures | 1276.45 | 1276.68 | 1275.28 | 1275.75 | 926.0 |
| 2008-04-01 22:00:00 | ES | Futures | 1275.52 | 1276.22 | 1275.28 | 1276.22 | 832.0 |
| 2008-04-01 22:30:00 | ES | Futures | 1275.98 | 1276.22 | 1274.35 | 1274.82 | 680.0 |
| 2008-04-01 23:00:00 | ES | Futures | 1274.82 | 1275.28 | 1274.35 | 1274.59 | 472.0 |
| 2008-04-01 23:30:00 | ES | Futures | 1274.82 | 1275.75 | 1274.35 | 1275.28 | 502.0 |
| 2008-04-01 00:00:00 | NQ | Futures | 2021.38 | 2021.94 | 2019.96 | 2021.66 | 46.0 |
| 2008-04-01 00:30:00 | NQ | Futures | 2021.66 | 2021.94 | 2020.24 | 2020.53 | 65.0 |
| 2008-04-01 01:00:00 | NQ | Futures | 2021.94 | 2023.07 | 2016.57 | 2017.13 | 145.0 |
> showing 50 of 2,318 rows — these rows as CSV