PREVIEW / futures_1hour / 2010-02-14
file: by_date/futures_1hour/2010/2010-02-14.parquet size: 11 KB rows: 181
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-02-14 18:00:00 | ES | Futures | 1048.45 | 1048.69 | 1046.01 | 1047.47 | 9661.0 |
| 2010-02-14 19:00:00 | ES | Futures | 1047.72 | 1047.96 | 1046.74 | 1046.99 | 2285.0 |
| 2010-02-14 20:00:00 | ES | Futures | 1046.99 | 1046.99 | 1046.01 | 1046.5 | 2503.0 |
| 2010-02-14 21:00:00 | ES | Futures | 1046.74 | 1046.74 | 1046.01 | 1046.5 | 1060.0 |
| 2010-02-14 22:00:00 | ES | Futures | 1046.74 | 1047.47 | 1046.5 | 1046.99 | 989.0 |
| 2010-02-14 23:00:00 | ES | Futures | 1046.99 | 1047.47 | 1046.01 | 1046.5 | 1310.0 |
| 2010-02-14 18:00:00 | NQ | Futures | 2035.39 | 2035.39 | 2031.11 | 2033.39 | 518.0 |
| 2010-02-14 19:00:00 | NQ | Futures | 2033.68 | 2034.54 | 2031.39 | 2031.68 | 158.0 |
| 2010-02-14 20:00:00 | NQ | Futures | 2031.97 | 2032.25 | 2031.11 | 2031.11 | 107.0 |
| 2010-02-14 21:00:00 | NQ | Futures | 2031.68 | 2032.25 | 2031.11 | 2032.25 | 74.0 |
| 2010-02-14 22:00:00 | NQ | Futures | 2032.54 | 2033.39 | 2031.68 | 2032.54 | 81.0 |
| 2010-02-14 23:00:00 | NQ | Futures | 2031.39 | 2033.11 | 2030.54 | 2031.39 | 131.0 |
| 2010-02-14 18:00:00 | YM | Futures | 9460.1 | 9460.1 | 9438.6 | 9447.0 | 297.0 |
| 2010-02-14 19:00:00 | YM | Futures | 9449.8 | 9453.6 | 9441.4 | 9442.3 | 93.0 |
| 2010-02-14 20:00:00 | YM | Futures | 9442.3 | 9445.1 | 9435.8 | 9440.5 | 72.0 |
| 2010-02-14 21:00:00 | YM | Futures | 9441.4 | 9445.1 | 9438.6 | 9441.4 | 42.0 |
| 2010-02-14 22:00:00 | YM | Futures | 9441.4 | 9444.2 | 9439.5 | 9441.4 | 171.0 |
| 2010-02-14 23:00:00 | YM | Futures | 9439.5 | 9449.8 | 9435.8 | 9438.6 | 103.0 |
| 2010-02-14 18:00:00 | CL | Futures | 158.22 | 158.97 | 157.67 | 158.93 | 121.0 |
| 2010-02-14 19:00:00 | CL | Futures | 158.8 | 158.97 | 158.61 | 158.61 | 85.0 |
| 2010-02-14 20:00:00 | CL | Futures | 158.61 | 158.76 | 158.56 | 158.76 | 50.0 |
| 2010-02-14 21:00:00 | CL | Futures | 158.73 | 158.78 | 158.58 | 158.76 | 42.0 |
| 2010-02-14 22:00:00 | CL | Futures | 158.73 | 158.8 | 158.69 | 158.73 | 26.0 |
| 2010-02-14 23:00:00 | CL | Futures | 158.73 | 158.73 | 158.5 | 158.5 | 54.0 |
| 2010-02-14 18:00:00 | GC | Futures | 1539.8 | 1544.8 | 1539.8 | 1543.0 | 1260.0 |
| 2010-02-14 19:00:00 | GC | Futures | 1542.9 | 1546.0 | 1540.5 | 1542.2 | 1576.0 |
| 2010-02-14 20:00:00 | GC | Futures | 1542.2 | 1542.3 | 1538.8 | 1540.3 | 694.0 |
| 2010-02-14 21:00:00 | GC | Futures | 1540.2 | 1541.8 | 1540.1 | 1541.3 | 354.0 |
| 2010-02-14 22:00:00 | GC | Futures | 1540.9 | 1543.3 | 1540.8 | 1541.0 | 461.0 |
| 2010-02-14 23:00:00 | GC | Futures | 1541.3 | 1541.6 | 1539.6 | 1540.1 | 679.0 |
| 2010-02-14 18:00:00 | ZN | Futures | 95.910693 | 95.923385 | 95.745702 | 95.796469 | 4730.0 |
| 2010-02-14 19:00:00 | ZN | Futures | 95.796469 | 95.872618 | 95.758394 | 95.859927 | 2074.0 |
| 2010-02-14 20:00:00 | ZN | Futures | 95.859927 | 95.88531 | 95.847235 | 95.872618 | 887.0 |
| 2010-02-14 21:00:00 | ZN | Futures | 95.859927 | 95.872618 | 95.834543 | 95.834543 | 716.0 |
| 2010-02-14 22:00:00 | ZN | Futures | 95.834543 | 95.834543 | 95.783777 | 95.783777 | 722.0 |
| 2010-02-14 23:00:00 | ZN | Futures | 95.783777 | 95.821852 | 95.783777 | 95.821852 | 449.0 |
> showing 36 of 181 rows — these rows as CSV