PREVIEW / futures_daily / 2013-04-18
file: by_date/futures_daily/2013/2013-04-18.parquet size: 9 KB rows: 103
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 |
|---|---|---|---|---|---|---|---|
| 2013-04-18 | ES | Futures | 1585.68 | 1594.92 | 1571.56 | 1574.9 | 2316865.0 |
| 2013-04-18 | NQ | Futures | 3200.18 | 3220.39 | 3146.46 | 3164.37 | 345298.0 |
| 2013-04-18 | YM | Futures | 14322.5 | 14391.5 | 14182.7 | 14189.6 | 211144.0 |
| 2013-04-18 | CL | Futures | 151.04 | 154.84 | 149.81 | 153.48 | 235083.0 |
| 2013-04-18 | GC | Futures | 1826.8 | 1861.2 | 1773.0 | 1848.6 | 246906.0 |
| 2013-04-18 | ZN | Futures | 118.51945 | 118.644676 | 118.38031 | 118.561192 | 1150376.0 |
| 2013-04-18 | A6 | Futures | 0.94703 | 0.95008 | 0.94371 | 0.94491 | 121773.0 |
| 2013-04-18 | AD | Futures | 0.97753 | 0.98085 | 0.97633 | 0.97703 | 60620.0 |
| 2013-04-18 | B | Futures | 93.85 | 96.15 | 93.16 | 95.46 | 306939.0 |
| 2013-04-18 | B6 | Futures | 1.5946 | 1.6018 | 1.5919 | 1.5989 | 92894.0 |
| 2013-04-18 | BFX | Futures | 2972.2 | 2983.8 | 2955.0 | 2967.7 | 50.0 |
| 2013-04-18 | BR | Futures | 0.24554 | 0.24554 | 0.24369 | 0.24371 | 103.0 |
| 2013-04-18 | BZ | Futures | 94.43 | 97.31 | 94.33 | 96.64 | 6283.0 |
| 2013-04-18 | C | Futures | 1630.0 | 1645.0 | 1628.0 | 1636.0 | 2640.0 |
| 2013-04-18 | CB | Futures | 91.459 | 91.952 | 91.213 | 91.213 | 46.0 |
| 2013-04-18 | CC | Futures | 1732.0 | 1750.0 | 1720.0 | 1739.0 | 12644.0 |
| 2013-04-18 | CNH | Futures | 7.2152 | 7.2152 | 7.2079 | 7.2124 | 130.0 |
| 2013-04-18 | CSC | Futures | 3.865 | 3.893 | 3.865 | 3.893 | 8.0 |
| 2013-04-18 | CT | Futures | 103.97 | 104.4 | 102.49 | 102.7 | 6415.0 |
| 2013-04-18 | DC | Futures | 29.77 | 30.21 | 29.77 | 29.83 | 327.0 |
| 2013-04-18 | DX | Futures | 79.515 | 79.534 | 79.251 | 79.463 | 24102.0 |
| 2013-04-18 | E1 | Futures | 1.38031 | 1.38559 | 1.3789 | 1.38057 | 27639.0 |
| 2013-04-18 | E6 | Futures | 1.53747 | 1.54455 | 1.53582 | 1.53889 | 252896.0 |
| 2013-04-18 | E7 | Futures | 1.5272 | 1.5344 | 1.5258 | 1.5288 | 3592.0 |
| 2013-04-18 | EBM | Futures | 287.88 | 288.46 | 285.55 | 285.55 | 9348.0 |
| 2013-04-18 | ED | Futures | 95.2492 | 95.2587 | 95.2492 | 95.254 | 62731.0 |
| 2013-04-18 | ER | Futures | 97.832 | 97.857 | 97.788 | 97.837 | 81590.0 |
| 2013-04-18 | EW | Futures | 1131.7 | 1138.8 | 1120.3 | 1122.4 | 24983.0 |
| 2013-04-18 | FBTP | Futures | 77.56 | 78.0 | 77.5 | 77.58 | 26716.0 |
| 2013-04-18 | FBTS | Futures | 92.27 | 92.407 | 92.253 | 92.313 | 4639.0 |
| 2013-04-18 | FCE | Futures | 2725.0 | 2748.4 | 2706.9 | 2720.3 | 91160.0 |
| 2013-04-18 | FDAX | Futures | 8367.8 | 8411.2 | 8276.7 | 8319.5 | 155911.0 |
| 2013-04-18 | FESX | Futures | 1748.3 | 1764.4 | 1735.0 | 1747.6 | 1235661.0 |
| 2013-04-18 | FGBL | Futures | 122.53 | 122.69 | 122.25 | 122.59 | 686921.0 |
| 2013-04-18 | FGBM | Futures | 118.36 | 118.41 | 118.2 | 118.32 | 396830.0 |
| 2013-04-18 | FGBS | Futures | 110.532 | 110.542 | 110.477 | 110.507 | 310092.0 |
| 2013-04-18 | FGBX | Futures | 129.55 | 129.85 | 129.04 | 129.68 | 11113.0 |
| 2013-04-18 | FMWO | Futures | 4622.6 | 4622.6 | 4616.3 | 4616.3 | 50.0 |
| 2013-04-18 | FOAT | Futures | 109.15 | 109.23 | 108.86 | 109.14 | 49894.0 |
| 2013-04-18 | FTDX | Futures | 849.2 | 854.9 | 845.5 | 846.4 | 132.0 |
| 2013-04-18 | FTI | Futures | 291.24 | 292.9 | 290.02 | 291.37 | 26506.0 |
| 2013-04-18 | FTUK | Futures | 4609.8 | 4626.1 | 4586.4 | 4597.5 | 100221.0 |
| 2013-04-18 | FVSA | Futures | 3477.67 | 3541.05 | 3335.08 | 3517.28 | 7806.0 |
| 2013-04-18 | FXXP | Futures | 206.1 | 207.1 | 205.2 | 205.7 | 7424.0 |
| 2013-04-18 | G | Futures | 100.49 | 100.7 | 100.22 | 100.62 | 155763.0 |
| 2013-04-18 | GF | Futures | 255.326 | 256.006 | 252.064 | 253.786 | 3109.0 |
| 2013-04-18 | GSCI | Futures | 972.69 | 977.83 | 963.13 | 973.17 | 259.0 |
| 2013-04-18 | HE | Futures | 88.727 | 88.954 | 88.249 | 88.551 | 229.0 |
| 2013-04-18 | HG | Futures | 4.0666 | 4.1086 | 3.9112 | 4.101 | 33234.0 |
| 2013-04-18 | HH | Futures | 47.707 | 50.109 | 47.243 | 49.86 | 4080.0 |
> showing 50 of 103 rows — these rows as CSV