PREVIEW / futures_1hour / 2024-09-27
file: by_date/futures_1hour/2024/2024-09-27.parquet size: 58 KB rows: 1,691
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 |
|---|---|---|---|---|---|---|---|
| 2024-09-27 00:00:00 | ES | Futures | 6023.28 | 6029.51 | 6022.76 | 6028.47 | 5222.0 |
| 2024-09-27 01:00:00 | ES | Futures | 6028.47 | 6030.29 | 6019.39 | 6025.87 | 10116.0 |
| 2024-09-27 02:00:00 | ES | Futures | 6025.87 | 6028.73 | 6015.75 | 6017.05 | 14451.0 |
| 2024-09-27 03:00:00 | ES | Futures | 6017.05 | 6023.28 | 6011.34 | 6011.6 | 22045.0 |
| 2024-09-27 04:00:00 | ES | Futures | 6011.6 | 6024.06 | 6011.34 | 6018.87 | 14914.0 |
| 2024-09-27 05:00:00 | ES | Futures | 6018.61 | 6024.84 | 6016.27 | 6021.2 | 10248.0 |
| 2024-09-27 06:00:00 | ES | Futures | 6021.2 | 6024.58 | 6017.83 | 6018.09 | 7640.0 |
| 2024-09-27 07:00:00 | ES | Futures | 6018.09 | 6026.13 | 6017.83 | 6025.87 | 9027.0 |
| 2024-09-27 08:00:00 | ES | Futures | 6025.61 | 6038.59 | 6024.84 | 6034.7 | 38505.0 |
| 2024-09-27 09:00:00 | ES | Futures | 6034.7 | 6036.25 | 6026.65 | 6030.29 | 134523.0 |
| 2024-09-27 10:00:00 | ES | Futures | 6029.77 | 6043.26 | 6026.13 | 6037.81 | 176094.0 |
| 2024-09-27 11:00:00 | ES | Futures | 6037.55 | 6038.07 | 6023.02 | 6023.54 | 119499.0 |
| 2024-09-27 12:00:00 | ES | Futures | 6023.28 | 6025.61 | 6017.31 | 6020.42 | 102645.0 |
| 2024-09-27 13:00:00 | ES | Futures | 6020.68 | 6025.87 | 6013.68 | 6023.28 | 83389.0 |
| 2024-09-27 14:00:00 | ES | Futures | 6023.02 | 6025.61 | 6002.26 | 6021.46 | 161115.0 |
| 2024-09-27 15:00:00 | ES | Futures | 6021.2 | 6022.24 | 6010.56 | 6011.6 | 180120.0 |
| 2024-09-27 16:00:00 | ES | Futures | 6011.6 | 6012.9 | 6005.63 | 6006.15 | 50733.0 |
| 2024-09-27 00:00:00 | NQ | Futures | 21207.74 | 21238.52 | 21204.08 | 21235.13 | 3049.0 |
| 2024-09-27 01:00:00 | NQ | Futures | 21234.87 | 21247.13 | 21176.43 | 21206.43 | 5441.0 |
| 2024-09-27 02:00:00 | NQ | Futures | 21205.91 | 21220.78 | 21136.25 | 21158.16 | 7547.0 |
| 2024-09-27 03:00:00 | NQ | Futures | 21158.16 | 21194.69 | 21118.24 | 21131.55 | 9816.0 |
| 2024-09-27 04:00:00 | NQ | Futures | 21131.81 | 21210.08 | 21128.94 | 21178.51 | 7964.0 |
| 2024-09-27 05:00:00 | NQ | Futures | 21178.51 | 21210.87 | 21165.21 | 21192.34 | 5249.0 |
| 2024-09-27 06:00:00 | NQ | Futures | 21192.86 | 21209.56 | 21166.77 | 21178.51 | 4092.0 |
| 2024-09-27 07:00:00 | NQ | Futures | 21178.51 | 21234.35 | 21178.25 | 21233.83 | 5673.0 |
| 2024-09-27 08:00:00 | NQ | Futures | 21233.04 | 21286.01 | 21227.83 | 21266.18 | 17932.0 |
| 2024-09-27 09:00:00 | NQ | Futures | 21266.18 | 21282.62 | 21197.04 | 21214.26 | 52583.0 |
| 2024-09-27 10:00:00 | NQ | Futures | 21215.3 | 21265.92 | 21157.38 | 21193.91 | 66778.0 |
| 2024-09-27 11:00:00 | NQ | Futures | 21194.95 | 21199.13 | 21114.59 | 21118.77 | 48501.0 |
| 2024-09-27 12:00:00 | NQ | Futures | 21119.03 | 21153.21 | 21092.15 | 21146.68 | 36593.0 |
| 2024-09-27 13:00:00 | NQ | Futures | 21146.94 | 21170.16 | 21100.76 | 21165.47 | 32371.0 |
| 2024-09-27 14:00:00 | NQ | Futures | 21164.95 | 21178.77 | 21053.54 | 21132.33 | 47726.0 |
| 2024-09-27 15:00:00 | NQ | Futures | 21132.07 | 21139.12 | 21093.46 | 21105.2 | 42285.0 |
| 2024-09-27 16:00:00 | NQ | Futures | 21105.72 | 21109.89 | 21069.97 | 21074.41 | 12105.0 |
| 2024-09-27 00:00:00 | YM | Futures | 44269.4 | 44290.3 | 44269.4 | 44288.2 | 894.0 |
| 2024-09-27 01:00:00 | YM | Futures | 44288.2 | 44302.7 | 44261.1 | 44297.5 | 1020.0 |
| 2024-09-27 02:00:00 | YM | Futures | 44298.6 | 44319.4 | 44243.4 | 44245.5 | 1970.0 |
| 2024-09-27 03:00:00 | YM | Futures | 44246.5 | 44274.6 | 44220.5 | 44222.6 | 1724.0 |
| 2024-09-27 04:00:00 | YM | Futures | 44224.7 | 44284.0 | 44222.6 | 44261.1 | 1539.0 |
| 2024-09-27 05:00:00 | YM | Futures | 44262.2 | 44295.5 | 44249.7 | 44275.7 | 1200.0 |
| 2024-09-27 06:00:00 | YM | Futures | 44275.7 | 44302.7 | 44262.2 | 44262.2 | 982.0 |
| 2024-09-27 07:00:00 | YM | Futures | 44262.2 | 44298.6 | 44257.0 | 44294.4 | 1316.0 |
| 2024-09-27 08:00:00 | YM | Futures | 44293.4 | 44395.4 | 44290.3 | 44375.6 | 4417.0 |
| 2024-09-27 09:00:00 | YM | Futures | 44373.5 | 44487.0 | 44323.6 | 44455.7 | 20723.0 |
| 2024-09-27 10:00:00 | YM | Futures | 44459.9 | 44668.0 | 44414.1 | 44652.4 | 24508.0 |
| 2024-09-27 11:00:00 | YM | Futures | 44652.4 | 44757.6 | 44639.9 | 44663.9 | 17588.0 |
| 2024-09-27 12:00:00 | YM | Futures | 44662.8 | 44662.8 | 44460.9 | 44468.2 | 13821.0 |
| 2024-09-27 13:00:00 | YM | Futures | 44468.2 | 44516.1 | 44426.6 | 44487.0 | 8869.0 |
| 2024-09-27 14:00:00 | YM | Futures | 44487.0 | 44502.6 | 44340.2 | 44483.8 | 11732.0 |
| 2024-09-27 15:00:00 | YM | Futures | 44482.8 | 44493.2 | 44385.0 | 44393.3 | 12169.0 |
> showing 50 of 1,691 rows — these rows as CSV