PREVIEW / futures_daily / 2012-01-26
file: by_date/futures_daily/2012/2012-01-26.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-01-26 | ES | Futures | 1325.46 | 1334.49 | 1313.92 | 1319.94 | 2012742.0 |
| 2012-01-26 | NQ | Futures | 2813.53 | 2831.55 | 2791.23 | 2805.53 | 186795.0 |
| 2012-01-26 | YM | Futures | 12276.0 | 12365.0 | 12222.9 | 12266.4 | 97486.0 |
| 2012-01-26 | CL | Futures | 186.82 | 189.49 | 185.45 | 186.33 | 260744.0 |
| 2012-01-26 | GC | Futures | 2295.4 | 2322.7 | 2284.6 | 2316.6 | 112482.0 |
| 2012-01-26 | ZN | Futures | 113.09774 | 113.651346 | 113.043729 | 113.583833 | 1330561.0 |
| 2012-01-26 | A6 | Futures | 0.93736 | 0.94582 | 0.93692 | 0.94021 | 109398.0 |
| 2012-01-26 | AD | Futures | 0.9979 | 1.00443 | 0.9976 | 1.00111 | 98879.0 |
| 2012-01-26 | B | Futures | 98.09 | 99.47 | 98.09 | 98.51 | 97102.0 |
| 2012-01-26 | B6 | Futures | 1.6358 | 1.6444 | 1.6354 | 1.6401 | 98595.0 |
| 2012-01-26 | BFX | Futures | 2698.9 | 2707.8 | 2698.9 | 2707.8 | 5.0 |
| 2012-01-26 | BR | Futures | 0.26693 | 0.26693 | 0.26693 | 0.26693 | 331.0 |
| 2012-01-26 | BZ | Futures | 105.35 | 105.49 | 104.79 | 104.98 | 377.0 |
| 2012-01-26 | C | Futures | 1627.0 | 1639.0 | 1607.0 | 1622.0 | 4820.0 |
| 2012-01-26 | CC | Futures | 1882.0 | 1918.0 | 1882.0 | 1901.0 | 10039.0 |
| 2012-01-26 | CSC | Futures | 3.903 | 3.903 | 3.903 | 3.903 | 2.0 |
| 2012-01-26 | CT | Futures | 124.49 | 125.46 | 122.73 | 123.11 | 9101.0 |
| 2012-01-26 | DC | Futures | 28.14 | 28.39 | 27.94 | 28.21 | 245.0 |
| 2012-01-26 | DX | Futures | 77.515 | 77.525 | 77.077 | 77.391 | 28801.0 |
| 2012-01-26 | E1 | Futures | 1.42499 | 1.43431 | 1.42342 | 1.42762 | 31813.0 |
| 2012-01-26 | E6 | Futures | 1.5662 | 1.57612 | 1.56501 | 1.56704 | 279417.0 |
| 2012-01-26 | E7 | Futures | 1.5522 | 1.5617 | 1.5508 | 1.5527 | 3866.0 |
| 2012-01-26 | EBM | Futures | 273.87 | 275.5 | 272.55 | 274.19 | 8564.0 |
| 2012-01-26 | ED | Futures | 95.0581 | 95.0916 | 95.0581 | 95.082 | 210500.0 |
| 2012-01-26 | ER | Futures | 97.454 | 97.474 | 97.425 | 97.435 | 138962.0 |
| 2012-01-26 | EW | Futures | 949.3 | 955.2 | 938.0 | 942.7 | 20101.0 |
| 2012-01-26 | FBTP | Futures | 61.75 | 62.87 | 61.74 | 62.49 | 14930.0 |
| 2012-01-26 | FBTS | Futures | 82.939 | 83.244 | 82.843 | 83.148 | 2353.0 |
| 2012-01-26 | FCE | Futures | 2376.2 | 2399.3 | 2365.9 | 2393.6 | 74479.0 |
| 2012-01-26 | FDAX | Futures | 7133.3 | 7249.3 | 7104.6 | 7224.4 | 147324.0 |
| 2012-01-26 | FESX | Futures | 1629.9 | 1650.0 | 1623.2 | 1645.3 | 1037953.0 |
| 2012-01-26 | FGBL | Futures | 111.73 | 112.42 | 111.58 | 112.24 | 705113.0 |
| 2012-01-26 | FGBM | Futures | 113.01 | 113.47 | 112.9 | 113.26 | 394392.0 |
| 2012-01-26 | FGBS | Futures | 109.909 | 109.939 | 109.864 | 109.904 | 323466.0 |
| 2012-01-26 | FGBX | Futures | 115.59 | 116.34 | 115.23 | 115.96 | 7748.0 |
| 2012-01-26 | FTDX | Futures | 692.0 | 695.8 | 688.8 | 692.0 | 170.0 |
| 2012-01-26 | FTI | Futures | 268.09 | 269.84 | 266.29 | 269.22 | 33775.0 |
| 2012-01-26 | FTUK | Futures | 4124.2 | 4159.6 | 4109.1 | 4150.6 | 99702.0 |
| 2012-01-26 | FVSA | Futures | 10544.26 | 10640.29 | 10179.34 | 10294.58 | 8015.0 |
| 2012-01-26 | FXXP | Futures | 180.6 | 182.0 | 180.0 | 181.9 | 4633.0 |
| 2012-01-26 | G | Futures | 93.91 | 94.24 | 93.73 | 94.1 | 121777.0 |
| 2012-01-26 | GF | Futures | 328.287 | 328.605 | 325.689 | 325.795 | 3115.0 |
| 2012-01-26 | GSCI | Futures | 1047.24 | 1050.29 | 1037.77 | 1038.79 | 2534.0 |
| 2012-01-26 | HE | Futures | 106.558 | 107.555 | 104.444 | 104.897 | 21070.0 |
| 2012-01-26 | HG | Futures | 5.0775 | 5.1579 | 5.0524 | 5.1461 | 40982.0 |
| 2012-01-26 | HO | Futures | 2.4574 | 2.4748 | 2.4466 | 2.4639 | 60389.0 |
| 2012-01-26 | HRC | Futures | 2876.8 | 2876.8 | 2876.8 | 2876.8 | 0.0 |
| 2012-01-26 | J1 | Futures | 0.016164 | 0.0162544 | 0.0161426 | 0.0162129 | 80948.0 |
| 2012-01-26 | J7 | Futures | 0.016093 | 0.016185 | 0.016077 | 0.016146 | 283.0 |
| 2012-01-26 | JB | Futures | 124.43 | 124.69 | 124.35 | 124.68 | 3255.0 |
> showing 50 of 97 rows — these rows as CSV