PREVIEW / futures_1hour / 2022-08-01
file: by_date/futures_1hour/2022/2022-08-01.parquet size: 69 KB rows: 2,055
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-01 00:00:00 | ES | Futures | 4661.23 | 4664.35 | 4660.67 | 4664.35 | 2722.0 |
| 2022-08-01 01:00:00 | ES | Futures | 4664.35 | 4664.91 | 4658.12 | 4664.35 | 4417.0 |
| 2022-08-01 02:00:00 | ES | Futures | 4664.63 | 4666.33 | 4661.52 | 4665.76 | 7309.0 |
| 2022-08-01 03:00:00 | ES | Futures | 4665.48 | 4677.66 | 4665.48 | 4673.13 | 18238.0 |
| 2022-08-01 04:00:00 | ES | Futures | 4673.41 | 4676.81 | 4664.91 | 4666.61 | 12297.0 |
| 2022-08-01 05:00:00 | ES | Futures | 4666.9 | 4676.25 | 4666.33 | 4673.98 | 8877.0 |
| 2022-08-01 06:00:00 | ES | Futures | 4674.26 | 4677.38 | 4672.0 | 4673.98 | 7462.0 |
| 2022-08-01 07:00:00 | ES | Futures | 4673.98 | 4684.18 | 4673.41 | 4677.66 | 13458.0 |
| 2022-08-01 08:00:00 | ES | Futures | 4677.38 | 4677.66 | 4653.02 | 4653.87 | 46539.0 |
| 2022-08-01 09:00:00 | ES | Futures | 4654.15 | 4680.49 | 4642.25 | 4673.7 | 234828.0 |
| 2022-08-01 10:00:00 | ES | Futures | 4673.7 | 4699.19 | 4660.67 | 4694.94 | 304783.0 |
| 2022-08-01 11:00:00 | ES | Futures | 4694.94 | 4699.19 | 4677.66 | 4691.26 | 191263.0 |
| 2022-08-01 12:00:00 | ES | Futures | 4691.26 | 4692.68 | 4674.83 | 4681.34 | 130044.0 |
| 2022-08-01 13:00:00 | ES | Futures | 4681.63 | 4681.63 | 4649.62 | 4660.38 | 205989.0 |
| 2022-08-01 14:00:00 | ES | Futures | 4660.38 | 4679.65 | 4651.32 | 4675.96 | 189040.0 |
| 2022-08-01 15:00:00 | ES | Futures | 4675.96 | 4681.34 | 4665.2 | 4668.03 | 244081.0 |
| 2022-08-01 16:00:00 | ES | Futures | 4668.03 | 4672.56 | 4666.05 | 4671.71 | 43055.0 |
| 2022-08-01 18:00:00 | ES | Futures | 4668.03 | 4670.58 | 4662.65 | 4666.33 | 6130.0 |
| 2022-08-01 19:00:00 | ES | Futures | 4666.33 | 4670.86 | 4660.67 | 4661.23 | 6398.0 |
| 2022-08-01 20:00:00 | ES | Futures | 4661.23 | 4663.22 | 4651.88 | 4652.17 | 10753.0 |
| 2022-08-01 21:00:00 | ES | Futures | 4652.17 | 4655.0 | 4644.52 | 4649.05 | 13596.0 |
| 2022-08-01 22:00:00 | ES | Futures | 4649.05 | 4650.18 | 4641.4 | 4648.2 | 8081.0 |
| 2022-08-01 23:00:00 | ES | Futures | 4648.2 | 4653.58 | 4646.79 | 4650.18 | 6085.0 |
| 2022-08-01 00:00:00 | NQ | Futures | 14943.54 | 14957.13 | 14940.93 | 14956.55 | 1743.0 |
| 2022-08-01 01:00:00 | NQ | Futures | 14955.97 | 14958.29 | 14928.21 | 14947.87 | 2384.0 |
| 2022-08-01 02:00:00 | NQ | Futures | 14948.74 | 14955.1 | 14937.17 | 14951.63 | 2598.0 |
| 2022-08-01 03:00:00 | NQ | Futures | 14951.63 | 15002.25 | 14951.63 | 14988.08 | 8052.0 |
| 2022-08-01 04:00:00 | NQ | Futures | 14987.79 | 14990.39 | 14937.17 | 14948.16 | 6416.0 |
| 2022-08-01 05:00:00 | NQ | Futures | 14948.16 | 14981.14 | 14946.72 | 14973.04 | 4727.0 |
| 2022-08-01 06:00:00 | NQ | Futures | 14973.33 | 14986.63 | 14964.94 | 14976.22 | 3683.0 |
| 2022-08-01 07:00:00 | NQ | Futures | 14977.09 | 15026.55 | 14975.35 | 15001.09 | 8117.0 |
| 2022-08-01 08:00:00 | NQ | Futures | 15001.09 | 15003.12 | 14926.18 | 14926.18 | 16602.0 |
| 2022-08-01 09:00:00 | NQ | Futures | 14926.76 | 15068.2 | 14868.91 | 15029.73 | 90161.0 |
| 2022-08-01 10:00:00 | NQ | Futures | 15028.86 | 15166.25 | 15000.8 | 15143.4 | 112664.0 |
| 2022-08-01 11:00:00 | NQ | Futures | 15143.69 | 15156.99 | 15074.85 | 15131.54 | 69005.0 |
| 2022-08-01 12:00:00 | NQ | Futures | 15131.25 | 15138.48 | 15030.31 | 15052.29 | 54004.0 |
| 2022-08-01 13:00:00 | NQ | Futures | 15052.87 | 15052.87 | 14921.84 | 14962.63 | 69642.0 |
| 2022-08-01 14:00:00 | NQ | Futures | 14963.2 | 15038.41 | 14934.28 | 15027.41 | 60570.0 |
| 2022-08-01 15:00:00 | NQ | Futures | 15027.13 | 15041.3 | 14971.3 | 14997.62 | 67681.0 |
| 2022-08-01 16:00:00 | NQ | Futures | 14997.62 | 15019.89 | 14990.39 | 15017.58 | 12629.0 |
| 2022-08-01 18:00:00 | NQ | Futures | 15010.64 | 15011.22 | 14983.74 | 14995.02 | 2470.0 |
| 2022-08-01 19:00:00 | NQ | Futures | 14994.15 | 15012.37 | 14980.85 | 14984.9 | 2681.0 |
| 2022-08-01 20:00:00 | NQ | Futures | 14984.32 | 14989.52 | 14950.48 | 14952.79 | 4728.0 |
| 2022-08-01 21:00:00 | NQ | Futures | 14951.63 | 14959.44 | 14916.35 | 14932.54 | 5612.0 |
| 2022-08-01 22:00:00 | NQ | Futures | 14933.12 | 14937.75 | 14905.93 | 14935.15 | 3751.0 |
| 2022-08-01 23:00:00 | NQ | Futures | 14934.57 | 14953.66 | 14925.31 | 14936.59 | 3230.0 |
| 2022-08-01 00:00:00 | YM | Futures | 36867.5 | 36882.2 | 36861.9 | 36882.2 | 641.0 |
| 2022-08-01 01:00:00 | YM | Futures | 36882.2 | 36898.0 | 36851.7 | 36893.4 | 1415.0 |
| 2022-08-01 02:00:00 | YM | Futures | 36894.6 | 36910.4 | 36876.5 | 36905.9 | 2153.0 |
| 2022-08-01 03:00:00 | YM | Futures | 36905.9 | 36976.9 | 36905.9 | 36945.4 | 4381.0 |
> showing 50 of 2,055 rows — these rows as CSV