PREVIEW / futures_1hour / 2023-03-01
file: by_date/futures_1hour/2023/2023-03-01.parquet size: 67 KB rows: 2,046
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 |
|---|---|---|---|---|---|---|---|
| 2023-03-01 00:00:00 | ES | Futures | 4447.7 | 4449.38 | 4445.46 | 4447.14 | 5824.0 |
| 2023-03-01 01:00:00 | ES | Futures | 4447.42 | 4454.97 | 4447.14 | 4451.06 | 10493.0 |
| 2023-03-01 02:00:00 | ES | Futures | 4451.06 | 4456.65 | 4448.82 | 4454.69 | 17707.0 |
| 2023-03-01 03:00:00 | ES | Futures | 4454.41 | 4459.44 | 4448.82 | 4456.65 | 31685.0 |
| 2023-03-01 04:00:00 | ES | Futures | 4456.65 | 4462.24 | 4452.73 | 4456.93 | 20672.0 |
| 2023-03-01 05:00:00 | ES | Futures | 4457.21 | 4461.68 | 4453.29 | 4461.12 | 14958.0 |
| 2023-03-01 06:00:00 | ES | Futures | 4461.12 | 4463.64 | 4458.61 | 4459.72 | 16613.0 |
| 2023-03-01 07:00:00 | ES | Futures | 4459.44 | 4459.44 | 4453.85 | 4457.77 | 19127.0 |
| 2023-03-01 08:00:00 | ES | Futures | 4457.49 | 4458.05 | 4432.88 | 4433.44 | 65471.0 |
| 2023-03-01 09:00:00 | ES | Futures | 4433.72 | 4447.42 | 4428.97 | 4441.27 | 250242.0 |
| 2023-03-01 10:00:00 | ES | Futures | 4441.27 | 4446.02 | 4417.78 | 4438.19 | 408231.0 |
| 2023-03-01 11:00:00 | ES | Futures | 4438.19 | 4440.99 | 4409.95 | 4436.52 | 321185.0 |
| 2023-03-01 12:00:00 | ES | Futures | 4436.8 | 4444.63 | 4433.16 | 4435.12 | 145078.0 |
| 2023-03-01 13:00:00 | ES | Futures | 4435.4 | 4435.68 | 4420.3 | 4426.17 | 130298.0 |
| 2023-03-01 14:00:00 | ES | Futures | 4426.17 | 4427.85 | 4413.03 | 4417.78 | 159829.0 |
| 2023-03-01 15:00:00 | ES | Futures | 4417.78 | 4430.37 | 4416.67 | 4426.45 | 220539.0 |
| 2023-03-01 16:00:00 | ES | Futures | 4426.45 | 4432.32 | 4422.82 | 4430.09 | 57011.0 |
| 2023-03-01 18:00:00 | ES | Futures | 4428.69 | 4430.09 | 4426.73 | 4428.97 | 6813.0 |
| 2023-03-01 19:00:00 | ES | Futures | 4428.97 | 4435.12 | 4422.82 | 4423.1 | 14664.0 |
| 2023-03-01 20:00:00 | ES | Futures | 4423.38 | 4423.66 | 4397.65 | 4404.64 | 45539.0 |
| 2023-03-01 21:00:00 | ES | Futures | 4404.64 | 4411.63 | 4403.24 | 4411.07 | 17882.0 |
| 2023-03-01 22:00:00 | ES | Futures | 4411.35 | 4414.15 | 4406.88 | 4409.12 | 11433.0 |
| 2023-03-01 23:00:00 | ES | Futures | 4409.12 | 4411.35 | 4406.88 | 4409.12 | 5575.0 |
| 2023-03-01 00:00:00 | NQ | Futures | 13736.8 | 13745.33 | 13728.26 | 13737.36 | 2649.0 |
| 2023-03-01 01:00:00 | NQ | Futures | 13737.93 | 13774.06 | 13736.51 | 13761.26 | 6638.0 |
| 2023-03-01 02:00:00 | NQ | Futures | 13760.69 | 13789.14 | 13751.31 | 13779.19 | 7589.0 |
| 2023-03-01 03:00:00 | NQ | Futures | 13779.47 | 13791.13 | 13747.61 | 13777.19 | 11172.0 |
| 2023-03-01 04:00:00 | NQ | Futures | 13776.34 | 13801.38 | 13770.37 | 13790.0 | 9065.0 |
| 2023-03-01 05:00:00 | NQ | Futures | 13789.71 | 13812.76 | 13774.06 | 13807.35 | 6619.0 |
| 2023-03-01 06:00:00 | NQ | Futures | 13807.63 | 13817.02 | 13795.69 | 13801.66 | 7073.0 |
| 2023-03-01 07:00:00 | NQ | Futures | 13801.94 | 13801.94 | 13776.91 | 13787.72 | 7794.0 |
| 2023-03-01 08:00:00 | NQ | Futures | 13787.15 | 13789.14 | 13698.67 | 13700.67 | 26763.0 |
| 2023-03-01 09:00:00 | NQ | Futures | 13700.38 | 13746.18 | 13660.27 | 13714.61 | 86856.0 |
| 2023-03-01 10:00:00 | NQ | Futures | 13714.89 | 13735.09 | 13602.23 | 13664.82 | 157425.0 |
| 2023-03-01 11:00:00 | NQ | Futures | 13664.82 | 13679.9 | 13570.08 | 13665.39 | 106879.0 |
| 2023-03-01 12:00:00 | NQ | Futures | 13665.39 | 13697.25 | 13648.03 | 13662.26 | 65415.0 |
| 2023-03-01 13:00:00 | NQ | Futures | 13663.11 | 13663.68 | 13608.49 | 13629.54 | 59463.0 |
| 2023-03-01 14:00:00 | NQ | Futures | 13629.54 | 13636.08 | 13582.6 | 13599.67 | 65875.0 |
| 2023-03-01 15:00:00 | NQ | Futures | 13599.95 | 13628.69 | 13588.86 | 13616.17 | 69411.0 |
| 2023-03-01 16:00:00 | NQ | Futures | 13616.45 | 13648.6 | 13605.08 | 13638.93 | 16809.0 |
| 2023-03-01 18:00:00 | NQ | Futures | 13618.16 | 13630.11 | 13615.32 | 13623.0 | 4075.0 |
| 2023-03-01 19:00:00 | NQ | Futures | 13623.28 | 13646.33 | 13593.7 | 13595.4 | 6038.0 |
| 2023-03-01 20:00:00 | NQ | Futures | 13595.69 | 13599.1 | 13489.85 | 13527.12 | 18753.0 |
| 2023-03-01 21:00:00 | NQ | Futures | 13527.69 | 13554.72 | 13522.57 | 13551.87 | 7717.0 |
| 2023-03-01 22:00:00 | NQ | Futures | 13552.73 | 13563.54 | 13535.94 | 13546.75 | 4924.0 |
| 2023-03-01 23:00:00 | NQ | Futures | 13547.04 | 13557.28 | 13537.65 | 13546.18 | 2549.0 |
| 2023-03-01 00:00:00 | YM | Futures | 36442.7 | 36454.9 | 36428.2 | 36439.3 | 624.0 |
| 2023-03-01 01:00:00 | YM | Futures | 36440.4 | 36489.5 | 36440.4 | 36451.6 | 1853.0 |
| 2023-03-01 02:00:00 | YM | Futures | 36452.7 | 36487.2 | 36441.5 | 36469.4 | 2494.0 |
| 2023-03-01 03:00:00 | YM | Futures | 36471.6 | 36510.6 | 36431.5 | 36487.2 | 4153.0 |
> showing 50 of 2,046 rows — these rows as CSV