PREVIEW / futures_1hour / 2024-07-30
file: by_date/futures_1hour/2024/2024-07-30.parquet size: 67 KB rows: 2,096
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-30 00:00:00 | ES | Futures | 5756.86 | 5767.08 | 5756.86 | 5766.56 | 5454.0 |
| 2024-07-30 01:00:00 | ES | Futures | 5766.82 | 5771.8 | 5764.72 | 5771.02 | 5953.0 |
| 2024-07-30 02:00:00 | ES | Futures | 5770.75 | 5772.06 | 5765.77 | 5772.06 | 7864.0 |
| 2024-07-30 03:00:00 | ES | Futures | 5772.06 | 5784.12 | 5772.06 | 5779.93 | 14215.0 |
| 2024-07-30 04:00:00 | ES | Futures | 5780.19 | 5783.07 | 5772.33 | 5779.14 | 12272.0 |
| 2024-07-30 05:00:00 | ES | Futures | 5779.4 | 5782.29 | 5772.85 | 5777.83 | 8248.0 |
| 2024-07-30 06:00:00 | ES | Futures | 5777.83 | 5783.6 | 5776.26 | 5781.24 | 7915.0 |
| 2024-07-30 07:00:00 | ES | Futures | 5781.24 | 5784.12 | 5779.67 | 5780.45 | 9029.0 |
| 2024-07-30 08:00:00 | ES | Futures | 5780.45 | 5783.86 | 5777.83 | 5780.45 | 17890.0 |
| 2024-07-30 09:00:00 | ES | Futures | 5780.72 | 5796.44 | 5779.67 | 5785.43 | 180707.0 |
| 2024-07-30 10:00:00 | ES | Futures | 5785.43 | 5787.53 | 5757.64 | 5759.22 | 287963.0 |
| 2024-07-30 11:00:00 | ES | Futures | 5759.48 | 5761.05 | 5723.04 | 5723.83 | 321893.0 |
| 2024-07-30 12:00:00 | ES | Futures | 5724.09 | 5731.95 | 5705.74 | 5706.26 | 220297.0 |
| 2024-07-30 13:00:00 | ES | Futures | 5706.26 | 5734.31 | 5702.59 | 5732.21 | 226227.0 |
| 2024-07-30 14:00:00 | ES | Futures | 5732.21 | 5746.63 | 5728.81 | 5733.79 | 186913.0 |
| 2024-07-30 15:00:00 | ES | Futures | 5733.79 | 5758.17 | 5726.45 | 5739.03 | 298952.0 |
| 2024-07-30 16:00:00 | ES | Futures | 5739.03 | 5744.01 | 5697.35 | 5717.27 | 130239.0 |
| 2024-07-30 18:00:00 | ES | Futures | 5720.16 | 5741.13 | 5716.75 | 5733.53 | 22040.0 |
| 2024-07-30 19:00:00 | ES | Futures | 5733.53 | 5748.73 | 5732.48 | 5747.16 | 7313.0 |
| 2024-07-30 20:00:00 | ES | Futures | 5746.9 | 5753.19 | 5741.91 | 5752.14 | 9098.0 |
| 2024-07-30 21:00:00 | ES | Futures | 5752.4 | 5754.5 | 5747.68 | 5751.88 | 6730.0 |
| 2024-07-30 22:00:00 | ES | Futures | 5751.88 | 5760.53 | 5751.09 | 5759.74 | 8647.0 |
| 2024-07-30 23:00:00 | ES | Futures | 5759.48 | 5765.51 | 5757.64 | 5764.72 | 7647.0 |
| 2024-07-30 00:00:00 | NQ | Futures | 20201.0 | 20255.91 | 20200.47 | 20253.0 | 4533.0 |
| 2024-07-30 01:00:00 | NQ | Futures | 20254.06 | 20282.3 | 20240.86 | 20277.02 | 4195.0 |
| 2024-07-30 02:00:00 | NQ | Futures | 20276.5 | 20289.43 | 20258.02 | 20282.57 | 4311.0 |
| 2024-07-30 03:00:00 | NQ | Futures | 20282.83 | 20328.5 | 20282.83 | 20310.81 | 6473.0 |
| 2024-07-30 04:00:00 | NQ | Futures | 20311.34 | 20334.57 | 20279.93 | 20321.9 | 7407.0 |
| 2024-07-30 05:00:00 | NQ | Futures | 20322.96 | 20343.55 | 20280.98 | 20302.37 | 6348.0 |
| 2024-07-30 06:00:00 | NQ | Futures | 20302.37 | 20333.25 | 20294.18 | 20330.08 | 4392.0 |
| 2024-07-30 07:00:00 | NQ | Futures | 20329.82 | 20358.33 | 20321.37 | 20339.59 | 6957.0 |
| 2024-07-30 08:00:00 | NQ | Futures | 20339.32 | 20355.43 | 20327.97 | 20345.92 | 7383.0 |
| 2024-07-30 09:00:00 | NQ | Futures | 20345.66 | 20400.3 | 20280.72 | 20301.05 | 80208.0 |
| 2024-07-30 10:00:00 | NQ | Futures | 20300.78 | 20321.37 | 20165.36 | 20176.71 | 114303.0 |
| 2024-07-30 11:00:00 | NQ | Futures | 20175.39 | 20185.42 | 19984.53 | 19987.96 | 110025.0 |
| 2024-07-30 12:00:00 | NQ | Futures | 19988.49 | 20034.42 | 19862.84 | 19868.64 | 77161.0 |
| 2024-07-30 13:00:00 | NQ | Futures | 19868.91 | 20009.87 | 19854.65 | 19996.41 | 75821.0 |
| 2024-07-30 14:00:00 | NQ | Futures | 19995.88 | 20062.14 | 19980.84 | 20012.51 | 61138.0 |
| 2024-07-30 15:00:00 | NQ | Futures | 20013.04 | 20079.83 | 19961.04 | 19997.99 | 86564.0 |
| 2024-07-30 16:00:00 | NQ | Futures | 19998.79 | 20014.36 | 19772.29 | 19916.16 | 46908.0 |
| 2024-07-30 18:00:00 | NQ | Futures | 19920.91 | 20060.56 | 19916.69 | 20031.52 | 14088.0 |
| 2024-07-30 19:00:00 | NQ | Futures | 20031.78 | 20131.04 | 20027.82 | 20126.82 | 7057.0 |
| 2024-07-30 20:00:00 | NQ | Futures | 20126.29 | 20147.41 | 20079.04 | 20143.98 | 7219.0 |
| 2024-07-30 21:00:00 | NQ | Futures | 20145.03 | 20157.44 | 20122.86 | 20145.03 | 5424.0 |
| 2024-07-30 22:00:00 | NQ | Futures | 20144.5 | 20189.65 | 20141.86 | 20176.18 | 4695.0 |
| 2024-07-30 23:00:00 | NQ | Futures | 20175.39 | 20210.24 | 20162.98 | 20204.43 | 3700.0 |
| 2024-07-30 00:00:00 | YM | Futures | 42779.3 | 42824.5 | 42777.2 | 42824.5 | 605.0 |
| 2024-07-30 01:00:00 | YM | Futures | 42824.5 | 42841.3 | 42809.8 | 42837.1 | 661.0 |
| 2024-07-30 02:00:00 | YM | Futures | 42835.0 | 42858.1 | 42805.6 | 42844.5 | 986.0 |
| 2024-07-30 03:00:00 | YM | Futures | 42846.6 | 42925.4 | 42846.6 | 42889.7 | 1795.0 |
> showing 50 of 2,096 rows — these rows as CSV