PREVIEW / futures_30min / 2010-12-17
file: by_date/futures_30min/2010/2010-12-17.parquet size: 63 KB rows: 2,163
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-17 00:00:00 | ES | Futures | 1225.01 | 1225.01 | 1224.02 | 1224.52 | 1188.0 |
| 2010-12-17 00:30:00 | ES | Futures | 1224.27 | 1225.75 | 1224.27 | 1225.75 | 2063.0 |
| 2010-12-17 01:00:00 | ES | Futures | 1225.75 | 1226.0 | 1225.01 | 1225.26 | 1619.0 |
| 2010-12-17 01:30:00 | ES | Futures | 1225.26 | 1226.0 | 1225.01 | 1225.26 | 1170.0 |
| 2010-12-17 02:00:00 | ES | Futures | 1225.26 | 1225.75 | 1224.76 | 1225.51 | 3195.0 |
| 2010-12-17 02:30:00 | ES | Futures | 1225.51 | 1226.25 | 1225.51 | 1225.75 | 5445.0 |
| 2010-12-17 03:00:00 | ES | Futures | 1226.0 | 1226.5 | 1224.76 | 1224.76 | 12815.0 |
| 2010-12-17 03:30:00 | ES | Futures | 1224.76 | 1226.25 | 1224.52 | 1225.75 | 6147.0 |
| 2010-12-17 04:00:00 | ES | Futures | 1225.51 | 1226.74 | 1225.51 | 1226.0 | 7035.0 |
| 2010-12-17 04:30:00 | ES | Futures | 1226.25 | 1226.74 | 1226.25 | 1226.74 | 3028.0 |
| 2010-12-17 05:00:00 | ES | Futures | 1226.74 | 1227.24 | 1225.51 | 1225.75 | 9225.0 |
| 2010-12-17 05:30:00 | ES | Futures | 1225.51 | 1226.0 | 1224.02 | 1224.76 | 8417.0 |
| 2010-12-17 06:00:00 | ES | Futures | 1224.76 | 1225.26 | 1224.52 | 1225.01 | 6449.0 |
| 2010-12-17 06:30:00 | ES | Futures | 1225.01 | 1225.51 | 1224.02 | 1224.52 | 5327.0 |
| 2010-12-17 07:00:00 | ES | Futures | 1224.52 | 1225.26 | 1223.28 | 1223.53 | 9388.0 |
| 2010-12-17 07:30:00 | ES | Futures | 1223.77 | 1226.0 | 1222.78 | 1225.51 | 14512.0 |
| 2010-12-17 08:00:00 | ES | Futures | 1225.75 | 1225.75 | 1224.02 | 1224.52 | 14822.0 |
| 2010-12-17 08:30:00 | ES | Futures | 1224.52 | 1226.0 | 1224.02 | 1225.26 | 18815.0 |
| 2010-12-17 09:00:00 | ES | Futures | 1225.26 | 1226.5 | 1224.02 | 1224.52 | 47203.0 |
| 2010-12-17 09:30:00 | ES | Futures | 1224.76 | 1225.01 | 1222.78 | 1224.27 | 169343.0 |
| 2010-12-17 10:00:00 | ES | Futures | 1224.02 | 1225.01 | 1222.29 | 1224.52 | 115923.0 |
| 2010-12-17 10:30:00 | ES | Futures | 1224.52 | 1225.01 | 1221.79 | 1223.77 | 114047.0 |
| 2010-12-17 11:00:00 | ES | Futures | 1223.77 | 1224.52 | 1223.03 | 1224.02 | 67677.0 |
| 2010-12-17 11:30:00 | ES | Futures | 1224.02 | 1225.26 | 1224.02 | 1224.27 | 53598.0 |
| 2010-12-17 12:00:00 | ES | Futures | 1224.27 | 1225.01 | 1224.27 | 1224.52 | 27629.0 |
| 2010-12-17 12:30:00 | ES | Futures | 1224.52 | 1225.51 | 1224.52 | 1225.01 | 24582.0 |
| 2010-12-17 13:00:00 | ES | Futures | 1225.26 | 1227.24 | 1225.01 | 1226.74 | 58895.0 |
| 2010-12-17 13:30:00 | ES | Futures | 1226.74 | 1228.23 | 1226.25 | 1227.73 | 34288.0 |
| 2010-12-17 14:00:00 | ES | Futures | 1227.73 | 1228.23 | 1226.99 | 1227.73 | 27960.0 |
| 2010-12-17 14:30:00 | ES | Futures | 1227.73 | 1228.23 | 1227.24 | 1227.73 | 25691.0 |
| 2010-12-17 15:00:00 | ES | Futures | 1227.98 | 1228.23 | 1226.0 | 1226.5 | 93094.0 |
| 2010-12-17 15:30:00 | ES | Futures | 1226.5 | 1227.49 | 1224.76 | 1226.99 | 187385.0 |
| 2010-12-17 16:00:00 | ES | Futures | 1226.99 | 1227.49 | 1224.76 | 1225.75 | 104842.0 |
| 2010-12-17 00:00:00 | NQ | Futures | 2547.99 | 2547.99 | 2546.26 | 2546.84 | 192.0 |
| 2010-12-17 00:30:00 | NQ | Futures | 2547.13 | 2548.56 | 2546.55 | 2547.99 | 135.0 |
| 2010-12-17 01:00:00 | NQ | Futures | 2547.99 | 2548.27 | 2547.13 | 2547.7 | 168.0 |
| 2010-12-17 01:30:00 | NQ | Futures | 2547.99 | 2548.56 | 2546.26 | 2547.13 | 263.0 |
| 2010-12-17 02:00:00 | NQ | Futures | 2547.41 | 2547.99 | 2546.55 | 2547.7 | 448.0 |
| 2010-12-17 02:30:00 | NQ | Futures | 2547.99 | 2548.56 | 2547.13 | 2547.99 | 212.0 |
| 2010-12-17 03:00:00 | NQ | Futures | 2548.27 | 2548.56 | 2545.4 | 2545.4 | 1306.0 |
| 2010-12-17 03:30:00 | NQ | Futures | 2545.69 | 2547.13 | 2545.4 | 2546.26 | 648.0 |
| 2010-12-17 04:00:00 | NQ | Futures | 2546.26 | 2547.41 | 2545.98 | 2546.55 | 804.0 |
| 2010-12-17 04:30:00 | NQ | Futures | 2546.84 | 2547.41 | 2546.26 | 2547.41 | 391.0 |
| 2010-12-17 05:00:00 | NQ | Futures | 2547.41 | 2548.27 | 2545.12 | 2545.12 | 759.0 |
| 2010-12-17 05:30:00 | NQ | Futures | 2545.4 | 2545.69 | 2543.68 | 2544.54 | 794.0 |
| 2010-12-17 06:00:00 | NQ | Futures | 2544.54 | 2545.12 | 2543.68 | 2544.83 | 1415.0 |
| 2010-12-17 06:30:00 | NQ | Futures | 2544.83 | 2545.4 | 2543.68 | 2544.83 | 1189.0 |
| 2010-12-17 07:00:00 | NQ | Futures | 2544.83 | 2545.4 | 2543.39 | 2543.97 | 1690.0 |
| 2010-12-17 07:30:00 | NQ | Futures | 2543.68 | 2547.41 | 2543.39 | 2546.26 | 2263.0 |
| 2010-12-17 08:00:00 | NQ | Futures | 2545.98 | 2546.84 | 2544.54 | 2545.4 | 2280.0 |
> showing 50 of 2,163 rows — these rows as CSV