PREVIEW / futures_daily / 2009-07-22
file: by_date/futures_daily/2009/2009-07-22.parquet size: 8 KB rows: 86
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-07-22 | ES | Futures | 913.15 | 917.94 | 905.23 | 910.99 | 2049033.0 |
| 2009-07-22 | NQ | Futures | 1748.09 | 1769.48 | 1739.64 | 1752.87 | 327293.0 |
| 2009-07-22 | YM | Futures | 8006.6 | 8036.3 | 7948.8 | 7969.6 | 139473.0 |
| 2009-07-22 | CL | Futures | 167.43 | 169.33 | 164.16 | 168.38 | 319989.0 |
| 2009-07-22 | GC | Futures | 1313.7 | 1322.2 | 1307.8 | 1319.8 | 89854.0 |
| 2009-07-22 | ZN | Futures | 92.751165 | 92.923542 | 92.30791 | 92.381786 | 713122.0 |
| 2009-07-22 | A6 | Futures | 0.65423 | 0.65753 | 0.64821 | 0.65479 | 69967.0 |
| 2009-07-22 | AD | Futures | 0.89457 | 0.90218 | 0.89082 | 0.89931 | 60448.0 |
| 2009-07-22 | B | Futures | 63.18 | 64.24 | 62.35 | 63.98 | 112689.0 |
| 2009-07-22 | B6 | Futures | 1.7133 | 1.7191 | 1.6985 | 1.7146 | 97930.0 |
| 2009-07-22 | BFX | Futures | 2405.3 | 2429.5 | 2395.0 | 2424.3 | 243.0 |
| 2009-07-22 | BR | Futures | 0.20299 | 0.20299 | 0.20299 | 0.20299 | 5.0 |
| 2009-07-22 | BZ | Futures | 67.51 | 68.27 | 66.86 | 68.27 | 15.0 |
| 2009-07-22 | C | Futures | 1925.0 | 1925.0 | 1837.0 | 1845.0 | 7082.0 |
| 2009-07-22 | CB | Futures | 75.884 | 75.884 | 75.458 | 75.6 | 10.0 |
| 2009-07-22 | CC | Futures | 2541.0 | 2541.0 | 2427.0 | 2448.0 | 9556.0 |
| 2009-07-22 | CT | Futures | 52.81 | 52.94 | 51.56 | 52.22 | 596.0 |
| 2009-07-22 | DC | Futures | 21.09 | 21.17 | 20.72 | 20.92 | 445.0 |
| 2009-07-22 | DX | Futures | 80.911 | 81.085 | 80.547 | 80.716 | 6991.0 |
| 2009-07-22 | E1 | Futures | 1.24198 | 1.24582 | 1.23616 | 1.24357 | 28905.0 |
| 2009-07-22 | E6 | Futures | 1.68758 | 1.69257 | 1.68046 | 1.68901 | 169965.0 |
| 2009-07-22 | E7 | Futures | 1.6705 | 1.675 | 1.6632 | 1.6717 | 1812.0 |
| 2009-07-22 | ED | Futures | 93.9188 | 93.933 | 93.9141 | 93.9236 | 78890.0 |
| 2009-07-22 | ER | Futures | 97.081 | 97.09 | 97.061 | 97.066 | 68581.0 |
| 2009-07-22 | EW | Futures | 577.7 | 582.8 | 573.1 | 577.2 | 27789.0 |
| 2009-07-22 | FCE | Futures | 2170.0 | 2175.0 | 2141.2 | 2164.8 | 100053.0 |
| 2009-07-22 | FDAX | Futures | 5614.2 | 5641.7 | 5541.3 | 5613.1 | 118774.0 |
| 2009-07-22 | FESX | Futures | 1509.0 | 1514.3 | 1487.5 | 1504.2 | 864810.0 |
| 2009-07-22 | FEU3 | Futures | 97.667 | 97.667 | 97.643 | 97.643 | 516.0 |
| 2009-07-22 | FGBL | Futures | 92.2 | 92.5 | 92.0 | 92.21 | 686263.0 |
| 2009-07-22 | FGBM | Futures | 98.15 | 98.36 | 98.07 | 98.17 | 287058.0 |
| 2009-07-22 | FGBS | Futures | 104.157 | 104.229 | 104.133 | 104.167 | 341989.0 |
| 2009-07-22 | FGBX | Futures | 83.78 | 84.03 | 83.2 | 83.45 | 2166.0 |
| 2009-07-22 | FTDX | Futures | 596.0 | 598.7 | 588.0 | 592.5 | 436.0 |
| 2009-07-22 | FTI | Futures | 221.97 | 222.34 | 218.93 | 221.68 | 23839.0 |
| 2009-07-22 | FTUK | Futures | 2955.6 | 2968.9 | 2930.7 | 2958.6 | 80010.0 |
| 2009-07-22 | G | Futures | 75.23 | 75.63 | 74.54 | 74.95 | 116592.0 |
| 2009-07-22 | GF | Futures | 284.933 | 285.277 | 283.348 | 284.244 | 1491.0 |
| 2009-07-22 | GSCI | Futures | 906.77 | 915.12 | 894.44 | 911.99 | 324.0 |
| 2009-07-22 | HE | Futures | 90.109 | 91.045 | 88.382 | 89.389 | 9676.0 |
| 2009-07-22 | HG | Futures | 3.4485 | 3.5637 | 3.412 | 3.5461 | 21964.0 |
| 2009-07-22 | HO | Futures | 1.7404 | 1.7726 | 1.7213 | 1.7614 | 37351.0 |
| 2009-07-22 | HRC | Futures | 2409.0 | 2409.0 | 2409.0 | 2409.0 | 0.0 |
| 2009-07-22 | J1 | Futures | 0.0134452 | 0.0135296 | 0.013415 | 0.0134591 | 89125.0 |
| 2009-07-22 | J7 | Futures | 0.013258 | 0.013338 | 0.013233 | 0.013274 | 66.0 |
| 2009-07-22 | JB | Futures | 116.36 | 116.58 | 116.23 | 116.36 | 3230.0 |
| 2009-07-22 | KC | Futures | 332.53 | 334.56 | 315.7 | 325.88 | 10946.0 |
| 2009-07-22 | KE | Futures | 2705.14 | 2705.14 | 2623.61 | 2660.78 | 11331.0 |
| 2009-07-22 | L | Futures | 97.367 | 97.367 | 97.337 | 97.347 | 31695.0 |
| 2009-07-22 | LBS | Futures | 747.3 | 762.4 | 730.3 | 736.8 | 620.0 |
> showing 50 of 86 rows — these rows as CSV