PREVIEW / futures_1hour / 2022-08-25
file: by_date/futures_1hour/2022/2022-08-25.parquet size: 65 KB rows: 1,994
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-08-25 00:00:00 | ES | Futures | 4707.12 | 4714.77 | 4706.27 | 4713.64 | 5001.0 |
| 2022-08-25 01:00:00 | ES | Futures | 4713.64 | 4717.6 | 4711.37 | 4712.22 | 7952.0 |
| 2022-08-25 02:00:00 | ES | Futures | 4712.22 | 4745.08 | 4711.37 | 4737.72 | 33610.0 |
| 2022-08-25 03:00:00 | ES | Futures | 4738.28 | 4741.11 | 4733.47 | 4740.83 | 19069.0 |
| 2022-08-25 04:00:00 | ES | Futures | 4740.83 | 4742.81 | 4731.77 | 4734.6 | 11105.0 |
| 2022-08-25 05:00:00 | ES | Futures | 4734.6 | 4735.73 | 4713.92 | 4716.19 | 19825.0 |
| 2022-08-25 06:00:00 | ES | Futures | 4716.19 | 4721.29 | 4714.2 | 4719.02 | 10929.0 |
| 2022-08-25 07:00:00 | ES | Futures | 4719.02 | 4727.8 | 4716.47 | 4722.14 | 16221.0 |
| 2022-08-25 08:00:00 | ES | Futures | 4722.14 | 4725.82 | 4708.54 | 4714.49 | 32364.0 |
| 2022-08-25 09:00:00 | ES | Futures | 4714.2 | 4726.95 | 4699.47 | 4725.82 | 204077.0 |
| 2022-08-25 10:00:00 | ES | Futures | 4725.82 | 4741.96 | 4722.14 | 4733.47 | 246766.0 |
| 2022-08-25 11:00:00 | ES | Futures | 4733.75 | 4734.03 | 4709.67 | 4722.14 | 221058.0 |
| 2022-08-25 12:00:00 | ES | Futures | 4722.42 | 4722.99 | 4705.99 | 4715.05 | 132109.0 |
| 2022-08-25 13:00:00 | ES | Futures | 4715.34 | 4732.33 | 4712.5 | 4729.5 | 140712.0 |
| 2022-08-25 14:00:00 | ES | Futures | 4729.78 | 4732.62 | 4721.85 | 4728.37 | 111552.0 |
| 2022-08-25 15:00:00 | ES | Futures | 4728.37 | 4762.08 | 4726.38 | 4761.51 | 265051.0 |
| 2022-08-25 16:00:00 | ES | Futures | 4761.51 | 4762.08 | 4752.16 | 4753.58 | 61027.0 |
| 2022-08-25 18:00:00 | ES | Futures | 4756.98 | 4759.53 | 4750.75 | 4752.73 | 4830.0 |
| 2022-08-25 19:00:00 | ES | Futures | 4752.73 | 4758.96 | 4752.73 | 4754.71 | 6142.0 |
| 2022-08-25 20:00:00 | ES | Futures | 4754.71 | 4758.11 | 4750.46 | 4756.69 | 7561.0 |
| 2022-08-25 21:00:00 | ES | Futures | 4756.69 | 4758.96 | 4753.01 | 4757.83 | 8724.0 |
| 2022-08-25 22:00:00 | ES | Futures | 4757.83 | 4758.96 | 4756.41 | 4758.11 | 4876.0 |
| 2022-08-25 23:00:00 | ES | Futures | 4758.11 | 4758.96 | 4756.69 | 4756.98 | 4528.0 |
| 2022-08-25 00:00:00 | NQ | Futures | 14998.78 | 15025.39 | 14996.76 | 15019.03 | 2551.0 |
| 2022-08-25 01:00:00 | NQ | Futures | 15019.61 | 15034.36 | 15009.77 | 15014.69 | 3196.0 |
| 2022-08-25 02:00:00 | NQ | Futures | 15014.4 | 15139.35 | 15010.35 | 15117.66 | 14377.0 |
| 2022-08-25 03:00:00 | NQ | Futures | 15116.21 | 15125.18 | 15099.44 | 15124.31 | 8590.0 |
| 2022-08-25 04:00:00 | NQ | Futures | 15124.02 | 15136.17 | 15097.12 | 15109.27 | 7121.0 |
| 2022-08-25 05:00:00 | NQ | Futures | 15108.4 | 15115.34 | 15030.89 | 15044.77 | 10152.0 |
| 2022-08-25 06:00:00 | NQ | Futures | 15044.48 | 15077.16 | 15036.67 | 15067.04 | 6950.0 |
| 2022-08-25 07:00:00 | NQ | Futures | 15066.17 | 15093.94 | 15056.63 | 15070.51 | 7982.0 |
| 2022-08-25 08:00:00 | NQ | Futures | 15070.22 | 15084.68 | 15023.94 | 15048.82 | 15646.0 |
| 2022-08-25 09:00:00 | NQ | Futures | 15048.53 | 15097.12 | 14996.47 | 15091.05 | 73187.0 |
| 2022-08-25 10:00:00 | NQ | Futures | 15091.34 | 15176.95 | 15088.15 | 15128.94 | 81721.0 |
| 2022-08-25 11:00:00 | NQ | Futures | 15129.23 | 15130.67 | 15041.3 | 15093.07 | 74655.0 |
| 2022-08-25 12:00:00 | NQ | Futures | 15093.07 | 15102.33 | 15037.25 | 15073.69 | 41806.0 |
| 2022-08-25 13:00:00 | NQ | Futures | 15074.27 | 15149.47 | 15064.15 | 15135.01 | 45796.0 |
| 2022-08-25 14:00:00 | NQ | Futures | 15135.01 | 15143.11 | 15089.31 | 15116.21 | 37271.0 |
| 2022-08-25 15:00:00 | NQ | Futures | 15116.21 | 15227.28 | 15102.62 | 15224.39 | 72029.0 |
| 2022-08-25 16:00:00 | NQ | Futures | 15224.1 | 15226.12 | 15201.25 | 15207.9 | 15707.0 |
| 2022-08-25 18:00:00 | NQ | Futures | 15218.31 | 15235.67 | 15198.07 | 15203.85 | 2362.0 |
| 2022-08-25 19:00:00 | NQ | Futures | 15203.85 | 15226.99 | 15203.85 | 15207.9 | 3144.0 |
| 2022-08-25 20:00:00 | NQ | Futures | 15208.48 | 15218.6 | 15189.97 | 15213.68 | 4152.0 |
| 2022-08-25 21:00:00 | NQ | Futures | 15213.68 | 15218.02 | 15198.07 | 15213.11 | 3103.0 |
| 2022-08-25 22:00:00 | NQ | Futures | 15212.24 | 15216.0 | 15203.27 | 15212.53 | 1864.0 |
| 2022-08-25 23:00:00 | NQ | Futures | 15211.95 | 15224.39 | 15209.35 | 15216.29 | 2000.0 |
| 2022-08-25 00:00:00 | YM | Futures | 37242.1 | 37297.4 | 37236.5 | 37290.6 | 912.0 |
| 2022-08-25 01:00:00 | YM | Futures | 37291.8 | 37317.7 | 37269.2 | 37274.8 | 1222.0 |
| 2022-08-25 02:00:00 | YM | Futures | 37273.7 | 37505.0 | 37270.3 | 37452.0 | 7916.0 |
| 2022-08-25 03:00:00 | YM | Futures | 37452.0 | 37481.3 | 37428.3 | 37480.2 | 4976.0 |
> showing 50 of 1,994 rows — these rows as CSV