PREVIEW / futures_30min / 2008-03-24
file: by_date/futures_30min/2008/2008-03-24.parquet size: 55 KB rows: 1,758
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-03-24 00:00:00 | ES | Futures | 1241.06 | 1241.76 | 1240.82 | 1241.52 | 512.0 |
| 2008-03-24 00:30:00 | ES | Futures | 1241.52 | 1241.76 | 1240.59 | 1241.29 | 320.0 |
| 2008-03-24 01:00:00 | ES | Futures | 1241.52 | 1241.99 | 1241.29 | 1241.52 | 795.0 |
| 2008-03-24 01:30:00 | ES | Futures | 1241.76 | 1241.76 | 1240.59 | 1241.06 | 363.0 |
| 2008-03-24 02:00:00 | ES | Futures | 1241.06 | 1241.29 | 1240.13 | 1241.06 | 790.0 |
| 2008-03-24 02:30:00 | ES | Futures | 1241.06 | 1241.06 | 1238.03 | 1238.26 | 804.0 |
| 2008-03-24 03:00:00 | ES | Futures | 1238.26 | 1239.19 | 1237.33 | 1238.73 | 527.0 |
| 2008-03-24 03:30:00 | ES | Futures | 1239.19 | 1240.59 | 1238.73 | 1240.36 | 566.0 |
| 2008-03-24 04:00:00 | ES | Futures | 1240.36 | 1240.59 | 1237.8 | 1238.73 | 313.0 |
| 2008-03-24 04:30:00 | ES | Futures | 1238.96 | 1240.59 | 1237.56 | 1240.59 | 465.0 |
| 2008-03-24 05:00:00 | ES | Futures | 1240.59 | 1241.99 | 1240.59 | 1241.06 | 610.0 |
| 2008-03-24 05:30:00 | ES | Futures | 1241.06 | 1241.29 | 1239.66 | 1240.82 | 609.0 |
| 2008-03-24 06:00:00 | ES | Futures | 1240.59 | 1241.06 | 1240.36 | 1240.59 | 397.0 |
| 2008-03-24 06:30:00 | ES | Futures | 1240.59 | 1241.99 | 1238.26 | 1238.96 | 1369.0 |
| 2008-03-24 07:00:00 | ES | Futures | 1238.96 | 1243.39 | 1238.26 | 1243.39 | 3203.0 |
| 2008-03-24 07:30:00 | ES | Futures | 1243.15 | 1243.39 | 1241.06 | 1241.99 | 2990.0 |
| 2008-03-24 08:00:00 | ES | Futures | 1242.22 | 1243.39 | 1241.06 | 1243.15 | 5813.0 |
| 2008-03-24 08:30:00 | ES | Futures | 1243.39 | 1246.65 | 1242.69 | 1245.95 | 19197.0 |
| 2008-03-24 09:00:00 | ES | Futures | 1245.95 | 1246.41 | 1243.85 | 1244.32 | 10504.0 |
| 2008-03-24 09:30:00 | ES | Futures | 1244.32 | 1254.1 | 1243.85 | 1253.4 | 204797.0 |
| 2008-03-24 10:00:00 | ES | Futures | 1253.4 | 1261.55 | 1253.16 | 1257.59 | 189951.0 |
| 2008-03-24 10:30:00 | ES | Futures | 1257.82 | 1263.64 | 1257.12 | 1260.15 | 107003.0 |
| 2008-03-24 11:00:00 | ES | Futures | 1260.38 | 1262.01 | 1258.29 | 1261.55 | 64971.0 |
| 2008-03-24 11:30:00 | ES | Futures | 1261.55 | 1265.27 | 1260.85 | 1262.25 | 77729.0 |
| 2008-03-24 12:00:00 | ES | Futures | 1262.25 | 1264.34 | 1260.62 | 1264.11 | 52649.0 |
| 2008-03-24 12:30:00 | ES | Futures | 1264.11 | 1268.07 | 1263.18 | 1265.04 | 86916.0 |
| 2008-03-24 13:00:00 | ES | Futures | 1265.04 | 1266.44 | 1263.88 | 1265.51 | 39022.0 |
| 2008-03-24 13:30:00 | ES | Futures | 1265.74 | 1266.67 | 1263.88 | 1266.67 | 39765.0 |
| 2008-03-24 14:00:00 | ES | Futures | 1266.67 | 1266.67 | 1262.01 | 1264.57 | 67734.0 |
| 2008-03-24 14:30:00 | ES | Futures | 1264.57 | 1265.51 | 1259.68 | 1260.38 | 86051.0 |
| 2008-03-24 15:00:00 | ES | Futures | 1260.15 | 1263.41 | 1258.29 | 1258.75 | 90094.0 |
| 2008-03-24 15:30:00 | ES | Futures | 1258.52 | 1261.55 | 1256.19 | 1258.75 | 165855.0 |
| 2008-03-24 16:00:00 | ES | Futures | 1258.52 | 1260.62 | 1258.52 | 1258.75 | 75975.0 |
| 2008-03-24 16:30:00 | ES | Futures | 1258.75 | 1259.68 | 1257.82 | 1258.29 | 4967.0 |
| 2008-03-24 17:00:00 | ES | Futures | 1258.29 | 1259.22 | 1257.59 | 1258.75 | 1580.0 |
| 2008-03-24 18:00:00 | ES | Futures | 1258.75 | 1264.11 | 1258.75 | 1263.41 | 9201.0 |
| 2008-03-24 18:30:00 | ES | Futures | 1263.18 | 1264.11 | 1261.31 | 1262.94 | 1884.0 |
| 2008-03-24 19:00:00 | ES | Futures | 1262.94 | 1262.94 | 1261.31 | 1261.78 | 734.0 |
| 2008-03-24 19:30:00 | ES | Futures | 1261.78 | 1262.01 | 1260.85 | 1261.55 | 701.0 |
| 2008-03-24 20:00:00 | ES | Futures | 1261.55 | 1262.71 | 1260.85 | 1261.55 | 831.0 |
| 2008-03-24 20:30:00 | ES | Futures | 1261.78 | 1261.78 | 1259.92 | 1261.08 | 1236.0 |
| 2008-03-24 21:00:00 | ES | Futures | 1261.08 | 1261.08 | 1260.15 | 1260.85 | 1165.0 |
| 2008-03-24 21:30:00 | ES | Futures | 1260.62 | 1262.94 | 1260.15 | 1260.38 | 1520.0 |
| 2008-03-24 22:00:00 | ES | Futures | 1260.15 | 1261.55 | 1258.99 | 1258.99 | 1156.0 |
| 2008-03-24 22:30:00 | ES | Futures | 1258.99 | 1259.45 | 1258.29 | 1258.52 | 1067.0 |
| 2008-03-24 23:00:00 | ES | Futures | 1258.52 | 1258.75 | 1258.29 | 1258.52 | 1121.0 |
| 2008-03-24 23:30:00 | ES | Futures | 1258.52 | 1258.99 | 1258.05 | 1258.05 | 823.0 |
| 2008-03-24 00:00:00 | NQ | Futures | 1986.02 | 1986.59 | 1986.02 | 1986.31 | 31.0 |
| 2008-03-24 00:30:00 | NQ | Futures | 1986.02 | 1986.59 | 1984.61 | 1986.59 | 49.0 |
| 2008-03-24 01:00:00 | NQ | Futures | 1987.15 | 1987.72 | 1987.15 | 1987.15 | 7.0 |
> showing 50 of 1,758 rows — these rows as CSV