PREVIEW / futures_daily / 2009-10-09
file: by_date/futures_daily/2009/2009-10-09.parquet size: 9 KB rows: 87
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-09 | ES | Futures | 1025.54 | 1030.6 | 1020.96 | 1030.12 | 1327011.0 |
| 2009-10-09 | NQ | Futures | 1937.09 | 1950.36 | 1926.37 | 1947.82 | 207432.0 |
| 2009-10-09 | YM | Futures | 8845.3 | 8909.8 | 8811.7 | 8903.4 | 92484.0 |
| 2009-10-09 | CL | Futures | 176.87 | 179.17 | 174.89 | 177.74 | 322276.0 |
| 2009-10-09 | GC | Futures | 1459.7 | 1460.8 | 1444.2 | 1449.6 | 122696.0 |
| 2009-10-09 | ZN | Futures | 94.986666 | 95.06139 | 94.12734 | 94.276788 | 1063525.0 |
| 2009-10-09 | A6 | Futures | 0.72845 | 0.72999 | 0.72417 | 0.72546 | 66180.0 |
| 2009-10-09 | AD | Futures | 0.9373 | 0.94716 | 0.93444 | 0.9446 | 71881.0 |
| 2009-10-09 | B | Futures | 65.41 | 66.48 | 64.93 | 65.96 | 112921.0 |
| 2009-10-09 | B6 | Futures | 1.6711 | 1.6722 | 1.6461 | 1.6473 | 124936.0 |
| 2009-10-09 | BFX | Futures | 2883.1 | 2910.7 | 2883.1 | 2892.4 | 162.0 |
| 2009-10-09 | BR | Futures | 0.22607 | 0.22665 | 0.22599 | 0.22639 | 102.0 |
| 2009-10-09 | BZ | Futures | 68.49 | 69.52 | 68.47 | 69.18 | 8.0 |
| 2009-10-09 | C | Futures | 2224.0 | 2271.0 | 2208.0 | 2211.0 | 5983.0 |
| 2009-10-09 | CC | Futures | 2849.0 | 2921.0 | 2786.0 | 2846.0 | 7653.0 |
| 2009-10-09 | CT | Futures | 54.77 | 55.2 | 54.21 | 54.39 | 6195.0 |
| 2009-10-09 | DC | Futures | 24.87 | 25.26 | 24.69 | 25.1 | 384.0 |
| 2009-10-09 | DX | Futures | 77.771 | 78.333 | 77.725 | 78.226 | 9800.0 |
| 2009-10-09 | E1 | Futures | 1.28748 | 1.28801 | 1.27639 | 1.28035 | 46744.0 |
| 2009-10-09 | E6 | Futures | 1.75318 | 1.75318 | 1.73861 | 1.74299 | 212759.0 |
| 2009-10-09 | E7 | Futures | 1.7357 | 1.7361 | 1.7219 | 1.7263 | 4207.0 |
| 2009-10-09 | ED | Futures | 94.1812 | 94.1812 | 94.1529 | 94.1623 | 183985.0 |
| 2009-10-09 | ER | Futures | 97.086 | 97.091 | 97.032 | 97.037 | 294307.0 |
| 2009-10-09 | EW | Futures | 674.5 | 679.2 | 670.5 | 678.4 | 29030.0 |
| 2009-10-09 | FCE | Futures | 2511.8 | 2523.7 | 2492.7 | 2506.8 | 129824.0 |
| 2009-10-09 | FDAX | Futures | 6216.8 | 6257.1 | 6175.5 | 6213.0 | 125159.0 |
| 2009-10-09 | FESX | Futures | 1719.6 | 1726.8 | 1703.5 | 1712.5 | 886934.0 |
| 2009-10-09 | FEU3 | Futures | 97.653 | 97.653 | 97.608 | 97.608 | 294.0 |
| 2009-10-09 | FGBL | Futures | 94.4 | 94.67 | 93.95 | 94.08 | 997932.0 |
| 2009-10-09 | FGBM | Futures | 99.4 | 99.5 | 99.0 | 99.1 | 597312.0 |
| 2009-10-09 | FGBS | Futures | 104.706 | 104.711 | 104.503 | 104.522 | 814957.0 |
| 2009-10-09 | FGBX | Futures | 88.76 | 89.1 | 88.1 | 88.28 | 2856.0 |
| 2009-10-09 | FTDX | Futures | 670.1 | 676.3 | 665.6 | 674.5 | 204.0 |
| 2009-10-09 | FTI | Futures | 259.1 | 260.78 | 257.41 | 259.8 | 29102.0 |
| 2009-10-09 | FTUK | Futures | 3381.7 | 3413.2 | 3380.1 | 3401.3 | 92784.0 |
| 2009-10-09 | G | Futures | 78.22 | 78.33 | 77.74 | 77.79 | 101523.0 |
| 2009-10-09 | GF | Futures | 258.824 | 260.339 | 257.448 | 259.306 | 771.0 |
| 2009-10-09 | GSCI | Futures | 934.56 | 943.97 | 930.56 | 940.57 | 3456.0 |
| 2009-10-09 | HE | Futures | 81.822 | 82.127 | 79.917 | 80.451 | 13536.0 |
| 2009-10-09 | HG | Futures | 4.0224 | 4.0294 | 3.9332 | 3.9548 | 17279.0 |
| 2009-10-09 | HO | Futures | 1.8045 | 1.8377 | 1.7962 | 1.8206 | 21241.0 |
| 2009-10-09 | HRC | Futures | 2713.5 | 2713.5 | 2713.5 | 2713.5 | 0.0 |
| 2009-10-09 | J1 | Futures | 0.0142105 | 0.014218 | 0.0139744 | 0.0139807 | 115306.0 |
| 2009-10-09 | J7 | Futures | 0.014006 | 0.014013 | 0.013796 | 0.013798 | 259.0 |
| 2009-10-09 | JB | Futures | 117.57 | 117.6 | 117.34 | 117.41 | 3098.0 |
| 2009-10-09 | KC | Futures | 361.64 | 366.79 | 356.89 | 358.08 | 8451.0 |
| 2009-10-09 | KE | Futures | 2270.68 | 2290.46 | 2228.81 | 2256.73 | 9092.0 |
| 2009-10-09 | L | Futures | 97.789 | 97.799 | 97.76 | 97.77 | 59972.0 |
| 2009-10-09 | LBS | Futures | 674.5 | 676.6 | 666.8 | 666.8 | 1202.0 |
| 2009-10-09 | LE | Futures | 141.373 | 142.712 | 141.163 | 142.21 | 15564.0 |
> showing 50 of 87 rows — these rows as CSV