PREVIEW / futures_30min / 2008-03-19
file: by_date/futures_30min/2008/2008-03-19.parquet size: 72 KB rows: 2,311
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-19 00:00:00 | ES | Futures | 1241.76 | 1241.99 | 1241.06 | 1241.76 | 1504.0 |
| 2008-03-19 00:30:00 | ES | Futures | 1241.76 | 1242.22 | 1240.13 | 1241.06 | 2009.0 |
| 2008-03-19 01:00:00 | ES | Futures | 1241.06 | 1241.99 | 1239.89 | 1240.36 | 1797.0 |
| 2008-03-19 01:30:00 | ES | Futures | 1240.36 | 1240.59 | 1239.66 | 1239.66 | 1833.0 |
| 2008-03-19 02:00:00 | ES | Futures | 1239.66 | 1240.82 | 1239.19 | 1239.43 | 2133.0 |
| 2008-03-19 02:30:00 | ES | Futures | 1239.19 | 1242.45 | 1239.19 | 1241.99 | 1667.0 |
| 2008-03-19 03:00:00 | ES | Futures | 1242.22 | 1242.22 | 1238.96 | 1239.43 | 3595.0 |
| 2008-03-19 03:30:00 | ES | Futures | 1239.43 | 1240.13 | 1238.73 | 1239.89 | 3835.0 |
| 2008-03-19 04:00:00 | ES | Futures | 1239.89 | 1240.13 | 1238.03 | 1238.5 | 14600.0 |
| 2008-03-19 04:30:00 | ES | Futures | 1238.5 | 1238.96 | 1230.58 | 1231.74 | 29681.0 |
| 2008-03-19 05:00:00 | ES | Futures | 1231.51 | 1235.7 | 1230.81 | 1231.51 | 19795.0 |
| 2008-03-19 05:30:00 | ES | Futures | 1231.74 | 1235.7 | 1231.28 | 1233.14 | 16140.0 |
| 2008-03-19 06:00:00 | ES | Futures | 1233.14 | 1234.3 | 1231.51 | 1234.07 | 15836.0 |
| 2008-03-19 06:30:00 | ES | Futures | 1234.07 | 1236.4 | 1232.67 | 1234.3 | 12424.0 |
| 2008-03-19 07:00:00 | ES | Futures | 1234.3 | 1236.63 | 1229.88 | 1236.4 | 31798.0 |
| 2008-03-19 07:30:00 | ES | Futures | 1236.4 | 1239.43 | 1235.7 | 1236.17 | 39093.0 |
| 2008-03-19 08:00:00 | ES | Futures | 1235.93 | 1237.33 | 1234.3 | 1237.1 | 24740.0 |
| 2008-03-19 08:30:00 | ES | Futures | 1236.87 | 1242.22 | 1236.4 | 1241.76 | 44113.0 |
| 2008-03-19 09:00:00 | ES | Futures | 1241.29 | 1250.6 | 1241.29 | 1246.41 | 102492.0 |
| 2008-03-19 09:30:00 | ES | Futures | 1246.41 | 1251.53 | 1242.69 | 1242.92 | 280057.0 |
| 2008-03-19 10:00:00 | ES | Futures | 1242.92 | 1246.65 | 1241.06 | 1241.76 | 170955.0 |
| 2008-03-19 10:30:00 | ES | Futures | 1241.52 | 1241.99 | 1235.93 | 1240.36 | 195188.0 |
| 2008-03-19 11:00:00 | ES | Futures | 1240.36 | 1246.65 | 1239.19 | 1245.95 | 125931.0 |
| 2008-03-19 11:30:00 | ES | Futures | 1245.71 | 1247.34 | 1242.92 | 1243.15 | 111485.0 |
| 2008-03-19 12:00:00 | ES | Futures | 1243.15 | 1244.55 | 1236.87 | 1238.03 | 151048.0 |
| 2008-03-19 12:30:00 | ES | Futures | 1238.26 | 1238.96 | 1232.21 | 1234.07 | 139385.0 |
| 2008-03-19 13:00:00 | ES | Futures | 1234.07 | 1237.56 | 1230.35 | 1231.04 | 160038.0 |
| 2008-03-19 13:30:00 | ES | Futures | 1231.28 | 1231.98 | 1222.2 | 1225.92 | 185309.0 |
| 2008-03-19 14:00:00 | ES | Futures | 1225.92 | 1227.78 | 1220.8 | 1224.76 | 183516.0 |
| 2008-03-19 14:30:00 | ES | Futures | 1224.53 | 1226.85 | 1217.07 | 1226.39 | 198310.0 |
| 2008-03-19 15:00:00 | ES | Futures | 1226.15 | 1230.35 | 1217.77 | 1218.94 | 175020.0 |
| 2008-03-19 15:30:00 | ES | Futures | 1218.94 | 1221.27 | 1209.86 | 1210.79 | 292925.0 |
| 2008-03-19 16:00:00 | ES | Futures | 1210.79 | 1211.72 | 1207.76 | 1209.62 | 146722.0 |
| 2008-03-19 17:00:00 | ES | Futures | 1208.92 | 1210.09 | 1208.46 | 1208.46 | 2689.0 |
| 2008-03-19 18:00:00 | ES | Futures | 1208.23 | 1209.62 | 1207.76 | 1208.69 | 3379.0 |
| 2008-03-19 18:30:00 | ES | Futures | 1208.46 | 1209.62 | 1206.13 | 1206.13 | 3153.0 |
| 2008-03-19 19:00:00 | ES | Futures | 1206.13 | 1208.92 | 1204.73 | 1205.66 | 2544.0 |
| 2008-03-19 19:30:00 | ES | Futures | 1205.43 | 1205.66 | 1204.03 | 1204.97 | 1905.0 |
| 2008-03-19 20:00:00 | ES | Futures | 1204.97 | 1205.9 | 1204.27 | 1205.9 | 1252.0 |
| 2008-03-19 20:30:00 | ES | Futures | 1205.66 | 1206.13 | 1204.73 | 1204.97 | 1010.0 |
| 2008-03-19 21:00:00 | ES | Futures | 1204.73 | 1204.97 | 1202.64 | 1203.1 | 4448.0 |
| 2008-03-19 21:30:00 | ES | Futures | 1202.87 | 1204.73 | 1202.64 | 1204.27 | 1495.0 |
| 2008-03-19 22:00:00 | ES | Futures | 1204.27 | 1204.5 | 1202.4 | 1203.34 | 2179.0 |
| 2008-03-19 22:30:00 | ES | Futures | 1203.34 | 1203.57 | 1198.21 | 1201.24 | 4922.0 |
| 2008-03-19 23:00:00 | ES | Futures | 1201.47 | 1202.64 | 1200.77 | 1201.94 | 1802.0 |
| 2008-03-19 23:30:00 | ES | Futures | 1201.71 | 1202.64 | 1201.01 | 1202.4 | 982.0 |
| 2008-03-19 00:00:00 | NQ | Futures | 2003.56 | 2003.56 | 2001.3 | 2002.71 | 31.0 |
| 2008-03-19 00:30:00 | NQ | Futures | 2002.71 | 2002.71 | 2001.3 | 2001.58 | 39.0 |
| 2008-03-19 01:00:00 | NQ | Futures | 2001.86 | 2003.28 | 2000.16 | 2000.45 | 107.0 |
| 2008-03-19 01:30:00 | NQ | Futures | 2000.45 | 2001.58 | 1999.03 | 2000.16 | 45.0 |
> showing 50 of 2,311 rows — these rows as CSV