PREVIEW / futures_daily / 2009-08-18
file: by_date/futures_daily/2009/2009-08-18.parquet size: 8 KB rows: 86
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2009-08-18 | ES | Futures | 938.57 | 949.85 | 936.65 | 949.37 | 1753397.0 |
| 2009-08-18 | NQ | Futures | 1764.13 | 1788.63 | 1761.04 | 1787.22 | 271573.0 |
| 2009-08-18 | YM | Futures | 8226.7 | 8312.4 | 8215.9 | 8307.0 | 129223.0 |
| 2009-08-18 | CL | Futures | 171.68 | 179.59 | 169.51 | 177.37 | 235078.0 |
| 2009-08-18 | GC | Futures | 1292.6 | 1301.7 | 1292.6 | 1298.4 | 52980.0 |
| 2009-08-18 | ZN | Futures | 92.861979 | 92.886604 | 92.554163 | 92.603413 | 601578.0 |
| 2009-08-18 | A6 | Futures | 0.65841 | 0.66372 | 0.65721 | 0.66267 | 65171.0 |
| 2009-08-18 | AD | Futures | 0.8921 | 0.89783 | 0.88924 | 0.89655 | 52299.0 |
| 2009-08-18 | B | Futures | 66.88 | 69.33 | 65.79 | 68.54 | 118040.0 |
| 2009-08-18 | B6 | Futures | 1.7014 | 1.7277 | 1.7003 | 1.7258 | 103090.0 |
| 2009-08-18 | BFX | Futures | 2551.2 | 2567.8 | 2543.4 | 2567.8 | 837.0 |
| 2009-08-18 | BR | Futures | 0.21 | 0.21 | 0.21 | 0.21 | 11.0 |
| 2009-08-18 | BZ | Futures | 69.17 | 71.63 | 69.17 | 71.5 | 16.0 |
| 2009-08-18 | C | Futures | 1841.0 | 1851.0 | 1805.0 | 1818.0 | 2061.0 |
| 2009-08-18 | CB | Futures | 68.21 | 68.21 | 68.21 | 68.21 | 8.0 |
| 2009-08-18 | CC | Futures | 2396.0 | 2432.0 | 2368.0 | 2410.0 | 6405.0 |
| 2009-08-18 | CT | Futures | 51.01 | 51.38 | 50.11 | 50.16 | 141.0 |
| 2009-08-18 | DC | Futures | 22.18 | 22.38 | 21.98 | 22.38 | 75.0 |
| 2009-08-18 | DX | Futures | 81.182 | 81.33 | 80.839 | 80.895 | 4368.0 |
| 2009-08-18 | E1 | Futures | 1.22702 | 1.23258 | 1.2257 | 1.23139 | 27768.0 |
| 2009-08-18 | E6 | Futures | 1.67061 | 1.68058 | 1.67001 | 1.67844 | 176720.0 |
| 2009-08-18 | E7 | Futures | 1.6536 | 1.663 | 1.653 | 1.6612 | 1759.0 |
| 2009-08-18 | ED | Futures | 93.9944 | 94.0085 | 93.9896 | 94.0015 | 106127.0 |
| 2009-08-18 | ER | Futures | 97.125 | 97.135 | 97.11 | 97.12 | 67310.0 |
| 2009-08-18 | EW | Futures | 606.5 | 615.5 | 605.8 | 614.8 | 30415.0 |
| 2009-08-18 | FCE | Futures | 2243.8 | 2262.1 | 2234.0 | 2255.6 | 142969.0 |
| 2009-08-18 | FDAX | Futures | 5743.7 | 5773.3 | 5703.1 | 5741.5 | 99918.0 |
| 2009-08-18 | FESX | Futures | 1559.7 | 1574.0 | 1551.9 | 1563.3 | 876085.0 |
| 2009-08-18 | FEU3 | Futures | 97.702 | 97.702 | 97.687 | 97.697 | 81.0 |
| 2009-08-18 | FGBL | Futures | 92.81 | 92.9 | 92.58 | 92.86 | 538402.0 |
| 2009-08-18 | FGBM | Futures | 98.2 | 98.31 | 98.05 | 98.28 | 258458.0 |
| 2009-08-18 | FGBS | Futures | 104.109 | 104.123 | 104.013 | 104.109 | 361411.0 |
| 2009-08-18 | FGBX | Futures | 86.32 | 86.46 | 85.85 | 86.29 | 3729.0 |
| 2009-08-18 | FTDX | Futures | 612.5 | 619.7 | 609.4 | 614.8 | 600.0 |
| 2009-08-18 | FTI | Futures | 233.61 | 235.14 | 232.75 | 234.77 | 14085.0 |
| 2009-08-18 | FTUK | Futures | 3094.0 | 3113.6 | 3075.4 | 3091.4 | 102090.0 |
| 2009-08-18 | G | Futures | 76.58 | 76.63 | 76.25 | 76.32 | 80893.0 |
| 2009-08-18 | GF | Futures | 277.14 | 280.595 | 276.932 | 279.904 | 700.0 |
| 2009-08-18 | GSCI | Futures | 916.57 | 943.58 | 912.29 | 939.6 | 250.0 |
| 2009-08-18 | HE | Futures | 66.667 | 70.227 | 64.531 | 66.742 | 14619.0 |
| 2009-08-18 | HG | Futures | 3.8719 | 3.9526 | 3.8206 | 3.8775 | 23193.0 |
| 2009-08-18 | HO | Futures | 1.8485 | 1.9022 | 1.8215 | 1.8875 | 4339.0 |
| 2009-08-18 | HRC | Futures | 2586.5 | 2586.5 | 2586.5 | 2586.5 | 0.0 |
| 2009-08-18 | J1 | Futures | 0.0133244 | 0.0133483 | 0.0132136 | 0.0133055 | 71428.0 |
| 2009-08-18 | J7 | Futures | 0.013117 | 0.013158 | 0.013035 | 0.013122 | 33.0 |
| 2009-08-18 | JB | Futures | 116.81 | 116.98 | 116.68 | 116.81 | 2130.0 |
| 2009-08-18 | KC | Futures | 341.62 | 342.3 | 333.75 | 338.5 | 6845.0 |
| 2009-08-18 | KE | Futures | 2393.38 | 2418.56 | 2381.39 | 2390.98 | 3684.0 |
| 2009-08-18 | L | Futures | 97.553 | 97.573 | 97.514 | 97.543 | 39802.0 |
| 2009-08-18 | LBS | Futures | 751.8 | 753.8 | 727.9 | 736.4 | 396.0 |
> showing 50 of 86 rows — these rows as CSV