PREVIEW / futures_1hour / 2024-07-11
file: by_date/futures_1hour/2024/2024-07-11.parquet size: 68 KB rows: 2,065
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-07-11 00:00:00 | ES | Futures | 5961.35 | 5961.61 | 5960.56 | 5961.08 | 1585.0 |
| 2024-07-11 01:00:00 | ES | Futures | 5961.08 | 5963.44 | 5959.77 | 5960.04 | 4171.0 |
| 2024-07-11 02:00:00 | ES | Futures | 5960.04 | 5962.39 | 5960.04 | 5961.35 | 6332.0 |
| 2024-07-11 03:00:00 | ES | Futures | 5961.35 | 5961.87 | 5958.2 | 5961.08 | 10023.0 |
| 2024-07-11 04:00:00 | ES | Futures | 5961.08 | 5962.39 | 5958.99 | 5959.77 | 10282.0 |
| 2024-07-11 05:00:00 | ES | Futures | 5959.77 | 5960.04 | 5957.68 | 5958.99 | 7406.0 |
| 2024-07-11 06:00:00 | ES | Futures | 5959.25 | 5959.77 | 5956.63 | 5957.68 | 9240.0 |
| 2024-07-11 07:00:00 | ES | Futures | 5957.68 | 5958.72 | 5956.1 | 5956.1 | 10566.0 |
| 2024-07-11 08:00:00 | ES | Futures | 5956.36 | 5985.47 | 5953.48 | 5961.08 | 123321.0 |
| 2024-07-11 09:00:00 | ES | Futures | 5961.08 | 5969.21 | 5956.89 | 5969.21 | 177307.0 |
| 2024-07-11 10:00:00 | ES | Futures | 5969.21 | 5972.88 | 5931.2 | 5932.25 | 334216.0 |
| 2024-07-11 11:00:00 | ES | Futures | 5932.25 | 5940.37 | 5910.22 | 5913.89 | 312917.0 |
| 2024-07-11 12:00:00 | ES | Futures | 5913.89 | 5924.64 | 5905.77 | 5909.44 | 218431.0 |
| 2024-07-11 13:00:00 | ES | Futures | 5909.44 | 5917.83 | 5903.93 | 5904.98 | 154814.0 |
| 2024-07-11 14:00:00 | ES | Futures | 5904.98 | 5919.66 | 5903.93 | 5918.09 | 143045.0 |
| 2024-07-11 15:00:00 | ES | Futures | 5918.09 | 5922.55 | 5909.96 | 5910.22 | 274914.0 |
| 2024-07-11 16:00:00 | ES | Futures | 5910.49 | 5916.52 | 5906.82 | 5914.42 | 71231.0 |
| 2024-07-11 18:00:00 | ES | Futures | 5912.85 | 5916.52 | 5908.91 | 5915.21 | 7578.0 |
| 2024-07-11 19:00:00 | ES | Futures | 5915.47 | 5918.61 | 5909.44 | 5911.53 | 5654.0 |
| 2024-07-11 20:00:00 | ES | Futures | 5911.8 | 5918.61 | 5910.22 | 5914.42 | 6572.0 |
| 2024-07-11 21:00:00 | ES | Futures | 5914.42 | 5916.25 | 5912.85 | 5914.42 | 4223.0 |
| 2024-07-11 22:00:00 | ES | Futures | 5914.42 | 5915.73 | 5911.8 | 5913.37 | 3570.0 |
| 2024-07-11 23:00:00 | ES | Futures | 5913.63 | 5914.94 | 5912.06 | 5914.42 | 2744.0 |
| 2024-07-11 00:00:00 | NQ | Futures | 22051.51 | 22052.83 | 22045.97 | 22048.08 | 1076.0 |
| 2024-07-11 01:00:00 | NQ | Futures | 22048.35 | 22055.74 | 22034.36 | 22036.47 | 2427.0 |
| 2024-07-11 02:00:00 | NQ | Futures | 22036.2 | 22057.06 | 22035.15 | 22048.87 | 4075.0 |
| 2024-07-11 03:00:00 | NQ | Futures | 22048.35 | 22055.47 | 22040.69 | 22051.25 | 3895.0 |
| 2024-07-11 04:00:00 | NQ | Futures | 22051.78 | 22060.23 | 22043.86 | 22048.87 | 4945.0 |
| 2024-07-11 05:00:00 | NQ | Futures | 22049.4 | 22053.1 | 22040.16 | 22050.72 | 3805.0 |
| 2024-07-11 06:00:00 | NQ | Futures | 22050.72 | 22052.31 | 22043.86 | 22049.14 | 3274.0 |
| 2024-07-11 07:00:00 | NQ | Futures | 22049.4 | 22055.21 | 22047.03 | 22050.46 | 3717.0 |
| 2024-07-11 08:00:00 | NQ | Futures | 22049.93 | 22157.37 | 22032.77 | 22060.75 | 56370.0 |
| 2024-07-11 09:00:00 | NQ | Futures | 22060.49 | 22088.21 | 21987.1 | 22036.73 | 121197.0 |
| 2024-07-11 10:00:00 | NQ | Futures | 22036.47 | 22039.37 | 21752.95 | 21756.38 | 172884.0 |
| 2024-07-11 11:00:00 | NQ | Futures | 21756.38 | 21802.31 | 21620.96 | 21626.24 | 147274.0 |
| 2024-07-11 12:00:00 | NQ | Futures | 21627.03 | 21688.01 | 21578.46 | 21586.91 | 96481.0 |
| 2024-07-11 13:00:00 | NQ | Futures | 21587.43 | 21629.14 | 21525.93 | 21531.47 | 72870.0 |
| 2024-07-11 14:00:00 | NQ | Futures | 21530.94 | 21615.42 | 21516.95 | 21613.04 | 62872.0 |
| 2024-07-11 15:00:00 | NQ | Futures | 21612.51 | 21640.23 | 21571.59 | 21572.39 | 93387.0 |
| 2024-07-11 16:00:00 | NQ | Futures | 21572.39 | 21606.97 | 21550.74 | 21575.55 | 21680.0 |
| 2024-07-11 18:00:00 | NQ | Futures | 21575.55 | 21593.77 | 21562.09 | 21585.06 | 4480.0 |
| 2024-07-11 19:00:00 | NQ | Futures | 21585.06 | 21603.01 | 21544.4 | 21556.28 | 4945.0 |
| 2024-07-11 20:00:00 | NQ | Futures | 21556.81 | 21593.24 | 21551.27 | 21577.14 | 6311.0 |
| 2024-07-11 21:00:00 | NQ | Futures | 21577.4 | 21586.64 | 21563.67 | 21572.65 | 4172.0 |
| 2024-07-11 22:00:00 | NQ | Futures | 21572.65 | 21575.55 | 21559.45 | 21562.09 | 4934.0 |
| 2024-07-11 23:00:00 | NQ | Futures | 21562.09 | 21567.37 | 21553.38 | 21562.62 | 1943.0 |
| 2024-07-11 00:00:00 | YM | Futures | 42070.1 | 42072.2 | 42061.7 | 42066.9 | 571.0 |
| 2024-07-11 01:00:00 | YM | Futures | 42066.9 | 42081.6 | 42065.9 | 42070.1 | 846.0 |
| 2024-07-11 02:00:00 | YM | Futures | 42070.1 | 42075.3 | 42059.6 | 42072.2 | 1644.0 |
| 2024-07-11 03:00:00 | YM | Futures | 42072.2 | 42077.4 | 42024.9 | 42041.7 | 2401.0 |
> showing 50 of 2,065 rows — these rows as CSV