PREVIEW / futures_1hour / 2024-08-08
file: by_date/futures_1hour/2024/2024-08-08.parquet size: 70 KB rows: 2,121
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 |
|---|---|---|---|---|---|---|---|
| 2024-08-08 00:00:00 | ES | Futures | 5484.99 | 5488.93 | 5471.89 | 5480.28 | 12034.0 |
| 2024-08-08 01:00:00 | ES | Futures | 5480.28 | 5486.83 | 5466.64 | 5467.17 | 11343.0 |
| 2024-08-08 02:00:00 | ES | Futures | 5467.17 | 5492.07 | 5464.02 | 5489.19 | 16022.0 |
| 2024-08-08 03:00:00 | ES | Futures | 5488.93 | 5489.98 | 5455.37 | 5460.61 | 27797.0 |
| 2024-08-08 04:00:00 | ES | Futures | 5460.35 | 5481.32 | 5458.25 | 5480.54 | 18551.0 |
| 2024-08-08 05:00:00 | ES | Futures | 5480.28 | 5486.3 | 5456.16 | 5463.76 | 15597.0 |
| 2024-08-08 06:00:00 | ES | Futures | 5463.5 | 5480.28 | 5457.47 | 5475.56 | 17097.0 |
| 2024-08-08 07:00:00 | ES | Futures | 5475.29 | 5490.5 | 5470.31 | 5487.62 | 21563.0 |
| 2024-08-08 08:00:00 | ES | Futures | 5487.88 | 5533.49 | 5479.75 | 5521.7 | 90577.0 |
| 2024-08-08 09:00:00 | ES | Futures | 5521.96 | 5550.01 | 5515.67 | 5549.75 | 256874.0 |
| 2024-08-08 10:00:00 | ES | Futures | 5550.01 | 5585.93 | 5545.55 | 5583.31 | 289923.0 |
| 2024-08-08 11:00:00 | ES | Futures | 5583.31 | 5586.45 | 5564.17 | 5577.54 | 163050.0 |
| 2024-08-08 12:00:00 | ES | Futures | 5577.54 | 5591.96 | 5566.53 | 5579.11 | 127544.0 |
| 2024-08-08 13:00:00 | ES | Futures | 5579.37 | 5607.42 | 5567.31 | 5604.54 | 141367.0 |
| 2024-08-08 14:00:00 | ES | Futures | 5604.54 | 5616.08 | 5596.94 | 5603.49 | 123330.0 |
| 2024-08-08 15:00:00 | ES | Futures | 5603.49 | 5612.93 | 5582.78 | 5608.47 | 297352.0 |
| 2024-08-08 16:00:00 | ES | Futures | 5608.74 | 5621.84 | 5607.69 | 5613.45 | 90411.0 |
| 2024-08-08 18:00:00 | ES | Futures | 5608.47 | 5616.6 | 5605.59 | 5612.14 | 8460.0 |
| 2024-08-08 19:00:00 | ES | Futures | 5612.14 | 5623.68 | 5609.52 | 5618.44 | 11434.0 |
| 2024-08-08 20:00:00 | ES | Futures | 5618.17 | 5618.17 | 5596.41 | 5604.8 | 17050.0 |
| 2024-08-08 21:00:00 | ES | Futures | 5604.54 | 5613.19 | 5602.97 | 5608.74 | 9392.0 |
| 2024-08-08 22:00:00 | ES | Futures | 5608.74 | 5619.48 | 5605.07 | 5618.44 | 6106.0 |
| 2024-08-08 23:00:00 | ES | Futures | 5618.44 | 5619.48 | 5610.05 | 5616.08 | 5420.0 |
| 2024-08-08 00:00:00 | NQ | Futures | 19029.97 | 19051.62 | 18968.73 | 18996.71 | 6446.0 |
| 2024-08-08 01:00:00 | NQ | Futures | 18996.71 | 19030.23 | 18928.87 | 18939.16 | 5086.0 |
| 2024-08-08 02:00:00 | NQ | Futures | 18937.84 | 19064.55 | 18917.25 | 19045.28 | 7119.0 |
| 2024-08-08 03:00:00 | NQ | Futures | 19047.13 | 19052.94 | 18878.97 | 18916.99 | 9861.0 |
| 2024-08-08 04:00:00 | NQ | Futures | 18915.67 | 19005.68 | 18904.05 | 19005.68 | 7693.0 |
| 2024-08-08 05:00:00 | NQ | Futures | 19005.16 | 19025.75 | 18913.03 | 18942.33 | 6727.0 |
| 2024-08-08 06:00:00 | NQ | Futures | 18946.55 | 19006.74 | 18921.21 | 18976.12 | 6311.0 |
| 2024-08-08 07:00:00 | NQ | Futures | 18976.12 | 19014.13 | 18939.42 | 18999.35 | 6284.0 |
| 2024-08-08 08:00:00 | NQ | Futures | 19000.4 | 19222.15 | 18962.39 | 19171.47 | 32926.0 |
| 2024-08-08 09:00:00 | NQ | Futures | 19172.79 | 19273.1 | 19074.58 | 19227.17 | 88767.0 |
| 2024-08-08 10:00:00 | NQ | Futures | 19227.69 | 19469.24 | 19207.37 | 19441.78 | 100046.0 |
| 2024-08-08 11:00:00 | NQ | Futures | 19442.31 | 19449.97 | 19348.07 | 19432.81 | 63843.0 |
| 2024-08-08 12:00:00 | NQ | Futures | 19433.07 | 19501.71 | 19387.93 | 19435.71 | 53881.0 |
| 2024-08-08 13:00:00 | NQ | Futures | 19437.03 | 19568.76 | 19384.76 | 19550.02 | 54189.0 |
| 2024-08-08 14:00:00 | NQ | Futures | 19549.75 | 19593.05 | 19505.4 | 19526.52 | 43967.0 |
| 2024-08-08 15:00:00 | NQ | Futures | 19527.84 | 19576.68 | 19433.6 | 19555.03 | 82890.0 |
| 2024-08-08 16:00:00 | NQ | Futures | 19554.5 | 19633.43 | 19547.11 | 19595.95 | 23736.0 |
| 2024-08-08 18:00:00 | NQ | Futures | 19587.77 | 19612.84 | 19563.74 | 19600.44 | 4012.0 |
| 2024-08-08 19:00:00 | NQ | Futures | 19600.44 | 19658.25 | 19595.42 | 19642.41 | 5420.0 |
| 2024-08-08 20:00:00 | NQ | Futures | 19640.03 | 19641.35 | 19524.41 | 19554.77 | 7698.0 |
| 2024-08-08 21:00:00 | NQ | Futures | 19556.09 | 19604.92 | 19547.38 | 19582.49 | 4482.0 |
| 2024-08-08 22:00:00 | NQ | Futures | 19579.85 | 19636.07 | 19564.27 | 19626.84 | 3251.0 |
| 2024-08-08 23:00:00 | NQ | Futures | 19627.1 | 19633.96 | 19576.15 | 19603.6 | 2899.0 |
| 2024-08-08 00:00:00 | YM | Futures | 40881.7 | 40901.7 | 40823.9 | 40870.2 | 1312.0 |
| 2024-08-08 01:00:00 | YM | Futures | 40872.3 | 40912.2 | 40805.0 | 40817.6 | 1536.0 |
| 2024-08-08 02:00:00 | YM | Futures | 40816.6 | 40950.0 | 40795.6 | 40891.2 | 2826.0 |
| 2024-08-08 03:00:00 | YM | Futures | 40899.6 | 40919.5 | 40690.5 | 40746.2 | 3143.0 |
> showing 50 of 2,121 rows — these rows as CSV