PREVIEW / futures_daily / 2009-11-30
file: by_date/futures_daily/2009/2009-11-30.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-11-30 | ES | Futures | 1052.79 | 1059.06 | 1046.04 | 1055.92 | 2016591.0 |
| 2009-11-30 | NQ | Futures | 1990.15 | 2003.69 | 1975.75 | 1995.23 | 309164.0 |
| 2009-11-30 | YM | Futures | 9359.2 | 9411.8 | 9306.5 | 9381.9 | 145722.0 |
| 2009-11-30 | CL | Futures | 185.07 | 189.82 | 182.84 | 188.07 | 358538.0 |
| 2009-11-30 | GC | Futures | 1626.9 | 1631.1 | 1603.5 | 1627.3 | 174369.0 |
| 2009-11-30 | ZN | Futures | 96.43133 | 96.61814 | 96.319244 | 96.580778 | 215023.0 |
| 2009-11-30 | A6 | Futures | 0.73548 | 0.74211 | 0.73403 | 0.73783 | 107730.0 |
| 2009-11-30 | AD | Futures | 0.92971 | 0.93621 | 0.92902 | 0.93276 | 87501.0 |
| 2009-11-30 | B | Futures | 71.88 | 73.58 | 70.94 | 72.85 | 44337.0 |
| 2009-11-30 | B6 | Futures | 1.7187 | 1.7265 | 1.7041 | 1.7087 | 119873.0 |
| 2009-11-30 | BFX | Futures | 2785.8 | 2785.8 | 2730.7 | 2774.8 | 313.0 |
| 2009-11-30 | BR | Futures | 0.2291 | 0.2291 | 0.22585 | 0.22585 | 362.0 |
| 2009-11-30 | C | Futures | 2244.0 | 2270.0 | 2220.0 | 2224.0 | 7572.0 |
| 2009-11-30 | CB | Futures | 80.193 | 80.193 | 79.452 | 79.946 | 26.0 |
| 2009-11-30 | CC | Futures | 2815.0 | 2852.0 | 2789.0 | 2800.0 | 5184.0 |
| 2009-11-30 | CT | Futures | 60.41 | 61.02 | 60.23 | 60.88 | 5794.0 |
| 2009-11-30 | DC | Futures | 25.39 | 25.55 | 25.25 | 25.4 | 52.0 |
| 2009-11-30 | DX | Futures | 76.572 | 76.633 | 76.097 | 76.505 | 18317.0 |
| 2009-11-30 | E1 | Futures | 1.31694 | 1.32288 | 1.31099 | 1.31284 | 59899.0 |
| 2009-11-30 | E6 | Futures | 1.7789 | 1.78767 | 1.77345 | 1.77665 | 274033.0 |
| 2009-11-30 | E7 | Futures | 1.76 | 1.7704 | 1.7563 | 1.7596 | 3140.0 |
| 2009-11-30 | ED | Futures | 94.2521 | 94.2734 | 94.2521 | 94.2592 | 166282.0 |
| 2009-11-30 | ER | Futures | 97.149 | 97.154 | 97.135 | 97.144 | 55331.0 |
| 2009-11-30 | EW | Futures | 662.4 | 667.4 | 655.2 | 663.2 | 43854.0 |
| 2009-11-30 | FBTP | Futures | 63.09 | 63.22 | 63.06 | 63.19 | 2740.0 |
| 2009-11-30 | FCE | Futures | 2464.3 | 2476.9 | 2432.1 | 2440.1 | 122689.0 |
| 2009-11-30 | FDAX | Futures | 6195.1 | 6227.2 | 6101.5 | 6132.5 | 175487.0 |
| 2009-11-30 | FESX | Futures | 1688.0 | 1699.3 | 1665.3 | 1672.5 | 1439675.0 |
| 2009-11-30 | FEU3 | Futures | 97.722 | 97.732 | 97.712 | 97.717 | 298.0 |
| 2009-11-30 | FGBL | Futures | 95.22 | 95.38 | 95.12 | 95.27 | 724903.0 |
| 2009-11-30 | FGBM | Futures | 100.15 | 100.2 | 100.06 | 100.18 | 473870.0 |
| 2009-11-30 | FGBS | Futures | 105.098 | 105.123 | 105.036 | 105.079 | 551937.0 |
| 2009-11-30 | FGBX | Futures | 88.35 | 89.26 | 88.35 | 89.2 | 3945.0 |
| 2009-11-30 | FTDX | Futures | 703.5 | 703.5 | 692.8 | 696.3 | 627.0 |
| 2009-11-30 | FTI | Futures | 252.36 | 254.24 | 249.05 | 249.58 | 39387.0 |
| 2009-11-30 | FTUK | Futures | 3484.9 | 3486.2 | 3436.4 | 3446.7 | 134010.0 |
| 2009-11-30 | G | Futures | 77.72 | 77.92 | 77.58 | 77.8 | 97354.0 |
| 2009-11-30 | GF | Futures | 251.372 | 252.729 | 250.626 | 252.118 | 957.0 |
| 2009-11-30 | GSCI | Futures | 978.3 | 996.86 | 972.11 | 990.48 | 284.0 |
| 2009-11-30 | HE | Futures | 90.39 | 90.59 | 88.784 | 89.487 | 12957.0 |
| 2009-11-30 | HG | Futures | 4.3173 | 4.3925 | 4.2849 | 4.3828 | 23943.0 |
| 2009-11-30 | HO | Futures | 1.9363 | 1.9768 | 1.9102 | 1.9581 | 7553.0 |
| 2009-11-30 | J1 | Futures | 0.0144943 | 0.0146248 | 0.0144566 | 0.0145545 | 106155.0 |
| 2009-11-30 | J7 | Futures | 0.014289 | 0.014432 | 0.014272 | 0.014365 | 63.0 |
| 2009-11-30 | JB | Futures | 118.02 | 118.09 | 117.84 | 118.01 | 2223.0 |
| 2009-11-30 | KC | Futures | 361.16 | 373.52 | 360.9 | 369.62 | 14322.0 |
| 2009-11-30 | KE | Futures | 2534.82 | 2615.1 | 2533.69 | 2600.4 | 10239.0 |
| 2009-11-30 | L | Futures | 97.691 | 97.73 | 97.691 | 97.73 | 37321.0 |
| 2009-11-30 | LBS | Futures | 839.0 | 874.9 | 837.7 | 874.9 | 939.0 |
| 2009-11-30 | LE | Futures | 140.103 | 140.348 | 139.694 | 140.267 | 11216.0 |
> showing 50 of 87 rows — these rows as CSV