PREVIEW / futures_1hour / 2024-09-16
file: by_date/futures_1hour/2024/2024-09-16.parquet size: 63 KB rows: 2,032
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-16 00:00:00 | ES | Futures | 5911.42 | 5911.68 | 5910.39 | 5910.65 | 560.0 |
| 2024-09-16 01:00:00 | ES | Futures | 5910.91 | 5911.42 | 5907.27 | 5909.35 | 1091.0 |
| 2024-09-16 02:00:00 | ES | Futures | 5909.61 | 5909.61 | 5902.86 | 5903.9 | 3299.0 |
| 2024-09-16 03:00:00 | ES | Futures | 5904.16 | 5910.91 | 5902.6 | 5910.39 | 5103.0 |
| 2024-09-16 04:00:00 | ES | Futures | 5910.65 | 5915.06 | 5908.83 | 5913.76 | 4649.0 |
| 2024-09-16 05:00:00 | ES | Futures | 5913.76 | 5916.36 | 5911.16 | 5911.42 | 4155.0 |
| 2024-09-16 06:00:00 | ES | Futures | 5911.42 | 5911.42 | 5904.68 | 5909.87 | 4485.0 |
| 2024-09-16 07:00:00 | ES | Futures | 5910.13 | 5910.39 | 5903.12 | 5905.2 | 6729.0 |
| 2024-09-16 08:00:00 | ES | Futures | 5905.46 | 5906.75 | 5900.52 | 5902.86 | 12899.0 |
| 2024-09-16 09:00:00 | ES | Futures | 5902.86 | 5917.65 | 5895.33 | 5912.98 | 90796.0 |
| 2024-09-16 10:00:00 | ES | Futures | 5912.98 | 5916.61 | 5885.47 | 5894.56 | 125191.0 |
| 2024-09-16 11:00:00 | ES | Futures | 5894.3 | 5902.86 | 5888.59 | 5900.01 | 70809.0 |
| 2024-09-16 12:00:00 | ES | Futures | 5900.01 | 5903.9 | 5890.4 | 5903.38 | 67394.0 |
| 2024-09-16 13:00:00 | ES | Futures | 5903.38 | 5913.5 | 5899.23 | 5913.24 | 53206.0 |
| 2024-09-16 14:00:00 | ES | Futures | 5913.24 | 5915.58 | 5906.23 | 5915.32 | 48822.0 |
| 2024-09-16 15:00:00 | ES | Futures | 5915.06 | 5919.99 | 5907.79 | 5917.65 | 105996.0 |
| 2024-09-16 16:00:00 | ES | Futures | 5917.65 | 5918.43 | 5911.16 | 5911.68 | 28903.0 |
| 2024-09-16 18:00:00 | ES | Futures | 5911.16 | 5918.17 | 5911.16 | 5915.84 | 3958.0 |
| 2024-09-16 19:00:00 | ES | Futures | 5915.84 | 5917.39 | 5912.46 | 5913.24 | 2225.0 |
| 2024-09-16 20:00:00 | ES | Futures | 5913.24 | 5915.32 | 5909.09 | 5909.87 | 3467.0 |
| 2024-09-16 21:00:00 | ES | Futures | 5909.61 | 5911.94 | 5907.27 | 5911.42 | 3464.0 |
| 2024-09-16 22:00:00 | ES | Futures | 5911.42 | 5912.46 | 5908.57 | 5911.42 | 2124.0 |
| 2024-09-16 23:00:00 | ES | Futures | 5911.68 | 5912.2 | 5908.31 | 5910.39 | 2394.0 |
| 2024-09-16 00:00:00 | NQ | Futures | 20630.34 | 20632.42 | 20623.55 | 20627.21 | 592.0 |
| 2024-09-16 01:00:00 | NQ | Futures | 20627.99 | 20630.86 | 20608.42 | 20617.03 | 1012.0 |
| 2024-09-16 02:00:00 | NQ | Futures | 20617.29 | 20618.34 | 20579.98 | 20588.59 | 1982.0 |
| 2024-09-16 03:00:00 | NQ | Futures | 20589.37 | 20621.47 | 20582.59 | 20619.12 | 4038.0 |
| 2024-09-16 04:00:00 | NQ | Futures | 20619.64 | 20644.95 | 20614.68 | 20627.47 | 3135.0 |
| 2024-09-16 05:00:00 | NQ | Futures | 20628.25 | 20639.47 | 20612.6 | 20616.77 | 3068.0 |
| 2024-09-16 06:00:00 | NQ | Futures | 20617.29 | 20617.55 | 20565.11 | 20593.03 | 3716.0 |
| 2024-09-16 07:00:00 | NQ | Futures | 20593.03 | 20594.85 | 20539.28 | 20551.02 | 4810.0 |
| 2024-09-16 08:00:00 | NQ | Futures | 20551.54 | 20556.76 | 20521.01 | 20531.71 | 7597.0 |
| 2024-09-16 09:00:00 | NQ | Futures | 20531.19 | 20557.28 | 20415.08 | 20521.54 | 48054.0 |
| 2024-09-16 10:00:00 | NQ | Futures | 20521.01 | 20553.89 | 20381.43 | 20426.83 | 49484.0 |
| 2024-09-16 11:00:00 | NQ | Futures | 20426.04 | 20499.62 | 20387.43 | 20454.74 | 28920.0 |
| 2024-09-16 12:00:00 | NQ | Futures | 20455.27 | 20479.53 | 20397.08 | 20477.96 | 24670.0 |
| 2024-09-16 13:00:00 | NQ | Futures | 20477.7 | 20527.54 | 20445.35 | 20518.67 | 21399.0 |
| 2024-09-16 14:00:00 | NQ | Futures | 20519.19 | 20530.15 | 20483.18 | 20523.88 | 19898.0 |
| 2024-09-16 15:00:00 | NQ | Futures | 20524.41 | 20543.71 | 20493.88 | 20529.1 | 26748.0 |
| 2024-09-16 16:00:00 | NQ | Futures | 20528.84 | 20531.97 | 20506.93 | 20507.97 | 7867.0 |
| 2024-09-16 18:00:00 | NQ | Futures | 20512.93 | 20555.19 | 20509.8 | 20542.15 | 3554.0 |
| 2024-09-16 19:00:00 | NQ | Futures | 20542.15 | 20552.06 | 20529.1 | 20531.45 | 1743.0 |
| 2024-09-16 20:00:00 | NQ | Futures | 20531.97 | 20541.63 | 20506.66 | 20510.32 | 2349.0 |
| 2024-09-16 21:00:00 | NQ | Futures | 20509.8 | 20514.49 | 20489.97 | 20511.36 | 2518.0 |
| 2024-09-16 22:00:00 | NQ | Futures | 20511.36 | 20521.28 | 20501.97 | 20517.62 | 1611.0 |
| 2024-09-16 23:00:00 | NQ | Futures | 20518.14 | 20520.23 | 20494.4 | 20504.58 | 1545.0 |
| 2024-09-16 00:00:00 | YM | Futures | 43571.6 | 43573.7 | 43563.2 | 43563.2 | 62.0 |
| 2024-09-16 01:00:00 | YM | Futures | 43564.2 | 43567.4 | 43545.3 | 43555.8 | 196.0 |
| 2024-09-16 02:00:00 | YM | Futures | 43554.8 | 43554.8 | 43510.6 | 43516.9 | 516.0 |
| 2024-09-16 03:00:00 | YM | Futures | 43519.0 | 43554.8 | 43499.1 | 43552.7 | 343.0 |
> showing 50 of 2,032 rows — these rows as CSV