PREVIEW / futures_1hour / 2024-09-10
file: by_date/futures_1hour/2024/2024-09-10.parquet size: 61 KB rows: 1,888
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-09-10 00:00:00 | ES | Futures | 5743.23 | 5745.59 | 5734.84 | 5736.15 | 5029.0 |
| 2024-09-10 01:00:00 | ES | Futures | 5736.41 | 5741.13 | 5734.84 | 5737.46 | 8726.0 |
| 2024-09-10 02:00:00 | ES | Futures | 5737.46 | 5740.08 | 5732.48 | 5738.77 | 7214.0 |
| 2024-09-10 03:00:00 | ES | Futures | 5739.03 | 5752.66 | 5734.05 | 5752.14 | 14164.0 |
| 2024-09-10 04:00:00 | ES | Futures | 5752.14 | 5754.76 | 5740.87 | 5742.18 | 11990.0 |
| 2024-09-10 05:00:00 | ES | Futures | 5741.91 | 5743.75 | 5728.28 | 5740.87 | 23152.0 |
| 2024-09-10 06:00:00 | ES | Futures | 5740.87 | 5749.26 | 5734.31 | 5741.13 | 23080.0 |
| 2024-09-10 07:00:00 | ES | Futures | 5740.87 | 5751.88 | 5740.6 | 5749.78 | 19203.0 |
| 2024-09-10 08:00:00 | ES | Futures | 5749.78 | 5764.99 | 5748.99 | 5763.67 | 39480.0 |
| 2024-09-10 09:00:00 | ES | Futures | 5763.67 | 5768.92 | 5758.43 | 5760.79 | 154915.0 |
| 2024-09-10 10:00:00 | ES | Futures | 5761.05 | 5763.41 | 5736.41 | 5746.37 | 244427.0 |
| 2024-09-10 11:00:00 | ES | Futures | 5746.63 | 5759.22 | 5720.94 | 5721.73 | 182793.0 |
| 2024-09-10 12:00:00 | ES | Futures | 5721.73 | 5739.29 | 5713.34 | 5732.21 | 174775.0 |
| 2024-09-10 13:00:00 | ES | Futures | 5731.95 | 5753.45 | 5730.64 | 5751.35 | 127278.0 |
| 2024-09-10 14:00:00 | ES | Futures | 5751.35 | 5765.51 | 5751.35 | 5763.94 | 120774.0 |
| 2024-09-10 15:00:00 | ES | Futures | 5764.2 | 5773.9 | 5761.58 | 5769.7 | 209194.0 |
| 2024-09-10 16:00:00 | ES | Futures | 5769.7 | 5772.06 | 5763.15 | 5767.08 | 47565.0 |
| 2024-09-10 18:00:00 | ES | Futures | 5766.82 | 5767.61 | 5764.2 | 5767.08 | 4347.0 |
| 2024-09-10 19:00:00 | ES | Futures | 5766.82 | 5769.44 | 5762.36 | 5764.72 | 3273.0 |
| 2024-09-10 20:00:00 | ES | Futures | 5764.99 | 5766.3 | 5757.38 | 5759.48 | 6037.0 |
| 2024-09-10 21:00:00 | ES | Futures | 5759.74 | 5762.36 | 5745.32 | 5750.83 | 19290.0 |
| 2024-09-10 22:00:00 | ES | Futures | 5751.09 | 5754.24 | 5747.94 | 5751.88 | 11524.0 |
| 2024-09-10 23:00:00 | ES | Futures | 5751.88 | 5753.45 | 5741.39 | 5744.54 | 10794.0 |
| 2024-09-10 00:00:00 | NQ | Futures | 19695.73 | 19707.88 | 19652.44 | 19659.04 | 2806.0 |
| 2024-09-10 01:00:00 | NQ | Futures | 19659.3 | 19689.93 | 19652.97 | 19665.11 | 3072.0 |
| 2024-09-10 02:00:00 | NQ | Futures | 19666.17 | 19684.12 | 19644.79 | 19674.88 | 3496.0 |
| 2024-09-10 03:00:00 | NQ | Futures | 19676.73 | 19727.41 | 19654.03 | 19725.04 | 7411.0 |
| 2024-09-10 04:00:00 | NQ | Futures | 19724.77 | 19738.5 | 19677.26 | 19686.5 | 6463.0 |
| 2024-09-10 05:00:00 | NQ | Futures | 19685.7 | 19694.15 | 19621.56 | 19680.95 | 9825.0 |
| 2024-09-10 06:00:00 | NQ | Futures | 19681.74 | 19724.77 | 19656.67 | 19694.15 | 8268.0 |
| 2024-09-10 07:00:00 | NQ | Futures | 19693.36 | 19752.23 | 19693.09 | 19742.99 | 9585.0 |
| 2024-09-10 08:00:00 | NQ | Futures | 19743.25 | 19819.28 | 19739.03 | 19807.93 | 14741.0 |
| 2024-09-10 09:00:00 | NQ | Futures | 19807.66 | 19874.45 | 19768.86 | 19811.89 | 77984.0 |
| 2024-09-10 10:00:00 | NQ | Futures | 19812.15 | 19869.43 | 19717.65 | 19776.25 | 89913.0 |
| 2024-09-10 11:00:00 | NQ | Futures | 19775.99 | 19840.92 | 19663.53 | 19665.38 | 62425.0 |
| 2024-09-10 12:00:00 | NQ | Futures | 19665.38 | 19765.69 | 19629.47 | 19734.01 | 55656.0 |
| 2024-09-10 13:00:00 | NQ | Futures | 19733.22 | 19846.73 | 19729.26 | 19838.02 | 43076.0 |
| 2024-09-10 14:00:00 | NQ | Futures | 19838.02 | 19901.64 | 19838.02 | 19875.77 | 41023.0 |
| 2024-09-10 15:00:00 | NQ | Futures | 19875.77 | 19934.37 | 19871.02 | 19909.3 | 52140.0 |
| 2024-09-10 16:00:00 | NQ | Futures | 19909.56 | 19920.65 | 19873.39 | 19888.44 | 14390.0 |
| 2024-09-10 18:00:00 | NQ | Futures | 19891.35 | 19901.9 | 19879.2 | 19899.0 | 2439.0 |
| 2024-09-10 19:00:00 | NQ | Futures | 19897.95 | 19911.67 | 19875.77 | 19890.29 | 2455.0 |
| 2024-09-10 20:00:00 | NQ | Futures | 19891.08 | 19898.21 | 19854.39 | 19863.89 | 4853.0 |
| 2024-09-10 21:00:00 | NQ | Futures | 19863.89 | 19878.67 | 19797.63 | 19828.25 | 9304.0 |
| 2024-09-10 22:00:00 | NQ | Futures | 19828.52 | 19851.48 | 19815.58 | 19835.91 | 4382.0 |
| 2024-09-10 23:00:00 | NQ | Futures | 19837.23 | 19849.11 | 19781.53 | 19800.27 | 5188.0 |
| 2024-09-10 00:00:00 | YM | Futures | 42919.1 | 42927.5 | 42879.2 | 42887.6 | 574.0 |
| 2024-09-10 01:00:00 | YM | Futures | 42889.7 | 42905.4 | 42869.7 | 42892.8 | 817.0 |
| 2024-09-10 02:00:00 | YM | Futures | 42892.8 | 42903.3 | 42857.1 | 42897.0 | 1085.0 |
| 2024-09-10 03:00:00 | YM | Futures | 42896.0 | 42990.5 | 42865.5 | 42985.3 | 1970.0 |
> showing 50 of 1,888 rows — these rows as CSV