PREVIEW / futures_1hour / 2008-05-05
file: by_date/futures_1hour/2008/2008-05-05.parquet size: 39 KB rows: 1,156
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-05 00:00:00 | ES | Futures | 1310.44 | 1312.54 | 1310.21 | 1312.54 | 707.0 |
| 2008-05-05 01:00:00 | ES | Futures | 1312.31 | 1313.47 | 1311.84 | 1313.24 | 1527.0 |
| 2008-05-05 02:00:00 | ES | Futures | 1313.24 | 1314.87 | 1312.77 | 1313.01 | 4216.0 |
| 2008-05-05 03:00:00 | ES | Futures | 1312.77 | 1315.33 | 1312.31 | 1314.4 | 6809.0 |
| 2008-05-05 04:00:00 | ES | Futures | 1314.4 | 1314.4 | 1313.01 | 1313.94 | 2114.0 |
| 2008-05-05 05:00:00 | ES | Futures | 1313.94 | 1313.94 | 1312.07 | 1313.01 | 2181.0 |
| 2008-05-05 06:00:00 | ES | Futures | 1313.01 | 1313.24 | 1311.14 | 1312.31 | 3824.0 |
| 2008-05-05 07:00:00 | ES | Futures | 1312.07 | 1314.4 | 1311.84 | 1313.24 | 8908.0 |
| 2008-05-05 08:00:00 | ES | Futures | 1313.01 | 1313.47 | 1310.91 | 1312.77 | 29953.0 |
| 2008-05-05 09:00:00 | ES | Futures | 1313.01 | 1316.96 | 1311.61 | 1315.33 | 178181.0 |
| 2008-05-05 10:00:00 | ES | Futures | 1315.57 | 1318.83 | 1308.81 | 1308.81 | 321924.0 |
| 2008-05-05 11:00:00 | ES | Futures | 1309.05 | 1313.01 | 1307.88 | 1312.07 | 163629.0 |
| 2008-05-05 12:00:00 | ES | Futures | 1312.07 | 1313.01 | 1309.28 | 1312.31 | 99918.0 |
| 2008-05-05 13:00:00 | ES | Futures | 1312.31 | 1312.77 | 1308.35 | 1309.05 | 101730.0 |
| 2008-05-05 14:00:00 | ES | Futures | 1309.28 | 1312.31 | 1308.12 | 1310.44 | 105803.0 |
| 2008-05-05 15:00:00 | ES | Futures | 1310.68 | 1312.77 | 1310.21 | 1310.68 | 137185.0 |
| 2008-05-05 16:00:00 | ES | Futures | 1310.91 | 1313.01 | 1310.68 | 1312.07 | 48519.0 |
| 2008-05-05 17:00:00 | ES | Futures | 1312.07 | 1312.54 | 1311.84 | 1312.31 | 725.0 |
| 2008-05-05 18:00:00 | ES | Futures | 1312.54 | 1313.24 | 1311.61 | 1312.31 | 1771.0 |
| 2008-05-05 19:00:00 | ES | Futures | 1312.54 | 1313.01 | 1312.07 | 1312.77 | 773.0 |
| 2008-05-05 20:00:00 | ES | Futures | 1312.77 | 1313.01 | 1312.07 | 1312.77 | 1141.0 |
| 2008-05-05 21:00:00 | ES | Futures | 1312.77 | 1313.94 | 1312.54 | 1312.77 | 2365.0 |
| 2008-05-05 22:00:00 | ES | Futures | 1313.01 | 1313.94 | 1313.01 | 1313.7 | 1979.0 |
| 2008-05-05 23:00:00 | ES | Futures | 1313.94 | 1314.87 | 1313.7 | 1314.64 | 1857.0 |
| 2008-05-05 00:00:00 | NQ | Futures | 2237.74 | 2241.13 | 2237.74 | 2241.13 | 159.0 |
| 2008-05-05 01:00:00 | NQ | Futures | 2241.13 | 2242.27 | 2240.57 | 2241.7 | 69.0 |
| 2008-05-05 02:00:00 | NQ | Futures | 2241.98 | 2244.53 | 2241.42 | 2242.55 | 282.0 |
| 2008-05-05 03:00:00 | NQ | Futures | 2243.11 | 2246.79 | 2241.7 | 2242.83 | 1077.0 |
| 2008-05-05 04:00:00 | NQ | Futures | 2243.11 | 2243.11 | 2239.72 | 2241.7 | 524.0 |
| 2008-05-05 05:00:00 | NQ | Futures | 2241.98 | 2242.27 | 2239.44 | 2240.85 | 487.0 |
| 2008-05-05 06:00:00 | NQ | Futures | 2240.85 | 2241.98 | 2238.87 | 2241.13 | 567.0 |
| 2008-05-05 07:00:00 | NQ | Futures | 2241.42 | 2245.09 | 2239.44 | 2244.25 | 1285.0 |
| 2008-05-05 08:00:00 | NQ | Futures | 2244.25 | 2245.09 | 2241.13 | 2243.68 | 2790.0 |
| 2008-05-05 09:00:00 | NQ | Futures | 2243.68 | 2253.01 | 2239.15 | 2249.05 | 32145.0 |
| 2008-05-05 10:00:00 | NQ | Futures | 2248.77 | 2260.08 | 2238.02 | 2239.15 | 49234.0 |
| 2008-05-05 11:00:00 | NQ | Futures | 2238.87 | 2245.94 | 2236.89 | 2243.4 | 27782.0 |
| 2008-05-05 12:00:00 | NQ | Futures | 2243.4 | 2245.66 | 2237.74 | 2243.96 | 15089.0 |
| 2008-05-05 13:00:00 | NQ | Futures | 2244.25 | 2244.81 | 2230.95 | 2233.21 | 25203.0 |
| 2008-05-05 14:00:00 | NQ | Futures | 2233.5 | 2241.13 | 2231.8 | 2236.89 | 18920.0 |
| 2008-05-05 15:00:00 | NQ | Futures | 2236.89 | 2241.98 | 2235.76 | 2241.13 | 24779.0 |
| 2008-05-05 16:00:00 | NQ | Futures | 2241.42 | 2243.11 | 2239.44 | 2241.7 | 5507.0 |
| 2008-05-05 17:00:00 | NQ | Futures | 2241.98 | 2241.98 | 2241.13 | 2241.13 | 42.0 |
| 2008-05-05 18:00:00 | NQ | Futures | 2240.85 | 2242.55 | 2240.57 | 2241.7 | 148.0 |
| 2008-05-05 19:00:00 | NQ | Futures | 2241.13 | 2241.98 | 2241.13 | 2241.42 | 19.0 |
| 2008-05-05 20:00:00 | NQ | Futures | 2241.13 | 2242.27 | 2239.15 | 2241.13 | 37.0 |
| 2008-05-05 21:00:00 | NQ | Futures | 2240.85 | 2243.4 | 2240.85 | 2241.42 | 128.0 |
| 2008-05-05 22:00:00 | NQ | Futures | 2241.98 | 2243.96 | 2241.98 | 2242.27 | 73.0 |
| 2008-05-05 23:00:00 | NQ | Futures | 2243.96 | 2245.09 | 2242.27 | 2244.81 | 72.0 |
| 2008-05-05 00:00:00 | YM | Futures | 11807.9 | 11826.1 | 11807.9 | 11826.1 | 110.0 |
| 2008-05-05 01:00:00 | YM | Futures | 11821.6 | 11831.6 | 11813.4 | 11830.6 | 231.0 |
> showing 50 of 1,156 rows — these rows as CSV