PREVIEW / futures_1hour / 2008-10-31
file: by_date/futures_1hour/2008/2008-10-31.parquet size: 39 KB rows: 1,028
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-31 00:00:00 | ES | Futures | 908.02 | 910.39 | 905.89 | 907.55 | 3598.0 |
| 2008-10-31 01:00:00 | ES | Futures | 907.31 | 910.86 | 901.16 | 901.4 | 5185.0 |
| 2008-10-31 02:00:00 | ES | Futures | 901.16 | 903.53 | 895.96 | 897.85 | 7206.0 |
| 2008-10-31 03:00:00 | ES | Futures | 897.61 | 899.74 | 892.17 | 899.03 | 15393.0 |
| 2008-10-31 04:00:00 | ES | Futures | 899.27 | 901.4 | 890.28 | 893.35 | 30798.0 |
| 2008-10-31 05:00:00 | ES | Futures | 893.59 | 894.77 | 889.8 | 893.12 | 17659.0 |
| 2008-10-31 06:00:00 | ES | Futures | 893.12 | 897.14 | 890.28 | 893.83 | 16085.0 |
| 2008-10-31 07:00:00 | ES | Futures | 893.83 | 896.67 | 891.93 | 893.12 | 17178.0 |
| 2008-10-31 08:00:00 | ES | Futures | 893.35 | 904.47 | 892.17 | 903.76 | 47739.0 |
| 2008-10-31 09:00:00 | ES | Futures | 903.76 | 905.89 | 892.41 | 898.09 | 244065.0 |
| 2008-10-31 10:00:00 | ES | Futures | 898.09 | 907.55 | 896.67 | 901.16 | 364277.0 |
| 2008-10-31 11:00:00 | ES | Futures | 901.16 | 915.12 | 900.93 | 911.34 | 274107.0 |
| 2008-10-31 12:00:00 | ES | Futures | 911.34 | 912.05 | 904.47 | 910.15 | 186249.0 |
| 2008-10-31 13:00:00 | ES | Futures | 910.15 | 928.14 | 909.92 | 921.75 | 295718.0 |
| 2008-10-31 14:00:00 | ES | Futures | 921.75 | 927.67 | 916.07 | 926.48 | 289019.0 |
| 2008-10-31 15:00:00 | ES | Futures | 926.48 | 931.45 | 904.0 | 919.15 | 711999.0 |
| 2008-10-31 16:00:00 | ES | Futures | 919.15 | 920.57 | 913.7 | 914.89 | 189265.0 |
| 2008-10-31 00:00:00 | NQ | Futures | 1518.38 | 1522.34 | 1513.85 | 1516.68 | 263.0 |
| 2008-10-31 01:00:00 | NQ | Futures | 1514.14 | 1520.65 | 1505.37 | 1505.37 | 191.0 |
| 2008-10-31 02:00:00 | NQ | Futures | 1508.76 | 1511.02 | 1498.01 | 1501.69 | 234.0 |
| 2008-10-31 03:00:00 | NQ | Futures | 1501.97 | 1507.35 | 1492.07 | 1501.97 | 395.0 |
| 2008-10-31 04:00:00 | NQ | Futures | 1504.23 | 1505.93 | 1488.67 | 1494.05 | 1503.0 |
| 2008-10-31 05:00:00 | NQ | Futures | 1493.48 | 1495.46 | 1486.12 | 1493.2 | 954.0 |
| 2008-10-31 06:00:00 | NQ | Futures | 1492.91 | 1497.16 | 1478.48 | 1486.41 | 2936.0 |
| 2008-10-31 07:00:00 | NQ | Futures | 1486.97 | 1494.33 | 1486.41 | 1490.65 | 1372.0 |
| 2008-10-31 08:00:00 | NQ | Futures | 1490.65 | 1505.37 | 1488.95 | 1504.8 | 4179.0 |
| 2008-10-31 09:00:00 | NQ | Futures | 1504.52 | 1504.8 | 1477.35 | 1487.54 | 37851.0 |
| 2008-10-31 10:00:00 | NQ | Futures | 1488.1 | 1508.19 | 1486.41 | 1501.4 | 54393.0 |
| 2008-10-31 11:00:00 | NQ | Futures | 1501.12 | 1520.65 | 1499.99 | 1513.29 | 44358.0 |
| 2008-10-31 12:00:00 | NQ | Futures | 1513.29 | 1514.42 | 1499.71 | 1510.18 | 28344.0 |
| 2008-10-31 13:00:00 | NQ | Futures | 1510.18 | 1536.21 | 1509.04 | 1526.3 | 34331.0 |
| 2008-10-31 14:00:00 | NQ | Futures | 1526.59 | 1533.94 | 1515.55 | 1531.4 | 31481.0 |
| 2008-10-31 15:00:00 | NQ | Futures | 1531.4 | 1540.74 | 1493.2 | 1514.14 | 92622.0 |
| 2008-10-31 16:00:00 | NQ | Futures | 1514.42 | 1516.68 | 1504.52 | 1513.01 | 13243.0 |
| 2008-10-31 00:00:00 | YM | Futures | 8367.6 | 8393.0 | 8348.5 | 8373.9 | 299.0 |
| 2008-10-31 01:00:00 | YM | Futures | 8377.6 | 8385.8 | 8313.0 | 8313.9 | 261.0 |
| 2008-10-31 02:00:00 | YM | Futures | 8313.0 | 8323.9 | 8272.1 | 8275.7 | 464.0 |
| 2008-10-31 03:00:00 | YM | Futures | 8276.6 | 8307.5 | 8238.4 | 8298.4 | 1026.0 |
| 2008-10-31 04:00:00 | YM | Futures | 8303.9 | 8309.4 | 8223.0 | 8250.2 | 2117.0 |
| 2008-10-31 05:00:00 | YM | Futures | 8250.2 | 8263.9 | 8217.5 | 8253.9 | 1175.0 |
| 2008-10-31 06:00:00 | YM | Futures | 8253.9 | 8281.2 | 8236.6 | 8256.6 | 1065.0 |
| 2008-10-31 07:00:00 | YM | Futures | 8257.5 | 8280.3 | 8240.2 | 8253.9 | 1169.0 |
| 2008-10-31 08:00:00 | YM | Futures | 8256.6 | 8344.8 | 8248.4 | 8341.2 | 3722.0 |
| 2008-10-31 09:00:00 | YM | Futures | 8340.3 | 8356.7 | 8267.5 | 8317.5 | 24861.0 |
| 2008-10-31 10:00:00 | YM | Futures | 8317.5 | 8383.0 | 8295.7 | 8330.3 | 37199.0 |
| 2008-10-31 11:00:00 | YM | Futures | 8329.4 | 8444.9 | 8329.4 | 8397.6 | 28665.0 |
| 2008-10-31 12:00:00 | YM | Futures | 8396.7 | 8409.4 | 8343.0 | 8393.9 | 20208.0 |
| 2008-10-31 13:00:00 | YM | Futures | 8393.0 | 8545.8 | 8390.3 | 8491.3 | 27716.0 |
| 2008-10-31 14:00:00 | YM | Futures | 8488.5 | 8540.4 | 8437.6 | 8527.6 | 28288.0 |
| 2008-10-31 15:00:00 | YM | Futures | 8529.5 | 8574.9 | 8341.2 | 8488.5 | 66433.0 |
> showing 50 of 1,028 rows — these rows as CSV