PREVIEW / futures_1hour / 2008-10-16
file: by_date/futures_1hour/2008/2008-10-16.parquet size: 46 KB rows: 1,291
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-16 00:00:00 | ES | Futures | 850.05 | 850.28 | 843.66 | 843.66 | 7417.0 |
| 2008-10-16 01:00:00 | ES | Futures | 843.66 | 844.37 | 833.01 | 834.66 | 11099.0 |
| 2008-10-16 02:00:00 | ES | Futures | 834.43 | 847.21 | 833.95 | 844.84 | 24440.0 |
| 2008-10-16 03:00:00 | ES | Futures | 845.08 | 864.95 | 843.89 | 864.95 | 65761.0 |
| 2008-10-16 04:00:00 | ES | Futures | 864.95 | 870.4 | 859.51 | 868.74 | 47204.0 |
| 2008-10-16 05:00:00 | ES | Futures | 868.74 | 868.74 | 847.92 | 853.6 | 26444.0 |
| 2008-10-16 06:00:00 | ES | Futures | 853.36 | 869.21 | 850.05 | 868.98 | 34063.0 |
| 2008-10-16 07:00:00 | ES | Futures | 868.74 | 869.69 | 853.83 | 856.91 | 41700.0 |
| 2008-10-16 08:00:00 | ES | Futures | 856.91 | 881.76 | 856.91 | 875.84 | 131606.0 |
| 2008-10-16 09:00:00 | ES | Futures | 876.08 | 878.68 | 850.99 | 869.21 | 565287.0 |
| 2008-10-16 10:00:00 | ES | Futures | 869.21 | 869.92 | 831.11 | 832.06 | 812268.0 |
| 2008-10-16 11:00:00 | ES | Futures | 832.06 | 850.99 | 819.04 | 845.08 | 696630.0 |
| 2008-10-16 12:00:00 | ES | Futures | 845.31 | 872.76 | 838.21 | 849.34 | 605022.0 |
| 2008-10-16 13:00:00 | ES | Futures | 849.34 | 865.19 | 843.66 | 859.75 | 410460.0 |
| 2008-10-16 14:00:00 | ES | Futures | 859.75 | 868.98 | 845.08 | 863.3 | 457072.0 |
| 2008-10-16 15:00:00 | ES | Futures | 863.06 | 899.27 | 859.98 | 895.72 | 874422.0 |
| 2008-10-16 16:00:00 | ES | Futures | 895.96 | 896.9 | 889.8 | 890.28 | 158593.0 |
| 2008-10-16 17:00:00 | ES | Futures | 890.28 | 893.35 | 890.28 | 893.12 | 6515.0 |
| 2008-10-16 18:00:00 | ES | Futures | 893.12 | 896.19 | 893.12 | 894.77 | 9479.0 |
| 2008-10-16 19:00:00 | ES | Futures | 894.77 | 895.96 | 891.93 | 892.88 | 4563.0 |
| 2008-10-16 20:00:00 | ES | Futures | 892.64 | 898.09 | 892.64 | 895.96 | 10071.0 |
| 2008-10-16 21:00:00 | ES | Futures | 896.19 | 896.9 | 891.46 | 896.19 | 7240.0 |
| 2008-10-16 22:00:00 | ES | Futures | 896.19 | 898.8 | 895.25 | 895.96 | 7039.0 |
| 2008-10-16 23:00:00 | ES | Futures | 895.96 | 897.38 | 894.54 | 897.38 | 2567.0 |
| 2008-10-16 00:00:00 | NQ | Futures | 1386.52 | 1386.52 | 1377.18 | 1377.18 | 272.0 |
| 2008-10-16 01:00:00 | NQ | Futures | 1376.9 | 1378.03 | 1361.9 | 1362.19 | 618.0 |
| 2008-10-16 02:00:00 | NQ | Futures | 1362.75 | 1383.69 | 1362.75 | 1381.14 | 810.0 |
| 2008-10-16 03:00:00 | NQ | Futures | 1383.12 | 1406.89 | 1378.88 | 1404.63 | 3167.0 |
| 2008-10-16 04:00:00 | NQ | Futures | 1404.63 | 1417.36 | 1397.27 | 1415.95 | 3030.0 |
| 2008-10-16 05:00:00 | NQ | Futures | 1414.82 | 1415.67 | 1377.18 | 1392.75 | 1663.0 |
| 2008-10-16 06:00:00 | NQ | Futures | 1391.33 | 1411.99 | 1385.11 | 1411.14 | 2425.0 |
| 2008-10-16 07:00:00 | NQ | Futures | 1411.14 | 1413.4 | 1390.48 | 1393.59 | 2602.0 |
| 2008-10-16 08:00:00 | NQ | Futures | 1393.59 | 1434.34 | 1389.92 | 1425.29 | 14777.0 |
| 2008-10-16 09:00:00 | NQ | Futures | 1425.0 | 1444.81 | 1400.95 | 1432.93 | 85531.0 |
| 2008-10-16 10:00:00 | NQ | Futures | 1432.93 | 1434.06 | 1364.45 | 1371.81 | 133854.0 |
| 2008-10-16 11:00:00 | NQ | Futures | 1372.09 | 1412.55 | 1348.32 | 1402.37 | 119034.0 |
| 2008-10-16 12:00:00 | NQ | Futures | 1402.08 | 1449.06 | 1391.05 | 1410.29 | 99959.0 |
| 2008-10-16 13:00:00 | NQ | Futures | 1410.29 | 1440.0 | 1397.56 | 1435.76 | 81187.0 |
| 2008-10-16 14:00:00 | NQ | Futures | 1435.76 | 1447.36 | 1404.91 | 1438.59 | 62934.0 |
| 2008-10-16 15:00:00 | NQ | Futures | 1438.3 | 1492.91 | 1433.49 | 1488.1 | 138734.0 |
| 2008-10-16 16:00:00 | NQ | Futures | 1488.39 | 1506.21 | 1475.65 | 1491.5 | 31833.0 |
| 2008-10-16 17:00:00 | NQ | Futures | 1491.5 | 1496.88 | 1490.37 | 1496.88 | 677.0 |
| 2008-10-16 18:00:00 | NQ | Futures | 1496.88 | 1499.71 | 1494.61 | 1498.57 | 870.0 |
| 2008-10-16 19:00:00 | NQ | Futures | 1498.86 | 1501.12 | 1497.16 | 1500.27 | 196.0 |
| 2008-10-16 20:00:00 | NQ | Futures | 1498.86 | 1504.23 | 1496.59 | 1498.29 | 504.0 |
| 2008-10-16 21:00:00 | NQ | Futures | 1500.27 | 1500.27 | 1491.78 | 1496.88 | 225.0 |
| 2008-10-16 22:00:00 | NQ | Futures | 1496.88 | 1500.84 | 1496.31 | 1497.73 | 160.0 |
| 2008-10-16 23:00:00 | NQ | Futures | 1497.44 | 1499.42 | 1494.9 | 1498.86 | 192.0 |
| 2008-10-16 00:00:00 | YM | Futures | 7686.3 | 7690.0 | 7640.0 | 7648.1 | 283.0 |
| 2008-10-16 01:00:00 | YM | Futures | 7640.9 | 7644.5 | 7559.0 | 7569.9 | 650.0 |
> showing 50 of 1,291 rows — these rows as CSV