PREVIEW / futures_1hour / 2024-07-23
file: by_date/futures_1hour/2024/2024-07-23.parquet size: 67 KB rows: 2,067
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-23 00:00:00 | ES | Futures | 5872.21 | 5876.14 | 5872.21 | 5874.31 | 2317.0 |
| 2024-07-23 01:00:00 | ES | Futures | 5874.31 | 5876.4 | 5869.85 | 5872.21 | 4076.0 |
| 2024-07-23 02:00:00 | ES | Futures | 5872.21 | 5874.57 | 5865.39 | 5873.26 | 11170.0 |
| 2024-07-23 03:00:00 | ES | Futures | 5873.52 | 5874.05 | 5861.2 | 5863.56 | 16359.0 |
| 2024-07-23 04:00:00 | ES | Futures | 5863.82 | 5873.52 | 5859.63 | 5871.42 | 12981.0 |
| 2024-07-23 05:00:00 | ES | Futures | 5871.69 | 5881.65 | 5871.16 | 5879.29 | 9732.0 |
| 2024-07-23 06:00:00 | ES | Futures | 5879.55 | 5887.42 | 5878.24 | 5885.06 | 12640.0 |
| 2024-07-23 07:00:00 | ES | Futures | 5885.06 | 5891.61 | 5884.53 | 5888.46 | 16190.0 |
| 2024-07-23 08:00:00 | ES | Futures | 5888.46 | 5888.73 | 5875.09 | 5881.91 | 28776.0 |
| 2024-07-23 09:00:00 | ES | Futures | 5881.91 | 5894.23 | 5876.14 | 5890.82 | 156245.0 |
| 2024-07-23 10:00:00 | ES | Futures | 5890.82 | 5900.26 | 5877.19 | 5884.27 | 237641.0 |
| 2024-07-23 11:00:00 | ES | Futures | 5884.27 | 5903.67 | 5883.48 | 5897.9 | 164560.0 |
| 2024-07-23 12:00:00 | ES | Futures | 5898.16 | 5899.74 | 5876.14 | 5880.86 | 159333.0 |
| 2024-07-23 13:00:00 | ES | Futures | 5881.12 | 5888.99 | 5876.4 | 5887.68 | 115118.0 |
| 2024-07-23 14:00:00 | ES | Futures | 5887.42 | 5891.09 | 5879.81 | 5886.1 | 82828.0 |
| 2024-07-23 15:00:00 | ES | Futures | 5886.37 | 5888.99 | 5866.7 | 5871.16 | 187050.0 |
| 2024-07-23 16:00:00 | ES | Futures | 5871.42 | 5884.53 | 5865.92 | 5874.83 | 84365.0 |
| 2024-07-23 18:00:00 | ES | Futures | 5856.74 | 5856.74 | 5844.68 | 5851.24 | 16427.0 |
| 2024-07-23 19:00:00 | ES | Futures | 5851.5 | 5851.5 | 5845.99 | 5846.26 | 6934.0 |
| 2024-07-23 20:00:00 | ES | Futures | 5846.26 | 5854.38 | 5846.26 | 5853.33 | 6657.0 |
| 2024-07-23 21:00:00 | ES | Futures | 5853.33 | 5854.91 | 5850.45 | 5850.71 | 6549.0 |
| 2024-07-23 22:00:00 | ES | Futures | 5850.98 | 5852.29 | 5848.88 | 5850.45 | 2733.0 |
| 2024-07-23 23:00:00 | ES | Futures | 5850.45 | 5851.24 | 5845.47 | 5846.78 | 2849.0 |
| 2024-07-23 00:00:00 | NQ | Futures | 21048.12 | 21067.39 | 21046.53 | 21056.3 | 1972.0 |
| 2024-07-23 01:00:00 | NQ | Futures | 21056.56 | 21069.76 | 21035.71 | 21047.06 | 2666.0 |
| 2024-07-23 02:00:00 | NQ | Futures | 21047.59 | 21062.9 | 21010.9 | 21052.08 | 7125.0 |
| 2024-07-23 03:00:00 | NQ | Futures | 21052.6 | 21054.72 | 20979.48 | 21005.62 | 11091.0 |
| 2024-07-23 04:00:00 | NQ | Futures | 21006.14 | 21044.69 | 20987.93 | 21034.65 | 9063.0 |
| 2024-07-23 05:00:00 | NQ | Futures | 21035.18 | 21088.51 | 21034.39 | 21075.04 | 6816.0 |
| 2024-07-23 06:00:00 | NQ | Futures | 21074.78 | 21112.26 | 21067.92 | 21090.62 | 6763.0 |
| 2024-07-23 07:00:00 | NQ | Futures | 21090.35 | 21134.97 | 21089.83 | 21114.11 | 9742.0 |
| 2024-07-23 08:00:00 | NQ | Futures | 21113.58 | 21114.38 | 21038.09 | 21085.6 | 17654.0 |
| 2024-07-23 09:00:00 | NQ | Futures | 21085.34 | 21156.61 | 21048.38 | 21125.2 | 80717.0 |
| 2024-07-23 10:00:00 | NQ | Futures | 21125.46 | 21169.02 | 21042.05 | 21086.13 | 107759.0 |
| 2024-07-23 11:00:00 | NQ | Futures | 21086.13 | 21208.09 | 21082.96 | 21154.5 | 71835.0 |
| 2024-07-23 12:00:00 | NQ | Futures | 21155.29 | 21161.63 | 21040.99 | 21065.01 | 64384.0 |
| 2024-07-23 13:00:00 | NQ | Futures | 21065.01 | 21105.93 | 21029.64 | 21097.22 | 46199.0 |
| 2024-07-23 14:00:00 | NQ | Futures | 21096.43 | 21115.43 | 21062.11 | 21092.73 | 38770.0 |
| 2024-07-23 15:00:00 | NQ | Futures | 21092.99 | 21114.11 | 21017.23 | 21039.14 | 57482.0 |
| 2024-07-23 16:00:00 | NQ | Futures | 21039.14 | 21118.34 | 21015.91 | 21061.84 | 29175.0 |
| 2024-07-23 18:00:00 | NQ | Futures | 20995.06 | 20995.06 | 20892.9 | 20925.36 | 12244.0 |
| 2024-07-23 19:00:00 | NQ | Futures | 20925.36 | 20925.89 | 20899.23 | 20899.23 | 5884.0 |
| 2024-07-23 20:00:00 | NQ | Futures | 20899.76 | 20947.8 | 20899.76 | 20935.92 | 6833.0 |
| 2024-07-23 21:00:00 | NQ | Futures | 20937.51 | 20946.48 | 20920.09 | 20923.52 | 6504.0 |
| 2024-07-23 22:00:00 | NQ | Futures | 20922.46 | 20932.49 | 20916.39 | 20926.95 | 1882.0 |
| 2024-07-23 23:00:00 | NQ | Futures | 20926.68 | 20931.17 | 20900.02 | 20905.83 | 2302.0 |
| 2024-07-23 00:00:00 | YM | Futures | 42713.1 | 42733.1 | 42712.1 | 42722.6 | 308.0 |
| 2024-07-23 01:00:00 | YM | Futures | 42722.6 | 42731.0 | 42698.4 | 42716.3 | 530.0 |
| 2024-07-23 02:00:00 | YM | Futures | 42713.1 | 42718.4 | 42660.6 | 42705.8 | 1590.0 |
| 2024-07-23 03:00:00 | YM | Futures | 42707.9 | 42716.3 | 42656.4 | 42668.0 | 1879.0 |
> showing 50 of 2,067 rows — these rows as CSV