PREVIEW / futures_daily / 2010-01-20
file: by_date/futures_daily/2010/2010-01-20.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-20 | ES | Futures | 1109.9 | 1111.35 | 1090.76 | 1099.24 | 2391710.0 |
| 2010-01-20 | NQ | Futures | 2136.83 | 2140.23 | 2087.35 | 2111.67 | 403528.0 |
| 2010-01-20 | YM | Futures | 9741.8 | 9751.9 | 9560.9 | 9643.2 | 157058.0 |
| 2010-01-20 | CL | Futures | 187.0 | 187.45 | 182.18 | 183.62 | 303758.0 |
| 2010-01-20 | GC | Futures | 1567.0 | 1571.5 | 1523.4 | 1531.4 | 232575.0 |
| 2010-01-20 | ZN | Futures | 94.40371 | 94.794121 | 94.391117 | 94.6304 | 821765.0 |
| 2010-01-20 | A6 | Futures | 0.74615 | 0.74647 | 0.7329 | 0.73363 | 118535.0 |
| 2010-01-20 | AD | Futures | 0.95744 | 0.95744 | 0.94095 | 0.94263 | 102303.0 |
| 2010-01-20 | B | Futures | 70.28 | 70.34 | 68.65 | 69.21 | 147098.0 |
| 2010-01-20 | B6 | Futures | 1.6987 | 1.6995 | 1.6864 | 1.691 | 119134.0 |
| 2010-01-20 | BFX | Futures | 2877.8 | 2881.9 | 2812.3 | 2834.8 | 782.0 |
| 2010-01-20 | BR | Futures | 0.22383 | 0.22383 | 0.22383 | 0.22383 | 70.0 |
| 2010-01-20 | C | Futures | 2343.0 | 2358.0 | 2332.0 | 2336.0 | 8575.0 |
| 2010-01-20 | CB | Futures | 74.518 | 74.518 | 74.518 | 74.518 | 5.0 |
| 2010-01-20 | CC | Futures | 2964.0 | 2971.0 | 2932.0 | 2940.0 | 6140.0 |
| 2010-01-20 | CT | Futures | 58.41 | 58.48 | 57.49 | 57.72 | 13128.0 |
| 2010-01-20 | DC | Futures | 24.33 | 24.49 | 23.67 | 23.95 | 312.0 |
| 2010-01-20 | DX | Futures | 78.991 | 79.972 | 78.991 | 79.83 | 20819.0 |
| 2010-01-20 | E1 | Futures | 1.27733 | 1.27746 | 1.25992 | 1.26374 | 62492.0 |
| 2010-01-20 | E6 | Futures | 1.6915 | 1.6915 | 1.66663 | 1.66983 | 341110.0 |
| 2010-01-20 | E7 | Futures | 1.679 | 1.6795 | 1.6553 | 1.6582 | 4500.0 |
| 2010-01-20 | EBM | Futures | 212.08 | 213.35 | 212.08 | 212.93 | 2458.0 |
| 2010-01-20 | ED | Futures | 94.382 | 94.3867 | 94.3725 | 94.382 | 136109.0 |
| 2010-01-20 | ER | Futures | 97.326 | 97.33 | 97.316 | 97.326 | 116293.0 |
| 2010-01-20 | EW | Futures | 727.7 | 728.1 | 716.9 | 724.0 | 32654.0 |
| 2010-01-20 | FBTP | Futures | 63.38 | 63.41 | 63.15 | 63.26 | 5588.0 |
| 2010-01-20 | FCE | Futures | 2610.7 | 2614.2 | 2549.1 | 2558.2 | 142070.0 |
| 2010-01-20 | FDAX | Futures | 6517.0 | 6529.6 | 6373.3 | 6393.6 | 188210.0 |
| 2010-01-20 | FESX | Futures | 1785.0 | 1786.2 | 1736.5 | 1744.3 | 1719961.0 |
| 2010-01-20 | FEU3 | Futures | 97.889 | 97.889 | 97.884 | 97.889 | 156.0 |
| 2010-01-20 | FGBL | Futures | 94.55 | 94.93 | 94.52 | 94.87 | 834309.0 |
| 2010-01-20 | FGBM | Futures | 100.3 | 100.56 | 100.26 | 100.53 | 426346.0 |
| 2010-01-20 | FGBS | Futures | 105.552 | 105.649 | 105.533 | 105.62 | 636316.0 |
| 2010-01-20 | FGBX | Futures | 88.05 | 88.37 | 87.74 | 88.3 | 3639.0 |
| 2010-01-20 | FTDX | Futures | 740.7 | 744.2 | 725.2 | 726.5 | 1238.0 |
| 2010-01-20 | FTI | Futures | 276.92 | 277.45 | 271.35 | 272.37 | 38642.0 |
| 2010-01-20 | FTUK | Futures | 3650.9 | 3663.6 | 3590.3 | 3602.4 | 130945.0 |
| 2010-01-20 | G | Futures | 75.4 | 75.42 | 75.17 | 75.26 | 85770.0 |
| 2010-01-20 | GF | Futures | 268.769 | 269.984 | 267.823 | 269.782 | 2325.0 |
| 2010-01-20 | GSCI | Futures | 964.3 | 964.67 | 956.82 | 959.62 | 350.0 |
| 2010-01-20 | HE | Futures | 98.887 | 98.887 | 96.746 | 98.184 | 16288.0 |
| 2010-01-20 | HG | Futures | 4.7587 | 4.787 | 4.6056 | 4.6284 | 27967.0 |
| 2010-01-20 | HO | Futures | 1.9158 | 1.9163 | 1.8739 | 1.8939 | 32019.0 |
| 2010-01-20 | HRC | Futures | 2729.2 | 2729.2 | 2729.2 | 2729.2 | 0.0 |
| 2010-01-20 | J1 | Futures | 0.0138113 | 0.0138654 | 0.013761 | 0.0138013 | 102494.0 |
| 2010-01-20 | J7 | Futures | 0.013612 | 0.013688 | 0.013591 | 0.013628 | 134.0 |
| 2010-01-20 | JB | Futures | 117.5 | 117.56 | 117.43 | 117.52 | 486.0 |
| 2010-01-20 | KC | Futures | 365.71 | 365.71 | 360.38 | 362.33 | 11331.0 |
| 2010-01-20 | KE | Futures | 2283.83 | 2287.22 | 2228.43 | 2281.57 | 12388.0 |
| 2010-01-20 | KRW | Futures | 0.0008567 | 0.0008567 | 0.0008559 | 0.0008559 | 20.0 |
> showing 50 of 91 rows — these rows as CSV