PREVIEW / futures_1hour / 2023-12-08
file: by_date/futures_1hour/2023/2023-12-08.parquet size: 56 KB rows: 1,630
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-12-08 00:00:00 | ES | Futures | 4985.27 | 4986.08 | 4982.82 | 4983.91 | 4683.0 |
| 2023-12-08 01:00:00 | ES | Futures | 4983.91 | 4984.18 | 4981.74 | 4982.55 | 3299.0 |
| 2023-12-08 02:00:00 | ES | Futures | 4982.55 | 4982.82 | 4978.21 | 4978.48 | 6238.0 |
| 2023-12-08 03:00:00 | ES | Futures | 4978.48 | 4982.55 | 4975.76 | 4982.01 | 13884.0 |
| 2023-12-08 04:00:00 | ES | Futures | 4982.01 | 4987.71 | 4981.74 | 4986.63 | 10558.0 |
| 2023-12-08 05:00:00 | ES | Futures | 4986.35 | 4989.61 | 4985.0 | 4987.98 | 9572.0 |
| 2023-12-08 06:00:00 | ES | Futures | 4987.98 | 4988.53 | 4978.48 | 4979.84 | 11009.0 |
| 2023-12-08 07:00:00 | ES | Futures | 4979.84 | 4980.92 | 4974.41 | 4978.21 | 20191.0 |
| 2023-12-08 08:00:00 | ES | Futures | 4978.21 | 4987.98 | 4955.13 | 4976.31 | 105781.0 |
| 2023-12-08 09:00:00 | ES | Futures | 4976.31 | 4989.61 | 4970.06 | 4984.18 | 201966.0 |
| 2023-12-08 10:00:00 | ES | Futures | 4983.37 | 5008.08 | 4983.37 | 5003.73 | 275448.0 |
| 2023-12-08 11:00:00 | ES | Futures | 5003.73 | 5004.55 | 4979.84 | 4984.18 | 193295.0 |
| 2023-12-08 12:00:00 | ES | Futures | 4984.18 | 4993.96 | 4976.31 | 4992.87 | 103092.0 |
| 2023-12-08 13:00:00 | ES | Futures | 4992.87 | 4999.12 | 4991.24 | 4997.76 | 83700.0 |
| 2023-12-08 14:00:00 | ES | Futures | 4998.03 | 5009.17 | 4997.22 | 5007.81 | 91266.0 |
| 2023-12-08 15:00:00 | ES | Futures | 5007.81 | 5011.61 | 5002.38 | 5005.09 | 179506.0 |
| 2023-12-08 16:00:00 | ES | Futures | 5004.82 | 5005.91 | 5002.11 | 5004.55 | 78868.0 |
| 2023-12-08 00:00:00 | NQ | Futures | 17607.9 | 17609.55 | 17595.26 | 17597.73 | 2113.0 |
| 2023-12-08 01:00:00 | NQ | Futures | 17597.73 | 17599.93 | 17589.22 | 17591.42 | 1582.0 |
| 2023-12-08 02:00:00 | NQ | Futures | 17592.24 | 17592.52 | 17570.82 | 17575.49 | 3656.0 |
| 2023-12-08 03:00:00 | NQ | Futures | 17575.49 | 17589.22 | 17565.6 | 17587.3 | 6243.0 |
| 2023-12-08 04:00:00 | NQ | Futures | 17587.02 | 17610.37 | 17585.37 | 17608.45 | 5536.0 |
| 2023-12-08 05:00:00 | NQ | Futures | 17608.45 | 17621.08 | 17599.38 | 17612.02 | 4614.0 |
| 2023-12-08 06:00:00 | NQ | Futures | 17612.84 | 17616.41 | 17569.17 | 17576.31 | 5636.0 |
| 2023-12-08 07:00:00 | NQ | Futures | 17576.59 | 17581.25 | 17546.37 | 17565.05 | 11407.0 |
| 2023-12-08 08:00:00 | NQ | Futures | 17566.15 | 17577.41 | 17455.73 | 17540.33 | 47759.0 |
| 2023-12-08 09:00:00 | NQ | Futures | 17540.6 | 17607.07 | 17510.94 | 17568.9 | 82417.0 |
| 2023-12-08 10:00:00 | NQ | Futures | 17576.04 | 17703.21 | 17576.04 | 17694.69 | 121148.0 |
| 2023-12-08 11:00:00 | NQ | Futures | 17694.69 | 17701.83 | 17589.49 | 17607.9 | 68709.0 |
| 2023-12-08 12:00:00 | NQ | Futures | 17608.45 | 17655.69 | 17566.97 | 17652.94 | 40775.0 |
| 2023-12-08 13:00:00 | NQ | Futures | 17652.39 | 17674.64 | 17643.88 | 17673.54 | 29166.0 |
| 2023-12-08 14:00:00 | NQ | Futures | 17673.54 | 17708.97 | 17667.5 | 17703.21 | 27571.0 |
| 2023-12-08 15:00:00 | NQ | Futures | 17703.21 | 17707.6 | 17674.92 | 17687.0 | 42070.0 |
| 2023-12-08 16:00:00 | NQ | Futures | 17687.0 | 17687.55 | 17673.54 | 17681.78 | 10294.0 |
| 2023-12-08 00:00:00 | YM | Futures | 39253.3 | 39256.5 | 39235.9 | 39242.4 | 498.0 |
| 2023-12-08 01:00:00 | YM | Futures | 39242.4 | 39247.8 | 39237.0 | 39242.4 | 460.0 |
| 2023-12-08 02:00:00 | YM | Futures | 39243.5 | 39244.6 | 39205.5 | 39205.5 | 952.0 |
| 2023-12-08 03:00:00 | YM | Futures | 39205.5 | 39233.7 | 39186.0 | 39231.6 | 1876.0 |
| 2023-12-08 04:00:00 | YM | Futures | 39231.6 | 39266.3 | 39226.1 | 39243.5 | 1536.0 |
| 2023-12-08 05:00:00 | YM | Futures | 39244.6 | 39272.8 | 39241.3 | 39258.7 | 1121.0 |
| 2023-12-08 06:00:00 | YM | Futures | 39258.7 | 39263.0 | 39188.2 | 39196.8 | 1715.0 |
| 2023-12-08 07:00:00 | YM | Futures | 39197.9 | 39207.7 | 39167.6 | 39175.1 | 3190.0 |
| 2023-12-08 08:00:00 | YM | Futures | 39175.1 | 39226.1 | 39059.1 | 39174.1 | 9475.0 |
| 2023-12-08 09:00:00 | YM | Futures | 39175.1 | 39312.9 | 39139.3 | 39253.3 | 17882.0 |
| 2023-12-08 10:00:00 | YM | Futures | 39254.3 | 39381.3 | 39254.3 | 39357.4 | 18570.0 |
| 2023-12-08 11:00:00 | YM | Futures | 39357.4 | 39365.0 | 39206.6 | 39231.6 | 13763.0 |
| 2023-12-08 12:00:00 | YM | Futures | 39231.6 | 39293.4 | 39181.7 | 39285.8 | 6532.0 |
| 2023-12-08 13:00:00 | YM | Futures | 39284.7 | 39339.0 | 39272.8 | 39310.7 | 5886.0 |
| 2023-12-08 14:00:00 | YM | Futures | 39311.8 | 39380.2 | 39306.4 | 39374.8 | 5327.0 |
| 2023-12-08 15:00:00 | YM | Futures | 39376.9 | 39416.0 | 39348.7 | 39353.1 | 11795.0 |
> showing 50 of 1,630 rows — these rows as CSV