PREVIEW / futures_1hour / 2025-03-19
file: by_date/futures_1hour/2025/2025-03-19.parquet size: 68 KB rows: 2,074
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-03-19 00:00:00 | ES | Futures | 5772.3 | 5773.06 | 5766.46 | 5767.73 | 4129.0 |
| 2025-03-19 01:00:00 | ES | Futures | 5767.73 | 5773.31 | 5764.93 | 5767.73 | 5230.0 |
| 2025-03-19 02:00:00 | ES | Futures | 5767.73 | 5768.23 | 5762.64 | 5767.73 | 3855.0 |
| 2025-03-19 03:00:00 | ES | Futures | 5767.73 | 5767.73 | 5748.93 | 5753.24 | 12433.0 |
| 2025-03-19 04:00:00 | ES | Futures | 5752.99 | 5771.03 | 5752.74 | 5765.18 | 15681.0 |
| 2025-03-19 05:00:00 | ES | Futures | 5764.68 | 5776.11 | 5759.85 | 5774.84 | 14633.0 |
| 2025-03-19 06:00:00 | ES | Futures | 5774.58 | 5779.67 | 5771.79 | 5774.84 | 9583.0 |
| 2025-03-19 07:00:00 | ES | Futures | 5774.33 | 5780.43 | 5770.27 | 5776.36 | 19420.0 |
| 2025-03-19 08:00:00 | ES | Futures | 5776.11 | 5778.9 | 5766.96 | 5772.04 | 22991.0 |
| 2025-03-19 09:00:00 | ES | Futures | 5772.3 | 5796.69 | 5767.47 | 5791.86 | 128580.0 |
| 2025-03-19 10:00:00 | ES | Futures | 5791.61 | 5806.09 | 5784.75 | 5787.03 | 133801.0 |
| 2025-03-19 11:00:00 | ES | Futures | 5786.78 | 5815.74 | 5785.25 | 5810.4 | 108995.0 |
| 2025-03-19 12:00:00 | ES | Futures | 5810.4 | 5814.72 | 5798.46 | 5801.77 | 82092.0 |
| 2025-03-19 13:00:00 | ES | Futures | 5801.77 | 5804.05 | 5778.14 | 5783.22 | 100246.0 |
| 2025-03-19 14:00:00 | ES | Futures | 5783.22 | 5838.86 | 5773.82 | 5835.81 | 212962.0 |
| 2025-03-19 15:00:00 | ES | Futures | 5835.55 | 5863.75 | 5818.53 | 5823.36 | 368811.0 |
| 2025-03-19 16:00:00 | ES | Futures | 5823.61 | 5829.46 | 5821.84 | 5822.34 | 43889.0 |
| 2025-03-19 18:00:00 | ES | Futures | 5824.38 | 5840.63 | 5821.58 | 5836.82 | 8029.0 |
| 2025-03-19 19:00:00 | ES | Futures | 5836.82 | 5841.4 | 5834.54 | 5840.63 | 5914.0 |
| 2025-03-19 20:00:00 | ES | Futures | 5840.38 | 5845.72 | 5836.57 | 5844.19 | 4863.0 |
| 2025-03-19 21:00:00 | ES | Futures | 5843.94 | 5845.72 | 5838.86 | 5839.87 | 4304.0 |
| 2025-03-19 22:00:00 | ES | Futures | 5839.62 | 5848.0 | 5839.36 | 5846.22 | 6342.0 |
| 2025-03-19 23:00:00 | ES | Futures | 5846.22 | 5853.08 | 5846.22 | 5849.78 | 4695.0 |
| 2025-03-19 00:00:00 | NQ | Futures | 20130.56 | 20131.83 | 20098.22 | 20103.56 | 2198.0 |
| 2025-03-19 01:00:00 | NQ | Futures | 20104.07 | 20129.79 | 20089.05 | 20105.6 | 2636.0 |
| 2025-03-19 02:00:00 | NQ | Futures | 20104.58 | 20111.46 | 20083.7 | 20105.35 | 2593.0 |
| 2025-03-19 03:00:00 | NQ | Futures | 20106.11 | 20106.11 | 20025.89 | 20039.9 | 7044.0 |
| 2025-03-19 04:00:00 | NQ | Futures | 20039.14 | 20114.0 | 20037.86 | 20088.54 | 8513.0 |
| 2025-03-19 05:00:00 | NQ | Futures | 20088.03 | 20134.89 | 20072.24 | 20132.09 | 7297.0 |
| 2025-03-19 06:00:00 | NQ | Futures | 20130.81 | 20153.22 | 20116.04 | 20125.72 | 6739.0 |
| 2025-03-19 07:00:00 | NQ | Futures | 20125.72 | 20158.06 | 20115.53 | 20141.25 | 9097.0 |
| 2025-03-19 08:00:00 | NQ | Futures | 20140.49 | 20151.95 | 20109.93 | 20128.27 | 8924.0 |
| 2025-03-19 09:00:00 | NQ | Futures | 20129.28 | 20214.08 | 20073.01 | 20192.18 | 55866.0 |
| 2025-03-19 10:00:00 | NQ | Futures | 20192.18 | 20271.13 | 20156.28 | 20166.46 | 57404.0 |
| 2025-03-19 11:00:00 | NQ | Futures | 20166.46 | 20308.56 | 20158.31 | 20290.99 | 44876.0 |
| 2025-03-19 12:00:00 | NQ | Futures | 20290.48 | 20303.72 | 20223.25 | 20245.91 | 31455.0 |
| 2025-03-19 13:00:00 | NQ | Futures | 20245.66 | 20255.59 | 20153.73 | 20177.92 | 31699.0 |
| 2025-03-19 14:00:00 | NQ | Futures | 20177.92 | 20402.53 | 20136.92 | 20396.41 | 76590.0 |
| 2025-03-19 15:00:00 | NQ | Futures | 20396.41 | 20517.88 | 20305.76 | 20324.6 | 115724.0 |
| 2025-03-19 16:00:00 | NQ | Futures | 20324.86 | 20353.38 | 20311.36 | 20316.2 | 14010.0 |
| 2025-03-19 18:00:00 | NQ | Futures | 20321.04 | 20398.96 | 20315.44 | 20384.19 | 4584.0 |
| 2025-03-19 19:00:00 | NQ | Futures | 20384.7 | 20407.87 | 20375.53 | 20405.33 | 4182.0 |
| 2025-03-19 20:00:00 | NQ | Futures | 20404.31 | 20431.05 | 20383.94 | 20421.37 | 4057.0 |
| 2025-03-19 21:00:00 | NQ | Futures | 20420.61 | 20431.05 | 20397.69 | 20400.74 | 2927.0 |
| 2025-03-19 22:00:00 | NQ | Futures | 20401.0 | 20451.93 | 20400.49 | 20441.49 | 4230.0 |
| 2025-03-19 23:00:00 | NQ | Futures | 20442.0 | 20466.7 | 20442.0 | 20457.28 | 3103.0 |
| 2025-03-19 00:00:00 | YM | Futures | 43216.8 | 43216.8 | 43184.9 | 43195.2 | 430.0 |
| 2025-03-19 01:00:00 | YM | Futures | 43195.2 | 43221.9 | 43181.8 | 43199.3 | 507.0 |
| 2025-03-19 02:00:00 | YM | Futures | 43199.3 | 43202.4 | 43159.2 | 43195.2 | 591.0 |
| 2025-03-19 03:00:00 | YM | Futures | 43195.2 | 43195.2 | 43087.1 | 43125.2 | 1667.0 |
> showing 50 of 2,074 rows — these rows as CSV