PREVIEW / futures_1hour / 2022-10-09
file: by_date/futures_1hour/2022/2022-10-09.parquet size: 19 KB rows: 411
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-10-09 18:00:00 | ES | Futures | 4102.96 | 4106.91 | 4080.97 | 4084.07 | 27393.0 |
| 2022-10-09 19:00:00 | ES | Futures | 4084.07 | 4101.55 | 4079.56 | 4097.04 | 19230.0 |
| 2022-10-09 20:00:00 | ES | Futures | 4097.32 | 4106.06 | 4088.87 | 4100.42 | 22115.0 |
| 2022-10-09 21:00:00 | ES | Futures | 4100.14 | 4110.85 | 4095.63 | 4105.78 | 16619.0 |
| 2022-10-09 22:00:00 | ES | Futures | 4105.5 | 4105.78 | 4100.14 | 4104.37 | 7390.0 |
| 2022-10-09 23:00:00 | ES | Futures | 4104.09 | 4105.78 | 4096.48 | 4100.14 | 6554.0 |
| 2022-10-09 18:00:00 | NQ | Futures | 12720.2 | 12720.78 | 12626.25 | 12641.19 | 12326.0 |
| 2022-10-09 19:00:00 | NQ | Futures | 12642.05 | 12697.22 | 12627.4 | 12683.14 | 9353.0 |
| 2022-10-09 20:00:00 | NQ | Futures | 12684.29 | 12724.23 | 12658.14 | 12704.69 | 10222.0 |
| 2022-10-09 21:00:00 | NQ | Futures | 12703.54 | 12736.58 | 12683.14 | 12715.03 | 7674.0 |
| 2022-10-09 22:00:00 | NQ | Futures | 12713.6 | 12715.03 | 12694.63 | 12707.27 | 3968.0 |
| 2022-10-09 23:00:00 | NQ | Futures | 12706.99 | 12711.58 | 12682.28 | 12696.36 | 4139.0 |
| 2022-10-09 18:00:00 | YM | Futures | 32856.8 | 32881.4 | 32689.5 | 32706.4 | 3486.0 |
| 2022-10-09 19:00:00 | YM | Futures | 32705.3 | 32820.8 | 32670.5 | 32795.0 | 2223.0 |
| 2022-10-09 20:00:00 | YM | Futures | 32796.2 | 32838.8 | 32734.4 | 32802.9 | 2621.0 |
| 2022-10-09 21:00:00 | YM | Futures | 32802.9 | 32872.5 | 32770.3 | 32842.2 | 2053.0 |
| 2022-10-09 22:00:00 | YM | Futures | 32839.9 | 32848.9 | 32809.6 | 32839.9 | 702.0 |
| 2022-10-09 23:00:00 | YM | Futures | 32842.2 | 32851.1 | 32786.1 | 32805.1 | 610.0 |
| 2022-10-09 18:00:00 | CL | Futures | 75.04 | 75.1 | 74.19 | 74.2 | 4442.0 |
| 2022-10-09 19:00:00 | CL | Futures | 74.19 | 74.54 | 74.17 | 74.37 | 1818.0 |
| 2022-10-09 20:00:00 | CL | Futures | 74.37 | 74.43 | 73.86 | 74.03 | 4431.0 |
| 2022-10-09 21:00:00 | CL | Futures | 74.03 | 74.09 | 73.57 | 73.99 | 7971.0 |
| 2022-10-09 22:00:00 | CL | Futures | 74.0 | 74.06 | 73.76 | 73.77 | 2274.0 |
| 2022-10-09 23:00:00 | CL | Futures | 73.77 | 73.87 | 73.69 | 73.71 | 1513.0 |
| 2022-10-09 18:00:00 | GC | Futures | 2012.0 | 2016.7 | 2010.7 | 2014.0 | 3244.0 |
| 2022-10-09 19:00:00 | GC | Futures | 2014.0 | 2014.9 | 2012.1 | 2013.1 | 1372.0 |
| 2022-10-09 20:00:00 | GC | Futures | 2013.1 | 2013.8 | 2008.4 | 2010.4 | 3180.0 |
| 2022-10-09 21:00:00 | GC | Futures | 2010.7 | 2012.3 | 2007.0 | 2009.8 | 6942.0 |
| 2022-10-09 22:00:00 | GC | Futures | 2009.8 | 2010.1 | 2006.1 | 2006.5 | 3063.0 |
| 2022-10-09 23:00:00 | GC | Futures | 2006.5 | 2006.8 | 1999.7 | 2003.1 | 3889.0 |
| 2022-10-09 18:00:00 | ZN | Futures | 114.951971 | 115.048678 | 114.935853 | 114.968089 | 5430.0 |
| 2022-10-09 19:00:00 | ZN | Futures | 114.984207 | 115.000324 | 114.951971 | 114.968089 | 2436.0 |
| 2022-10-09 20:00:00 | ZN | Futures | 114.968089 | 115.064796 | 114.951971 | 115.064796 | 5872.0 |
| 2022-10-09 21:00:00 | ZN | Futures | 115.048678 | 115.113149 | 115.016442 | 115.097031 | 4688.0 |
| 2022-10-09 22:00:00 | ZN | Futures | 115.097031 | 115.097031 | 115.03256 | 115.048678 | 4821.0 |
| 2022-10-09 23:00:00 | ZN | Futures | 115.048678 | 115.080913 | 115.03256 | 115.064796 | 1344.0 |
> showing 36 of 411 rows — these rows as CSV