PREVIEW / futures_1hour / 2022-03-02
file: by_date/futures_1hour/2022/2022-03-02.parquet size: 71 KB rows: 2,075
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-02 00:00:00 | ES | Futures | 4885.69 | 4893.32 | 4883.71 | 4885.69 | 7357.0 |
| 2022-03-02 01:00:00 | ES | Futures | 4885.69 | 4888.23 | 4865.33 | 4869.57 | 9532.0 |
| 2022-03-02 02:00:00 | ES | Futures | 4869.29 | 4872.68 | 4839.59 | 4857.69 | 28757.0 |
| 2022-03-02 03:00:00 | ES | Futures | 4857.69 | 4883.71 | 4847.51 | 4860.8 | 45918.0 |
| 2022-03-02 04:00:00 | ES | Futures | 4860.8 | 4909.16 | 4854.3 | 4901.81 | 43530.0 |
| 2022-03-02 05:00:00 | ES | Futures | 4901.81 | 4912.84 | 4890.78 | 4896.44 | 28093.0 |
| 2022-03-02 06:00:00 | ES | Futures | 4896.15 | 4909.16 | 4890.5 | 4901.24 | 25423.0 |
| 2022-03-02 07:00:00 | ES | Futures | 4901.24 | 4909.16 | 4886.82 | 4896.72 | 32715.0 |
| 2022-03-02 08:00:00 | ES | Futures | 4896.72 | 4897.28 | 4871.55 | 4884.28 | 56534.0 |
| 2022-03-02 09:00:00 | ES | Futures | 4884.28 | 4921.6 | 4882.86 | 4908.6 | 177610.0 |
| 2022-03-02 10:00:00 | ES | Futures | 4908.6 | 4931.5 | 4885.41 | 4918.78 | 267648.0 |
| 2022-03-02 11:00:00 | ES | Futures | 4918.78 | 4962.05 | 4908.03 | 4947.91 | 237580.0 |
| 2022-03-02 12:00:00 | ES | Futures | 4948.19 | 4959.78 | 4941.68 | 4956.11 | 106202.0 |
| 2022-03-02 13:00:00 | ES | Futures | 4956.11 | 4973.64 | 4956.11 | 4967.14 | 94135.0 |
| 2022-03-02 14:00:00 | ES | Futures | 4967.14 | 4974.77 | 4954.41 | 4958.09 | 96071.0 |
| 2022-03-02 15:00:00 | ES | Futures | 4958.09 | 4976.47 | 4953.84 | 4956.39 | 259498.0 |
| 2022-03-02 16:00:00 | ES | Futures | 4956.39 | 4958.37 | 4943.38 | 4947.62 | 61843.0 |
| 2022-03-02 18:00:00 | ES | Futures | 4947.62 | 4951.3 | 4943.95 | 4949.04 | 6963.0 |
| 2022-03-02 19:00:00 | ES | Futures | 4949.32 | 4951.86 | 4946.49 | 4949.32 | 7344.0 |
| 2022-03-02 20:00:00 | ES | Futures | 4949.32 | 4954.13 | 4943.66 | 4943.95 | 10461.0 |
| 2022-03-02 21:00:00 | ES | Futures | 4943.95 | 4959.22 | 4943.38 | 4957.24 | 8395.0 |
| 2022-03-02 22:00:00 | ES | Futures | 4957.24 | 4962.05 | 4954.69 | 4958.65 | 4196.0 |
| 2022-03-02 23:00:00 | ES | Futures | 4958.65 | 4960.35 | 4956.39 | 4957.52 | 3141.0 |
| 2022-03-02 00:00:00 | NQ | Futures | 16308.59 | 16339.89 | 16298.16 | 16307.43 | 5486.0 |
| 2022-03-02 01:00:00 | NQ | Futures | 16305.98 | 16313.23 | 16225.12 | 16237.01 | 5024.0 |
| 2022-03-02 02:00:00 | NQ | Futures | 16236.72 | 16247.15 | 16127.17 | 16194.98 | 14365.0 |
| 2022-03-02 03:00:00 | NQ | Futures | 16195.27 | 16299.32 | 16161.65 | 16215.27 | 19226.0 |
| 2022-03-02 04:00:00 | NQ | Futures | 16214.69 | 16365.97 | 16188.03 | 16336.41 | 17800.0 |
| 2022-03-02 05:00:00 | NQ | Futures | 16337.86 | 16397.85 | 16314.39 | 16341.34 | 14996.0 |
| 2022-03-02 06:00:00 | NQ | Futures | 16340.47 | 16394.38 | 16329.17 | 16351.77 | 11879.0 |
| 2022-03-02 07:00:00 | NQ | Futures | 16351.77 | 16380.18 | 16306.27 | 16330.33 | 12257.0 |
| 2022-03-02 08:00:00 | NQ | Futures | 16331.49 | 16333.23 | 16235.27 | 16268.31 | 22286.0 |
| 2022-03-02 09:00:00 | NQ | Futures | 16268.02 | 16380.18 | 16242.51 | 16317.29 | 76103.0 |
| 2022-03-02 10:00:00 | NQ | Futures | 16316.42 | 16374.67 | 16172.96 | 16285.12 | 122872.0 |
| 2022-03-02 11:00:00 | NQ | Futures | 16285.41 | 16488.28 | 16244.54 | 16419.59 | 78951.0 |
| 2022-03-02 12:00:00 | NQ | Futures | 16419.01 | 16474.95 | 16402.2 | 16451.47 | 38709.0 |
| 2022-03-02 13:00:00 | NQ | Futures | 16452.34 | 16536.97 | 16452.34 | 16500.74 | 32876.0 |
| 2022-03-02 14:00:00 | NQ | Futures | 16500.16 | 16558.99 | 16482.48 | 16506.83 | 32581.0 |
| 2022-03-02 15:00:00 | NQ | Futures | 16505.96 | 16565.95 | 16497.55 | 16505.09 | 61329.0 |
| 2022-03-02 16:00:00 | NQ | Futures | 16505.09 | 16510.59 | 16429.44 | 16457.85 | 18210.0 |
| 2022-03-02 18:00:00 | NQ | Futures | 16457.56 | 16472.05 | 16445.09 | 16468.57 | 4084.0 |
| 2022-03-02 19:00:00 | NQ | Futures | 16468.28 | 16478.13 | 16455.24 | 16470.02 | 3889.0 |
| 2022-03-02 20:00:00 | NQ | Futures | 16469.44 | 16489.15 | 16440.46 | 16445.38 | 5116.0 |
| 2022-03-02 21:00:00 | NQ | Futures | 16445.67 | 16494.94 | 16441.91 | 16488.57 | 4410.0 |
| 2022-03-02 22:00:00 | NQ | Futures | 16489.73 | 16507.12 | 16476.97 | 16489.73 | 2790.0 |
| 2022-03-02 23:00:00 | NQ | Futures | 16489.44 | 16501.03 | 16480.16 | 16484.51 | 2381.0 |
| 2022-03-02 00:00:00 | YM | Futures | 37525.9 | 37584.4 | 37510.2 | 37529.3 | 1512.0 |
| 2022-03-02 01:00:00 | YM | Futures | 37527.1 | 37555.2 | 37384.3 | 37414.7 | 2210.0 |
| 2022-03-02 02:00:00 | YM | Futures | 37418.1 | 37446.1 | 37221.4 | 37354.0 | 7584.0 |
| 2022-03-02 03:00:00 | YM | Futures | 37355.1 | 37530.4 | 37283.2 | 37355.1 | 14851.0 |
> showing 50 of 2,075 rows — these rows as CSV