PREVIEW / futures_daily / 2010-12-31
file: by_date/futures_daily/2010/2010-12-31.parquet size: 8 KB rows: 82
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-31 | ES | Futures | 1234.59 | 1238.03 | 1229.91 | 1233.36 | 667046.0 |
| 2010-12-31 | NQ | Futures | 2526.34 | 2530.59 | 2506.18 | 2515.83 | 100071.0 |
| 2010-12-31 | YM | Futures | 10780.0 | 10817.5 | 10732.3 | 10775.3 | 30888.0 |
| 2010-12-31 | CL | Futures | 183.76 | 188.66 | 182.49 | 187.26 | 171010.0 |
| 2010-12-31 | GC | Futures | 1909.8 | 1932.9 | 1909.2 | 1932.0 | 44808.0 |
| 2010-12-31 | ZN | Futures | 99.828618 | 100.231572 | 99.776624 | 100.192576 | 200271.0 |
| 2010-12-31 | A6 | Futures | 0.85479 | 0.86216 | 0.85326 | 0.85987 | 27516.0 |
| 2010-12-31 | AD | Futures | 0.99106 | 0.9985 | 0.99016 | 0.99681 | 33281.0 |
| 2010-12-31 | B | Futures | 79.14 | 80.99 | 78.42 | 80.62 | 34316.0 |
| 2010-12-31 | B6 | Futures | 1.5995 | 1.6244 | 1.5992 | 1.6163 | 47158.0 |
| 2010-12-31 | BFX | Futures | 2989.4 | 2991.7 | 2973.2 | 2973.2 | 47.0 |
| 2010-12-31 | BR | Futures | 0.25601 | 0.25601 | 0.25601 | 0.25601 | 13.0 |
| 2010-12-31 | BZ | Futures | 85.87 | 85.87 | 85.87 | 85.87 | 86.0 |
| 2010-12-31 | C | Futures | 2218.0 | 2233.0 | 2186.0 | 2204.0 | 5325.0 |
| 2010-12-31 | CB | Futures | 102.668 | 102.668 | 102.668 | 102.668 | 2.0 |
| 2010-12-31 | CC | Futures | 2459.0 | 2473.0 | 2425.0 | 2463.0 | 2881.0 |
| 2010-12-31 | CT | Futures | 123.48 | 125.92 | 123.08 | 124.17 | 5421.0 |
| 2010-12-31 | DC | Futures | 23.29 | 23.37 | 22.93 | 23.06 | 218.0 |
| 2010-12-31 | DX | Futures | 79.621 | 79.626 | 78.883 | 79.145 | 11836.0 |
| 2010-12-31 | E1 | Futures | 1.40301 | 1.41061 | 1.39593 | 1.40432 | 16279.0 |
| 2010-12-31 | E6 | Futures | 1.57191 | 1.588 | 1.57156 | 1.58102 | 89767.0 |
| 2010-12-31 | E7 | Futures | 1.5603 | 1.5761 | 1.5597 | 1.5693 | 2800.0 |
| 2010-12-31 | EBM | Futures | 222.42 | 226.05 | 222.19 | 225.82 | 1107.0 |
| 2010-12-31 | ED | Futures | 94.8099 | 94.8194 | 94.8004 | 94.8147 | 54158.0 |
| 2010-12-31 | ER | Futures | 97.385 | 97.429 | 97.38 | 97.39 | 25923.0 |
| 2010-12-31 | EW | Futures | 898.0 | 901.3 | 891.8 | 891.8 | 9441.0 |
| 2010-12-31 | FCE | Futures | 2574.3 | 2578.0 | 2539.6 | 2541.9 | 22356.0 |
| 2010-12-31 | FTI | Futures | 285.64 | 286.2 | 283.2 | 283.92 | 4242.0 |
| 2010-12-31 | FTUK | Futures | 4115.2 | 4132.5 | 4081.8 | 4094.3 | 21889.0 |
| 2010-12-31 | G | Futures | 81.6 | 82.12 | 81.58 | 82.09 | 21264.0 |
| 2010-12-31 | GF | Futures | 301.731 | 304.471 | 300.859 | 303.599 | 380.0 |
| 2010-12-31 | GSCI | Futures | 1009.1 | 1029.46 | 1007.97 | 1028.57 | 327.0 |
| 2010-12-31 | HE | Futures | 99.201 | 100.33 | 98.856 | 100.016 | 8893.0 |
| 2010-12-31 | HG | Futures | 5.824 | 5.9333 | 5.8207 | 5.9266 | 12115.0 |
| 2010-12-31 | HO | Futures | 2.0928 | 2.1471 | 2.076 | 2.1313 | 11310.0 |
| 2010-12-31 | HRC | Futures | 2615.9 | 2615.9 | 2615.9 | 2615.9 | 0.0 |
| 2010-12-31 | J1 | Futures | 0.0154148 | 0.0155278 | 0.015411 | 0.0154814 | 32686.0 |
| 2010-12-31 | J7 | Futures | 0.015316 | 0.015415 | 0.015304 | 0.015371 | 333.0 |
| 2010-12-31 | KC | Futures | 580.94 | 591.73 | 579.47 | 589.77 | 3206.0 |
| 2010-12-31 | KE | Futures | 3439.05 | 3487.95 | 3426.83 | 3467.58 | 5731.0 |
| 2010-12-31 | L | Futures | 98.155 | 98.165 | 98.145 | 98.165 | 10285.0 |
| 2010-12-31 | LBS | Futures | 832.6 | 843.0 | 829.8 | 829.8 | 345.0 |
| 2010-12-31 | LE | Futures | 163.348 | 164.788 | 163.045 | 164.258 | 14759.0 |
| 2010-12-31 | MFS | Futures | 1331.1 | 1346.9 | 1329.9 | 1340.3 | 514.0 |
| 2010-12-31 | MGC | Futures | 1897.8 | 1915.2 | 1896.0 | 1914.8 | 232.0 |
| 2010-12-31 | MME | Futures | 962.8 | 969.6 | 960.7 | 969.6 | 566.0 |
| 2010-12-31 | MP | Futures | 0.04447 | 0.04468 | 0.04439 | 0.04463 | 11521.0 |
| 2010-12-31 | N6 | Futures | 0.62171 | 0.63064 | 0.62171 | 0.62885 | 2728.0 |
| 2010-12-31 | NG | Futures | 115.897 | 119.354 | 115.388 | 118.041 | 65874.0 |
| 2010-12-31 | NIY | Futures | 8215.4 | 8223.5 | 8155.0 | 8223.5 | 1900.0 |
> showing 50 of 82 rows — these rows as CSV