PREVIEW / futures_1hour / 2008-12-31
file: by_date/futures_1hour/2008/2008-12-31.parquet size: 31 KB rows: 826
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-12-31 00:00:00 | ES | Futures | 843.67 | 843.91 | 843.67 | 843.91 | 639.0 |
| 2008-12-31 01:00:00 | ES | Futures | 843.67 | 844.14 | 843.43 | 843.67 | 644.0 |
| 2008-12-31 02:00:00 | ES | Futures | 843.43 | 843.91 | 843.19 | 843.67 | 1150.0 |
| 2008-12-31 03:00:00 | ES | Futures | 843.67 | 843.91 | 841.53 | 841.77 | 4721.0 |
| 2008-12-31 04:00:00 | ES | Futures | 842.01 | 843.19 | 841.53 | 842.48 | 1293.0 |
| 2008-12-31 05:00:00 | ES | Futures | 842.48 | 848.41 | 842.25 | 846.28 | 4027.0 |
| 2008-12-31 06:00:00 | ES | Futures | 846.28 | 848.17 | 845.33 | 846.28 | 2441.0 |
| 2008-12-31 07:00:00 | ES | Futures | 846.28 | 846.75 | 843.67 | 844.14 | 5448.0 |
| 2008-12-31 08:00:00 | ES | Futures | 843.91 | 846.75 | 842.48 | 845.33 | 14655.0 |
| 2008-12-31 09:00:00 | ES | Futures | 845.57 | 846.99 | 841.06 | 846.04 | 66819.0 |
| 2008-12-31 10:00:00 | ES | Futures | 846.28 | 850.55 | 846.28 | 849.84 | 88347.0 |
| 2008-12-31 11:00:00 | ES | Futures | 849.84 | 853.39 | 848.89 | 851.73 | 72068.0 |
| 2008-12-31 12:00:00 | ES | Futures | 851.5 | 853.63 | 850.31 | 853.16 | 46495.0 |
| 2008-12-31 13:00:00 | ES | Futures | 853.16 | 854.58 | 849.12 | 853.39 | 59410.0 |
| 2008-12-31 14:00:00 | ES | Futures | 853.63 | 857.9 | 852.21 | 856.24 | 96591.0 |
| 2008-12-31 15:00:00 | ES | Futures | 856.48 | 861.46 | 852.44 | 854.1 | 315341.0 |
| 2008-12-31 16:00:00 | ES | Futures | 854.34 | 855.76 | 845.33 | 846.28 | 124752.0 |
| 2008-12-31 00:00:00 | NQ | Futures | 1363.05 | 1363.05 | 1361.64 | 1361.64 | 7.0 |
| 2008-12-31 01:00:00 | NQ | Futures | 1361.64 | 1361.64 | 1361.07 | 1361.36 | 8.0 |
| 2008-12-31 02:00:00 | NQ | Futures | 1361.07 | 1362.49 | 1360.79 | 1362.49 | 21.0 |
| 2008-12-31 03:00:00 | NQ | Futures | 1362.49 | 1363.05 | 1359.1 | 1359.1 | 63.0 |
| 2008-12-31 04:00:00 | NQ | Futures | 1359.95 | 1360.51 | 1356.84 | 1359.95 | 105.0 |
| 2008-12-31 05:00:00 | NQ | Futures | 1359.95 | 1366.16 | 1359.66 | 1363.9 | 176.0 |
| 2008-12-31 06:00:00 | NQ | Futures | 1364.18 | 1365.88 | 1362.77 | 1363.62 | 126.0 |
| 2008-12-31 07:00:00 | NQ | Futures | 1363.62 | 1364.18 | 1359.1 | 1360.23 | 414.0 |
| 2008-12-31 08:00:00 | NQ | Futures | 1360.51 | 1363.33 | 1356.84 | 1360.79 | 1974.0 |
| 2008-12-31 09:00:00 | NQ | Futures | 1360.79 | 1369.26 | 1354.02 | 1366.72 | 13689.0 |
| 2008-12-31 10:00:00 | NQ | Futures | 1366.72 | 1374.06 | 1366.72 | 1372.65 | 16191.0 |
| 2008-12-31 11:00:00 | NQ | Futures | 1372.93 | 1378.86 | 1370.68 | 1375.76 | 15143.0 |
| 2008-12-31 12:00:00 | NQ | Futures | 1376.04 | 1378.3 | 1372.65 | 1377.45 | 8336.0 |
| 2008-12-31 13:00:00 | NQ | Futures | 1377.45 | 1379.43 | 1373.5 | 1378.3 | 10315.0 |
| 2008-12-31 14:00:00 | NQ | Futures | 1378.3 | 1383.38 | 1373.78 | 1379.15 | 13999.0 |
| 2008-12-31 15:00:00 | NQ | Futures | 1379.43 | 1382.82 | 1365.59 | 1367.29 | 31387.0 |
| 2008-12-31 16:00:00 | NQ | Futures | 1367.29 | 1368.7 | 1351.76 | 1355.71 | 13326.0 |
| 2008-12-31 00:00:00 | YM | Futures | 7870.7 | 7874.3 | 7868.8 | 7871.6 | 37.0 |
| 2008-12-31 01:00:00 | YM | Futures | 7871.6 | 7873.4 | 7871.6 | 7871.6 | 15.0 |
| 2008-12-31 02:00:00 | YM | Futures | 7874.3 | 7874.3 | 7867.0 | 7868.8 | 50.0 |
| 2008-12-31 03:00:00 | YM | Futures | 7868.8 | 7870.7 | 7859.7 | 7861.6 | 133.0 |
| 2008-12-31 04:00:00 | YM | Futures | 7862.5 | 7869.8 | 7858.8 | 7866.1 | 42.0 |
| 2008-12-31 05:00:00 | YM | Futures | 7866.1 | 7905.3 | 7864.3 | 7894.4 | 253.0 |
| 2008-12-31 06:00:00 | YM | Futures | 7896.2 | 7905.3 | 7883.4 | 7890.7 | 157.0 |
| 2008-12-31 07:00:00 | YM | Futures | 7888.0 | 7896.2 | 7878.9 | 7878.9 | 376.0 |
| 2008-12-31 08:00:00 | YM | Futures | 7883.4 | 7904.4 | 7864.3 | 7892.5 | 568.0 |
| 2008-12-31 09:00:00 | YM | Futures | 7892.5 | 7905.3 | 7857.9 | 7895.3 | 8794.0 |
| 2008-12-31 10:00:00 | YM | Futures | 7896.2 | 7932.6 | 7896.2 | 7923.5 | 7965.0 |
| 2008-12-31 11:00:00 | YM | Futures | 7925.3 | 7960.0 | 7918.1 | 7945.4 | 5927.0 |
| 2008-12-31 12:00:00 | YM | Futures | 7944.5 | 7970.9 | 7939.0 | 7962.7 | 4303.0 |
| 2008-12-31 13:00:00 | YM | Futures | 7963.6 | 7967.3 | 7919.0 | 7950.0 | 5331.0 |
| 2008-12-31 14:00:00 | YM | Futures | 7950.9 | 7987.3 | 7940.8 | 7976.4 | 8665.0 |
| 2008-12-31 15:00:00 | YM | Futures | 7976.4 | 8016.5 | 7944.5 | 7952.7 | 17414.0 |
> showing 50 of 826 rows — these rows as CSV