PREVIEW / futures_1hour / 2024-02-05
file: by_date/futures_1hour/2024/2024-02-05.parquet size: 68 KB rows: 2,118
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-02-05 00:00:00 | ES | Futures | 5337.16 | 5339.85 | 5336.36 | 5338.78 | 5459.0 |
| 2024-02-05 01:00:00 | ES | Futures | 5338.78 | 5341.46 | 5338.51 | 5340.12 | 5025.0 |
| 2024-02-05 02:00:00 | ES | Futures | 5340.12 | 5342.8 | 5337.97 | 5338.51 | 7001.0 |
| 2024-02-05 03:00:00 | ES | Futures | 5338.51 | 5343.88 | 5336.9 | 5341.73 | 12010.0 |
| 2024-02-05 04:00:00 | ES | Futures | 5341.73 | 5343.07 | 5332.87 | 5335.02 | 14423.0 |
| 2024-02-05 05:00:00 | ES | Futures | 5335.02 | 5343.88 | 5335.02 | 5341.73 | 11865.0 |
| 2024-02-05 06:00:00 | ES | Futures | 5342.0 | 5342.8 | 5339.58 | 5340.12 | 12058.0 |
| 2024-02-05 07:00:00 | ES | Futures | 5340.12 | 5345.49 | 5337.97 | 5343.88 | 18898.0 |
| 2024-02-05 08:00:00 | ES | Futures | 5343.88 | 5344.95 | 5332.33 | 5334.21 | 34826.0 |
| 2024-02-05 09:00:00 | ES | Futures | 5334.21 | 5342.8 | 5332.87 | 5339.85 | 154511.0 |
| 2024-02-05 10:00:00 | ES | Futures | 5339.31 | 5339.85 | 5304.93 | 5311.38 | 287129.0 |
| 2024-02-05 11:00:00 | ES | Futures | 5311.38 | 5325.88 | 5310.04 | 5325.35 | 146490.0 |
| 2024-02-05 12:00:00 | ES | Futures | 5325.61 | 5339.58 | 5324.27 | 5335.28 | 120535.0 |
| 2024-02-05 13:00:00 | ES | Futures | 5335.55 | 5340.92 | 5330.45 | 5336.36 | 103178.0 |
| 2024-02-05 14:00:00 | ES | Futures | 5336.36 | 5347.64 | 5333.4 | 5345.49 | 106968.0 |
| 2024-02-05 15:00:00 | ES | Futures | 5345.76 | 5346.03 | 5329.37 | 5329.91 | 244448.0 |
| 2024-02-05 16:00:00 | ES | Futures | 5329.91 | 5330.99 | 5324.0 | 5329.11 | 65646.0 |
| 2024-02-05 18:00:00 | ES | Futures | 5328.3 | 5330.99 | 5325.88 | 5326.69 | 4092.0 |
| 2024-02-05 19:00:00 | ES | Futures | 5326.42 | 5330.45 | 5326.15 | 5329.91 | 3343.0 |
| 2024-02-05 20:00:00 | ES | Futures | 5329.64 | 5333.13 | 5329.37 | 5332.6 | 6902.0 |
| 2024-02-05 21:00:00 | ES | Futures | 5332.33 | 5335.02 | 5331.52 | 5333.13 | 4799.0 |
| 2024-02-05 22:00:00 | ES | Futures | 5333.4 | 5336.63 | 5333.13 | 5334.21 | 5028.0 |
| 2024-02-05 23:00:00 | ES | Futures | 5333.94 | 5336.63 | 5333.4 | 5336.09 | 2829.0 |
| 2024-02-05 00:00:00 | NQ | Futures | 19184.27 | 19198.37 | 19176.14 | 19191.32 | 4295.0 |
| 2024-02-05 01:00:00 | NQ | Futures | 19191.59 | 19207.32 | 19188.61 | 19195.66 | 4271.0 |
| 2024-02-05 02:00:00 | NQ | Futures | 19195.12 | 19216.0 | 19187.8 | 19195.93 | 5164.0 |
| 2024-02-05 03:00:00 | NQ | Futures | 19196.2 | 19229.56 | 19187.8 | 19221.16 | 7685.0 |
| 2024-02-05 04:00:00 | NQ | Futures | 19220.61 | 19225.49 | 19172.88 | 19183.73 | 9401.0 |
| 2024-02-05 05:00:00 | NQ | Futures | 19183.73 | 19226.58 | 19183.73 | 19221.16 | 7144.0 |
| 2024-02-05 06:00:00 | NQ | Futures | 19221.43 | 19226.04 | 19203.26 | 19210.31 | 7183.0 |
| 2024-02-05 07:00:00 | NQ | Futures | 19210.04 | 19240.14 | 19202.17 | 19236.89 | 11563.0 |
| 2024-02-05 08:00:00 | NQ | Futures | 19236.89 | 19243.94 | 19191.05 | 19201.63 | 18473.0 |
| 2024-02-05 09:00:00 | NQ | Futures | 19201.9 | 19241.77 | 19175.86 | 19205.97 | 78594.0 |
| 2024-02-05 10:00:00 | NQ | Futures | 19206.51 | 19207.87 | 19043.24 | 19085.28 | 119544.0 |
| 2024-02-05 11:00:00 | NQ | Futures | 19085.28 | 19161.49 | 19076.06 | 19157.69 | 64424.0 |
| 2024-02-05 12:00:00 | NQ | Futures | 19157.69 | 19223.05 | 19151.73 | 19195.93 | 56064.0 |
| 2024-02-05 13:00:00 | NQ | Futures | 19196.48 | 19225.77 | 19177.22 | 19198.1 | 47859.0 |
| 2024-02-05 14:00:00 | NQ | Futures | 19198.37 | 19250.72 | 19182.37 | 19239.6 | 46615.0 |
| 2024-02-05 15:00:00 | NQ | Futures | 19240.14 | 19241.5 | 19172.61 | 19198.37 | 76354.0 |
| 2024-02-05 16:00:00 | NQ | Futures | 19198.37 | 19209.76 | 19178.31 | 19204.07 | 17961.0 |
| 2024-02-05 18:00:00 | NQ | Futures | 19199.73 | 19213.02 | 19193.76 | 19197.56 | 3303.0 |
| 2024-02-05 19:00:00 | NQ | Futures | 19197.56 | 19214.38 | 19195.12 | 19209.22 | 2745.0 |
| 2024-02-05 20:00:00 | NQ | Futures | 19208.68 | 19224.14 | 19206.51 | 19222.51 | 3562.0 |
| 2024-02-05 21:00:00 | NQ | Futures | 19222.24 | 19235.26 | 19218.99 | 19227.12 | 3082.0 |
| 2024-02-05 22:00:00 | NQ | Futures | 19227.66 | 19242.85 | 19226.31 | 19233.36 | 3676.0 |
| 2024-02-05 23:00:00 | NQ | Futures | 19233.09 | 19247.19 | 19230.38 | 19243.12 | 2484.0 |
| 2024-02-05 00:00:00 | YM | Futures | 41543.2 | 41562.5 | 41541.0 | 41547.5 | 791.0 |
| 2024-02-05 01:00:00 | YM | Futures | 41547.5 | 41565.7 | 41545.3 | 41557.1 | 653.0 |
| 2024-02-05 02:00:00 | YM | Futures | 41555.0 | 41575.4 | 41521.7 | 41523.8 | 1938.0 |
| 2024-02-05 03:00:00 | YM | Futures | 41524.9 | 41569.0 | 41521.7 | 41552.8 | 1594.0 |
> showing 50 of 2,118 rows — these rows as CSV