PREVIEW / futures_daily / 2009-11-02
file: by_date/futures_daily/2009/2009-11-02.parquet size: 9 KB rows: 89
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-11-02 | ES | Futures | 994.68 | 1012.28 | 989.61 | 1002.15 | 2783823.0 |
| 2009-11-02 | NQ | Futures | 1875.01 | 1905.2 | 1862.87 | 1884.04 | 456628.0 |
| 2009-11-02 | YM | Futures | 8768.2 | 8908.0 | 8711.9 | 8838.1 | 219769.0 |
| 2009-11-02 | CL | Futures | 188.73 | 192.74 | 187.6 | 191.45 | 371006.0 |
| 2009-11-02 | GC | Futures | 1442.4 | 1470.1 | 1440.8 | 1457.1 | 132632.0 |
| 2009-11-02 | ZN | Futures | 94.662862 | 94.700224 | 94.276788 | 94.43869 | 744279.0 |
| 2009-11-02 | A6 | Futures | 0.72029 | 0.73435 | 0.72029 | 0.72562 | 118215.0 |
| 2009-11-02 | AD | Futures | 0.9088 | 0.92034 | 0.90831 | 0.91393 | 83903.0 |
| 2009-11-02 | B | Futures | 70.65 | 72.33 | 70.32 | 71.86 | 59912.0 |
| 2009-11-02 | B6 | Futures | 1.7056 | 1.7143 | 1.6984 | 1.7046 | 130234.0 |
| 2009-11-02 | BFX | Futures | 2700.5 | 2728.5 | 2693.5 | 2693.5 | 683.0 |
| 2009-11-02 | BR | Futures | 0.22438 | 0.22438 | 0.22438 | 0.22438 | 17.0 |
| 2009-11-02 | BZ | Futures | 75.59 | 76.51 | 75.59 | 76.51 | 1.0 |
| 2009-11-02 | C | Futures | 2216.0 | 2228.0 | 2184.0 | 2192.0 | 5076.0 |
| 2009-11-02 | CB | Futures | 76.652 | 77.19 | 76.652 | 76.652 | 5.0 |
| 2009-11-02 | CC | Futures | 2893.0 | 2912.0 | 2834.0 | 2852.0 | 11571.0 |
| 2009-11-02 | CT | Futures | 58.24 | 59.77 | 57.86 | 58.37 | 13725.0 |
| 2009-11-02 | DC | Futures | 25.51 | 25.55 | 24.83 | 24.97 | 227.0 |
| 2009-11-02 | DX | Futures | 78.078 | 78.18 | 77.674 | 78.062 | 14262.0 |
| 2009-11-02 | E1 | Futures | 1.28893 | 1.29977 | 1.28669 | 1.29105 | 63108.0 |
| 2009-11-02 | E6 | Futures | 1.74572 | 1.75911 | 1.74216 | 1.74821 | 277473.0 |
| 2009-11-02 | E7 | Futures | 1.7298 | 1.7423 | 1.7257 | 1.7315 | 2801.0 |
| 2009-11-02 | ED | Futures | 94.2238 | 94.2332 | 94.219 | 94.2285 | 109616.0 |
| 2009-11-02 | ER | Futures | 97.13 | 97.139 | 97.125 | 97.13 | 49812.0 |
| 2009-11-02 | EW | Futures | 636.9 | 648.5 | 630.2 | 639.6 | 61350.0 |
| 2009-11-02 | FBTP | Futures | 62.64 | 62.83 | 62.64 | 62.75 | 1602.0 |
| 2009-11-02 | FCE | Futures | 2369.1 | 2413.3 | 2352.9 | 2394.8 | 145902.0 |
| 2009-11-02 | FDAX | Futures | 5889.3 | 5957.9 | 5806.1 | 5902.9 | 194837.0 |
| 2009-11-02 | FESX | Futures | 1629.5 | 1656.9 | 1613.3 | 1642.6 | 1515620.0 |
| 2009-11-02 | FEU3 | Futures | 97.702 | 97.702 | 97.702 | 97.702 | 118.0 |
| 2009-11-02 | FGBL | Futures | 94.0 | 94.11 | 93.84 | 93.95 | 646772.0 |
| 2009-11-02 | FGBM | Futures | 99.2 | 99.31 | 99.12 | 99.22 | 350911.0 |
| 2009-11-02 | FGBS | Futures | 104.721 | 104.765 | 104.692 | 104.726 | 359618.0 |
| 2009-11-02 | FGBX | Futures | 87.42 | 87.57 | 87.16 | 87.3 | 2891.0 |
| 2009-11-02 | FTDX | Futures | 641.1 | 648.7 | 634.9 | 643.8 | 758.0 |
| 2009-11-02 | FTI | Futures | 247.28 | 248.5 | 242.65 | 246.78 | 38018.0 |
| 2009-11-02 | FTUK | Futures | 3310.7 | 3375.4 | 3309.7 | 3360.8 | 119833.0 |
| 2009-11-02 | G | Futures | 76.94 | 77.04 | 76.62 | 76.7 | 69567.0 |
| 2009-11-02 | GF | Futures | 261.645 | 263.227 | 260.819 | 261.714 | 1309.0 |
| 2009-11-02 | GSCI | Futures | 983.86 | 992.81 | 976.18 | 987.79 | 236.0 |
| 2009-11-02 | HE | Futures | 86.434 | 88.682 | 86.205 | 87.996 | 14485.0 |
| 2009-11-02 | HG | Futures | 4.1074 | 4.1631 | 4.0726 | 4.1039 | 30274.0 |
| 2009-11-02 | HO | Futures | 1.9443 | 1.9883 | 1.9369 | 1.982 | 48004.0 |
| 2009-11-02 | HRC | Futures | 2713.1 | 2713.1 | 2713.1 | 2713.1 | 0.0 |
| 2009-11-02 | J1 | Futures | 0.0140045 | 0.0140422 | 0.0138463 | 0.0138953 | 98049.0 |
| 2009-11-02 | J7 | Futures | 0.013818 | 0.013845 | 0.013672 | 0.013714 | 99.0 |
| 2009-11-02 | JB | Futures | 116.38 | 116.7 | 116.35 | 116.7 | 1470.0 |
| 2009-11-02 | KC | Futures | 356.36 | 377.74 | 356.23 | 375.76 | 21579.0 |
| 2009-11-02 | KE | Futures | 2319.54 | 2432.38 | 2299.77 | 2419.58 | 7811.0 |
| 2009-11-02 | L | Futures | 97.789 | 97.789 | 97.75 | 97.77 | 30717.0 |
> showing 50 of 89 rows — these rows as CSV