PREVIEW / futures_1hour / 2024-08-14
file: by_date/futures_1hour/2024/2024-08-14.parquet size: 66 KB rows: 2,081
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-14 00:00:00 | ES | Futures | 5723.3 | 5725.66 | 5722.51 | 5723.83 | 2666.0 |
| 2024-08-14 01:00:00 | ES | Futures | 5723.83 | 5727.76 | 5722.51 | 5726.45 | 4036.0 |
| 2024-08-14 02:00:00 | ES | Futures | 5726.45 | 5729.59 | 5724.09 | 5725.4 | 6631.0 |
| 2024-08-14 03:00:00 | ES | Futures | 5725.66 | 5728.02 | 5722.25 | 5723.04 | 10267.0 |
| 2024-08-14 04:00:00 | ES | Futures | 5723.04 | 5725.66 | 5718.84 | 5724.87 | 12975.0 |
| 2024-08-14 05:00:00 | ES | Futures | 5725.14 | 5726.71 | 5723.56 | 5724.61 | 7625.0 |
| 2024-08-14 06:00:00 | ES | Futures | 5724.87 | 5729.07 | 5723.56 | 5725.92 | 9389.0 |
| 2024-08-14 07:00:00 | ES | Futures | 5726.18 | 5727.5 | 5722.78 | 5726.18 | 13742.0 |
| 2024-08-14 08:00:00 | ES | Futures | 5725.92 | 5740.08 | 5713.6 | 5732.74 | 84572.0 |
| 2024-08-14 09:00:00 | ES | Futures | 5732.74 | 5736.41 | 5715.7 | 5717.8 | 155699.0 |
| 2024-08-14 10:00:00 | ES | Futures | 5718.06 | 5727.76 | 5703.38 | 5726.71 | 219367.0 |
| 2024-08-14 11:00:00 | ES | Futures | 5726.97 | 5752.93 | 5725.4 | 5751.88 | 136788.0 |
| 2024-08-14 12:00:00 | ES | Futures | 5751.88 | 5754.76 | 5721.2 | 5735.1 | 156031.0 |
| 2024-08-14 13:00:00 | ES | Futures | 5734.84 | 5740.87 | 5728.54 | 5737.2 | 90735.0 |
| 2024-08-14 14:00:00 | ES | Futures | 5737.2 | 5748.21 | 5729.86 | 5747.68 | 79923.0 |
| 2024-08-14 15:00:00 | ES | Futures | 5747.42 | 5751.61 | 5731.43 | 5741.65 | 170330.0 |
| 2024-08-14 16:00:00 | ES | Futures | 5741.65 | 5752.14 | 5740.87 | 5748.21 | 45911.0 |
| 2024-08-14 18:00:00 | ES | Futures | 5747.94 | 5749.52 | 5742.7 | 5745.32 | 5936.0 |
| 2024-08-14 19:00:00 | ES | Futures | 5745.32 | 5748.21 | 5738.77 | 5741.13 | 4167.0 |
| 2024-08-14 20:00:00 | ES | Futures | 5740.87 | 5752.14 | 5740.87 | 5750.04 | 8703.0 |
| 2024-08-14 21:00:00 | ES | Futures | 5750.3 | 5752.93 | 5747.68 | 5752.14 | 6997.0 |
| 2024-08-14 22:00:00 | ES | Futures | 5752.14 | 5758.96 | 5750.83 | 5758.17 | 8016.0 |
| 2024-08-14 23:00:00 | ES | Futures | 5758.17 | 5759.22 | 5755.29 | 5757.64 | 3304.0 |
| 2024-08-14 00:00:00 | NQ | Futures | 20176.97 | 20187.01 | 20169.32 | 20172.22 | 1914.0 |
| 2024-08-14 01:00:00 | NQ | Futures | 20172.49 | 20190.44 | 20166.15 | 20184.37 | 3173.0 |
| 2024-08-14 02:00:00 | NQ | Futures | 20183.05 | 20203.11 | 20172.22 | 20173.81 | 4707.0 |
| 2024-08-14 03:00:00 | NQ | Futures | 20174.33 | 20184.1 | 20153.74 | 20163.51 | 6074.0 |
| 2024-08-14 04:00:00 | NQ | Futures | 20163.78 | 20181.73 | 20129.72 | 20155.59 | 8155.0 |
| 2024-08-14 05:00:00 | NQ | Futures | 20155.86 | 20169.85 | 20141.6 | 20164.3 | 4021.0 |
| 2024-08-14 06:00:00 | NQ | Futures | 20164.57 | 20192.02 | 20161.4 | 20176.97 | 5002.0 |
| 2024-08-14 07:00:00 | NQ | Futures | 20176.97 | 20188.06 | 20159.02 | 20179.09 | 5068.0 |
| 2024-08-14 08:00:00 | NQ | Futures | 20179.09 | 20235.31 | 20062.67 | 20200.21 | 34232.0 |
| 2024-08-14 09:00:00 | NQ | Futures | 20201.52 | 20247.99 | 20074.29 | 20093.82 | 81346.0 |
| 2024-08-14 10:00:00 | NQ | Futures | 20093.29 | 20138.96 | 19984.0 | 20133.15 | 97256.0 |
| 2024-08-14 11:00:00 | NQ | Futures | 20133.42 | 20277.55 | 20119.16 | 20270.42 | 61494.0 |
| 2024-08-14 12:00:00 | NQ | Futures | 20270.42 | 20272.01 | 20081.41 | 20137.64 | 69064.0 |
| 2024-08-14 13:00:00 | NQ | Futures | 20136.85 | 20170.9 | 20117.58 | 20138.43 | 38995.0 |
| 2024-08-14 14:00:00 | NQ | Futures | 20138.43 | 20181.99 | 20109.66 | 20178.82 | 31150.0 |
| 2024-08-14 15:00:00 | NQ | Futures | 20178.03 | 20212.88 | 20103.06 | 20175.92 | 52102.0 |
| 2024-08-14 16:00:00 | NQ | Futures | 20176.45 | 20232.41 | 20170.64 | 20217.89 | 13717.0 |
| 2024-08-14 18:00:00 | NQ | Futures | 20213.14 | 20221.06 | 20190.7 | 20200.21 | 1927.0 |
| 2024-08-14 19:00:00 | NQ | Futures | 20199.15 | 20217.1 | 20168.79 | 20175.13 | 2735.0 |
| 2024-08-14 20:00:00 | NQ | Futures | 20177.24 | 20245.35 | 20174.86 | 20237.95 | 4307.0 |
| 2024-08-14 21:00:00 | NQ | Futures | 20237.43 | 20250.63 | 20216.31 | 20238.75 | 3278.0 |
| 2024-08-14 22:00:00 | NQ | Futures | 20238.75 | 20292.33 | 20229.51 | 20287.32 | 4902.0 |
| 2024-08-14 23:00:00 | NQ | Futures | 20286.79 | 20299.99 | 20275.97 | 20288.64 | 2613.0 |
| 2024-08-14 00:00:00 | YM | Futures | 41909.3 | 41931.4 | 41904.1 | 41919.8 | 654.0 |
| 2024-08-14 01:00:00 | YM | Futures | 41916.7 | 41946.1 | 41910.4 | 41940.9 | 541.0 |
| 2024-08-14 02:00:00 | YM | Futures | 41939.8 | 41960.8 | 41919.8 | 41946.1 | 1419.0 |
| 2024-08-14 03:00:00 | YM | Futures | 41945.1 | 41962.9 | 41917.7 | 41925.1 | 1347.0 |
> showing 50 of 2,081 rows — these rows as CSV