PREVIEW / futures_1hour / 2022-11-21
file: by_date/futures_1hour/2022/2022-11-21.parquet size: 66 KB rows: 2,029
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-11-21 00:00:00 | ES | Futures | 4468.3 | 4469.14 | 4463.79 | 4469.14 | 5105.0 |
| 2022-11-21 01:00:00 | ES | Futures | 4469.14 | 4470.27 | 4461.53 | 4463.5 | 5995.0 |
| 2022-11-21 02:00:00 | ES | Futures | 4463.5 | 4467.17 | 4458.15 | 4458.99 | 9373.0 |
| 2022-11-21 03:00:00 | ES | Futures | 4459.27 | 4467.45 | 4455.61 | 4459.84 | 26515.0 |
| 2022-11-21 04:00:00 | ES | Futures | 4459.56 | 4461.25 | 4451.95 | 4457.02 | 19874.0 |
| 2022-11-21 05:00:00 | ES | Futures | 4457.3 | 4461.53 | 4453.64 | 4457.02 | 14532.0 |
| 2022-11-21 06:00:00 | ES | Futures | 4456.74 | 4460.68 | 4452.51 | 4455.33 | 9212.0 |
| 2022-11-21 07:00:00 | ES | Futures | 4455.33 | 4459.84 | 4451.66 | 4458.43 | 12056.0 |
| 2022-11-21 08:00:00 | ES | Futures | 4458.71 | 4468.3 | 4455.61 | 4466.6 | 27151.0 |
| 2022-11-21 09:00:00 | ES | Futures | 4466.32 | 4477.03 | 4459.27 | 4469.99 | 139460.0 |
| 2022-11-21 10:00:00 | ES | Futures | 4469.99 | 4473.65 | 4447.44 | 4454.76 | 161349.0 |
| 2022-11-21 11:00:00 | ES | Futures | 4455.05 | 4460.4 | 4439.82 | 4447.15 | 131588.0 |
| 2022-11-21 12:00:00 | ES | Futures | 4447.15 | 4464.35 | 4446.31 | 4455.33 | 106580.0 |
| 2022-11-21 13:00:00 | ES | Futures | 4455.33 | 4474.5 | 4454.76 | 4464.91 | 112044.0 |
| 2022-11-21 14:00:00 | ES | Futures | 4464.63 | 4471.68 | 4460.12 | 4461.81 | 99597.0 |
| 2022-11-21 15:00:00 | ES | Futures | 4461.81 | 4468.86 | 4456.17 | 4462.94 | 175994.0 |
| 2022-11-21 16:00:00 | ES | Futures | 4462.94 | 4466.89 | 4461.81 | 4462.94 | 31244.0 |
| 2022-11-21 18:00:00 | ES | Futures | 4462.66 | 4466.04 | 4461.25 | 4464.35 | 5599.0 |
| 2022-11-21 19:00:00 | ES | Futures | 4464.63 | 4472.81 | 4464.07 | 4469.42 | 8121.0 |
| 2022-11-21 20:00:00 | ES | Futures | 4469.14 | 4473.93 | 4467.45 | 4468.86 | 6968.0 |
| 2022-11-21 21:00:00 | ES | Futures | 4468.58 | 4469.99 | 4464.63 | 4468.58 | 5759.0 |
| 2022-11-21 22:00:00 | ES | Futures | 4468.86 | 4472.52 | 4467.73 | 4469.42 | 4110.0 |
| 2022-11-21 23:00:00 | ES | Futures | 4469.14 | 4469.7 | 4467.45 | 4467.73 | 2075.0 |
| 2022-11-21 00:00:00 | NQ | Futures | 13423.58 | 13426.74 | 13408.06 | 13425.59 | 2699.0 |
| 2022-11-21 01:00:00 | NQ | Futures | 13425.59 | 13430.47 | 13402.03 | 13407.2 | 2322.0 |
| 2022-11-21 02:00:00 | NQ | Futures | 13406.63 | 13418.69 | 13383.35 | 13387.09 | 4015.0 |
| 2022-11-21 03:00:00 | NQ | Futures | 13388.24 | 13426.74 | 13372.15 | 13389.96 | 9128.0 |
| 2022-11-21 04:00:00 | NQ | Futures | 13388.52 | 13396.28 | 13352.61 | 13367.55 | 8996.0 |
| 2022-11-21 05:00:00 | NQ | Futures | 13368.41 | 13381.92 | 13345.14 | 13353.47 | 5517.0 |
| 2022-11-21 06:00:00 | NQ | Futures | 13353.18 | 13366.11 | 13334.51 | 13343.7 | 5125.0 |
| 2022-11-21 07:00:00 | NQ | Futures | 13344.28 | 13360.08 | 13326.46 | 13357.78 | 6600.0 |
| 2022-11-21 08:00:00 | NQ | Futures | 13358.36 | 13397.14 | 13348.3 | 13393.7 | 14403.0 |
| 2022-11-21 09:00:00 | NQ | Futures | 13393.7 | 13446.56 | 13364.39 | 13403.75 | 69678.0 |
| 2022-11-21 10:00:00 | NQ | Futures | 13404.33 | 13417.54 | 13303.19 | 13329.62 | 75121.0 |
| 2022-11-21 11:00:00 | NQ | Futures | 13329.91 | 13365.54 | 13291.12 | 13306.92 | 50536.0 |
| 2022-11-21 12:00:00 | NQ | Futures | 13306.92 | 13333.07 | 13277.9 | 13285.95 | 43618.0 |
| 2022-11-21 13:00:00 | NQ | Futures | 13285.66 | 13371.57 | 13283.08 | 13332.21 | 46896.0 |
| 2022-11-21 14:00:00 | NQ | Futures | 13331.92 | 13356.06 | 13308.36 | 13319.28 | 41032.0 |
| 2022-11-21 15:00:00 | NQ | Futures | 13318.99 | 13346.29 | 13305.49 | 13317.27 | 54450.0 |
| 2022-11-21 16:00:00 | NQ | Futures | 13316.98 | 13329.91 | 13314.68 | 13319.28 | 11343.0 |
| 2022-11-21 18:00:00 | NQ | Futures | 13318.13 | 13327.9 | 13306.64 | 13324.74 | 2632.0 |
| 2022-11-21 19:00:00 | NQ | Futures | 13325.31 | 13358.93 | 13323.59 | 13343.99 | 4439.0 |
| 2022-11-21 20:00:00 | NQ | Futures | 13344.85 | 13361.8 | 13336.81 | 13338.24 | 3784.0 |
| 2022-11-21 21:00:00 | NQ | Futures | 13338.24 | 13348.01 | 13326.17 | 13339.39 | 3220.0 |
| 2022-11-21 22:00:00 | NQ | Futures | 13339.97 | 13353.18 | 13335.37 | 13342.55 | 2114.0 |
| 2022-11-21 23:00:00 | NQ | Futures | 13342.84 | 13345.14 | 13335.66 | 13336.23 | 1273.0 |
| 2022-11-21 00:00:00 | YM | Futures | 37819.3 | 37833.9 | 37787.9 | 37833.9 | 1111.0 |
| 2022-11-21 01:00:00 | YM | Futures | 37833.9 | 37844.0 | 37776.6 | 37791.2 | 1227.0 |
| 2022-11-21 02:00:00 | YM | Futures | 37790.1 | 37822.6 | 37760.9 | 37767.7 | 1649.0 |
| 2022-11-21 03:00:00 | YM | Futures | 37766.5 | 37813.7 | 37746.3 | 37775.5 | 2848.0 |
> showing 50 of 2,029 rows — these rows as CSV