PREVIEW / futures_30min / 2008-01-28
file: by_date/futures_30min/2008/2008-01-28.parquet size: 49 KB rows: 1,502
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-28 00:00:00 | ES | Futures | 1234.33 | 1234.56 | 1230.6 | 1230.83 | 5176.0 |
| 2008-01-28 00:30:00 | ES | Futures | 1230.83 | 1232.46 | 1223.14 | 1226.87 | 5971.0 |
| 2008-01-28 01:00:00 | ES | Futures | 1226.87 | 1227.1 | 1221.97 | 1224.54 | 2647.0 |
| 2008-01-28 01:30:00 | ES | Futures | 1224.3 | 1230.13 | 1224.07 | 1227.1 | 4412.0 |
| 2008-01-28 02:00:00 | ES | Futures | 1227.1 | 1231.06 | 1225.24 | 1230.13 | 9629.0 |
| 2008-01-28 02:30:00 | ES | Futures | 1230.37 | 1231.06 | 1227.1 | 1230.37 | 7591.0 |
| 2008-01-28 03:00:00 | ES | Futures | 1230.37 | 1236.89 | 1230.37 | 1236.66 | 19573.0 |
| 2008-01-28 03:30:00 | ES | Futures | 1236.43 | 1238.53 | 1234.33 | 1238.53 | 14501.0 |
| 2008-01-28 04:00:00 | ES | Futures | 1238.53 | 1238.99 | 1236.19 | 1237.36 | 10936.0 |
| 2008-01-28 04:30:00 | ES | Futures | 1237.59 | 1237.83 | 1234.1 | 1236.89 | 7373.0 |
| 2008-01-28 05:00:00 | ES | Futures | 1236.89 | 1237.59 | 1232.7 | 1232.93 | 5859.0 |
| 2008-01-28 05:30:00 | ES | Futures | 1233.16 | 1236.66 | 1232.7 | 1235.26 | 6459.0 |
| 2008-01-28 06:00:00 | ES | Futures | 1235.26 | 1235.96 | 1233.63 | 1234.1 | 3941.0 |
| 2008-01-28 06:30:00 | ES | Futures | 1234.1 | 1236.43 | 1232.46 | 1236.19 | 7153.0 |
| 2008-01-28 07:00:00 | ES | Futures | 1236.19 | 1238.99 | 1234.8 | 1238.53 | 12755.0 |
| 2008-01-28 07:30:00 | ES | Futures | 1238.76 | 1239.46 | 1236.43 | 1237.36 | 9513.0 |
| 2008-01-28 08:00:00 | ES | Futures | 1237.13 | 1242.72 | 1236.66 | 1242.26 | 27635.0 |
| 2008-01-28 08:30:00 | ES | Futures | 1242.49 | 1243.19 | 1237.83 | 1240.39 | 24824.0 |
| 2008-01-28 09:00:00 | ES | Futures | 1240.39 | 1245.52 | 1239.46 | 1245.29 | 29561.0 |
| 2008-01-28 09:30:00 | ES | Futures | 1245.05 | 1245.75 | 1235.96 | 1241.32 | 222953.0 |
| 2008-01-28 10:00:00 | ES | Futures | 1241.32 | 1247.39 | 1233.63 | 1246.22 | 239300.0 |
| 2008-01-28 10:30:00 | ES | Futures | 1246.22 | 1252.98 | 1243.66 | 1250.42 | 180299.0 |
| 2008-01-28 11:00:00 | ES | Futures | 1250.42 | 1253.45 | 1246.92 | 1250.88 | 120155.0 |
| 2008-01-28 11:30:00 | ES | Futures | 1250.88 | 1255.78 | 1250.42 | 1250.88 | 80855.0 |
| 2008-01-28 12:00:00 | ES | Futures | 1251.12 | 1252.28 | 1246.92 | 1248.55 | 61638.0 |
| 2008-01-28 12:30:00 | ES | Futures | 1248.55 | 1254.15 | 1246.92 | 1252.51 | 66308.0 |
| 2008-01-28 13:00:00 | ES | Futures | 1252.28 | 1258.11 | 1251.58 | 1255.08 | 108186.0 |
| 2008-01-28 13:30:00 | ES | Futures | 1255.08 | 1256.94 | 1252.05 | 1254.15 | 64033.0 |
| 2008-01-28 14:00:00 | ES | Futures | 1254.15 | 1259.74 | 1254.15 | 1256.94 | 75425.0 |
| 2008-01-28 14:30:00 | ES | Futures | 1256.71 | 1260.44 | 1253.91 | 1254.61 | 101501.0 |
| 2008-01-28 15:00:00 | ES | Futures | 1254.61 | 1256.71 | 1249.25 | 1253.21 | 125321.0 |
| 2008-01-28 15:30:00 | ES | Futures | 1253.21 | 1264.87 | 1252.75 | 1264.87 | 219060.0 |
| 2008-01-28 16:00:00 | ES | Futures | 1264.87 | 1266.74 | 1262.77 | 1263.24 | 90014.0 |
| 2008-01-28 16:30:00 | ES | Futures | 1262.54 | 1263.01 | 1260.91 | 1261.61 | 9537.0 |
| 2008-01-28 17:00:00 | ES | Futures | 1261.84 | 1266.5 | 1261.84 | 1265.11 | 10037.0 |
| 2008-01-28 18:00:00 | ES | Futures | 1264.41 | 1265.34 | 1263.71 | 1263.94 | 2563.0 |
| 2008-01-28 18:30:00 | ES | Futures | 1263.94 | 1265.57 | 1263.71 | 1265.11 | 1182.0 |
| 2008-01-28 19:00:00 | ES | Futures | 1265.11 | 1265.8 | 1264.41 | 1265.11 | 1868.0 |
| 2008-01-28 19:30:00 | ES | Futures | 1264.87 | 1265.11 | 1263.71 | 1264.17 | 1484.0 |
| 2008-01-28 20:00:00 | ES | Futures | 1264.17 | 1265.11 | 1263.24 | 1263.24 | 1348.0 |
| 2008-01-28 20:30:00 | ES | Futures | 1263.47 | 1264.64 | 1261.84 | 1262.54 | 1772.0 |
| 2008-01-28 21:00:00 | ES | Futures | 1262.54 | 1263.24 | 1261.84 | 1262.07 | 1253.0 |
| 2008-01-28 21:30:00 | ES | Futures | 1262.07 | 1262.31 | 1261.14 | 1261.61 | 1169.0 |
| 2008-01-28 22:00:00 | ES | Futures | 1261.61 | 1262.07 | 1260.91 | 1261.37 | 1441.0 |
| 2008-01-28 22:30:00 | ES | Futures | 1261.37 | 1262.31 | 1260.68 | 1261.14 | 1905.0 |
| 2008-01-28 23:00:00 | ES | Futures | 1261.14 | 1264.87 | 1260.91 | 1263.24 | 2123.0 |
| 2008-01-28 23:30:00 | ES | Futures | 1263.24 | 1263.94 | 1261.84 | 1263.24 | 579.0 |
| 2008-01-28 00:00:00 | NQ | Futures | 2017.56 | 2017.56 | 2008.48 | 2010.75 | 490.0 |
| 2008-01-28 00:30:00 | NQ | Futures | 2009.61 | 2013.3 | 2000.81 | 2005.07 | 444.0 |
| 2008-01-28 01:00:00 | NQ | Futures | 2003.94 | 2004.22 | 1999.96 | 2002.23 | 405.0 |
> showing 50 of 1,502 rows — these rows as CSV