PREVIEW / futures_daily / 2010-03-09
file: by_date/futures_daily/2010/2010-03-09.parquet size: 9 KB rows: 92
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-03-09 | ES | Futures | 1102.39 | 1110.14 | 1096.81 | 1105.54 | 1759468.0 |
| 2010-03-09 | NQ | Futures | 2135.42 | 2162.56 | 2127.5 | 2150.4 | 332075.0 |
| 2010-03-09 | YM | Futures | 9625.8 | 9687.9 | 9591.1 | 9649.5 | 107360.0 |
| 2010-03-09 | CL | Futures | 191.91 | 192.28 | 188.18 | 191.3 | 332133.0 |
| 2010-03-09 | GC | Futures | 1541.9 | 1543.7 | 1520.5 | 1539.8 | 153991.0 |
| 2010-03-09 | ZN | Futures | 95.346174 | 95.677769 | 95.346174 | 95.550233 | 653375.0 |
| 2010-03-09 | A6 | Futures | 0.73818 | 0.7429 | 0.7355 | 0.74176 | 105873.0 |
| 2010-03-09 | AD | Futures | 0.9605 | 0.96455 | 0.95665 | 0.96208 | 83765.0 |
| 2010-03-09 | B | Futures | 72.02 | 72.14 | 70.64 | 71.72 | 112415.0 |
| 2010-03-09 | B6 | Futures | 1.564 | 1.564 | 1.5512 | 1.5566 | 147831.0 |
| 2010-03-09 | BFX | Futures | 2939.5 | 2939.5 | 2939.5 | 2939.5 | 270.0 |
| 2010-03-09 | BR | Futures | 0.22613 | 0.22613 | 0.22613 | 0.22613 | 155.0 |
| 2010-03-09 | BZ | Futures | 75.42 | 75.42 | 75.42 | 75.42 | 2.0 |
| 2010-03-09 | C | Futures | 2171.0 | 2175.0 | 2145.0 | 2158.0 | 2696.0 |
| 2010-03-09 | CB | Futures | 75.011 | 75.011 | 74.888 | 74.888 | 13.0 |
| 2010-03-09 | CC | Futures | 2394.0 | 2395.0 | 2341.0 | 2372.0 | 9150.0 |
| 2010-03-09 | CT | Futures | 66.7 | 66.72 | 64.9 | 65.33 | 9103.0 |
| 2010-03-09 | DC | Futures | 22.54 | 22.54 | 22.25 | 22.36 | 152.0 |
| 2010-03-09 | DX | Futures | 81.839 | 82.25 | 81.803 | 81.971 | 24082.0 |
| 2010-03-09 | E1 | Futures | 1.22841 | 1.2292 | 1.22049 | 1.22564 | 59375.0 |
| 2010-03-09 | E6 | Futures | 1.61336 | 1.61431 | 1.60247 | 1.60922 | 303465.0 |
| 2010-03-09 | E7 | Futures | 1.6021 | 1.6028 | 1.5913 | 1.598 | 2873.0 |
| 2010-03-09 | EBM | Futures | 201.11 | 201.11 | 199.88 | 201.11 | 6098.0 |
| 2010-03-09 | ED | Futures | 94.3962 | 94.4009 | 94.3962 | 94.3986 | 85295.0 |
| 2010-03-09 | ER | Futures | 97.34 | 97.35 | 97.34 | 97.345 | 107718.0 |
| 2010-03-09 | EW | Futures | 748.9 | 754.5 | 745.0 | 749.7 | 25845.0 |
| 2010-03-09 | FBTP | Futures | 64.19 | 64.37 | 64.12 | 64.3 | 3556.0 |
| 2010-03-09 | FCE | Futures | 2512.1 | 2523.0 | 2489.6 | 2510.8 | 125449.0 |
| 2010-03-09 | FDAX | Futures | 6418.1 | 6455.3 | 6377.7 | 6434.0 | 145295.0 |
| 2010-03-09 | FESX | Futures | 1725.7 | 1732.9 | 1710.1 | 1724.5 | 1042883.0 |
| 2010-03-09 | FEU3 | Futures | 97.909 | 97.909 | 97.909 | 97.909 | 37.0 |
| 2010-03-09 | FGBL | Futures | 95.59 | 96.01 | 95.59 | 95.86 | 878601.0 |
| 2010-03-09 | FGBM | Futures | 101.49 | 101.75 | 101.47 | 101.64 | 520930.0 |
| 2010-03-09 | FGBS | Futures | 106.243 | 106.341 | 106.233 | 106.277 | 549231.0 |
| 2010-03-09 | FGBX | Futures | 89.82 | 90.2 | 89.53 | 89.94 | 2550.0 |
| 2010-03-09 | FTDX | Futures | 731.4 | 739.4 | 724.3 | 734.1 | 488.0 |
| 2010-03-09 | FTI | Futures | 273.14 | 273.79 | 270.65 | 272.86 | 45214.0 |
| 2010-03-09 | FTUK | Futures | 3750.7 | 3762.4 | 3717.6 | 3747.7 | 103132.0 |
| 2010-03-09 | G | Futures | 75.92 | 76.29 | 75.84 | 76.21 | 103171.0 |
| 2010-03-09 | GF | Futures | 277.413 | 277.548 | 276.332 | 276.467 | 1133.0 |
| 2010-03-09 | GSCI | Futures | 961.76 | 973.06 | 960.93 | 967.5 | 3354.0 |
| 2010-03-09 | HE | Futures | 97.415 | 98.084 | 96.679 | 96.88 | 16413.0 |
| 2010-03-09 | HG | Futures | 4.6794 | 4.6794 | 4.5838 | 4.6609 | 25369.0 |
| 2010-03-09 | HO | Futures | 1.9188 | 1.9433 | 1.9094 | 1.929 | 14075.0 |
| 2010-03-09 | HRC | Futures | 2990.6 | 2990.6 | 2990.6 | 2990.6 | 0.0 |
| 2010-03-09 | J1 | Futures | 0.0139346 | 0.0140416 | 0.0139321 | 0.01399 | 121165.0 |
| 2010-03-09 | J7 | Futures | 0.013766 | 0.013863 | 0.013766 | 0.013815 | 356.0 |
| 2010-03-09 | JB | Futures | 118.36 | 118.46 | 118.34 | 118.41 | 11073.0 |
| 2010-03-09 | KC | Futures | 336.32 | 344.79 | 334.13 | 340.94 | 12789.0 |
| 2010-03-09 | KE | Futures | 2215.64 | 2217.85 | 2200.13 | 2204.56 | 6083.0 |
> showing 50 of 92 rows — these rows as CSV