PREVIEW / futures_30min / 2008-06-16
file: by_date/futures_30min/2008/2008-06-16.parquet size: 65 KB rows: 2,206
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-06-16 00:00:00 | ES | Futures | 1264.11 | 1264.34 | 1263.87 | 1264.11 | 475.0 |
| 2008-06-16 00:30:00 | ES | Futures | 1264.11 | 1265.5 | 1263.64 | 1265.5 | 690.0 |
| 2008-06-16 01:00:00 | ES | Futures | 1265.27 | 1265.73 | 1264.57 | 1265.27 | 767.0 |
| 2008-06-16 01:30:00 | ES | Futures | 1265.04 | 1266.2 | 1264.57 | 1265.73 | 848.0 |
| 2008-06-16 02:00:00 | ES | Futures | 1265.73 | 1266.2 | 1265.5 | 1265.73 | 1429.0 |
| 2008-06-16 02:30:00 | ES | Futures | 1265.73 | 1266.2 | 1265.04 | 1265.97 | 621.0 |
| 2008-06-16 03:00:00 | ES | Futures | 1265.97 | 1268.06 | 1265.27 | 1267.59 | 5500.0 |
| 2008-06-16 03:30:00 | ES | Futures | 1267.59 | 1268.06 | 1264.34 | 1264.8 | 4623.0 |
| 2008-06-16 04:00:00 | ES | Futures | 1264.8 | 1265.73 | 1264.34 | 1265.5 | 2586.0 |
| 2008-06-16 04:30:00 | ES | Futures | 1265.27 | 1266.43 | 1264.8 | 1266.43 | 3595.0 |
| 2008-06-16 05:00:00 | ES | Futures | 1265.97 | 1267.36 | 1265.04 | 1267.13 | 3479.0 |
| 2008-06-16 05:30:00 | ES | Futures | 1267.13 | 1267.83 | 1266.43 | 1267.83 | 3992.0 |
| 2008-06-16 06:00:00 | ES | Futures | 1267.83 | 1268.29 | 1267.13 | 1268.29 | 3609.0 |
| 2008-06-16 06:30:00 | ES | Futures | 1268.06 | 1268.29 | 1266.66 | 1266.66 | 4337.0 |
| 2008-06-16 07:00:00 | ES | Futures | 1266.66 | 1266.66 | 1263.87 | 1264.11 | 8464.0 |
| 2008-06-16 07:30:00 | ES | Futures | 1264.34 | 1264.34 | 1262.25 | 1262.48 | 10532.0 |
| 2008-06-16 08:00:00 | ES | Futures | 1262.71 | 1266.66 | 1261.55 | 1262.25 | 17446.0 |
| 2008-06-16 08:30:00 | ES | Futures | 1262.25 | 1262.25 | 1258.53 | 1259.92 | 46738.0 |
| 2008-06-16 09:00:00 | ES | Futures | 1259.92 | 1259.92 | 1256.44 | 1258.3 | 38075.0 |
| 2008-06-16 09:30:00 | ES | Futures | 1258.3 | 1262.02 | 1257.13 | 1260.62 | 162485.0 |
| 2008-06-16 10:00:00 | ES | Futures | 1260.85 | 1265.04 | 1258.99 | 1263.64 | 122871.0 |
| 2008-06-16 10:30:00 | ES | Futures | 1263.64 | 1267.59 | 1261.78 | 1267.13 | 96957.0 |
| 2008-06-16 11:00:00 | ES | Futures | 1267.36 | 1267.59 | 1262.71 | 1263.87 | 93550.0 |
| 2008-06-16 11:30:00 | ES | Futures | 1263.87 | 1265.5 | 1263.41 | 1264.57 | 41335.0 |
| 2008-06-16 12:00:00 | ES | Futures | 1264.57 | 1264.8 | 1261.78 | 1263.18 | 54017.0 |
| 2008-06-16 12:30:00 | ES | Futures | 1263.41 | 1266.9 | 1262.48 | 1265.04 | 45759.0 |
| 2008-06-16 13:00:00 | ES | Futures | 1265.27 | 1269.45 | 1262.02 | 1269.45 | 93712.0 |
| 2008-06-16 13:30:00 | ES | Futures | 1269.45 | 1271.31 | 1268.29 | 1269.22 | 125027.0 |
| 2008-06-16 14:00:00 | ES | Futures | 1269.45 | 1269.92 | 1266.66 | 1267.13 | 70723.0 |
| 2008-06-16 14:30:00 | ES | Futures | 1267.13 | 1270.61 | 1267.13 | 1269.92 | 50209.0 |
| 2008-06-16 15:00:00 | ES | Futures | 1269.92 | 1270.61 | 1267.59 | 1268.29 | 75040.0 |
| 2008-06-16 15:30:00 | ES | Futures | 1268.29 | 1268.76 | 1265.27 | 1266.43 | 123589.0 |
| 2008-06-16 16:00:00 | ES | Futures | 1266.43 | 1266.9 | 1264.11 | 1264.34 | 60291.0 |
| 2008-06-16 16:30:00 | ES | Futures | 1264.57 | 1264.8 | 1262.71 | 1263.64 | 6712.0 |
| 2008-06-16 17:00:00 | ES | Futures | 1263.64 | 1263.87 | 1263.18 | 1263.87 | 2217.0 |
| 2008-06-16 18:00:00 | ES | Futures | 1263.64 | 1264.57 | 1262.95 | 1264.57 | 1008.0 |
| 2008-06-16 18:30:00 | ES | Futures | 1264.34 | 1264.57 | 1264.11 | 1264.34 | 89.0 |
| 2008-06-16 19:00:00 | ES | Futures | 1264.34 | 1264.34 | 1263.87 | 1263.87 | 197.0 |
| 2008-06-16 19:30:00 | ES | Futures | 1263.64 | 1264.8 | 1263.41 | 1264.57 | 365.0 |
| 2008-06-16 20:00:00 | ES | Futures | 1264.8 | 1265.04 | 1264.57 | 1265.04 | 574.0 |
| 2008-06-16 20:30:00 | ES | Futures | 1264.8 | 1265.04 | 1264.57 | 1265.04 | 405.0 |
| 2008-06-16 21:00:00 | ES | Futures | 1265.04 | 1265.04 | 1263.64 | 1263.87 | 435.0 |
| 2008-06-16 21:30:00 | ES | Futures | 1263.87 | 1265.5 | 1263.87 | 1265.04 | 832.0 |
| 2008-06-16 22:00:00 | ES | Futures | 1265.04 | 1265.04 | 1264.34 | 1264.8 | 433.0 |
| 2008-06-16 22:30:00 | ES | Futures | 1264.57 | 1264.8 | 1264.11 | 1264.57 | 402.0 |
| 2008-06-16 23:00:00 | ES | Futures | 1264.34 | 1264.8 | 1264.11 | 1264.57 | 239.0 |
| 2008-06-16 23:30:00 | ES | Futures | 1264.57 | 1264.57 | 1262.95 | 1263.87 | 1273.0 |
| 2008-06-16 00:00:00 | NQ | Futures | 2215.43 | 2215.99 | 2214.31 | 2214.31 | 132.0 |
| 2008-06-16 00:30:00 | NQ | Futures | 2214.31 | 2217.68 | 2214.31 | 2217.4 | 133.0 |
| 2008-06-16 01:00:00 | NQ | Futures | 2217.4 | 2218.24 | 2217.12 | 2217.96 | 204.0 |
> showing 50 of 2,206 rows — these rows as CSV