PREVIEW / futures_1hour / 2024-09-17
file: by_date/futures_1hour/2024/2024-09-17.parquet size: 66 KB rows: 2,074
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-17 00:00:00 | ES | Futures | 5910.39 | 5914.54 | 5909.35 | 5914.54 | 2105.0 |
| 2024-09-17 01:00:00 | ES | Futures | 5914.28 | 5917.39 | 5914.28 | 5916.87 | 3477.0 |
| 2024-09-17 02:00:00 | ES | Futures | 5917.13 | 5919.73 | 5915.58 | 5919.21 | 4770.0 |
| 2024-09-17 03:00:00 | ES | Futures | 5919.47 | 5930.89 | 5918.43 | 5927.0 | 11074.0 |
| 2024-09-17 04:00:00 | ES | Futures | 5927.0 | 5932.19 | 5927.0 | 5930.37 | 7623.0 |
| 2024-09-17 05:00:00 | ES | Futures | 5930.37 | 5939.19 | 5930.11 | 5936.34 | 6867.0 |
| 2024-09-17 06:00:00 | ES | Futures | 5936.6 | 5939.19 | 5932.19 | 5932.7 | 6884.0 |
| 2024-09-17 07:00:00 | ES | Futures | 5932.96 | 5944.12 | 5929.07 | 5941.01 | 13785.0 |
| 2024-09-17 08:00:00 | ES | Futures | 5941.01 | 5944.9 | 5935.56 | 5942.05 | 30167.0 |
| 2024-09-17 09:00:00 | ES | Futures | 5942.05 | 5945.16 | 5928.81 | 5933.22 | 129250.0 |
| 2024-09-17 10:00:00 | ES | Futures | 5933.22 | 5955.54 | 5930.89 | 5940.49 | 171723.0 |
| 2024-09-17 11:00:00 | ES | Futures | 5940.49 | 5949.05 | 5936.34 | 5938.67 | 114465.0 |
| 2024-09-17 12:00:00 | ES | Futures | 5938.67 | 5940.75 | 5895.59 | 5904.68 | 188677.0 |
| 2024-09-17 13:00:00 | ES | Futures | 5904.68 | 5917.91 | 5894.04 | 5914.02 | 115812.0 |
| 2024-09-17 14:00:00 | ES | Futures | 5914.02 | 5919.21 | 5899.75 | 5907.53 | 100289.0 |
| 2024-09-17 15:00:00 | ES | Futures | 5907.27 | 5919.99 | 5900.26 | 5919.21 | 154127.0 |
| 2024-09-17 16:00:00 | ES | Futures | 5919.47 | 5923.88 | 5917.39 | 5918.43 | 37204.0 |
| 2024-09-17 18:00:00 | ES | Futures | 5918.17 | 5921.55 | 5917.13 | 5919.47 | 3481.0 |
| 2024-09-17 19:00:00 | ES | Futures | 5919.47 | 5923.88 | 5917.65 | 5922.84 | 2196.0 |
| 2024-09-17 20:00:00 | ES | Futures | 5923.1 | 5924.14 | 5920.77 | 5921.81 | 3037.0 |
| 2024-09-17 21:00:00 | ES | Futures | 5922.06 | 5924.92 | 5920.77 | 5924.4 | 3441.0 |
| 2024-09-17 22:00:00 | ES | Futures | 5924.4 | 5925.44 | 5923.62 | 5924.66 | 2295.0 |
| 2024-09-17 23:00:00 | ES | Futures | 5924.66 | 5924.66 | 5919.47 | 5920.25 | 2731.0 |
| 2024-09-17 00:00:00 | NQ | Futures | 20504.84 | 20528.84 | 20499.62 | 20528.58 | 1182.0 |
| 2024-09-17 01:00:00 | NQ | Futures | 20527.8 | 20550.76 | 20527.02 | 20547.37 | 1959.0 |
| 2024-09-17 02:00:00 | NQ | Futures | 20547.89 | 20565.11 | 20533.54 | 20552.85 | 2614.0 |
| 2024-09-17 03:00:00 | NQ | Futures | 20553.37 | 20607.64 | 20550.76 | 20595.64 | 7244.0 |
| 2024-09-17 04:00:00 | NQ | Futures | 20595.37 | 20613.38 | 20589.37 | 20602.42 | 5522.0 |
| 2024-09-17 05:00:00 | NQ | Futures | 20602.42 | 20650.43 | 20601.38 | 20637.12 | 4550.0 |
| 2024-09-17 06:00:00 | NQ | Futures | 20637.64 | 20650.17 | 20611.81 | 20615.99 | 3993.0 |
| 2024-09-17 07:00:00 | NQ | Futures | 20615.47 | 20666.6 | 20601.64 | 20656.95 | 6573.0 |
| 2024-09-17 08:00:00 | NQ | Futures | 20656.95 | 20684.61 | 20629.55 | 20659.56 | 13342.0 |
| 2024-09-17 09:00:00 | NQ | Futures | 20660.6 | 20694.26 | 20569.28 | 20622.51 | 58343.0 |
| 2024-09-17 10:00:00 | NQ | Futures | 20623.29 | 20716.7 | 20601.38 | 20632.42 | 68539.0 |
| 2024-09-17 11:00:00 | NQ | Futures | 20632.69 | 20681.48 | 20602.68 | 20637.9 | 42688.0 |
| 2024-09-17 12:00:00 | NQ | Futures | 20637.9 | 20648.6 | 20451.87 | 20491.27 | 60183.0 |
| 2024-09-17 13:00:00 | NQ | Futures | 20492.05 | 20554.41 | 20428.91 | 20519.71 | 39629.0 |
| 2024-09-17 14:00:00 | NQ | Futures | 20519.71 | 20541.11 | 20464.92 | 20497.79 | 31205.0 |
| 2024-09-17 15:00:00 | NQ | Futures | 20497.27 | 20545.02 | 20477.96 | 20541.63 | 39604.0 |
| 2024-09-17 16:00:00 | NQ | Futures | 20541.37 | 20561.72 | 20530.93 | 20545.54 | 10581.0 |
| 2024-09-17 18:00:00 | NQ | Futures | 20546.06 | 20557.8 | 20538.24 | 20547.11 | 1989.0 |
| 2024-09-17 19:00:00 | NQ | Futures | 20547.63 | 20568.76 | 20539.28 | 20566.41 | 1742.0 |
| 2024-09-17 20:00:00 | NQ | Futures | 20565.89 | 20570.33 | 20555.72 | 20564.33 | 1809.0 |
| 2024-09-17 21:00:00 | NQ | Futures | 20563.8 | 20575.55 | 20555.19 | 20571.11 | 2217.0 |
| 2024-09-17 22:00:00 | NQ | Futures | 20571.63 | 20576.07 | 20566.41 | 20571.63 | 1284.0 |
| 2024-09-17 23:00:00 | NQ | Futures | 20572.15 | 20572.15 | 20543.45 | 20546.32 | 2291.0 |
| 2024-09-17 00:00:00 | YM | Futures | 43739.7 | 43755.3 | 43732.4 | 43753.2 | 218.0 |
| 2024-09-17 01:00:00 | YM | Futures | 43754.3 | 43763.6 | 43747.0 | 43762.6 | 514.0 |
| 2024-09-17 02:00:00 | YM | Futures | 43764.7 | 43794.9 | 43761.6 | 43794.9 | 709.0 |
| 2024-09-17 03:00:00 | YM | Futures | 43791.7 | 43839.6 | 43784.4 | 43812.5 | 1337.0 |
> showing 50 of 2,074 rows — these rows as CSV