PREVIEW / futures_1hour / 2024-11-15
file: by_date/futures_1hour/2024/2024-11-15.parquet size: 58 KB rows: 1,686
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-11-15 00:00:00 | ES | Futures | 6187.3 | 6190.15 | 6182.11 | 6183.15 | 5605.0 |
| 2024-11-15 01:00:00 | ES | Futures | 6183.15 | 6183.15 | 6168.87 | 6175.88 | 15470.0 |
| 2024-11-15 02:00:00 | ES | Futures | 6175.62 | 6176.14 | 6167.31 | 6167.83 | 12164.0 |
| 2024-11-15 03:00:00 | ES | Futures | 6167.83 | 6171.47 | 6156.67 | 6169.65 | 34975.0 |
| 2024-11-15 04:00:00 | ES | Futures | 6169.39 | 6170.17 | 6163.68 | 6165.24 | 15148.0 |
| 2024-11-15 05:00:00 | ES | Futures | 6165.24 | 6168.61 | 6162.38 | 6167.83 | 14291.0 |
| 2024-11-15 06:00:00 | ES | Futures | 6167.83 | 6173.28 | 6167.31 | 6171.99 | 14602.0 |
| 2024-11-15 07:00:00 | ES | Futures | 6171.99 | 6179.51 | 6171.21 | 6178.21 | 20329.0 |
| 2024-11-15 08:00:00 | ES | Futures | 6177.95 | 6180.03 | 6167.05 | 6169.65 | 48053.0 |
| 2024-11-15 09:00:00 | ES | Futures | 6169.39 | 6171.21 | 6150.19 | 6152.0 | 256466.0 |
| 2024-11-15 10:00:00 | ES | Futures | 6152.26 | 6152.78 | 6123.71 | 6128.13 | 343458.0 |
| 2024-11-15 11:00:00 | ES | Futures | 6128.13 | 6138.51 | 6118.26 | 6121.12 | 195028.0 |
| 2024-11-15 12:00:00 | ES | Futures | 6121.12 | 6123.2 | 6109.18 | 6117.49 | 150850.0 |
| 2024-11-15 13:00:00 | ES | Futures | 6117.49 | 6119.82 | 6100.62 | 6107.36 | 138283.0 |
| 2024-11-15 14:00:00 | ES | Futures | 6107.62 | 6121.12 | 6102.43 | 6112.55 | 153125.0 |
| 2024-11-15 15:00:00 | ES | Futures | 6112.55 | 6126.83 | 6110.74 | 6121.64 | 298353.0 |
| 2024-11-15 16:00:00 | ES | Futures | 6121.64 | 6130.2 | 6121.12 | 6124.75 | 70037.0 |
| 2024-11-15 00:00:00 | NQ | Futures | 21832.1 | 21842.54 | 21806.53 | 21811.75 | 3021.0 |
| 2024-11-15 01:00:00 | NQ | Futures | 21812.27 | 21812.27 | 21740.26 | 21780.7 | 9481.0 |
| 2024-11-15 02:00:00 | NQ | Futures | 21779.92 | 21786.44 | 21750.43 | 21754.87 | 6889.0 |
| 2024-11-15 03:00:00 | NQ | Futures | 21754.35 | 21770.26 | 21701.9 | 21741.56 | 13621.0 |
| 2024-11-15 04:00:00 | NQ | Futures | 21742.35 | 21747.56 | 21716.78 | 21729.3 | 7187.0 |
| 2024-11-15 05:00:00 | NQ | Futures | 21729.04 | 21741.3 | 21715.21 | 21736.87 | 5180.0 |
| 2024-11-15 06:00:00 | NQ | Futures | 21736.61 | 21766.87 | 21733.74 | 21755.13 | 6505.0 |
| 2024-11-15 07:00:00 | NQ | Futures | 21753.56 | 21777.83 | 21745.22 | 21773.39 | 7714.0 |
| 2024-11-15 08:00:00 | NQ | Futures | 21771.83 | 21774.7 | 21707.91 | 21719.91 | 17677.0 |
| 2024-11-15 09:00:00 | NQ | Futures | 21719.65 | 21727.21 | 21581.62 | 21593.1 | 96194.0 |
| 2024-11-15 10:00:00 | NQ | Futures | 21593.36 | 21600.93 | 21439.43 | 21458.73 | 115982.0 |
| 2024-11-15 11:00:00 | NQ | Futures | 21458.73 | 21489.52 | 21374.98 | 21390.11 | 82348.0 |
| 2024-11-15 12:00:00 | NQ | Futures | 21390.37 | 21408.64 | 21338.98 | 21377.85 | 61518.0 |
| 2024-11-15 13:00:00 | NQ | Futures | 21377.33 | 21385.94 | 21295.92 | 21320.71 | 54784.0 |
| 2024-11-15 14:00:00 | NQ | Futures | 21320.97 | 21388.29 | 21310.8 | 21353.85 | 52656.0 |
| 2024-11-15 15:00:00 | NQ | Futures | 21353.33 | 21408.9 | 21344.98 | 21385.94 | 83650.0 |
| 2024-11-15 16:00:00 | NQ | Futures | 21386.2 | 21417.77 | 21384.37 | 21398.2 | 19214.0 |
| 2024-11-15 00:00:00 | YM | Futures | 45577.7 | 45594.3 | 45548.5 | 45554.8 | 546.0 |
| 2024-11-15 01:00:00 | YM | Futures | 45554.8 | 45556.9 | 45476.7 | 45514.2 | 2327.0 |
| 2024-11-15 02:00:00 | YM | Futures | 45511.1 | 45511.1 | 45436.1 | 45440.3 | 1785.0 |
| 2024-11-15 03:00:00 | YM | Futures | 45440.3 | 45507.9 | 45396.6 | 45504.8 | 4048.0 |
| 2024-11-15 04:00:00 | YM | Futures | 45503.8 | 45514.2 | 45469.4 | 45471.5 | 3162.0 |
| 2024-11-15 05:00:00 | YM | Futures | 45471.5 | 45502.7 | 45458.0 | 45496.5 | 1789.0 |
| 2024-11-15 06:00:00 | YM | Futures | 45497.5 | 45520.4 | 45492.3 | 45505.9 | 1338.0 |
| 2024-11-15 07:00:00 | YM | Futures | 45504.8 | 45562.1 | 45504.8 | 45549.6 | 2079.0 |
| 2024-11-15 08:00:00 | YM | Futures | 45551.6 | 45580.8 | 45493.4 | 45506.9 | 3874.0 |
| 2024-11-15 09:00:00 | YM | Futures | 45507.9 | 45566.2 | 45425.7 | 45440.3 | 22119.0 |
| 2024-11-15 10:00:00 | YM | Futures | 45439.2 | 45447.6 | 45323.7 | 45341.4 | 22291.0 |
| 2024-11-15 11:00:00 | YM | Futures | 45340.4 | 45460.1 | 45295.6 | 45337.3 | 13255.0 |
| 2024-11-15 12:00:00 | YM | Futures | 45339.3 | 45347.7 | 45249.8 | 45303.9 | 9182.0 |
| 2024-11-15 13:00:00 | YM | Futures | 45303.9 | 45370.6 | 45256.1 | 45301.9 | 7744.0 |
| 2024-11-15 14:00:00 | YM | Futures | 45302.9 | 45385.1 | 45277.9 | 45328.9 | 7403.0 |
| 2024-11-15 15:00:00 | YM | Futures | 45325.8 | 45425.7 | 45286.3 | 45351.8 | 16500.0 |
> showing 50 of 1,686 rows — these rows as CSV