PREVIEW / futures_1hour / 2024-07-09
file: by_date/futures_1hour/2024/2024-07-09.parquet size: 64 KB rows: 2,057
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 |
|---|---|---|---|---|---|---|---|
| 2024-07-09 00:00:00 | ES | Futures | 5912.32 | 5913.63 | 5911.53 | 5913.37 | 2852.0 |
| 2024-07-09 01:00:00 | ES | Futures | 5913.37 | 5914.42 | 5911.27 | 5912.58 | 4854.0 |
| 2024-07-09 02:00:00 | ES | Futures | 5912.32 | 5912.32 | 5908.39 | 5910.22 | 5701.0 |
| 2024-07-09 03:00:00 | ES | Futures | 5909.96 | 5913.11 | 5907.6 | 5912.32 | 13255.0 |
| 2024-07-09 04:00:00 | ES | Futures | 5912.32 | 5913.89 | 5910.22 | 5912.85 | 9709.0 |
| 2024-07-09 05:00:00 | ES | Futures | 5912.85 | 5914.42 | 5912.32 | 5912.32 | 7253.0 |
| 2024-07-09 06:00:00 | ES | Futures | 5912.58 | 5913.89 | 5911.53 | 5912.58 | 7975.0 |
| 2024-07-09 07:00:00 | ES | Futures | 5912.32 | 5913.37 | 5909.44 | 5910.22 | 12032.0 |
| 2024-07-09 08:00:00 | ES | Futures | 5910.49 | 5912.06 | 5906.82 | 5909.96 | 21827.0 |
| 2024-07-09 09:00:00 | ES | Futures | 5909.7 | 5916.52 | 5908.39 | 5914.42 | 100715.0 |
| 2024-07-09 10:00:00 | ES | Futures | 5914.68 | 5917.3 | 5903.93 | 5911.27 | 189975.0 |
| 2024-07-09 11:00:00 | ES | Futures | 5911.01 | 5913.37 | 5904.72 | 5912.85 | 117517.0 |
| 2024-07-09 12:00:00 | ES | Futures | 5913.11 | 5916.25 | 5908.91 | 5915.47 | 83920.0 |
| 2024-07-09 13:00:00 | ES | Futures | 5915.47 | 5920.45 | 5904.98 | 5908.91 | 120747.0 |
| 2024-07-09 14:00:00 | ES | Futures | 5908.91 | 5909.44 | 5903.41 | 5906.29 | 89340.0 |
| 2024-07-09 15:00:00 | ES | Futures | 5906.29 | 5908.13 | 5902.1 | 5905.77 | 148770.0 |
| 2024-07-09 16:00:00 | ES | Futures | 5906.03 | 5907.86 | 5904.46 | 5906.03 | 42357.0 |
| 2024-07-09 18:00:00 | ES | Futures | 5905.77 | 5908.13 | 5905.51 | 5907.34 | 3263.0 |
| 2024-07-09 19:00:00 | ES | Futures | 5907.6 | 5908.91 | 5907.6 | 5907.86 | 1579.0 |
| 2024-07-09 20:00:00 | ES | Futures | 5907.6 | 5910.22 | 5907.6 | 5909.96 | 4079.0 |
| 2024-07-09 21:00:00 | ES | Futures | 5909.96 | 5910.75 | 5907.08 | 5907.34 | 4226.0 |
| 2024-07-09 22:00:00 | ES | Futures | 5907.6 | 5909.96 | 5907.34 | 5909.7 | 2668.0 |
| 2024-07-09 23:00:00 | ES | Futures | 5909.7 | 5909.96 | 5908.39 | 5908.65 | 1663.0 |
| 2024-07-09 00:00:00 | NQ | Futures | 21893.92 | 21900.52 | 21888.64 | 21897.88 | 1992.0 |
| 2024-07-09 01:00:00 | NQ | Futures | 21898.14 | 21902.63 | 21880.45 | 21884.94 | 3708.0 |
| 2024-07-09 02:00:00 | NQ | Futures | 21884.94 | 21887.05 | 21874.12 | 21884.68 | 3133.0 |
| 2024-07-09 03:00:00 | NQ | Futures | 21883.89 | 21899.72 | 21870.69 | 21892.07 | 6577.0 |
| 2024-07-09 04:00:00 | NQ | Futures | 21892.33 | 21900.78 | 21884.15 | 21892.33 | 4778.0 |
| 2024-07-09 05:00:00 | NQ | Futures | 21892.07 | 21908.17 | 21890.48 | 21899.99 | 3949.0 |
| 2024-07-09 06:00:00 | NQ | Futures | 21900.52 | 21904.48 | 21890.48 | 21899.2 | 4111.0 |
| 2024-07-09 07:00:00 | NQ | Futures | 21899.2 | 21905.53 | 21877.29 | 21884.68 | 6470.0 |
| 2024-07-09 08:00:00 | NQ | Futures | 21885.21 | 21890.48 | 21861.18 | 21880.45 | 10815.0 |
| 2024-07-09 09:00:00 | NQ | Futures | 21880.98 | 21925.86 | 21874.91 | 21910.02 | 75494.0 |
| 2024-07-09 10:00:00 | NQ | Futures | 21910.02 | 21933.51 | 21837.16 | 21866.73 | 112283.0 |
| 2024-07-09 11:00:00 | NQ | Futures | 21866.46 | 21880.19 | 21826.34 | 21863.56 | 64621.0 |
| 2024-07-09 12:00:00 | NQ | Futures | 21863.29 | 21875.7 | 21798.62 | 21832.41 | 60077.0 |
| 2024-07-09 13:00:00 | NQ | Futures | 21832.67 | 21847.98 | 21768.79 | 21816.04 | 64244.0 |
| 2024-07-09 14:00:00 | NQ | Futures | 21815.78 | 21835.84 | 21796.24 | 21827.92 | 43047.0 |
| 2024-07-09 15:00:00 | NQ | Futures | 21827.92 | 21843.23 | 21809.71 | 21835.58 | 51054.0 |
| 2024-07-09 16:00:00 | NQ | Futures | 21835.58 | 21846.93 | 21828.19 | 21844.82 | 11772.0 |
| 2024-07-09 18:00:00 | NQ | Futures | 21842.97 | 21858.02 | 21841.38 | 21853.0 | 3319.0 |
| 2024-07-09 19:00:00 | NQ | Futures | 21853.26 | 21861.45 | 21851.94 | 21855.38 | 1389.0 |
| 2024-07-09 20:00:00 | NQ | Futures | 21855.11 | 21869.1 | 21854.85 | 21867.52 | 3108.0 |
| 2024-07-09 21:00:00 | NQ | Futures | 21867.78 | 21869.63 | 21859.34 | 21859.86 | 2792.0 |
| 2024-07-09 22:00:00 | NQ | Futures | 21859.86 | 21871.48 | 21859.34 | 21868.57 | 2343.0 |
| 2024-07-09 23:00:00 | NQ | Futures | 21869.37 | 21874.12 | 21866.99 | 21868.05 | 1159.0 |
| 2024-07-09 00:00:00 | YM | Futures | 41739.1 | 41744.4 | 41733.9 | 41742.3 | 397.0 |
| 2024-07-09 01:00:00 | YM | Futures | 41743.3 | 41745.4 | 41729.7 | 41734.9 | 752.0 |
| 2024-07-09 02:00:00 | YM | Futures | 41734.9 | 41738.1 | 41691.8 | 41705.5 | 1301.0 |
| 2024-07-09 03:00:00 | YM | Futures | 41706.5 | 41716.0 | 41663.5 | 41713.9 | 2318.0 |
> showing 50 of 2,057 rows — these rows as CSV