PREVIEW / futures_1hour / 2022-02-23
file: by_date/futures_1hour/2022/2022-02-23.parquet size: 71 KB rows: 2,107
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-23 00:00:00 | ES | Futures | 4891.91 | 4895.59 | 4886.82 | 4888.23 | 7076.0 |
| 2022-02-23 01:00:00 | ES | Futures | 4887.95 | 4894.17 | 4882.86 | 4883.14 | 7530.0 |
| 2022-02-23 02:00:00 | ES | Futures | 4883.43 | 4894.46 | 4877.77 | 4890.78 | 10560.0 |
| 2022-02-23 03:00:00 | ES | Futures | 4890.78 | 4907.18 | 4884.84 | 4905.77 | 36373.0 |
| 2022-02-23 04:00:00 | ES | Futures | 4905.77 | 4915.67 | 4902.09 | 4903.79 | 23763.0 |
| 2022-02-23 05:00:00 | ES | Futures | 4903.79 | 4906.9 | 4892.19 | 4899.55 | 15798.0 |
| 2022-02-23 06:00:00 | ES | Futures | 4899.83 | 4901.24 | 4881.73 | 4883.43 | 19061.0 |
| 2022-02-23 07:00:00 | ES | Futures | 4883.43 | 4903.79 | 4882.01 | 4902.09 | 20692.0 |
| 2022-02-23 08:00:00 | ES | Futures | 4902.37 | 4906.62 | 4892.76 | 4902.37 | 22924.0 |
| 2022-02-23 09:00:00 | ES | Futures | 4902.66 | 4905.49 | 4879.18 | 4880.6 | 175782.0 |
| 2022-02-23 10:00:00 | ES | Futures | 4880.6 | 4880.88 | 4841.29 | 4846.38 | 255773.0 |
| 2022-02-23 11:00:00 | ES | Futures | 4846.38 | 4857.69 | 4828.28 | 4854.02 | 194669.0 |
| 2022-02-23 12:00:00 | ES | Futures | 4854.02 | 4870.42 | 4840.72 | 4844.97 | 139455.0 |
| 2022-02-23 13:00:00 | ES | Futures | 4844.68 | 4844.97 | 4811.03 | 4824.04 | 190464.0 |
| 2022-02-23 14:00:00 | ES | Futures | 4823.76 | 4829.13 | 4788.12 | 4794.63 | 215870.0 |
| 2022-02-23 15:00:00 | ES | Futures | 4794.63 | 4798.3 | 4769.46 | 4777.09 | 373881.0 |
| 2022-02-23 16:00:00 | ES | Futures | 4777.09 | 4781.9 | 4765.22 | 4768.04 | 75950.0 |
| 2022-02-23 18:00:00 | ES | Futures | 4768.61 | 4778.79 | 4760.97 | 4771.72 | 22523.0 |
| 2022-02-23 19:00:00 | ES | Futures | 4771.44 | 4777.09 | 4740.61 | 4740.61 | 36791.0 |
| 2022-02-23 20:00:00 | ES | Futures | 4740.89 | 4761.82 | 4732.41 | 4754.75 | 38374.0 |
| 2022-02-23 21:00:00 | ES | Futures | 4754.47 | 4758.71 | 4728.45 | 4730.71 | 42718.0 |
| 2022-02-23 22:00:00 | ES | Futures | 4730.43 | 4733.82 | 4656.62 | 4667.37 | 106797.0 |
| 2022-02-23 23:00:00 | ES | Futures | 4667.65 | 4688.86 | 4659.16 | 4685.47 | 46276.0 |
| 2022-02-23 00:00:00 | NQ | Futures | 16198.46 | 16215.85 | 16175.27 | 16180.49 | 3716.0 |
| 2022-02-23 01:00:00 | NQ | Futures | 16179.62 | 16203.1 | 16156.44 | 16159.34 | 4917.0 |
| 2022-02-23 02:00:00 | NQ | Futures | 16159.05 | 16205.13 | 16143.11 | 16191.79 | 6763.0 |
| 2022-02-23 03:00:00 | NQ | Futures | 16191.5 | 16261.35 | 16163.39 | 16247.44 | 16076.0 |
| 2022-02-23 04:00:00 | NQ | Futures | 16248.31 | 16309.46 | 16248.31 | 16262.22 | 12282.0 |
| 2022-02-23 05:00:00 | NQ | Futures | 16263.09 | 16276.71 | 16210.05 | 16234.98 | 10845.0 |
| 2022-02-23 06:00:00 | NQ | Futures | 16233.53 | 16241.06 | 16173.54 | 16182.81 | 11165.0 |
| 2022-02-23 07:00:00 | NQ | Futures | 16182.81 | 16268.6 | 16175.27 | 16257.0 | 11569.0 |
| 2022-02-23 08:00:00 | NQ | Futures | 16257.29 | 16268.02 | 16214.11 | 16253.24 | 14013.0 |
| 2022-02-23 09:00:00 | NQ | Futures | 16253.82 | 16265.7 | 16100.5 | 16117.89 | 84584.0 |
| 2022-02-23 10:00:00 | NQ | Futures | 16118.47 | 16118.76 | 15942.26 | 15973.85 | 105069.0 |
| 2022-02-23 11:00:00 | NQ | Futures | 15973.27 | 16033.26 | 15898.21 | 16010.66 | 80736.0 |
| 2022-02-23 12:00:00 | NQ | Futures | 16010.66 | 16072.1 | 15941.68 | 15957.04 | 51819.0 |
| 2022-02-23 13:00:00 | NQ | Futures | 15956.17 | 15957.33 | 15825.76 | 15862.27 | 65643.0 |
| 2022-02-23 14:00:00 | NQ | Futures | 15861.69 | 15889.81 | 15729.25 | 15753.01 | 70745.0 |
| 2022-02-23 15:00:00 | NQ | Futures | 15753.59 | 15763.73 | 15643.75 | 15657.95 | 101207.0 |
| 2022-02-23 16:00:00 | NQ | Futures | 15657.95 | 15695.34 | 15616.8 | 15635.64 | 21391.0 |
| 2022-02-23 18:00:00 | NQ | Futures | 15631.87 | 15670.7 | 15600.86 | 15650.42 | 10915.0 |
| 2022-02-23 19:00:00 | NQ | Futures | 15649.84 | 15667.52 | 15511.59 | 15516.23 | 19902.0 |
| 2022-02-23 20:00:00 | NQ | Futures | 15517.97 | 15611.58 | 15484.93 | 15570.43 | 17965.0 |
| 2022-02-23 21:00:00 | NQ | Futures | 15571.3 | 15587.24 | 15441.75 | 15453.92 | 21783.0 |
| 2022-02-23 22:00:00 | NQ | Futures | 15452.47 | 15466.96 | 15191.06 | 15217.14 | 46570.0 |
| 2022-02-23 23:00:00 | NQ | Futures | 15217.14 | 15313.65 | 15202.07 | 15294.81 | 24822.0 |
| 2022-02-23 00:00:00 | YM | Futures | 37849.6 | 37877.7 | 37820.4 | 37831.6 | 1372.0 |
| 2022-02-23 01:00:00 | YM | Futures | 37828.2 | 37870.9 | 37788.9 | 37791.2 | 2138.0 |
| 2022-02-23 02:00:00 | YM | Futures | 37787.8 | 37864.2 | 37748.4 | 37835.0 | 3471.0 |
| 2022-02-23 03:00:00 | YM | Futures | 37837.2 | 37964.2 | 37800.1 | 37956.4 | 9473.0 |
> showing 50 of 2,107 rows — these rows as CSV