PREVIEW / futures_1hour / 2023-05-23
file: by_date/futures_1hour/2023/2023-05-23.parquet size: 66 KB rows: 2,026
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-05-23 00:00:00 | ES | Futures | 4673.96 | 4674.24 | 4669.52 | 4671.19 | 5663.0 |
| 2023-05-23 01:00:00 | ES | Futures | 4671.19 | 4672.85 | 4669.52 | 4672.02 | 4226.0 |
| 2023-05-23 02:00:00 | ES | Futures | 4672.02 | 4672.57 | 4667.03 | 4667.58 | 8763.0 |
| 2023-05-23 03:00:00 | ES | Futures | 4667.3 | 4667.58 | 4659.26 | 4661.76 | 25404.0 |
| 2023-05-23 04:00:00 | ES | Futures | 4661.76 | 4664.53 | 4659.81 | 4661.2 | 11829.0 |
| 2023-05-23 05:00:00 | ES | Futures | 4661.2 | 4662.31 | 4656.76 | 4658.15 | 12033.0 |
| 2023-05-23 06:00:00 | ES | Futures | 4658.15 | 4665.36 | 4656.49 | 4661.76 | 13652.0 |
| 2023-05-23 07:00:00 | ES | Futures | 4662.03 | 4662.87 | 4650.38 | 4650.66 | 22201.0 |
| 2023-05-23 08:00:00 | ES | Futures | 4650.66 | 4656.49 | 4650.11 | 4651.77 | 27687.0 |
| 2023-05-23 09:00:00 | ES | Futures | 4651.77 | 4656.76 | 4643.17 | 4652.05 | 176270.0 |
| 2023-05-23 10:00:00 | ES | Futures | 4652.05 | 4657.87 | 4644.56 | 4649.0 | 190471.0 |
| 2023-05-23 11:00:00 | ES | Futures | 4649.0 | 4656.49 | 4648.44 | 4652.33 | 106209.0 |
| 2023-05-23 12:00:00 | ES | Futures | 4652.6 | 4655.38 | 4632.36 | 4637.35 | 194209.0 |
| 2023-05-23 13:00:00 | ES | Futures | 4637.35 | 4644.28 | 4624.59 | 4629.86 | 190597.0 |
| 2023-05-23 14:00:00 | ES | Futures | 4630.14 | 4636.52 | 4607.39 | 4619.04 | 246791.0 |
| 2023-05-23 15:00:00 | ES | Futures | 4619.32 | 4623.48 | 4609.89 | 4612.94 | 267728.0 |
| 2023-05-23 16:00:00 | ES | Futures | 4612.94 | 4617.1 | 4611.28 | 4614.33 | 65033.0 |
| 2023-05-23 18:00:00 | ES | Futures | 4612.94 | 4619.32 | 4612.94 | 4618.49 | 4741.0 |
| 2023-05-23 19:00:00 | ES | Futures | 4618.77 | 4620.15 | 4617.66 | 4619.88 | 3848.0 |
| 2023-05-23 20:00:00 | ES | Futures | 4619.88 | 4622.09 | 4617.93 | 4620.98 | 5879.0 |
| 2023-05-23 21:00:00 | ES | Futures | 4620.98 | 4621.26 | 4616.27 | 4616.55 | 6789.0 |
| 2023-05-23 22:00:00 | ES | Futures | 4616.55 | 4618.21 | 4614.61 | 4617.38 | 4938.0 |
| 2023-05-23 23:00:00 | ES | Futures | 4617.38 | 4619.88 | 4615.99 | 4618.77 | 3289.0 |
| 2023-05-23 00:00:00 | NQ | Futures | 15696.02 | 15697.43 | 15679.12 | 15684.47 | 3154.0 |
| 2023-05-23 01:00:00 | NQ | Futures | 15685.04 | 15695.17 | 15680.81 | 15690.1 | 2669.0 |
| 2023-05-23 02:00:00 | NQ | Futures | 15689.82 | 15693.2 | 15671.24 | 15672.65 | 4739.0 |
| 2023-05-23 03:00:00 | NQ | Futures | 15672.37 | 15674.62 | 15650.41 | 15662.23 | 8495.0 |
| 2023-05-23 04:00:00 | NQ | Futures | 15662.51 | 15673.49 | 15651.25 | 15662.23 | 6454.0 |
| 2023-05-23 05:00:00 | NQ | Futures | 15662.23 | 15667.86 | 15632.39 | 15636.89 | 7863.0 |
| 2023-05-23 06:00:00 | NQ | Futures | 15636.89 | 15656.6 | 15631.54 | 15649.28 | 7978.0 |
| 2023-05-23 07:00:00 | NQ | Futures | 15649.56 | 15656.6 | 15596.91 | 15602.54 | 11956.0 |
| 2023-05-23 08:00:00 | NQ | Futures | 15603.11 | 15620.56 | 15583.96 | 15587.06 | 17698.0 |
| 2023-05-23 09:00:00 | NQ | Futures | 15587.62 | 15628.44 | 15566.78 | 15613.24 | 92464.0 |
| 2023-05-23 10:00:00 | NQ | Futures | 15613.52 | 15629.57 | 15578.33 | 15593.81 | 81731.0 |
| 2023-05-23 11:00:00 | NQ | Futures | 15594.1 | 15623.66 | 15591.56 | 15609.86 | 52271.0 |
| 2023-05-23 12:00:00 | NQ | Futures | 15609.86 | 15619.72 | 15514.7 | 15535.53 | 73195.0 |
| 2023-05-23 13:00:00 | NQ | Futures | 15536.1 | 15563.41 | 15502.87 | 15512.73 | 64590.0 |
| 2023-05-23 14:00:00 | NQ | Futures | 15512.73 | 15532.72 | 15441.78 | 15475.56 | 86109.0 |
| 2023-05-23 15:00:00 | NQ | Futures | 15476.41 | 15493.58 | 15440.37 | 15457.82 | 82164.0 |
| 2023-05-23 16:00:00 | NQ | Futures | 15457.82 | 15470.21 | 15450.22 | 15465.99 | 17464.0 |
| 2023-05-23 18:00:00 | NQ | Futures | 15461.77 | 15480.07 | 15459.79 | 15478.66 | 2724.0 |
| 2023-05-23 19:00:00 | NQ | Futures | 15479.22 | 15484.85 | 15475.28 | 15483.45 | 2288.0 |
| 2023-05-23 20:00:00 | NQ | Futures | 15482.32 | 15491.89 | 15477.25 | 15486.54 | 3358.0 |
| 2023-05-23 21:00:00 | NQ | Futures | 15486.26 | 15488.79 | 15466.27 | 15468.24 | 4373.0 |
| 2023-05-23 22:00:00 | NQ | Futures | 15468.52 | 15473.87 | 15461.2 | 15470.78 | 3291.0 |
| 2023-05-23 23:00:00 | NQ | Futures | 15470.78 | 15480.91 | 15469.93 | 15478.94 | 1902.0 |
| 2023-05-23 00:00:00 | YM | Futures | 36932.8 | 36936.1 | 36898.5 | 36909.6 | 746.0 |
| 2023-05-23 01:00:00 | YM | Futures | 36909.6 | 36916.2 | 36890.8 | 36914.0 | 781.0 |
| 2023-05-23 02:00:00 | YM | Futures | 36911.8 | 36915.1 | 36869.8 | 36878.6 | 1755.0 |
| 2023-05-23 03:00:00 | YM | Futures | 36879.7 | 36883.0 | 36812.3 | 36824.5 | 3717.0 |
> showing 50 of 2,026 rows — these rows as CSV