PREVIEW / futures_1hour / 2025-12-18
file: by_date/futures_1hour/2025/2025-12-18.parquet size: 65 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-12-18 00:00:00 | ES | Futures | 6839.65 | 6840.41 | 6833.86 | 6836.88 | 6393.0 |
| 2025-12-18 01:00:00 | ES | Futures | 6836.88 | 6838.64 | 6831.59 | 6837.13 | 8195.0 |
| 2025-12-18 02:00:00 | ES | Futures | 6837.13 | 6846.7 | 6836.88 | 6844.69 | 8452.0 |
| 2025-12-18 03:00:00 | ES | Futures | 6844.69 | 6852.25 | 6840.16 | 6849.47 | 16134.0 |
| 2025-12-18 04:00:00 | ES | Futures | 6849.47 | 6859.05 | 6846.2 | 6858.54 | 12170.0 |
| 2025-12-18 05:00:00 | ES | Futures | 6858.54 | 6859.55 | 6853.76 | 6856.53 | 8562.0 |
| 2025-12-18 06:00:00 | ES | Futures | 6856.53 | 6863.08 | 6855.52 | 6862.32 | 9356.0 |
| 2025-12-18 07:00:00 | ES | Futures | 6862.32 | 6863.33 | 6854.76 | 6856.28 | 12286.0 |
| 2025-12-18 08:00:00 | ES | Futures | 6856.28 | 6889.27 | 6852.25 | 6880.71 | 73457.0 |
| 2025-12-18 09:00:00 | ES | Futures | 6880.46 | 6901.87 | 6871.89 | 6896.07 | 240993.0 |
| 2025-12-18 10:00:00 | ES | Futures | 6896.07 | 6922.27 | 6876.43 | 6916.48 | 303767.0 |
| 2025-12-18 11:00:00 | ES | Futures | 6916.22 | 6923.78 | 6909.17 | 6911.69 | 174055.0 |
| 2025-12-18 12:00:00 | ES | Futures | 6911.44 | 6911.69 | 6863.08 | 6898.84 | 354680.0 |
| 2025-12-18 13:00:00 | ES | Futures | 6898.84 | 6912.45 | 6890.78 | 6897.33 | 153876.0 |
| 2025-12-18 14:00:00 | ES | Futures | 6897.33 | 6897.84 | 6867.61 | 6871.89 | 194818.0 |
| 2025-12-18 15:00:00 | ES | Futures | 6871.89 | 6901.61 | 6869.12 | 6879.95 | 273418.0 |
| 2025-12-18 16:00:00 | ES | Futures | 6879.95 | 6881.21 | 6871.39 | 6874.16 | 55478.0 |
| 2025-12-18 18:00:00 | ES | Futures | 6876.17 | 6881.21 | 6871.39 | 6881.21 | 7511.0 |
| 2025-12-18 19:00:00 | ES | Futures | 6881.46 | 6882.72 | 6874.16 | 6879.7 | 6488.0 |
| 2025-12-18 20:00:00 | ES | Futures | 6879.7 | 6884.49 | 6873.66 | 6881.97 | 8908.0 |
| 2025-12-18 21:00:00 | ES | Futures | 6881.72 | 6884.74 | 6876.93 | 6877.43 | 7408.0 |
| 2025-12-18 22:00:00 | ES | Futures | 6877.18 | 6888.26 | 6873.91 | 6886.0 | 9353.0 |
| 2025-12-18 23:00:00 | ES | Futures | 6886.0 | 6888.01 | 6882.22 | 6885.49 | 4253.0 |
| 2025-12-18 00:00:00 | NQ | Futures | 25205.41 | 25213.23 | 25183.97 | 25203.9 | 2892.0 |
| 2025-12-18 01:00:00 | NQ | Futures | 25203.39 | 25209.95 | 25172.12 | 25201.63 | 3223.0 |
| 2025-12-18 02:00:00 | NQ | Futures | 25202.63 | 25260.39 | 25201.12 | 25250.8 | 6754.0 |
| 2025-12-18 03:00:00 | NQ | Futures | 25249.29 | 25292.41 | 25227.1 | 25274.51 | 6421.0 |
| 2025-12-18 04:00:00 | NQ | Futures | 25274.26 | 25316.88 | 25250.05 | 25316.12 | 5214.0 |
| 2025-12-18 05:00:00 | NQ | Futures | 25316.37 | 25319.15 | 25284.85 | 25298.72 | 3531.0 |
| 2025-12-18 06:00:00 | NQ | Futures | 25298.47 | 25323.69 | 25293.93 | 25319.65 | 3435.0 |
| 2025-12-18 07:00:00 | NQ | Futures | 25321.16 | 25334.28 | 25304.52 | 25313.35 | 5241.0 |
| 2025-12-18 08:00:00 | NQ | Futures | 25314.35 | 25485.09 | 25284.09 | 25443.73 | 31942.0 |
| 2025-12-18 09:00:00 | NQ | Futures | 25442.21 | 25551.16 | 25381.44 | 25498.7 | 101217.0 |
| 2025-12-18 10:00:00 | NQ | Futures | 25498.7 | 25629.59 | 25395.05 | 25587.73 | 107205.0 |
| 2025-12-18 11:00:00 | NQ | Futures | 25588.23 | 25634.88 | 25565.03 | 25608.66 | 56982.0 |
| 2025-12-18 12:00:00 | NQ | Futures | 25608.91 | 25608.91 | 25404.89 | 25577.13 | 97478.0 |
| 2025-12-18 13:00:00 | NQ | Futures | 25577.39 | 25624.55 | 25538.8 | 25560.24 | 47176.0 |
| 2025-12-18 14:00:00 | NQ | Futures | 25559.73 | 25561.75 | 25414.22 | 25428.85 | 65867.0 |
| 2025-12-18 15:00:00 | NQ | Futures | 25429.1 | 25565.28 | 25412.96 | 25472.48 | 67483.0 |
| 2025-12-18 16:00:00 | NQ | Futures | 25472.98 | 25478.28 | 25416.99 | 25439.69 | 16309.0 |
| 2025-12-18 18:00:00 | NQ | Futures | 25460.88 | 25478.53 | 25430.36 | 25478.02 | 5560.0 |
| 2025-12-18 19:00:00 | NQ | Futures | 25478.28 | 25487.61 | 25441.2 | 25464.15 | 5146.0 |
| 2025-12-18 20:00:00 | NQ | Futures | 25464.91 | 25498.45 | 25431.87 | 25487.86 | 6128.0 |
| 2025-12-18 21:00:00 | NQ | Futures | 25487.35 | 25508.03 | 25470.96 | 25472.73 | 4484.0 |
| 2025-12-18 22:00:00 | NQ | Futures | 25471.97 | 25543.34 | 25456.84 | 25528.46 | 6429.0 |
| 2025-12-18 23:00:00 | NQ | Futures | 25529.47 | 25539.81 | 25507.53 | 25527.7 | 3028.0 |
| 2025-12-18 00:00:00 | YM | Futures | 48520.1 | 48524.1 | 48484.9 | 48495.9 | 999.0 |
| 2025-12-18 01:00:00 | YM | Futures | 48498.0 | 48515.1 | 48481.8 | 48503.0 | 395.0 |
| 2025-12-18 02:00:00 | YM | Futures | 48503.0 | 48531.2 | 48501.0 | 48524.1 | 702.0 |
| 2025-12-18 03:00:00 | YM | Futures | 48523.1 | 48558.3 | 48503.0 | 48552.3 | 1153.0 |
> showing 50 of 2,101 rows — these rows as CSV