PREVIEW / futures_1hour / 2025-03-17
file: by_date/futures_1hour/2025/2025-03-17.parquet size: 67 KB rows: 2,084
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-17 00:00:00 | ES | Futures | 5752.99 | 5756.8 | 5751.72 | 5754.01 | 2220.0 |
| 2025-03-17 01:00:00 | ES | Futures | 5754.01 | 5755.79 | 5752.48 | 5753.5 | 1292.0 |
| 2025-03-17 02:00:00 | ES | Futures | 5753.24 | 5754.77 | 5745.12 | 5749.18 | 3075.0 |
| 2025-03-17 03:00:00 | ES | Futures | 5749.43 | 5753.5 | 5742.83 | 5752.99 | 4542.0 |
| 2025-03-17 04:00:00 | ES | Futures | 5753.24 | 5758.83 | 5746.64 | 5757.06 | 10305.0 |
| 2025-03-17 05:00:00 | ES | Futures | 5756.8 | 5761.88 | 5754.26 | 5758.33 | 6859.0 |
| 2025-03-17 06:00:00 | ES | Futures | 5758.07 | 5773.31 | 5756.04 | 5771.79 | 6449.0 |
| 2025-03-17 07:00:00 | ES | Futures | 5771.79 | 5778.9 | 5768.23 | 5768.74 | 11232.0 |
| 2025-03-17 08:00:00 | ES | Futures | 5768.49 | 5793.64 | 5759.6 | 5786.02 | 29300.0 |
| 2025-03-17 09:00:00 | ES | Futures | 5785.76 | 5818.79 | 5775.85 | 5811.67 | 108066.0 |
| 2025-03-17 10:00:00 | ES | Futures | 5811.42 | 5817.52 | 5790.84 | 5794.15 | 119772.0 |
| 2025-03-17 11:00:00 | ES | Futures | 5794.15 | 5806.85 | 5781.7 | 5792.37 | 84568.0 |
| 2025-03-17 12:00:00 | ES | Futures | 5792.37 | 5806.85 | 5786.52 | 5799.99 | 63831.0 |
| 2025-03-17 13:00:00 | ES | Futures | 5800.24 | 5829.2 | 5793.13 | 5826.15 | 67361.0 |
| 2025-03-17 14:00:00 | ES | Futures | 5826.15 | 5852.83 | 5825.9 | 5847.49 | 80243.0 |
| 2025-03-17 15:00:00 | ES | Futures | 5847.24 | 5848.76 | 5823.11 | 5825.39 | 147001.0 |
| 2025-03-17 16:00:00 | ES | Futures | 5825.14 | 5826.41 | 5818.28 | 5824.38 | 41210.0 |
| 2025-03-17 18:00:00 | ES | Futures | 5824.12 | 5830.98 | 5822.85 | 5830.22 | 6480.0 |
| 2025-03-17 19:00:00 | ES | Futures | 5830.22 | 5830.73 | 5822.85 | 5824.12 | 4904.0 |
| 2025-03-17 20:00:00 | ES | Futures | 5824.38 | 5825.9 | 5817.01 | 5819.8 | 6936.0 |
| 2025-03-17 21:00:00 | ES | Futures | 5820.06 | 5822.6 | 5809.13 | 5810.15 | 7374.0 |
| 2025-03-17 22:00:00 | ES | Futures | 5810.15 | 5812.69 | 5808.63 | 5811.17 | 3831.0 |
| 2025-03-17 23:00:00 | ES | Futures | 5811.17 | 5811.93 | 5803.8 | 5805.07 | 3537.0 |
| 2025-03-17 00:00:00 | NQ | Futures | 20163.15 | 20184.54 | 20162.39 | 20174.61 | 1450.0 |
| 2025-03-17 01:00:00 | NQ | Futures | 20175.38 | 20178.69 | 20164.43 | 20173.59 | 880.0 |
| 2025-03-17 02:00:00 | NQ | Futures | 20172.07 | 20180.72 | 20139.98 | 20156.02 | 1827.0 |
| 2025-03-17 03:00:00 | NQ | Futures | 20154.49 | 20174.1 | 20132.09 | 20170.79 | 3097.0 |
| 2025-03-17 04:00:00 | NQ | Futures | 20171.81 | 20206.44 | 20153.22 | 20198.55 | 5372.0 |
| 2025-03-17 05:00:00 | NQ | Futures | 20197.28 | 20216.38 | 20183.52 | 20205.43 | 3741.0 |
| 2025-03-17 06:00:00 | NQ | Futures | 20203.9 | 20270.11 | 20196.51 | 20261.96 | 4421.0 |
| 2025-03-17 07:00:00 | NQ | Futures | 20260.18 | 20297.86 | 20257.63 | 20264.5 | 4559.0 |
| 2025-03-17 08:00:00 | NQ | Futures | 20264.5 | 20359.74 | 20237.0 | 20331.99 | 13185.0 |
| 2025-03-17 09:00:00 | NQ | Futures | 20331.48 | 20430.54 | 20262.98 | 20370.69 | 45490.0 |
| 2025-03-17 10:00:00 | NQ | Futures | 20369.93 | 20396.16 | 20246.68 | 20262.47 | 51555.0 |
| 2025-03-17 11:00:00 | NQ | Futures | 20262.98 | 20310.6 | 20202.11 | 20255.34 | 37000.0 |
| 2025-03-17 12:00:00 | NQ | Futures | 20256.61 | 20321.8 | 20228.85 | 20273.93 | 25044.0 |
| 2025-03-17 13:00:00 | NQ | Futures | 20273.93 | 20416.79 | 20246.93 | 20397.18 | 24375.0 |
| 2025-03-17 14:00:00 | NQ | Futures | 20396.92 | 20543.09 | 20396.16 | 20520.69 | 34658.0 |
| 2025-03-17 15:00:00 | NQ | Futures | 20520.43 | 20528.32 | 20404.82 | 20411.69 | 42782.0 |
| 2025-03-17 16:00:00 | NQ | Futures | 20411.18 | 20417.04 | 20376.3 | 20410.17 | 11941.0 |
| 2025-03-17 18:00:00 | NQ | Futures | 20413.99 | 20439.96 | 20406.09 | 20431.56 | 4929.0 |
| 2025-03-17 19:00:00 | NQ | Futures | 20431.56 | 20434.36 | 20397.69 | 20401.76 | 3388.0 |
| 2025-03-17 20:00:00 | NQ | Futures | 20401.25 | 20409.4 | 20362.8 | 20376.04 | 4295.0 |
| 2025-03-17 21:00:00 | NQ | Futures | 20376.55 | 20389.03 | 20324.6 | 20330.97 | 4618.0 |
| 2025-03-17 22:00:00 | NQ | Futures | 20330.46 | 20349.3 | 20327.4 | 20342.17 | 2184.0 |
| 2025-03-17 23:00:00 | NQ | Futures | 20341.92 | 20346.76 | 20304.99 | 20312.12 | 2415.0 |
| 2025-03-17 00:00:00 | YM | Futures | 42879.2 | 42895.7 | 42863.8 | 42880.3 | 413.0 |
| 2025-03-17 01:00:00 | YM | Futures | 42881.3 | 42901.9 | 42876.1 | 42880.3 | 214.0 |
| 2025-03-17 02:00:00 | YM | Futures | 42880.3 | 42885.4 | 42825.7 | 42853.5 | 744.0 |
| 2025-03-17 03:00:00 | YM | Futures | 42850.4 | 42882.3 | 42806.2 | 42881.3 | 1182.0 |
> showing 50 of 2,084 rows — these rows as CSV