PREVIEW / futures_1hour / 2024-03-22
file: by_date/futures_1hour/2024/2024-03-22.parquet size: 55 KB rows: 1,666
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-22 00:00:00 | ES | Futures | 5627.45 | 5631.17 | 5627.45 | 5630.37 | 4040.0 |
| 2024-03-22 01:00:00 | ES | Futures | 5630.37 | 5632.23 | 5629.57 | 5630.37 | 4174.0 |
| 2024-03-22 02:00:00 | ES | Futures | 5630.64 | 5632.49 | 5628.78 | 5629.57 | 4514.0 |
| 2024-03-22 03:00:00 | ES | Futures | 5629.31 | 5629.84 | 5621.88 | 5626.66 | 10637.0 |
| 2024-03-22 04:00:00 | ES | Futures | 5626.66 | 5634.35 | 5625.06 | 5633.29 | 13943.0 |
| 2024-03-22 05:00:00 | ES | Futures | 5633.29 | 5635.94 | 5631.17 | 5633.55 | 11952.0 |
| 2024-03-22 06:00:00 | ES | Futures | 5633.82 | 5636.74 | 5632.23 | 5633.02 | 10711.0 |
| 2024-03-22 07:00:00 | ES | Futures | 5633.29 | 5635.94 | 5617.64 | 5618.96 | 24659.0 |
| 2024-03-22 08:00:00 | ES | Futures | 5619.23 | 5623.21 | 5616.04 | 5622.68 | 33818.0 |
| 2024-03-22 09:00:00 | ES | Futures | 5622.68 | 5629.31 | 5617.9 | 5621.88 | 146060.0 |
| 2024-03-22 10:00:00 | ES | Futures | 5621.62 | 5627.72 | 5613.39 | 5613.92 | 132918.0 |
| 2024-03-22 11:00:00 | ES | Futures | 5613.92 | 5622.41 | 5613.39 | 5620.55 | 92511.0 |
| 2024-03-22 12:00:00 | ES | Futures | 5620.55 | 5623.21 | 5612.6 | 5622.41 | 83665.0 |
| 2024-03-22 13:00:00 | ES | Futures | 5622.41 | 5630.64 | 5621.35 | 5629.84 | 80037.0 |
| 2024-03-22 14:00:00 | ES | Futures | 5630.11 | 5630.64 | 5623.74 | 5626.13 | 84053.0 |
| 2024-03-22 15:00:00 | ES | Futures | 5625.86 | 5627.45 | 5614.98 | 5615.78 | 212953.0 |
| 2024-03-22 16:00:00 | ES | Futures | 5615.51 | 5617.64 | 5611.27 | 5613.39 | 59209.0 |
| 2024-03-22 00:00:00 | NQ | Futures | 19852.01 | 19881.17 | 19852.01 | 19876.08 | 4369.0 |
| 2024-03-22 01:00:00 | NQ | Futures | 19876.35 | 19886.78 | 19872.07 | 19878.49 | 3211.0 |
| 2024-03-22 02:00:00 | NQ | Futures | 19878.49 | 19889.19 | 19861.64 | 19868.06 | 3362.0 |
| 2024-03-22 03:00:00 | NQ | Futures | 19867.79 | 19873.41 | 19835.42 | 19862.44 | 8260.0 |
| 2024-03-22 04:00:00 | NQ | Futures | 19862.17 | 19900.16 | 19856.82 | 19895.34 | 9180.0 |
| 2024-03-22 05:00:00 | NQ | Futures | 19895.08 | 19909.79 | 19875.28 | 19891.87 | 7258.0 |
| 2024-03-22 06:00:00 | NQ | Futures | 19892.13 | 19895.61 | 19869.13 | 19874.48 | 5885.0 |
| 2024-03-22 07:00:00 | NQ | Futures | 19875.55 | 19884.38 | 19800.65 | 19806.8 | 15285.0 |
| 2024-03-22 08:00:00 | NQ | Futures | 19806.8 | 19831.14 | 19786.74 | 19826.6 | 22225.0 |
| 2024-03-22 09:00:00 | NQ | Futures | 19826.86 | 19845.32 | 19795.3 | 19828.2 | 69108.0 |
| 2024-03-22 10:00:00 | NQ | Futures | 19827.67 | 19864.85 | 19797.97 | 19808.94 | 75156.0 |
| 2024-03-22 11:00:00 | NQ | Futures | 19808.94 | 19861.64 | 19805.2 | 19858.43 | 53572.0 |
| 2024-03-22 12:00:00 | NQ | Futures | 19858.43 | 19883.31 | 19825.79 | 19881.17 | 43599.0 |
| 2024-03-22 13:00:00 | NQ | Futures | 19880.9 | 19930.12 | 19877.69 | 19926.38 | 43274.0 |
| 2024-03-22 14:00:00 | NQ | Futures | 19926.38 | 19928.52 | 19881.43 | 19897.22 | 41609.0 |
| 2024-03-22 15:00:00 | NQ | Futures | 19896.95 | 19908.72 | 19845.59 | 19872.34 | 65472.0 |
| 2024-03-22 16:00:00 | NQ | Futures | 19872.61 | 19877.69 | 19854.15 | 19863.51 | 13648.0 |
| 2024-03-22 00:00:00 | YM | Futures | 42701.7 | 42714.4 | 42699.5 | 42709.1 | 581.0 |
| 2024-03-22 01:00:00 | YM | Futures | 42710.2 | 42722.9 | 42707.0 | 42712.3 | 528.0 |
| 2024-03-22 02:00:00 | YM | Futures | 42712.3 | 42726.1 | 42702.7 | 42703.8 | 646.0 |
| 2024-03-22 03:00:00 | YM | Futures | 42703.8 | 42705.9 | 42661.3 | 42676.2 | 1945.0 |
| 2024-03-22 04:00:00 | YM | Futures | 42675.1 | 42717.6 | 42671.9 | 42709.1 | 2134.0 |
| 2024-03-22 05:00:00 | YM | Futures | 42709.1 | 42731.4 | 42701.7 | 42721.8 | 1860.0 |
| 2024-03-22 06:00:00 | YM | Futures | 42722.9 | 42749.4 | 42716.5 | 42727.1 | 1956.0 |
| 2024-03-22 07:00:00 | YM | Futures | 42728.2 | 42751.6 | 42640.1 | 42651.8 | 3525.0 |
| 2024-03-22 08:00:00 | YM | Futures | 42652.8 | 42692.1 | 42628.4 | 42667.7 | 4621.0 |
| 2024-03-22 09:00:00 | YM | Futures | 42667.7 | 42718.7 | 42601.9 | 42615.7 | 16823.0 |
| 2024-03-22 10:00:00 | YM | Futures | 42615.7 | 42632.7 | 42470.2 | 42474.5 | 17241.0 |
| 2024-03-22 11:00:00 | YM | Futures | 42474.5 | 42521.2 | 42468.1 | 42480.8 | 12505.0 |
| 2024-03-22 12:00:00 | YM | Futures | 42481.9 | 42489.3 | 42407.6 | 42471.3 | 11397.0 |
| 2024-03-22 13:00:00 | YM | Futures | 42471.3 | 42490.4 | 42444.7 | 42484.0 | 7290.0 |
| 2024-03-22 14:00:00 | YM | Futures | 42485.1 | 42494.6 | 42434.1 | 42454.3 | 8967.0 |
| 2024-03-22 15:00:00 | YM | Futures | 42453.2 | 42460.7 | 42314.1 | 42318.4 | 19718.0 |
> showing 50 of 1,666 rows — these rows as CSV