PREVIEW / futures_1hour / 2025-01-23
file: by_date/futures_1hour/2025/2025-01-23.parquet size: 69 KB rows: 2,098
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-23 00:00:00 | ES | Futures | 6272.02 | 6273.05 | 6269.46 | 6269.71 | 2117.0 |
| 2025-01-23 01:00:00 | ES | Futures | 6269.46 | 6272.02 | 6267.41 | 6268.43 | 2727.0 |
| 2025-01-23 02:00:00 | ES | Futures | 6268.69 | 6269.46 | 6264.07 | 6265.87 | 6269.0 |
| 2025-01-23 03:00:00 | ES | Futures | 6265.61 | 6266.89 | 6258.43 | 6260.74 | 13805.0 |
| 2025-01-23 04:00:00 | ES | Futures | 6260.74 | 6265.87 | 6257.15 | 6264.59 | 11989.0 |
| 2025-01-23 05:00:00 | ES | Futures | 6264.33 | 6268.69 | 6262.28 | 6262.54 | 10444.0 |
| 2025-01-23 06:00:00 | ES | Futures | 6262.54 | 6269.46 | 6261.77 | 6268.18 | 8659.0 |
| 2025-01-23 07:00:00 | ES | Futures | 6268.43 | 6271.25 | 6263.56 | 6271.0 | 11823.0 |
| 2025-01-23 08:00:00 | ES | Futures | 6271.0 | 6273.82 | 6265.61 | 6270.74 | 25685.0 |
| 2025-01-23 09:00:00 | ES | Futures | 6271.0 | 6275.1 | 6267.15 | 6274.33 | 116483.0 |
| 2025-01-23 10:00:00 | ES | Futures | 6274.59 | 6281.25 | 6267.92 | 6280.99 | 129613.0 |
| 2025-01-23 11:00:00 | ES | Futures | 6280.99 | 6291.25 | 6275.87 | 6284.84 | 167518.0 |
| 2025-01-23 12:00:00 | ES | Futures | 6284.84 | 6289.46 | 6280.99 | 6289.2 | 70888.0 |
| 2025-01-23 13:00:00 | ES | Futures | 6289.2 | 6295.61 | 6288.17 | 6290.22 | 73251.0 |
| 2025-01-23 14:00:00 | ES | Futures | 6290.22 | 6293.04 | 6285.61 | 6290.99 | 82272.0 |
| 2025-01-23 15:00:00 | ES | Futures | 6290.74 | 6310.99 | 6288.94 | 6310.48 | 210917.0 |
| 2025-01-23 16:00:00 | ES | Futures | 6310.48 | 6310.73 | 6303.3 | 6305.35 | 86391.0 |
| 2025-01-23 18:00:00 | ES | Futures | 6304.84 | 6305.86 | 6302.02 | 6304.84 | 5294.0 |
| 2025-01-23 19:00:00 | ES | Futures | 6304.84 | 6305.35 | 6302.02 | 6303.56 | 6158.0 |
| 2025-01-23 20:00:00 | ES | Futures | 6303.81 | 6307.4 | 6302.53 | 6304.84 | 16089.0 |
| 2025-01-23 21:00:00 | ES | Futures | 6304.84 | 6312.79 | 6303.81 | 6311.5 | 14220.0 |
| 2025-01-23 22:00:00 | ES | Futures | 6311.5 | 6313.04 | 6301.76 | 6304.07 | 7183.0 |
| 2025-01-23 23:00:00 | ES | Futures | 6304.07 | 6305.35 | 6300.48 | 6303.04 | 4587.0 |
| 2025-01-23 00:00:00 | NQ | Futures | 22608.94 | 22614.6 | 22595.55 | 22597.61 | 1770.0 |
| 2025-01-23 01:00:00 | NQ | Futures | 22598.64 | 22609.96 | 22579.08 | 22587.06 | 2707.0 |
| 2025-01-23 02:00:00 | NQ | Futures | 22587.83 | 22592.72 | 22557.72 | 22564.67 | 4266.0 |
| 2025-01-23 03:00:00 | NQ | Futures | 22564.67 | 22570.33 | 22505.48 | 22523.75 | 9116.0 |
| 2025-01-23 04:00:00 | NQ | Futures | 22523.75 | 22545.11 | 22497.76 | 22537.39 | 8349.0 |
| 2025-01-23 05:00:00 | NQ | Futures | 22537.14 | 22550.77 | 22520.67 | 22524.01 | 5226.0 |
| 2025-01-23 06:00:00 | NQ | Futures | 22522.98 | 22547.69 | 22516.55 | 22541.51 | 5863.0 |
| 2025-01-23 07:00:00 | NQ | Futures | 22542.03 | 22548.72 | 22515.26 | 22543.83 | 7025.0 |
| 2025-01-23 08:00:00 | NQ | Futures | 22543.05 | 22563.64 | 22519.38 | 22539.71 | 16688.0 |
| 2025-01-23 09:00:00 | NQ | Futures | 22539.97 | 22562.1 | 22508.57 | 22541.0 | 61156.0 |
| 2025-01-23 10:00:00 | NQ | Futures | 22541.51 | 22586.29 | 22510.89 | 22575.99 | 61938.0 |
| 2025-01-23 11:00:00 | NQ | Futures | 22576.51 | 22617.17 | 22540.22 | 22592.72 | 71469.0 |
| 2025-01-23 12:00:00 | NQ | Futures | 22593.24 | 22593.24 | 22543.83 | 22583.2 | 37233.0 |
| 2025-01-23 13:00:00 | NQ | Futures | 22583.2 | 22631.07 | 22576.25 | 22599.93 | 37369.0 |
| 2025-01-23 14:00:00 | NQ | Futures | 22599.93 | 22608.94 | 22568.02 | 22599.16 | 34143.0 |
| 2025-01-23 15:00:00 | NQ | Futures | 22598.9 | 22691.54 | 22588.35 | 22689.48 | 61940.0 |
| 2025-01-23 16:00:00 | NQ | Futures | 22689.74 | 22698.49 | 22655.51 | 22668.9 | 19282.0 |
| 2025-01-23 18:00:00 | NQ | Futures | 22665.55 | 22665.55 | 22642.13 | 22657.06 | 3461.0 |
| 2025-01-23 19:00:00 | NQ | Futures | 22658.09 | 22661.18 | 22641.1 | 22654.74 | 6985.0 |
| 2025-01-23 20:00:00 | NQ | Futures | 22654.74 | 22681.51 | 22648.31 | 22656.8 | 19259.0 |
| 2025-01-23 21:00:00 | NQ | Futures | 22657.06 | 22706.73 | 22653.46 | 22697.46 | 13783.0 |
| 2025-01-23 22:00:00 | NQ | Futures | 22697.21 | 22706.73 | 22636.73 | 22649.6 | 5890.0 |
| 2025-01-23 23:00:00 | NQ | Futures | 22649.6 | 22655.51 | 22625.15 | 22641.88 | 4252.0 |
| 2025-01-23 00:00:00 | YM | Futures | 45638.7 | 45645.9 | 45624.3 | 45625.3 | 263.0 |
| 2025-01-23 01:00:00 | YM | Futures | 45626.3 | 45639.7 | 45620.2 | 45622.2 | 368.0 |
| 2025-01-23 02:00:00 | YM | Futures | 45626.3 | 45631.5 | 45607.8 | 45629.4 | 698.0 |
| 2025-01-23 03:00:00 | YM | Futures | 45629.4 | 45644.9 | 45606.8 | 45615.0 | 1497.0 |
> showing 50 of 2,098 rows — these rows as CSV