PREVIEW / futures_1hour / 2025-01-07
file: by_date/futures_1hour/2025/2025-01-07.parquet size: 68 KB rows: 2,101
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 |
|---|---|---|---|---|---|---|---|
| 2025-01-07 00:00:00 | ES | Futures | 6169.98 | 6171.01 | 6160.24 | 6168.19 | 6519.0 |
| 2025-01-07 01:00:00 | ES | Futures | 6168.19 | 6170.5 | 6163.57 | 6164.86 | 3716.0 |
| 2025-01-07 02:00:00 | ES | Futures | 6164.86 | 6171.78 | 6164.6 | 6171.52 | 5843.0 |
| 2025-01-07 03:00:00 | ES | Futures | 6171.52 | 6180.24 | 6166.14 | 6177.42 | 14067.0 |
| 2025-01-07 04:00:00 | ES | Futures | 6177.67 | 6181.52 | 6171.78 | 6173.32 | 9297.0 |
| 2025-01-07 05:00:00 | ES | Futures | 6173.32 | 6182.29 | 6171.01 | 6181.52 | 6394.0 |
| 2025-01-07 06:00:00 | ES | Futures | 6181.78 | 6183.31 | 6174.85 | 6177.67 | 8453.0 |
| 2025-01-07 07:00:00 | ES | Futures | 6177.93 | 6186.39 | 6174.6 | 6181.26 | 14294.0 |
| 2025-01-07 08:00:00 | ES | Futures | 6181.26 | 6191.52 | 6179.73 | 6191.52 | 21211.0 |
| 2025-01-07 09:00:00 | ES | Futures | 6191.52 | 6199.72 | 6182.29 | 6185.88 | 146407.0 |
| 2025-01-07 10:00:00 | ES | Futures | 6185.11 | 6185.11 | 6121.78 | 6154.6 | 436574.0 |
| 2025-01-07 11:00:00 | ES | Futures | 6154.6 | 6157.68 | 6123.84 | 6126.14 | 246928.0 |
| 2025-01-07 12:00:00 | ES | Futures | 6126.14 | 6136.91 | 6114.86 | 6128.19 | 155160.0 |
| 2025-01-07 13:00:00 | ES | Futures | 6128.45 | 6143.83 | 6126.4 | 6129.73 | 113674.0 |
| 2025-01-07 14:00:00 | ES | Futures | 6129.48 | 6135.63 | 6117.68 | 6119.48 | 107164.0 |
| 2025-01-07 15:00:00 | ES | Futures | 6119.73 | 6120.76 | 6086.4 | 6106.91 | 306024.0 |
| 2025-01-07 16:00:00 | ES | Futures | 6107.17 | 6111.53 | 6105.38 | 6106.66 | 50871.0 |
| 2025-01-07 18:00:00 | ES | Futures | 6107.43 | 6110.76 | 6099.99 | 6110.25 | 8801.0 |
| 2025-01-07 19:00:00 | ES | Futures | 6109.99 | 6115.89 | 6108.97 | 6114.09 | 6944.0 |
| 2025-01-07 20:00:00 | ES | Futures | 6114.09 | 6120.76 | 6112.55 | 6120.25 | 7505.0 |
| 2025-01-07 21:00:00 | ES | Futures | 6119.99 | 6122.3 | 6115.37 | 6119.22 | 5913.0 |
| 2025-01-07 22:00:00 | ES | Futures | 6118.96 | 6119.99 | 6113.84 | 6117.68 | 4814.0 |
| 2025-01-07 23:00:00 | ES | Futures | 6117.94 | 6121.02 | 6115.12 | 6116.66 | 4311.0 |
| 2025-01-07 00:00:00 | NQ | Futures | 22358.54 | 22366.0 | 22297.55 | 22344.13 | 6222.0 |
| 2025-01-07 01:00:00 | NQ | Futures | 22343.1 | 22354.16 | 22321.48 | 22328.17 | 3630.0 |
| 2025-01-07 02:00:00 | NQ | Futures | 22327.66 | 22371.66 | 22325.85 | 22367.29 | 5073.0 |
| 2025-01-07 03:00:00 | NQ | Futures | 22367.29 | 22405.12 | 22343.35 | 22397.14 | 8060.0 |
| 2025-01-07 04:00:00 | NQ | Futures | 22396.88 | 22414.38 | 22362.65 | 22366.0 | 7604.0 |
| 2025-01-07 05:00:00 | NQ | Futures | 22366.77 | 22410.78 | 22355.19 | 22407.95 | 5001.0 |
| 2025-01-07 06:00:00 | NQ | Futures | 22407.69 | 22411.29 | 22358.79 | 22375.01 | 6251.0 |
| 2025-01-07 07:00:00 | NQ | Futures | 22375.26 | 22403.32 | 22356.99 | 22384.53 | 7111.0 |
| 2025-01-07 08:00:00 | NQ | Futures | 22383.76 | 22419.01 | 22369.86 | 22418.24 | 9504.0 |
| 2025-01-07 09:00:00 | NQ | Futures | 22418.24 | 22446.81 | 22332.8 | 22347.73 | 74427.0 |
| 2025-01-07 10:00:00 | NQ | Futures | 22348.24 | 22348.24 | 22028.36 | 22183.03 | 165597.0 |
| 2025-01-07 11:00:00 | NQ | Futures | 22181.74 | 22207.22 | 22055.13 | 22064.9 | 84998.0 |
| 2025-01-07 12:00:00 | NQ | Futures | 22065.68 | 22106.85 | 22015.49 | 22075.2 | 51588.0 |
| 2025-01-07 13:00:00 | NQ | Futures | 22075.71 | 22149.57 | 22057.44 | 22070.05 | 39518.0 |
| 2025-01-07 14:00:00 | NQ | Futures | 22069.28 | 22105.82 | 22031.96 | 22046.89 | 39134.0 |
| 2025-01-07 15:00:00 | NQ | Futures | 22047.15 | 22052.55 | 21904.83 | 21986.67 | 80701.0 |
| 2025-01-07 16:00:00 | NQ | Futures | 21986.67 | 22023.21 | 21985.9 | 22003.66 | 15405.0 |
| 2025-01-07 18:00:00 | NQ | Futures | 22009.06 | 22024.5 | 21971.74 | 22020.9 | 5370.0 |
| 2025-01-07 19:00:00 | NQ | Futures | 22022.18 | 22043.54 | 22016.52 | 22034.79 | 4310.0 |
| 2025-01-07 20:00:00 | NQ | Futures | 22035.82 | 22065.16 | 22023.47 | 22059.76 | 4663.0 |
| 2025-01-07 21:00:00 | NQ | Futures | 22058.73 | 22066.96 | 22030.93 | 22048.95 | 4057.0 |
| 2025-01-07 22:00:00 | NQ | Futures | 22048.43 | 22053.84 | 22018.32 | 22035.05 | 4082.0 |
| 2025-01-07 23:00:00 | NQ | Futures | 22036.08 | 22048.69 | 22012.92 | 22022.44 | 2956.0 |
| 2025-01-07 00:00:00 | YM | Futures | 44218.3 | 44221.4 | 44180.2 | 44218.3 | 973.0 |
| 2025-01-07 01:00:00 | YM | Futures | 44215.2 | 44224.5 | 44195.7 | 44220.4 | 1063.0 |
| 2025-01-07 02:00:00 | YM | Futures | 44221.4 | 44237.9 | 44193.6 | 44236.8 | 1888.0 |
| 2025-01-07 03:00:00 | YM | Futures | 44237.9 | 44298.6 | 44198.7 | 44278.0 | 4678.0 |
> showing 50 of 2,101 rows — these rows as CSV