PREVIEW / futures_1hour / 2024-06-10
file: by_date/futures_1hour/2024/2024-06-10.parquet size: 58 KB rows: 1,835
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-06-10 00:00:00 | ES | Futures | 5683.43 | 5685.55 | 5682.63 | 5685.02 | 2084.0 |
| 2024-06-10 01:00:00 | ES | Futures | 5685.02 | 5686.08 | 5683.16 | 5684.76 | 3243.0 |
| 2024-06-10 02:00:00 | ES | Futures | 5684.76 | 5684.76 | 5672.55 | 5673.88 | 12105.0 |
| 2024-06-10 03:00:00 | ES | Futures | 5673.88 | 5678.65 | 5670.43 | 5677.59 | 25646.0 |
| 2024-06-10 04:00:00 | ES | Futures | 5677.59 | 5678.65 | 5669.1 | 5670.7 | 15903.0 |
| 2024-06-10 05:00:00 | ES | Futures | 5670.7 | 5672.55 | 5664.86 | 5670.7 | 13301.0 |
| 2024-06-10 06:00:00 | ES | Futures | 5670.7 | 5679.19 | 5668.57 | 5675.47 | 14138.0 |
| 2024-06-10 07:00:00 | ES | Futures | 5675.47 | 5681.31 | 5674.94 | 5678.39 | 12889.0 |
| 2024-06-10 08:00:00 | ES | Futures | 5678.12 | 5682.37 | 5672.29 | 5673.61 | 20099.0 |
| 2024-06-10 09:00:00 | ES | Futures | 5673.35 | 5675.47 | 5667.78 | 5673.61 | 140013.0 |
| 2024-06-10 10:00:00 | ES | Futures | 5673.35 | 5682.1 | 5672.55 | 5680.25 | 135854.0 |
| 2024-06-10 11:00:00 | ES | Futures | 5680.25 | 5694.57 | 5679.98 | 5689.8 | 122610.0 |
| 2024-06-10 12:00:00 | ES | Futures | 5689.8 | 5695.37 | 5689.0 | 5692.18 | 77886.0 |
| 2024-06-10 13:00:00 | ES | Futures | 5692.18 | 5701.47 | 5685.29 | 5696.69 | 122806.0 |
| 2024-06-10 14:00:00 | ES | Futures | 5696.69 | 5699.88 | 5686.08 | 5693.78 | 136280.0 |
| 2024-06-10 15:00:00 | ES | Futures | 5693.78 | 5704.65 | 5690.33 | 5701.47 | 205293.0 |
| 2024-06-10 16:00:00 | ES | Futures | 5701.2 | 5702.27 | 5693.25 | 5698.02 | 43615.0 |
| 2024-06-10 18:00:00 | ES | Futures | 5698.29 | 5699.88 | 5697.49 | 5697.49 | 3222.0 |
| 2024-06-10 19:00:00 | ES | Futures | 5697.76 | 5698.29 | 5693.25 | 5694.57 | 3575.0 |
| 2024-06-10 20:00:00 | ES | Futures | 5694.57 | 5695.1 | 5691.92 | 5692.45 | 3687.0 |
| 2024-06-10 21:00:00 | ES | Futures | 5692.45 | 5695.63 | 5691.65 | 5695.37 | 4380.0 |
| 2024-06-10 22:00:00 | ES | Futures | 5695.1 | 5695.37 | 5692.45 | 5693.25 | 3079.0 |
| 2024-06-10 23:00:00 | ES | Futures | 5693.25 | 5694.57 | 5691.92 | 5694.31 | 2348.0 |
| 2024-06-10 00:00:00 | NQ | Futures | 20376.58 | 20381.93 | 20369.63 | 20379.53 | 1355.0 |
| 2024-06-10 01:00:00 | NQ | Futures | 20379.79 | 20385.41 | 20370.97 | 20376.85 | 1852.0 |
| 2024-06-10 02:00:00 | NQ | Futures | 20377.12 | 20377.39 | 20332.45 | 20338.06 | 6326.0 |
| 2024-06-10 03:00:00 | NQ | Futures | 20337.8 | 20359.73 | 20322.28 | 20351.97 | 10878.0 |
| 2024-06-10 04:00:00 | NQ | Futures | 20351.97 | 20353.58 | 20321.48 | 20327.1 | 7693.0 |
| 2024-06-10 05:00:00 | NQ | Futures | 20326.56 | 20338.06 | 20302.75 | 20330.31 | 5896.0 |
| 2024-06-10 06:00:00 | NQ | Futures | 20330.57 | 20370.97 | 20325.49 | 20346.36 | 7791.0 |
| 2024-06-10 07:00:00 | NQ | Futures | 20346.89 | 20372.57 | 20345.82 | 20358.13 | 6724.0 |
| 2024-06-10 08:00:00 | NQ | Futures | 20357.59 | 20368.29 | 20317.73 | 20323.08 | 10656.0 |
| 2024-06-10 09:00:00 | NQ | Futures | 20323.62 | 20355.72 | 20306.5 | 20323.35 | 75741.0 |
| 2024-06-10 10:00:00 | NQ | Futures | 20323.62 | 20404.94 | 20317.47 | 20400.66 | 81056.0 |
| 2024-06-10 11:00:00 | NQ | Futures | 20400.39 | 20451.75 | 20396.91 | 20424.74 | 62828.0 |
| 2024-06-10 12:00:00 | NQ | Futures | 20424.74 | 20460.05 | 20418.85 | 20444.0 | 47474.0 |
| 2024-06-10 13:00:00 | NQ | Futures | 20443.73 | 20456.57 | 20388.09 | 20439.18 | 59820.0 |
| 2024-06-10 14:00:00 | NQ | Futures | 20439.18 | 20444.26 | 20366.69 | 20413.5 | 72401.0 |
| 2024-06-10 15:00:00 | NQ | Futures | 20412.7 | 20469.14 | 20408.15 | 20450.42 | 77637.0 |
| 2024-06-10 16:00:00 | NQ | Futures | 20450.42 | 20453.63 | 20419.38 | 20445.6 | 13029.0 |
| 2024-06-10 18:00:00 | NQ | Futures | 20445.07 | 20445.07 | 20429.82 | 20431.96 | 2291.0 |
| 2024-06-10 19:00:00 | NQ | Futures | 20432.49 | 20434.1 | 20411.63 | 20421.26 | 2825.0 |
| 2024-06-10 20:00:00 | NQ | Futures | 20420.46 | 20424.74 | 20414.03 | 20417.24 | 1984.0 |
| 2024-06-10 21:00:00 | NQ | Futures | 20416.44 | 20433.83 | 20414.3 | 20432.23 | 2788.0 |
| 2024-06-10 22:00:00 | NQ | Futures | 20431.42 | 20432.49 | 20419.92 | 20424.2 | 1729.0 |
| 2024-06-10 23:00:00 | NQ | Futures | 20423.67 | 20428.75 | 20414.57 | 20427.14 | 1817.0 |
| 2024-06-10 00:00:00 | YM | Futures | 41245.0 | 41253.5 | 41237.6 | 41249.3 | 536.0 |
| 2024-06-10 01:00:00 | YM | Futures | 41248.2 | 41256.7 | 41237.6 | 41245.0 | 709.0 |
| 2024-06-10 02:00:00 | YM | Futures | 41244.0 | 41244.0 | 41146.3 | 41153.7 | 2007.0 |
| 2024-06-10 03:00:00 | YM | Futures | 41150.5 | 41201.5 | 41119.7 | 41190.9 | 3450.0 |
> showing 50 of 1,835 rows — these rows as CSV