PREVIEW / futures_1hour / 2022-12-09
file: by_date/futures_1hour/2022/2022-12-09.parquet size: 56 KB rows: 1,596
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-12-09 00:00:00 | ES | Futures | 4480.98 | 4482.95 | 4480.13 | 4481.26 | 4093.0 |
| 2022-12-09 01:00:00 | ES | Futures | 4481.26 | 4486.05 | 4480.42 | 4485.77 | 5332.0 |
| 2022-12-09 02:00:00 | ES | Futures | 4485.49 | 4490.85 | 4481.26 | 4487.75 | 9780.0 |
| 2022-12-09 03:00:00 | ES | Futures | 4487.46 | 4489.16 | 4478.73 | 4481.83 | 12909.0 |
| 2022-12-09 04:00:00 | ES | Futures | 4481.83 | 4484.65 | 4476.75 | 4478.44 | 8466.0 |
| 2022-12-09 05:00:00 | ES | Futures | 4478.44 | 4488.59 | 4478.44 | 4486.62 | 9024.0 |
| 2022-12-09 06:00:00 | ES | Futures | 4486.34 | 4490.85 | 4484.65 | 4488.03 | 10820.0 |
| 2022-12-09 07:00:00 | ES | Futures | 4488.03 | 4498.46 | 4484.65 | 4497.05 | 15398.0 |
| 2022-12-09 08:00:00 | ES | Futures | 4497.05 | 4499.02 | 4431.37 | 4462.09 | 94128.0 |
| 2022-12-09 09:00:00 | ES | Futures | 4462.09 | 4478.73 | 4447.15 | 4466.32 | 152898.0 |
| 2022-12-09 10:00:00 | ES | Futures | 4464.63 | 4482.11 | 4453.92 | 4481.54 | 205915.0 |
| 2022-12-09 11:00:00 | ES | Futures | 4481.83 | 4487.18 | 4470.83 | 4484.36 | 121552.0 |
| 2022-12-09 12:00:00 | ES | Futures | 4484.36 | 4485.77 | 4472.81 | 4475.06 | 65963.0 |
| 2022-12-09 13:00:00 | ES | Futures | 4475.06 | 4475.06 | 4461.53 | 4468.3 | 77043.0 |
| 2022-12-09 14:00:00 | ES | Futures | 4468.3 | 4469.99 | 4457.87 | 4466.6 | 68889.0 |
| 2022-12-09 15:00:00 | ES | Futures | 4466.6 | 4471.96 | 4436.72 | 4438.41 | 166403.0 |
| 2022-12-09 16:00:00 | ES | Futures | 4438.41 | 4439.82 | 4432.49 | 4433.06 | 42704.0 |
| 2022-12-09 00:00:00 | NQ | Futures | 13421.85 | 13431.91 | 13419.56 | 13425.59 | 1657.0 |
| 2022-12-09 01:00:00 | NQ | Futures | 13426.16 | 13445.41 | 13424.73 | 13444.55 | 2265.0 |
| 2022-12-09 02:00:00 | NQ | Futures | 13444.55 | 13466.1 | 13423.87 | 13449.15 | 5668.0 |
| 2022-12-09 03:00:00 | NQ | Futures | 13449.15 | 13454.32 | 13420.42 | 13436.22 | 6934.0 |
| 2022-12-09 04:00:00 | NQ | Futures | 13435.65 | 13446.56 | 13407.2 | 13414.67 | 5796.0 |
| 2022-12-09 05:00:00 | NQ | Futures | 13415.25 | 13452.02 | 13414.67 | 13444.84 | 4275.0 |
| 2022-12-09 06:00:00 | NQ | Futures | 13444.55 | 13457.48 | 13431.05 | 13448.0 | 5890.0 |
| 2022-12-09 07:00:00 | NQ | Futures | 13448.58 | 13487.94 | 13435.36 | 13481.04 | 8010.0 |
| 2022-12-09 08:00:00 | NQ | Futures | 13481.33 | 13502.02 | 13236.53 | 13352.9 | 43495.0 |
| 2022-12-09 09:00:00 | NQ | Futures | 13352.61 | 13401.74 | 13274.46 | 13346.57 | 74286.0 |
| 2022-12-09 10:00:00 | NQ | Futures | 13348.3 | 13453.46 | 13302.33 | 13452.02 | 91295.0 |
| 2022-12-09 11:00:00 | NQ | Futures | 13452.6 | 13466.96 | 13407.2 | 13454.32 | 47227.0 |
| 2022-12-09 12:00:00 | NQ | Futures | 13454.61 | 13467.83 | 13423.29 | 13429.04 | 26844.0 |
| 2022-12-09 13:00:00 | NQ | Futures | 13428.75 | 13428.75 | 13368.41 | 13404.04 | 27629.0 |
| 2022-12-09 14:00:00 | NQ | Futures | 13402.32 | 13412.37 | 13364.96 | 13399.16 | 21149.0 |
| 2022-12-09 15:00:00 | NQ | Futures | 13398.58 | 13415.82 | 13291.98 | 13298.59 | 38613.0 |
| 2022-12-09 16:00:00 | NQ | Futures | 13297.44 | 13302.61 | 13274.74 | 13277.9 | 8443.0 |
| 2022-12-09 00:00:00 | YM | Futures | 37986.5 | 37993.2 | 37973.0 | 37983.1 | 641.0 |
| 2022-12-09 01:00:00 | YM | Futures | 37983.1 | 38004.4 | 37970.8 | 38000.0 | 577.0 |
| 2022-12-09 02:00:00 | YM | Futures | 38003.3 | 38033.6 | 37974.1 | 38015.7 | 1444.0 |
| 2022-12-09 03:00:00 | YM | Futures | 38015.7 | 38029.1 | 37952.8 | 37965.2 | 1951.0 |
| 2022-12-09 04:00:00 | YM | Futures | 37964.0 | 37982.0 | 37940.5 | 37953.9 | 1537.0 |
| 2022-12-09 05:00:00 | YM | Futures | 37956.2 | 38017.9 | 37953.9 | 38006.7 | 1186.0 |
| 2022-12-09 06:00:00 | YM | Futures | 38004.4 | 38037.0 | 37997.7 | 38012.3 | 1576.0 |
| 2022-12-09 07:00:00 | YM | Futures | 38013.4 | 38098.7 | 37992.1 | 38092.0 | 3273.0 |
| 2022-12-09 08:00:00 | YM | Futures | 38092.0 | 38111.1 | 37648.7 | 37861.9 | 14398.0 |
| 2022-12-09 09:00:00 | YM | Futures | 37860.8 | 37947.2 | 37775.5 | 37844.0 | 17788.0 |
| 2022-12-09 10:00:00 | YM | Futures | 37845.1 | 37953.9 | 37767.7 | 37950.6 | 16762.0 |
| 2022-12-09 11:00:00 | YM | Futures | 37948.3 | 38014.5 | 37879.9 | 37992.1 | 11580.0 |
| 2022-12-09 12:00:00 | YM | Futures | 37993.2 | 37997.7 | 37885.5 | 37905.7 | 6410.0 |
| 2022-12-09 13:00:00 | YM | Futures | 37905.7 | 37905.7 | 37817.0 | 37855.2 | 6742.0 |
| 2022-12-09 14:00:00 | YM | Futures | 37855.2 | 37861.9 | 37771.0 | 37829.4 | 4706.0 |
| 2022-12-09 15:00:00 | YM | Futures | 37828.3 | 37873.1 | 37581.4 | 37596.0 | 14618.0 |
> showing 50 of 1,596 rows — these rows as CSV