PREVIEW / futures_1hour / 2024-07-17
file: by_date/futures_1hour/2024/2024-07-17.parquet size: 67 KB rows: 2,077
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-17 00:00:00 | ES | Futures | 5987.3 | 5987.82 | 5984.15 | 5985.2 | 2724.0 |
| 2024-07-17 01:00:00 | ES | Futures | 5985.47 | 5986.78 | 5981.27 | 5981.53 | 6381.0 |
| 2024-07-17 02:00:00 | ES | Futures | 5981.79 | 5982.06 | 5962.39 | 5969.21 | 24380.0 |
| 2024-07-17 03:00:00 | ES | Futures | 5969.21 | 5969.74 | 5953.74 | 5955.32 | 28049.0 |
| 2024-07-17 04:00:00 | ES | Futures | 5955.58 | 5957.15 | 5944.04 | 5952.43 | 36869.0 |
| 2024-07-17 05:00:00 | ES | Futures | 5952.69 | 5954.53 | 5947.98 | 5952.43 | 13842.0 |
| 2024-07-17 06:00:00 | ES | Futures | 5952.43 | 5955.05 | 5945.09 | 5947.19 | 13743.0 |
| 2024-07-17 07:00:00 | ES | Futures | 5947.45 | 5950.6 | 5930.15 | 5939.06 | 38896.0 |
| 2024-07-17 08:00:00 | ES | Futures | 5939.06 | 5943.52 | 5931.98 | 5934.08 | 41510.0 |
| 2024-07-17 09:00:00 | ES | Futures | 5934.08 | 5948.76 | 5927.79 | 5941.42 | 243622.0 |
| 2024-07-17 10:00:00 | ES | Futures | 5941.42 | 5941.95 | 5920.97 | 5924.91 | 360420.0 |
| 2024-07-17 11:00:00 | ES | Futures | 5924.91 | 5930.15 | 5919.66 | 5926.22 | 222372.0 |
| 2024-07-17 12:00:00 | ES | Futures | 5926.48 | 5927.79 | 5912.06 | 5921.76 | 219811.0 |
| 2024-07-17 13:00:00 | ES | Futures | 5922.02 | 5922.02 | 5907.34 | 5914.94 | 157232.0 |
| 2024-07-17 14:00:00 | ES | Futures | 5915.21 | 5926.74 | 5909.96 | 5916.52 | 139681.0 |
| 2024-07-17 15:00:00 | ES | Futures | 5916.52 | 5925.69 | 5911.53 | 5911.53 | 294785.0 |
| 2024-07-17 16:00:00 | ES | Futures | 5911.53 | 5918.09 | 5905.77 | 5917.56 | 99049.0 |
| 2024-07-17 18:00:00 | ES | Futures | 5918.61 | 5925.17 | 5917.56 | 5924.64 | 8915.0 |
| 2024-07-17 19:00:00 | ES | Futures | 5924.64 | 5924.91 | 5922.81 | 5923.86 | 4689.0 |
| 2024-07-17 20:00:00 | ES | Futures | 5923.86 | 5928.84 | 5923.59 | 5926.74 | 7086.0 |
| 2024-07-17 21:00:00 | ES | Futures | 5926.74 | 5929.62 | 5924.91 | 5928.58 | 6003.0 |
| 2024-07-17 22:00:00 | ES | Futures | 5928.84 | 5929.1 | 5925.69 | 5927.79 | 5614.0 |
| 2024-07-17 23:00:00 | ES | Futures | 5927.79 | 5928.31 | 5920.97 | 5925.17 | 4457.0 |
| 2024-07-17 00:00:00 | NQ | Futures | 21684.05 | 21686.69 | 21664.25 | 21672.44 | 2401.0 |
| 2024-07-17 01:00:00 | NQ | Futures | 21672.17 | 21683.52 | 21654.22 | 21656.07 | 4794.0 |
| 2024-07-17 02:00:00 | NQ | Futures | 21656.6 | 21660.56 | 21557.34 | 21599.05 | 14345.0 |
| 2024-07-17 03:00:00 | NQ | Futures | 21599.31 | 21602.48 | 21485.01 | 21501.9 | 20676.0 |
| 2024-07-17 04:00:00 | NQ | Futures | 21502.17 | 21516.69 | 21444.09 | 21481.31 | 22419.0 |
| 2024-07-17 05:00:00 | NQ | Futures | 21481.05 | 21495.57 | 21456.76 | 21481.31 | 8887.0 |
| 2024-07-17 06:00:00 | NQ | Futures | 21481.05 | 21506.92 | 21457.03 | 21471.28 | 10226.0 |
| 2024-07-17 07:00:00 | NQ | Futures | 21471.81 | 21487.65 | 21392.88 | 21421.39 | 23269.0 |
| 2024-07-17 08:00:00 | NQ | Futures | 21421.12 | 21456.76 | 21407.13 | 21414.79 | 22760.0 |
| 2024-07-17 09:00:00 | NQ | Futures | 21414.52 | 21432.21 | 21336.39 | 21339.29 | 116057.0 |
| 2024-07-17 10:00:00 | NQ | Futures | 21339.29 | 21343.25 | 21221.82 | 21248.74 | 146924.0 |
| 2024-07-17 11:00:00 | NQ | Futures | 21248.48 | 21278.84 | 21174.56 | 21210.2 | 95833.0 |
| 2024-07-17 12:00:00 | NQ | Futures | 21210.47 | 21212.84 | 21126.78 | 21185.12 | 89235.0 |
| 2024-07-17 13:00:00 | NQ | Futures | 21185.39 | 21207.83 | 21130.48 | 21151.86 | 66851.0 |
| 2024-07-17 14:00:00 | NQ | Futures | 21152.39 | 21197.79 | 21131.01 | 21146.32 | 54930.0 |
| 2024-07-17 15:00:00 | NQ | Futures | 21146.05 | 21195.16 | 21105.67 | 21110.15 | 93357.0 |
| 2024-07-17 16:00:00 | NQ | Futures | 21110.68 | 21144.73 | 21082.43 | 21136.29 | 26413.0 |
| 2024-07-17 18:00:00 | NQ | Futures | 21144.21 | 21189.35 | 21144.21 | 21183.54 | 8418.0 |
| 2024-07-17 19:00:00 | NQ | Futures | 21183.54 | 21190.14 | 21173.24 | 21180.37 | 2681.0 |
| 2024-07-17 20:00:00 | NQ | Futures | 21179.84 | 21197.0 | 21175.62 | 21185.65 | 4452.0 |
| 2024-07-17 21:00:00 | NQ | Futures | 21185.65 | 21203.07 | 21174.04 | 21192.52 | 4895.0 |
| 2024-07-17 22:00:00 | NQ | Futures | 21193.31 | 21194.89 | 21176.94 | 21184.07 | 3416.0 |
| 2024-07-17 23:00:00 | NQ | Futures | 21184.33 | 21186.18 | 21145.0 | 21172.45 | 3774.0 |
| 2024-07-17 00:00:00 | YM | Futures | 43383.5 | 43385.6 | 43367.7 | 43377.2 | 523.0 |
| 2024-07-17 01:00:00 | YM | Futures | 43375.1 | 43380.3 | 43341.5 | 43346.7 | 1104.0 |
| 2024-07-17 02:00:00 | YM | Futures | 43347.8 | 43349.9 | 43237.4 | 43272.1 | 3894.0 |
| 2024-07-17 03:00:00 | YM | Futures | 43271.1 | 43290.0 | 43213.3 | 43245.9 | 3745.0 |
> showing 50 of 2,077 rows — these rows as CSV