PREVIEW / futures_daily / 2009-10-28
file: by_date/futures_daily/2009/2009-10-28.parquet size: 9 KB rows: 88
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-10-28 | ES | Futures | 1023.37 | 1025.3 | 1001.19 | 1001.67 | 2843071.0 |
| 2009-10-28 | NQ | Futures | 1941.04 | 1944.99 | 1893.35 | 1896.45 | 441310.0 |
| 2009-10-28 | YM | Futures | 8933.4 | 8950.7 | 8810.8 | 8816.3 | 187938.0 |
| 2009-10-28 | CL | Futures | 194.73 | 195.61 | 188.82 | 189.8 | 359438.0 |
| 2009-10-28 | GC | Futures | 1437.7 | 1441.3 | 1419.6 | 1424.6 | 152915.0 |
| 2009-10-28 | ZN | Futures | 93.990346 | 94.413782 | 93.87826 | 94.25188 | 998092.0 |
| 2009-10-28 | A6 | Futures | 0.73742 | 0.74057 | 0.72102 | 0.72304 | 139071.0 |
| 2009-10-28 | AD | Futures | 0.92675 | 0.92675 | 0.91166 | 0.91383 | 92282.0 |
| 2009-10-28 | B | Futures | 73.03 | 73.19 | 70.96 | 71.16 | 65830.0 |
| 2009-10-28 | B6 | Futures | 1.7033 | 1.7131 | 1.694 | 1.707 | 171410.0 |
| 2009-10-28 | BFX | Futures | 2757.5 | 2757.5 | 2682.8 | 2687.6 | 406.0 |
| 2009-10-28 | BR | Futures | 0.22714 | 0.22714 | 0.22305 | 0.22492 | 272.0 |
| 2009-10-28 | BZ | Futures | 76.06 | 76.06 | 75.76 | 75.76 | 1.0 |
| 2009-10-28 | C | Futures | 2244.0 | 2253.0 | 2205.0 | 2238.0 | 6105.0 |
| 2009-10-28 | CC | Futures | 2939.0 | 2939.0 | 2863.0 | 2920.0 | 10497.0 |
| 2009-10-28 | CT | Futures | 57.86 | 58.04 | 57.07 | 57.72 | 9275.0 |
| 2009-10-28 | DC | Futures | 24.93 | 24.95 | 24.56 | 24.73 | 304.0 |
| 2009-10-28 | DX | Futures | 77.838 | 78.312 | 77.725 | 78.19 | 16818.0 |
| 2009-10-28 | E1 | Futures | 1.29369 | 1.29633 | 1.28524 | 1.28761 | 58031.0 |
| 2009-10-28 | E6 | Futures | 1.75484 | 1.75864 | 1.74098 | 1.7443 | 318928.0 |
| 2009-10-28 | E7 | Futures | 1.738 | 1.7418 | 1.7243 | 1.7276 | 3716.0 |
| 2009-10-28 | ED | Futures | 94.219 | 94.238 | 94.2143 | 94.2285 | 184622.0 |
| 2009-10-28 | ER | Futures | 97.144 | 97.149 | 97.139 | 97.139 | 62178.0 |
| 2009-10-28 | EW | Futures | 663.8 | 665.9 | 641.2 | 642.9 | 49419.0 |
| 2009-10-28 | FBTP | Futures | 62.52 | 62.64 | 62.46 | 62.59 | 4372.0 |
| 2009-10-28 | FCE | Futures | 2451.0 | 2456.6 | 2394.2 | 2412.0 | 147910.0 |
| 2009-10-28 | FDAX | Futures | 6115.6 | 6127.6 | 5942.1 | 5997.1 | 220524.0 |
| 2009-10-28 | FESX | Futures | 1679.6 | 1682.6 | 1637.8 | 1655.7 | 1545245.0 |
| 2009-10-28 | FEU3 | Futures | 97.712 | 97.717 | 97.712 | 97.712 | 3617.0 |
| 2009-10-28 | FGBL | Futures | 93.63 | 93.86 | 93.52 | 93.76 | 749108.0 |
| 2009-10-28 | FGBM | Futures | 99.12 | 99.26 | 99.04 | 99.18 | 463761.0 |
| 2009-10-28 | FGBS | Futures | 104.721 | 104.76 | 104.687 | 104.735 | 441991.0 |
| 2009-10-28 | FGBX | Futures | 86.48 | 86.96 | 86.44 | 86.82 | 1974.0 |
| 2009-10-28 | FTDX | Futures | 658.9 | 658.9 | 630.9 | 635.8 | 1545.0 |
| 2009-10-28 | FTI | Futures | 252.47 | 252.84 | 245.6 | 247.44 | 47710.0 |
| 2009-10-28 | FTUK | Futures | 3420.8 | 3422.8 | 3325.3 | 3357.5 | 133564.0 |
| 2009-10-28 | G | Futures | 76.98 | 77.2 | 76.8 | 77.0 | 100971.0 |
| 2009-10-28 | GF | Futures | 263.571 | 264.465 | 260.751 | 262.745 | 1465.0 |
| 2009-10-28 | GSCI | Futures | 997.04 | 997.04 | 978.05 | 978.05 | 787.0 |
| 2009-10-28 | HE | Futures | 84.681 | 85.367 | 83.309 | 85.29 | 13886.0 |
| 2009-10-28 | HG | Futures | 4.1959 | 4.2279 | 4.0677 | 4.0837 | 28456.0 |
| 2009-10-28 | HO | Futures | 2.0097 | 2.0164 | 1.9523 | 1.958 | 45822.0 |
| 2009-10-28 | HRC | Futures | 2713.1 | 2713.1 | 2713.1 | 2713.1 | 0.0 |
| 2009-10-28 | J1 | Futures | 0.0136843 | 0.0138702 | 0.0136793 | 0.0138325 | 120764.0 |
| 2009-10-28 | J7 | Futures | 0.013532 | 0.013687 | 0.013516 | 0.013652 | 115.0 |
| 2009-10-28 | JB | Futures | 116.22 | 116.42 | 116.15 | 116.19 | 1541.0 |
| 2009-10-28 | KC | Futures | 359.92 | 360.45 | 350.95 | 355.3 | 9775.0 |
| 2009-10-28 | KE | Futures | 2375.38 | 2399.81 | 2332.34 | 2336.99 | 9678.0 |
| 2009-10-28 | L | Futures | 97.819 | 97.829 | 97.799 | 97.809 | 40212.0 |
| 2009-10-28 | LBS | Futures | 713.2 | 720.2 | 709.2 | 713.2 | 329.0 |
> showing 50 of 88 rows — these rows as CSV