PREVIEW / futures_1hour / 2024-11-14
file: by_date/futures_1hour/2024/2024-11-14.parquet size: 70 KB rows: 2,135
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-11-14 00:00:00 | ES | Futures | 6241.02 | 6241.8 | 6234.79 | 6238.94 | 5741.0 |
| 2024-11-14 01:00:00 | ES | Futures | 6238.68 | 6239.98 | 6234.53 | 6234.53 | 4543.0 |
| 2024-11-14 02:00:00 | ES | Futures | 6234.79 | 6243.87 | 6232.71 | 6242.84 | 9275.0 |
| 2024-11-14 03:00:00 | ES | Futures | 6242.84 | 6252.7 | 6241.8 | 6248.54 | 16581.0 |
| 2024-11-14 04:00:00 | ES | Futures | 6248.54 | 6253.99 | 6246.47 | 6247.25 | 13916.0 |
| 2024-11-14 05:00:00 | ES | Futures | 6246.99 | 6252.7 | 6246.73 | 6248.29 | 8796.0 |
| 2024-11-14 06:00:00 | ES | Futures | 6248.29 | 6254.25 | 6246.99 | 6253.74 | 10355.0 |
| 2024-11-14 07:00:00 | ES | Futures | 6253.48 | 6254.77 | 6247.25 | 6247.77 | 14228.0 |
| 2024-11-14 08:00:00 | ES | Futures | 6248.03 | 6254.25 | 6238.42 | 6243.35 | 48430.0 |
| 2024-11-14 09:00:00 | ES | Futures | 6243.35 | 6249.84 | 6228.04 | 6234.27 | 198456.0 |
| 2024-11-14 10:00:00 | ES | Futures | 6234.27 | 6240.24 | 6221.04 | 6231.94 | 205555.0 |
| 2024-11-14 11:00:00 | ES | Futures | 6231.68 | 6240.5 | 6225.19 | 6227.0 | 122304.0 |
| 2024-11-14 12:00:00 | ES | Futures | 6227.0 | 6229.08 | 6206.5 | 6220.26 | 176652.0 |
| 2024-11-14 13:00:00 | ES | Futures | 6220.26 | 6227.78 | 6207.02 | 6208.58 | 110783.0 |
| 2024-11-14 14:00:00 | ES | Futures | 6208.32 | 6229.08 | 6208.06 | 6223.63 | 115741.0 |
| 2024-11-14 15:00:00 | ES | Futures | 6223.63 | 6223.63 | 6196.12 | 6204.43 | 311792.0 |
| 2024-11-14 16:00:00 | ES | Futures | 6204.43 | 6205.46 | 6191.45 | 6201.83 | 64064.0 |
| 2024-11-14 18:00:00 | ES | Futures | 6199.5 | 6201.83 | 6191.71 | 6194.56 | 9107.0 |
| 2024-11-14 19:00:00 | ES | Futures | 6194.3 | 6195.34 | 6185.74 | 6189.11 | 11962.0 |
| 2024-11-14 20:00:00 | ES | Futures | 6188.85 | 6189.11 | 6181.85 | 6182.89 | 11422.0 |
| 2024-11-14 21:00:00 | ES | Futures | 6183.15 | 6187.82 | 6181.59 | 6186.78 | 7030.0 |
| 2024-11-14 22:00:00 | ES | Futures | 6187.04 | 6189.63 | 6184.7 | 6186.0 | 6140.0 |
| 2024-11-14 23:00:00 | ES | Futures | 6186.0 | 6188.34 | 6182.89 | 6187.3 | 7097.0 |
| 2024-11-14 00:00:00 | NQ | Futures | 22061.7 | 22065.88 | 22028.04 | 22043.44 | 3915.0 |
| 2024-11-14 01:00:00 | NQ | Futures | 22043.44 | 22047.35 | 22020.48 | 22022.3 | 3223.0 |
| 2024-11-14 02:00:00 | NQ | Futures | 22021.78 | 22054.92 | 22010.82 | 22051.53 | 4761.0 |
| 2024-11-14 03:00:00 | NQ | Futures | 22051.53 | 22099.01 | 22046.31 | 22089.88 | 8166.0 |
| 2024-11-14 04:00:00 | NQ | Futures | 22089.62 | 22115.19 | 22075.27 | 22076.57 | 7651.0 |
| 2024-11-14 05:00:00 | NQ | Futures | 22075.79 | 22107.62 | 22071.36 | 22086.75 | 5027.0 |
| 2024-11-14 06:00:00 | NQ | Futures | 22086.49 | 22105.01 | 22083.1 | 22101.88 | 4943.0 |
| 2024-11-14 07:00:00 | NQ | Futures | 22101.88 | 22107.62 | 22076.05 | 22078.4 | 5512.0 |
| 2024-11-14 08:00:00 | NQ | Futures | 22079.18 | 22101.1 | 22034.31 | 22056.48 | 20900.0 |
| 2024-11-14 09:00:00 | NQ | Futures | 22057.27 | 22099.01 | 21983.43 | 22012.65 | 74436.0 |
| 2024-11-14 10:00:00 | NQ | Futures | 22012.39 | 22060.92 | 21958.9 | 22011.61 | 76109.0 |
| 2024-11-14 11:00:00 | NQ | Futures | 22011.09 | 22063.01 | 22006.65 | 22022.3 | 45708.0 |
| 2024-11-14 12:00:00 | NQ | Futures | 22022.83 | 22033.26 | 21934.12 | 22003.26 | 63106.0 |
| 2024-11-14 13:00:00 | NQ | Futures | 22003.52 | 22042.66 | 21939.07 | 21945.34 | 43245.0 |
| 2024-11-14 14:00:00 | NQ | Futures | 21944.55 | 22010.82 | 21941.94 | 21988.91 | 45317.0 |
| 2024-11-14 15:00:00 | NQ | Futures | 21989.17 | 21989.17 | 21886.63 | 21925.51 | 94597.0 |
| 2024-11-14 16:00:00 | NQ | Futures | 21925.51 | 21930.2 | 21864.97 | 21897.59 | 18493.0 |
| 2024-11-14 18:00:00 | NQ | Futures | 21893.15 | 21897.33 | 21850.89 | 21864.71 | 5109.0 |
| 2024-11-14 19:00:00 | NQ | Futures | 21864.19 | 21871.24 | 21826.36 | 21840.19 | 5398.0 |
| 2024-11-14 20:00:00 | NQ | Futures | 21839.14 | 21840.45 | 21795.83 | 21803.66 | 7248.0 |
| 2024-11-14 21:00:00 | NQ | Futures | 21803.14 | 21829.75 | 21796.88 | 21827.92 | 4485.0 |
| 2024-11-14 22:00:00 | NQ | Futures | 21827.92 | 21837.84 | 21815.66 | 21818.01 | 4199.0 |
| 2024-11-14 23:00:00 | NQ | Futures | 21818.27 | 21833.14 | 21803.4 | 21831.84 | 3914.0 |
| 2024-11-14 00:00:00 | YM | Futures | 45875.3 | 45879.5 | 45838.9 | 45853.5 | 761.0 |
| 2024-11-14 01:00:00 | YM | Futures | 45853.5 | 45864.9 | 45824.3 | 45827.4 | 956.0 |
| 2024-11-14 02:00:00 | YM | Futures | 45826.4 | 45920.1 | 45823.3 | 45912.8 | 1611.0 |
| 2024-11-14 03:00:00 | YM | Futures | 45910.7 | 45969.0 | 45903.4 | 45929.4 | 2162.0 |
> showing 50 of 2,135 rows — these rows as CSV