PREVIEW / futures_1hour / 2008-10-09
file: by_date/futures_1hour/2008/2008-10-09.parquet size: 47 KB rows: 1,316
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-10-09 00:00:00 | ES | Futures | 937.61 | 939.03 | 934.29 | 935.24 | 7144.0 |
| 2008-10-09 01:00:00 | ES | Futures | 935.24 | 939.97 | 933.35 | 939.26 | 7316.0 |
| 2008-10-09 02:00:00 | ES | Futures | 939.5 | 945.65 | 934.77 | 945.42 | 24297.0 |
| 2008-10-09 03:00:00 | ES | Futures | 945.42 | 954.41 | 939.03 | 952.99 | 41390.0 |
| 2008-10-09 04:00:00 | ES | Futures | 952.75 | 955.59 | 949.91 | 954.88 | 27054.0 |
| 2008-10-09 05:00:00 | ES | Futures | 954.88 | 955.59 | 943.05 | 947.07 | 26531.0 |
| 2008-10-09 06:00:00 | ES | Futures | 947.07 | 950.15 | 941.39 | 945.89 | 34533.0 |
| 2008-10-09 07:00:00 | ES | Futures | 945.89 | 950.86 | 939.03 | 939.5 | 45501.0 |
| 2008-10-09 08:00:00 | ES | Futures | 939.5 | 948.97 | 935.0 | 946.84 | 88280.0 |
| 2008-10-09 09:00:00 | ES | Futures | 946.6 | 956.06 | 940.21 | 941.87 | 365613.0 |
| 2008-10-09 10:00:00 | ES | Futures | 941.63 | 946.13 | 922.22 | 924.12 | 566255.0 |
| 2008-10-09 11:00:00 | ES | Futures | 923.88 | 938.55 | 912.05 | 926.01 | 576045.0 |
| 2008-10-09 12:00:00 | ES | Futures | 926.25 | 933.58 | 918.67 | 923.17 | 239040.0 |
| 2008-10-09 13:00:00 | ES | Futures | 923.17 | 935.0 | 921.04 | 924.83 | 304023.0 |
| 2008-10-09 14:00:00 | ES | Futures | 924.59 | 928.38 | 908.26 | 909.68 | 362621.0 |
| 2008-10-09 15:00:00 | ES | Futures | 909.68 | 910.15 | 863.3 | 871.58 | 1120581.0 |
| 2008-10-09 16:00:00 | ES | Futures | 871.34 | 876.08 | 856.91 | 861.88 | 269615.0 |
| 2008-10-09 17:00:00 | ES | Futures | 862.11 | 868.74 | 861.64 | 867.79 | 12104.0 |
| 2008-10-09 18:00:00 | ES | Futures | 866.37 | 868.03 | 859.04 | 864.24 | 15511.0 |
| 2008-10-09 19:00:00 | ES | Futures | 864.48 | 866.37 | 860.22 | 860.46 | 7459.0 |
| 2008-10-09 20:00:00 | ES | Futures | 860.69 | 862.82 | 833.95 | 840.11 | 37706.0 |
| 2008-10-09 21:00:00 | ES | Futures | 840.34 | 851.23 | 838.21 | 842.71 | 17972.0 |
| 2008-10-09 22:00:00 | ES | Futures | 842.95 | 843.42 | 826.38 | 833.95 | 33243.0 |
| 2008-10-09 23:00:00 | ES | Futures | 833.95 | 841.29 | 833.24 | 835.61 | 14580.0 |
| 2008-10-09 00:00:00 | NQ | Futures | 1509.89 | 1513.85 | 1507.91 | 1511.31 | 530.0 |
| 2008-10-09 01:00:00 | NQ | Futures | 1511.87 | 1514.99 | 1507.35 | 1513.57 | 454.0 |
| 2008-10-09 02:00:00 | NQ | Futures | 1513.29 | 1522.06 | 1507.35 | 1520.36 | 762.0 |
| 2008-10-09 03:00:00 | NQ | Futures | 1520.36 | 1543.28 | 1511.87 | 1539.89 | 2230.0 |
| 2008-10-09 04:00:00 | NQ | Futures | 1540.45 | 1550.64 | 1537.34 | 1545.55 | 1839.0 |
| 2008-10-09 05:00:00 | NQ | Futures | 1545.26 | 1546.68 | 1530.83 | 1533.66 | 1824.0 |
| 2008-10-09 06:00:00 | NQ | Futures | 1533.38 | 1539.32 | 1524.32 | 1533.1 | 1843.0 |
| 2008-10-09 07:00:00 | NQ | Futures | 1532.81 | 1537.06 | 1516.68 | 1518.38 | 3505.0 |
| 2008-10-09 08:00:00 | NQ | Futures | 1518.38 | 1536.21 | 1511.87 | 1529.13 | 10375.0 |
| 2008-10-09 09:00:00 | NQ | Futures | 1528.85 | 1554.03 | 1522.91 | 1531.96 | 63361.0 |
| 2008-10-09 10:00:00 | NQ | Futures | 1531.96 | 1544.13 | 1511.31 | 1517.53 | 82879.0 |
| 2008-10-09 11:00:00 | NQ | Futures | 1516.97 | 1544.98 | 1494.61 | 1530.83 | 94972.0 |
| 2008-10-09 12:00:00 | NQ | Futures | 1530.83 | 1540.17 | 1514.7 | 1522.34 | 37273.0 |
| 2008-10-09 13:00:00 | NQ | Futures | 1522.34 | 1542.15 | 1520.08 | 1527.72 | 45936.0 |
| 2008-10-09 14:00:00 | NQ | Futures | 1527.15 | 1532.53 | 1494.9 | 1496.88 | 47927.0 |
| 2008-10-09 15:00:00 | NQ | Futures | 1497.16 | 1499.14 | 1428.97 | 1456.41 | 165766.0 |
| 2008-10-09 16:00:00 | NQ | Futures | 1456.41 | 1461.22 | 1431.79 | 1437.17 | 28551.0 |
| 2008-10-09 17:00:00 | NQ | Futures | 1437.45 | 1448.77 | 1437.45 | 1448.49 | 718.0 |
| 2008-10-09 18:00:00 | NQ | Futures | 1447.36 | 1447.64 | 1431.79 | 1440.0 | 837.0 |
| 2008-10-09 19:00:00 | NQ | Futures | 1440.0 | 1443.96 | 1435.47 | 1436.04 | 183.0 |
| 2008-10-09 20:00:00 | NQ | Futures | 1438.02 | 1439.15 | 1403.5 | 1414.53 | 2959.0 |
| 2008-10-09 21:00:00 | NQ | Futures | 1414.53 | 1429.25 | 1410.01 | 1416.51 | 1231.0 |
| 2008-10-09 22:00:00 | NQ | Futures | 1416.8 | 1419.63 | 1392.75 | 1406.89 | 2415.0 |
| 2008-10-09 23:00:00 | NQ | Futures | 1406.89 | 1417.08 | 1399.82 | 1405.2 | 899.0 |
| 2008-10-09 00:00:00 | YM | Futures | 8435.8 | 8438.5 | 8404.0 | 8417.6 | 380.0 |
| 2008-10-09 01:00:00 | YM | Futures | 8411.2 | 8454.0 | 8397.6 | 8446.7 | 483.0 |
> showing 50 of 1,316 rows — these rows as CSV