PREVIEW / futures_1hour / 2024-01-12
file: by_date/futures_1hour/2024/2024-01-12.parquet size: 56 KB rows: 1,640
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-12 00:00:00 | ES | Futures | 5165.27 | 5167.95 | 5164.46 | 5164.46 | 4150.0 |
| 2024-01-12 01:00:00 | ES | Futures | 5164.73 | 5168.49 | 5164.19 | 5168.22 | 4428.0 |
| 2024-01-12 02:00:00 | ES | Futures | 5168.22 | 5169.29 | 5158.28 | 5159.09 | 12722.0 |
| 2024-01-12 03:00:00 | ES | Futures | 5159.09 | 5177.89 | 5158.82 | 5176.01 | 26988.0 |
| 2024-01-12 04:00:00 | ES | Futures | 5175.74 | 5180.31 | 5169.83 | 5170.37 | 20132.0 |
| 2024-01-12 05:00:00 | ES | Futures | 5170.1 | 5175.2 | 5167.15 | 5168.76 | 16251.0 |
| 2024-01-12 06:00:00 | ES | Futures | 5168.76 | 5172.79 | 5147.81 | 5156.67 | 44184.0 |
| 2024-01-12 07:00:00 | ES | Futures | 5156.67 | 5163.65 | 5154.25 | 5159.09 | 29947.0 |
| 2024-01-12 08:00:00 | ES | Futures | 5159.09 | 5175.74 | 5155.6 | 5172.79 | 76923.0 |
| 2024-01-12 09:00:00 | ES | Futures | 5172.52 | 5196.15 | 5170.91 | 5180.31 | 241098.0 |
| 2024-01-12 10:00:00 | ES | Futures | 5180.31 | 5184.07 | 5159.36 | 5165.53 | 310552.0 |
| 2024-01-12 11:00:00 | ES | Futures | 5165.53 | 5176.82 | 5161.24 | 5164.19 | 151017.0 |
| 2024-01-12 12:00:00 | ES | Futures | 5164.46 | 5173.05 | 5160.7 | 5169.29 | 95440.0 |
| 2024-01-12 13:00:00 | ES | Futures | 5169.29 | 5178.96 | 5169.29 | 5177.89 | 71644.0 |
| 2024-01-12 14:00:00 | ES | Futures | 5178.16 | 5182.46 | 5169.29 | 5170.64 | 85486.0 |
| 2024-01-12 15:00:00 | ES | Futures | 5170.64 | 5177.89 | 5165.27 | 5174.94 | 173831.0 |
| 2024-01-12 16:00:00 | ES | Futures | 5174.94 | 5176.01 | 5167.15 | 5169.03 | 47597.0 |
| 2024-01-12 00:00:00 | NQ | Futures | 18383.13 | 18394.25 | 18379.33 | 18380.96 | 2414.0 |
| 2024-01-12 01:00:00 | NQ | Futures | 18380.96 | 18397.5 | 18377.71 | 18396.42 | 2331.0 |
| 2024-01-12 02:00:00 | NQ | Futures | 18396.69 | 18400.49 | 18350.04 | 18356.55 | 6833.0 |
| 2024-01-12 03:00:00 | NQ | Futures | 18356.01 | 18415.67 | 18351.94 | 18402.39 | 10014.0 |
| 2024-01-12 04:00:00 | NQ | Futures | 18401.84 | 18417.84 | 18360.89 | 18363.33 | 7657.0 |
| 2024-01-12 05:00:00 | NQ | Futures | 18362.79 | 18384.49 | 18347.87 | 18358.99 | 6289.0 |
| 2024-01-12 06:00:00 | NQ | Futures | 18359.54 | 18371.2 | 18297.16 | 18329.16 | 15190.0 |
| 2024-01-12 07:00:00 | NQ | Futures | 18328.62 | 18358.18 | 18319.67 | 18342.72 | 12454.0 |
| 2024-01-12 08:00:00 | NQ | Futures | 18342.72 | 18419.47 | 18328.35 | 18402.66 | 33748.0 |
| 2024-01-12 09:00:00 | NQ | Futures | 18402.93 | 18488.09 | 18394.25 | 18426.79 | 92257.0 |
| 2024-01-12 10:00:00 | NQ | Futures | 18427.34 | 18448.49 | 18348.14 | 18381.77 | 116185.0 |
| 2024-01-12 11:00:00 | NQ | Futures | 18381.5 | 18437.37 | 18356.28 | 18363.87 | 72153.0 |
| 2024-01-12 12:00:00 | NQ | Futures | 18364.69 | 18404.01 | 18352.21 | 18391.81 | 45659.0 |
| 2024-01-12 13:00:00 | NQ | Futures | 18391.81 | 18423.81 | 18391.54 | 18419.47 | 30946.0 |
| 2024-01-12 14:00:00 | NQ | Futures | 18419.47 | 18435.47 | 18380.69 | 18388.83 | 39925.0 |
| 2024-01-12 15:00:00 | NQ | Futures | 18389.1 | 18420.29 | 18368.21 | 18411.88 | 59814.0 |
| 2024-01-12 16:00:00 | NQ | Futures | 18411.88 | 18412.15 | 18384.49 | 18393.44 | 10470.0 |
| 2024-01-12 00:00:00 | YM | Futures | 40700.0 | 40718.3 | 40696.8 | 40696.8 | 604.0 |
| 2024-01-12 01:00:00 | YM | Futures | 40695.7 | 40716.1 | 40695.7 | 40716.1 | 679.0 |
| 2024-01-12 02:00:00 | YM | Futures | 40716.1 | 40723.7 | 40650.6 | 40652.8 | 2244.0 |
| 2024-01-12 03:00:00 | YM | Futures | 40652.8 | 40810.7 | 40652.8 | 40793.5 | 5311.0 |
| 2024-01-12 04:00:00 | YM | Futures | 40792.4 | 40819.2 | 40768.8 | 40774.1 | 3451.0 |
| 2024-01-12 05:00:00 | YM | Futures | 40774.1 | 40812.8 | 40695.7 | 40714.0 | 8160.0 |
| 2024-01-12 06:00:00 | YM | Futures | 40714.0 | 40754.8 | 40440.1 | 40514.2 | 16741.0 |
| 2024-01-12 07:00:00 | YM | Futures | 40516.4 | 40590.5 | 40515.3 | 40547.5 | 6973.0 |
| 2024-01-12 08:00:00 | YM | Futures | 40549.7 | 40643.1 | 40518.5 | 40630.2 | 10803.0 |
| 2024-01-12 09:00:00 | YM | Futures | 40629.1 | 40848.2 | 40616.2 | 40646.3 | 28113.0 |
| 2024-01-12 10:00:00 | YM | Futures | 40647.4 | 40663.5 | 40462.7 | 40498.1 | 24117.0 |
| 2024-01-12 11:00:00 | YM | Futures | 40498.1 | 40569.0 | 40473.4 | 40508.8 | 13146.0 |
| 2024-01-12 12:00:00 | YM | Futures | 40512.1 | 40564.7 | 40482.0 | 40538.9 | 7938.0 |
| 2024-01-12 13:00:00 | YM | Futures | 40540.0 | 40620.5 | 40540.0 | 40610.9 | 6205.0 |
| 2024-01-12 14:00:00 | YM | Futures | 40610.9 | 40643.1 | 40544.3 | 40553.9 | 6727.0 |
| 2024-01-12 15:00:00 | YM | Futures | 40552.9 | 40613.0 | 40531.4 | 40594.8 | 11959.0 |
> showing 50 of 1,640 rows — these rows as CSV