PREVIEW / futures_1hour / 2024-07-29
file: by_date/futures_1hour/2024/2024-07-29.parquet size: 66 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-29 00:00:00 | ES | Futures | 5791.99 | 5793.82 | 5789.63 | 5790.94 | 2284.0 |
| 2024-07-29 01:00:00 | ES | Futures | 5791.2 | 5795.92 | 5790.68 | 5794.09 | 4845.0 |
| 2024-07-29 02:00:00 | ES | Futures | 5794.35 | 5796.71 | 5789.89 | 5795.4 | 8347.0 |
| 2024-07-29 03:00:00 | ES | Futures | 5795.13 | 5795.4 | 5774.42 | 5775.73 | 21487.0 |
| 2024-07-29 04:00:00 | ES | Futures | 5775.73 | 5785.43 | 5773.64 | 5779.4 | 15551.0 |
| 2024-07-29 05:00:00 | ES | Futures | 5779.67 | 5786.74 | 5775.47 | 5786.48 | 10802.0 |
| 2024-07-29 06:00:00 | ES | Futures | 5786.48 | 5791.46 | 5784.91 | 5788.06 | 7851.0 |
| 2024-07-29 07:00:00 | ES | Futures | 5787.79 | 5795.4 | 5785.96 | 5791.99 | 14270.0 |
| 2024-07-29 08:00:00 | ES | Futures | 5791.73 | 5803.79 | 5788.32 | 5791.46 | 28514.0 |
| 2024-07-29 09:00:00 | ES | Futures | 5791.46 | 5791.46 | 5769.18 | 5789.37 | 230024.0 |
| 2024-07-29 10:00:00 | ES | Futures | 5789.37 | 5793.82 | 5764.46 | 5764.99 | 291798.0 |
| 2024-07-29 11:00:00 | ES | Futures | 5765.25 | 5780.72 | 5747.68 | 5778.88 | 235716.0 |
| 2024-07-29 12:00:00 | ES | Futures | 5778.88 | 5791.2 | 5778.62 | 5785.7 | 166150.0 |
| 2024-07-29 13:00:00 | ES | Futures | 5785.7 | 5794.09 | 5772.06 | 5777.57 | 137534.0 |
| 2024-07-29 14:00:00 | ES | Futures | 5777.57 | 5777.83 | 5767.08 | 5774.16 | 161630.0 |
| 2024-07-29 15:00:00 | ES | Futures | 5774.42 | 5784.12 | 5767.87 | 5770.75 | 210325.0 |
| 2024-07-29 16:00:00 | ES | Futures | 5770.75 | 5773.9 | 5767.87 | 5772.33 | 48114.0 |
| 2024-07-29 18:00:00 | ES | Futures | 5772.33 | 5776.78 | 5769.7 | 5772.06 | 4036.0 |
| 2024-07-29 19:00:00 | ES | Futures | 5772.33 | 5772.59 | 5752.66 | 5755.81 | 8726.0 |
| 2024-07-29 20:00:00 | ES | Futures | 5755.55 | 5761.31 | 5753.97 | 5760.0 | 5737.0 |
| 2024-07-29 21:00:00 | ES | Futures | 5760.27 | 5761.58 | 5747.94 | 5750.57 | 9292.0 |
| 2024-07-29 22:00:00 | ES | Futures | 5750.83 | 5754.76 | 5746.11 | 5752.4 | 8643.0 |
| 2024-07-29 23:00:00 | ES | Futures | 5752.66 | 5757.64 | 5751.61 | 5756.86 | 5247.0 |
| 2024-07-29 00:00:00 | NQ | Futures | 20382.35 | 20390.01 | 20372.59 | 20379.98 | 1015.0 |
| 2024-07-29 01:00:00 | NQ | Futures | 20380.51 | 20409.28 | 20377.07 | 20391.59 | 3173.0 |
| 2024-07-29 02:00:00 | NQ | Futures | 20391.59 | 20416.14 | 20369.68 | 20402.68 | 4976.0 |
| 2024-07-29 03:00:00 | NQ | Futures | 20402.42 | 20404.0 | 20294.71 | 20314.25 | 11569.0 |
| 2024-07-29 04:00:00 | NQ | Futures | 20313.45 | 20363.08 | 20302.37 | 20325.6 | 8838.0 |
| 2024-07-29 05:00:00 | NQ | Futures | 20325.86 | 20350.41 | 20310.55 | 20347.51 | 4289.0 |
| 2024-07-29 06:00:00 | NQ | Futures | 20346.98 | 20374.43 | 20337.48 | 20362.82 | 4848.0 |
| 2024-07-29 07:00:00 | NQ | Futures | 20361.76 | 20400.04 | 20356.22 | 20376.81 | 7252.0 |
| 2024-07-29 08:00:00 | NQ | Futures | 20376.81 | 20444.92 | 20367.57 | 20389.74 | 14207.0 |
| 2024-07-29 09:00:00 | NQ | Futures | 20390.01 | 20450.2 | 20297.09 | 20441.22 | 93994.0 |
| 2024-07-29 10:00:00 | NQ | Futures | 20440.96 | 20461.02 | 20293.39 | 20297.09 | 98811.0 |
| 2024-07-29 11:00:00 | NQ | Futures | 20297.09 | 20349.09 | 20182.25 | 20338.0 | 83589.0 |
| 2024-07-29 12:00:00 | NQ | Futures | 20338.27 | 20424.33 | 20337.74 | 20388.42 | 63403.0 |
| 2024-07-29 13:00:00 | NQ | Futures | 20388.42 | 20430.93 | 20321.37 | 20331.93 | 46535.0 |
| 2024-07-29 14:00:00 | NQ | Futures | 20331.93 | 20334.57 | 20259.07 | 20294.97 | 44557.0 |
| 2024-07-29 15:00:00 | NQ | Futures | 20295.5 | 20345.13 | 20272.54 | 20282.83 | 51056.0 |
| 2024-07-29 16:00:00 | NQ | Futures | 20282.83 | 20297.61 | 20261.71 | 20297.61 | 12464.0 |
| 2024-07-29 18:00:00 | NQ | Futures | 20291.81 | 20313.45 | 20280.98 | 20291.02 | 1845.0 |
| 2024-07-29 19:00:00 | NQ | Futures | 20290.75 | 20291.28 | 20192.55 | 20202.84 | 6485.0 |
| 2024-07-29 20:00:00 | NQ | Futures | 20202.32 | 20229.51 | 20195.98 | 20227.66 | 3469.0 |
| 2024-07-29 21:00:00 | NQ | Futures | 20228.19 | 20237.16 | 20162.46 | 20175.92 | 6520.0 |
| 2024-07-29 22:00:00 | NQ | Futures | 20176.71 | 20192.29 | 20142.92 | 20175.65 | 5376.0 |
| 2024-07-29 23:00:00 | NQ | Futures | 20176.97 | 20207.86 | 20171.96 | 20199.94 | 3717.0 |
| 2024-07-29 00:00:00 | YM | Futures | 43060.9 | 43072.5 | 43044.1 | 43051.5 | 381.0 |
| 2024-07-29 01:00:00 | YM | Futures | 43051.5 | 43076.7 | 43049.4 | 43071.4 | 653.0 |
| 2024-07-29 02:00:00 | YM | Futures | 43073.5 | 43078.8 | 43035.7 | 43073.5 | 1218.0 |
| 2024-07-29 03:00:00 | YM | Futures | 43075.6 | 43077.7 | 42941.1 | 42946.4 | 2144.0 |
> showing 50 of 2,077 rows — these rows as CSV