PREVIEW / futures_daily / 2009-10-15
file: by_date/futures_daily/2009/2009-10-15.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-15 | ES | Futures | 1048.93 | 1054.48 | 1042.18 | 1051.1 | 1839117.0 |
| 2009-10-15 | NQ | Futures | 1972.65 | 1980.27 | 1960.8 | 1973.78 | 260884.0 |
| 2009-10-15 | YM | Futures | 9035.1 | 9085.0 | 8993.3 | 9046.0 | 115714.0 |
| 2009-10-15 | CL | Futures | 185.88 | 192.23 | 184.44 | 191.32 | 243455.0 |
| 2009-10-15 | GC | Futures | 1469.9 | 1474.8 | 1446.3 | 1452.4 | 151363.0 |
| 2009-10-15 | ZN | Futures | 94.214518 | 94.31415 | 93.81599 | 93.865806 | 1019743.0 |
| 2009-10-15 | A6 | Futures | 0.73597 | 0.7417 | 0.73516 | 0.73928 | 75896.0 |
| 2009-10-15 | AD | Futures | 0.96224 | 0.96609 | 0.95061 | 0.95416 | 77445.0 |
| 2009-10-15 | B | Futures | 69.12 | 71.41 | 68.61 | 71.11 | 162582.0 |
| 2009-10-15 | B6 | Futures | 1.6643 | 1.6955 | 1.6635 | 1.6921 | 165320.0 |
| 2009-10-15 | BFX | Futures | 2928.5 | 2935.4 | 2917.6 | 2928.8 | 985.0 |
| 2009-10-15 | BR | Futures | 0.23076 | 0.23178 | 0.23076 | 0.23176 | 189.0 |
| 2009-10-15 | BZ | Futures | 73.0 | 74.66 | 73.0 | 74.58 | 9.0 |
| 2009-10-15 | C | Futures | 2172.0 | 2220.0 | 2166.0 | 2211.0 | 4843.0 |
| 2009-10-15 | CB | Futures | 71.676 | 71.676 | 71.676 | 71.676 | 5.0 |
| 2009-10-15 | CC | Futures | 2773.0 | 2871.0 | 2773.0 | 2867.0 | 9063.0 |
| 2009-10-15 | CT | Futures | 57.86 | 59.97 | 57.06 | 58.37 | 18579.0 |
| 2009-10-15 | DC | Futures | 25.02 | 25.19 | 24.63 | 24.71 | 257.0 |
| 2009-10-15 | DX | Futures | 77.189 | 77.536 | 76.985 | 77.245 | 12868.0 |
| 2009-10-15 | E1 | Futures | 1.30267 | 1.30611 | 1.29594 | 1.30095 | 48466.0 |
| 2009-10-15 | E6 | Futures | 1.76942 | 1.77345 | 1.75875 | 1.76895 | 244378.0 |
| 2009-10-15 | E7 | Futures | 1.7522 | 1.7566 | 1.742 | 1.752 | 3397.0 |
| 2009-10-15 | ED | Futures | 94.1954 | 94.2049 | 94.1907 | 94.1954 | 132055.0 |
| 2009-10-15 | ER | Futures | 97.066 | 97.081 | 97.046 | 97.066 | 135076.0 |
| 2009-10-15 | EW | Futures | 686.9 | 692.1 | 682.3 | 690.4 | 29203.0 |
| 2009-10-15 | FBTP | Futures | 62.16 | 62.22 | 61.87 | 62.02 | 5198.0 |
| 2009-10-15 | FCE | Futures | 2553.4 | 2570.6 | 2542.9 | 2556.7 | 82492.0 |
| 2009-10-15 | FDAX | Futures | 6377.9 | 6389.8 | 6320.2 | 6350.1 | 135970.0 |
| 2009-10-15 | FESX | Futures | 1757.3 | 1760.9 | 1739.4 | 1747.7 | 1166284.0 |
| 2009-10-15 | FGBL | Futures | 93.78 | 93.82 | 93.34 | 93.58 | 1033792.0 |
| 2009-10-15 | FGBM | Futures | 99.05 | 99.07 | 98.71 | 98.73 | 627984.0 |
| 2009-10-15 | FGBS | Futures | 104.576 | 104.59 | 104.406 | 104.518 | 670525.0 |
| 2009-10-15 | FGBX | Futures | 87.07 | 87.07 | 86.28 | 86.64 | 1588.0 |
| 2009-10-15 | FTDX | Futures | 698.1 | 706.1 | 689.2 | 689.7 | 797.0 |
| 2009-10-15 | FTI | Futures | 266.63 | 266.79 | 264.09 | 265.32 | 26277.0 |
| 2009-10-15 | FTUK | Futures | 3478.9 | 3478.9 | 3443.4 | 3452.4 | 118290.0 |
| 2009-10-15 | G | Futures | 77.43 | 77.47 | 77.02 | 77.19 | 102237.0 |
| 2009-10-15 | GF | Futures | 259.994 | 261.714 | 259.925 | 260.269 | 1518.0 |
| 2009-10-15 | GSCI | Futures | 969.1 | 994.68 | 966.94 | 994.19 | 941.0 |
| 2009-10-15 | HE | Futures | 83.156 | 83.423 | 81.975 | 83.042 | 11871.0 |
| 2009-10-15 | HG | Futures | 3.9715 | 4.0154 | 3.8698 | 3.9841 | 20606.0 |
| 2009-10-15 | HO | Futures | 1.9183 | 1.9899 | 1.9088 | 1.9838 | 28310.0 |
| 2009-10-15 | HRC | Futures | 2763.8 | 2763.8 | 2763.8 | 2763.8 | 0.0 |
| 2009-10-15 | J1 | Futures | 0.0140585 | 0.0140723 | 0.0138363 | 0.0138614 | 138396.0 |
| 2009-10-15 | J7 | Futures | 0.013866 | 0.013883 | 0.013658 | 0.013681 | 140.0 |
| 2009-10-15 | JB | Futures | 117.4 | 117.43 | 117.21 | 117.26 | 1926.0 |
| 2009-10-15 | KC | Futures | 367.58 | 368.11 | 359.79 | 363.62 | 8473.0 |
| 2009-10-15 | KE | Futures | 2432.38 | 2456.81 | 2377.7 | 2410.28 | 12824.0 |
| 2009-10-15 | L | Futures | 97.779 | 97.789 | 97.77 | 97.789 | 20816.0 |
| 2009-10-15 | LBS | Futures | 733.2 | 735.3 | 721.4 | 735.3 | 407.0 |
> showing 50 of 88 rows — these rows as CSV