PREVIEW / futures_1hour / 2024-01-04
file: by_date/futures_1hour/2024/2024-01-04.parquet size: 67 KB rows: 2,093
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-01-04 00:00:00 | ES | Futures | 5102.95 | 5103.22 | 5101.07 | 5101.34 | 4049.0 |
| 2024-01-04 01:00:00 | ES | Futures | 5101.34 | 5107.25 | 5101.34 | 5106.71 | 5541.0 |
| 2024-01-04 02:00:00 | ES | Futures | 5106.98 | 5109.67 | 5105.1 | 5106.18 | 7986.0 |
| 2024-01-04 03:00:00 | ES | Futures | 5106.18 | 5110.74 | 5103.22 | 5103.76 | 19552.0 |
| 2024-01-04 04:00:00 | ES | Futures | 5103.76 | 5108.32 | 5101.88 | 5107.79 | 12359.0 |
| 2024-01-04 05:00:00 | ES | Futures | 5107.52 | 5108.59 | 5102.15 | 5105.1 | 11026.0 |
| 2024-01-04 06:00:00 | ES | Futures | 5104.83 | 5108.59 | 5099.19 | 5100.27 | 15542.0 |
| 2024-01-04 07:00:00 | ES | Futures | 5100.27 | 5108.06 | 5095.97 | 5103.76 | 25869.0 |
| 2024-01-04 08:00:00 | ES | Futures | 5103.76 | 5104.56 | 5094.36 | 5095.7 | 55223.0 |
| 2024-01-04 09:00:00 | ES | Futures | 5095.7 | 5102.68 | 5089.25 | 5098.66 | 182777.0 |
| 2024-01-04 10:00:00 | ES | Futures | 5098.66 | 5113.16 | 5096.24 | 5109.13 | 187660.0 |
| 2024-01-04 11:00:00 | ES | Futures | 5108.86 | 5120.95 | 5104.3 | 5107.25 | 154449.0 |
| 2024-01-04 12:00:00 | ES | Futures | 5107.25 | 5108.59 | 5095.7 | 5100.8 | 107630.0 |
| 2024-01-04 13:00:00 | ES | Futures | 5100.54 | 5104.3 | 5098.92 | 5100.27 | 69843.0 |
| 2024-01-04 14:00:00 | ES | Futures | 5100.27 | 5102.95 | 5090.33 | 5095.97 | 109455.0 |
| 2024-01-04 15:00:00 | ES | Futures | 5095.97 | 5100.0 | 5078.51 | 5081.47 | 242754.0 |
| 2024-01-04 16:00:00 | ES | Futures | 5081.73 | 5085.49 | 5079.05 | 5084.15 | 57047.0 |
| 2024-01-04 18:00:00 | ES | Futures | 5084.69 | 5088.72 | 5084.42 | 5086.03 | 5578.0 |
| 2024-01-04 19:00:00 | ES | Futures | 5086.03 | 5088.18 | 5084.96 | 5086.03 | 4139.0 |
| 2024-01-04 20:00:00 | ES | Futures | 5086.3 | 5088.72 | 5084.96 | 5087.37 | 5808.0 |
| 2024-01-04 21:00:00 | ES | Futures | 5087.37 | 5087.37 | 5084.42 | 5084.96 | 3258.0 |
| 2024-01-04 22:00:00 | ES | Futures | 5085.23 | 5086.3 | 5083.88 | 5084.42 | 2120.0 |
| 2024-01-04 23:00:00 | ES | Futures | 5084.15 | 5087.11 | 5083.35 | 5083.88 | 4070.0 |
| 2024-01-04 00:00:00 | NQ | Futures | 17952.73 | 17956.25 | 17945.95 | 17947.03 | 2056.0 |
| 2024-01-04 01:00:00 | NQ | Futures | 17947.03 | 17976.05 | 17942.42 | 17974.69 | 3908.0 |
| 2024-01-04 02:00:00 | NQ | Futures | 17975.24 | 17994.22 | 17970.9 | 17976.05 | 4950.0 |
| 2024-01-04 03:00:00 | NQ | Futures | 17976.59 | 17990.97 | 17949.2 | 17953.27 | 8135.0 |
| 2024-01-04 04:00:00 | NQ | Futures | 17953.27 | 17987.17 | 17952.46 | 17983.1 | 5831.0 |
| 2024-01-04 05:00:00 | NQ | Futures | 17982.83 | 17984.46 | 17954.9 | 17968.73 | 4972.0 |
| 2024-01-04 06:00:00 | NQ | Futures | 17968.73 | 17978.76 | 17930.22 | 17931.3 | 6376.0 |
| 2024-01-04 07:00:00 | NQ | Futures | 17931.03 | 17938.35 | 17904.45 | 17920.45 | 13392.0 |
| 2024-01-04 08:00:00 | NQ | Futures | 17920.18 | 17920.18 | 17846.69 | 17855.64 | 30179.0 |
| 2024-01-04 09:00:00 | NQ | Futures | 17855.09 | 17899.84 | 17838.01 | 17856.99 | 83146.0 |
| 2024-01-04 10:00:00 | NQ | Futures | 17856.45 | 17945.13 | 17840.72 | 17926.96 | 86595.0 |
| 2024-01-04 11:00:00 | NQ | Futures | 17926.96 | 17990.42 | 17915.03 | 17924.52 | 76014.0 |
| 2024-01-04 12:00:00 | NQ | Futures | 17924.52 | 17930.76 | 17879.23 | 17904.99 | 50972.0 |
| 2024-01-04 13:00:00 | NQ | Futures | 17905.54 | 17931.03 | 17891.43 | 17905.27 | 35628.0 |
| 2024-01-04 14:00:00 | NQ | Futures | 17905.27 | 17915.84 | 17861.33 | 17885.47 | 44409.0 |
| 2024-01-04 15:00:00 | NQ | Futures | 17885.2 | 17911.5 | 17830.14 | 17838.55 | 64015.0 |
| 2024-01-04 16:00:00 | NQ | Futures | 17838.55 | 17853.47 | 17830.96 | 17846.14 | 13702.0 |
| 2024-01-04 18:00:00 | NQ | Futures | 17850.75 | 17865.67 | 17846.14 | 17852.38 | 3228.0 |
| 2024-01-04 19:00:00 | NQ | Futures | 17852.38 | 17863.23 | 17848.86 | 17854.82 | 2722.0 |
| 2024-01-04 20:00:00 | NQ | Futures | 17854.82 | 17865.94 | 17846.14 | 17856.72 | 3499.0 |
| 2024-01-04 21:00:00 | NQ | Futures | 17856.18 | 17857.53 | 17843.97 | 17846.96 | 2247.0 |
| 2024-01-04 22:00:00 | NQ | Futures | 17846.69 | 17850.75 | 17839.63 | 17840.99 | 1710.0 |
| 2024-01-04 23:00:00 | NQ | Futures | 17841.53 | 17852.65 | 17835.57 | 17836.92 | 2588.0 |
| 2024-01-04 00:00:00 | YM | Futures | 40520.7 | 40521.7 | 40500.2 | 40504.5 | 546.0 |
| 2024-01-04 01:00:00 | YM | Futures | 40507.8 | 40541.1 | 40506.7 | 40535.7 | 1368.0 |
| 2024-01-04 02:00:00 | YM | Futures | 40537.8 | 40551.8 | 40526.0 | 40533.5 | 1705.0 |
| 2024-01-04 03:00:00 | YM | Futures | 40533.5 | 40578.7 | 40528.2 | 40542.1 | 3221.0 |
> showing 50 of 2,093 rows — these rows as CSV