PREVIEW / futures_1hour / 2024-03-21
file: by_date/futures_1hour/2024/2024-03-21.parquet size: 67 KB rows: 2,077
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-03-21 00:00:00 | ES | Futures | 5631.17 | 5633.55 | 5630.64 | 5633.55 | 4632.0 |
| 2024-03-21 01:00:00 | ES | Futures | 5633.55 | 5634.88 | 5632.23 | 5633.82 | 4622.0 |
| 2024-03-21 02:00:00 | ES | Futures | 5634.08 | 5635.41 | 5632.76 | 5635.15 | 7019.0 |
| 2024-03-21 03:00:00 | ES | Futures | 5635.15 | 5640.98 | 5634.08 | 5640.72 | 12673.0 |
| 2024-03-21 04:00:00 | ES | Futures | 5640.98 | 5640.98 | 5632.76 | 5633.55 | 23120.0 |
| 2024-03-21 05:00:00 | ES | Futures | 5633.82 | 5634.08 | 5626.92 | 5629.57 | 19676.0 |
| 2024-03-21 06:00:00 | ES | Futures | 5629.57 | 5630.11 | 5625.86 | 5627.98 | 14952.0 |
| 2024-03-21 07:00:00 | ES | Futures | 5628.25 | 5635.41 | 5627.98 | 5633.55 | 20850.0 |
| 2024-03-21 08:00:00 | ES | Futures | 5633.02 | 5639.39 | 5633.02 | 5637.53 | 30684.0 |
| 2024-03-21 09:00:00 | ES | Futures | 5637.27 | 5647.08 | 5633.29 | 5640.72 | 191752.0 |
| 2024-03-21 10:00:00 | ES | Futures | 5640.45 | 5646.82 | 5637.8 | 5642.57 | 170611.0 |
| 2024-03-21 11:00:00 | ES | Futures | 5642.57 | 5646.29 | 5636.47 | 5644.17 | 115050.0 |
| 2024-03-21 12:00:00 | ES | Futures | 5644.17 | 5648.41 | 5640.72 | 5644.43 | 101907.0 |
| 2024-03-21 13:00:00 | ES | Futures | 5644.43 | 5644.43 | 5633.29 | 5634.08 | 93028.0 |
| 2024-03-21 14:00:00 | ES | Futures | 5634.08 | 5637.53 | 5625.86 | 5628.78 | 129892.0 |
| 2024-03-21 15:00:00 | ES | Futures | 5628.78 | 5638.06 | 5624.27 | 5627.19 | 217593.0 |
| 2024-03-21 16:00:00 | ES | Futures | 5626.92 | 5633.82 | 5625.6 | 5632.23 | 49032.0 |
| 2024-03-21 18:00:00 | ES | Futures | 5631.43 | 5634.35 | 5629.04 | 5633.82 | 4149.0 |
| 2024-03-21 19:00:00 | ES | Futures | 5633.82 | 5635.41 | 5632.23 | 5634.88 | 3351.0 |
| 2024-03-21 20:00:00 | ES | Futures | 5634.62 | 5635.94 | 5632.23 | 5634.35 | 5657.0 |
| 2024-03-21 21:00:00 | ES | Futures | 5634.35 | 5635.68 | 5627.98 | 5628.25 | 7336.0 |
| 2024-03-21 22:00:00 | ES | Futures | 5628.51 | 5630.11 | 5623.21 | 5624.27 | 7885.0 |
| 2024-03-21 23:00:00 | ES | Futures | 5624.0 | 5627.72 | 5623.74 | 5627.45 | 5676.0 |
| 2024-03-21 00:00:00 | NQ | Futures | 19894.27 | 19909.25 | 19890.26 | 19903.9 | 3153.0 |
| 2024-03-21 01:00:00 | NQ | Futures | 19903.9 | 19918.08 | 19898.82 | 19913.53 | 3146.0 |
| 2024-03-21 02:00:00 | NQ | Futures | 19913.8 | 19937.61 | 19909.25 | 19937.61 | 5116.0 |
| 2024-03-21 03:00:00 | NQ | Futures | 19936.81 | 19974.26 | 19932.53 | 19966.5 | 9344.0 |
| 2024-03-21 04:00:00 | NQ | Futures | 19966.77 | 19967.57 | 19910.86 | 19922.36 | 13942.0 |
| 2024-03-21 05:00:00 | NQ | Futures | 19922.9 | 19927.98 | 19890.8 | 19909.52 | 10133.0 |
| 2024-03-21 06:00:00 | NQ | Futures | 19909.79 | 19913.8 | 19895.88 | 19908.72 | 6512.0 |
| 2024-03-21 07:00:00 | NQ | Futures | 19908.45 | 19953.39 | 19908.18 | 19944.57 | 13114.0 |
| 2024-03-21 08:00:00 | NQ | Futures | 19944.57 | 19982.28 | 19942.96 | 19964.36 | 17817.0 |
| 2024-03-21 09:00:00 | NQ | Futures | 19964.9 | 20018.93 | 19930.12 | 19953.66 | 106533.0 |
| 2024-03-21 10:00:00 | NQ | Futures | 19953.13 | 19995.93 | 19923.97 | 19948.85 | 96626.0 |
| 2024-03-21 11:00:00 | NQ | Futures | 19949.11 | 20010.37 | 19921.02 | 19989.77 | 62962.0 |
| 2024-03-21 12:00:00 | NQ | Futures | 19990.04 | 20017.33 | 19982.55 | 19997.8 | 43077.0 |
| 2024-03-21 13:00:00 | NQ | Futures | 19997.53 | 19998.33 | 19915.41 | 19922.36 | 45264.0 |
| 2024-03-21 14:00:00 | NQ | Futures | 19922.1 | 19927.45 | 19851.47 | 19873.94 | 63008.0 |
| 2024-03-21 15:00:00 | NQ | Futures | 19873.94 | 19904.17 | 19851.74 | 19858.16 | 61117.0 |
| 2024-03-21 16:00:00 | NQ | Futures | 19858.16 | 19887.85 | 19856.02 | 19880.63 | 12462.0 |
| 2024-03-21 18:00:00 | NQ | Futures | 19881.43 | 19892.13 | 19869.66 | 19889.46 | 2752.0 |
| 2024-03-21 19:00:00 | NQ | Futures | 19889.46 | 19895.08 | 19880.9 | 19890.26 | 1970.0 |
| 2024-03-21 20:00:00 | NQ | Futures | 19890.26 | 19896.95 | 19878.76 | 19888.92 | 2769.0 |
| 2024-03-21 21:00:00 | NQ | Futures | 19888.66 | 19897.22 | 19858.16 | 19859.77 | 4176.0 |
| 2024-03-21 22:00:00 | NQ | Futures | 19860.3 | 19868.86 | 19829.54 | 19834.62 | 5563.0 |
| 2024-03-21 23:00:00 | NQ | Futures | 19834.35 | 19852.54 | 19832.21 | 19852.28 | 3540.0 |
| 2024-03-21 00:00:00 | YM | Futures | 42524.4 | 42537.1 | 42520.1 | 42536.0 | 687.0 |
| 2024-03-21 01:00:00 | YM | Futures | 42537.1 | 42546.7 | 42531.8 | 42544.5 | 611.0 |
| 2024-03-21 02:00:00 | YM | Futures | 42545.6 | 42552.0 | 42526.5 | 42536.0 | 1229.0 |
| 2024-03-21 03:00:00 | YM | Futures | 42537.1 | 42578.5 | 42529.7 | 42576.4 | 2232.0 |
> showing 50 of 2,077 rows — these rows as CSV