PREVIEW / futures_1hour / 2024-09-18
file: by_date/futures_1hour/2024/2024-09-18.parquet size: 69 KB rows: 2,082
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-18 00:00:00 | ES | Futures | 5920.25 | 5923.62 | 5918.43 | 5920.25 | 3209.0 |
| 2024-09-18 01:00:00 | ES | Futures | 5919.99 | 5923.36 | 5918.43 | 5922.84 | 4345.0 |
| 2024-09-18 02:00:00 | ES | Futures | 5922.58 | 5928.55 | 5922.58 | 5925.7 | 5813.0 |
| 2024-09-18 03:00:00 | ES | Futures | 5925.96 | 5927.77 | 5918.95 | 5919.73 | 10009.0 |
| 2024-09-18 04:00:00 | ES | Futures | 5919.73 | 5921.29 | 5915.32 | 5921.03 | 11803.0 |
| 2024-09-18 05:00:00 | ES | Futures | 5921.03 | 5926.48 | 5919.73 | 5925.96 | 5756.0 |
| 2024-09-18 06:00:00 | ES | Futures | 5926.22 | 5926.74 | 5923.36 | 5925.7 | 4825.0 |
| 2024-09-18 07:00:00 | ES | Futures | 5925.44 | 5927.51 | 5921.29 | 5921.29 | 8544.0 |
| 2024-09-18 08:00:00 | ES | Futures | 5921.55 | 5929.07 | 5916.1 | 5926.74 | 21759.0 |
| 2024-09-18 09:00:00 | ES | Futures | 5926.48 | 5927.51 | 5911.68 | 5916.61 | 109759.0 |
| 2024-09-18 10:00:00 | ES | Futures | 5916.36 | 5919.99 | 5907.53 | 5914.28 | 125333.0 |
| 2024-09-18 11:00:00 | ES | Futures | 5914.28 | 5918.17 | 5900.78 | 5901.82 | 94028.0 |
| 2024-09-18 12:00:00 | ES | Futures | 5901.82 | 5923.36 | 5898.71 | 5922.32 | 73009.0 |
| 2024-09-18 13:00:00 | ES | Futures | 5922.58 | 5929.59 | 5914.02 | 5917.65 | 82715.0 |
| 2024-09-18 14:00:00 | ES | Futures | 5917.39 | 5975.01 | 5901.56 | 5923.1 | 414785.0 |
| 2024-09-18 15:00:00 | ES | Futures | 5923.1 | 5944.9 | 5891.44 | 5897.15 | 395446.0 |
| 2024-09-18 16:00:00 | ES | Futures | 5897.15 | 5913.5 | 5894.04 | 5906.49 | 57066.0 |
| 2024-09-18 18:00:00 | ES | Futures | 5909.87 | 5919.99 | 5907.79 | 5915.84 | 6701.0 |
| 2024-09-18 19:00:00 | ES | Futures | 5915.84 | 5937.12 | 5909.87 | 5936.08 | 10103.0 |
| 2024-09-18 20:00:00 | ES | Futures | 5935.82 | 5948.02 | 5920.51 | 5923.36 | 22771.0 |
| 2024-09-18 21:00:00 | ES | Futures | 5923.62 | 5929.33 | 5915.06 | 5929.33 | 11426.0 |
| 2024-09-18 22:00:00 | ES | Futures | 5929.33 | 5951.65 | 5929.07 | 5948.8 | 13835.0 |
| 2024-09-18 23:00:00 | ES | Futures | 5948.54 | 5956.58 | 5943.6 | 5955.8 | 11958.0 |
| 2024-09-18 00:00:00 | NQ | Futures | 20546.32 | 20560.15 | 20529.89 | 20538.76 | 2436.0 |
| 2024-09-18 01:00:00 | NQ | Futures | 20538.24 | 20554.67 | 20528.58 | 20551.8 | 2923.0 |
| 2024-09-18 02:00:00 | NQ | Futures | 20550.76 | 20580.5 | 20549.72 | 20575.02 | 3347.0 |
| 2024-09-18 03:00:00 | NQ | Futures | 20576.07 | 20587.81 | 20539.02 | 20555.46 | 7317.0 |
| 2024-09-18 04:00:00 | NQ | Futures | 20554.93 | 20557.02 | 20515.27 | 20545.8 | 7736.0 |
| 2024-09-18 05:00:00 | NQ | Futures | 20545.54 | 20571.37 | 20542.41 | 20570.85 | 3548.0 |
| 2024-09-18 06:00:00 | NQ | Futures | 20570.33 | 20575.28 | 20558.06 | 20573.2 | 3442.0 |
| 2024-09-18 07:00:00 | NQ | Futures | 20573.2 | 20590.42 | 20560.67 | 20562.24 | 4840.0 |
| 2024-09-18 08:00:00 | NQ | Futures | 20562.5 | 20594.07 | 20530.15 | 20588.33 | 9607.0 |
| 2024-09-18 09:00:00 | NQ | Futures | 20588.59 | 20597.98 | 20525.45 | 20568.76 | 44726.0 |
| 2024-09-18 10:00:00 | NQ | Futures | 20568.5 | 20585.46 | 20504.58 | 20550.76 | 48000.0 |
| 2024-09-18 11:00:00 | NQ | Futures | 20550.76 | 20568.5 | 20441.18 | 20452.39 | 37107.0 |
| 2024-09-18 12:00:00 | NQ | Futures | 20452.39 | 20573.46 | 20438.31 | 20566.67 | 34771.0 |
| 2024-09-18 13:00:00 | NQ | Futures | 20566.67 | 20592.77 | 20532.23 | 20548.41 | 27681.0 |
| 2024-09-18 14:00:00 | NQ | Futures | 20561.98 | 20768.62 | 20486.84 | 20583.63 | 128574.0 |
| 2024-09-18 15:00:00 | NQ | Futures | 20582.07 | 20637.38 | 20411.69 | 20438.83 | 114345.0 |
| 2024-09-18 16:00:00 | NQ | Futures | 20438.31 | 20521.54 | 20421.09 | 20489.71 | 15887.0 |
| 2024-09-18 18:00:00 | NQ | Futures | 20506.4 | 20546.85 | 20493.88 | 20525.71 | 4529.0 |
| 2024-09-18 19:00:00 | NQ | Futures | 20525.71 | 20642.34 | 20499.88 | 20625.64 | 7001.0 |
| 2024-09-18 20:00:00 | NQ | Futures | 20626.68 | 20712.0 | 20563.28 | 20581.81 | 12122.0 |
| 2024-09-18 21:00:00 | NQ | Futures | 20582.85 | 20600.85 | 20536.93 | 20599.55 | 7240.0 |
| 2024-09-18 22:00:00 | NQ | Futures | 20600.85 | 20707.57 | 20592.24 | 20687.48 | 8716.0 |
| 2024-09-18 23:00:00 | NQ | Futures | 20687.22 | 20736.01 | 20663.73 | 20731.83 | 8666.0 |
| 2024-09-18 00:00:00 | YM | Futures | 43788.6 | 43807.3 | 43785.5 | 43791.7 | 327.0 |
| 2024-09-18 01:00:00 | YM | Futures | 43791.7 | 43813.6 | 43781.3 | 43810.5 | 529.0 |
| 2024-09-18 02:00:00 | YM | Futures | 43809.4 | 43840.6 | 43802.1 | 43814.6 | 943.0 |
| 2024-09-18 03:00:00 | YM | Futures | 43815.7 | 43824.0 | 43770.9 | 43770.9 | 873.0 |
> showing 50 of 2,082 rows — these rows as CSV