PREVIEW / futures_1hour / 2022-03-17
file: by_date/futures_1hour/2022/2022-03-17.parquet size: 68 KB rows: 2,026
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 |
|---|---|---|---|---|---|---|---|
| 2022-03-17 00:00:00 | ES | Futures | 4922.79 | 4929.59 | 4917.69 | 4927.89 | 5954.0 |
| 2022-03-17 01:00:00 | ES | Futures | 4927.61 | 4932.43 | 4923.07 | 4926.19 | 6828.0 |
| 2022-03-17 02:00:00 | ES | Futures | 4926.19 | 4941.78 | 4924.49 | 4939.23 | 6927.0 |
| 2022-03-17 03:00:00 | ES | Futures | 4939.23 | 4947.17 | 4921.09 | 4936.68 | 13501.0 |
| 2022-03-17 04:00:00 | ES | Futures | 4936.68 | 4938.95 | 4921.66 | 4926.47 | 17152.0 |
| 2022-03-17 05:00:00 | ES | Futures | 4926.47 | 4929.88 | 4915.99 | 4923.07 | 15137.0 |
| 2022-03-17 06:00:00 | ES | Futures | 4922.79 | 4923.92 | 4898.13 | 4920.52 | 34543.0 |
| 2022-03-17 07:00:00 | ES | Futures | 4920.81 | 4925.91 | 4909.75 | 4916.27 | 15793.0 |
| 2022-03-17 08:00:00 | ES | Futures | 4916.27 | 4925.06 | 4903.8 | 4910.32 | 30111.0 |
| 2022-03-17 09:00:00 | ES | Futures | 4910.32 | 4939.23 | 4904.37 | 4938.38 | 157624.0 |
| 2022-03-17 10:00:00 | ES | Futures | 4938.38 | 4947.73 | 4913.72 | 4922.79 | 171521.0 |
| 2022-03-17 11:00:00 | ES | Futures | 4922.51 | 4942.06 | 4917.4 | 4938.38 | 101351.0 |
| 2022-03-17 12:00:00 | ES | Futures | 4938.66 | 4958.79 | 4933.84 | 4956.8 | 91437.0 |
| 2022-03-17 13:00:00 | ES | Futures | 4957.09 | 4980.89 | 4948.3 | 4976.08 | 88941.0 |
| 2022-03-17 14:00:00 | ES | Futures | 4976.36 | 4979.19 | 4962.47 | 4975.51 | 98270.0 |
| 2022-03-17 15:00:00 | ES | Futures | 4975.23 | 4995.92 | 4960.49 | 4994.22 | 230297.0 |
| 2022-03-17 16:00:00 | ES | Futures | 4994.5 | 4996.2 | 4966.16 | 4970.69 | 84421.0 |
| 2022-03-17 18:00:00 | ES | Futures | 4970.69 | 4977.21 | 4961.9 | 4965.02 | 9488.0 |
| 2022-03-17 19:00:00 | ES | Futures | 4965.02 | 4968.99 | 4962.19 | 4965.31 | 5517.0 |
| 2022-03-17 20:00:00 | ES | Futures | 4965.59 | 4974.66 | 4956.8 | 4959.64 | 11403.0 |
| 2022-03-17 21:00:00 | ES | Futures | 4959.64 | 4962.19 | 4953.97 | 4961.34 | 8710.0 |
| 2022-03-17 22:00:00 | ES | Futures | 4961.34 | 4962.75 | 4955.1 | 4957.09 | 6244.0 |
| 2022-03-17 23:00:00 | ES | Futures | 4957.37 | 4958.22 | 4952.27 | 4957.65 | 4811.0 |
| 2022-03-17 00:00:00 | NQ | Futures | 16167.85 | 16209.32 | 16145.23 | 16199.75 | 3292.0 |
| 2022-03-17 01:00:00 | NQ | Futures | 16200.04 | 16223.52 | 16182.06 | 16190.47 | 3041.0 |
| 2022-03-17 02:00:00 | NQ | Futures | 16190.47 | 16245.56 | 16182.93 | 16238.02 | 3338.0 |
| 2022-03-17 03:00:00 | NQ | Futures | 16236.86 | 16264.41 | 16152.19 | 16204.97 | 8415.0 |
| 2022-03-17 04:00:00 | NQ | Futures | 16206.71 | 16213.66 | 16142.33 | 16158.86 | 9175.0 |
| 2022-03-17 05:00:00 | NQ | Futures | 16158.57 | 16169.59 | 16115.94 | 16154.22 | 8043.0 |
| 2022-03-17 06:00:00 | NQ | Futures | 16152.48 | 16155.38 | 16049.83 | 16140.01 | 14174.0 |
| 2022-03-17 07:00:00 | NQ | Futures | 16140.01 | 16159.73 | 16086.95 | 16116.52 | 8234.0 |
| 2022-03-17 08:00:00 | NQ | Futures | 16116.81 | 16155.09 | 16044.32 | 16070.71 | 16878.0 |
| 2022-03-17 09:00:00 | NQ | Futures | 16070.42 | 16218.3 | 16028.66 | 16214.53 | 68347.0 |
| 2022-03-17 10:00:00 | NQ | Futures | 16214.24 | 16253.39 | 16062.3 | 16095.93 | 76199.0 |
| 2022-03-17 11:00:00 | NQ | Futures | 16095.64 | 16186.41 | 16055.05 | 16149.29 | 51374.0 |
| 2022-03-17 12:00:00 | NQ | Futures | 16150.45 | 16230.19 | 16127.25 | 16217.72 | 37038.0 |
| 2022-03-17 13:00:00 | NQ | Futures | 16218.3 | 16345.31 | 16171.91 | 16319.8 | 45100.0 |
| 2022-03-17 14:00:00 | NQ | Futures | 16320.09 | 16333.71 | 16254.84 | 16308.2 | 39061.0 |
| 2022-03-17 15:00:00 | NQ | Futures | 16307.91 | 16380.11 | 16245.56 | 16377.21 | 61589.0 |
| 2022-03-17 16:00:00 | NQ | Futures | 16376.92 | 16392.29 | 16285.58 | 16301.53 | 18412.0 |
| 2022-03-17 18:00:00 | NQ | Futures | 16304.43 | 16322.41 | 16258.61 | 16269.63 | 4623.0 |
| 2022-03-17 19:00:00 | NQ | Futures | 16269.63 | 16282.68 | 16258.32 | 16266.15 | 3383.0 |
| 2022-03-17 20:00:00 | NQ | Futures | 16266.15 | 16298.05 | 16215.98 | 16221.49 | 5490.0 |
| 2022-03-17 21:00:00 | NQ | Futures | 16223.52 | 16234.54 | 16199.75 | 16230.77 | 5397.0 |
| 2022-03-17 22:00:00 | NQ | Futures | 16231.64 | 16238.02 | 16210.18 | 16223.81 | 3316.0 |
| 2022-03-17 23:00:00 | NQ | Futures | 16224.39 | 16238.31 | 16207.0 | 16229.61 | 2114.0 |
| 2022-03-17 00:00:00 | YM | Futures | 38208.6 | 38252.6 | 38179.3 | 38240.2 | 1045.0 |
| 2022-03-17 01:00:00 | YM | Futures | 38240.2 | 38271.8 | 38213.1 | 38230.0 | 1228.0 |
| 2022-03-17 02:00:00 | YM | Futures | 38232.3 | 38339.4 | 38222.1 | 38322.5 | 1423.0 |
| 2022-03-17 03:00:00 | YM | Futures | 38319.1 | 38374.3 | 38216.5 | 38328.1 | 2991.0 |
> showing 50 of 2,026 rows — these rows as CSV