PREVIEW / futures_1hour / 2010-05-16
file: by_date/futures_1hour/2010/2010-05-16.parquet size: 14 KB rows: 247
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 |
|---|---|---|---|---|---|---|---|
| 2010-05-16 18:00:00 | ES | Futures | 1108.47 | 1110.67 | 1106.03 | 1107.01 | 15402.0 |
| 2010-05-16 19:00:00 | ES | Futures | 1106.76 | 1108.47 | 1103.83 | 1107.98 | 13148.0 |
| 2010-05-16 20:00:00 | ES | Futures | 1108.23 | 1109.45 | 1104.32 | 1107.74 | 15027.0 |
| 2010-05-16 21:00:00 | ES | Futures | 1107.74 | 1108.72 | 1101.63 | 1103.1 | 12130.0 |
| 2010-05-16 22:00:00 | ES | Futures | 1103.1 | 1103.34 | 1096.25 | 1097.23 | 29965.0 |
| 2010-05-16 23:00:00 | ES | Futures | 1096.99 | 1099.43 | 1095.27 | 1096.01 | 14633.0 |
| 2010-05-16 18:00:00 | NQ | Futures | 2185.31 | 2189.89 | 2179.87 | 2181.87 | 857.0 |
| 2010-05-16 19:00:00 | NQ | Futures | 2180.73 | 2185.02 | 2176.15 | 2184.74 | 684.0 |
| 2010-05-16 20:00:00 | NQ | Futures | 2184.74 | 2186.45 | 2177.86 | 2183.88 | 894.0 |
| 2010-05-16 21:00:00 | NQ | Futures | 2184.16 | 2185.31 | 2172.71 | 2175.29 | 933.0 |
| 2010-05-16 22:00:00 | NQ | Futures | 2175.29 | 2175.29 | 2161.83 | 2163.54 | 1768.0 |
| 2010-05-16 23:00:00 | NQ | Futures | 2163.54 | 2167.55 | 2159.54 | 2161.25 | 977.0 |
| 2010-05-16 18:00:00 | YM | Futures | 9974.4 | 9990.4 | 9951.8 | 9959.3 | 389.0 |
| 2010-05-16 19:00:00 | YM | Futures | 9959.3 | 9966.9 | 9931.1 | 9966.9 | 905.0 |
| 2010-05-16 20:00:00 | YM | Futures | 9965.0 | 9976.3 | 9936.7 | 9960.3 | 683.0 |
| 2010-05-16 21:00:00 | YM | Futures | 9962.2 | 9966.9 | 9911.3 | 9921.7 | 973.0 |
| 2010-05-16 22:00:00 | YM | Futures | 9921.7 | 9921.7 | 9865.2 | 9872.8 | 2734.0 |
| 2010-05-16 23:00:00 | YM | Futures | 9872.8 | 9889.7 | 9854.9 | 9867.1 | 1619.0 |
| 2010-05-16 18:00:00 | CL | Futures | 148.74 | 149.35 | 148.33 | 148.46 | 224.0 |
| 2010-05-16 19:00:00 | CL | Futures | 148.38 | 148.44 | 147.91 | 147.99 | 342.0 |
| 2010-05-16 20:00:00 | CL | Futures | 147.97 | 147.99 | 146.77 | 147.09 | 782.0 |
| 2010-05-16 21:00:00 | CL | Futures | 147.09 | 147.13 | 145.63 | 145.73 | 727.0 |
| 2010-05-16 22:00:00 | CL | Futures | 145.77 | 145.77 | 144.69 | 145.34 | 1790.0 |
| 2010-05-16 23:00:00 | CL | Futures | 145.28 | 145.61 | 144.9 | 145.28 | 693.0 |
| 2010-05-16 18:00:00 | GC | Futures | 1732.3 | 1737.0 | 1730.9 | 1733.8 | 1583.0 |
| 2010-05-16 19:00:00 | GC | Futures | 1734.0 | 1737.8 | 1733.3 | 1737.0 | 769.0 |
| 2010-05-16 20:00:00 | GC | Futures | 1737.0 | 1739.0 | 1735.6 | 1737.5 | 1779.0 |
| 2010-05-16 21:00:00 | GC | Futures | 1737.5 | 1740.0 | 1737.3 | 1739.0 | 1308.0 |
| 2010-05-16 22:00:00 | GC | Futures | 1739.0 | 1743.2 | 1737.6 | 1742.7 | 2893.0 |
| 2010-05-16 23:00:00 | GC | Futures | 1742.7 | 1747.5 | 1742.5 | 1746.8 | 2358.0 |
| 2010-05-16 18:00:00 | ZN | Futures | 98.374637 | 98.41318 | 98.336094 | 98.400332 | 2589.0 |
| 2010-05-16 19:00:00 | ZN | Futures | 98.400332 | 98.490266 | 98.400332 | 98.451723 | 3154.0 |
| 2010-05-16 20:00:00 | ZN | Futures | 98.438875 | 98.541656 | 98.426027 | 98.503113 | 6869.0 |
| 2010-05-16 21:00:00 | ZN | Futures | 98.503113 | 98.554504 | 98.490266 | 98.554504 | 3700.0 |
| 2010-05-16 22:00:00 | ZN | Futures | 98.567352 | 98.79861 | 98.567352 | 98.747219 | 20308.0 |
| 2010-05-16 23:00:00 | ZN | Futures | 98.747219 | 98.888543 | 98.721524 | 98.862848 | 13435.0 |
> showing 36 of 247 rows — these rows as CSV