PREVIEW / futures_1hour / 2023-02-16
file: by_date/futures_1hour/2023/2023-02-16.parquet size: 69 KB rows: 2,075
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-16 00:00:00 | ES | Futures | 4658.8 | 4659.36 | 4655.73 | 4657.41 | 3239.0 |
| 2023-02-16 01:00:00 | ES | Futures | 4657.41 | 4657.97 | 4651.53 | 4654.33 | 6652.0 |
| 2023-02-16 02:00:00 | ES | Futures | 4654.33 | 4657.97 | 4652.93 | 4657.41 | 6845.0 |
| 2023-02-16 03:00:00 | ES | Futures | 4657.41 | 4662.16 | 4650.7 | 4650.98 | 21336.0 |
| 2023-02-16 04:00:00 | ES | Futures | 4650.98 | 4657.69 | 4648.46 | 4648.46 | 15131.0 |
| 2023-02-16 05:00:00 | ES | Futures | 4648.74 | 4652.09 | 4646.5 | 4647.06 | 12979.0 |
| 2023-02-16 06:00:00 | ES | Futures | 4647.06 | 4649.3 | 4644.82 | 4647.34 | 10669.0 |
| 2023-02-16 07:00:00 | ES | Futures | 4647.34 | 4649.3 | 4636.72 | 4637.83 | 24808.0 |
| 2023-02-16 08:00:00 | ES | Futures | 4637.55 | 4638.95 | 4593.1 | 4600.93 | 129897.0 |
| 2023-02-16 09:00:00 | ES | Futures | 4600.65 | 4601.21 | 4583.59 | 4590.58 | 303380.0 |
| 2023-02-16 10:00:00 | ES | Futures | 4590.3 | 4622.46 | 4585.55 | 4618.82 | 315375.0 |
| 2023-02-16 11:00:00 | ES | Futures | 4619.1 | 4626.65 | 4612.39 | 4619.66 | 190509.0 |
| 2023-02-16 12:00:00 | ES | Futures | 4619.94 | 4636.44 | 4613.51 | 4627.77 | 171364.0 |
| 2023-02-16 13:00:00 | ES | Futures | 4628.05 | 4633.92 | 4618.54 | 4628.05 | 135690.0 |
| 2023-02-16 14:00:00 | ES | Futures | 4628.05 | 4636.44 | 4624.69 | 4628.61 | 113186.0 |
| 2023-02-16 15:00:00 | ES | Futures | 4628.89 | 4630.0 | 4582.47 | 4585.27 | 418993.0 |
| 2023-02-16 16:00:00 | ES | Futures | 4585.27 | 4586.67 | 4579.96 | 4580.79 | 73028.0 |
| 2023-02-16 18:00:00 | ES | Futures | 4580.51 | 4581.07 | 4569.05 | 4571.85 | 16608.0 |
| 2023-02-16 19:00:00 | ES | Futures | 4572.13 | 4575.48 | 4570.45 | 4572.97 | 9329.0 |
| 2023-02-16 20:00:00 | ES | Futures | 4573.24 | 4578.28 | 4569.89 | 4572.69 | 10821.0 |
| 2023-02-16 21:00:00 | ES | Futures | 4572.69 | 4572.69 | 4568.77 | 4569.61 | 7598.0 |
| 2023-02-16 22:00:00 | ES | Futures | 4569.61 | 4572.69 | 4568.77 | 4569.89 | 7242.0 |
| 2023-02-16 23:00:00 | ES | Futures | 4569.89 | 4570.73 | 4564.58 | 4567.09 | 7830.0 |
| 2023-02-16 00:00:00 | NQ | Futures | 14542.77 | 14544.76 | 14529.11 | 14538.22 | 1856.0 |
| 2023-02-16 01:00:00 | NQ | Futures | 14537.36 | 14540.21 | 14506.35 | 14517.16 | 4400.0 |
| 2023-02-16 02:00:00 | NQ | Futures | 14517.16 | 14538.5 | 14510.9 | 14534.8 | 3783.0 |
| 2023-02-16 03:00:00 | NQ | Futures | 14534.52 | 14547.89 | 14500.38 | 14502.94 | 11123.0 |
| 2023-02-16 04:00:00 | NQ | Futures | 14502.65 | 14519.44 | 14483.88 | 14484.45 | 7127.0 |
| 2023-02-16 05:00:00 | NQ | Futures | 14484.73 | 14497.25 | 14475.34 | 14483.02 | 6195.0 |
| 2023-02-16 06:00:00 | NQ | Futures | 14482.17 | 14492.13 | 14470.22 | 14478.76 | 5637.0 |
| 2023-02-16 07:00:00 | NQ | Futures | 14479.04 | 14485.58 | 14428.4 | 14437.79 | 12111.0 |
| 2023-02-16 08:00:00 | NQ | Futures | 14438.07 | 14441.77 | 14262.83 | 14291.56 | 46275.0 |
| 2023-02-16 09:00:00 | NQ | Futures | 14292.13 | 14329.4 | 14220.72 | 14297.82 | 102993.0 |
| 2023-02-16 10:00:00 | NQ | Futures | 14297.25 | 14418.73 | 14265.1 | 14394.83 | 97267.0 |
| 2023-02-16 11:00:00 | NQ | Futures | 14395.12 | 14421.86 | 14360.98 | 14385.16 | 64009.0 |
| 2023-02-16 12:00:00 | NQ | Futures | 14385.44 | 14445.76 | 14344.48 | 14399.1 | 55848.0 |
| 2023-02-16 13:00:00 | NQ | Futures | 14399.1 | 14422.43 | 14364.11 | 14410.19 | 47071.0 |
| 2023-02-16 14:00:00 | NQ | Futures | 14411.05 | 14427.26 | 14374.63 | 14397.96 | 41103.0 |
| 2023-02-16 15:00:00 | NQ | Futures | 14397.96 | 14403.93 | 14197.11 | 14203.65 | 120469.0 |
| 2023-02-16 16:00:00 | NQ | Futures | 14204.22 | 14209.06 | 14173.78 | 14186.3 | 19897.0 |
| 2023-02-16 18:00:00 | NQ | Futures | 14182.03 | 14186.3 | 14134.8 | 14143.05 | 8895.0 |
| 2023-02-16 19:00:00 | NQ | Futures | 14142.77 | 14152.44 | 14135.09 | 14146.75 | 4254.0 |
| 2023-02-16 20:00:00 | NQ | Futures | 14147.32 | 14167.24 | 14132.24 | 14143.62 | 5632.0 |
| 2023-02-16 21:00:00 | NQ | Futures | 14142.77 | 14143.62 | 14125.41 | 14128.26 | 4249.0 |
| 2023-02-16 22:00:00 | NQ | Futures | 14128.26 | 14140.78 | 14120.29 | 14129.68 | 3511.0 |
| 2023-02-16 23:00:00 | NQ | Futures | 14129.97 | 14133.1 | 14112.61 | 14126.27 | 3302.0 |
| 2023-02-16 00:00:00 | YM | Futures | 38098.3 | 38100.6 | 38073.8 | 38087.2 | 591.0 |
| 2023-02-16 01:00:00 | YM | Futures | 38086.1 | 38088.3 | 38053.8 | 38071.6 | 1006.0 |
| 2023-02-16 02:00:00 | YM | Futures | 38071.6 | 38103.9 | 38064.9 | 38097.2 | 1106.0 |
| 2023-02-16 03:00:00 | YM | Futures | 38097.2 | 38141.8 | 38069.4 | 38069.4 | 2770.0 |
> showing 50 of 2,075 rows — these rows as CSV