PREVIEW / futures_1hour / 2022-02-02
file: by_date/futures_1hour/2022/2022-02-02.parquet size: 67 KB rows: 2,055
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 |
|---|---|---|---|---|---|---|---|
| 2022-02-02 00:00:00 | ES | Futures | 5155.2 | 5165.66 | 5154.92 | 5160.01 | 6702.0 |
| 2022-02-02 01:00:00 | ES | Futures | 5160.29 | 5167.64 | 5156.33 | 5159.16 | 5868.0 |
| 2022-02-02 02:00:00 | ES | Futures | 5159.16 | 5164.25 | 5155.48 | 5158.03 | 7849.0 |
| 2022-02-02 03:00:00 | ES | Futures | 5158.03 | 5159.72 | 5148.13 | 5152.65 | 19268.0 |
| 2022-02-02 04:00:00 | ES | Futures | 5152.94 | 5175.28 | 5151.81 | 5173.58 | 19606.0 |
| 2022-02-02 05:00:00 | ES | Futures | 5173.58 | 5174.43 | 5166.51 | 5168.49 | 14160.0 |
| 2022-02-02 06:00:00 | ES | Futures | 5168.21 | 5170.19 | 5162.84 | 5169.62 | 11005.0 |
| 2022-02-02 07:00:00 | ES | Futures | 5169.62 | 5180.93 | 5166.51 | 5178.39 | 28807.0 |
| 2022-02-02 08:00:00 | ES | Futures | 5178.11 | 5178.11 | 5160.57 | 5161.7 | 34069.0 |
| 2022-02-02 09:00:00 | ES | Futures | 5161.7 | 5168.49 | 5141.34 | 5147.28 | 219668.0 |
| 2022-02-02 10:00:00 | ES | Futures | 5147.28 | 5164.81 | 5134.55 | 5153.22 | 268544.0 |
| 2022-02-02 11:00:00 | ES | Futures | 5153.22 | 5156.05 | 5130.31 | 5149.83 | 177396.0 |
| 2022-02-02 12:00:00 | ES | Futures | 5149.83 | 5173.58 | 5144.45 | 5173.02 | 115819.0 |
| 2022-02-02 13:00:00 | ES | Futures | 5173.02 | 5173.86 | 5155.2 | 5166.79 | 97294.0 |
| 2022-02-02 14:00:00 | ES | Futures | 5166.79 | 5183.48 | 5158.03 | 5175.0 | 129642.0 |
| 2022-02-02 15:00:00 | ES | Futures | 5174.71 | 5187.72 | 5170.19 | 5177.82 | 262511.0 |
| 2022-02-02 16:00:00 | ES | Futures | 5177.54 | 5180.93 | 5135.69 | 5145.3 | 105902.0 |
| 2022-02-02 18:00:00 | ES | Futures | 5142.19 | 5145.02 | 5124.37 | 5125.51 | 27704.0 |
| 2022-02-02 19:00:00 | ES | Futures | 5125.51 | 5133.42 | 5124.37 | 5126.35 | 14449.0 |
| 2022-02-02 20:00:00 | ES | Futures | 5126.64 | 5130.88 | 5122.39 | 5123.24 | 12704.0 |
| 2022-02-02 21:00:00 | ES | Futures | 5123.24 | 5128.05 | 5120.41 | 5126.92 | 7306.0 |
| 2022-02-02 22:00:00 | ES | Futures | 5126.92 | 5132.01 | 5126.07 | 5130.6 | 5591.0 |
| 2022-02-02 23:00:00 | ES | Futures | 5130.6 | 5132.01 | 5129.46 | 5130.88 | 3786.0 |
| 2022-02-02 00:00:00 | NQ | Futures | 17556.83 | 17603.2 | 17556.54 | 17584.95 | 4003.0 |
| 2022-02-02 01:00:00 | NQ | Futures | 17584.95 | 17617.69 | 17570.16 | 17583.5 | 4419.0 |
| 2022-02-02 02:00:00 | NQ | Futures | 17583.5 | 17615.09 | 17569.88 | 17588.42 | 5738.0 |
| 2022-02-02 03:00:00 | NQ | Futures | 17590.16 | 17611.61 | 17569.88 | 17586.68 | 9492.0 |
| 2022-02-02 04:00:00 | NQ | Futures | 17586.68 | 17682.61 | 17583.79 | 17674.5 | 12646.0 |
| 2022-02-02 05:00:00 | NQ | Futures | 17673.92 | 17675.37 | 17624.07 | 17637.11 | 8888.0 |
| 2022-02-02 06:00:00 | NQ | Futures | 17636.24 | 17654.79 | 17601.76 | 17651.02 | 8794.0 |
| 2022-02-02 07:00:00 | NQ | Futures | 17650.73 | 17690.44 | 17628.71 | 17677.69 | 15076.0 |
| 2022-02-02 08:00:00 | NQ | Futures | 17677.69 | 17678.85 | 17583.5 | 17588.42 | 19117.0 |
| 2022-02-02 09:00:00 | NQ | Futures | 17588.42 | 17599.73 | 17420.04 | 17500.03 | 96651.0 |
| 2022-02-02 10:00:00 | NQ | Futures | 17500.32 | 17584.66 | 17407.29 | 17463.8 | 103451.0 |
| 2022-02-02 11:00:00 | NQ | Futures | 17463.51 | 17480.61 | 17321.21 | 17421.78 | 83242.0 |
| 2022-02-02 12:00:00 | NQ | Futures | 17421.49 | 17528.72 | 17384.1 | 17526.4 | 45631.0 |
| 2022-02-02 13:00:00 | NQ | Futures | 17526.4 | 17530.17 | 17431.92 | 17458.88 | 39251.0 |
| 2022-02-02 14:00:00 | NQ | Futures | 17458.88 | 17536.26 | 17401.49 | 17499.16 | 47556.0 |
| 2022-02-02 15:00:00 | NQ | Futures | 17497.42 | 17566.4 | 17470.47 | 17520.9 | 65983.0 |
| 2022-02-02 16:00:00 | NQ | Futures | 17519.74 | 17529.01 | 17186.16 | 17230.5 | 43716.0 |
| 2022-02-02 18:00:00 | NQ | Futures | 17218.04 | 17233.69 | 17105.01 | 17117.76 | 14205.0 |
| 2022-02-02 19:00:00 | NQ | Futures | 17118.34 | 17162.1 | 17116.31 | 17127.32 | 8667.0 |
| 2022-02-02 20:00:00 | NQ | Futures | 17128.19 | 17145.0 | 17108.49 | 17120.95 | 7513.0 |
| 2022-02-02 21:00:00 | NQ | Futures | 17120.08 | 17145.58 | 17100.95 | 17136.6 | 4891.0 |
| 2022-02-02 22:00:00 | NQ | Futures | 17137.18 | 17156.02 | 17116.89 | 17142.97 | 4867.0 |
| 2022-02-02 23:00:00 | NQ | Futures | 17142.39 | 17151.09 | 17136.02 | 17140.37 | 2354.0 |
| 2022-02-02 00:00:00 | YM | Futures | 39637.6 | 39694.9 | 39633.1 | 39657.8 | 1322.0 |
| 2022-02-02 01:00:00 | YM | Futures | 39660.0 | 39709.5 | 39625.2 | 39647.7 | 1746.0 |
| 2022-02-02 02:00:00 | YM | Futures | 39647.7 | 39672.4 | 39616.2 | 39635.3 | 2409.0 |
| 2022-02-02 03:00:00 | YM | Futures | 39635.3 | 39637.6 | 39558.9 | 39582.5 | 5643.0 |
> showing 50 of 2,055 rows — these rows as CSV