PREVIEW / futures_1hour / 2008-11-07
file: by_date/futures_1hour/2008/2008-11-07.parquet size: 37 KB rows: 1,032
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-11-07 00:00:00 | ES | Futures | 868.98 | 870.4 | 865.66 | 868.03 | 5740.0 |
| 2008-11-07 01:00:00 | ES | Futures | 868.27 | 869.21 | 864.24 | 866.14 | 4089.0 |
| 2008-11-07 02:00:00 | ES | Futures | 865.9 | 870.4 | 864.01 | 868.98 | 14311.0 |
| 2008-11-07 03:00:00 | ES | Futures | 868.98 | 876.79 | 868.74 | 873.47 | 35266.0 |
| 2008-11-07 04:00:00 | ES | Futures | 873.47 | 876.31 | 868.5 | 869.69 | 23136.0 |
| 2008-11-07 05:00:00 | ES | Futures | 869.69 | 874.89 | 869.69 | 874.42 | 14312.0 |
| 2008-11-07 06:00:00 | ES | Futures | 874.18 | 874.66 | 866.61 | 867.08 | 15170.0 |
| 2008-11-07 07:00:00 | ES | Futures | 867.08 | 868.27 | 863.06 | 864.24 | 28396.0 |
| 2008-11-07 08:00:00 | ES | Futures | 864.01 | 867.08 | 853.83 | 855.02 | 154192.0 |
| 2008-11-07 09:00:00 | ES | Futures | 855.02 | 867.56 | 852.89 | 860.69 | 332358.0 |
| 2008-11-07 10:00:00 | ES | Futures | 860.93 | 879.86 | 860.46 | 873.0 | 469578.0 |
| 2008-11-07 11:00:00 | ES | Futures | 873.0 | 874.18 | 862.35 | 873.0 | 376885.0 |
| 2008-11-07 12:00:00 | ES | Futures | 873.0 | 876.31 | 867.32 | 873.24 | 157952.0 |
| 2008-11-07 13:00:00 | ES | Futures | 873.24 | 875.6 | 868.98 | 874.42 | 134984.0 |
| 2008-11-07 14:00:00 | ES | Futures | 873.95 | 880.1 | 864.01 | 865.43 | 273004.0 |
| 2008-11-07 15:00:00 | ES | Futures | 865.43 | 881.28 | 859.27 | 879.39 | 458626.0 |
| 2008-11-07 16:00:00 | ES | Futures | 879.39 | 887.44 | 878.68 | 887.2 | 131713.0 |
| 2008-11-07 00:00:00 | NQ | Futures | 1425.57 | 1426.14 | 1419.63 | 1421.32 | 133.0 |
| 2008-11-07 01:00:00 | NQ | Futures | 1422.74 | 1422.74 | 1417.93 | 1421.61 | 146.0 |
| 2008-11-07 02:00:00 | NQ | Futures | 1421.89 | 1425.29 | 1417.08 | 1421.61 | 378.0 |
| 2008-11-07 03:00:00 | NQ | Futures | 1424.44 | 1434.62 | 1423.31 | 1429.25 | 2344.0 |
| 2008-11-07 04:00:00 | NQ | Futures | 1428.97 | 1434.62 | 1425.0 | 1428.68 | 1825.0 |
| 2008-11-07 05:00:00 | NQ | Futures | 1429.81 | 1439.72 | 1428.12 | 1438.59 | 1584.0 |
| 2008-11-07 06:00:00 | NQ | Futures | 1438.59 | 1439.43 | 1432.93 | 1432.93 | 1810.0 |
| 2008-11-07 07:00:00 | NQ | Futures | 1432.93 | 1434.34 | 1426.42 | 1427.55 | 2206.0 |
| 2008-11-07 08:00:00 | NQ | Futures | 1427.55 | 1431.79 | 1411.7 | 1413.12 | 16810.0 |
| 2008-11-07 09:00:00 | NQ | Futures | 1412.84 | 1429.53 | 1407.18 | 1417.93 | 45296.0 |
| 2008-11-07 10:00:00 | NQ | Futures | 1417.65 | 1448.77 | 1417.08 | 1437.45 | 56354.0 |
| 2008-11-07 11:00:00 | NQ | Futures | 1437.45 | 1439.15 | 1419.63 | 1436.89 | 41760.0 |
| 2008-11-07 12:00:00 | NQ | Futures | 1436.89 | 1442.26 | 1429.25 | 1438.02 | 22592.0 |
| 2008-11-07 13:00:00 | NQ | Futures | 1438.3 | 1441.98 | 1429.53 | 1437.74 | 21869.0 |
| 2008-11-07 14:00:00 | NQ | Futures | 1438.3 | 1446.79 | 1421.89 | 1423.02 | 35958.0 |
| 2008-11-07 15:00:00 | NQ | Futures | 1422.74 | 1440.0 | 1412.84 | 1437.74 | 65934.0 |
| 2008-11-07 16:00:00 | NQ | Futures | 1437.45 | 1460.09 | 1436.61 | 1460.09 | 18433.0 |
| 2008-11-07 00:00:00 | YM | Futures | 8015.6 | 8023.8 | 7982.8 | 8003.8 | 361.0 |
| 2008-11-07 01:00:00 | YM | Futures | 8008.3 | 8013.8 | 7971.0 | 7979.2 | 264.0 |
| 2008-11-07 02:00:00 | YM | Futures | 7991.9 | 8026.5 | 7974.7 | 8013.8 | 1008.0 |
| 2008-11-07 03:00:00 | YM | Futures | 8019.2 | 8070.2 | 8012.9 | 8042.9 | 2155.0 |
| 2008-11-07 04:00:00 | YM | Futures | 8042.0 | 8069.3 | 8005.6 | 8012.0 | 1258.0 |
| 2008-11-07 05:00:00 | YM | Futures | 8016.5 | 8057.4 | 8015.6 | 8052.0 | 749.0 |
| 2008-11-07 06:00:00 | YM | Futures | 8052.0 | 8053.8 | 8002.9 | 8005.6 | 1539.0 |
| 2008-11-07 07:00:00 | YM | Futures | 8004.7 | 8012.9 | 7967.4 | 7974.7 | 1782.0 |
| 2008-11-07 08:00:00 | YM | Futures | 7977.4 | 7993.8 | 7886.4 | 7891.9 | 9632.0 |
| 2008-11-07 09:00:00 | YM | Futures | 7891.9 | 8011.0 | 7875.5 | 7950.1 | 28226.0 |
| 2008-11-07 10:00:00 | YM | Futures | 7951.0 | 8105.6 | 7945.6 | 8052.0 | 39554.0 |
| 2008-11-07 11:00:00 | YM | Futures | 8052.0 | 8062.0 | 7956.5 | 8053.8 | 33484.0 |
| 2008-11-07 12:00:00 | YM | Futures | 8052.9 | 8076.5 | 8001.0 | 8057.4 | 14650.0 |
| 2008-11-07 13:00:00 | YM | Futures | 8058.3 | 8075.6 | 8012.9 | 8065.6 | 14130.0 |
| 2008-11-07 14:00:00 | YM | Futures | 8066.5 | 8125.6 | 7980.1 | 7991.9 | 27170.0 |
| 2008-11-07 15:00:00 | YM | Futures | 7992.9 | 8129.3 | 7934.6 | 8117.5 | 43105.0 |
> showing 50 of 1,032 rows — these rows as CSV