PREVIEW / futures_1hour / 2024-08-26
file: by_date/futures_1hour/2024/2024-08-26.parquet size: 62 KB rows: 1,969
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-08-26 00:00:00 | ES | Futures | 5920.71 | 5924.38 | 5920.19 | 5923.33 | 1717.0 |
| 2024-08-26 01:00:00 | ES | Futures | 5923.07 | 5927.26 | 5920.97 | 5924.91 | 3222.0 |
| 2024-08-26 02:00:00 | ES | Futures | 5925.17 | 5929.62 | 5924.64 | 5925.69 | 3892.0 |
| 2024-08-26 03:00:00 | ES | Futures | 5925.95 | 5934.34 | 5925.17 | 5933.56 | 8992.0 |
| 2024-08-26 04:00:00 | ES | Futures | 5933.56 | 5940.11 | 5931.2 | 5939.06 | 7720.0 |
| 2024-08-26 05:00:00 | ES | Futures | 5939.06 | 5939.32 | 5934.61 | 5937.75 | 4573.0 |
| 2024-08-26 06:00:00 | ES | Futures | 5937.75 | 5939.32 | 5933.82 | 5937.75 | 7148.0 |
| 2024-08-26 07:00:00 | ES | Futures | 5937.75 | 5939.85 | 5927.26 | 5934.61 | 12155.0 |
| 2024-08-26 08:00:00 | ES | Futures | 5934.34 | 5937.75 | 5930.15 | 5937.23 | 14499.0 |
| 2024-08-26 09:00:00 | ES | Futures | 5936.96 | 5944.83 | 5931.72 | 5935.39 | 128352.0 |
| 2024-08-26 10:00:00 | ES | Futures | 5935.39 | 5937.23 | 5904.98 | 5915.21 | 205525.0 |
| 2024-08-26 11:00:00 | ES | Futures | 5914.94 | 5917.3 | 5900.79 | 5902.88 | 129187.0 |
| 2024-08-26 12:00:00 | ES | Futures | 5902.88 | 5920.97 | 5900.26 | 5919.14 | 93592.0 |
| 2024-08-26 13:00:00 | ES | Futures | 5919.14 | 5921.23 | 5894.76 | 5898.16 | 107651.0 |
| 2024-08-26 14:00:00 | ES | Futures | 5898.16 | 5913.11 | 5893.18 | 5912.32 | 108563.0 |
| 2024-08-26 15:00:00 | ES | Futures | 5912.06 | 5912.85 | 5902.1 | 5911.53 | 139506.0 |
| 2024-08-26 16:00:00 | ES | Futures | 5911.8 | 5912.32 | 5901.57 | 5903.41 | 43326.0 |
| 2024-08-26 18:00:00 | ES | Futures | 5903.93 | 5907.6 | 5896.85 | 5900.0 | 5368.0 |
| 2024-08-26 19:00:00 | ES | Futures | 5900.0 | 5907.6 | 5899.48 | 5906.03 | 3493.0 |
| 2024-08-26 20:00:00 | ES | Futures | 5906.03 | 5910.22 | 5901.05 | 5902.36 | 5940.0 |
| 2024-08-26 21:00:00 | ES | Futures | 5902.36 | 5906.29 | 5899.74 | 5905.24 | 4992.0 |
| 2024-08-26 22:00:00 | ES | Futures | 5905.51 | 5910.75 | 5904.46 | 5908.65 | 3400.0 |
| 2024-08-26 23:00:00 | ES | Futures | 5908.65 | 5910.22 | 5907.34 | 5908.91 | 2060.0 |
| 2024-08-26 00:00:00 | NQ | Futures | 20868.61 | 20888.14 | 20859.37 | 20883.39 | 1438.0 |
| 2024-08-26 01:00:00 | NQ | Futures | 20881.81 | 20902.66 | 20869.14 | 20891.31 | 2135.0 |
| 2024-08-26 02:00:00 | NQ | Futures | 20891.58 | 20916.92 | 20885.24 | 20894.48 | 3243.0 |
| 2024-08-26 03:00:00 | NQ | Futures | 20895.01 | 20946.48 | 20888.67 | 20938.3 | 5567.0 |
| 2024-08-26 04:00:00 | NQ | Futures | 20937.24 | 20956.25 | 20921.41 | 20952.56 | 5087.0 |
| 2024-08-26 05:00:00 | NQ | Futures | 20953.08 | 20954.14 | 20930.38 | 20947.54 | 2847.0 |
| 2024-08-26 06:00:00 | NQ | Futures | 20946.75 | 20954.4 | 20905.3 | 20917.97 | 5279.0 |
| 2024-08-26 07:00:00 | NQ | Futures | 20916.65 | 20925.89 | 20849.34 | 20879.96 | 8480.0 |
| 2024-08-26 08:00:00 | NQ | Futures | 20880.22 | 20896.59 | 20853.03 | 20880.75 | 8195.0 |
| 2024-08-26 09:00:00 | NQ | Futures | 20880.49 | 20909.0 | 20813.7 | 20825.05 | 56429.0 |
| 2024-08-26 10:00:00 | NQ | Futures | 20825.58 | 20833.24 | 20596.44 | 20697.55 | 99154.0 |
| 2024-08-26 11:00:00 | NQ | Futures | 20696.76 | 20732.13 | 20639.47 | 20649.5 | 55536.0 |
| 2024-08-26 12:00:00 | NQ | Futures | 20650.03 | 20741.63 | 20634.72 | 20717.08 | 41466.0 |
| 2024-08-26 13:00:00 | NQ | Futures | 20717.61 | 20724.47 | 20615.71 | 20629.44 | 41858.0 |
| 2024-08-26 14:00:00 | NQ | Futures | 20629.7 | 20718.14 | 20605.42 | 20712.6 | 43870.0 |
| 2024-08-26 15:00:00 | NQ | Futures | 20712.6 | 20722.1 | 20651.35 | 20689.36 | 48982.0 |
| 2024-08-26 16:00:00 | NQ | Futures | 20689.36 | 20693.59 | 20641.85 | 20642.38 | 13739.0 |
| 2024-08-26 18:00:00 | NQ | Futures | 20652.67 | 20668.77 | 20613.34 | 20629.7 | 3235.0 |
| 2024-08-26 19:00:00 | NQ | Futures | 20629.7 | 20673.79 | 20624.69 | 20665.34 | 3140.0 |
| 2024-08-26 20:00:00 | NQ | Futures | 20665.34 | 20688.84 | 20642.38 | 20650.82 | 4274.0 |
| 2024-08-26 21:00:00 | NQ | Futures | 20651.09 | 20670.89 | 20636.3 | 20665.08 | 3087.0 |
| 2024-08-26 22:00:00 | NQ | Futures | 20664.02 | 20701.24 | 20659.53 | 20690.42 | 2566.0 |
| 2024-08-26 23:00:00 | NQ | Futures | 20690.42 | 20701.24 | 20682.24 | 20691.21 | 1839.0 |
| 2024-08-26 00:00:00 | YM | Futures | 43329.9 | 43341.5 | 43327.8 | 43336.2 | 166.0 |
| 2024-08-26 01:00:00 | YM | Futures | 43336.2 | 43352.0 | 43325.7 | 43341.5 | 393.0 |
| 2024-08-26 02:00:00 | YM | Futures | 43342.5 | 43355.1 | 43332.0 | 43341.5 | 845.0 |
| 2024-08-26 03:00:00 | YM | Futures | 43341.5 | 43382.4 | 43338.3 | 43380.3 | 1053.0 |
> showing 50 of 1,969 rows — these rows as CSV