PREVIEW / futures_1hour / 2022-11-29
file: by_date/futures_1hour/2022/2022-11-29.parquet size: 66 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 |
|---|---|---|---|---|---|---|---|
| 2022-11-29 00:00:00 | ES | Futures | 4490.56 | 4492.82 | 4488.87 | 4491.13 | 8152.0 |
| 2022-11-29 01:00:00 | ES | Futures | 4491.13 | 4493.95 | 4486.62 | 4489.44 | 10943.0 |
| 2022-11-29 02:00:00 | ES | Futures | 4489.44 | 4495.92 | 4489.16 | 4492.82 | 12796.0 |
| 2022-11-29 03:00:00 | ES | Futures | 4492.82 | 4499.3 | 4489.72 | 4495.64 | 26016.0 |
| 2022-11-29 04:00:00 | ES | Futures | 4495.64 | 4497.89 | 4480.7 | 4484.36 | 22665.0 |
| 2022-11-29 05:00:00 | ES | Futures | 4484.36 | 4492.54 | 4482.95 | 4486.34 | 16124.0 |
| 2022-11-29 06:00:00 | ES | Futures | 4486.62 | 4491.97 | 4482.67 | 4491.69 | 10918.0 |
| 2022-11-29 07:00:00 | ES | Futures | 4491.69 | 4491.97 | 4482.95 | 4490.0 | 15758.0 |
| 2022-11-29 08:00:00 | ES | Futures | 4490.0 | 4490.28 | 4471.96 | 4478.44 | 47047.0 |
| 2022-11-29 09:00:00 | ES | Futures | 4478.44 | 4482.39 | 4466.32 | 4471.11 | 142714.0 |
| 2022-11-29 10:00:00 | ES | Futures | 4471.4 | 4489.72 | 4468.01 | 4478.44 | 196084.0 |
| 2022-11-29 11:00:00 | ES | Futures | 4478.73 | 4480.98 | 4444.05 | 4459.84 | 238616.0 |
| 2022-11-29 12:00:00 | ES | Futures | 4459.56 | 4466.6 | 4453.07 | 4463.22 | 111971.0 |
| 2022-11-29 13:00:00 | ES | Futures | 4463.22 | 4464.63 | 4451.38 | 4464.07 | 108135.0 |
| 2022-11-29 14:00:00 | ES | Futures | 4463.79 | 4475.91 | 4454.2 | 4460.68 | 169496.0 |
| 2022-11-29 15:00:00 | ES | Futures | 4460.68 | 4469.7 | 4457.58 | 4466.6 | 223895.0 |
| 2022-11-29 16:00:00 | ES | Futures | 4466.89 | 4468.86 | 4462.94 | 4467.73 | 37116.0 |
| 2022-11-29 18:00:00 | ES | Futures | 4467.73 | 4468.3 | 4461.25 | 4463.5 | 5945.0 |
| 2022-11-29 19:00:00 | ES | Futures | 4463.5 | 4470.55 | 4462.66 | 4469.14 | 8195.0 |
| 2022-11-29 20:00:00 | ES | Futures | 4469.42 | 4473.93 | 4468.01 | 4471.11 | 8872.0 |
| 2022-11-29 21:00:00 | ES | Futures | 4470.83 | 4471.96 | 4469.14 | 4471.4 | 3438.0 |
| 2022-11-29 22:00:00 | ES | Futures | 4471.4 | 4472.81 | 4469.42 | 4472.52 | 3590.0 |
| 2022-11-29 23:00:00 | ES | Futures | 4472.52 | 4475.91 | 4471.96 | 4473.65 | 4585.0 |
| 2022-11-29 00:00:00 | NQ | Futures | 13409.79 | 13419.56 | 13406.05 | 13418.12 | 3565.0 |
| 2022-11-29 01:00:00 | NQ | Futures | 13418.41 | 13430.47 | 13402.89 | 13413.81 | 4257.0 |
| 2022-11-29 02:00:00 | NQ | Futures | 13414.1 | 13434.21 | 13410.65 | 13420.42 | 5353.0 |
| 2022-11-29 03:00:00 | NQ | Futures | 13420.99 | 13452.02 | 13409.5 | 13438.81 | 10905.0 |
| 2022-11-29 04:00:00 | NQ | Futures | 13438.81 | 13445.7 | 13386.8 | 13398.29 | 8800.0 |
| 2022-11-29 05:00:00 | NQ | Futures | 13398.01 | 13427.03 | 13390.54 | 13408.64 | 5510.0 |
| 2022-11-29 06:00:00 | NQ | Futures | 13409.5 | 13422.14 | 13393.12 | 13422.14 | 5329.0 |
| 2022-11-29 07:00:00 | NQ | Futures | 13421.57 | 13421.57 | 13391.11 | 13416.4 | 5710.0 |
| 2022-11-29 08:00:00 | NQ | Futures | 13417.26 | 13417.83 | 13350.31 | 13372.15 | 17075.0 |
| 2022-11-29 09:00:00 | NQ | Futures | 13371.86 | 13387.95 | 13291.98 | 13307.21 | 65647.0 |
| 2022-11-29 10:00:00 | NQ | Futures | 13307.5 | 13376.17 | 13287.39 | 13326.46 | 79846.0 |
| 2022-11-29 11:00:00 | NQ | Futures | 13327.04 | 13332.5 | 13176.77 | 13244.0 | 91476.0 |
| 2022-11-29 12:00:00 | NQ | Futures | 13244.0 | 13278.19 | 13225.61 | 13259.8 | 43525.0 |
| 2022-11-29 13:00:00 | NQ | Futures | 13259.52 | 13261.81 | 13190.27 | 13240.26 | 46144.0 |
| 2022-11-29 14:00:00 | NQ | Futures | 13240.26 | 13279.63 | 13205.5 | 13229.06 | 65867.0 |
| 2022-11-29 15:00:00 | NQ | Futures | 13229.06 | 13253.48 | 13216.42 | 13244.0 | 64044.0 |
| 2022-11-29 16:00:00 | NQ | Futures | 13244.0 | 13250.9 | 13225.04 | 13239.11 | 10055.0 |
| 2022-11-29 18:00:00 | NQ | Futures | 13239.98 | 13241.41 | 13214.4 | 13221.01 | 3168.0 |
| 2022-11-29 19:00:00 | NQ | Futures | 13221.59 | 13249.46 | 13217.85 | 13244.29 | 3461.0 |
| 2022-11-29 20:00:00 | NQ | Futures | 13244.29 | 13267.27 | 13240.26 | 13256.07 | 4093.0 |
| 2022-11-29 21:00:00 | NQ | Futures | 13255.49 | 13257.5 | 13247.45 | 13253.48 | 1658.0 |
| 2022-11-29 22:00:00 | NQ | Futures | 13254.06 | 13261.53 | 13249.17 | 13260.66 | 1507.0 |
| 2022-11-29 23:00:00 | NQ | Futures | 13260.95 | 13270.72 | 13258.08 | 13262.96 | 2074.0 |
| 2022-11-29 00:00:00 | YM | Futures | 38086.4 | 38095.3 | 38065.0 | 38078.5 | 1356.0 |
| 2022-11-29 01:00:00 | YM | Futures | 38079.6 | 38092.0 | 38037.0 | 38059.4 | 2438.0 |
| 2022-11-29 02:00:00 | YM | Futures | 38058.3 | 38115.5 | 38057.2 | 38081.9 | 2361.0 |
| 2022-11-29 03:00:00 | YM | Futures | 38083.0 | 38148.1 | 38062.8 | 38098.7 | 4108.0 |
> showing 50 of 2,046 rows — these rows as CSV