PREVIEW / futures_1hour / 2008-04-04
file: by_date/futures_1hour/2008/2008-04-04.parquet size: 35 KB rows: 980
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-04-04 00:00:00 | ES | Futures | 1278.78 | 1278.78 | 1278.31 | 1278.54 | 447.0 |
| 2008-04-04 01:00:00 | ES | Futures | 1278.54 | 1279.01 | 1278.31 | 1278.54 | 531.0 |
| 2008-04-04 02:00:00 | ES | Futures | 1278.54 | 1279.01 | 1277.85 | 1278.54 | 1992.0 |
| 2008-04-04 03:00:00 | ES | Futures | 1278.31 | 1281.11 | 1277.85 | 1279.24 | 8957.0 |
| 2008-04-04 04:00:00 | ES | Futures | 1279.01 | 1279.94 | 1278.54 | 1279.71 | 7331.0 |
| 2008-04-04 05:00:00 | ES | Futures | 1279.71 | 1280.41 | 1278.54 | 1278.78 | 4227.0 |
| 2008-04-04 06:00:00 | ES | Futures | 1278.78 | 1279.24 | 1277.85 | 1278.78 | 6646.0 |
| 2008-04-04 07:00:00 | ES | Futures | 1279.01 | 1286.93 | 1278.78 | 1285.06 | 34430.0 |
| 2008-04-04 08:00:00 | ES | Futures | 1285.3 | 1292.75 | 1274.35 | 1282.97 | 214812.0 |
| 2008-04-04 09:00:00 | ES | Futures | 1282.97 | 1283.67 | 1273.66 | 1276.91 | 249604.0 |
| 2008-04-04 10:00:00 | ES | Futures | 1276.91 | 1278.31 | 1270.63 | 1275.98 | 324398.0 |
| 2008-04-04 11:00:00 | ES | Futures | 1276.22 | 1280.64 | 1275.52 | 1277.38 | 209552.0 |
| 2008-04-04 12:00:00 | ES | Futures | 1277.38 | 1286.69 | 1276.91 | 1285.76 | 210781.0 |
| 2008-04-04 13:00:00 | ES | Futures | 1285.76 | 1288.09 | 1283.9 | 1285.06 | 150394.0 |
| 2008-04-04 14:00:00 | ES | Futures | 1285.3 | 1286.23 | 1280.64 | 1282.97 | 175739.0 |
| 2008-04-04 15:00:00 | ES | Futures | 1282.97 | 1284.6 | 1274.82 | 1278.78 | 256375.0 |
| 2008-04-04 16:00:00 | ES | Futures | 1278.78 | 1278.78 | 1276.91 | 1277.85 | 54731.0 |
| 2008-04-04 00:00:00 | NQ | Futures | 2114.71 | 2114.71 | 2112.45 | 2113.01 | 79.0 |
| 2008-04-04 01:00:00 | NQ | Futures | 2112.45 | 2113.58 | 2112.16 | 2113.3 | 32.0 |
| 2008-04-04 02:00:00 | NQ | Futures | 2112.16 | 2113.01 | 2111.88 | 2112.73 | 101.0 |
| 2008-04-04 03:00:00 | NQ | Futures | 2112.45 | 2116.69 | 2109.34 | 2113.01 | 775.0 |
| 2008-04-04 04:00:00 | NQ | Futures | 2113.3 | 2114.71 | 2113.01 | 2114.14 | 545.0 |
| 2008-04-04 05:00:00 | NQ | Futures | 2113.58 | 2114.71 | 2113.01 | 2113.86 | 465.0 |
| 2008-04-04 06:00:00 | NQ | Futures | 2113.58 | 2114.71 | 2113.3 | 2114.14 | 725.0 |
| 2008-04-04 07:00:00 | NQ | Futures | 2113.58 | 2124.04 | 2113.58 | 2123.19 | 2729.0 |
| 2008-04-04 08:00:00 | NQ | Futures | 2123.19 | 2126.59 | 2106.51 | 2119.52 | 25870.0 |
| 2008-04-04 09:00:00 | NQ | Futures | 2119.8 | 2120.65 | 2104.53 | 2113.3 | 41442.0 |
| 2008-04-04 10:00:00 | NQ | Futures | 2113.01 | 2115.56 | 2096.04 | 2106.79 | 51756.0 |
| 2008-04-04 11:00:00 | NQ | Futures | 2107.07 | 2116.97 | 2106.79 | 2112.45 | 30731.0 |
| 2008-04-04 12:00:00 | NQ | Futures | 2112.45 | 2135.64 | 2111.6 | 2131.96 | 44092.0 |
| 2008-04-04 13:00:00 | NQ | Futures | 2132.24 | 2139.6 | 2128.85 | 2132.53 | 28022.0 |
| 2008-04-04 14:00:00 | NQ | Futures | 2132.81 | 2135.07 | 2124.04 | 2126.59 | 32474.0 |
| 2008-04-04 15:00:00 | NQ | Futures | 2126.87 | 2129.42 | 2113.3 | 2117.54 | 51172.0 |
| 2008-04-04 16:00:00 | NQ | Futures | 2117.54 | 2118.1 | 2114.43 | 2114.99 | 9184.0 |
| 2008-04-04 00:00:00 | YM | Futures | 11479.9 | 11479.9 | 11476.3 | 11479.9 | 42.0 |
| 2008-04-04 01:00:00 | YM | Futures | 11479.9 | 11479.9 | 11475.4 | 11478.1 | 87.0 |
| 2008-04-04 02:00:00 | YM | Futures | 11476.3 | 11479.0 | 11472.6 | 11476.3 | 136.0 |
| 2008-04-04 03:00:00 | YM | Futures | 11474.5 | 11495.4 | 11469.9 | 11480.8 | 999.0 |
| 2008-04-04 04:00:00 | YM | Futures | 11482.6 | 11486.3 | 11476.3 | 11484.4 | 444.0 |
| 2008-04-04 05:00:00 | YM | Futures | 11485.4 | 11492.6 | 11477.2 | 11480.8 | 335.0 |
| 2008-04-04 06:00:00 | YM | Futures | 11480.8 | 11481.7 | 11472.6 | 11480.8 | 249.0 |
| 2008-04-04 07:00:00 | YM | Futures | 11481.7 | 11532.6 | 11481.7 | 11529.0 | 1563.0 |
| 2008-04-04 08:00:00 | YM | Futures | 11527.2 | 11598.0 | 11450.8 | 11507.2 | 15091.0 |
| 2008-04-04 09:00:00 | YM | Futures | 11506.3 | 11510.8 | 11419.9 | 11436.3 | 23842.0 |
| 2008-04-04 10:00:00 | YM | Futures | 11436.3 | 11443.6 | 11380.0 | 11428.1 | 32713.0 |
| 2008-04-04 11:00:00 | YM | Futures | 11429.0 | 11469.0 | 11425.4 | 11444.5 | 17873.0 |
| 2008-04-04 12:00:00 | YM | Futures | 11444.5 | 11520.8 | 11438.1 | 11511.7 | 19913.0 |
| 2008-04-04 13:00:00 | YM | Futures | 11511.7 | 11529.9 | 11497.2 | 11507.2 | 12504.0 |
| 2008-04-04 14:00:00 | YM | Futures | 11507.2 | 11517.2 | 11471.7 | 11492.6 | 15597.0 |
| 2008-04-04 15:00:00 | YM | Futures | 11491.7 | 11506.3 | 11423.6 | 11459.0 | 24233.0 |
> showing 50 of 980 rows — these rows as CSV