PREVIEW / futures_1hour / 2022-02-06
file: by_date/futures_1hour/2022/2022-02-06.parquet size: 20 KB rows: 429
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-02-06 18:00:00 | ES | Futures | 5087.04 | 5089.87 | 5076.86 | 5088.46 | 13676.0 |
| 2022-02-06 19:00:00 | ES | Futures | 5088.74 | 5089.02 | 5066.97 | 5073.47 | 16073.0 |
| 2022-02-06 20:00:00 | ES | Futures | 5073.75 | 5080.26 | 5067.53 | 5070.08 | 13295.0 |
| 2022-02-06 21:00:00 | ES | Futures | 5070.36 | 5073.75 | 5057.92 | 5061.59 | 12004.0 |
| 2022-02-06 22:00:00 | ES | Futures | 5061.59 | 5074.32 | 5061.31 | 5070.92 | 5863.0 |
| 2022-02-06 23:00:00 | ES | Futures | 5070.64 | 5087.33 | 5070.64 | 5084.22 | 8582.0 |
| 2022-02-06 18:00:00 | NQ | Futures | 17020.96 | 17061.54 | 16965.03 | 17054.0 | 9200.0 |
| 2022-02-06 19:00:00 | NQ | Futures | 17052.55 | 17055.45 | 16949.38 | 16979.52 | 9029.0 |
| 2022-02-06 20:00:00 | NQ | Futures | 16980.1 | 17007.34 | 16953.14 | 16970.53 | 8299.0 |
| 2022-02-06 21:00:00 | NQ | Futures | 16972.27 | 16988.5 | 16925.9 | 16937.2 | 7237.0 |
| 2022-02-06 22:00:00 | NQ | Futures | 16938.94 | 16997.49 | 16936.91 | 16977.78 | 5047.0 |
| 2022-02-06 23:00:00 | NQ | Futures | 16976.62 | 17058.06 | 16976.62 | 17038.06 | 6947.0 |
| 2022-02-06 18:00:00 | YM | Futures | 39335.3 | 39379.1 | 39294.8 | 39348.7 | 2253.0 |
| 2022-02-06 19:00:00 | YM | Futures | 39346.5 | 39354.4 | 39207.1 | 39260.0 | 3238.0 |
| 2022-02-06 20:00:00 | YM | Futures | 39261.1 | 39300.4 | 39200.4 | 39215.0 | 1846.0 |
| 2022-02-06 21:00:00 | YM | Futures | 39217.3 | 39239.7 | 39115.0 | 39166.7 | 2783.0 |
| 2022-02-06 22:00:00 | YM | Futures | 39168.9 | 39246.5 | 39163.3 | 39224.0 | 988.0 |
| 2022-02-06 23:00:00 | YM | Futures | 39222.9 | 39327.4 | 39222.9 | 39302.7 | 1458.0 |
| 2022-02-06 18:00:00 | CL | Futures | 65.64 | 65.86 | 65.31 | 65.66 | 7643.0 |
| 2022-02-06 19:00:00 | CL | Futures | 65.65 | 65.67 | 65.43 | 65.45 | 3184.0 |
| 2022-02-06 20:00:00 | CL | Futures | 65.45 | 66.29 | 65.44 | 66.14 | 13368.0 |
| 2022-02-06 21:00:00 | CL | Futures | 66.14 | 66.16 | 65.31 | 65.48 | 10821.0 |
| 2022-02-06 22:00:00 | CL | Futures | 65.48 | 65.92 | 65.48 | 65.73 | 6466.0 |
| 2022-02-06 23:00:00 | CL | Futures | 65.72 | 65.9 | 65.68 | 65.86 | 2008.0 |
| 2022-02-06 18:00:00 | GC | Futures | 2170.4 | 2178.4 | 2169.8 | 2173.5 | 3511.0 |
| 2022-02-06 19:00:00 | GC | Futures | 2173.6 | 2177.8 | 2173.6 | 2177.3 | 2780.0 |
| 2022-02-06 20:00:00 | GC | Futures | 2177.4 | 2180.7 | 2172.0 | 2174.1 | 7914.0 |
| 2022-02-06 21:00:00 | GC | Futures | 2174.0 | 2174.8 | 2172.9 | 2172.9 | 1674.0 |
| 2022-02-06 22:00:00 | GC | Futures | 2172.9 | 2174.6 | 2172.4 | 2173.4 | 1721.0 |
| 2022-02-06 23:00:00 | GC | Futures | 2173.5 | 2174.8 | 2173.1 | 2174.2 | 1059.0 |
| 2022-02-06 18:00:00 | ZN | Futures | 130.240555 | 130.304729 | 130.096165 | 130.288686 | 37025.0 |
| 2022-02-06 19:00:00 | ZN | Futures | 130.288686 | 130.368903 | 130.256599 | 130.304729 | 29251.0 |
| 2022-02-06 20:00:00 | ZN | Futures | 130.304729 | 130.384946 | 130.192425 | 130.288686 | 25318.0 |
| 2022-02-06 21:00:00 | ZN | Futures | 130.304729 | 130.352859 | 130.240555 | 130.288686 | 12633.0 |
| 2022-02-06 22:00:00 | ZN | Futures | 130.288686 | 130.320773 | 130.272642 | 130.272642 | 6898.0 |
| 2022-02-06 23:00:00 | ZN | Futures | 130.288686 | 130.336816 | 130.272642 | 130.304729 | 8860.0 |
> showing 36 of 429 rows — these rows as CSV