PREVIEW / futures_1hour / 2008-10-17
file: by_date/futures_1hour/2008/2008-10-17.parquet size: 38 KB rows: 1,027
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-17 00:00:00 | ES | Futures | 896.9 | 899.27 | 896.67 | 899.03 | 3633.0 |
| 2008-10-17 01:00:00 | ES | Futures | 899.03 | 904.0 | 898.56 | 900.45 | 5990.0 |
| 2008-10-17 02:00:00 | ES | Futures | 900.22 | 900.22 | 892.17 | 894.77 | 17095.0 |
| 2008-10-17 03:00:00 | ES | Futures | 894.77 | 895.01 | 876.79 | 877.02 | 42206.0 |
| 2008-10-17 04:00:00 | ES | Futures | 877.02 | 880.81 | 869.21 | 871.82 | 33490.0 |
| 2008-10-17 05:00:00 | ES | Futures | 871.82 | 876.55 | 859.51 | 862.35 | 43211.0 |
| 2008-10-17 06:00:00 | ES | Futures | 862.59 | 878.92 | 862.11 | 875.37 | 38352.0 |
| 2008-10-17 07:00:00 | ES | Futures | 875.13 | 884.83 | 873.47 | 884.36 | 50994.0 |
| 2008-10-17 08:00:00 | ES | Futures | 884.36 | 888.86 | 874.66 | 878.92 | 99741.0 |
| 2008-10-17 09:00:00 | ES | Futures | 878.68 | 892.41 | 867.56 | 891.7 | 463154.0 |
| 2008-10-17 10:00:00 | ES | Futures | 891.93 | 902.58 | 882.23 | 897.85 | 580157.0 |
| 2008-10-17 11:00:00 | ES | Futures | 898.09 | 906.37 | 889.33 | 895.25 | 429740.0 |
| 2008-10-17 12:00:00 | ES | Futures | 895.01 | 917.49 | 894.54 | 916.07 | 295002.0 |
| 2008-10-17 13:00:00 | ES | Futures | 916.07 | 935.0 | 913.94 | 925.77 | 460463.0 |
| 2008-10-17 14:00:00 | ES | Futures | 925.77 | 930.98 | 902.11 | 912.99 | 446537.0 |
| 2008-10-17 15:00:00 | ES | Futures | 912.76 | 920.57 | 889.8 | 890.99 | 623944.0 |
| 2008-10-17 16:00:00 | ES | Futures | 890.99 | 893.59 | 881.99 | 883.41 | 124684.0 |
| 2008-10-17 00:00:00 | NQ | Futures | 1499.42 | 1504.23 | 1499.42 | 1503.1 | 179.0 |
| 2008-10-17 01:00:00 | NQ | Futures | 1503.95 | 1508.19 | 1501.12 | 1501.12 | 277.0 |
| 2008-10-17 02:00:00 | NQ | Futures | 1500.84 | 1500.84 | 1489.52 | 1492.91 | 748.0 |
| 2008-10-17 03:00:00 | NQ | Futures | 1492.63 | 1492.63 | 1461.79 | 1461.79 | 2849.0 |
| 2008-10-17 04:00:00 | NQ | Futures | 1462.92 | 1479.9 | 1447.36 | 1465.75 | 2894.0 |
| 2008-10-17 05:00:00 | NQ | Futures | 1466.03 | 1473.67 | 1436.32 | 1441.13 | 3026.0 |
| 2008-10-17 06:00:00 | NQ | Futures | 1441.42 | 1470.28 | 1441.13 | 1463.77 | 2683.0 |
| 2008-10-17 07:00:00 | NQ | Futures | 1463.49 | 1480.46 | 1462.35 | 1479.33 | 3343.0 |
| 2008-10-17 08:00:00 | NQ | Futures | 1479.62 | 1486.97 | 1462.92 | 1470.28 | 10856.0 |
| 2008-10-17 09:00:00 | NQ | Futures | 1469.99 | 1492.35 | 1450.47 | 1491.22 | 79019.0 |
| 2008-10-17 10:00:00 | NQ | Futures | 1491.5 | 1506.21 | 1467.45 | 1499.14 | 96932.0 |
| 2008-10-17 11:00:00 | NQ | Futures | 1499.14 | 1513.01 | 1485.56 | 1490.65 | 72011.0 |
| 2008-10-17 12:00:00 | NQ | Futures | 1490.37 | 1525.17 | 1489.24 | 1523.19 | 46199.0 |
| 2008-10-17 13:00:00 | NQ | Futures | 1522.91 | 1552.62 | 1516.4 | 1535.64 | 69086.0 |
| 2008-10-17 14:00:00 | NQ | Futures | 1535.36 | 1545.55 | 1494.33 | 1512.72 | 85126.0 |
| 2008-10-17 15:00:00 | NQ | Futures | 1513.01 | 1526.3 | 1482.45 | 1489.24 | 94501.0 |
| 2008-10-17 16:00:00 | NQ | Futures | 1488.95 | 1491.5 | 1484.14 | 1484.99 | 11971.0 |
| 2008-10-17 00:00:00 | YM | Futures | 8177.5 | 8199.3 | 8177.5 | 8193.9 | 297.0 |
| 2008-10-17 01:00:00 | YM | Futures | 8191.1 | 8241.2 | 8189.3 | 8208.4 | 474.0 |
| 2008-10-17 02:00:00 | YM | Futures | 8208.4 | 8208.4 | 8142.0 | 8162.9 | 1253.0 |
| 2008-10-17 03:00:00 | YM | Futures | 8160.2 | 8161.1 | 8013.8 | 8014.7 | 3498.0 |
| 2008-10-17 04:00:00 | YM | Futures | 8015.6 | 8054.7 | 7958.3 | 7983.8 | 3006.0 |
| 2008-10-17 05:00:00 | YM | Futures | 7982.8 | 8022.0 | 7871.0 | 7894.6 | 3385.0 |
| 2008-10-17 06:00:00 | YM | Futures | 7894.6 | 8043.8 | 7893.7 | 8022.0 | 3909.0 |
| 2008-10-17 07:00:00 | YM | Futures | 8022.9 | 8090.2 | 8010.1 | 8082.9 | 3958.0 |
| 2008-10-17 08:00:00 | YM | Futures | 8082.9 | 8124.7 | 8002.9 | 8035.6 | 8448.0 |
| 2008-10-17 09:00:00 | YM | Futures | 8036.5 | 8131.1 | 7924.6 | 8126.6 | 41983.0 |
| 2008-10-17 10:00:00 | YM | Futures | 8127.5 | 8195.7 | 8019.2 | 8150.2 | 46419.0 |
| 2008-10-17 11:00:00 | YM | Futures | 8152.9 | 8231.1 | 8082.0 | 8124.7 | 31787.0 |
| 2008-10-17 12:00:00 | YM | Futures | 8124.7 | 8320.3 | 8119.3 | 8302.1 | 23257.0 |
| 2008-10-17 13:00:00 | YM | Futures | 8300.3 | 8444.0 | 8270.3 | 8371.2 | 37557.0 |
| 2008-10-17 14:00:00 | YM | Futures | 8371.2 | 8424.9 | 8172.0 | 8258.4 | 36930.0 |
| 2008-10-17 15:00:00 | YM | Futures | 8258.4 | 8323.9 | 8035.6 | 8046.5 | 55967.0 |
> showing 50 of 1,027 rows — these rows as CSV