PREVIEW / futures_1hour / 2009-03-01
file: by_date/futures_1hour/2009/2009-03-01.parquet size: 13 KB rows: 220
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 |
|---|---|---|---|---|---|---|---|
| 2009-03-01 18:00:00 | ES | Futures | 693.77 | 696.14 | 687.36 | 689.73 | 18187.0 |
| 2009-03-01 19:00:00 | ES | Futures | 689.73 | 690.92 | 687.6 | 689.26 | 7805.0 |
| 2009-03-01 20:00:00 | ES | Futures | 689.02 | 689.73 | 688.07 | 689.5 | 3268.0 |
| 2009-03-01 21:00:00 | ES | Futures | 689.5 | 690.45 | 686.18 | 686.89 | 6559.0 |
| 2009-03-01 22:00:00 | ES | Futures | 686.89 | 687.13 | 684.28 | 685.47 | 6523.0 |
| 2009-03-01 23:00:00 | ES | Futures | 685.47 | 686.65 | 684.99 | 685.94 | 2287.0 |
| 2009-03-01 18:00:00 | NQ | Futures | 1258.57 | 1259.42 | 1245.86 | 1248.69 | 1920.0 |
| 2009-03-01 19:00:00 | NQ | Futures | 1248.69 | 1249.82 | 1245.3 | 1246.43 | 495.0 |
| 2009-03-01 20:00:00 | NQ | Futures | 1246.43 | 1248.12 | 1243.89 | 1247.28 | 308.0 |
| 2009-03-01 21:00:00 | NQ | Futures | 1247.56 | 1248.12 | 1237.39 | 1241.06 | 967.0 |
| 2009-03-01 22:00:00 | NQ | Futures | 1241.06 | 1241.35 | 1237.11 | 1238.52 | 300.0 |
| 2009-03-01 23:00:00 | NQ | Futures | 1239.65 | 1241.63 | 1238.52 | 1241.06 | 223.0 |
| 2009-03-01 18:00:00 | YM | Futures | 6418.1 | 6424.5 | 6357.0 | 6370.7 | 1071.0 |
| 2009-03-01 19:00:00 | YM | Futures | 6369.8 | 6378.0 | 6358.0 | 6369.8 | 604.0 |
| 2009-03-01 20:00:00 | YM | Futures | 6369.8 | 6375.3 | 6362.5 | 6374.4 | 379.0 |
| 2009-03-01 21:00:00 | YM | Futures | 6374.4 | 6378.0 | 6347.9 | 6354.3 | 990.0 |
| 2009-03-01 22:00:00 | YM | Futures | 6354.3 | 6354.3 | 6337.0 | 6341.6 | 713.0 |
| 2009-03-01 23:00:00 | YM | Futures | 6342.5 | 6347.9 | 6336.1 | 6344.3 | 305.0 |
| 2009-03-01 18:00:00 | CL | Futures | 114.86 | 115.12 | 113.85 | 114.18 | 494.0 |
| 2009-03-01 19:00:00 | CL | Futures | 114.21 | 114.29 | 113.9 | 114.24 | 265.0 |
| 2009-03-01 20:00:00 | CL | Futures | 114.21 | 114.21 | 113.59 | 113.77 | 326.0 |
| 2009-03-01 21:00:00 | CL | Futures | 113.74 | 114.0 | 113.23 | 113.3 | 274.0 |
| 2009-03-01 22:00:00 | CL | Futures | 113.3 | 113.46 | 113.1 | 113.25 | 256.0 |
| 2009-03-01 23:00:00 | CL | Futures | 113.25 | 113.41 | 112.63 | 112.76 | 481.0 |
| 2009-03-01 18:00:00 | GC | Futures | 1337.7 | 1351.2 | 1336.7 | 1350.4 | 2303.0 |
| 2009-03-01 19:00:00 | GC | Futures | 1350.4 | 1358.0 | 1349.5 | 1355.5 | 2670.0 |
| 2009-03-01 20:00:00 | GC | Futures | 1355.5 | 1356.0 | 1352.1 | 1352.8 | 1851.0 |
| 2009-03-01 21:00:00 | GC | Futures | 1352.6 | 1357.8 | 1352.2 | 1354.3 | 918.0 |
| 2009-03-01 22:00:00 | GC | Futures | 1354.3 | 1356.3 | 1352.3 | 1355.3 | 593.0 |
| 2009-03-01 23:00:00 | GC | Futures | 1355.3 | 1358.5 | 1354.8 | 1358.0 | 987.0 |
| 2009-03-01 18:00:00 | ZN | Futures | 94.075525 | 94.316652 | 94.075525 | 94.232257 | 387.0 |
| 2009-03-01 19:00:00 | ZN | Futures | 94.232257 | 94.364877 | 94.220201 | 94.316652 | 765.0 |
| 2009-03-01 20:00:00 | ZN | Futures | 94.316652 | 94.316652 | 94.268426 | 94.268426 | 125.0 |
| 2009-03-01 21:00:00 | ZN | Futures | 94.280483 | 94.304595 | 94.244314 | 94.304595 | 287.0 |
| 2009-03-01 22:00:00 | ZN | Futures | 94.316652 | 94.376933 | 94.280483 | 94.304595 | 423.0 |
| 2009-03-01 23:00:00 | ZN | Futures | 94.328708 | 94.364877 | 94.328708 | 94.328708 | 187.0 |
> showing 36 of 220 rows — these rows as CSV