PREVIEW / futures_daily / 2011-03-15
file: by_date/futures_daily/2011/2011-03-15.parquet size: 9 KB rows: 94
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 |
|---|---|---|---|---|---|---|---|
| 2011-03-15 | ES | Futures | 1277.61 | 1280.33 | 1238.5 | 1262.51 | 3992352.0 |
| 2011-03-15 | NQ | Futures | 2607.19 | 2611.47 | 2521.21 | 2556.8 | 430853.0 |
| 2011-03-15 | YM | Futures | 11211.6 | 11222.9 | 10912.6 | 11083.7 | 200560.0 |
| 2011-03-15 | CL | Futures | 198.76 | 198.77 | 188.93 | 189.47 | 218453.0 |
| 2011-03-15 | GC | Futures | 1939.2 | 1939.3 | 1873.8 | 1890.2 | 248089.0 |
| 2011-03-15 | ZN | Futures | 101.22411 | 102.356577 | 101.197774 | 101.421633 | 1716995.0 |
| 2011-03-15 | A6 | Futures | 0.85614 | 0.85717 | 0.83255 | 0.84001 | 241389.0 |
| 2011-03-15 | AD | Futures | 1.02062 | 1.02072 | 0.99612 | 1.01196 | 170697.0 |
| 2011-03-15 | B | Futures | 96.44 | 96.5 | 91.6 | 92.1 | 268217.0 |
| 2011-03-15 | B6 | Futures | 1.6784 | 1.6798 | 1.6581 | 1.6701 | 125233.0 |
| 2011-03-15 | BFX | Futures | 3022.7 | 3026.7 | 2920.1 | 2951.7 | 800.0 |
| 2011-03-15 | BR | Futures | 0.25839 | 0.25973 | 0.25839 | 0.25973 | 303.0 |
| 2011-03-15 | BZ | Futures | 97.32 | 99.3 | 96.75 | 97.02 | 3124.0 |
| 2011-03-15 | C | Futures | 2390.0 | 2395.0 | 2321.0 | 2342.0 | 12648.0 |
| 2011-03-15 | CB | Futures | 119.975 | 119.975 | 118.509 | 119.095 | 14.0 |
| 2011-03-15 | CC | Futures | 2676.0 | 2689.0 | 2572.0 | 2616.0 | 14739.0 |
| 2011-03-15 | CSC | Futures | 4.142 | 4.217 | 4.116 | 4.194 | 41.0 |
| 2011-03-15 | CT | Futures | 175.36 | 178.46 | 170.74 | 170.74 | 7811.0 |
| 2011-03-15 | DC | Futures | 27.53 | 28.07 | 26.77 | 27.36 | 370.0 |
| 2011-03-15 | DX | Futures | 76.272 | 77.004 | 76.203 | 76.273 | 29655.0 |
| 2011-03-15 | E1 | Futures | 1.41742 | 1.43379 | 1.41624 | 1.42868 | 76522.0 |
| 2011-03-15 | E6 | Futures | 1.65462 | 1.6577 | 1.63886 | 1.65568 | 380356.0 |
| 2011-03-15 | E7 | Futures | 1.6427 | 1.6452 | 1.6269 | 1.6434 | 6010.0 |
| 2011-03-15 | EBM | Futures | 200.56 | 200.79 | 188.11 | 190.69 | 24804.0 |
| 2011-03-15 | ED | Futures | 94.874 | 94.8835 | 94.8502 | 94.8597 | 412767.0 |
| 2011-03-15 | ER | Futures | 97.286 | 97.351 | 97.281 | 97.316 | 359395.0 |
| 2011-03-15 | EW | Futures | 941.4 | 942.9 | 912.1 | 933.1 | 55042.0 |
| 2011-03-15 | FBTP | Futures | 64.24 | 64.52 | 63.93 | 64.35 | 10312.0 |
| 2011-03-15 | FCE | Futures | 2538.4 | 2544.8 | 2472.2 | 2519.8 | 108746.0 |
| 2011-03-15 | FDAX | Futures | 7133.5 | 7193.5 | 6942.9 | 7136.2 | 407263.0 |
| 2011-03-15 | FESX | Futures | 1749.2 | 1749.2 | 1696.6 | 1740.2 | 1339136.0 |
| 2011-03-15 | FEU3 | Futures | 97.86 | 97.87 | 97.86 | 97.865 | 533.0 |
| 2011-03-15 | FGBL | Futures | 98.32 | 98.97 | 98.28 | 98.44 | 1353756.0 |
| 2011-03-15 | FGBM | Futures | 103.82 | 104.27 | 103.46 | 103.67 | 875908.0 |
| 2011-03-15 | FGBS | Futures | 106.627 | 106.836 | 106.578 | 106.697 | 1270824.0 |
| 2011-03-15 | FGBX | Futures | 95.46 | 97.16 | 95.46 | 96.17 | 8809.0 |
| 2011-03-15 | FTDX | Futures | 777.0 | 777.0 | 757.4 | 775.7 | 2687.0 |
| 2011-03-15 | FTI | Futures | 283.32 | 285.11 | 279.04 | 282.54 | 26127.0 |
| 2011-03-15 | FTUK | Futures | 4002.8 | 4002.8 | 3878.9 | 3955.2 | 133460.0 |
| 2011-03-15 | FXXP | Futures | 175.5 | 175.8 | 172.8 | 175.3 | 19927.0 |
| 2011-03-15 | G | Futures | 82.43 | 82.58 | 82.02 | 82.06 | 178228.0 |
| 2011-03-15 | GF | Futures | 322.955 | 323.258 | 316.179 | 316.179 | 2342.0 |
| 2011-03-15 | GSCI | Futures | 1061.48 | 1065.86 | 1050.83 | 1050.83 | 679.0 |
| 2011-03-15 | HE | Futures | 100.697 | 100.784 | 98.1 | 99.034 | 20689.0 |
| 2011-03-15 | HG | Futures | 5.623 | 5.623 | 5.4292 | 5.5104 | 57238.0 |
| 2011-03-15 | HO | Futures | 2.5486 | 2.5486 | 2.4379 | 2.4661 | 28046.0 |
| 2011-03-15 | HRC | Futures | 3098.9 | 3098.9 | 3098.9 | 3098.9 | 0.0 |
| 2011-03-15 | J1 | Futures | 0.0153923 | 0.0155971 | 0.0153219 | 0.0155506 | 236070.0 |
| 2011-03-15 | J7 | Futures | 0.015286 | 0.015499 | 0.015231 | 0.015455 | 1273.0 |
| 2011-03-15 | JB | Futures | 121.81 | 121.81 | 121.81 | 121.81 | 5404.0 |
> showing 50 of 94 rows — these rows as CSV