PREVIEW / futures_1hour / 2023-08-10
file: by_date/futures_1hour/2023/2023-08-10.parquet size: 67 KB rows: 2,045
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 |
|---|---|---|---|---|---|---|---|
| 2023-08-10 00:00:00 | ES | Futures | 4944.22 | 4945.87 | 4942.3 | 4942.3 | 2867.0 |
| 2023-08-10 01:00:00 | ES | Futures | 4942.3 | 4945.05 | 4939.01 | 4945.05 | 6138.0 |
| 2023-08-10 02:00:00 | ES | Futures | 4945.05 | 4948.34 | 4943.4 | 4943.4 | 9496.0 |
| 2023-08-10 03:00:00 | ES | Futures | 4943.13 | 4958.77 | 4943.13 | 4954.66 | 26904.0 |
| 2023-08-10 04:00:00 | ES | Futures | 4954.38 | 4956.58 | 4949.99 | 4953.28 | 12102.0 |
| 2023-08-10 05:00:00 | ES | Futures | 4953.28 | 4956.3 | 4951.09 | 4953.56 | 11294.0 |
| 2023-08-10 06:00:00 | ES | Futures | 4953.56 | 4954.11 | 4947.79 | 4950.81 | 12086.0 |
| 2023-08-10 07:00:00 | ES | Futures | 4950.81 | 4953.01 | 4945.6 | 4947.52 | 16749.0 |
| 2023-08-10 08:00:00 | ES | Futures | 4947.24 | 4968.66 | 4934.62 | 4959.6 | 125894.0 |
| 2023-08-10 09:00:00 | ES | Futures | 4959.6 | 4984.85 | 4948.62 | 4984.58 | 287123.0 |
| 2023-08-10 10:00:00 | ES | Futures | 4984.85 | 4990.34 | 4956.58 | 4965.64 | 367464.0 |
| 2023-08-10 11:00:00 | ES | Futures | 4965.91 | 4966.73 | 4935.99 | 4944.22 | 322224.0 |
| 2023-08-10 12:00:00 | ES | Futures | 4944.22 | 4948.07 | 4925.56 | 4929.68 | 220258.0 |
| 2023-08-10 13:00:00 | ES | Futures | 4929.68 | 4935.44 | 4912.11 | 4914.03 | 206715.0 |
| 2023-08-10 14:00:00 | ES | Futures | 4914.03 | 4942.85 | 4913.48 | 4942.3 | 214016.0 |
| 2023-08-10 15:00:00 | ES | Futures | 4942.58 | 4942.85 | 4915.68 | 4926.11 | 235732.0 |
| 2023-08-10 16:00:00 | ES | Futures | 4926.11 | 4928.58 | 4921.44 | 4926.66 | 50456.0 |
| 2023-08-10 18:00:00 | ES | Futures | 4927.75 | 4931.6 | 4926.11 | 4930.22 | 4063.0 |
| 2023-08-10 19:00:00 | ES | Futures | 4930.5 | 4932.97 | 4928.3 | 4931.6 | 2953.0 |
| 2023-08-10 20:00:00 | ES | Futures | 4931.6 | 4937.09 | 4931.32 | 4935.71 | 5512.0 |
| 2023-08-10 21:00:00 | ES | Futures | 4935.44 | 4936.81 | 4931.6 | 4932.15 | 7012.0 |
| 2023-08-10 22:00:00 | ES | Futures | 4931.87 | 4932.7 | 4926.66 | 4928.3 | 6559.0 |
| 2023-08-10 23:00:00 | ES | Futures | 4928.3 | 4930.77 | 4923.36 | 4924.73 | 6010.0 |
| 2023-08-10 00:00:00 | NQ | Futures | 16954.87 | 16965.17 | 16947.09 | 16947.09 | 2099.0 |
| 2023-08-10 01:00:00 | NQ | Futures | 16947.64 | 16957.93 | 16932.9 | 16957.38 | 4182.0 |
| 2023-08-10 02:00:00 | NQ | Futures | 16956.82 | 16974.9 | 16950.42 | 16959.32 | 4608.0 |
| 2023-08-10 03:00:00 | NQ | Futures | 16960.44 | 17014.95 | 16959.32 | 16997.98 | 10907.0 |
| 2023-08-10 04:00:00 | NQ | Futures | 16997.98 | 17012.17 | 16979.35 | 16996.32 | 7768.0 |
| 2023-08-10 05:00:00 | NQ | Futures | 16996.32 | 17009.94 | 16985.19 | 17000.77 | 5778.0 |
| 2023-08-10 06:00:00 | NQ | Futures | 17001.32 | 17003.83 | 16973.79 | 16987.97 | 7017.0 |
| 2023-08-10 07:00:00 | NQ | Futures | 16987.69 | 17004.66 | 16972.4 | 16980.46 | 8955.0 |
| 2023-08-10 08:00:00 | NQ | Futures | 16980.46 | 17085.6 | 16959.32 | 17052.22 | 61899.0 |
| 2023-08-10 09:00:00 | NQ | Futures | 17053.61 | 17161.25 | 16991.87 | 17157.63 | 110278.0 |
| 2023-08-10 10:00:00 | NQ | Futures | 17157.63 | 17179.88 | 17028.86 | 17056.95 | 138648.0 |
| 2023-08-10 11:00:00 | NQ | Futures | 17056.95 | 17064.18 | 16917.6 | 16952.09 | 111975.0 |
| 2023-08-10 12:00:00 | NQ | Futures | 16952.09 | 17000.21 | 16906.2 | 16924.56 | 77963.0 |
| 2023-08-10 13:00:00 | NQ | Futures | 16924.84 | 16947.64 | 16839.17 | 16848.35 | 73018.0 |
| 2023-08-10 14:00:00 | NQ | Futures | 16849.46 | 16962.66 | 16845.29 | 16959.6 | 64227.0 |
| 2023-08-10 15:00:00 | NQ | Futures | 16960.72 | 16964.33 | 16881.17 | 16910.93 | 66158.0 |
| 2023-08-10 16:00:00 | NQ | Futures | 16910.93 | 16934.29 | 16902.03 | 16930.12 | 12205.0 |
| 2023-08-10 18:00:00 | NQ | Futures | 16931.51 | 16951.81 | 16927.34 | 16947.09 | 2565.0 |
| 2023-08-10 19:00:00 | NQ | Futures | 16947.09 | 16958.77 | 16934.85 | 16954.6 | 2191.0 |
| 2023-08-10 20:00:00 | NQ | Futures | 16954.87 | 16984.63 | 16952.09 | 16979.07 | 4134.0 |
| 2023-08-10 21:00:00 | NQ | Futures | 16979.35 | 16983.8 | 16960.44 | 16962.94 | 4715.0 |
| 2023-08-10 22:00:00 | NQ | Futures | 16963.22 | 16963.22 | 16931.51 | 16939.3 | 5143.0 |
| 2023-08-10 23:00:00 | NQ | Futures | 16939.02 | 16949.87 | 16916.21 | 16922.89 | 4114.0 |
| 2023-08-10 00:00:00 | YM | Futures | 38714.4 | 38723.1 | 38702.3 | 38702.3 | 492.0 |
| 2023-08-10 01:00:00 | YM | Futures | 38704.5 | 38716.6 | 38681.5 | 38714.4 | 899.0 |
| 2023-08-10 02:00:00 | YM | Futures | 38714.4 | 38737.4 | 38688.1 | 38688.1 | 1728.0 |
| 2023-08-10 03:00:00 | YM | Futures | 38689.2 | 38811.9 | 38688.1 | 38773.5 | 4538.0 |
> showing 50 of 2,045 rows — these rows as CSV