PREVIEW / futures_1hour / 2024-10-11
file: by_date/futures_1hour/2024/2024-10-11.parquet size: 55 KB rows: 1,644
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-10-11 00:00:00 | ES | Futures | 6055.98 | 6056.24 | 6051.57 | 6052.09 | 1970.0 |
| 2024-10-11 01:00:00 | ES | Futures | 6052.09 | 6052.6 | 6048.45 | 6051.05 | 3037.0 |
| 2024-10-11 02:00:00 | ES | Futures | 6051.05 | 6051.83 | 6047.93 | 6048.19 | 3693.0 |
| 2024-10-11 03:00:00 | ES | Futures | 6048.45 | 6049.23 | 6039.37 | 6046.64 | 10135.0 |
| 2024-10-11 04:00:00 | ES | Futures | 6046.38 | 6046.9 | 6037.55 | 6038.59 | 8609.0 |
| 2024-10-11 05:00:00 | ES | Futures | 6038.85 | 6043.52 | 6037.81 | 6039.89 | 6277.0 |
| 2024-10-11 06:00:00 | ES | Futures | 6039.89 | 6047.93 | 6038.33 | 6047.93 | 8500.0 |
| 2024-10-11 07:00:00 | ES | Futures | 6047.67 | 6049.49 | 6043.78 | 6044.56 | 8340.0 |
| 2024-10-11 08:00:00 | ES | Futures | 6044.56 | 6060.13 | 6043.52 | 6047.67 | 37753.0 |
| 2024-10-11 09:00:00 | ES | Futures | 6047.93 | 6062.21 | 6044.56 | 6061.43 | 110442.0 |
| 2024-10-11 10:00:00 | ES | Futures | 6060.65 | 6089.72 | 6056.5 | 6078.82 | 210216.0 |
| 2024-10-11 11:00:00 | ES | Futures | 6078.82 | 6086.34 | 6077.78 | 6084.79 | 86477.0 |
| 2024-10-11 12:00:00 | ES | Futures | 6084.53 | 6084.53 | 6067.66 | 6076.48 | 90422.0 |
| 2024-10-11 13:00:00 | ES | Futures | 6076.48 | 6081.67 | 6071.29 | 6079.08 | 61718.0 |
| 2024-10-11 14:00:00 | ES | Futures | 6079.08 | 6087.38 | 6075.7 | 6085.05 | 75697.0 |
| 2024-10-11 15:00:00 | ES | Futures | 6085.3 | 6091.79 | 6082.19 | 6082.71 | 161724.0 |
| 2024-10-11 16:00:00 | ES | Futures | 6082.71 | 6084.53 | 6075.7 | 6076.22 | 50260.0 |
| 2024-10-11 00:00:00 | NQ | Futures | 21348.89 | 21349.15 | 21324.62 | 21327.49 | 1527.0 |
| 2024-10-11 01:00:00 | NQ | Futures | 21327.23 | 21328.54 | 21305.58 | 21318.36 | 1958.0 |
| 2024-10-11 02:00:00 | NQ | Futures | 21318.36 | 21325.15 | 21302.71 | 21305.58 | 2598.0 |
| 2024-10-11 03:00:00 | NQ | Futures | 21306.1 | 21309.75 | 21260.96 | 21301.4 | 6096.0 |
| 2024-10-11 04:00:00 | NQ | Futures | 21300.36 | 21302.71 | 21242.44 | 21248.44 | 6888.0 |
| 2024-10-11 05:00:00 | NQ | Futures | 21249.48 | 21272.7 | 21245.05 | 21257.83 | 4104.0 |
| 2024-10-11 06:00:00 | NQ | Futures | 21258.09 | 21279.75 | 21247.92 | 21271.92 | 4633.0 |
| 2024-10-11 07:00:00 | NQ | Futures | 21271.14 | 21276.62 | 21252.35 | 21256.53 | 4293.0 |
| 2024-10-11 08:00:00 | NQ | Futures | 21256.79 | 21307.4 | 21243.48 | 21258.09 | 18103.0 |
| 2024-10-11 09:00:00 | NQ | Futures | 21258.35 | 21269.31 | 21201.47 | 21248.44 | 56184.0 |
| 2024-10-11 10:00:00 | NQ | Futures | 21247.13 | 21375.24 | 21212.69 | 21319.93 | 85442.0 |
| 2024-10-11 11:00:00 | NQ | Futures | 21319.41 | 21365.59 | 21296.45 | 21362.72 | 39179.0 |
| 2024-10-11 12:00:00 | NQ | Futures | 21362.72 | 21364.81 | 21295.14 | 21332.45 | 32996.0 |
| 2024-10-11 13:00:00 | NQ | Futures | 21332.45 | 21344.72 | 21308.45 | 21328.8 | 21939.0 |
| 2024-10-11 14:00:00 | NQ | Futures | 21328.8 | 21369.76 | 21316.54 | 21360.89 | 25764.0 |
| 2024-10-11 15:00:00 | NQ | Futures | 21360.37 | 21388.81 | 21338.71 | 21342.37 | 40436.0 |
| 2024-10-11 16:00:00 | NQ | Futures | 21342.37 | 21346.28 | 21297.23 | 21304.27 | 13445.0 |
| 2024-10-11 00:00:00 | YM | Futures | 44501.5 | 44501.5 | 44478.6 | 44480.7 | 182.0 |
| 2024-10-11 01:00:00 | YM | Futures | 44479.7 | 44484.9 | 44463.0 | 44478.6 | 329.0 |
| 2024-10-11 02:00:00 | YM | Futures | 44475.5 | 44478.6 | 44453.7 | 44455.7 | 762.0 |
| 2024-10-11 03:00:00 | YM | Futures | 44456.8 | 44468.2 | 44422.4 | 44458.9 | 1127.0 |
| 2024-10-11 04:00:00 | YM | Futures | 44459.9 | 44475.5 | 44420.3 | 44438.0 | 1397.0 |
| 2024-10-11 05:00:00 | YM | Futures | 44439.1 | 44460.9 | 44405.8 | 44417.2 | 879.0 |
| 2024-10-11 06:00:00 | YM | Futures | 44415.1 | 44502.6 | 44404.7 | 44499.4 | 4123.0 |
| 2024-10-11 07:00:00 | YM | Futures | 44500.5 | 44519.2 | 44468.2 | 44470.3 | 1582.0 |
| 2024-10-11 08:00:00 | YM | Futures | 44473.4 | 44546.3 | 44454.7 | 44477.6 | 5610.0 |
| 2024-10-11 09:00:00 | YM | Futures | 44477.6 | 44689.9 | 44467.2 | 44664.9 | 21742.0 |
| 2024-10-11 10:00:00 | YM | Futures | 44662.8 | 44825.2 | 44630.6 | 44788.8 | 22021.0 |
| 2024-10-11 11:00:00 | YM | Futures | 44788.8 | 44872.0 | 44770.0 | 44845.0 | 11716.0 |
| 2024-10-11 12:00:00 | YM | Futures | 44846.0 | 44850.2 | 44727.4 | 44783.6 | 8791.0 |
| 2024-10-11 13:00:00 | YM | Futures | 44784.6 | 44835.6 | 44738.8 | 44828.3 | 6164.0 |
| 2024-10-11 14:00:00 | YM | Futures | 44828.3 | 44902.2 | 44804.4 | 44871.0 | 8068.0 |
| 2024-10-11 15:00:00 | YM | Futures | 44870.0 | 44939.7 | 44859.5 | 44901.2 | 13524.0 |
> showing 50 of 1,644 rows — these rows as CSV