PREVIEW / futures_1hour / 2022-09-04
file: by_date/futures_1hour/2022/2022-09-04.parquet size: 17 KB rows: 371
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-09-04 18:00:00 | ES | Futures | 4451.89 | 4455.86 | 4436.31 | 4440.85 | 13372.0 |
| 2022-09-04 19:00:00 | ES | Futures | 4440.85 | 4457.28 | 4440.0 | 4456.14 | 10463.0 |
| 2022-09-04 20:00:00 | ES | Futures | 4456.14 | 4462.94 | 4444.53 | 4450.76 | 15608.0 |
| 2022-09-04 21:00:00 | ES | Futures | 4450.76 | 4459.54 | 4448.21 | 4451.33 | 9974.0 |
| 2022-09-04 22:00:00 | ES | Futures | 4451.33 | 4455.86 | 4447.36 | 4451.89 | 7573.0 |
| 2022-09-04 23:00:00 | ES | Futures | 4451.89 | 4458.69 | 4447.93 | 4456.71 | 6016.0 |
| 2022-09-04 18:00:00 | NQ | Futures | 14011.32 | 14035.04 | 13946.82 | 13962.15 | 7167.0 |
| 2022-09-04 19:00:00 | NQ | Futures | 13961.57 | 14033.01 | 13959.83 | 14026.36 | 5140.0 |
| 2022-09-04 20:00:00 | NQ | Futures | 14026.07 | 14056.44 | 13980.37 | 14009.87 | 8206.0 |
| 2022-09-04 21:00:00 | NQ | Futures | 14009.58 | 14041.69 | 13992.81 | 14006.4 | 6171.0 |
| 2022-09-04 22:00:00 | NQ | Futures | 14006.11 | 14020.0 | 13981.82 | 14003.22 | 4448.0 |
| 2022-09-04 23:00:00 | NQ | Futures | 14002.93 | 14027.8 | 13987.31 | 14019.13 | 3482.0 |
| 2022-09-04 18:00:00 | YM | Futures | 35367.9 | 35406.3 | 35291.2 | 35321.7 | 1986.0 |
| 2022-09-04 19:00:00 | YM | Futures | 35319.4 | 35422.1 | 35316.0 | 35413.1 | 1260.0 |
| 2022-09-04 20:00:00 | YM | Futures | 35411.9 | 35452.6 | 35330.7 | 35370.2 | 2213.0 |
| 2022-09-04 21:00:00 | YM | Futures | 35370.2 | 35427.7 | 35365.7 | 35379.2 | 957.0 |
| 2022-09-04 22:00:00 | YM | Futures | 35381.5 | 35410.8 | 35360.0 | 35392.8 | 754.0 |
| 2022-09-04 23:00:00 | YM | Futures | 35392.8 | 35436.8 | 35367.9 | 35424.3 | 635.0 |
| 2022-09-04 18:00:00 | CL | Futures | 69.42 | 70.48 | 69.39 | 70.33 | 3568.0 |
| 2022-09-04 19:00:00 | CL | Futures | 70.34 | 70.58 | 70.26 | 70.54 | 1418.0 |
| 2022-09-04 20:00:00 | CL | Futures | 70.55 | 70.71 | 70.37 | 70.37 | 2344.0 |
| 2022-09-04 21:00:00 | CL | Futures | 70.39 | 70.82 | 70.33 | 70.66 | 3547.0 |
| 2022-09-04 22:00:00 | CL | Futures | 70.66 | 70.8 | 70.33 | 70.5 | 2167.0 |
| 2022-09-04 23:00:00 | CL | Futures | 70.5 | 70.87 | 70.48 | 70.82 | 2056.0 |
| 2022-09-04 18:00:00 | GC | Futures | 2036.5 | 2036.9 | 2032.2 | 2032.7 | 1198.0 |
| 2022-09-04 19:00:00 | GC | Futures | 2032.9 | 2033.0 | 2030.1 | 2030.3 | 1051.0 |
| 2022-09-04 20:00:00 | GC | Futures | 2030.1 | 2032.6 | 2029.9 | 2031.4 | 1567.0 |
| 2022-09-04 21:00:00 | GC | Futures | 2031.4 | 2036.2 | 2031.0 | 2034.9 | 2336.0 |
| 2022-09-04 22:00:00 | GC | Futures | 2034.9 | 2035.6 | 2031.1 | 2034.4 | 2156.0 |
| 2022-09-04 23:00:00 | GC | Futures | 2034.3 | 2036.1 | 2033.7 | 2035.0 | 1407.0 |
| 2022-09-04 18:00:00 | ZN | Futures | 120.206366 | 120.528721 | 120.206366 | 120.512604 | 336.0 |
| 2022-09-04 19:00:00 | ZN | Futures | 120.46425 | 120.46425 | 120.286955 | 120.286955 | 259.0 |
| 2022-09-04 20:00:00 | ZN | Futures | 120.286955 | 120.367544 | 120.286955 | 120.367544 | 45.0 |
| 2022-09-04 21:00:00 | ZN | Futures | 120.351426 | 120.367544 | 120.351426 | 120.367544 | 53.0 |
| 2022-09-04 22:00:00 | ZN | Futures | 120.335308 | 120.335308 | 120.31919 | 120.31919 | 55.0 |
| 2022-09-04 23:00:00 | ZN | Futures | 120.31919 | 120.31919 | 120.286955 | 120.31919 | 107.0 |
> showing 36 of 371 rows — these rows as CSV