PREVIEW / futures_daily / 2009-12-14
file: by_date/futures_daily/2009/2009-12-14.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-12-14 | ES | Futures | 1068.7 | 1078.88 | 1066.04 | 1074.52 | 1720435.0 |
| 2009-12-14 | NQ | Futures | 2025.14 | 2046.07 | 2020.33 | 2044.65 | 224192.0 |
| 2009-12-14 | YM | Futures | 9518.9 | 9600.2 | 9495.2 | 9533.5 | 91943.0 |
| 2009-12-14 | CL | Futures | 170.03 | 172.03 | 167.97 | 170.41 | 166311.0 |
| 2009-12-14 | GC | Futures | 1534.2 | 1553.8 | 1530.2 | 1546.8 | 120588.0 |
| 2009-12-14 | ZN | Futures | 94.781527 | 95.033404 | 94.680776 | 94.756339 | 502059.0 |
| 2009-12-14 | A6 | Futures | 0.73306 | 0.73867 | 0.72867 | 0.73786 | 64798.0 |
| 2009-12-14 | AD | Futures | 0.93029 | 0.93434 | 0.92585 | 0.93167 | 68429.0 |
| 2009-12-14 | B | Futures | 66.5 | 67.22 | 66.1 | 66.79 | 81448.0 |
| 2009-12-14 | B6 | Futures | 1.684 | 1.6946 | 1.6804 | 1.6923 | 71182.0 |
| 2009-12-14 | BFX | Futures | 2832.5 | 2834.8 | 2817.9 | 2830.4 | 464.0 |
| 2009-12-14 | BR | Futures | 0.22752 | 0.22752 | 0.22752 | 0.22752 | 10.0 |
| 2009-12-14 | C | Futures | 2300.0 | 2310.0 | 2286.0 | 2301.0 | 5695.0 |
| 2009-12-14 | CC | Futures | 2921.0 | 2940.0 | 2896.0 | 2931.0 | 3847.0 |
| 2009-12-14 | CT | Futures | 60.33 | 62.07 | 60.18 | 61.77 | 14440.0 |
| 2009-12-14 | DC | Futures | 25.45 | 25.65 | 25.3 | 25.5 | 136.0 |
| 2009-12-14 | DX | Futures | 78.234 | 78.335 | 77.939 | 78.035 | 13553.0 |
| 2009-12-14 | E1 | Futures | 1.27416 | 1.28168 | 1.27416 | 1.27851 | 39096.0 |
| 2009-12-14 | E6 | Futures | 1.72973 | 1.73814 | 1.72831 | 1.73352 | 194822.0 |
| 2009-12-14 | E7 | Futures | 1.7181 | 1.7261 | 1.7159 | 1.7215 | 2462.0 |
| 2009-12-14 | EBM | Futures | 221.81 | 224.35 | 220.55 | 223.93 | 3471.0 |
| 2009-12-14 | ED | Futures | 94.2637 | 94.2779 | 94.2448 | 94.2684 | 191556.0 |
| 2009-12-14 | ER | Futures | 97.174 | 97.184 | 97.159 | 97.174 | 141909.0 |
| 2009-12-14 | EW | Futures | 684.0 | 693.8 | 681.8 | 691.1 | 39908.0 |
| 2009-12-14 | FBTP | Futures | 63.26 | 63.39 | 63.22 | 63.33 | 1721.0 |
| 2009-12-14 | FCE | Futures | 2520.1 | 2520.1 | 2488.4 | 2499.9 | 34351.0 |
| 2009-12-14 | FDAX | Futures | 6336.5 | 6355.0 | 6287.0 | 6307.7 | 115900.0 |
| 2009-12-14 | FESX | Futures | 1728.7 | 1734.7 | 1715.5 | 1722.7 | 523455.0 |
| 2009-12-14 | FEU3 | Futures | 97.731 | 97.741 | 97.727 | 97.736 | 1450.0 |
| 2009-12-14 | FGBL | Futures | 94.62 | 94.94 | 94.54 | 94.82 | 465806.0 |
| 2009-12-14 | FGBM | Futures | 100.11 | 100.28 | 100.02 | 100.24 | 270902.0 |
| 2009-12-14 | FGBS | Futures | 105.26 | 105.323 | 105.221 | 105.313 | 288791.0 |
| 2009-12-14 | FGBX | Futures | 87.7 | 88.33 | 87.62 | 88.28 | 3091.0 |
| 2009-12-14 | FTDX | Futures | 719.5 | 720.3 | 717.7 | 717.7 | 5022.0 |
| 2009-12-14 | FTI | Futures | 264.56 | 264.68 | 262.11 | 263.01 | 19541.0 |
| 2009-12-14 | FTUK | Futures | 3539.7 | 3544.4 | 3521.0 | 3529.0 | 221412.0 |
| 2009-12-14 | G | Futures | 75.76 | 76.1 | 75.69 | 76.01 | 55571.0 |
| 2009-12-14 | GF | Futures | 248.931 | 249.677 | 248.457 | 249.27 | 1334.0 |
| 2009-12-14 | GSCI | Futures | 924.22 | 936.35 | 924.22 | 929.43 | 3005.0 |
| 2009-12-14 | HE | Futures | 87.647 | 88.951 | 87.58 | 88.148 | 11401.0 |
| 2009-12-14 | HG | Futures | 4.3318 | 4.3649 | 4.2911 | 4.3483 | 11791.0 |
| 2009-12-14 | HO | Futures | 1.8099 | 1.8269 | 1.8032 | 1.8127 | 6588.0 |
| 2009-12-14 | HRC | Futures | 2561.7 | 2561.7 | 2561.7 | 2561.7 | 0.0 |
| 2009-12-14 | J1 | Futures | 0.0141058 | 0.0142581 | 0.0140982 | 0.0142052 | 71251.0 |
| 2009-12-14 | J7 | Futures | 0.013966 | 0.014073 | 0.013966 | 0.014027 | 79.0 |
| 2009-12-14 | JB | Futures | 117.75 | 117.9 | 117.61 | 117.72 | 1872.0 |
| 2009-12-14 | KC | Futures | 372.74 | 381.59 | 371.83 | 379.77 | 10889.0 |
| 2009-12-14 | KE | Futures | 2388.97 | 2438.72 | 2365.23 | 2414.98 | 5525.0 |
| 2009-12-14 | KRW | Futures | 0.0008462 | 0.0008463 | 0.0008462 | 0.0008463 | 30.0 |
| 2009-12-14 | L | Futures | 97.71 | 97.72 | 97.691 | 97.691 | 33568.0 |
> showing 50 of 89 rows — these rows as CSV