PREVIEW / futures_daily / 2009-06-15
file: by_date/futures_daily/2009/2009-06-15.parquet size: 8 KB rows: 84
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-15 | ES | Futures | 900.43 | 900.67 | 878.13 | 882.21 | 2146711.0 |
| 2009-06-15 | NQ | Futures | 1670.1 | 1670.1 | 1625.62 | 1641.1 | 321471.0 |
| 2009-06-15 | YM | Futures | 7865.8 | 7867.6 | 7688.1 | 7726.9 | 130103.0 |
| 2009-06-15 | CL | Futures | 191.78 | 191.89 | 184.97 | 187.63 | 88091.0 |
| 2009-06-15 | GC | Futures | 1301.8 | 1301.8 | 1282.7 | 1284.1 | 91532.0 |
| 2009-06-15 | ZN | Futures | 90.103946 | 90.547201 | 89.931569 | 90.473325 | 517590.0 |
| 2009-06-15 | A6 | Futures | 0.64571 | 0.64893 | 0.63077 | 0.63205 | 65218.0 |
| 2009-06-15 | AD | Futures | 0.88223 | 0.8839 | 0.8684 | 0.87146 | 69782.0 |
| 2009-06-15 | B | Futures | 68.74 | 68.84 | 66.29 | 67.19 | 105383.0 |
| 2009-06-15 | B6 | Futures | 1.7097 | 1.7125 | 1.6912 | 1.6967 | 93127.0 |
| 2009-06-15 | BFX | Futures | 2315.1 | 2316.0 | 2281.7 | 2283.8 | 1928.0 |
| 2009-06-15 | C | Futures | 1867.0 | 1869.0 | 1795.0 | 1815.0 | 2720.0 |
| 2009-06-15 | CB | Futures | 74.037 | 74.037 | 74.037 | 74.037 | 2.0 |
| 2009-06-15 | CC | Futures | 2476.0 | 2476.0 | 2341.0 | 2353.0 | 11586.0 |
| 2009-06-15 | CT | Futures | 52.0 | 52.02 | 49.13 | 49.13 | 14293.0 |
| 2009-06-15 | DC | Futures | 22.11 | 22.11 | 21.81 | 21.88 | 149.0 |
| 2009-06-15 | DX | Futures | 82.681 | 83.705 | 82.497 | 83.475 | 7690.0 |
| 2009-06-15 | E1 | Futures | 1.22557 | 1.22954 | 1.20995 | 1.21273 | 39781.0 |
| 2009-06-15 | E6 | Futures | 1.65933 | 1.66063 | 1.63131 | 1.63523 | 203067.0 |
| 2009-06-15 | E7 | Futures | 1.6419 | 1.6434 | 1.6148 | 1.6184 | 3080.0 |
| 2009-06-15 | ED | Futures | 93.73 | 93.7583 | 93.7111 | 93.73 | 202335.0 |
| 2009-06-15 | ER | Futures | 96.738 | 96.777 | 96.733 | 96.767 | 180925.0 |
| 2009-06-15 | EW | Futures | 571.8 | 572.5 | 555.7 | 562.1 | 49105.0 |
| 2009-06-15 | FCE | Futures | 2162.5 | 2162.5 | 2093.7 | 2098.3 | 95255.0 |
| 2009-06-15 | FDAX | Futures | 5510.9 | 5510.9 | 5316.0 | 5335.0 | 179616.0 |
| 2009-06-15 | FESX | Futures | 1491.7 | 1491.7 | 1441.6 | 1447.5 | 888693.0 |
| 2009-06-15 | FEU3 | Futures | 97.318 | 97.352 | 97.313 | 97.342 | 849.0 |
| 2009-06-15 | FGBL | Futures | 90.18 | 90.91 | 90.15 | 90.81 | 564916.0 |
| 2009-06-15 | FGBM | Futures | 96.44 | 96.94 | 96.43 | 96.88 | 336720.0 |
| 2009-06-15 | FGBS | Futures | 103.338 | 103.483 | 103.329 | 103.459 | 365509.0 |
| 2009-06-15 | FGBX | Futures | 81.38 | 81.96 | 81.38 | 81.94 | 1238.0 |
| 2009-06-15 | FTDX | Futures | 580.0 | 580.0 | 564.8 | 564.8 | 301.0 |
| 2009-06-15 | FTI | Futures | 215.46 | 215.46 | 209.64 | 210.01 | 9228.0 |
| 2009-06-15 | FTUK | Futures | 2911.5 | 2911.5 | 2844.1 | 2852.8 | 191451.0 |
| 2009-06-15 | G | Futures | 74.31 | 74.65 | 74.11 | 74.61 | 75035.0 |
| 2009-06-15 | GF | Futures | 268.74 | 269.566 | 266.948 | 267.913 | 679.0 |
| 2009-06-15 | GSCI | Futures | 975.62 | 979.27 | 959.35 | 966.34 | 373.0 |
| 2009-06-15 | HE | Futures | 87.838 | 87.838 | 84.804 | 85.389 | 5697.0 |
| 2009-06-15 | HG | Futures | 3.3513 | 3.3689 | 3.1923 | 3.2148 | 21980.0 |
| 2009-06-15 | HO | Futures | 1.9257 | 1.9448 | 1.8873 | 1.9144 | 6571.0 |
| 2009-06-15 | HRC | Futures | 2291.7 | 2291.7 | 2291.7 | 2291.7 | 0.0 |
| 2009-06-15 | J1 | Futures | 0.0128145 | 0.0129127 | 0.012783 | 0.0129039 | 64319.0 |
| 2009-06-15 | J7 | Futures | 0.012648 | 0.012731 | 0.012617 | 0.012726 | 30.0 |
| 2009-06-15 | JB | Futures | 114.54 | 114.76 | 114.49 | 114.73 | 1188.0 |
| 2009-06-15 | KC | Futures | 357.16 | 357.58 | 335.69 | 336.24 | 17291.0 |
| 2009-06-15 | KE | Futures | 3114.39 | 3120.49 | 3024.19 | 3080.26 | 8459.0 |
| 2009-06-15 | L | Futures | 97.023 | 97.043 | 96.993 | 97.013 | 44712.0 |
| 2009-06-15 | LBS | Futures | 941.9 | 947.8 | 912.2 | 927.3 | 203.0 |
| 2009-06-15 | LE | Futures | 143.629 | 144.069 | 142.219 | 142.439 | 4720.0 |
| 2009-06-15 | MP | Futures | 0.03864 | 0.03869 | 0.03812 | 0.03859 | 6156.0 |
> showing 50 of 84 rows — these rows as CSV