PREVIEW / futures_daily / 2009-03-04
file: by_date/futures_daily/2009/2009-03-04.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-03-04 | ES | Futures | 652.03 | 683.43 | 643.53 | 669.03 | 3168491.0 |
| 2009-03-04 | NQ | Futures | 1199.6 | 1257.74 | 1187.3 | 1230.9 | 426573.0 |
| 2009-03-04 | YM | Futures | 5941.6 | 6207.8 | 5880.1 | 6081.4 | 234313.0 |
| 2009-03-04 | CL | Futures | 116.49 | 128.83 | 115.54 | 127.76 | 319761.0 |
| 2009-03-04 | GC | Futures | 1271.8 | 1281.8 | 1249.5 | 1258.2 | 102120.0 |
| 2009-03-04 | ZN | Futures | 94.176444 | 94.176444 | 93.136547 | 93.291934 | 76068.0 |
| 2009-03-04 | A6 | Futures | 0.50481 | 0.51726 | 0.4983 | 0.51702 | 44141.0 |
| 2009-03-04 | AD | Futures | 0.75841 | 0.77285 | 0.75733 | 0.77128 | 45433.0 |
| 2009-03-04 | B | Futures | 43.08 | 46.37 | 43.05 | 46.0 | 78183.0 |
| 2009-03-04 | B6 | Futures | 1.4582 | 1.4753 | 1.4529 | 1.4709 | 62336.0 |
| 2009-03-04 | BFX | Futures | 1717.2 | 1725.4 | 1717.2 | 1725.4 | 20.0 |
| 2009-03-04 | BZ | Futures | 47.94 | 48.14 | 46.97 | 47.98 | 18.0 |
| 2009-03-04 | C | Futures | 1799.0 | 1853.0 | 1785.0 | 1837.0 | 1663.0 |
| 2009-03-04 | CB | Futures | 76.436 | 76.436 | 76.436 | 76.436 | 2.0 |
| 2009-03-04 | CC | Futures | 2008.0 | 2076.0 | 1998.0 | 2057.0 | 6605.0 |
| 2009-03-04 | CT | Futures | 39.5 | 41.27 | 39.48 | 39.58 | 6061.0 |
| 2009-03-04 | DC | Futures | 27.07 | 27.43 | 27.07 | 27.19 | 45.0 |
| 2009-03-04 | DX | Futures | 93.023 | 93.023 | 91.789 | 91.976 | 5320.0 |
| 2009-03-04 | E1 | Futures | 1.12899 | 1.13869 | 1.12194 | 1.1351 | 24400.0 |
| 2009-03-04 | E6 | Futures | 1.48473 | 1.49953 | 1.47467 | 1.49669 | 181795.0 |
| 2009-03-04 | E7 | Futures | 1.4681 | 1.482 | 1.4579 | 1.4796 | 1813.0 |
| 2009-03-04 | EBM | Futures | 208.23 | 210.91 | 208.23 | 210.53 | 982.0 |
| 2009-03-04 | ED | Futures | 92.9824 | 92.9871 | 92.9306 | 92.9612 | 156016.0 |
| 2009-03-04 | ER | Futures | 96.483 | 96.508 | 96.474 | 96.493 | 96857.0 |
| 2009-03-04 | EW | Futures | 405.2 | 428.6 | 400.7 | 418.8 | 37513.0 |
| 2009-03-04 | FCE | Futures | 1605.6 | 1685.7 | 1603.1 | 1669.5 | 173812.0 |
| 2009-03-04 | FDAX | Futures | 4072.5 | 4296.3 | 4067.0 | 4242.2 | 198565.0 |
| 2009-03-04 | FESX | Futures | 1080.7 | 1128.4 | 1080.1 | 1115.2 | 1646270.0 |
| 2009-03-04 | FEU3 | Futures | 97.047 | 97.071 | 97.047 | 97.062 | 201.0 |
| 2009-03-04 | FGBL | Futures | 93.5 | 93.5 | 92.8 | 93.02 | 1148929.0 |
| 2009-03-04 | FGBM | Futures | 98.43 | 98.51 | 98.2 | 98.36 | 673094.0 |
| 2009-03-04 | FGBS | Futures | 104.04 | 104.122 | 104.002 | 104.083 | 781725.0 |
| 2009-03-04 | FGBX | Futures | 84.55 | 84.55 | 83.59 | 83.76 | 14427.0 |
| 2009-03-04 | FTDX | Futures | 377.7 | 398.2 | 377.7 | 392.0 | 288.0 |
| 2009-03-04 | FTI | Futures | 166.45 | 172.92 | 166.12 | 172.39 | 39771.0 |
| 2009-03-04 | FTUK | Futures | 2322.7 | 2412.8 | 2317.4 | 2385.6 | 149887.0 |
| 2009-03-04 | G | Futures | 75.75 | 75.84 | 75.23 | 75.51 | 86941.0 |
| 2009-03-04 | GF | Futures | 257.26 | 263.572 | 257.26 | 260.977 | 208.0 |
| 2009-03-04 | GSCI | Futures | 712.23 | 740.45 | 712.23 | 737.17 | 62.0 |
| 2009-03-04 | HE | Futures | 117.919 | 121.398 | 117.484 | 120.48 | 8377.0 |
| 2009-03-04 | HG | Futures | 2.264 | 2.4472 | 2.2436 | 2.3866 | 20634.0 |
| 2009-03-04 | HO | Futures | 1.3082 | 1.3799 | 1.3075 | 1.3643 | 13271.0 |
| 2009-03-04 | HRC | Futures | 2953.0 | 2953.0 | 2953.0 | 2953.0 | 0.0 |
| 2009-03-04 | J1 | Futures | 0.012865 | 0.0128662 | 0.0126982 | 0.0127349 | 67975.0 |
| 2009-03-04 | J7 | Futures | 0.012679 | 0.012704 | 0.012547 | 0.012582 | 233.0 |
| 2009-03-04 | JB | Futures | 116.46 | 116.52 | 116.12 | 116.12 | 599.0 |
| 2009-03-04 | KC | Futures | 300.28 | 308.44 | 300.28 | 305.77 | 8987.0 |
| 2009-03-04 | KE | Futures | 2689.33 | 2795.33 | 2689.33 | 2795.33 | 6867.0 |
| 2009-03-04 | L | Futures | 96.571 | 96.581 | 96.541 | 96.581 | 32206.0 |
| 2009-03-04 | LBS | Futures | 931.1 | 939.5 | 880.7 | 885.1 | 111.0 |
> showing 50 of 86 rows — these rows as CSV