PREVIEW / futures_1hour / 2023-02-15
file: by_date/futures_1hour/2023/2023-02-15.parquet size: 68 KB rows: 2,053
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-15 00:00:00 | ES | Futures | 4617.7 | 4619.94 | 4613.51 | 4616.3 | 5081.0 |
| 2023-02-15 01:00:00 | ES | Futures | 4616.58 | 4616.58 | 4609.59 | 4612.67 | 5101.0 |
| 2023-02-15 02:00:00 | ES | Futures | 4612.39 | 4617.14 | 4608.48 | 4610.71 | 14064.0 |
| 2023-02-15 03:00:00 | ES | Futures | 4610.71 | 4621.9 | 4607.92 | 4618.26 | 25607.0 |
| 2023-02-15 04:00:00 | ES | Futures | 4618.54 | 4624.41 | 4618.54 | 4620.78 | 14254.0 |
| 2023-02-15 05:00:00 | ES | Futures | 4620.78 | 4623.29 | 4616.3 | 4621.9 | 13294.0 |
| 2023-02-15 06:00:00 | ES | Futures | 4621.9 | 4623.29 | 4617.14 | 4620.5 | 7916.0 |
| 2023-02-15 07:00:00 | ES | Futures | 4620.22 | 4632.24 | 4619.66 | 4623.01 | 22929.0 |
| 2023-02-15 08:00:00 | ES | Futures | 4622.74 | 4625.53 | 4603.44 | 4617.42 | 87006.0 |
| 2023-02-15 09:00:00 | ES | Futures | 4617.42 | 4624.41 | 4602.88 | 4609.31 | 227382.0 |
| 2023-02-15 10:00:00 | ES | Futures | 4609.31 | 4624.97 | 4600.09 | 4613.51 | 271603.0 |
| 2023-02-15 11:00:00 | ES | Futures | 4613.79 | 4637.55 | 4612.67 | 4630.56 | 193053.0 |
| 2023-02-15 12:00:00 | ES | Futures | 4630.56 | 4632.24 | 4615.19 | 4623.01 | 153865.0 |
| 2023-02-15 13:00:00 | ES | Futures | 4623.29 | 4639.79 | 4619.38 | 4639.79 | 106705.0 |
| 2023-02-15 14:00:00 | ES | Futures | 4639.79 | 4645.94 | 4631.96 | 4633.36 | 119889.0 |
| 2023-02-15 15:00:00 | ES | Futures | 4633.64 | 4651.81 | 4633.36 | 4651.26 | 200140.0 |
| 2023-02-15 16:00:00 | ES | Futures | 4651.26 | 4654.61 | 4649.3 | 4652.09 | 59573.0 |
| 2023-02-15 18:00:00 | ES | Futures | 4651.53 | 4652.65 | 4647.9 | 4651.53 | 6159.0 |
| 2023-02-15 19:00:00 | ES | Futures | 4651.53 | 4657.13 | 4650.7 | 4655.73 | 8248.0 |
| 2023-02-15 20:00:00 | ES | Futures | 4655.73 | 4661.04 | 4654.33 | 4658.8 | 8401.0 |
| 2023-02-15 21:00:00 | ES | Futures | 4658.8 | 4661.88 | 4657.69 | 4661.04 | 7483.0 |
| 2023-02-15 22:00:00 | ES | Futures | 4661.04 | 4661.6 | 4657.13 | 4658.25 | 4295.0 |
| 2023-02-15 23:00:00 | ES | Futures | 4658.25 | 4660.2 | 4657.69 | 4659.08 | 2999.0 |
| 2023-02-15 00:00:00 | NQ | Futures | 14298.39 | 14307.21 | 14283.88 | 14292.7 | 2780.0 |
| 2023-02-15 01:00:00 | NQ | Futures | 14292.98 | 14294.12 | 14260.26 | 14272.21 | 3478.0 |
| 2023-02-15 02:00:00 | NQ | Futures | 14272.5 | 14299.81 | 14262.54 | 14269.37 | 8075.0 |
| 2023-02-15 03:00:00 | NQ | Futures | 14269.65 | 14319.72 | 14261.97 | 14308.34 | 11138.0 |
| 2023-02-15 04:00:00 | NQ | Futures | 14308.91 | 14330.25 | 14305.21 | 14310.05 | 6165.0 |
| 2023-02-15 05:00:00 | NQ | Futures | 14310.05 | 14318.3 | 14294.12 | 14314.6 | 4896.0 |
| 2023-02-15 06:00:00 | NQ | Futures | 14315.17 | 14319.72 | 14294.69 | 14308.63 | 3923.0 |
| 2023-02-15 07:00:00 | NQ | Futures | 14308.63 | 14361.54 | 14308.63 | 14332.53 | 11413.0 |
| 2023-02-15 08:00:00 | NQ | Futures | 14332.81 | 14355.0 | 14263.68 | 14320.01 | 36822.0 |
| 2023-02-15 09:00:00 | NQ | Futures | 14320.29 | 14374.35 | 14271.36 | 14297.25 | 90143.0 |
| 2023-02-15 10:00:00 | NQ | Futures | 14297.25 | 14352.44 | 14252.3 | 14295.26 | 81357.0 |
| 2023-02-15 11:00:00 | NQ | Futures | 14296.11 | 14420.72 | 14290.71 | 14392.84 | 68176.0 |
| 2023-02-15 12:00:00 | NQ | Futures | 14393.41 | 14400.8 | 14347.32 | 14375.48 | 48827.0 |
| 2023-02-15 13:00:00 | NQ | Futures | 14375.48 | 14433.24 | 14355.57 | 14432.1 | 38338.0 |
| 2023-02-15 14:00:00 | NQ | Futures | 14432.1 | 14476.76 | 14418.44 | 14425.84 | 49090.0 |
| 2023-02-15 15:00:00 | NQ | Futures | 14426.12 | 14491.56 | 14413.89 | 14490.99 | 54005.0 |
| 2023-02-15 16:00:00 | NQ | Futures | 14490.71 | 14516.59 | 14479.61 | 14506.35 | 19054.0 |
| 2023-02-15 18:00:00 | NQ | Futures | 14497.82 | 14510.05 | 14488.43 | 14505.78 | 3924.0 |
| 2023-02-15 19:00:00 | NQ | Futures | 14505.21 | 14531.67 | 14505.21 | 14525.13 | 5620.0 |
| 2023-02-15 20:00:00 | NQ | Futures | 14524.84 | 14546.18 | 14521.15 | 14536.51 | 5659.0 |
| 2023-02-15 21:00:00 | NQ | Futures | 14536.51 | 14555.29 | 14533.38 | 14552.16 | 3531.0 |
| 2023-02-15 22:00:00 | NQ | Futures | 14552.16 | 14557.85 | 14541.06 | 14543.34 | 2117.0 |
| 2023-02-15 23:00:00 | NQ | Futures | 14543.91 | 14547.03 | 14537.36 | 14543.34 | 1770.0 |
| 2023-02-15 00:00:00 | YM | Futures | 37905.6 | 37922.3 | 37880.0 | 37900.0 | 729.0 |
| 2023-02-15 01:00:00 | YM | Futures | 37901.1 | 37902.2 | 37861.0 | 37882.2 | 858.0 |
| 2023-02-15 02:00:00 | YM | Futures | 37880.0 | 37911.2 | 37849.9 | 37865.5 | 1937.0 |
| 2023-02-15 03:00:00 | YM | Futures | 37865.5 | 37935.7 | 37833.2 | 37911.2 | 2947.0 |
> showing 50 of 2,053 rows — these rows as CSV