PREVIEW / futures_daily / 2009-09-16
file: by_date/futures_daily/2009/2009-09-16.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-09-16 | ES | Futures | 1008.66 | 1026.26 | 1007.46 | 1025.78 | 2485619.0 |
| 2009-09-16 | NQ | Futures | 1912.82 | 1945.56 | 1911.13 | 1939.07 | 326862.0 |
| 2009-09-16 | YM | Futures | 8719.1 | 8843.5 | 8710.1 | 8829.0 | 146781.0 |
| 2009-09-16 | CL | Futures | 175.33 | 180.58 | 174.57 | 180.46 | 174206.0 |
| 2009-09-16 | GC | Futures | 1394.9 | 1414.6 | 1393.4 | 1410.4 | 124440.0 |
| 2009-09-16 | ZN | Futures | 93.417462 | 93.840898 | 92.981571 | 93.168382 | 1048780.0 |
| 2009-09-16 | A6 | Futures | 0.69281 | 0.70211 | 0.69233 | 0.70122 | 71212.0 |
| 2009-09-16 | AD | Futures | 0.91925 | 0.92645 | 0.91847 | 0.92478 | 61026.0 |
| 2009-09-16 | B | Futures | 65.67 | 67.71 | 65.15 | 67.66 | 137677.0 |
| 2009-09-16 | B6 | Futures | 1.7151 | 1.7203 | 1.7095 | 1.716 | 107745.0 |
| 2009-09-16 | BFX | Futures | 2825.1 | 2858.2 | 2822.1 | 2835.3 | 2100.0 |
| 2009-09-16 | BR | Futures | 0.21864 | 0.21872 | 0.21824 | 0.21864 | 39.0 |
| 2009-09-16 | BZ | Futures | 68.76 | 70.42 | 68.36 | 70.42 | 13.0 |
| 2009-09-16 | C | Futures | 2077.0 | 2090.0 | 1961.0 | 2060.0 | 18068.0 |
| 2009-09-16 | CB | Futures | 70.197 | 70.197 | 70.197 | 70.197 | 8.0 |
| 2009-09-16 | CC | Futures | 2747.0 | 2764.0 | 2562.0 | 2697.0 | 21864.0 |
| 2009-09-16 | CT | Futures | 54.42 | 55.23 | 54.42 | 54.95 | 141.0 |
| 2009-09-16 | DC | Futures | 23.45 | 23.53 | 23.23 | 23.35 | 137.0 |
| 2009-09-16 | DX | Futures | 78.323 | 78.425 | 77.975 | 78.078 | 5467.0 |
| 2009-09-16 | E1 | Futures | 1.27771 | 1.28365 | 1.2748 | 1.2818 | 41896.0 |
| 2009-09-16 | E6 | Futures | 1.7373 | 1.74655 | 1.73517 | 1.74477 | 241223.0 |
| 2009-09-16 | E7 | Futures | 1.7211 | 1.7298 | 1.7184 | 1.728 | 2471.0 |
| 2009-09-16 | ED | Futures | 94.0962 | 94.1292 | 94.082 | 94.0962 | 246221.0 |
| 2009-09-16 | ER | Futures | 97.169 | 97.179 | 97.135 | 97.154 | 163687.0 |
| 2009-09-16 | EW | Futures | 667.6 | 682.6 | 667.0 | 681.1 | 42226.0 |
| 2009-09-16 | FCE | Futures | 2485.4 | 2531.3 | 2483.4 | 2518.1 | 103787.0 |
| 2009-09-16 | FDAX | Futures | 6199.0 | 6285.7 | 6189.7 | 6247.3 | 183270.0 |
| 2009-09-16 | FESX | Futures | 1699.3 | 1722.0 | 1694.6 | 1710.1 | 947906.0 |
| 2009-09-16 | FEU3 | Futures | 97.741 | 97.746 | 97.717 | 97.727 | 3326.0 |
| 2009-09-16 | FGBL | Futures | 93.28 | 93.49 | 92.89 | 93.06 | 902225.0 |
| 2009-09-16 | FGBM | Futures | 98.88 | 99.03 | 98.62 | 98.75 | 482018.0 |
| 2009-09-16 | FGBS | Futures | 104.692 | 104.731 | 104.585 | 104.663 | 475012.0 |
| 2009-09-16 | FGBX | Futures | 86.2 | 86.59 | 85.82 | 86.09 | 1004.0 |
| 2009-09-16 | FTDX | Futures | 674.1 | 680.3 | 674.1 | 675.8 | 2901.0 |
| 2009-09-16 | FTI | Futures | 254.98 | 258.69 | 254.9 | 257.37 | 24628.0 |
| 2009-09-16 | FTUK | Futures | 3336.3 | 3398.3 | 3335.9 | 3371.4 | 166478.0 |
| 2009-09-16 | G | Futures | 76.67 | 76.84 | 76.08 | 76.26 | 111292.0 |
| 2009-09-16 | GF | Futures | 272.11 | 272.454 | 270.182 | 271.077 | 1008.0 |
| 2009-09-16 | GSCI | Futures | 926.56 | 950.17 | 925.56 | 948.57 | 811.0 |
| 2009-09-16 | HE | Futures | 80.495 | 81.169 | 78.546 | 78.621 | 14846.0 |
| 2009-09-16 | HG | Futures | 3.975 | 4.1158 | 3.9632 | 4.0921 | 21283.0 |
| 2009-09-16 | HO | Futures | 1.7752 | 1.8315 | 1.766 | 1.8292 | 13561.0 |
| 2009-09-16 | HRC | Futures | 2738.7 | 2738.7 | 2738.7 | 2738.7 | 0.0 |
| 2009-09-16 | J1 | Futures | 0.0138011 | 0.013943 | 0.0137509 | 0.01382 | 138487.0 |
| 2009-09-16 | J7 | Futures | 0.013632 | 0.013759 | 0.013574 | 0.01364 | 76.0 |
| 2009-09-16 | JB | Futures | 117.21 | 117.23 | 116.97 | 117.21 | 2910.0 |
| 2009-09-16 | KC | Futures | 355.3 | 360.05 | 352.0 | 354.25 | 9018.0 |
| 2009-09-16 | KE | Futures | 2238.11 | 2254.4 | 2182.28 | 2233.46 | 9357.0 |
| 2009-09-16 | L | Futures | 97.829 | 97.868 | 97.819 | 97.848 | 177396.0 |
| 2009-09-16 | LBS | Futures | 725.1 | 727.1 | 713.2 | 713.7 | 286.0 |
> showing 50 of 88 rows — these rows as CSV