PREVIEW / futures_daily / 2009-06-12
file: by_date/futures_daily/2009/2009-06-12.parquet size: 8 KB rows: 83
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-06-12 | ES | Futures | 896.86 | 902.34 | 891.38 | 900.43 | 761323.0 |
| 2009-06-12 | NQ | Futures | 1673.19 | 1682.46 | 1651.28 | 1670.1 | 94492.0 |
| 2009-06-12 | YM | Futures | 7846.0 | 7901.0 | 7804.5 | 7883.9 | 103122.0 |
| 2009-06-12 | CL | Futures | 192.82 | 193.36 | 188.48 | 191.78 | 224601.0 |
| 2009-06-12 | GC | Futures | 1324.0 | 1328.0 | 1296.1 | 1302.4 | 103112.0 |
| 2009-06-12 | ZN | Futures | 89.882318 | 90.325574 | 89.833068 | 90.103946 | 574693.0 |
| 2009-06-12 | A6 | Futures | 0.65383 | 0.6556 | 0.64314 | 0.64885 | 53994.0 |
| 2009-06-12 | AD | Futures | 0.89595 | 0.89793 | 0.87857 | 0.88341 | 65722.0 |
| 2009-06-12 | B | Futures | 69.09 | 69.21 | 67.69 | 68.68 | 101337.0 |
| 2009-06-12 | B6 | Futures | 1.726 | 1.7287 | 1.7 | 1.7132 | 83522.0 |
| 2009-06-12 | BR | Futures | 0.19956 | 0.19956 | 0.19905 | 0.19948 | 6.0 |
| 2009-06-12 | C | Futures | 1909.0 | 1920.0 | 1880.0 | 1891.0 | 2639.0 |
| 2009-06-12 | CB | Futures | 73.895 | 74.321 | 73.895 | 73.895 | 16.0 |
| 2009-06-12 | CC | Futures | 2517.0 | 2528.0 | 2474.0 | 2489.0 | 7867.0 |
| 2009-06-12 | CT | Futures | 52.12 | 52.57 | 51.35 | 51.9 | 14293.0 |
| 2009-06-12 | DC | Futures | 22.3 | 22.38 | 22.04 | 22.11 | 205.0 |
| 2009-06-12 | DX | Futures | 81.755 | 82.85 | 81.678 | 82.487 | 8198.0 |
| 2009-06-12 | E1 | Futures | 1.23735 | 1.23986 | 1.22159 | 1.22782 | 38401.0 |
| 2009-06-12 | E6 | Futures | 1.67203 | 1.67571 | 1.65268 | 1.6617 | 167863.0 |
| 2009-06-12 | E7 | Futures | 1.6548 | 1.6583 | 1.6358 | 1.6446 | 2751.0 |
| 2009-06-12 | ED | Futures | 93.6969 | 93.7441 | 93.6969 | 93.73 | 194111.0 |
| 2009-06-12 | ER | Futures | 96.694 | 96.743 | 96.694 | 96.733 | 136516.0 |
| 2009-06-12 | EW | Futures | 574.3 | 576.2 | 566.6 | 573.1 | 42214.0 |
| 2009-06-12 | FCE | Futures | 2169.7 | 2177.6 | 2159.0 | 2167.4 | 4340.0 |
| 2009-06-12 | FDAX | Futures | 5546.3 | 5562.6 | 5493.5 | 5519.6 | 107499.0 |
| 2009-06-12 | FESX | Futures | 1495.9 | 1501.2 | 1486.9 | 1492.3 | 120629.0 |
| 2009-06-12 | FEU3 | Futures | 97.283 | 97.308 | 97.283 | 97.308 | 1414.0 |
| 2009-06-12 | FGBL | Futures | 89.95 | 90.3 | 89.93 | 90.08 | 492506.0 |
| 2009-06-12 | FGBM | Futures | 96.35 | 96.5 | 96.31 | 96.38 | 289822.0 |
| 2009-06-12 | FGBS | Futures | 103.271 | 103.358 | 103.266 | 103.309 | 381772.0 |
| 2009-06-12 | FGBX | Futures | 81.2 | 81.43 | 80.82 | 81.19 | 1550.0 |
| 2009-06-12 | FTDX | Futures | 588.9 | 593.4 | 580.0 | 584.4 | 394.0 |
| 2009-06-12 | FTI | Futures | 217.29 | 217.9 | 214.81 | 215.78 | 408.0 |
| 2009-06-12 | FTUK | Futures | 2931.7 | 2942.7 | 2913.5 | 2921.8 | 64159.0 |
| 2009-06-12 | G | Futures | 74.05 | 74.14 | 73.79 | 73.98 | 56260.0 |
| 2009-06-12 | GF | Futures | 265.225 | 269.635 | 264.054 | 268.946 | 1220.0 |
| 2009-06-12 | GSCI | Futures | 979.48 | 989.39 | 977.6 | 986.16 | 260.0 |
| 2009-06-12 | HE | Futures | 87.874 | 88.532 | 86.924 | 87.436 | 7328.0 |
| 2009-06-12 | HG | Futures | 3.428 | 3.4329 | 3.3203 | 3.3393 | 20985.0 |
| 2009-06-12 | HO | Futures | 1.9399 | 1.9482 | 1.9128 | 1.9394 | 7354.0 |
| 2009-06-12 | HRC | Futures | 2291.7 | 2291.7 | 2291.7 | 2291.7 | 0.0 |
| 2009-06-12 | J1 | Futures | 0.0128976 | 0.0129265 | 0.0127981 | 0.0128283 | 62887.0 |
| 2009-06-12 | J7 | Futures | 0.012694 | 0.012694 | 0.012614 | 0.012652 | 22.0 |
| 2009-06-12 | JB | Futures | 114.23 | 114.63 | 114.15 | 114.63 | 3060.0 |
| 2009-06-12 | KC | Futures | 363.95 | 363.95 | 355.36 | 358.96 | 7656.0 |
| 2009-06-12 | KE | Futures | 3126.58 | 3158.28 | 3061.98 | 3105.86 | 9606.0 |
| 2009-06-12 | L | Futures | 96.993 | 97.033 | 96.993 | 97.013 | 37974.0 |
| 2009-06-12 | LBS | Futures | 899.0 | 941.4 | 899.0 | 941.4 | 279.0 |
| 2009-06-12 | LE | Futures | 143.761 | 144.73 | 142.88 | 143.805 | 4237.0 |
| 2009-06-12 | MP | Futures | 0.03864 | 0.03871 | 0.03842 | 0.03859 | 9962.0 |
> showing 50 of 83 rows — these rows as CSV