PREVIEW / futures_daily / 2012-03-14
file: by_date/futures_daily/2012/2012-03-14.parquet size: 9 KB rows: 97
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-14 | ES | Futures | 1401.23 | 1405.01 | 1394.93 | 1399.47 | 2095321.0 |
| 2012-03-14 | NQ | Futures | 3085.14 | 3109.2 | 3077.4 | 3096.59 | 341477.0 |
| 2012-03-14 | YM | Futures | 12749.3 | 12792.1 | 12719.2 | 12768.8 | 115047.0 |
| 2012-03-14 | CL | Futures | 197.69 | 198.26 | 194.76 | 195.31 | 106543.0 |
| 2012-03-14 | GC | Futures | 2243.3 | 2253.5 | 2189.1 | 2200.1 | 279269.0 |
| 2012-03-14 | ZN | Futures | 112.62246 | 112.663074 | 111.444655 | 111.566497 | 1814385.0 |
| 2012-03-14 | A6 | Futures | 0.93823 | 0.93949 | 0.92789 | 0.92942 | 65940.0 |
| 2012-03-14 | AD | Futures | 1.01567 | 1.01618 | 1.00964 | 1.01074 | 45059.0 |
| 2012-03-14 | B | Futures | 112.93 | 113.4 | 111.64 | 111.92 | 188735.0 |
| 2012-03-14 | B6 | Futures | 1.6468 | 1.6514 | 1.6414 | 1.6441 | 68375.0 |
| 2012-03-14 | BFX | Futures | 2842.1 | 2860.5 | 2840.2 | 2840.2 | 381.0 |
| 2012-03-14 | BR | Futures | 0.26022 | 0.26022 | 0.25805 | 0.25869 | 68.0 |
| 2012-03-14 | BZ | Futures | 119.8 | 120.56 | 118.79 | 119.05 | 823.0 |
| 2012-03-14 | C | Futures | 1540.0 | 1543.0 | 1486.0 | 1508.0 | 12574.0 |
| 2012-03-14 | CB | Futures | 82.349 | 82.618 | 82.08 | 82.618 | 66.0 |
| 2012-03-14 | CC | Futures | 1803.0 | 1810.0 | 1735.0 | 1761.0 | 13280.0 |
| 2012-03-14 | CSC | Futures | 3.692 | 3.703 | 3.692 | 3.692 | 4.0 |
| 2012-03-14 | CT | Futures | 110.32 | 110.87 | 108.94 | 109.06 | 9270.0 |
| 2012-03-14 | DC | Futures | 25.6 | 25.92 | 25.51 | 25.81 | 97.0 |
| 2012-03-14 | DX | Futures | 78.087 | 78.538 | 78.068 | 78.461 | 36080.0 |
| 2012-03-14 | E1 | Futures | 1.41832 | 1.41976 | 1.40444 | 1.40876 | 29504.0 |
| 2012-03-14 | E6 | Futures | 1.56298 | 1.56358 | 1.55391 | 1.55534 | 144927.0 |
| 2012-03-14 | E7 | Futures | 1.5478 | 1.5483 | 1.5391 | 1.5404 | 2298.0 |
| 2012-03-14 | EBM | Futures | 283.34 | 286.03 | 283.0 | 284.01 | 6615.0 |
| 2012-03-14 | ED | Futures | 95.0645 | 95.074 | 95.0502 | 95.0693 | 284847.0 |
| 2012-03-14 | ER | Futures | 97.484 | 97.494 | 97.459 | 97.469 | 204491.0 |
| 2012-03-14 | EW | Futures | 1006.3 | 1009.2 | 997.8 | 999.8 | 24073.0 |
| 2012-03-14 | FBTP | Futures | 69.19 | 69.51 | 69.03 | 69.39 | 11296.0 |
| 2012-03-14 | FBTS | Futures | 86.372 | 86.47 | 86.291 | 86.454 | 603.0 |
| 2012-03-14 | FCE | Futures | 2524.2 | 2539.1 | 2519.3 | 2524.6 | 135524.0 |
| 2012-03-14 | FDAX | Futures | 7751.2 | 7841.2 | 7750.6 | 7825.7 | 223147.0 |
| 2012-03-14 | FESX | Futures | 1725.5 | 1742.8 | 1721.4 | 1731.0 | 1464343.0 |
| 2012-03-14 | FGBL | Futures | 112.84 | 112.88 | 111.95 | 112.17 | 948368.0 |
| 2012-03-14 | FGBM | Futures | 113.53 | 113.57 | 113.01 | 113.13 | 594145.0 |
| 2012-03-14 | FGBS | Futures | 109.914 | 109.929 | 109.795 | 109.824 | 578071.0 |
| 2012-03-14 | FGBX | Futures | 116.35 | 116.35 | 113.78 | 114.34 | 12393.0 |
| 2012-03-14 | FTDX | Futures | 727.4 | 731.7 | 727.4 | 728.8 | 2460.0 |
| 2012-03-14 | FTI | Futures | 281.06 | 281.99 | 279.84 | 280.64 | 29550.0 |
| 2012-03-14 | FTUK | Futures | 4329.7 | 4339.9 | 4291.0 | 4305.2 | 138285.0 |
| 2012-03-14 | FVSA | Futures | 8218.0 | 8335.16 | 8050.63 | 8201.26 | 9964.0 |
| 2012-03-14 | FXXP | Futures | 192.5 | 193.4 | 192.3 | 192.6 | 11504.0 |
| 2012-03-14 | G | Futures | 93.62 | 93.67 | 92.33 | 92.63 | 199628.0 |
| 2012-03-14 | GF | Futures | 330.251 | 330.356 | 328.524 | 329.1 | 1890.0 |
| 2012-03-14 | GSCI | Futures | 1116.47 | 1123.36 | 1110.77 | 1114.41 | 585.0 |
| 2012-03-14 | HE | Futures | 105.954 | 106.196 | 105.531 | 105.622 | 14844.0 |
| 2012-03-14 | HG | Futures | 5.1288 | 5.1367 | 5.0154 | 5.0449 | 44048.0 |
| 2012-03-14 | HO | Futures | 2.7048 | 2.7257 | 2.687 | 2.6946 | 20960.0 |
| 2012-03-14 | HRC | Futures | 2719.2 | 2719.2 | 2719.2 | 2719.2 | 0.0 |
| 2012-03-14 | J1 | Futures | 0.0151407 | 0.015142 | 0.0149689 | 0.0149928 | 57892.0 |
| 2012-03-14 | J7 | Futures | 0.015059 | 0.015059 | 0.014902 | 0.014922 | 147.0 |
> showing 50 of 97 rows — these rows as CSV