PREVIEW / futures_daily / 2014-10-15
file: by_date/futures_daily/2014/2014-10-15.parquet size: 9 KB rows: 105
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 |
|---|---|---|---|---|---|---|---|
| 2014-10-15 | ES | Futures | 1961.99 | 1967.22 | 1893.83 | 1929.09 | 4661757.0 |
| 2014-10-15 | NQ | Futures | 4431.63 | 4440.62 | 4278.07 | 4348.48 | 831107.0 |
| 2014-10-15 | YM | Futures | 16523.5 | 16566.2 | 15998.0 | 16239.5 | 536220.0 |
| 2014-10-15 | CL | Futures | 156.92 | 156.98 | 152.41 | 155.4 | 261128.0 |
| 2014-10-15 | GC | Futures | 1617.7 | 1640.0 | 1602.8 | 1632.7 | 258099.0 |
| 2014-10-15 | ZN | Futures | 119.491215 | 122.33206 | 119.242275 | 120.486975 | 4096750.0 |
| 2014-10-15 | A6 | Futures | 0.84362 | 0.85732 | 0.83944 | 0.84867 | 189978.0 |
| 2014-10-15 | AD | Futures | 0.89803 | 0.90341 | 0.89081 | 0.89874 | 146550.0 |
| 2014-10-15 | ALI | Futures | 2944.45 | 2944.45 | 2944.45 | 2944.45 | 0.0 |
| 2014-10-15 | B | Futures | 89.23 | 89.29 | 86.55 | 87.32 | 434885.0 |
| 2014-10-15 | B6 | Futures | 1.6711 | 1.6883 | 1.6677 | 1.6736 | 232387.0 |
| 2014-10-15 | BFX | Futures | 3647.2 | 3651.3 | 3528.4 | 3528.4 | 187.0 |
| 2014-10-15 | BR | Futures | 0.22082 | 0.22109 | 0.21663 | 0.21871 | 2210.0 |
| 2014-10-15 | BZ | Futures | 89.83 | 89.91 | 87.21 | 87.96 | 28203.0 |
| 2014-10-15 | C | Futures | 2183.0 | 2204.0 | 2167.0 | 2198.0 | 5524.0 |
| 2014-10-15 | CB | Futures | 135.656 | 135.656 | 132.765 | 132.765 | 87.0 |
| 2014-10-15 | CC | Futures | 2311.0 | 2345.0 | 2291.0 | 2328.0 | 13851.0 |
| 2014-10-15 | CNH | Futures | 7.0651 | 7.0662 | 7.0584 | 7.064 | 1.0 |
| 2014-10-15 | CSC | Futures | 5.2 | 5.2 | 5.011 | 5.022 | 48.0 |
| 2014-10-15 | CT | Futures | 81.58 | 81.68 | 80.2 | 80.73 | 11949.0 |
| 2014-10-15 | DC | Futures | 41.91 | 41.91 | 40.53 | 40.62 | 240.0 |
| 2014-10-15 | DX | Futures | 81.671 | 81.761 | 80.237 | 80.917 | 116402.0 |
| 2014-10-15 | E1 | Futures | 1.3408 | 1.36663 | 1.33773 | 1.35486 | 107968.0 |
| 2014-10-15 | E6 | Futures | 1.49046 | 1.51765 | 1.48669 | 1.50446 | 563026.0 |
| 2014-10-15 | E7 | Futures | 1.481 | 1.508 | 1.4775 | 1.495 | 11812.0 |
| 2014-10-15 | ED | Futures | 95.447 | 95.4517 | 95.4422 | 95.4422 | 299098.0 |
| 2014-10-15 | ER | Futures | 97.999 | 98.009 | 97.989 | 97.994 | 74259.0 |
| 2014-10-15 | EW | Futures | 1354.5 | 1357.3 | 1316.0 | 1342.1 | 72282.0 |
| 2014-10-15 | FBTP | Futures | 95.6 | 95.89 | 94.55 | 95.06 | 199313.0 |
| 2014-10-15 | FBTS | Futures | 98.552 | 98.632 | 98.259 | 98.393 | 25251.0 |
| 2014-10-15 | FCE | Futures | 3286.8 | 3303.3 | 3134.3 | 3176.2 | 132245.0 |
| 2014-10-15 | FDAX | Futures | 9670.6 | 9701.8 | 9286.1 | 9393.5 | 242396.0 |
| 2014-10-15 | FESX | Futures | 2163.7 | 2170.9 | 2057.9 | 2087.6 | 2596137.0 |
| 2014-10-15 | FGBL | Futures | 132.95 | 134.34 | 132.95 | 133.74 | 1640806.0 |
| 2014-10-15 | FGBM | Futures | 123.01 | 123.4 | 123.01 | 123.24 | 884622.0 |
| 2014-10-15 | FGBS | Futures | 110.908 | 110.953 | 110.908 | 110.933 | 358531.0 |
| 2014-10-15 | FGBX | Futures | 145.18 | 149.35 | 145.06 | 147.41 | 52456.0 |
| 2014-10-15 | FMWO | Futures | 5355.2 | 5355.2 | 5258.7 | 5258.7 | 2300.0 |
| 2014-10-15 | FOAT | Futures | 122.42 | 123.28 | 122.4 | 123.02 | 151944.0 |
| 2014-10-15 | FTDX | Futures | 1088.7 | 1096.8 | 1054.7 | 1059.0 | 436.0 |
| 2014-10-15 | FTI | Futures | 341.96 | 343.89 | 327.65 | 331.15 | 32750.0 |
| 2014-10-15 | FTUK | Futures | 4917.9 | 4928.3 | 4735.0 | 4784.9 | 223948.0 |
| 2014-10-15 | FVSA | Futures | 1829.15 | 2054.15 | 1824.99 | 2024.98 | 24300.0 |
| 2014-10-15 | FXXP | Futures | 243.1 | 243.4 | 233.1 | 235.3 | 18588.0 |
| 2014-10-15 | G | Futures | 99.41 | 101.32 | 99.41 | 100.74 | 410423.0 |
| 2014-10-15 | GF | Futures | 370.195 | 370.586 | 366.516 | 366.516 | 4636.0 |
| 2014-10-15 | GSCI | Futures | 915.38 | 916.23 | 902.73 | 905.61 | 120.0 |
| 2014-10-15 | HE | Futures | 126.986 | 127.154 | 123.722 | 123.722 | 14698.0 |
| 2014-10-15 | HG | Futures | 3.9073 | 3.913 | 3.7957 | 3.8166 | 77030.0 |
| 2014-10-15 | HH | Futures | 45.698 | 46.121 | 45.638 | 45.94 | 1360.0 |
> showing 50 of 105 rows — these rows as CSV