PREVIEW / futures_1hour / 2021-10-12
file: by_date/futures_1hour/2021/2021-10-12.parquet size: 65 KB rows: 1,993
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-10-12 00:00:00 | ES | Futures | 4885.66 | 4892.72 | 4885.66 | 4891.02 | 5305.0 |
| 2021-10-12 01:00:00 | ES | Futures | 4890.74 | 4897.51 | 4889.33 | 4894.69 | 8029.0 |
| 2021-10-12 02:00:00 | ES | Futures | 4894.69 | 4894.69 | 4873.53 | 4878.32 | 21134.0 |
| 2021-10-12 03:00:00 | ES | Futures | 4878.61 | 4896.67 | 4875.22 | 4893.0 | 30500.0 |
| 2021-10-12 04:00:00 | ES | Futures | 4893.28 | 4908.8 | 4888.77 | 4906.83 | 21791.0 |
| 2021-10-12 05:00:00 | ES | Futures | 4906.83 | 4917.55 | 4906.83 | 4912.75 | 23854.0 |
| 2021-10-12 06:00:00 | ES | Futures | 4912.75 | 4918.68 | 4906.26 | 4917.83 | 18983.0 |
| 2021-10-12 07:00:00 | ES | Futures | 4917.83 | 4921.22 | 4912.75 | 4913.32 | 14880.0 |
| 2021-10-12 08:00:00 | ES | Futures | 4913.04 | 4927.43 | 4912.75 | 4918.4 | 40807.0 |
| 2021-10-12 09:00:00 | ES | Futures | 4918.12 | 4927.43 | 4898.08 | 4904.85 | 183403.0 |
| 2021-10-12 10:00:00 | ES | Futures | 4904.85 | 4917.83 | 4898.64 | 4904.57 | 179951.0 |
| 2021-10-12 11:00:00 | ES | Futures | 4904.85 | 4920.66 | 4904.57 | 4918.68 | 100452.0 |
| 2021-10-12 12:00:00 | ES | Futures | 4918.68 | 4927.43 | 4903.44 | 4905.7 | 95575.0 |
| 2021-10-12 13:00:00 | ES | Futures | 4905.42 | 4913.6 | 4900.62 | 4905.98 | 87699.0 |
| 2021-10-12 14:00:00 | ES | Futures | 4905.7 | 4921.5 | 4904.0 | 4906.83 | 99492.0 |
| 2021-10-12 15:00:00 | ES | Futures | 4906.83 | 4907.67 | 4889.89 | 4899.49 | 180991.0 |
| 2021-10-12 16:00:00 | ES | Futures | 4899.49 | 4899.77 | 4883.69 | 4886.51 | 59943.0 |
| 2021-10-12 18:00:00 | ES | Futures | 4885.1 | 4889.61 | 4884.81 | 4887.92 | 5727.0 |
| 2021-10-12 19:00:00 | ES | Futures | 4888.2 | 4890.18 | 4883.69 | 4885.38 | 5834.0 |
| 2021-10-12 20:00:00 | ES | Futures | 4885.66 | 4897.8 | 4885.38 | 4896.1 | 11027.0 |
| 2021-10-12 21:00:00 | ES | Futures | 4896.1 | 4896.95 | 4886.79 | 4889.89 | 9970.0 |
| 2021-10-12 22:00:00 | ES | Futures | 4890.18 | 4891.59 | 4886.51 | 4889.05 | 5657.0 |
| 2021-10-12 23:00:00 | ES | Futures | 4889.33 | 4894.97 | 4889.33 | 4893.0 | 7373.0 |
| 2021-10-12 00:00:00 | NQ | Futures | 16948.8 | 16976.04 | 16948.22 | 16968.5 | 3021.0 |
| 2021-10-12 01:00:00 | NQ | Futures | 16968.21 | 16994.01 | 16963.29 | 16977.78 | 4339.0 |
| 2021-10-12 02:00:00 | NQ | Futures | 16978.07 | 16978.07 | 16914.6 | 16926.77 | 10216.0 |
| 2021-10-12 03:00:00 | NQ | Futures | 16927.35 | 17001.83 | 16909.67 | 16987.63 | 13271.0 |
| 2021-10-12 04:00:00 | NQ | Futures | 16988.21 | 17045.89 | 16977.78 | 17037.77 | 9818.0 |
| 2021-10-12 05:00:00 | NQ | Futures | 17038.35 | 17079.21 | 17038.06 | 17069.36 | 9799.0 |
| 2021-10-12 06:00:00 | NQ | Futures | 17069.65 | 17098.05 | 17053.42 | 17094.29 | 6906.0 |
| 2021-10-12 07:00:00 | NQ | Futures | 17094.0 | 17109.36 | 17076.61 | 17077.77 | 8241.0 |
| 2021-10-12 08:00:00 | NQ | Futures | 17077.19 | 17137.76 | 17072.55 | 17093.71 | 17115.0 |
| 2021-10-12 09:00:00 | NQ | Futures | 17093.13 | 17132.83 | 16991.98 | 16995.75 | 103487.0 |
| 2021-10-12 10:00:00 | NQ | Futures | 16996.04 | 17064.14 | 16963.58 | 16970.24 | 105422.0 |
| 2021-10-12 11:00:00 | NQ | Futures | 16970.82 | 17046.76 | 16970.82 | 17046.18 | 60310.0 |
| 2021-10-12 12:00:00 | NQ | Futures | 17046.47 | 17078.64 | 16986.18 | 16994.59 | 46876.0 |
| 2021-10-12 13:00:00 | NQ | Futures | 16994.3 | 17018.64 | 16966.77 | 16992.85 | 37113.0 |
| 2021-10-12 14:00:00 | NQ | Futures | 16992.56 | 17064.72 | 16985.02 | 17006.47 | 42283.0 |
| 2021-10-12 15:00:00 | NQ | Futures | 17006.76 | 17019.22 | 16950.25 | 16983.29 | 62626.0 |
| 2021-10-12 16:00:00 | NQ | Futures | 16983.58 | 16986.76 | 16908.51 | 16922.13 | 18140.0 |
| 2021-10-12 18:00:00 | NQ | Futures | 16918.37 | 16936.91 | 16914.89 | 16935.18 | 3370.0 |
| 2021-10-12 19:00:00 | NQ | Futures | 16935.18 | 16944.74 | 16927.06 | 16931.41 | 3079.0 |
| 2021-10-12 20:00:00 | NQ | Futures | 16931.7 | 16978.36 | 16930.54 | 16968.21 | 5579.0 |
| 2021-10-12 21:00:00 | NQ | Futures | 16968.5 | 16971.11 | 16934.31 | 16945.61 | 5341.0 |
| 2021-10-12 22:00:00 | NQ | Futures | 16945.03 | 16951.98 | 16923.29 | 16932.86 | 4779.0 |
| 2021-10-12 23:00:00 | NQ | Futures | 16932.86 | 16956.62 | 16932.86 | 16946.19 | 3193.0 |
| 2021-10-12 00:00:00 | YM | Futures | 38356.3 | 38402.3 | 38353.0 | 38388.8 | 984.0 |
| 2021-10-12 01:00:00 | YM | Futures | 38386.6 | 38438.2 | 38378.7 | 38410.1 | 1687.0 |
| 2021-10-12 02:00:00 | YM | Futures | 38406.8 | 38407.9 | 38251.0 | 38289.1 | 5830.0 |
| 2021-10-12 03:00:00 | YM | Futures | 38291.3 | 38419.1 | 38267.8 | 38386.6 | 6885.0 |
> showing 50 of 1,993 rows — these rows as CSV