PREVIEW / futures_daily / 2009-03-16
file: by_date/futures_daily/2009/2009-03-16.parquet size: 9 KB rows: 87
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 |
|---|---|---|---|---|---|---|---|
| 2009-03-16 | ES | Futures | 715.53 | 735.31 | 711.25 | 718.63 | 2848135.0 |
| 2009-03-16 | NQ | Futures | 1307.49 | 1325.74 | 1283.33 | 1294.57 | 386080.0 |
| 2009-03-16 | YM | Futures | 6417.9 | 6582.1 | 6382.1 | 6443.1 | 196954.0 |
| 2009-03-16 | CL | Futures | 130.2 | 135.57 | 125.54 | 134.89 | 160952.0 |
| 2009-03-16 | GC | Futures | 1288.2 | 1291.4 | 1270.2 | 1279.5 | 84779.0 |
| 2009-03-16 | ZN | Futures | 94.852071 | 94.973442 | 94.184526 | 94.402995 | 572546.0 |
| 2009-03-16 | A6 | Futures | 0.51998 | 0.52692 | 0.51783 | 0.525 | 32325.0 |
| 2009-03-16 | AD | Futures | 0.77406 | 0.78007 | 0.77042 | 0.77682 | 30728.0 |
| 2009-03-16 | B | Futures | 44.27 | 45.75 | 42.56 | 45.48 | 106552.0 |
| 2009-03-16 | B6 | Futures | 1.4526 | 1.4815 | 1.4458 | 1.4667 | 67443.0 |
| 2009-03-16 | BFX | Futures | 1853.3 | 1860.4 | 1846.3 | 1860.4 | 1405.0 |
| 2009-03-16 | BR | Futures | 0.16442 | 0.16442 | 0.16442 | 0.16442 | 50.0 |
| 2009-03-16 | BZ | Futures | 44.94 | 47.71 | 44.75 | 47.44 | 83.0 |
| 2009-03-16 | C | Futures | 1902.0 | 1928.0 | 1885.0 | 1904.0 | 5950.0 |
| 2009-03-16 | CB | Futures | 78.241 | 78.392 | 78.241 | 78.392 | 12.0 |
| 2009-03-16 | CC | Futures | 2101.0 | 2147.0 | 2096.0 | 2136.0 | 7165.0 |
| 2009-03-16 | CT | Futures | 40.34 | 41.1 | 40.34 | 40.61 | 6459.0 |
| 2009-03-16 | DC | Futures | 28.39 | 29.39 | 28.39 | 29.01 | 175.0 |
| 2009-03-16 | DX | Futures | 90.67 | 90.886 | 89.496 | 90.026 | 7234.0 |
| 2009-03-16 | E1 | Futures | 1.11816 | 1.12572 | 1.11511 | 1.12015 | 22249.0 |
| 2009-03-16 | E6 | Futures | 1.52906 | 1.55004 | 1.52171 | 1.53925 | 188864.0 |
| 2009-03-16 | E7 | Futures | 1.5083 | 1.5317 | 1.5044 | 1.5214 | 1622.0 |
| 2009-03-16 | EBM | Futures | 212.85 | 216.72 | 211.31 | 214.79 | 3566.0 |
| 2009-03-16 | ED | Futures | 92.9879 | 92.9879 | 92.9314 | 92.9502 | 199296.0 |
| 2009-03-16 | ER | Futures | 96.508 | 96.522 | 96.493 | 96.508 | 162293.0 |
| 2009-03-16 | EW | Futures | 437.2 | 446.4 | 431.1 | 434.8 | 51831.0 |
| 2009-03-16 | FCE | Futures | 1739.7 | 1779.6 | 1739.7 | 1771.4 | 106855.0 |
| 2009-03-16 | FDAX | Futures | 4372.7 | 4447.0 | 4348.1 | 4401.6 | 168011.0 |
| 2009-03-16 | FESX | Futures | 1159.3 | 1186.9 | 1158.1 | 1174.3 | 696220.0 |
| 2009-03-16 | FEU3 | Futures | 97.086 | 97.091 | 97.076 | 97.086 | 4028.0 |
| 2009-03-16 | FGBL | Futures | 93.25 | 93.26 | 92.85 | 92.98 | 538538.0 |
| 2009-03-16 | FGBM | Futures | 97.95 | 97.97 | 97.74 | 97.89 | 353449.0 |
| 2009-03-16 | FGBS | Futures | 103.719 | 103.743 | 103.656 | 103.733 | 258486.0 |
| 2009-03-16 | FGBX | Futures | 82.7 | 82.8 | 82.12 | 82.39 | 1164.0 |
| 2009-03-16 | FTDX | Futures | 391.2 | 395.7 | 386.7 | 391.2 | 1805.0 |
| 2009-03-16 | FTI | Futures | 174.77 | 177.28 | 173.45 | 176.04 | 12077.0 |
| 2009-03-16 | FTUK | Futures | 2512.9 | 2561.2 | 2488.6 | 2535.6 | 159943.0 |
| 2009-03-16 | G | Futures | 78.98 | 79.12 | 78.54 | 78.61 | 58692.0 |
| 2009-03-16 | GF | Futures | 257.875 | 258.294 | 255.851 | 256.968 | 850.0 |
| 2009-03-16 | GSCI | Futures | 713.45 | 742.37 | 711.75 | 740.03 | 146.0 |
| 2009-03-16 | HE | Futures | 121.591 | 122.655 | 119.997 | 121.302 | 6116.0 |
| 2009-03-16 | HG | Futures | 2.3485 | 2.4725 | 2.338 | 2.4612 | 18239.0 |
| 2009-03-16 | HO | Futures | 1.3081 | 1.3753 | 1.2853 | 1.3632 | 6258.0 |
| 2009-03-16 | HRC | Futures | 2833.7 | 2833.7 | 2833.7 | 2833.7 | 0.0 |
| 2009-03-16 | J1 | Futures | 0.012866 | 0.0129429 | 0.012798 | 0.0128484 | 47716.0 |
| 2009-03-16 | J7 | Futures | 0.012647 | 0.012716 | 0.012622 | 0.012674 | 36.0 |
| 2009-03-16 | JB | Futures | 115.93 | 116.41 | 115.91 | 116.31 | 1282.0 |
| 2009-03-16 | KC | Futures | 307.88 | 314.49 | 305.49 | 311.54 | 6413.0 |
| 2009-03-16 | KE | Futures | 2800.26 | 2949.39 | 2779.31 | 2944.46 | 7833.0 |
| 2009-03-16 | L | Futures | 96.581 | 96.63 | 96.541 | 96.59 | 43099.0 |
> showing 50 of 87 rows — these rows as CSV