PREVIEW / futures_daily / 2012-10-04
file: by_date/futures_daily/2012/2012-10-04.parquet size: 9 KB rows: 98
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 |
|---|---|---|---|---|---|---|---|
| 2012-10-04 | ES | Futures | 1469.68 | 1483.67 | 1469.68 | 1481.64 | 1566715.0 |
| 2012-10-04 | NQ | Futures | 3232.07 | 3256.23 | 3230.63 | 3246.45 | 194754.0 |
| 2012-10-04 | YM | Futures | 13108.4 | 13207.0 | 13106.5 | 13180.7 | 112527.0 |
| 2012-10-04 | CL | Futures | 158.84 | 165.75 | 158.66 | 165.52 | 291389.0 |
| 2012-10-04 | GC | Futures | 2376.5 | 2400.2 | 2376.4 | 2398.6 | 161985.0 |
| 2012-10-04 | ZN | Futures | 117.562925 | 117.576659 | 117.178374 | 117.274512 | 740394.0 |
| 2012-10-04 | A6 | Futures | 0.92299 | 0.92808 | 0.91972 | 0.92517 | 142991.0 |
| 2012-10-04 | AD | Futures | 1.01473 | 1.02245 | 1.01453 | 1.02155 | 88083.0 |
| 2012-10-04 | B | Futures | 98.42 | 102.45 | 98.28 | 102.36 | 206681.0 |
| 2012-10-04 | B6 | Futures | 1.6793 | 1.6917 | 1.6786 | 1.69 | 106481.0 |
| 2012-10-04 | BR | Futures | 0.23806 | 0.23918 | 0.23806 | 0.23879 | 83.0 |
| 2012-10-04 | BZ | Futures | 103.13 | 106.22 | 103.08 | 106.22 | 2046.0 |
| 2012-10-04 | C | Futures | 1582.0 | 1596.0 | 1546.0 | 1553.0 | 10336.0 |
| 2012-10-04 | CC | Futures | 1826.0 | 1845.0 | 1799.0 | 1806.0 | 10886.0 |
| 2012-10-04 | CSC | Futures | 4.187 | 4.187 | 4.164 | 4.164 | 20.0 |
| 2012-10-04 | CT | Futures | 92.91 | 93.75 | 92.59 | 93.03 | 9753.0 |
| 2012-10-04 | DC | Futures | 31.14 | 31.37 | 31.14 | 31.26 | 615.0 |
| 2012-10-04 | DX | Futures | 77.431 | 77.494 | 76.864 | 76.947 | 20032.0 |
| 2012-10-04 | E1 | Futures | 1.37312 | 1.38638 | 1.37286 | 1.38484 | 30435.0 |
| 2012-10-04 | E6 | Futures | 1.5212 | 1.53568 | 1.52108 | 1.53415 | 308299.0 |
| 2012-10-04 | E7 | Futures | 1.5122 | 1.5264 | 1.5121 | 1.525 | 5417.0 |
| 2012-10-04 | ED | Futures | 95.2301 | 95.2349 | 95.2205 | 95.2301 | 106449.0 |
| 2012-10-04 | ER | Futures | 97.876 | 97.886 | 97.862 | 97.876 | 92012.0 |
| 2012-10-04 | EW | Futures | 1003.9 | 1014.8 | 1003.2 | 1013.1 | 22123.0 |
| 2012-10-04 | FBTP | Futures | 71.4 | 71.49 | 71.08 | 71.15 | 15698.0 |
| 2012-10-04 | FBTS | Futures | 89.433 | 89.474 | 89.282 | 89.332 | 1815.0 |
| 2012-10-04 | FCE | Futures | 2556.1 | 2568.1 | 2532.9 | 2544.5 | 87558.0 |
| 2012-10-04 | FDAX | Futures | 8055.0 | 8083.0 | 7981.1 | 8001.9 | 123489.0 |
| 2012-10-04 | FESX | Futures | 1700.1 | 1706.9 | 1683.1 | 1686.5 | 973581.0 |
| 2012-10-04 | FEU3 | Futures | 98.497 | 98.497 | 98.497 | 98.497 | 150.0 |
| 2012-10-04 | FGBL | Futures | 118.32 | 118.51 | 117.95 | 118.4 | 682202.0 |
| 2012-10-04 | FGBM | Futures | 116.29 | 116.37 | 116.05 | 116.28 | 353795.0 |
| 2012-10-04 | FGBS | Futures | 110.372 | 110.377 | 110.293 | 110.328 | 329975.0 |
| 2012-10-04 | FGBX | Futures | 125.38 | 125.8 | 124.33 | 125.38 | 7826.0 |
| 2012-10-04 | FOAT | Futures | 102.95 | 103.21 | 102.81 | 103.05 | 54997.0 |
| 2012-10-04 | FTDX | Futures | 773.5 | 773.5 | 768.4 | 770.2 | 46.0 |
| 2012-10-04 | FTI | Futures | 280.07 | 281.69 | 278.54 | 279.43 | 27500.0 |
| 2012-10-04 | FTUK | Futures | 4241.3 | 4264.4 | 4225.2 | 4240.2 | 78060.0 |
| 2012-10-04 | FVSA | Futures | 5572.38 | 5645.7 | 5474.62 | 5609.04 | 2406.0 |
| 2012-10-04 | FXXP | Futures | 196.1 | 196.1 | 194.5 | 195.1 | 1824.0 |
| 2012-10-04 | G | Futures | 99.75 | 99.81 | 99.33 | 99.6 | 115969.0 |
| 2012-10-04 | GF | Futures | 282.575 | 284.035 | 280.531 | 281.261 | 1423.0 |
| 2012-10-04 | GSCI | Futures | 1056.47 | 1075.09 | 1055.02 | 1075.09 | 651.0 |
| 2012-10-04 | HE | Futures | 94.312 | 96.114 | 94.218 | 94.529 | 26095.0 |
| 2012-10-04 | HG | Futures | 4.8486 | 4.9 | 4.8396 | 4.8653 | 40194.0 |
| 2012-10-04 | HH | Futures | 43.8 | 43.8 | 42.997 | 43.431 | 1499.0 |
| 2012-10-04 | HO | Futures | 2.4688 | 2.5625 | 2.4688 | 2.5616 | 53039.0 |
| 2012-10-04 | HRC | Futures | 2459.4 | 2459.4 | 2459.4 | 2459.4 | 134.0 |
| 2012-10-04 | J1 | Futures | 0.0159632 | 0.0159983 | 0.0159131 | 0.0159607 | 77124.0 |
| 2012-10-04 | J7 | Futures | 0.015891 | 0.015931 | 0.015847 | 0.015893 | 467.0 |
> showing 50 of 98 rows — these rows as CSV