PREVIEW / futures_1hour / 2022-03-16
file: by_date/futures_1hour/2022/2022-03-16.parquet size: 69 KB rows: 2,031
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-16 00:00:00 | ES | Futures | 4816.22 | 4821.32 | 4813.95 | 4819.33 | 3447.0 |
| 2022-03-16 01:00:00 | ES | Futures | 4819.33 | 4849.66 | 4817.92 | 4839.74 | 16014.0 |
| 2022-03-16 02:00:00 | ES | Futures | 4839.46 | 4857.31 | 4838.04 | 4856.75 | 11743.0 |
| 2022-03-16 03:00:00 | ES | Futures | 4856.46 | 4862.42 | 4850.8 | 4861.28 | 16180.0 |
| 2022-03-16 04:00:00 | ES | Futures | 4861.57 | 4877.44 | 4857.03 | 4871.77 | 36917.0 |
| 2022-03-16 05:00:00 | ES | Futures | 4871.77 | 4881.97 | 4870.92 | 4872.34 | 19019.0 |
| 2022-03-16 06:00:00 | ES | Futures | 4872.62 | 4891.89 | 4870.92 | 4884.24 | 27711.0 |
| 2022-03-16 07:00:00 | ES | Futures | 4883.96 | 4886.79 | 4875.74 | 4886.51 | 19296.0 |
| 2022-03-16 08:00:00 | ES | Futures | 4886.51 | 4890.19 | 4868.65 | 4870.64 | 28499.0 |
| 2022-03-16 09:00:00 | ES | Futures | 4870.92 | 4899.83 | 4864.12 | 4891.33 | 174736.0 |
| 2022-03-16 10:00:00 | ES | Futures | 4891.33 | 4920.24 | 4877.44 | 4906.92 | 281409.0 |
| 2022-03-16 11:00:00 | ES | Futures | 4906.92 | 4908.9 | 4894.16 | 4903.8 | 101137.0 |
| 2022-03-16 12:00:00 | ES | Futures | 4904.08 | 4910.32 | 4882.54 | 4888.78 | 96507.0 |
| 2022-03-16 13:00:00 | ES | Futures | 4888.78 | 4891.33 | 4869.79 | 4884.24 | 101477.0 |
| 2022-03-16 14:00:00 | ES | Futures | 4883.67 | 4885.38 | 4809.7 | 4868.37 | 312456.0 |
| 2022-03-16 15:00:00 | ES | Futures | 4868.37 | 4933.84 | 4861.28 | 4932.71 | 293076.0 |
| 2022-03-16 16:00:00 | ES | Futures | 4932.99 | 4951.7 | 4925.62 | 4945.75 | 85936.0 |
| 2022-03-16 18:00:00 | ES | Futures | 4944.33 | 4945.75 | 4931.01 | 4935.83 | 6902.0 |
| 2022-03-16 19:00:00 | ES | Futures | 4936.11 | 4941.5 | 4930.44 | 4939.8 | 6253.0 |
| 2022-03-16 20:00:00 | ES | Futures | 4939.51 | 4942.91 | 4934.13 | 4940.65 | 7506.0 |
| 2022-03-16 21:00:00 | ES | Futures | 4940.65 | 4941.21 | 4914.29 | 4921.09 | 14013.0 |
| 2022-03-16 22:00:00 | ES | Futures | 4921.37 | 4930.16 | 4919.67 | 4924.49 | 7474.0 |
| 2022-03-16 23:00:00 | ES | Futures | 4924.21 | 4926.47 | 4916.55 | 4922.22 | 6154.0 |
| 2022-03-16 00:00:00 | NQ | Futures | 15603.56 | 15623.86 | 15597.47 | 15617.77 | 1410.0 |
| 2022-03-16 01:00:00 | NQ | Futures | 15618.06 | 15768.84 | 15609.36 | 15727.38 | 8981.0 |
| 2022-03-16 02:00:00 | NQ | Futures | 15725.64 | 15769.71 | 15712.01 | 15768.26 | 4988.0 |
| 2022-03-16 03:00:00 | NQ | Futures | 15767.97 | 15805.67 | 15750.28 | 15796.97 | 6933.0 |
| 2022-03-16 04:00:00 | NQ | Futures | 15797.26 | 15867.43 | 15777.83 | 15846.85 | 12857.0 |
| 2022-03-16 05:00:00 | NQ | Futures | 15847.72 | 15895.27 | 15844.24 | 15860.48 | 7251.0 |
| 2022-03-16 06:00:00 | NQ | Futures | 15860.19 | 15914.12 | 15854.68 | 15888.31 | 9522.0 |
| 2022-03-16 07:00:00 | NQ | Futures | 15887.73 | 15898.75 | 15850.62 | 15894.69 | 8856.0 |
| 2022-03-16 08:00:00 | NQ | Futures | 15894.4 | 15908.61 | 15823.65 | 15830.61 | 14469.0 |
| 2022-03-16 09:00:00 | NQ | Futures | 15830.03 | 15945.15 | 15788.85 | 15914.99 | 58921.0 |
| 2022-03-16 10:00:00 | NQ | Futures | 15915.57 | 16083.76 | 15879.32 | 16042.87 | 86053.0 |
| 2022-03-16 11:00:00 | NQ | Futures | 16043.16 | 16056.79 | 15994.15 | 16023.73 | 37882.0 |
| 2022-03-16 12:00:00 | NQ | Futures | 16025.18 | 16043.16 | 15903.1 | 15921.66 | 36581.0 |
| 2022-03-16 13:00:00 | NQ | Futures | 15922.24 | 15955.59 | 15847.43 | 15942.25 | 40052.0 |
| 2022-03-16 14:00:00 | NQ | Futures | 15942.25 | 15988.64 | 15615.74 | 15931.23 | 139035.0 |
| 2022-03-16 15:00:00 | NQ | Futures | 15930.36 | 16189.31 | 15892.08 | 16186.41 | 90241.0 |
| 2022-03-16 16:00:00 | NQ | Futures | 16186.12 | 16268.47 | 16164.37 | 16238.02 | 23818.0 |
| 2022-03-16 18:00:00 | NQ | Futures | 16228.16 | 16232.8 | 16185.25 | 16191.63 | 3844.0 |
| 2022-03-16 19:00:00 | NQ | Futures | 16192.79 | 16219.46 | 16176.26 | 16213.37 | 3206.0 |
| 2022-03-16 20:00:00 | NQ | Futures | 16212.21 | 16232.22 | 16189.89 | 16227.87 | 3767.0 |
| 2022-03-16 21:00:00 | NQ | Futures | 16227.87 | 16230.19 | 16122.61 | 16143.49 | 6763.0 |
| 2022-03-16 22:00:00 | NQ | Futures | 16144.65 | 16186.12 | 16138.85 | 16172.49 | 3966.0 |
| 2022-03-16 23:00:00 | NQ | Futures | 16171.33 | 16177.42 | 16140.01 | 16167.85 | 2828.0 |
| 2022-03-16 00:00:00 | YM | Futures | 37641.6 | 37670.9 | 37626.9 | 37655.1 | 685.0 |
| 2022-03-16 01:00:00 | YM | Futures | 37658.5 | 37840.0 | 37650.6 | 37772.3 | 3373.0 |
| 2022-03-16 02:00:00 | YM | Futures | 37770.1 | 37915.5 | 37761.1 | 37908.8 | 3577.0 |
| 2022-03-16 03:00:00 | YM | Futures | 37907.6 | 37942.6 | 37864.8 | 37934.7 | 4810.0 |
> showing 50 of 2,031 rows — these rows as CSV