PREVIEW / futures_daily / 2009-10-21
file: by_date/futures_daily/2009/2009-10-21.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-10-21 | ES | Futures | 1050.38 | 1059.54 | 1034.46 | 1039.77 | 2418114.0 |
| 2009-10-21 | NQ | Futures | 1983.66 | 2008.49 | 1970.96 | 1979.14 | 321499.0 |
| 2009-10-21 | YM | Futures | 9076.8 | 9140.4 | 8923.4 | 8988.8 | 173006.0 |
| 2009-10-21 | CL | Futures | 192.82 | 200.93 | 190.25 | 199.39 | 395742.0 |
| 2009-10-21 | GC | Futures | 1459.6 | 1473.3 | 1448.9 | 1471.6 | 140364.0 |
| 2009-10-21 | ZN | Futures | 94.538322 | 94.637954 | 93.965438 | 94.06507 | 929560.0 |
| 2009-10-21 | A6 | Futures | 0.74259 | 0.75011 | 0.73912 | 0.74874 | 92811.0 |
| 2009-10-21 | AD | Futures | 0.93937 | 0.95012 | 0.93148 | 0.94913 | 94598.0 |
| 2009-10-21 | B | Futures | 71.75 | 74.87 | 70.93 | 74.34 | 171780.0 |
| 2009-10-21 | B6 | Futures | 1.704 | 1.7306 | 1.7004 | 1.7304 | 162534.0 |
| 2009-10-21 | BFX | Futures | 2936.4 | 2936.4 | 2889.4 | 2917.2 | 27.0 |
| 2009-10-21 | BR | Futures | 0.2242 | 0.22857 | 0.2242 | 0.2285 | 541.0 |
| 2009-10-21 | BZ | Futures | 75.51 | 78.22 | 75.51 | 77.97 | 57.0 |
| 2009-10-21 | C | Futures | 2221.0 | 2239.0 | 2211.0 | 2234.0 | 3622.0 |
| 2009-10-21 | CB | Futures | 72.618 | 72.618 | 72.08 | 72.483 | 19.0 |
| 2009-10-21 | CC | Futures | 2935.0 | 2972.0 | 2917.0 | 2969.0 | 7730.0 |
| 2009-10-21 | CT | Futures | 58.08 | 59.1 | 57.71 | 59.01 | 6975.0 |
| 2009-10-21 | DC | Futures | 25.21 | 25.22 | 24.93 | 25.0 | 89.0 |
| 2009-10-21 | DX | Futures | 77.312 | 77.485 | 76.658 | 76.684 | 14018.0 |
| 2009-10-21 | E1 | Futures | 1.30492 | 1.31681 | 1.30109 | 1.31522 | 51570.0 |
| 2009-10-21 | E6 | Futures | 1.77001 | 1.78305 | 1.76421 | 1.78175 | 297781.0 |
| 2009-10-21 | E7 | Futures | 1.7534 | 1.7658 | 1.7475 | 1.7647 | 4581.0 |
| 2009-10-21 | ED | Futures | 94.1907 | 94.2001 | 94.1907 | 94.1954 | 64242.0 |
| 2009-10-21 | ER | Futures | 97.071 | 97.086 | 97.071 | 97.076 | 85609.0 |
| 2009-10-21 | EW | Futures | 687.2 | 694.8 | 674.2 | 679.1 | 46934.0 |
| 2009-10-21 | FBTP | Futures | 62.49 | 62.49 | 62.13 | 62.19 | 6234.0 |
| 2009-10-21 | FCE | Futures | 2550.1 | 2561.4 | 2504.9 | 2550.4 | 136968.0 |
| 2009-10-21 | FDAX | Futures | 6340.9 | 6378.4 | 6244.6 | 6353.9 | 185514.0 |
| 2009-10-21 | FESX | Futures | 1743.5 | 1756.1 | 1716.1 | 1749.5 | 1348581.0 |
| 2009-10-21 | FEU3 | Futures | 97.638 | 97.653 | 97.638 | 97.648 | 45.0 |
| 2009-10-21 | FGBL | Futures | 93.82 | 93.89 | 93.21 | 93.37 | 983612.0 |
| 2009-10-21 | FGBM | Futures | 99.04 | 99.1 | 98.77 | 98.87 | 438217.0 |
| 2009-10-21 | FGBS | Futures | 104.532 | 104.566 | 104.469 | 104.508 | 479705.0 |
| 2009-10-21 | FGBX | Futures | 86.84 | 87.19 | 85.93 | 86.2 | 2590.0 |
| 2009-10-21 | FTDX | Futures | 691.9 | 694.1 | 678.5 | 689.2 | 891.0 |
| 2009-10-21 | FTI | Futures | 266.06 | 267.0 | 261.64 | 265.44 | 40755.0 |
| 2009-10-21 | FTUK | Futures | 3477.9 | 3477.9 | 3413.2 | 3467.3 | 109731.0 |
| 2009-10-21 | G | Futures | 77.17 | 77.24 | 76.31 | 76.43 | 202872.0 |
| 2009-10-21 | GF | Futures | 263.295 | 265.634 | 263.295 | 264.74 | 2633.0 |
| 2009-10-21 | GSCI | Futures | 1008.45 | 1039.94 | 997.43 | 1035.02 | 625.0 |
| 2009-10-21 | HE | Futures | 81.098 | 82.394 | 80.755 | 81.822 | 11907.0 |
| 2009-10-21 | HG | Futures | 4.0768 | 4.2607 | 4.028 | 4.2307 | 32610.0 |
| 2009-10-21 | HO | Futures | 2.0052 | 2.0903 | 1.9864 | 2.0678 | 42526.0 |
| 2009-10-21 | HRC | Futures | 2763.8 | 2763.8 | 2763.8 | 2763.8 | 0.0 |
| 2009-10-21 | J1 | Futures | 0.0138539 | 0.0138815 | 0.0137597 | 0.0137974 | 89572.0 |
| 2009-10-21 | J7 | Futures | 0.013647 | 0.013698 | 0.013583 | 0.013617 | 76.0 |
| 2009-10-21 | JB | Futures | 117.05 | 117.16 | 116.93 | 116.93 | 886.0 |
| 2009-10-21 | KC | Futures | 374.44 | 381.17 | 369.56 | 380.91 | 9133.0 |
| 2009-10-21 | KE | Futures | 2447.5 | 2574.3 | 2434.7 | 2540.56 | 14987.0 |
| 2009-10-21 | L | Futures | 97.75 | 97.76 | 97.671 | 97.701 | 73067.0 |
> showing 50 of 89 rows — these rows as CSV