PREVIEW / futures_daily / 2010-01-26
file: by_date/futures_daily/2010/2010-01-26.parquet size: 9 KB rows: 91
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 |
|---|---|---|---|---|---|---|---|
| 2010-01-26 | ES | Futures | 1060.46 | 1066.28 | 1047.86 | 1053.92 | 2449263.0 |
| 2010-01-26 | NQ | Futures | 2046.91 | 2062.75 | 2017.51 | 2031.93 | 419117.0 |
| 2010-01-26 | YM | Futures | 9270.5 | 9349.9 | 9183.7 | 9260.4 | 164295.0 |
| 2010-01-26 | CL | Futures | 177.81 | 178.07 | 174.36 | 176.46 | 256207.0 |
| 2010-01-26 | GC | Futures | 1508.1 | 1515.0 | 1490.7 | 1508.6 | 104594.0 |
| 2010-01-26 | ZN | Futures | 94.894872 | 95.285282 | 94.831902 | 94.970435 | 765667.0 |
| 2010-01-26 | A6 | Futures | 0.73079 | 0.73453 | 0.72266 | 0.72811 | 111066.0 |
| 2010-01-26 | AD | Futures | 0.93335 | 0.93612 | 0.92328 | 0.93088 | 76331.0 |
| 2010-01-26 | B | Futures | 66.62 | 66.7 | 65.53 | 66.3 | 67292.0 |
| 2010-01-26 | B6 | Futures | 1.6866 | 1.6891 | 1.671 | 1.6762 | 136692.0 |
| 2010-01-26 | BFX | Futures | 2775.6 | 2818.9 | 2775.6 | 2818.9 | 75.0 |
| 2010-01-26 | BR | Futures | 0.2176 | 0.21929 | 0.2176 | 0.21929 | 291.0 |
| 2010-01-26 | C | Futures | 2357.0 | 2371.0 | 2325.0 | 2342.0 | 7184.0 |
| 2010-01-26 | CB | Futures | 71.803 | 71.803 | 71.557 | 71.557 | 5.0 |
| 2010-01-26 | CC | Futures | 2917.0 | 2930.0 | 2845.0 | 2889.0 | 9945.0 |
| 2010-01-26 | CT | Futures | 57.07 | 57.43 | 56.56 | 56.92 | 12312.0 |
| 2010-01-26 | DC | Futures | 23.35 | 23.4 | 23.04 | 23.04 | 217.0 |
| 2010-01-26 | DX | Futures | 79.632 | 80.171 | 79.561 | 79.942 | 19076.0 |
| 2010-01-26 | E1 | Futures | 1.26849 | 1.27086 | 1.25702 | 1.26098 | 56858.0 |
| 2010-01-26 | E6 | Futures | 1.67492 | 1.67835 | 1.66214 | 1.66746 | 313123.0 |
| 2010-01-26 | E7 | Futures | 1.6633 | 1.6667 | 1.6506 | 1.6559 | 3369.0 |
| 2010-01-26 | EBM | Futures | 214.62 | 215.04 | 213.77 | 214.62 | 4310.0 |
| 2010-01-26 | ED | Futures | 94.3725 | 94.3773 | 94.3678 | 94.3725 | 94062.0 |
| 2010-01-26 | ER | Futures | 97.321 | 97.321 | 97.306 | 97.311 | 111134.0 |
| 2010-01-26 | EW | Futures | 703.8 | 705.6 | 695.1 | 698.4 | 31865.0 |
| 2010-01-26 | FBTP | Futures | 63.53 | 63.6 | 63.44 | 63.56 | 3737.0 |
| 2010-01-26 | FCE | Futures | 2432.2 | 2485.6 | 2427.7 | 2479.4 | 121028.0 |
| 2010-01-26 | FDAX | Futures | 6070.2 | 6214.4 | 6062.0 | 6199.7 | 171173.0 |
| 2010-01-26 | FESX | Futures | 1650.3 | 1697.6 | 1647.3 | 1691.0 | 1625687.0 |
| 2010-01-26 | FEU3 | Futures | 97.874 | 97.879 | 97.874 | 97.874 | 244.0 |
| 2010-01-26 | FGBL | Futures | 95.18 | 95.23 | 94.96 | 95.06 | 733356.0 |
| 2010-01-26 | FGBM | Futures | 100.78 | 100.83 | 100.63 | 100.71 | 490500.0 |
| 2010-01-26 | FGBS | Futures | 105.732 | 105.732 | 105.659 | 105.688 | 503983.0 |
| 2010-01-26 | FGBX | Futures | 89.0 | 89.0 | 88.55 | 88.85 | 2773.0 |
| 2010-01-26 | FTDX | Futures | 705.8 | 716.4 | 705.8 | 712.8 | 482.0 |
| 2010-01-26 | FTI | Futures | 262.54 | 267.82 | 262.21 | 266.97 | 32646.0 |
| 2010-01-26 | FTUK | Futures | 3478.8 | 3516.6 | 3464.4 | 3505.2 | 106553.0 |
| 2010-01-26 | G | Futures | 75.99 | 76.37 | 75.85 | 76.11 | 109314.0 |
| 2010-01-26 | GF | Futures | 267.013 | 267.823 | 266.135 | 267.351 | 3296.0 |
| 2010-01-26 | GSCI | Futures | 937.2 | 938.13 | 925.05 | 934.58 | 578.0 |
| 2010-01-26 | HE | Futures | 94.103 | 94.203 | 91.694 | 91.895 | 16625.0 |
| 2010-01-26 | HG | Futures | 4.667 | 4.6856 | 4.5608 | 4.607 | 27220.0 |
| 2010-01-26 | HO | Futures | 1.8388 | 1.8389 | 1.8082 | 1.8261 | 45834.0 |
| 2010-01-26 | HRC | Futures | 2729.2 | 2729.2 | 2729.2 | 2729.2 | 0.0 |
| 2010-01-26 | J1 | Futures | 0.0139472 | 0.0140894 | 0.0138982 | 0.0140315 | 156452.0 |
| 2010-01-26 | J7 | Futures | 0.013745 | 0.013912 | 0.013728 | 0.013856 | 113.0 |
| 2010-01-26 | JB | Futures | 117.43 | 117.7 | 117.36 | 117.65 | 2010.0 |
| 2010-01-26 | KC | Futures | 361.94 | 362.33 | 356.6 | 359.86 | 10918.0 |
| 2010-01-26 | KE | Futures | 2262.35 | 2277.04 | 2246.52 | 2258.95 | 9427.0 |
| 2010-01-26 | KRW | Futures | 0.0008427 | 0.000844 | 0.0008427 | 0.000844 | 20.0 |
> showing 50 of 91 rows — these rows as CSV