PREVIEW / futures_1hour / 2022-01-28
file: by_date/futures_1hour/2022/2022-01-28.parquet size: 58 KB rows: 1,662
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-01-28 00:00:00 | ES | Futures | 4901.53 | 4920.76 | 4898.13 | 4917.08 | 17271.0 |
| 2022-01-28 01:00:00 | ES | Futures | 4916.8 | 4922.17 | 4908.6 | 4913.69 | 10948.0 |
| 2022-01-28 02:00:00 | ES | Futures | 4913.12 | 4920.76 | 4904.64 | 4915.1 | 15576.0 |
| 2022-01-28 03:00:00 | ES | Futures | 4915.1 | 4915.38 | 4875.79 | 4894.74 | 42317.0 |
| 2022-01-28 04:00:00 | ES | Futures | 4894.74 | 4902.66 | 4882.3 | 4888.23 | 23703.0 |
| 2022-01-28 05:00:00 | ES | Futures | 4887.95 | 4888.52 | 4868.72 | 4876.36 | 26250.0 |
| 2022-01-28 06:00:00 | ES | Futures | 4876.64 | 4880.03 | 4855.43 | 4868.72 | 33580.0 |
| 2022-01-28 07:00:00 | ES | Futures | 4868.44 | 4873.25 | 4826.02 | 4838.74 | 57852.0 |
| 2022-01-28 08:00:00 | ES | Futures | 4839.03 | 4889.37 | 4834.22 | 4879.75 | 106541.0 |
| 2022-01-28 09:00:00 | ES | Futures | 4879.75 | 4905.49 | 4845.53 | 4852.6 | 241026.0 |
| 2022-01-28 10:00:00 | ES | Futures | 4852.32 | 4909.44 | 4844.97 | 4908.03 | 286490.0 |
| 2022-01-28 11:00:00 | ES | Futures | 4908.31 | 4949.89 | 4893.04 | 4948.19 | 249437.0 |
| 2022-01-28 12:00:00 | ES | Futures | 4948.47 | 4955.26 | 4917.08 | 4921.32 | 170706.0 |
| 2022-01-28 13:00:00 | ES | Futures | 4921.89 | 4948.19 | 4920.19 | 4940.27 | 140823.0 |
| 2022-01-28 14:00:00 | ES | Futures | 4939.99 | 4950.73 | 4889.93 | 4938.29 | 214327.0 |
| 2022-01-28 15:00:00 | ES | Futures | 4938.29 | 5005.6 | 4932.92 | 5004.47 | 357242.0 |
| 2022-01-28 16:00:00 | ES | Futures | 5004.47 | 5006.73 | 4991.46 | 4999.66 | 92551.0 |
| 2022-01-28 00:00:00 | NQ | Futures | 16341.34 | 16413.79 | 16328.3 | 16402.49 | 9054.0 |
| 2022-01-28 01:00:00 | NQ | Futures | 16401.62 | 16426.26 | 16375.83 | 16397.27 | 6372.0 |
| 2022-01-28 02:00:00 | NQ | Futures | 16394.96 | 16419.01 | 16345.69 | 16397.85 | 10255.0 |
| 2022-01-28 03:00:00 | NQ | Futures | 16398.43 | 16398.43 | 16242.51 | 16319.31 | 24077.0 |
| 2022-01-28 04:00:00 | NQ | Futures | 16319.6 | 16361.92 | 16272.65 | 16298.45 | 12984.0 |
| 2022-01-28 05:00:00 | NQ | Futures | 16299.03 | 16299.32 | 16225.12 | 16265.7 | 14159.0 |
| 2022-01-28 06:00:00 | NQ | Futures | 16266.28 | 16279.61 | 16169.19 | 16218.17 | 16636.0 |
| 2022-01-28 07:00:00 | NQ | Futures | 16217.01 | 16251.21 | 16033.84 | 16086.59 | 33629.0 |
| 2022-01-28 08:00:00 | NQ | Futures | 16087.46 | 16286.56 | 16067.17 | 16243.67 | 48266.0 |
| 2022-01-28 09:00:00 | NQ | Futures | 16243.38 | 16348.3 | 16075.58 | 16113.54 | 100178.0 |
| 2022-01-28 10:00:00 | NQ | Futures | 16113.83 | 16400.17 | 16067.75 | 16397.27 | 114929.0 |
| 2022-01-28 11:00:00 | NQ | Futures | 16397.56 | 16574.35 | 16329.17 | 16564.5 | 98325.0 |
| 2022-01-28 12:00:00 | NQ | Futures | 16565.95 | 16591.45 | 16445.09 | 16456.69 | 67922.0 |
| 2022-01-28 13:00:00 | NQ | Futures | 16457.27 | 16540.44 | 16432.05 | 16496.97 | 54445.0 |
| 2022-01-28 14:00:00 | NQ | Futures | 16496.39 | 16543.05 | 16297.87 | 16475.82 | 79416.0 |
| 2022-01-28 15:00:00 | NQ | Futures | 16476.4 | 16737.81 | 16456.98 | 16732.3 | 94202.0 |
| 2022-01-28 16:00:00 | NQ | Futures | 16733.75 | 16742.16 | 16688.54 | 16728.54 | 22282.0 |
| 2022-01-28 00:00:00 | YM | Futures | 38357.5 | 38495.8 | 38339.6 | 38462.1 | 2709.0 |
| 2022-01-28 01:00:00 | YM | Futures | 38463.2 | 38498.0 | 38402.5 | 38425.0 | 2295.0 |
| 2022-01-28 02:00:00 | YM | Futures | 38423.9 | 38474.4 | 38364.3 | 38428.3 | 4557.0 |
| 2022-01-28 03:00:00 | YM | Futures | 38428.3 | 38428.3 | 38151.9 | 38269.9 | 15108.0 |
| 2022-01-28 04:00:00 | YM | Futures | 38271.0 | 38314.8 | 38185.6 | 38236.2 | 7220.0 |
| 2022-01-28 05:00:00 | YM | Futures | 38237.3 | 38239.5 | 38099.1 | 38154.1 | 7694.0 |
| 2022-01-28 06:00:00 | YM | Futures | 38155.3 | 38173.2 | 37995.7 | 38092.3 | 11143.0 |
| 2022-01-28 07:00:00 | YM | Futures | 38090.1 | 38120.4 | 37774.3 | 37875.4 | 16277.0 |
| 2022-01-28 08:00:00 | YM | Futures | 37877.7 | 38232.8 | 37848.5 | 38138.4 | 19169.0 |
| 2022-01-28 09:00:00 | YM | Futures | 38139.5 | 38322.7 | 37856.3 | 37895.7 | 35442.0 |
| 2022-01-28 10:00:00 | YM | Futures | 37895.7 | 38222.7 | 37846.2 | 38218.2 | 44625.0 |
| 2022-01-28 11:00:00 | YM | Futures | 38221.6 | 38507.0 | 38138.4 | 38486.8 | 29036.0 |
| 2022-01-28 12:00:00 | YM | Futures | 38490.2 | 38535.1 | 38254.2 | 38290.1 | 18449.0 |
| 2022-01-28 13:00:00 | YM | Futures | 38292.4 | 38530.6 | 38281.1 | 38469.9 | 16499.0 |
| 2022-01-28 14:00:00 | YM | Futures | 38467.7 | 38541.9 | 38113.7 | 38487.9 | 25290.0 |
| 2022-01-28 15:00:00 | YM | Futures | 38482.3 | 38892.5 | 38423.9 | 38882.4 | 28937.0 |
> showing 50 of 1,662 rows — these rows as CSV