PREVIEW / futures_1hour / 2022-11-06
file: by_date/futures_1hour/2022/2022-11-06.parquet size: 20 KB rows: 438
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-06 18:00:00 | ES | Futures | 4228.4 | 4235.73 | 4215.15 | 4230.38 | 16779.0 |
| 2022-11-06 19:00:00 | ES | Futures | 4230.1 | 4243.91 | 4230.1 | 4240.24 | 12086.0 |
| 2022-11-06 20:00:00 | ES | Futures | 4239.96 | 4250.96 | 4228.97 | 4247.29 | 21843.0 |
| 2022-11-06 21:00:00 | ES | Futures | 4247.57 | 4254.62 | 4245.88 | 4253.21 | 12650.0 |
| 2022-11-06 22:00:00 | ES | Futures | 4253.21 | 4258.57 | 4248.7 | 4253.21 | 10636.0 |
| 2022-11-06 23:00:00 | ES | Futures | 4253.21 | 4258.0 | 4251.52 | 4254.62 | 7015.0 |
| 2022-11-06 18:00:00 | NQ | Futures | 12396.96 | 12432.59 | 12356.16 | 12408.17 | 8923.0 |
| 2022-11-06 19:00:00 | NQ | Futures | 12408.46 | 12452.7 | 12401.56 | 12437.76 | 5686.0 |
| 2022-11-06 20:00:00 | NQ | Futures | 12437.19 | 12473.1 | 12395.24 | 12463.05 | 9103.0 |
| 2022-11-06 21:00:00 | NQ | Futures | 12462.47 | 12492.07 | 12449.83 | 12487.76 | 5403.0 |
| 2022-11-06 22:00:00 | NQ | Futures | 12488.05 | 12506.72 | 12471.09 | 12486.61 | 4999.0 |
| 2022-11-06 23:00:00 | NQ | Futures | 12485.75 | 12498.68 | 12475.4 | 12486.03 | 3681.0 |
| 2022-11-06 18:00:00 | YM | Futures | 36216.7 | 36217.8 | 36038.3 | 36168.5 | 2700.0 |
| 2022-11-06 19:00:00 | YM | Futures | 36168.5 | 36266.1 | 36168.5 | 36239.2 | 1781.0 |
| 2022-11-06 20:00:00 | YM | Futures | 36235.8 | 36335.7 | 36176.3 | 36307.6 | 2672.0 |
| 2022-11-06 21:00:00 | YM | Futures | 36304.3 | 36352.5 | 36291.9 | 36344.7 | 1281.0 |
| 2022-11-06 22:00:00 | YM | Futures | 36343.5 | 36377.2 | 36311.0 | 36339.0 | 1151.0 |
| 2022-11-06 23:00:00 | YM | Futures | 36335.7 | 36371.6 | 36326.7 | 36348.0 | 645.0 |
| 2022-11-06 18:00:00 | CL | Futures | 74.03 | 74.24 | 73.54 | 73.78 | 8697.0 |
| 2022-11-06 19:00:00 | CL | Futures | 73.78 | 74.35 | 73.76 | 74.28 | 3013.0 |
| 2022-11-06 20:00:00 | CL | Futures | 74.29 | 74.56 | 74.01 | 74.51 | 5764.0 |
| 2022-11-06 21:00:00 | CL | Futures | 74.5 | 74.51 | 74.16 | 74.32 | 2998.0 |
| 2022-11-06 22:00:00 | CL | Futures | 74.33 | 74.46 | 74.14 | 74.37 | 2159.0 |
| 2022-11-06 23:00:00 | CL | Futures | 74.37 | 74.51 | 74.33 | 74.35 | 1236.0 |
| 2022-11-06 18:00:00 | GC | Futures | 1982.7 | 1988.3 | 1978.9 | 1979.5 | 8418.0 |
| 2022-11-06 19:00:00 | GC | Futures | 1979.5 | 1982.4 | 1977.1 | 1980.1 | 4268.0 |
| 2022-11-06 20:00:00 | GC | Futures | 1980.2 | 1982.3 | 1976.5 | 1978.9 | 5783.0 |
| 2022-11-06 21:00:00 | GC | Futures | 1978.8 | 1980.1 | 1976.5 | 1979.2 | 3191.0 |
| 2022-11-06 22:00:00 | GC | Futures | 1979.1 | 1982.2 | 1977.6 | 1980.7 | 2542.0 |
| 2022-11-06 23:00:00 | GC | Futures | 1980.4 | 1980.7 | 1977.6 | 1979.2 | 2147.0 |
| 2022-11-06 18:00:00 | ZN | Futures | 113.565843 | 113.662549 | 113.4369 | 113.453018 | 14222.0 |
| 2022-11-06 19:00:00 | ZN | Futures | 113.453018 | 113.549725 | 113.372429 | 113.453018 | 14902.0 |
| 2022-11-06 20:00:00 | ZN | Futures | 113.453018 | 113.517489 | 113.4369 | 113.469136 | 11339.0 |
| 2022-11-06 21:00:00 | ZN | Futures | 113.469136 | 113.485254 | 113.4369 | 113.453018 | 5199.0 |
| 2022-11-06 22:00:00 | ZN | Futures | 113.453018 | 113.469136 | 113.388547 | 113.404665 | 6154.0 |
| 2022-11-06 23:00:00 | ZN | Futures | 113.388547 | 113.4369 | 113.372429 | 113.404665 | 7308.0 |
> showing 36 of 438 rows — these rows as CSV