PREVIEW / futures_1hour / 2008-05-30
file: by_date/futures_1hour/2008/2008-05-30.parquet size: 35 KB rows: 988
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-05-30 00:00:00 | ES | Futures | 1302.06 | 1302.76 | 1301.6 | 1302.29 | 1038.0 |
| 2008-05-30 01:00:00 | ES | Futures | 1302.29 | 1302.53 | 1301.36 | 1302.53 | 1445.0 |
| 2008-05-30 02:00:00 | ES | Futures | 1302.53 | 1302.53 | 1300.66 | 1301.13 | 4647.0 |
| 2008-05-30 03:00:00 | ES | Futures | 1300.9 | 1303.23 | 1300.43 | 1301.83 | 12895.0 |
| 2008-05-30 04:00:00 | ES | Futures | 1301.83 | 1303.23 | 1300.43 | 1302.99 | 5436.0 |
| 2008-05-30 05:00:00 | ES | Futures | 1302.99 | 1304.86 | 1302.53 | 1304.39 | 6847.0 |
| 2008-05-30 06:00:00 | ES | Futures | 1304.39 | 1305.32 | 1303.23 | 1304.39 | 7141.0 |
| 2008-05-30 07:00:00 | ES | Futures | 1304.62 | 1304.86 | 1303.23 | 1303.92 | 13752.0 |
| 2008-05-30 08:00:00 | ES | Futures | 1303.92 | 1307.65 | 1303.46 | 1306.02 | 47908.0 |
| 2008-05-30 09:00:00 | ES | Futures | 1306.02 | 1306.95 | 1302.76 | 1303.69 | 150443.0 |
| 2008-05-30 10:00:00 | ES | Futures | 1303.69 | 1308.12 | 1302.76 | 1304.62 | 202837.0 |
| 2008-05-30 11:00:00 | ES | Futures | 1304.39 | 1306.25 | 1302.06 | 1305.79 | 151433.0 |
| 2008-05-30 12:00:00 | ES | Futures | 1306.02 | 1306.95 | 1304.39 | 1305.79 | 71070.0 |
| 2008-05-30 13:00:00 | ES | Futures | 1306.02 | 1308.12 | 1304.39 | 1306.72 | 66026.0 |
| 2008-05-30 14:00:00 | ES | Futures | 1306.95 | 1307.65 | 1304.86 | 1306.95 | 68506.0 |
| 2008-05-30 15:00:00 | ES | Futures | 1307.18 | 1308.58 | 1302.06 | 1302.29 | 244051.0 |
| 2008-05-30 16:00:00 | ES | Futures | 1302.76 | 1304.86 | 1302.06 | 1304.62 | 99990.0 |
| 2008-05-30 00:00:00 | NQ | Futures | 2293.74 | 2294.87 | 2293.17 | 2293.74 | 105.0 |
| 2008-05-30 01:00:00 | NQ | Futures | 2293.74 | 2294.59 | 2293.46 | 2294.31 | 49.0 |
| 2008-05-30 02:00:00 | NQ | Futures | 2294.31 | 2294.31 | 2290.06 | 2290.91 | 400.0 |
| 2008-05-30 03:00:00 | NQ | Futures | 2290.35 | 2296.0 | 2289.78 | 2293.17 | 859.0 |
| 2008-05-30 04:00:00 | NQ | Futures | 2293.74 | 2295.72 | 2291.19 | 2295.72 | 497.0 |
| 2008-05-30 05:00:00 | NQ | Futures | 2295.44 | 2297.98 | 2294.02 | 2297.13 | 443.0 |
| 2008-05-30 06:00:00 | NQ | Futures | 2297.42 | 2297.98 | 2295.72 | 2296.85 | 683.0 |
| 2008-05-30 07:00:00 | NQ | Futures | 2296.85 | 2298.83 | 2294.87 | 2296.0 | 2103.0 |
| 2008-05-30 08:00:00 | NQ | Futures | 2296.57 | 2302.22 | 2295.72 | 2299.68 | 5453.0 |
| 2008-05-30 09:00:00 | NQ | Futures | 2299.4 | 2299.68 | 2289.21 | 2297.13 | 39245.0 |
| 2008-05-30 10:00:00 | NQ | Futures | 2297.42 | 2306.18 | 2294.87 | 2301.09 | 50195.0 |
| 2008-05-30 11:00:00 | NQ | Futures | 2301.38 | 2305.62 | 2297.42 | 2304.49 | 30474.0 |
| 2008-05-30 12:00:00 | NQ | Futures | 2304.77 | 2306.75 | 2301.38 | 2305.9 | 25421.0 |
| 2008-05-30 13:00:00 | NQ | Futures | 2306.18 | 2311.28 | 2302.51 | 2307.6 | 21746.0 |
| 2008-05-30 14:00:00 | NQ | Futures | 2307.6 | 2310.71 | 2303.07 | 2309.58 | 20702.0 |
| 2008-05-30 15:00:00 | NQ | Futures | 2309.86 | 2312.12 | 2298.83 | 2300.25 | 40038.0 |
| 2008-05-30 16:00:00 | NQ | Futures | 2299.96 | 2305.9 | 2298.83 | 2301.94 | 12494.0 |
| 2008-05-30 00:00:00 | YM | Futures | 11477.2 | 11484.4 | 11475.4 | 11479.0 | 102.0 |
| 2008-05-30 01:00:00 | YM | Futures | 11479.9 | 11484.4 | 11477.2 | 11483.5 | 72.0 |
| 2008-05-30 02:00:00 | YM | Futures | 11482.6 | 11482.6 | 11466.3 | 11473.5 | 169.0 |
| 2008-05-30 03:00:00 | YM | Futures | 11469.9 | 11486.3 | 11467.2 | 11478.1 | 775.0 |
| 2008-05-30 04:00:00 | YM | Futures | 11477.2 | 11486.3 | 11468.1 | 11485.4 | 356.0 |
| 2008-05-30 05:00:00 | YM | Futures | 11485.4 | 11499.0 | 11481.7 | 11494.4 | 513.0 |
| 2008-05-30 06:00:00 | YM | Futures | 11496.3 | 11504.4 | 11489.0 | 11499.9 | 370.0 |
| 2008-05-30 07:00:00 | YM | Futures | 11499.0 | 11501.7 | 11491.7 | 11497.2 | 361.0 |
| 2008-05-30 08:00:00 | YM | Futures | 11498.1 | 11520.8 | 11493.5 | 11512.6 | 2698.0 |
| 2008-05-30 09:00:00 | YM | Futures | 11511.7 | 11517.2 | 11478.1 | 11485.4 | 14250.0 |
| 2008-05-30 10:00:00 | YM | Futures | 11485.4 | 11528.1 | 11471.7 | 11497.2 | 19492.0 |
| 2008-05-30 11:00:00 | YM | Futures | 11497.2 | 11502.6 | 11473.5 | 11499.0 | 15945.0 |
| 2008-05-30 12:00:00 | YM | Futures | 11499.9 | 11509.9 | 11483.5 | 11499.0 | 8383.0 |
| 2008-05-30 13:00:00 | YM | Futures | 11499.0 | 11517.2 | 11482.6 | 11506.3 | 8288.0 |
| 2008-05-30 14:00:00 | YM | Futures | 11505.3 | 11505.3 | 11484.4 | 11498.1 | 8060.0 |
| 2008-05-30 15:00:00 | YM | Futures | 11499.9 | 11512.6 | 11459.0 | 11459.0 | 18069.0 |
> showing 50 of 988 rows — these rows as CSV