PREVIEW / futures_daily / 2012-03-16
file: by_date/futures_daily/2012/2012-03-16.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-03-16 | ES | Futures | 1406.52 | 1411.31 | 1404.76 | 1409.29 | 1384158.0 |
| 2012-03-16 | NQ | Futures | 3106.33 | 3116.36 | 3096.59 | 3103.76 | 196864.0 |
| 2012-03-16 | YM | Futures | 12806.7 | 12860.2 | 12795.0 | 12800.9 | 73406.0 |
| 2012-03-16 | CL | Futures | 195.22 | 198.81 | 194.76 | 198.32 | 150002.0 |
| 2012-03-16 | GC | Futures | 2220.0 | 2229.5 | 2195.8 | 2217.3 | 160610.0 |
| 2012-03-16 | ZN | Futures | 111.593573 | 111.674801 | 110.984364 | 111.431117 | 1294185.0 |
| 2012-03-16 | A6 | Futures | 0.93724 | 0.94354 | 0.93562 | 0.94255 | 110479.0 |
| 2012-03-16 | AD | Futures | 1.01225 | 1.01416 | 1.01014 | 1.01275 | 62157.0 |
| 2012-03-16 | B | Futures | 110.1 | 113.34 | 110.01 | 113.03 | 155286.0 |
| 2012-03-16 | B6 | Futures | 1.6477 | 1.6638 | 1.6463 | 1.6608 | 103021.0 |
| 2012-03-16 | BFX | Futures | 2864.8 | 2891.6 | 2858.7 | 2886.7 | 46.0 |
| 2012-03-16 | BR | Futures | 0.26065 | 0.26076 | 0.26057 | 0.26057 | 63.0 |
| 2012-03-16 | BZ | Futures | 117.84 | 120.52 | 117.07 | 120.23 | 412.0 |
| 2012-03-16 | C | Futures | 1446.0 | 1468.0 | 1419.0 | 1463.0 | 5810.0 |
| 2012-03-16 | CB | Futures | 82.887 | 82.887 | 82.739 | 82.753 | 4.0 |
| 2012-03-16 | CC | Futures | 1690.0 | 1727.0 | 1650.0 | 1717.0 | 13339.0 |
| 2012-03-16 | CSC | Futures | 3.728 | 3.737 | 3.669 | 3.682 | 32.0 |
| 2012-03-16 | CT | Futures | 109.13 | 110.34 | 108.88 | 109.48 | 7646.0 |
| 2012-03-16 | DC | Futures | 26.17 | 26.5 | 25.89 | 26.06 | 130.0 |
| 2012-03-16 | DX | Futures | 78.097 | 78.247 | 77.463 | 77.59 | 28870.0 |
| 2012-03-16 | E1 | Futures | 1.42015 | 1.4322 | 1.41609 | 1.43128 | 47653.0 |
| 2012-03-16 | E6 | Futures | 1.56191 | 1.57516 | 1.55844 | 1.57325 | 254334.0 |
| 2012-03-16 | E7 | Futures | 1.5469 | 1.5599 | 1.5436 | 1.5582 | 6278.0 |
| 2012-03-16 | EBM | Futures | 289.74 | 291.42 | 288.05 | 288.05 | 11109.0 |
| 2012-03-16 | ED | Futures | 95.0788 | 95.1027 | 95.074 | 95.0836 | 194280.0 |
| 2012-03-16 | ER | Futures | 97.484 | 97.499 | 97.474 | 97.489 | 198989.0 |
| 2012-03-16 | EW | Futures | 1007.9 | 1011.7 | 1006.7 | 1008.1 | 22085.0 |
| 2012-03-16 | FBTP | Futures | 69.45 | 69.61 | 69.14 | 69.33 | 4679.0 |
| 2012-03-16 | FBTS | Futures | 86.381 | 86.494 | 86.324 | 86.381 | 473.0 |
| 2012-03-16 | FCE | Futures | 2533.1 | 2549.4 | 2530.3 | 2545.9 | 91076.0 |
| 2012-03-16 | FDAX | Futures | 7895.8 | 7947.2 | 7887.6 | 7943.7 | 36204.0 |
| 2012-03-16 | FESX | Futures | 1743.4 | 1755.2 | 1742.1 | 1750.3 | 1099053.0 |
| 2012-03-16 | FGBL | Futures | 111.84 | 111.97 | 110.92 | 111.07 | 920153.0 |
| 2012-03-16 | FGBM | Futures | 112.85 | 112.92 | 112.25 | 112.41 | 575679.0 |
| 2012-03-16 | FGBS | Futures | 109.74 | 109.775 | 109.59 | 109.63 | 578313.0 |
| 2012-03-16 | FGBX | Futures | 114.28 | 114.51 | 112.5 | 112.74 | 8720.0 |
| 2012-03-16 | FTDX | Futures | 740.5 | 745.2 | 736.8 | 739.1 | 530.0 |
| 2012-03-16 | FTI | Futures | 282.92 | 283.98 | 282.08 | 282.97 | 28431.0 |
| 2012-03-16 | FTUK | Futures | 4296.5 | 4322.4 | 4289.9 | 4317.3 | 111661.0 |
| 2012-03-16 | FVSA | Futures | 8201.26 | 8218.0 | 7966.94 | 8134.31 | 3941.0 |
| 2012-03-16 | FXXP | Futures | 193.2 | 194.2 | 193.0 | 193.8 | 3793.0 |
| 2012-03-16 | G | Futures | 92.11 | 92.17 | 91.21 | 91.57 | 156403.0 |
| 2012-03-16 | GF | Futures | 327.478 | 328.106 | 322.14 | 322.977 | 3692.0 |
| 2012-03-16 | GSCI | Futures | 1112.83 | 1126.76 | 1112.83 | 1126.29 | 142.0 |
| 2012-03-16 | HE | Futures | 104.957 | 105.048 | 103.719 | 103.779 | 13244.0 |
| 2012-03-16 | HG | Futures | 5.1085 | 5.1655 | 5.0705 | 5.0842 | 49325.0 |
| 2012-03-16 | HO | Futures | 2.6645 | 2.7159 | 2.6598 | 2.711 | 15737.0 |
| 2012-03-16 | HRC | Futures | 2719.2 | 2719.2 | 2719.2 | 2719.2 | 0.0 |
| 2012-03-16 | J1 | Futures | 0.0150216 | 0.0150855 | 0.0149489 | 0.0150529 | 96059.0 |
| 2012-03-16 | J7 | Futures | 0.014941 | 0.015013 | 0.014876 | 0.014982 | 626.0 |
> showing 50 of 98 rows — these rows as CSV