PREVIEW / futures_1hour / 2023-02-02
file: by_date/futures_1hour/2023/2023-02-02.parquet size: 70 KB rows: 2,116
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 |
|---|---|---|---|---|---|---|---|
| 2023-02-02 00:00:00 | ES | Futures | 4638.39 | 4638.95 | 4633.92 | 4636.16 | 5561.0 |
| 2023-02-02 01:00:00 | ES | Futures | 4636.16 | 4638.11 | 4634.2 | 4637.83 | 6570.0 |
| 2023-02-02 02:00:00 | ES | Futures | 4637.55 | 4640.07 | 4633.36 | 4633.92 | 13078.0 |
| 2023-02-02 03:00:00 | ES | Futures | 4634.2 | 4653.77 | 4633.36 | 4650.98 | 38745.0 |
| 2023-02-02 04:00:00 | ES | Futures | 4650.98 | 4650.98 | 4638.11 | 4645.38 | 24263.0 |
| 2023-02-02 05:00:00 | ES | Futures | 4645.66 | 4647.9 | 4641.47 | 4643.43 | 14220.0 |
| 2023-02-02 06:00:00 | ES | Futures | 4643.43 | 4646.78 | 4637.0 | 4640.91 | 15592.0 |
| 2023-02-02 07:00:00 | ES | Futures | 4640.91 | 4648.18 | 4635.6 | 4647.62 | 31355.0 |
| 2023-02-02 08:00:00 | ES | Futures | 4647.34 | 4667.75 | 4643.43 | 4665.24 | 73020.0 |
| 2023-02-02 09:00:00 | ES | Futures | 4665.51 | 4670.83 | 4650.42 | 4653.21 | 266119.0 |
| 2023-02-02 10:00:00 | ES | Futures | 4652.93 | 4693.76 | 4645.1 | 4688.16 | 331503.0 |
| 2023-02-02 11:00:00 | ES | Futures | 4688.16 | 4692.64 | 4678.94 | 4679.22 | 179392.0 |
| 2023-02-02 12:00:00 | ES | Futures | 4679.5 | 4691.8 | 4676.42 | 4688.44 | 132549.0 |
| 2023-02-02 13:00:00 | ES | Futures | 4688.44 | 4704.38 | 4685.37 | 4703.82 | 143269.0 |
| 2023-02-02 14:00:00 | ES | Futures | 4704.1 | 4706.9 | 4654.89 | 4656.29 | 333978.0 |
| 2023-02-02 15:00:00 | ES | Futures | 4656.29 | 4690.12 | 4649.58 | 4689.28 | 388533.0 |
| 2023-02-02 16:00:00 | ES | Futures | 4689.56 | 4705.22 | 4646.22 | 4657.97 | 151735.0 |
| 2023-02-02 18:00:00 | ES | Futures | 4670.55 | 4672.51 | 4656.29 | 4658.25 | 16525.0 |
| 2023-02-02 19:00:00 | ES | Futures | 4658.52 | 4664.96 | 4657.97 | 4663.28 | 9307.0 |
| 2023-02-02 20:00:00 | ES | Futures | 4663.28 | 4667.47 | 4660.48 | 4664.4 | 12152.0 |
| 2023-02-02 21:00:00 | ES | Futures | 4664.4 | 4665.51 | 4657.13 | 4659.36 | 11215.0 |
| 2023-02-02 22:00:00 | ES | Futures | 4659.64 | 4663.28 | 4659.08 | 4663.0 | 6287.0 |
| 2023-02-02 23:00:00 | ES | Futures | 4663.0 | 4665.24 | 4661.88 | 4663.84 | 4673.0 |
| 2023-02-02 00:00:00 | NQ | Futures | 14270.22 | 14274.21 | 14252.3 | 14258.56 | 2974.0 |
| 2023-02-02 01:00:00 | NQ | Futures | 14259.41 | 14266.81 | 14253.44 | 14265.67 | 2848.0 |
| 2023-02-02 02:00:00 | NQ | Futures | 14265.67 | 14267.66 | 14233.81 | 14246.32 | 7227.0 |
| 2023-02-02 03:00:00 | NQ | Futures | 14247.18 | 14345.33 | 14244.9 | 14343.62 | 17556.0 |
| 2023-02-02 04:00:00 | NQ | Futures | 14343.05 | 14345.9 | 14297.82 | 14327.97 | 12024.0 |
| 2023-02-02 05:00:00 | NQ | Futures | 14327.69 | 14341.91 | 14301.23 | 14308.06 | 8853.0 |
| 2023-02-02 06:00:00 | NQ | Futures | 14308.91 | 14325.98 | 14288.43 | 14301.8 | 7436.0 |
| 2023-02-02 07:00:00 | NQ | Futures | 14302.65 | 14354.15 | 14284.73 | 14351.87 | 14202.0 |
| 2023-02-02 08:00:00 | NQ | Futures | 14351.59 | 14415.6 | 14325.41 | 14409.06 | 32704.0 |
| 2023-02-02 09:00:00 | NQ | Futures | 14409.06 | 14507.21 | 14391.42 | 14421.57 | 114439.0 |
| 2023-02-02 10:00:00 | NQ | Futures | 14420.72 | 14596.54 | 14392.27 | 14570.65 | 109286.0 |
| 2023-02-02 11:00:00 | NQ | Futures | 14570.93 | 14610.76 | 14544.47 | 14550.45 | 65505.0 |
| 2023-02-02 12:00:00 | NQ | Futures | 14550.45 | 14613.04 | 14533.38 | 14605.07 | 43924.0 |
| 2023-02-02 13:00:00 | NQ | Futures | 14605.64 | 14711.47 | 14600.8 | 14710.62 | 55102.0 |
| 2023-02-02 14:00:00 | NQ | Futures | 14710.9 | 14719.15 | 14468.8 | 14475.06 | 99296.0 |
| 2023-02-02 15:00:00 | NQ | Futures | 14474.49 | 14629.54 | 14442.06 | 14628.97 | 105343.0 |
| 2023-02-02 16:00:00 | NQ | Futures | 14628.4 | 14736.51 | 14359.27 | 14418.44 | 66521.0 |
| 2023-02-02 18:00:00 | NQ | Futures | 14507.21 | 14520.58 | 14400.8 | 14411.33 | 12807.0 |
| 2023-02-02 19:00:00 | NQ | Futures | 14411.62 | 14434.94 | 14407.63 | 14420.44 | 4171.0 |
| 2023-02-02 20:00:00 | NQ | Futures | 14421.0 | 14426.69 | 14401.94 | 14404.79 | 5116.0 |
| 2023-02-02 21:00:00 | NQ | Futures | 14405.36 | 14409.06 | 14359.84 | 14380.89 | 6176.0 |
| 2023-02-02 22:00:00 | NQ | Futures | 14381.17 | 14396.82 | 14379.18 | 14395.4 | 3473.0 |
| 2023-02-02 23:00:00 | NQ | Futures | 14395.4 | 14411.9 | 14389.14 | 14401.66 | 2391.0 |
| 2023-02-02 00:00:00 | YM | Futures | 38003.6 | 38010.3 | 37979.1 | 37990.3 | 755.0 |
| 2023-02-02 01:00:00 | YM | Futures | 37990.3 | 37996.9 | 37974.7 | 37991.4 | 1142.0 |
| 2023-02-02 02:00:00 | YM | Futures | 37991.4 | 38024.8 | 37968.0 | 37970.2 | 1904.0 |
| 2023-02-02 03:00:00 | YM | Futures | 37971.3 | 38099.4 | 37957.9 | 38059.3 | 4190.0 |
> showing 50 of 2,116 rows — these rows as CSV