PREVIEW / futures_1hour / 2024-01-11
file: by_date/futures_1hour/2024/2024-01-11.parquet size: 68 KB rows: 2,071
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-01-11 00:00:00 | ES | Futures | 5187.83 | 5189.17 | 5186.22 | 5187.02 | 4047.0 |
| 2024-01-11 01:00:00 | ES | Futures | 5187.02 | 5191.86 | 5186.48 | 5190.51 | 7204.0 |
| 2024-01-11 02:00:00 | ES | Futures | 5190.51 | 5193.2 | 5189.98 | 5190.51 | 8048.0 |
| 2024-01-11 03:00:00 | ES | Futures | 5190.24 | 5197.77 | 5188.9 | 5195.89 | 18342.0 |
| 2024-01-11 04:00:00 | ES | Futures | 5195.62 | 5196.15 | 5184.87 | 5186.48 | 17047.0 |
| 2024-01-11 05:00:00 | ES | Futures | 5186.75 | 5187.56 | 5181.38 | 5183.8 | 14169.0 |
| 2024-01-11 06:00:00 | ES | Futures | 5183.8 | 5187.56 | 5182.99 | 5184.6 | 14123.0 |
| 2024-01-11 07:00:00 | ES | Futures | 5184.34 | 5188.1 | 5181.92 | 5184.87 | 17901.0 |
| 2024-01-11 08:00:00 | ES | Futures | 5184.87 | 5196.69 | 5159.63 | 5165.0 | 131553.0 |
| 2024-01-11 09:00:00 | ES | Futures | 5165.27 | 5191.59 | 5163.92 | 5171.71 | 284435.0 |
| 2024-01-11 10:00:00 | ES | Futures | 5171.98 | 5172.79 | 5142.17 | 5146.73 | 347300.0 |
| 2024-01-11 11:00:00 | ES | Futures | 5146.46 | 5149.69 | 5127.66 | 5131.42 | 233686.0 |
| 2024-01-11 12:00:00 | ES | Futures | 5131.42 | 5150.49 | 5130.89 | 5146.2 | 129390.0 |
| 2024-01-11 13:00:00 | ES | Futures | 5146.2 | 5166.61 | 5145.39 | 5165.8 | 127331.0 |
| 2024-01-11 14:00:00 | ES | Futures | 5166.07 | 5179.23 | 5161.24 | 5177.35 | 125841.0 |
| 2024-01-11 15:00:00 | ES | Futures | 5177.62 | 5178.43 | 5162.85 | 5172.79 | 188328.0 |
| 2024-01-11 16:00:00 | ES | Futures | 5172.52 | 5173.32 | 5168.49 | 5169.83 | 38155.0 |
| 2024-01-11 18:00:00 | ES | Futures | 5169.03 | 5171.44 | 5166.34 | 5168.76 | 8061.0 |
| 2024-01-11 19:00:00 | ES | Futures | 5168.76 | 5170.91 | 5162.31 | 5163.12 | 11694.0 |
| 2024-01-11 20:00:00 | ES | Futures | 5163.39 | 5165.8 | 5160.16 | 5165.0 | 11264.0 |
| 2024-01-11 21:00:00 | ES | Futures | 5164.73 | 5169.83 | 5164.46 | 5168.76 | 6712.0 |
| 2024-01-11 22:00:00 | ES | Futures | 5168.76 | 5169.29 | 5167.15 | 5167.95 | 3044.0 |
| 2024-01-11 23:00:00 | ES | Futures | 5168.22 | 5168.22 | 5162.04 | 5165.27 | 5415.0 |
| 2024-01-11 00:00:00 | NQ | Futures | 18439.54 | 18447.13 | 18433.3 | 18440.08 | 3508.0 |
| 2024-01-11 01:00:00 | NQ | Futures | 18439.81 | 18457.44 | 18433.85 | 18450.12 | 3674.0 |
| 2024-01-11 02:00:00 | NQ | Futures | 18450.12 | 18461.78 | 18448.22 | 18453.1 | 4375.0 |
| 2024-01-11 03:00:00 | NQ | Futures | 18453.1 | 18494.05 | 18447.95 | 18487.27 | 9495.0 |
| 2024-01-11 04:00:00 | NQ | Futures | 18486.73 | 18487.82 | 18436.83 | 18446.32 | 10509.0 |
| 2024-01-11 05:00:00 | NQ | Futures | 18446.86 | 18451.75 | 18433.85 | 18446.32 | 6032.0 |
| 2024-01-11 06:00:00 | NQ | Futures | 18446.59 | 18466.39 | 18439.54 | 18450.66 | 7189.0 |
| 2024-01-11 07:00:00 | NQ | Futures | 18450.12 | 18461.78 | 18442.8 | 18445.78 | 6891.0 |
| 2024-01-11 08:00:00 | NQ | Futures | 18445.51 | 18503.82 | 18325.09 | 18341.64 | 54805.0 |
| 2024-01-11 09:00:00 | NQ | Futures | 18341.91 | 18489.17 | 18335.67 | 18396.69 | 118211.0 |
| 2024-01-11 10:00:00 | NQ | Futures | 18396.69 | 18400.22 | 18251.6 | 18285.5 | 142048.0 |
| 2024-01-11 11:00:00 | NQ | Futures | 18285.22 | 18297.16 | 18174.03 | 18196.0 | 104689.0 |
| 2024-01-11 12:00:00 | NQ | Futures | 18196.0 | 18287.39 | 18194.1 | 18266.51 | 60266.0 |
| 2024-01-11 13:00:00 | NQ | Futures | 18265.97 | 18372.82 | 18262.44 | 18370.11 | 60739.0 |
| 2024-01-11 14:00:00 | NQ | Futures | 18370.38 | 18424.35 | 18350.31 | 18414.86 | 53782.0 |
| 2024-01-11 15:00:00 | NQ | Futures | 18414.86 | 18418.93 | 18361.7 | 18404.56 | 69663.0 |
| 2024-01-11 16:00:00 | NQ | Futures | 18404.56 | 18409.17 | 18394.79 | 18396.69 | 10406.0 |
| 2024-01-11 18:00:00 | NQ | Futures | 18396.15 | 18402.11 | 18378.25 | 18389.64 | 4388.0 |
| 2024-01-11 19:00:00 | NQ | Futures | 18389.37 | 18404.28 | 18366.04 | 18370.11 | 5086.0 |
| 2024-01-11 20:00:00 | NQ | Futures | 18370.38 | 18383.13 | 18355.47 | 18379.88 | 5210.0 |
| 2024-01-11 21:00:00 | NQ | Futures | 18380.15 | 18402.11 | 18379.06 | 18396.42 | 3695.0 |
| 2024-01-11 22:00:00 | NQ | Futures | 18396.96 | 18399.13 | 18389.91 | 18395.06 | 1862.0 |
| 2024-01-11 23:00:00 | NQ | Futures | 18395.06 | 18396.42 | 18373.91 | 18383.67 | 2996.0 |
| 2024-01-11 00:00:00 | YM | Futures | 40802.1 | 40810.7 | 40789.2 | 40796.7 | 712.0 |
| 2024-01-11 01:00:00 | YM | Futures | 40795.6 | 40835.4 | 40793.5 | 40822.5 | 1240.0 |
| 2024-01-11 02:00:00 | YM | Futures | 40823.5 | 40844.0 | 40821.4 | 40822.5 | 1711.0 |
| 2024-01-11 03:00:00 | YM | Futures | 40822.5 | 40855.8 | 40808.5 | 40840.7 | 2541.0 |
> showing 50 of 2,071 rows — these rows as CSV