PREVIEW / futures_1hour / 2008-10-21
file: by_date/futures_1hour/2008/2008-10-21.parquet size: 45 KB rows: 1,257
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-21 00:00:00 | ES | Futures | 932.4 | 932.4 | 929.32 | 931.22 | 5934.0 |
| 2008-10-21 01:00:00 | ES | Futures | 931.22 | 937.37 | 931.22 | 935.48 | 5549.0 |
| 2008-10-21 02:00:00 | ES | Futures | 935.24 | 937.37 | 930.51 | 931.22 | 14056.0 |
| 2008-10-21 03:00:00 | ES | Futures | 931.22 | 933.11 | 924.35 | 928.61 | 32562.0 |
| 2008-10-21 04:00:00 | ES | Futures | 928.85 | 930.74 | 924.12 | 924.83 | 17617.0 |
| 2008-10-21 05:00:00 | ES | Futures | 925.06 | 930.51 | 924.59 | 930.51 | 11398.0 |
| 2008-10-21 06:00:00 | ES | Futures | 930.27 | 932.64 | 928.85 | 931.69 | 15027.0 |
| 2008-10-21 07:00:00 | ES | Futures | 931.69 | 931.93 | 922.46 | 924.35 | 35504.0 |
| 2008-10-21 08:00:00 | ES | Futures | 924.59 | 926.25 | 919.62 | 921.51 | 61711.0 |
| 2008-10-21 09:00:00 | ES | Futures | 921.51 | 927.67 | 912.52 | 922.22 | 322549.0 |
| 2008-10-21 10:00:00 | ES | Futures | 922.22 | 933.35 | 919.62 | 921.51 | 406317.0 |
| 2008-10-21 11:00:00 | ES | Futures | 921.75 | 925.3 | 906.37 | 907.79 | 279990.0 |
| 2008-10-21 12:00:00 | ES | Futures | 907.79 | 913.47 | 902.11 | 902.35 | 303862.0 |
| 2008-10-21 13:00:00 | ES | Futures | 902.35 | 916.78 | 901.87 | 911.81 | 213121.0 |
| 2008-10-21 14:00:00 | ES | Futures | 911.57 | 931.22 | 911.57 | 925.3 | 264279.0 |
| 2008-10-21 15:00:00 | ES | Futures | 925.3 | 931.22 | 900.22 | 902.82 | 493329.0 |
| 2008-10-21 16:00:00 | ES | Futures | 902.82 | 910.63 | 898.32 | 901.4 | 133829.0 |
| 2008-10-21 17:00:00 | ES | Futures | 901.4 | 913.47 | 899.98 | 912.28 | 17667.0 |
| 2008-10-21 18:00:00 | ES | Futures | 915.83 | 917.02 | 914.18 | 914.65 | 5750.0 |
| 2008-10-21 19:00:00 | ES | Futures | 914.41 | 917.49 | 912.76 | 913.23 | 3244.0 |
| 2008-10-21 20:00:00 | ES | Futures | 913.23 | 913.47 | 909.21 | 911.1 | 4341.0 |
| 2008-10-21 21:00:00 | ES | Futures | 910.86 | 913.7 | 910.39 | 913.47 | 3788.0 |
| 2008-10-21 22:00:00 | ES | Futures | 913.47 | 913.94 | 910.15 | 910.39 | 2933.0 |
| 2008-10-21 23:00:00 | ES | Futures | 910.63 | 910.86 | 905.66 | 906.37 | 4806.0 |
| 2008-10-21 00:00:00 | NQ | Futures | 1526.87 | 1526.87 | 1522.34 | 1524.61 | 127.0 |
| 2008-10-21 01:00:00 | NQ | Futures | 1525.46 | 1534.51 | 1525.46 | 1532.53 | 127.0 |
| 2008-10-21 02:00:00 | NQ | Futures | 1531.4 | 1534.79 | 1522.91 | 1523.47 | 404.0 |
| 2008-10-21 03:00:00 | NQ | Futures | 1525.46 | 1525.46 | 1511.31 | 1518.66 | 1361.0 |
| 2008-10-21 04:00:00 | NQ | Futures | 1517.82 | 1522.91 | 1511.31 | 1512.16 | 785.0 |
| 2008-10-21 05:00:00 | NQ | Futures | 1512.44 | 1517.82 | 1511.31 | 1517.82 | 792.0 |
| 2008-10-21 06:00:00 | NQ | Futures | 1517.25 | 1520.93 | 1514.42 | 1518.66 | 1011.0 |
| 2008-10-21 07:00:00 | NQ | Futures | 1518.95 | 1519.23 | 1505.08 | 1509.33 | 3019.0 |
| 2008-10-21 08:00:00 | NQ | Futures | 1509.33 | 1514.7 | 1502.54 | 1506.21 | 6526.0 |
| 2008-10-21 09:00:00 | NQ | Futures | 1506.21 | 1513.85 | 1495.46 | 1511.02 | 42657.0 |
| 2008-10-21 10:00:00 | NQ | Futures | 1510.74 | 1532.53 | 1506.5 | 1507.35 | 59839.0 |
| 2008-10-21 11:00:00 | NQ | Futures | 1507.35 | 1513.57 | 1477.63 | 1479.33 | 50694.0 |
| 2008-10-21 12:00:00 | NQ | Futures | 1479.05 | 1486.41 | 1462.92 | 1463.2 | 52842.0 |
| 2008-10-21 13:00:00 | NQ | Futures | 1462.92 | 1487.26 | 1462.92 | 1475.94 | 39833.0 |
| 2008-10-21 14:00:00 | NQ | Futures | 1475.94 | 1503.95 | 1475.37 | 1492.35 | 48443.0 |
| 2008-10-21 15:00:00 | NQ | Futures | 1492.63 | 1503.1 | 1449.34 | 1450.75 | 96415.0 |
| 2008-10-21 16:00:00 | NQ | Futures | 1450.47 | 1470.28 | 1438.3 | 1441.13 | 26828.0 |
| 2008-10-21 17:00:00 | NQ | Futures | 1440.85 | 1483.86 | 1434.91 | 1482.45 | 9096.0 |
| 2008-10-21 18:00:00 | NQ | Futures | 1488.95 | 1496.59 | 1488.67 | 1492.07 | 1734.0 |
| 2008-10-21 19:00:00 | NQ | Futures | 1492.07 | 1498.57 | 1491.22 | 1492.35 | 1010.0 |
| 2008-10-21 20:00:00 | NQ | Futures | 1492.07 | 1493.48 | 1484.14 | 1486.41 | 827.0 |
| 2008-10-21 21:00:00 | NQ | Futures | 1486.12 | 1491.78 | 1485.27 | 1491.78 | 201.0 |
| 2008-10-21 22:00:00 | NQ | Futures | 1491.78 | 1496.03 | 1486.97 | 1487.82 | 427.0 |
| 2008-10-21 23:00:00 | NQ | Futures | 1487.26 | 1489.24 | 1484.99 | 1487.26 | 562.0 |
| 2008-10-21 00:00:00 | YM | Futures | 8421.2 | 8424.9 | 8400.3 | 8412.1 | 203.0 |
| 2008-10-21 01:00:00 | YM | Futures | 8417.6 | 8463.1 | 8413.0 | 8446.7 | 314.0 |
> showing 50 of 1,257 rows — these rows as CSV