PREVIEW / futures_30min / 2008-06-23
file: by_date/futures_30min/2008/2008-06-23.parquet size: 63 KB rows: 2,137
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-23 00:00:00 | ES | Futures | 1230.17 | 1231.34 | 1229.94 | 1230.17 | 1314.0 |
| 2008-06-23 00:30:00 | ES | Futures | 1230.17 | 1232.5 | 1230.17 | 1232.03 | 2551.0 |
| 2008-06-23 01:00:00 | ES | Futures | 1232.27 | 1232.73 | 1231.57 | 1232.03 | 847.0 |
| 2008-06-23 01:30:00 | ES | Futures | 1232.27 | 1232.5 | 1231.1 | 1231.57 | 1172.0 |
| 2008-06-23 02:00:00 | ES | Futures | 1231.34 | 1231.57 | 1230.41 | 1230.64 | 2578.0 |
| 2008-06-23 02:30:00 | ES | Futures | 1230.64 | 1231.34 | 1230.41 | 1230.87 | 2298.0 |
| 2008-06-23 03:00:00 | ES | Futures | 1230.64 | 1232.73 | 1230.64 | 1231.8 | 8698.0 |
| 2008-06-23 03:30:00 | ES | Futures | 1231.8 | 1233.66 | 1230.64 | 1231.34 | 6841.0 |
| 2008-06-23 04:00:00 | ES | Futures | 1231.34 | 1232.27 | 1230.41 | 1230.87 | 4906.0 |
| 2008-06-23 04:30:00 | ES | Futures | 1230.87 | 1231.57 | 1229.24 | 1229.48 | 4174.0 |
| 2008-06-23 05:00:00 | ES | Futures | 1229.71 | 1230.64 | 1226.92 | 1229.48 | 8930.0 |
| 2008-06-23 05:30:00 | ES | Futures | 1229.48 | 1230.41 | 1228.55 | 1230.17 | 2593.0 |
| 2008-06-23 06:00:00 | ES | Futures | 1230.17 | 1232.03 | 1229.94 | 1231.34 | 4417.0 |
| 2008-06-23 06:30:00 | ES | Futures | 1231.57 | 1232.73 | 1230.87 | 1230.87 | 5833.0 |
| 2008-06-23 07:00:00 | ES | Futures | 1230.87 | 1231.1 | 1229.01 | 1229.48 | 5684.0 |
| 2008-06-23 07:30:00 | ES | Futures | 1229.24 | 1230.64 | 1227.39 | 1227.85 | 8528.0 |
| 2008-06-23 08:00:00 | ES | Futures | 1228.08 | 1231.1 | 1228.08 | 1230.17 | 12370.0 |
| 2008-06-23 08:30:00 | ES | Futures | 1230.17 | 1233.89 | 1229.01 | 1233.43 | 31934.0 |
| 2008-06-23 09:00:00 | ES | Futures | 1233.66 | 1234.36 | 1230.17 | 1230.64 | 22400.0 |
| 2008-06-23 09:30:00 | ES | Futures | 1230.41 | 1232.27 | 1226.69 | 1227.85 | 204014.0 |
| 2008-06-23 10:00:00 | ES | Futures | 1228.08 | 1229.71 | 1224.83 | 1227.62 | 147651.0 |
| 2008-06-23 10:30:00 | ES | Futures | 1227.62 | 1230.87 | 1225.06 | 1227.62 | 118558.0 |
| 2008-06-23 11:00:00 | ES | Futures | 1227.39 | 1228.32 | 1223.67 | 1225.99 | 118314.0 |
| 2008-06-23 11:30:00 | ES | Futures | 1225.99 | 1228.08 | 1224.6 | 1227.15 | 76781.0 |
| 2008-06-23 12:00:00 | ES | Futures | 1227.15 | 1228.08 | 1224.13 | 1224.36 | 56907.0 |
| 2008-06-23 12:30:00 | ES | Futures | 1224.13 | 1228.08 | 1224.13 | 1227.62 | 58239.0 |
| 2008-06-23 13:00:00 | ES | Futures | 1227.62 | 1229.71 | 1225.99 | 1228.32 | 75843.0 |
| 2008-06-23 13:30:00 | ES | Futures | 1228.55 | 1230.87 | 1227.85 | 1229.48 | 60569.0 |
| 2008-06-23 14:00:00 | ES | Futures | 1229.48 | 1230.64 | 1227.15 | 1228.32 | 72409.0 |
| 2008-06-23 14:30:00 | ES | Futures | 1228.32 | 1229.48 | 1225.99 | 1227.15 | 51662.0 |
| 2008-06-23 15:00:00 | ES | Futures | 1227.15 | 1227.62 | 1224.6 | 1227.39 | 67154.0 |
| 2008-06-23 15:30:00 | ES | Futures | 1227.15 | 1227.62 | 1224.6 | 1227.15 | 113759.0 |
| 2008-06-23 16:00:00 | ES | Futures | 1227.15 | 1227.39 | 1224.83 | 1225.06 | 72497.0 |
| 2008-06-23 16:30:00 | ES | Futures | 1225.06 | 1225.76 | 1222.04 | 1224.36 | 12784.0 |
| 2008-06-23 17:00:00 | ES | Futures | 1224.36 | 1225.29 | 1223.9 | 1224.83 | 2567.0 |
| 2008-06-23 18:00:00 | ES | Futures | 1224.83 | 1224.83 | 1223.9 | 1224.13 | 583.0 |
| 2008-06-23 18:30:00 | ES | Futures | 1224.13 | 1224.36 | 1223.9 | 1223.9 | 235.0 |
| 2008-06-23 19:00:00 | ES | Futures | 1224.13 | 1224.36 | 1223.9 | 1224.13 | 198.0 |
| 2008-06-23 19:30:00 | ES | Futures | 1224.13 | 1224.83 | 1224.13 | 1224.13 | 374.0 |
| 2008-06-23 20:00:00 | ES | Futures | 1224.36 | 1224.36 | 1224.13 | 1224.36 | 903.0 |
| 2008-06-23 20:30:00 | ES | Futures | 1224.36 | 1224.36 | 1223.67 | 1223.67 | 443.0 |
| 2008-06-23 21:00:00 | ES | Futures | 1223.67 | 1225.53 | 1223.67 | 1225.29 | 1045.0 |
| 2008-06-23 21:30:00 | ES | Futures | 1225.53 | 1225.99 | 1225.29 | 1225.76 | 483.0 |
| 2008-06-23 22:00:00 | ES | Futures | 1225.76 | 1225.76 | 1225.29 | 1225.29 | 162.0 |
| 2008-06-23 22:30:00 | ES | Futures | 1225.53 | 1225.99 | 1225.29 | 1225.29 | 350.0 |
| 2008-06-23 23:00:00 | ES | Futures | 1225.53 | 1225.99 | 1225.29 | 1225.29 | 193.0 |
| 2008-06-23 23:30:00 | ES | Futures | 1225.53 | 1225.99 | 1224.83 | 1225.29 | 305.0 |
| 2008-06-23 00:00:00 | NQ | Futures | 2190.11 | 2192.08 | 2189.55 | 2190.96 | 126.0 |
| 2008-06-23 00:30:00 | NQ | Futures | 2190.96 | 2193.49 | 2189.83 | 2192.36 | 160.0 |
| 2008-06-23 01:00:00 | NQ | Futures | 2192.65 | 2194.62 | 2191.8 | 2194.33 | 156.0 |
> showing 50 of 2,137 rows — these rows as CSV