PREVIEW / futures_1hour / 2023-03-08
file: by_date/futures_1hour/2023/2023-03-08.parquet size: 65 KB rows: 2,019
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-03-08 00:00:00 | ES | Futures | 4462.52 | 4464.2 | 4460.0 | 4460.0 | 6425.0 |
| 2023-03-08 01:00:00 | ES | Futures | 4460.28 | 4464.2 | 4459.17 | 4463.64 | 8021.0 |
| 2023-03-08 02:00:00 | ES | Futures | 4463.64 | 4463.92 | 4460.0 | 4460.84 | 8309.0 |
| 2023-03-08 03:00:00 | ES | Futures | 4460.84 | 4469.51 | 4460.56 | 4465.6 | 26381.0 |
| 2023-03-08 04:00:00 | ES | Futures | 4465.6 | 4468.11 | 4459.72 | 4466.71 | 17339.0 |
| 2023-03-08 05:00:00 | ES | Futures | 4466.99 | 4470.63 | 4463.92 | 4469.79 | 13907.0 |
| 2023-03-08 06:00:00 | ES | Futures | 4469.79 | 4474.54 | 4466.44 | 4466.99 | 24927.0 |
| 2023-03-08 07:00:00 | ES | Futures | 4466.99 | 4468.67 | 4453.85 | 4461.12 | 33180.0 |
| 2023-03-08 08:00:00 | ES | Futures | 4460.84 | 4469.51 | 4454.69 | 4463.64 | 68320.0 |
| 2023-03-08 09:00:00 | ES | Futures | 4463.36 | 4470.63 | 4457.49 | 4466.71 | 173060.0 |
| 2023-03-08 10:00:00 | ES | Futures | 4466.44 | 4477.34 | 4444.91 | 4462.24 | 430072.0 |
| 2023-03-08 11:00:00 | ES | Futures | 4461.96 | 4477.34 | 4454.97 | 4472.87 | 174351.0 |
| 2023-03-08 12:00:00 | ES | Futures | 4473.15 | 4475.1 | 4449.38 | 4457.49 | 146936.0 |
| 2023-03-08 13:00:00 | ES | Futures | 4457.49 | 4460.0 | 4441.83 | 4446.58 | 178917.0 |
| 2023-03-08 14:00:00 | ES | Futures | 4446.86 | 4458.05 | 4445.74 | 4450.5 | 125329.0 |
| 2023-03-08 15:00:00 | ES | Futures | 4450.5 | 4471.19 | 4446.02 | 4468.67 | 211383.0 |
| 2023-03-08 16:00:00 | ES | Futures | 4468.67 | 4471.75 | 4466.99 | 4471.75 | 47747.0 |
| 2023-03-08 18:00:00 | ES | Futures | 4470.35 | 4471.19 | 4466.99 | 4467.55 | 6475.0 |
| 2023-03-08 19:00:00 | ES | Futures | 4467.83 | 4468.39 | 4456.93 | 4465.04 | 19229.0 |
| 2023-03-08 20:00:00 | ES | Futures | 4465.32 | 4467.55 | 4457.21 | 4457.77 | 11275.0 |
| 2023-03-08 21:00:00 | ES | Futures | 4457.49 | 4461.68 | 4456.93 | 4461.4 | 7940.0 |
| 2023-03-08 22:00:00 | ES | Futures | 4461.12 | 4461.96 | 4458.89 | 4461.12 | 5666.0 |
| 2023-03-08 23:00:00 | ES | Futures | 4461.4 | 4463.08 | 4460.0 | 4462.52 | 2991.0 |
| 2023-03-08 00:00:00 | NQ | Futures | 13840.07 | 13852.87 | 13834.09 | 13834.66 | 3514.0 |
| 2023-03-08 01:00:00 | NQ | Futures | 13834.95 | 13847.75 | 13824.99 | 13846.33 | 3872.0 |
| 2023-03-08 02:00:00 | NQ | Futures | 13846.33 | 13850.31 | 13830.11 | 13832.39 | 4165.0 |
| 2023-03-08 03:00:00 | NQ | Futures | 13831.53 | 13873.64 | 13830.39 | 13864.53 | 11178.0 |
| 2023-03-08 04:00:00 | NQ | Futures | 13864.53 | 13877.05 | 13837.51 | 13864.25 | 7249.0 |
| 2023-03-08 05:00:00 | NQ | Futures | 13864.82 | 13883.31 | 13852.02 | 13879.33 | 5524.0 |
| 2023-03-08 06:00:00 | NQ | Futures | 13879.61 | 13902.94 | 13871.36 | 13872.21 | 9304.0 |
| 2023-03-08 07:00:00 | NQ | Futures | 13872.21 | 13879.9 | 13828.4 | 13848.32 | 11829.0 |
| 2023-03-08 08:00:00 | NQ | Futures | 13847.75 | 13878.47 | 13821.01 | 13857.99 | 24259.0 |
| 2023-03-08 09:00:00 | NQ | Futures | 13857.71 | 13901.52 | 13832.1 | 13858.84 | 62021.0 |
| 2023-03-08 10:00:00 | NQ | Futures | 13858.56 | 13910.62 | 13778.9 | 13872.78 | 127835.0 |
| 2023-03-08 11:00:00 | NQ | Futures | 13873.35 | 13945.33 | 13842.06 | 13934.8 | 76976.0 |
| 2023-03-08 12:00:00 | NQ | Futures | 13935.09 | 13943.05 | 13838.93 | 13875.06 | 60011.0 |
| 2023-03-08 13:00:00 | NQ | Futures | 13875.06 | 13883.88 | 13817.31 | 13832.67 | 58780.0 |
| 2023-03-08 14:00:00 | NQ | Futures | 13833.24 | 13892.13 | 13827.83 | 13859.98 | 47530.0 |
| 2023-03-08 15:00:00 | NQ | Futures | 13860.27 | 13935.09 | 13835.52 | 13918.59 | 67761.0 |
| 2023-03-08 16:00:00 | NQ | Futures | 13918.59 | 13927.12 | 13909.2 | 13926.84 | 13563.0 |
| 2023-03-08 18:00:00 | NQ | Futures | 13918.59 | 13925.13 | 13909.77 | 13911.48 | 3083.0 |
| 2023-03-08 19:00:00 | NQ | Futures | 13912.04 | 13913.75 | 13866.81 | 13897.82 | 7813.0 |
| 2023-03-08 20:00:00 | NQ | Futures | 13897.53 | 13905.22 | 13863.96 | 13865.96 | 5116.0 |
| 2023-03-08 21:00:00 | NQ | Futures | 13865.67 | 13883.88 | 13863.11 | 13879.04 | 3066.0 |
| 2023-03-08 22:00:00 | NQ | Futures | 13878.47 | 13889.85 | 13870.22 | 13885.3 | 2683.0 |
| 2023-03-08 23:00:00 | NQ | Futures | 13885.59 | 13889.0 | 13878.47 | 13887.86 | 1758.0 |
| 2023-03-08 00:00:00 | YM | Futures | 36644.3 | 36651.0 | 36619.8 | 36623.2 | 717.0 |
| 2023-03-08 01:00:00 | YM | Futures | 36623.2 | 36646.6 | 36619.8 | 36644.3 | 1093.0 |
| 2023-03-08 02:00:00 | YM | Futures | 36645.4 | 36645.4 | 36617.6 | 36623.2 | 1174.0 |
| 2023-03-08 03:00:00 | YM | Futures | 36622.0 | 36676.6 | 36618.7 | 36644.3 | 4581.0 |
> showing 50 of 2,019 rows — these rows as CSV