PREVIEW / futures_daily / 2010-06-25
file: by_date/futures_daily/2010/2010-06-25.parquet size: 9 KB rows: 88
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-06-25 | ES | Futures | 1043.87 | 1052.89 | 1036.56 | 1048.26 | 2454671.0 |
| 2010-06-25 | NQ | Futures | 2089.35 | 2101.23 | 2068.13 | 2081.71 | 323580.0 |
| 2010-06-25 | YM | Futures | 9334.7 | 9376.3 | 9264.4 | 9342.0 | 156873.0 |
| 2010-06-25 | CL | Futures | 163.52 | 169.13 | 162.11 | 168.43 | 316456.0 |
| 2010-06-25 | GC | Futures | 1697.6 | 1718.0 | 1693.6 | 1713.5 | 91013.0 |
| 2010-06-25 | ZN | Futures | 99.351026 | 99.824858 | 99.261382 | 99.568733 | 1095906.0 |
| 2010-06-25 | A6 | Futures | 0.71165 | 0.71944 | 0.70593 | 0.71844 | 103509.0 |
| 2010-06-25 | AD | Futures | 0.94639 | 0.95488 | 0.9452 | 0.9531 | 75907.0 |
| 2010-06-25 | B | Futures | 67.1 | 69.0 | 66.53 | 68.65 | 58804.0 |
| 2010-06-25 | B6 | Futures | 1.5486 | 1.565 | 1.5416 | 1.5606 | 114887.0 |
| 2010-06-25 | BFX | Futures | 2802.7 | 2820.8 | 2777.7 | 2790.5 | 323.0 |
| 2010-06-25 | BZ | Futures | 72.37 | 73.67 | 72.37 | 73.36 | 85.0 |
| 2010-06-25 | C | Futures | 2525.0 | 2542.0 | 2501.0 | 2537.0 | 2867.0 |
| 2010-06-25 | CB | Futures | 82.57 | 82.57 | 82.57 | 82.57 | 5.0 |
| 2010-06-25 | CC | Futures | 2597.0 | 2611.0 | 2555.0 | 2596.0 | 6241.0 |
| 2010-06-25 | CT | Futures | 67.5 | 67.73 | 67.34 | 67.48 | 85.0 |
| 2010-06-25 | DC | Futures | 22.13 | 22.52 | 22.09 | 22.51 | 146.0 |
| 2010-06-25 | DX | Futures | 86.681 | 87.099 | 86.197 | 86.257 | 18523.0 |
| 2010-06-25 | E1 | Futures | 1.19355 | 1.20419 | 1.19066 | 1.20235 | 38745.0 |
| 2010-06-25 | E6 | Futures | 1.45884 | 1.46653 | 1.44974 | 1.46546 | 299215.0 |
| 2010-06-25 | E7 | Futures | 1.4482 | 1.4559 | 1.4392 | 1.4549 | 4481.0 |
| 2010-06-25 | ED | Futures | 94.2142 | 94.2569 | 94.2142 | 94.2474 | 159026.0 |
| 2010-06-25 | ER | Futures | 97.301 | 97.311 | 97.281 | 97.286 | 103840.0 |
| 2010-06-25 | EW | Futures | 720.9 | 731.2 | 716.4 | 730.0 | 31698.0 |
| 2010-06-25 | FBTP | Futures | 64.85 | 64.93 | 64.65 | 64.77 | 3793.0 |
| 2010-06-25 | FCE | Futures | 2350.0 | 2352.7 | 2303.3 | 2315.1 | 143738.0 |
| 2010-06-25 | FDAX | Futures | 6681.8 | 6698.7 | 6577.4 | 6614.3 | 153175.0 |
| 2010-06-25 | FESX | Futures | 1640.8 | 1647.0 | 1616.7 | 1626.0 | 1277309.0 |
| 2010-06-25 | FEU3 | Futures | 97.864 | 97.864 | 97.845 | 97.845 | 25.0 |
| 2010-06-25 | FGBL | Futures | 100.67 | 100.87 | 100.58 | 100.73 | 574729.0 |
| 2010-06-25 | FGBM | Futures | 105.28 | 105.41 | 105.22 | 105.28 | 290123.0 |
| 2010-06-25 | FGBS | Futures | 107.677 | 107.731 | 107.628 | 107.647 | 316138.0 |
| 2010-06-25 | FGBX | Futures | 99.33 | 99.89 | 99.26 | 99.37 | 2300.0 |
| 2010-06-25 | FTDX | Futures | 670.8 | 672.5 | 659.8 | 663.3 | 419.0 |
| 2010-06-25 | FTI | Futures | 261.7 | 261.86 | 257.66 | 258.49 | 37067.0 |
| 2010-06-25 | FTUK | Futures | 3495.2 | 3509.3 | 3439.4 | 3457.0 | 105788.0 |
| 2010-06-25 | G | Futures | 81.02 | 81.18 | 80.9 | 81.1 | 70911.0 |
| 2010-06-25 | GF | Futures | 285.076 | 286.718 | 284.76 | 285.96 | 1720.0 |
| 2010-06-25 | GSCI | Futures | 858.74 | 876.93 | 858.74 | 875.99 | 153.0 |
| 2010-06-25 | HE | Futures | 100.665 | 101.071 | 99.852 | 101.009 | 4526.0 |
| 2010-06-25 | HG | Futures | 4.0386 | 4.1772 | 4.0004 | 4.1665 | 23757.0 |
| 2010-06-25 | HO | Futures | 1.8453 | 1.8939 | 1.8284 | 1.8896 | 18374.0 |
| 2010-06-25 | HRC | Futures | 2970.6 | 2970.6 | 2970.6 | 2970.6 | 0.0 |
| 2010-06-25 | J1 | Futures | 0.0140556 | 0.0141411 | 0.0140304 | 0.014092 | 113865.0 |
| 2010-06-25 | J7 | Futures | 0.013944 | 0.014011 | 0.013926 | 0.013986 | 155.0 |
| 2010-06-25 | JB | Futures | 120.2 | 120.39 | 120.08 | 120.14 | 817.0 |
| 2010-06-25 | KC | Futures | 423.92 | 429.07 | 416.89 | 424.17 | 10904.0 |
| 2010-06-25 | KE | Futures | 2146.67 | 2151.99 | 2102.99 | 2108.31 | 7848.0 |
| 2010-06-25 | L | Futures | 98.007 | 98.026 | 97.997 | 98.026 | 18982.0 |
| 2010-06-25 | LBS | Futures | 553.4 | 592.4 | 553.4 | 584.7 | 281.0 |
> showing 50 of 88 rows — these rows as CSV