PREVIEW / futures_1hour / 2021-09-21
file: by_date/futures_1hour/2021/2021-09-21.parquet size: 64 KB rows: 1,966
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 |
|---|---|---|---|---|---|---|---|
| 2021-09-21 00:00:00 | ES | Futures | 4935.89 | 4937.59 | 4933.35 | 4936.18 | 5500.0 |
| 2021-09-21 01:00:00 | ES | Futures | 4936.18 | 4939.28 | 4925.17 | 4927.99 | 12331.0 |
| 2021-09-21 02:00:00 | ES | Futures | 4927.99 | 4940.13 | 4924.89 | 4933.92 | 16255.0 |
| 2021-09-21 03:00:00 | ES | Futures | 4933.92 | 4956.5 | 4932.23 | 4956.21 | 39347.0 |
| 2021-09-21 04:00:00 | ES | Futures | 4956.21 | 4962.14 | 4951.42 | 4951.7 | 31483.0 |
| 2021-09-21 05:00:00 | ES | Futures | 4951.98 | 4955.37 | 4944.64 | 4951.98 | 19447.0 |
| 2021-09-21 06:00:00 | ES | Futures | 4952.26 | 4954.24 | 4947.18 | 4950.57 | 16390.0 |
| 2021-09-21 07:00:00 | ES | Futures | 4950.29 | 4950.85 | 4939.0 | 4945.21 | 30462.0 |
| 2021-09-21 08:00:00 | ES | Futures | 4945.21 | 4946.9 | 4932.23 | 4933.07 | 72513.0 |
| 2021-09-21 09:00:00 | ES | Futures | 4933.07 | 4950.01 | 4922.91 | 4932.79 | 269442.0 |
| 2021-09-21 10:00:00 | ES | Futures | 4933.07 | 4937.02 | 4895.26 | 4903.44 | 347543.0 |
| 2021-09-21 11:00:00 | ES | Futures | 4903.16 | 4931.1 | 4896.39 | 4926.86 | 230206.0 |
| 2021-09-21 12:00:00 | ES | Futures | 4927.15 | 4939.56 | 4916.42 | 4921.5 | 138062.0 |
| 2021-09-21 13:00:00 | ES | Futures | 4921.5 | 4924.32 | 4903.16 | 4908.24 | 124762.0 |
| 2021-09-21 14:00:00 | ES | Futures | 4908.24 | 4926.02 | 4900.62 | 4916.99 | 147853.0 |
| 2021-09-21 15:00:00 | ES | Futures | 4916.99 | 4929.12 | 4900.05 | 4902.31 | 241646.0 |
| 2021-09-21 16:00:00 | ES | Futures | 4902.03 | 4904.0 | 4887.07 | 4894.97 | 79069.0 |
| 2021-09-21 18:00:00 | ES | Futures | 4895.26 | 4898.64 | 4891.87 | 4893.0 | 8954.0 |
| 2021-09-21 19:00:00 | ES | Futures | 4893.0 | 4895.82 | 4889.05 | 4889.61 | 9337.0 |
| 2021-09-21 20:00:00 | ES | Futures | 4889.61 | 4889.61 | 4878.04 | 4884.53 | 20014.0 |
| 2021-09-21 21:00:00 | ES | Futures | 4884.53 | 4922.91 | 4880.3 | 4911.91 | 46516.0 |
| 2021-09-21 22:00:00 | ES | Futures | 4911.62 | 4913.04 | 4896.95 | 4910.5 | 17749.0 |
| 2021-09-21 23:00:00 | ES | Futures | 4910.21 | 4915.58 | 4904.57 | 4907.11 | 7815.0 |
| 2021-09-21 00:00:00 | NQ | Futures | 17484.67 | 17491.62 | 17476.84 | 17489.31 | 2182.0 |
| 2021-09-21 01:00:00 | NQ | Futures | 17489.02 | 17493.36 | 17447.28 | 17457.72 | 6635.0 |
| 2021-09-21 02:00:00 | NQ | Futures | 17458.59 | 17492.2 | 17446.7 | 17473.66 | 6284.0 |
| 2021-09-21 03:00:00 | NQ | Futures | 17473.66 | 17560.89 | 17467.86 | 17560.31 | 13350.0 |
| 2021-09-21 04:00:00 | NQ | Futures | 17559.73 | 17578.28 | 17544.37 | 17549.59 | 10199.0 |
| 2021-09-21 05:00:00 | NQ | Futures | 17549.88 | 17558.57 | 17516.26 | 17533.07 | 8036.0 |
| 2021-09-21 06:00:00 | NQ | Futures | 17533.07 | 17540.31 | 17518.87 | 17536.26 | 5146.0 |
| 2021-09-21 07:00:00 | NQ | Futures | 17535.68 | 17537.71 | 17507.85 | 17530.46 | 7451.0 |
| 2021-09-21 08:00:00 | NQ | Futures | 17530.75 | 17544.95 | 17475.39 | 17479.45 | 19495.0 |
| 2021-09-21 09:00:00 | NQ | Futures | 17479.74 | 17541.76 | 17422.36 | 17466.99 | 95287.0 |
| 2021-09-21 10:00:00 | NQ | Futures | 17467.28 | 17483.51 | 17359.47 | 17387.0 | 111502.0 |
| 2021-09-21 11:00:00 | NQ | Futures | 17387.58 | 17518.29 | 17364.1 | 17493.36 | 77147.0 |
| 2021-09-21 12:00:00 | NQ | Futures | 17493.94 | 17527.56 | 17438.3 | 17457.43 | 49033.0 |
| 2021-09-21 13:00:00 | NQ | Futures | 17456.56 | 17466.12 | 17391.93 | 17412.5 | 57585.0 |
| 2021-09-21 14:00:00 | NQ | Futures | 17412.5 | 17500.61 | 17390.77 | 17465.83 | 55424.0 |
| 2021-09-21 15:00:00 | NQ | Futures | 17466.12 | 17508.72 | 17405.55 | 17410.48 | 72531.0 |
| 2021-09-21 16:00:00 | NQ | Futures | 17410.48 | 17417.43 | 17346.43 | 17380.62 | 19836.0 |
| 2021-09-21 18:00:00 | NQ | Futures | 17380.62 | 17391.64 | 17372.8 | 17375.99 | 3300.0 |
| 2021-09-21 19:00:00 | NQ | Futures | 17376.86 | 17384.1 | 17354.83 | 17357.44 | 4114.0 |
| 2021-09-21 20:00:00 | NQ | Futures | 17357.44 | 17358.31 | 17308.46 | 17337.44 | 9582.0 |
| 2021-09-21 21:00:00 | NQ | Futures | 17337.15 | 17471.05 | 17321.79 | 17437.43 | 18813.0 |
| 2021-09-21 22:00:00 | NQ | Futures | 17436.85 | 17440.91 | 17390.48 | 17430.76 | 8721.0 |
| 2021-09-21 23:00:00 | NQ | Futures | 17430.76 | 17445.25 | 17408.45 | 17417.14 | 4314.0 |
| 2021-09-21 00:00:00 | YM | Futures | 38194.9 | 38202.8 | 38169.1 | 38181.5 | 1759.0 |
| 2021-09-21 01:00:00 | YM | Futures | 38180.3 | 38214.0 | 38092.9 | 38118.7 | 3074.0 |
| 2021-09-21 02:00:00 | YM | Futures | 38117.6 | 38227.4 | 38094.0 | 38171.4 | 4806.0 |
| 2021-09-21 03:00:00 | YM | Futures | 38170.3 | 38354.1 | 38156.8 | 38346.2 | 8973.0 |
> showing 50 of 1,966 rows — these rows as CSV