PREVIEW / futures_1hour / 2024-01-03
file: by_date/futures_1hour/2024/2024-01-03.parquet size: 70 KB rows: 2,108
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-03 00:00:00 | ES | Futures | 5138.94 | 5139.75 | 5137.33 | 5139.48 | 4376.0 |
| 2024-01-03 01:00:00 | ES | Futures | 5139.48 | 5141.63 | 5138.68 | 5140.29 | 3867.0 |
| 2024-01-03 02:00:00 | ES | Futures | 5140.29 | 5141.9 | 5138.68 | 5141.09 | 6330.0 |
| 2024-01-03 03:00:00 | ES | Futures | 5141.09 | 5145.12 | 5137.06 | 5137.06 | 19366.0 |
| 2024-01-03 04:00:00 | ES | Futures | 5137.33 | 5138.68 | 5130.62 | 5130.62 | 21366.0 |
| 2024-01-03 05:00:00 | ES | Futures | 5130.89 | 5135.45 | 5129.54 | 5131.69 | 14011.0 |
| 2024-01-03 06:00:00 | ES | Futures | 5131.96 | 5133.3 | 5125.78 | 5127.66 | 14411.0 |
| 2024-01-03 07:00:00 | ES | Futures | 5127.93 | 5127.93 | 5120.41 | 5121.49 | 30261.0 |
| 2024-01-03 08:00:00 | ES | Futures | 5121.49 | 5127.66 | 5119.87 | 5120.95 | 39638.0 |
| 2024-01-03 09:00:00 | ES | Futures | 5120.68 | 5122.56 | 5109.67 | 5113.43 | 213842.0 |
| 2024-01-03 10:00:00 | ES | Futures | 5113.16 | 5124.17 | 5099.46 | 5106.71 | 293789.0 |
| 2024-01-03 11:00:00 | ES | Futures | 5106.71 | 5112.89 | 5103.76 | 5105.1 | 145794.0 |
| 2024-01-03 12:00:00 | ES | Futures | 5105.37 | 5117.46 | 5102.15 | 5116.38 | 99795.0 |
| 2024-01-03 13:00:00 | ES | Futures | 5116.38 | 5122.02 | 5111.82 | 5114.5 | 96245.0 |
| 2024-01-03 14:00:00 | ES | Futures | 5114.5 | 5126.59 | 5101.88 | 5115.58 | 237323.0 |
| 2024-01-03 15:00:00 | ES | Futures | 5115.85 | 5116.65 | 5093.55 | 5100.0 | 273780.0 |
| 2024-01-03 16:00:00 | ES | Futures | 5100.0 | 5102.15 | 5097.04 | 5101.88 | 48349.0 |
| 2024-01-03 18:00:00 | ES | Futures | 5103.22 | 5106.71 | 5101.88 | 5103.22 | 5828.0 |
| 2024-01-03 19:00:00 | ES | Futures | 5102.95 | 5106.18 | 5099.73 | 5106.18 | 7806.0 |
| 2024-01-03 20:00:00 | ES | Futures | 5105.91 | 5106.44 | 5103.76 | 5105.64 | 6863.0 |
| 2024-01-03 21:00:00 | ES | Futures | 5105.64 | 5105.91 | 5101.88 | 5104.3 | 3895.0 |
| 2024-01-03 22:00:00 | ES | Futures | 5104.3 | 5105.64 | 5102.15 | 5102.68 | 3571.0 |
| 2024-01-03 23:00:00 | ES | Futures | 5102.95 | 5105.1 | 5102.42 | 5102.95 | 2652.0 |
| 2024-01-03 00:00:00 | NQ | Futures | 18111.11 | 18122.77 | 18104.6 | 18121.69 | 3211.0 |
| 2024-01-03 01:00:00 | NQ | Futures | 18121.42 | 18134.71 | 18116.81 | 18129.01 | 2946.0 |
| 2024-01-03 02:00:00 | NQ | Futures | 18128.47 | 18131.72 | 18118.16 | 18127.11 | 4025.0 |
| 2024-01-03 03:00:00 | NQ | Futures | 18126.84 | 18148.54 | 18086.43 | 18089.41 | 10422.0 |
| 2024-01-03 04:00:00 | NQ | Futures | 18088.6 | 18103.79 | 18052.8 | 18054.16 | 11190.0 |
| 2024-01-03 05:00:00 | NQ | Futures | 18053.89 | 18088.33 | 18047.92 | 18070.43 | 9365.0 |
| 2024-01-03 06:00:00 | NQ | Futures | 18070.7 | 18079.38 | 18047.11 | 18060.4 | 7598.0 |
| 2024-01-03 07:00:00 | NQ | Futures | 18060.67 | 18061.48 | 18011.04 | 18018.09 | 14461.0 |
| 2024-01-03 08:00:00 | NQ | Futures | 18018.09 | 18057.95 | 18005.88 | 18026.49 | 21101.0 |
| 2024-01-03 09:00:00 | NQ | Futures | 18026.49 | 18053.89 | 17987.98 | 18022.97 | 110534.0 |
| 2024-01-03 10:00:00 | NQ | Futures | 18021.88 | 18066.09 | 17947.3 | 18002.9 | 115181.0 |
| 2024-01-03 11:00:00 | NQ | Futures | 18003.17 | 18027.58 | 17962.76 | 17967.1 | 62925.0 |
| 2024-01-03 12:00:00 | NQ | Futures | 17967.37 | 18013.48 | 17953.0 | 18008.6 | 44656.0 |
| 2024-01-03 13:00:00 | NQ | Futures | 18008.32 | 18029.21 | 17976.32 | 17992.32 | 37764.0 |
| 2024-01-03 14:00:00 | NQ | Futures | 17990.15 | 18039.24 | 17931.84 | 17997.75 | 96435.0 |
| 2024-01-03 15:00:00 | NQ | Futures | 17997.75 | 18004.8 | 17923.44 | 17943.78 | 87836.0 |
| 2024-01-03 16:00:00 | NQ | Futures | 17943.51 | 17946.22 | 17929.13 | 17945.95 | 10765.0 |
| 2024-01-03 18:00:00 | NQ | Futures | 17948.66 | 17967.64 | 17948.66 | 17953.27 | 3714.0 |
| 2024-01-03 19:00:00 | NQ | Futures | 17953.0 | 17968.19 | 17935.37 | 17964.66 | 4297.0 |
| 2024-01-03 20:00:00 | NQ | Futures | 17964.39 | 17967.64 | 17952.46 | 17960.05 | 3508.0 |
| 2024-01-03 21:00:00 | NQ | Futures | 17960.32 | 17961.68 | 17945.95 | 17956.25 | 2327.0 |
| 2024-01-03 22:00:00 | NQ | Futures | 17955.98 | 17962.22 | 17950.29 | 17953.27 | 1662.0 |
| 2024-01-03 23:00:00 | NQ | Futures | 17952.73 | 17959.51 | 17951.64 | 17952.18 | 1467.0 |
| 2024-01-03 00:00:00 | YM | Futures | 40783.8 | 40783.8 | 40768.8 | 40776.3 | 668.0 |
| 2024-01-03 01:00:00 | YM | Futures | 40776.3 | 40787.0 | 40774.1 | 40782.7 | 529.0 |
| 2024-01-03 02:00:00 | YM | Futures | 40781.7 | 40795.6 | 40767.7 | 40782.7 | 1208.0 |
| 2024-01-03 03:00:00 | YM | Futures | 40782.7 | 40817.1 | 40774.1 | 40786.0 | 2618.0 |
> showing 50 of 2,108 rows — these rows as CSV