PREVIEW / futures_1hour / 2025-03-20
file: by_date/futures_1hour/2025/2025-03-20.parquet size: 67 KB rows: 2,089
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-20 00:00:00 | ES | Futures | 5849.78 | 5851.56 | 5847.24 | 5849.02 | 2593.0 |
| 2025-03-20 01:00:00 | ES | Futures | 5849.27 | 5851.3 | 5847.49 | 5851.05 | 2639.0 |
| 2025-03-20 02:00:00 | ES | Futures | 5850.8 | 5851.81 | 5842.92 | 5844.19 | 5424.0 |
| 2025-03-20 03:00:00 | ES | Futures | 5843.94 | 5849.27 | 5841.65 | 5842.41 | 6803.0 |
| 2025-03-20 04:00:00 | ES | Futures | 5842.41 | 5851.05 | 5842.41 | 5846.73 | 15231.0 |
| 2025-03-20 05:00:00 | ES | Futures | 5846.99 | 5847.49 | 5818.53 | 5822.34 | 31315.0 |
| 2025-03-20 06:00:00 | ES | Futures | 5822.6 | 5823.11 | 5774.33 | 5793.13 | 63074.0 |
| 2025-03-20 07:00:00 | ES | Futures | 5793.13 | 5804.31 | 5787.79 | 5803.04 | 26743.0 |
| 2025-03-20 08:00:00 | ES | Futures | 5803.29 | 5804.31 | 5793.38 | 5794.15 | 28920.0 |
| 2025-03-20 09:00:00 | ES | Futures | 5794.4 | 5819.04 | 5776.36 | 5817.77 | 161637.0 |
| 2025-03-20 10:00:00 | ES | Futures | 5818.03 | 5858.42 | 5815.99 | 5846.22 | 226962.0 |
| 2025-03-20 11:00:00 | ES | Futures | 5846.22 | 5851.3 | 5828.19 | 5833.27 | 148221.0 |
| 2025-03-20 12:00:00 | ES | Futures | 5833.27 | 5846.22 | 5807.1 | 5809.9 | 180275.0 |
| 2025-03-20 13:00:00 | ES | Futures | 5809.64 | 5823.61 | 5796.69 | 5802.02 | 144679.0 |
| 2025-03-20 14:00:00 | ES | Futures | 5802.02 | 5812.44 | 5787.03 | 5794.4 | 144178.0 |
| 2025-03-20 15:00:00 | ES | Futures | 5794.65 | 5817.26 | 5793.64 | 5806.85 | 232125.0 |
| 2025-03-20 16:00:00 | ES | Futures | 5806.85 | 5811.42 | 5805.07 | 5808.88 | 52221.0 |
| 2025-03-20 18:00:00 | ES | Futures | 5807.61 | 5812.18 | 5806.09 | 5807.36 | 3826.0 |
| 2025-03-20 19:00:00 | ES | Futures | 5807.36 | 5807.61 | 5798.46 | 5807.1 | 6472.0 |
| 2025-03-20 20:00:00 | ES | Futures | 5806.59 | 5815.23 | 5804.82 | 5811.93 | 6292.0 |
| 2025-03-20 21:00:00 | ES | Futures | 5811.67 | 5816.25 | 5807.86 | 5814.72 | 5651.0 |
| 2025-03-20 22:00:00 | ES | Futures | 5814.72 | 5815.48 | 5807.86 | 5811.42 | 5154.0 |
| 2025-03-20 23:00:00 | ES | Futures | 5811.67 | 5811.67 | 5804.31 | 5806.34 | 5849.0 |
| 2025-03-20 00:00:00 | NQ | Futures | 20457.28 | 20465.93 | 20442.0 | 20453.71 | 1994.0 |
| 2025-03-20 01:00:00 | NQ | Futures | 20453.71 | 20463.9 | 20440.47 | 20461.86 | 1698.0 |
| 2025-03-20 02:00:00 | NQ | Futures | 20461.61 | 20462.88 | 20417.04 | 20423.41 | 3607.0 |
| 2025-03-20 03:00:00 | NQ | Futures | 20422.64 | 20449.38 | 20408.89 | 20414.24 | 4516.0 |
| 2025-03-20 04:00:00 | NQ | Futures | 20414.5 | 20446.84 | 20413.73 | 20428.25 | 6270.0 |
| 2025-03-20 05:00:00 | NQ | Futures | 20429.01 | 20432.32 | 20306.27 | 20325.88 | 13146.0 |
| 2025-03-20 06:00:00 | NQ | Futures | 20326.64 | 20327.4 | 20102.55 | 20184.03 | 33796.0 |
| 2025-03-20 07:00:00 | NQ | Futures | 20184.29 | 20231.65 | 20162.9 | 20221.72 | 13210.0 |
| 2025-03-20 08:00:00 | NQ | Futures | 20222.74 | 20231.15 | 20192.18 | 20196.26 | 12704.0 |
| 2025-03-20 09:00:00 | NQ | Futures | 20196.77 | 20311.11 | 20123.68 | 20303.72 | 64422.0 |
| 2025-03-20 10:00:00 | NQ | Futures | 20305.25 | 20479.18 | 20297.1 | 20416.53 | 88567.0 |
| 2025-03-20 11:00:00 | NQ | Futures | 20416.02 | 20436.4 | 20336.57 | 20357.71 | 60838.0 |
| 2025-03-20 12:00:00 | NQ | Futures | 20357.71 | 20412.97 | 20228.85 | 20245.66 | 68246.0 |
| 2025-03-20 13:00:00 | NQ | Futures | 20245.41 | 20313.14 | 20194.98 | 20217.9 | 49294.0 |
| 2025-03-20 14:00:00 | NQ | Futures | 20218.16 | 20268.83 | 20163.41 | 20188.36 | 47691.0 |
| 2025-03-20 15:00:00 | NQ | Futures | 20188.62 | 20292.52 | 20183.52 | 20250.75 | 64303.0 |
| 2025-03-20 16:00:00 | NQ | Futures | 20251.52 | 20283.6 | 20249.48 | 20264.5 | 12482.0 |
| 2025-03-20 18:00:00 | NQ | Futures | 20268.83 | 20280.29 | 20249.99 | 20258.39 | 2706.0 |
| 2025-03-20 19:00:00 | NQ | Futures | 20257.88 | 20259.92 | 20216.63 | 20256.36 | 4523.0 |
| 2025-03-20 20:00:00 | NQ | Futures | 20255.85 | 20298.12 | 20250.24 | 20283.86 | 4852.0 |
| 2025-03-20 21:00:00 | NQ | Futures | 20283.6 | 20303.72 | 20269.85 | 20295.57 | 3179.0 |
| 2025-03-20 22:00:00 | NQ | Futures | 20296.08 | 20300.41 | 20260.94 | 20272.65 | 3557.0 |
| 2025-03-20 23:00:00 | NQ | Futures | 20274.18 | 20274.69 | 20234.2 | 20244.39 | 4345.0 |
| 2025-03-20 00:00:00 | YM | Futures | 43690.2 | 43702.6 | 43680.9 | 43684.0 | 356.0 |
| 2025-03-20 01:00:00 | YM | Futures | 43684.0 | 43704.6 | 43678.9 | 43701.5 | 239.0 |
| 2025-03-20 02:00:00 | YM | Futures | 43699.5 | 43707.7 | 43668.6 | 43669.6 | 466.0 |
| 2025-03-20 03:00:00 | YM | Futures | 43669.6 | 43689.2 | 43644.9 | 43651.1 | 1042.0 |
> showing 50 of 2,089 rows — these rows as CSV