PREVIEW / futures_daily / 2009-10-26
file: by_date/futures_daily/2009/2009-10-26.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-26 | ES | Futures | 1038.32 | 1049.89 | 1023.61 | 1028.68 | 2339507.0 |
| 2009-10-26 | NQ | Futures | 1976.6 | 2006.23 | 1961.36 | 1973.21 | 393166.0 |
| 2009-10-26 | YM | Futures | 9010.6 | 9101.4 | 8890.7 | 8934.3 | 194145.0 |
| 2009-10-26 | CL | Futures | 195.17 | 199.9 | 191.05 | 192.79 | 363907.0 |
| 2009-10-26 | GC | Futures | 1459.2 | 1466.5 | 1435.1 | 1441.6 | 162321.0 |
| 2009-10-26 | ZN | Futures | 93.591818 | 93.703904 | 93.155928 | 93.31783 | 963553.0 |
| 2009-10-26 | A6 | Futures | 0.74065 | 0.74623 | 0.73387 | 0.73508 | 96386.0 |
| 2009-10-26 | AD | Futures | 0.9371 | 0.93897 | 0.92162 | 0.92359 | 81270.0 |
| 2009-10-26 | B | Futures | 73.62 | 75.12 | 71.91 | 72.5 | 40975.0 |
| 2009-10-26 | B6 | Futures | 1.6953 | 1.7055 | 1.6903 | 1.6959 | 131659.0 |
| 2009-10-26 | BFX | Futures | 2902.4 | 2902.4 | 2814.6 | 2825.0 | 298.0 |
| 2009-10-26 | BR | Futures | 0.22559 | 0.22559 | 0.22559 | 0.22559 | 55.0 |
| 2009-10-26 | BZ | Futures | 77.22 | 77.55 | 77.19 | 77.19 | 2.0 |
| 2009-10-26 | C | Futures | 2265.0 | 2278.0 | 2211.0 | 2261.0 | 6976.0 |
| 2009-10-26 | CC | Futures | 2957.0 | 2988.0 | 2881.0 | 2943.0 | 10430.0 |
| 2009-10-26 | CT | Futures | 58.41 | 59.19 | 57.53 | 58.17 | 10209.0 |
| 2009-10-26 | DC | Futures | 25.14 | 25.36 | 25.1 | 25.19 | 153.0 |
| 2009-10-26 | DX | Futures | 77.184 | 77.858 | 76.919 | 77.792 | 18504.0 |
| 2009-10-26 | E1 | Futures | 1.30994 | 1.31456 | 1.29488 | 1.2966 | 65356.0 |
| 2009-10-26 | E6 | Futures | 1.77772 | 1.78506 | 1.75911 | 1.76077 | 261141.0 |
| 2009-10-26 | E7 | Futures | 1.7607 | 1.7677 | 1.7421 | 1.7439 | 6226.0 |
| 2009-10-26 | ED | Futures | 94.2001 | 94.2096 | 94.1954 | 94.2001 | 103652.0 |
| 2009-10-26 | ER | Futures | 97.1 | 97.12 | 97.1 | 97.12 | 81534.0 |
| 2009-10-26 | EW | Futures | 679.2 | 688.4 | 669.2 | 673.4 | 51191.0 |
| 2009-10-26 | FBTP | Futures | 61.96 | 62.14 | 61.96 | 62.1 | 3563.0 |
| 2009-10-26 | FCE | Futures | 2516.1 | 2528.3 | 2456.0 | 2466.2 | 139556.0 |
| 2009-10-26 | FDAX | Futures | 6283.2 | 6314.7 | 6120.5 | 6141.2 | 196952.0 |
| 2009-10-26 | FESX | Futures | 1725.6 | 1730.4 | 1681.4 | 1688.0 | 1283703.0 |
| 2009-10-26 | FEU3 | Futures | 97.682 | 97.692 | 97.682 | 97.692 | 1389.0 |
| 2009-10-26 | FGBL | Futures | 93.01 | 93.2 | 92.87 | 93.11 | 719980.0 |
| 2009-10-26 | FGBM | Futures | 98.7 | 98.8 | 98.6 | 98.75 | 392598.0 |
| 2009-10-26 | FGBS | Futures | 104.493 | 104.581 | 104.469 | 104.576 | 413646.0 |
| 2009-10-26 | FGBX | Futures | 85.38 | 85.73 | 85.25 | 85.59 | 1722.0 |
| 2009-10-26 | FTDX | Futures | 679.4 | 684.8 | 668.3 | 671.4 | 469.0 |
| 2009-10-26 | FTI | Futures | 261.43 | 262.62 | 254.4 | 254.97 | 41869.0 |
| 2009-10-26 | FTUK | Futures | 3467.6 | 3486.5 | 3406.6 | 3426.8 | 104138.0 |
| 2009-10-26 | G | Futures | 76.34 | 76.55 | 76.26 | 76.45 | 59629.0 |
| 2009-10-26 | GF | Futures | 263.295 | 264.396 | 262.057 | 263.777 | 1621.0 |
| 2009-10-26 | GSCI | Futures | 1020.65 | 1033.44 | 996.45 | 1000.58 | 693.0 |
| 2009-10-26 | HE | Futures | 81.06 | 82.051 | 80.527 | 81.479 | 8148.0 |
| 2009-10-26 | HG | Futures | 4.2279 | 4.2767 | 4.1471 | 4.1959 | 24369.0 |
| 2009-10-26 | HO | Futures | 2.0309 | 2.0742 | 1.9856 | 1.9986 | 49822.0 |
| 2009-10-26 | HRC | Futures | 2713.1 | 2713.1 | 2713.1 | 2713.1 | 0.0 |
| 2009-10-26 | J1 | Futures | 0.0136341 | 0.0137157 | 0.013609 | 0.0136165 | 82731.0 |
| 2009-10-26 | J7 | Futures | 0.013456 | 0.013534 | 0.013435 | 0.013439 | 50.0 |
| 2009-10-26 | JB | Futures | 116.58 | 116.58 | 116.4 | 116.45 | 1538.0 |
| 2009-10-26 | KC | Futures | 360.98 | 367.45 | 354.25 | 360.32 | 12417.0 |
| 2009-10-26 | KE | Futures | 2554.52 | 2619.66 | 2470.77 | 2470.77 | 13945.0 |
| 2009-10-26 | L | Futures | 97.779 | 97.799 | 97.76 | 97.789 | 34276.0 |
| 2009-10-26 | LBS | Futures | 716.9 | 721.8 | 715.3 | 715.7 | 170.0 |
> showing 50 of 88 rows — these rows as CSV