PREVIEW / futures_1hour / 2023-02-08
file: by_date/futures_1hour/2023/2023-02-08.parquet size: 67 KB rows: 2,061
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-08 00:00:00 | ES | Futures | 4669.71 | 4674.18 | 4667.47 | 4673.06 | 5110.0 |
| 2023-02-08 01:00:00 | ES | Futures | 4673.06 | 4673.62 | 4665.79 | 4666.35 | 5712.0 |
| 2023-02-08 02:00:00 | ES | Futures | 4666.63 | 4668.87 | 4659.92 | 4665.51 | 10926.0 |
| 2023-02-08 03:00:00 | ES | Futures | 4665.51 | 4669.43 | 4649.86 | 4658.52 | 24871.0 |
| 2023-02-08 04:00:00 | ES | Futures | 4658.52 | 4663.84 | 4654.05 | 4659.36 | 14225.0 |
| 2023-02-08 05:00:00 | ES | Futures | 4659.36 | 4659.92 | 4652.37 | 4658.8 | 15650.0 |
| 2023-02-08 06:00:00 | ES | Futures | 4658.8 | 4659.92 | 4649.86 | 4653.77 | 13988.0 |
| 2023-02-08 07:00:00 | ES | Futures | 4654.05 | 4660.2 | 4647.06 | 4650.14 | 25059.0 |
| 2023-02-08 08:00:00 | ES | Futures | 4650.14 | 4650.7 | 4645.1 | 4647.9 | 33976.0 |
| 2023-02-08 09:00:00 | ES | Futures | 4648.18 | 4659.92 | 4641.19 | 4656.29 | 214450.0 |
| 2023-02-08 10:00:00 | ES | Futures | 4656.01 | 4661.6 | 4633.08 | 4637.83 | 270555.0 |
| 2023-02-08 11:00:00 | ES | Futures | 4637.83 | 4638.95 | 4611.83 | 4626.09 | 278999.0 |
| 2023-02-08 12:00:00 | ES | Futures | 4626.09 | 4632.52 | 4616.3 | 4631.4 | 145824.0 |
| 2023-02-08 13:00:00 | ES | Futures | 4631.4 | 4639.51 | 4620.5 | 4625.81 | 153423.0 |
| 2023-02-08 14:00:00 | ES | Futures | 4625.81 | 4634.48 | 4615.47 | 4625.25 | 131632.0 |
| 2023-02-08 15:00:00 | ES | Futures | 4625.25 | 4626.37 | 4609.31 | 4618.26 | 299441.0 |
| 2023-02-08 16:00:00 | ES | Futures | 4618.26 | 4623.01 | 4615.19 | 4621.9 | 51474.0 |
| 2023-02-08 18:00:00 | ES | Futures | 4621.62 | 4624.97 | 4616.86 | 4623.01 | 6347.0 |
| 2023-02-08 19:00:00 | ES | Futures | 4623.29 | 4626.93 | 4622.74 | 4626.37 | 4998.0 |
| 2023-02-08 20:00:00 | ES | Futures | 4626.37 | 4629.45 | 4624.69 | 4627.77 | 6481.0 |
| 2023-02-08 21:00:00 | ES | Futures | 4627.77 | 4631.12 | 4627.21 | 4629.45 | 3617.0 |
| 2023-02-08 22:00:00 | ES | Futures | 4630.0 | 4631.96 | 4627.21 | 4629.45 | 5691.0 |
| 2023-02-08 23:00:00 | ES | Futures | 4629.45 | 4630.0 | 4628.05 | 4629.17 | 2968.0 |
| 2023-02-08 00:00:00 | NQ | Futures | 14551.87 | 14575.77 | 14539.07 | 14569.79 | 3729.0 |
| 2023-02-08 01:00:00 | NQ | Futures | 14570.08 | 14573.49 | 14535.37 | 14539.35 | 3918.0 |
| 2023-02-08 02:00:00 | NQ | Futures | 14539.35 | 14559.27 | 14514.32 | 14542.48 | 7339.0 |
| 2023-02-08 03:00:00 | NQ | Futures | 14543.05 | 14553.29 | 14471.64 | 14508.63 | 13915.0 |
| 2023-02-08 04:00:00 | NQ | Futures | 14508.63 | 14532.81 | 14489.0 | 14514.89 | 8111.0 |
| 2023-02-08 05:00:00 | NQ | Futures | 14514.03 | 14517.73 | 14480.18 | 14517.73 | 6904.0 |
| 2023-02-08 06:00:00 | NQ | Futures | 14517.16 | 14524.56 | 14496.39 | 14509.77 | 7265.0 |
| 2023-02-08 07:00:00 | NQ | Futures | 14510.62 | 14546.47 | 14481.32 | 14497.25 | 14149.0 |
| 2023-02-08 08:00:00 | NQ | Futures | 14498.1 | 14502.37 | 14464.53 | 14475.91 | 17596.0 |
| 2023-02-08 09:00:00 | NQ | Futures | 14475.34 | 14511.47 | 14409.62 | 14450.88 | 76932.0 |
| 2023-02-08 10:00:00 | NQ | Futures | 14450.88 | 14490.99 | 14337.08 | 14350.17 | 103938.0 |
| 2023-02-08 11:00:00 | NQ | Futures | 14350.17 | 14360.12 | 14244.33 | 14316.88 | 79467.0 |
| 2023-02-08 12:00:00 | NQ | Futures | 14317.16 | 14341.91 | 14273.92 | 14329.11 | 46039.0 |
| 2023-02-08 13:00:00 | NQ | Futures | 14329.97 | 14364.67 | 14269.08 | 14302.09 | 45746.0 |
| 2023-02-08 14:00:00 | NQ | Futures | 14301.8 | 14340.49 | 14265.95 | 14300.66 | 40519.0 |
| 2023-02-08 15:00:00 | NQ | Futures | 14300.66 | 14304.93 | 14239.21 | 14273.92 | 63329.0 |
| 2023-02-08 16:00:00 | NQ | Futures | 14273.92 | 14292.13 | 14259.13 | 14291.84 | 11525.0 |
| 2023-02-08 18:00:00 | NQ | Futures | 14287.29 | 14302.37 | 14271.64 | 14294.4 | 3629.0 |
| 2023-02-08 19:00:00 | NQ | Futures | 14294.97 | 14311.76 | 14294.4 | 14307.78 | 3265.0 |
| 2023-02-08 20:00:00 | NQ | Futures | 14308.06 | 14322.0 | 14301.52 | 14317.45 | 2903.0 |
| 2023-02-08 21:00:00 | NQ | Futures | 14317.16 | 14331.1 | 14314.89 | 14323.14 | 2375.0 |
| 2023-02-08 22:00:00 | NQ | Futures | 14323.42 | 14329.97 | 14309.77 | 14317.16 | 4310.0 |
| 2023-02-08 23:00:00 | NQ | Futures | 14316.59 | 14318.59 | 14306.35 | 14312.04 | 2292.0 |
| 2023-02-08 00:00:00 | YM | Futures | 38091.6 | 38118.4 | 38081.6 | 38112.8 | 750.0 |
| 2023-02-08 01:00:00 | YM | Futures | 38111.7 | 38118.4 | 38076.0 | 38078.3 | 1168.0 |
| 2023-02-08 02:00:00 | YM | Futures | 38079.4 | 38086.1 | 38030.4 | 38061.6 | 2360.0 |
| 2023-02-08 03:00:00 | YM | Futures | 38061.6 | 38091.6 | 37972.4 | 38028.1 | 5553.0 |
> showing 50 of 2,061 rows — these rows as CSV