PREVIEW / futures_daily / 2011-12-30
file: by_date/futures_daily/2011/2011-12-30.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-12-30 | ES | Futures | 1261.23 | 1265.0 | 1255.21 | 1256.97 | 692364.0 |
| 2011-12-30 | NQ | Futures | 2605.4 | 2612.55 | 2596.25 | 2601.11 | 69032.0 |
| 2011-12-30 | YM | Futures | 11806.1 | 11846.7 | 11734.5 | 11750.0 | 45348.0 |
| 2011-12-30 | CL | Futures | 186.48 | 187.19 | 184.29 | 184.7 | 154064.0 |
| 2011-12-30 | GC | Futures | 2089.1 | 2137.0 | 2087.6 | 2115.4 | 94315.0 |
| 2011-12-30 | ZN | Futures | 113.003222 | 113.408299 | 112.854693 | 113.313781 | 298765.0 |
| 2011-12-30 | A6 | Futures | 0.89402 | 0.90622 | 0.89349 | 0.90515 | 54166.0 |
| 2011-12-30 | AD | Futures | 0.98164 | 0.98646 | 0.98044 | 0.98576 | 34764.0 |
| 2011-12-30 | B | Futures | 95.86 | 96.03 | 94.6 | 95.24 | 50311.0 |
| 2011-12-30 | B6 | Futures | 1.6097 | 1.6268 | 1.6088 | 1.6203 | 55567.0 |
| 2011-12-30 | BFX | Futures | 2488.3 | 2509.1 | 2475.4 | 2505.5 | 136.0 |
| 2011-12-30 | BZ | Futures | 101.51 | 101.59 | 101.08 | 101.08 | 411.0 |
| 2011-12-30 | C | Futures | 1391.0 | 1412.0 | 1381.0 | 1407.0 | 5186.0 |
| 2011-12-30 | CC | Futures | 1614.0 | 1663.0 | 1607.0 | 1635.0 | 4444.0 |
| 2011-12-30 | CSC | Futures | 4.066 | 4.066 | 4.049 | 4.049 | 1.0 |
| 2011-12-30 | CT | Futures | 117.94 | 118.3 | 116.95 | 118.23 | 4190.0 |
| 2011-12-30 | DC | Futures | 29.42 | 29.62 | 29.23 | 29.3 | 161.0 |
| 2011-12-30 | DX | Futures | 78.673 | 78.863 | 78.216 | 78.373 | 12439.0 |
| 2011-12-30 | E1 | Futures | 1.39756 | 1.40753 | 1.39467 | 1.40058 | 16749.0 |
| 2011-12-30 | E6 | Futures | 1.54923 | 1.55485 | 1.54373 | 1.55007 | 115573.0 |
| 2011-12-30 | E7 | Futures | 1.5348 | 1.5406 | 1.5296 | 1.5359 | 2579.0 |
| 2011-12-30 | EBM | Futures | 254.87 | 257.16 | 254.54 | 255.85 | 3290.0 |
| 2011-12-30 | ED | Futures | 94.9005 | 94.9244 | 94.8909 | 94.9148 | 95956.0 |
| 2011-12-30 | ER | Futures | 97.267 | 97.277 | 97.253 | 97.272 | 36472.0 |
| 2011-12-30 | EW | Futures | 885.7 | 890.0 | 880.1 | 883.7 | 14939.0 |
| 2011-12-30 | FBTP | Futures | 57.7 | 58.06 | 57.53 | 57.9 | 1687.0 |
| 2011-12-30 | FBTS | Futures | 80.122 | 80.162 | 79.993 | 80.154 | 430.0 |
| 2011-12-30 | FCE | Futures | 2250.6 | 2291.4 | 2219.8 | 2266.7 | 29522.0 |
| 2011-12-30 | FDAX | Futures | 6493.4 | 6515.4 | 6429.3 | 6515.4 | 35988.0 |
| 2011-12-30 | FESX | Futures | 1535.7 | 1547.0 | 1524.3 | 1543.0 | 347239.0 |
| 2011-12-30 | FGBL | Futures | 112.37 | 112.59 | 112.16 | 112.52 | 114998.0 |
| 2011-12-30 | FGBM | Futures | 113.05 | 113.3 | 112.94 | 113.22 | 72533.0 |
| 2011-12-30 | FGBS | Futures | 109.859 | 109.919 | 109.849 | 109.864 | 81493.0 |
| 2011-12-30 | FGBX | Futures | 118.62 | 118.94 | 118.14 | 118.49 | 2959.0 |
| 2011-12-30 | FTDX | Futures | 629.3 | 642.8 | 627.5 | 642.8 | 90.0 |
| 2011-12-30 | FTI | Futures | 261.26 | 263.28 | 260.3 | 262.86 | 12322.0 |
| 2011-12-30 | FTUK | Futures | 3998.4 | 4004.9 | 3961.6 | 3993.3 | 23760.0 |
| 2011-12-30 | FVSA | Futures | 13078.89 | 13078.89 | 12999.14 | 13058.95 | 950.0 |
| 2011-12-30 | FXXP | Futures | 171.1 | 172.0 | 170.9 | 172.0 | 958.0 |
| 2011-12-30 | G | Futures | 94.82 | 95.27 | 94.82 | 94.91 | 23524.0 |
| 2011-12-30 | GF | Futures | 316.864 | 317.134 | 315.195 | 315.249 | 995.0 |
| 2011-12-30 | GSCI | Futures | 1010.63 | 1019.34 | 1008.67 | 1014.87 | 404.0 |
| 2011-12-30 | HE | Futures | 104.202 | 104.88 | 103.863 | 103.924 | 13109.0 |
| 2011-12-30 | HG | Futures | 4.4681 | 4.5617 | 4.4549 | 4.5321 | 20608.0 |
| 2011-12-30 | HO | Futures | 2.3666 | 2.3816 | 2.3362 | 2.3517 | 12274.0 |
| 2011-12-30 | HRC | Futures | 2825.8 | 2865.0 | 2825.8 | 2845.4 | 20.0 |
| 2011-12-30 | J1 | Futures | 0.0161991 | 0.0163536 | 0.016174 | 0.016336 | 89463.0 |
| 2011-12-30 | J7 | Futures | 0.016135 | 0.016285 | 0.016107 | 0.016268 | 430.0 |
| 2011-12-30 | JB | Futures | 124.47 | 124.68 | 124.47 | 124.65 | 1709.0 |
| 2011-12-30 | KC | Futures | 519.92 | 527.21 | 519.34 | 525.47 | 2826.0 |
> showing 50 of 94 rows — these rows as CSV