PREVIEW / futures_daily / 2012-04-02
file: by_date/futures_daily/2012/2012-04-02.parquet size: 9 KB rows: 98
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-04-02 | ES | Futures | 1418.11 | 1428.69 | 1409.79 | 1423.4 | 1718652.0 |
| 2012-04-02 | NQ | Futures | 3159.9 | 3189.4 | 3143.28 | 3181.66 | 210984.0 |
| 2012-04-02 | YM | Futures | 12808.7 | 12865.1 | 12722.1 | 12826.2 | 111056.0 |
| 2012-04-02 | CL | Futures | 190.37 | 194.46 | 188.14 | 193.98 | 278097.0 |
| 2012-04-02 | GC | Futures | 2234.5 | 2253.0 | 2225.0 | 2245.4 | 110017.0 |
| 2012-04-02 | ZN | Futures | 112.14863 | 112.581846 | 111.918485 | 112.378776 | 979399.0 |
| 2012-04-02 | A6 | Futures | 0.93158 | 0.93239 | 0.92465 | 0.9314 | 112436.0 |
| 2012-04-02 | AD | Futures | 1.00813 | 1.01577 | 1.00541 | 1.01567 | 85982.0 |
| 2012-04-02 | B | Futures | 110.46 | 113.04 | 109.41 | 112.84 | 143892.0 |
| 2012-04-02 | B6 | Futures | 1.6795 | 1.6852 | 1.6764 | 1.683 | 90454.0 |
| 2012-04-02 | BFX | Futures | 2851.5 | 2870.3 | 2833.9 | 2870.3 | 4.0 |
| 2012-04-02 | BR | Futures | 0.25817 | 0.25817 | 0.25745 | 0.25745 | 21.0 |
| 2012-04-02 | BZ | Futures | 116.23 | 119.36 | 116.23 | 119.36 | 415.0 |
| 2012-04-02 | C | Futures | 1471.0 | 1499.0 | 1447.0 | 1448.0 | 5907.0 |
| 2012-04-02 | CB | Futures | 78.312 | 78.582 | 78.178 | 78.312 | 9.0 |
| 2012-04-02 | CC | Futures | 1692.0 | 1730.0 | 1645.0 | 1664.0 | 22683.0 |
| 2012-04-02 | CSC | Futures | 3.705 | 3.714 | 3.705 | 3.714 | 6.0 |
| 2012-04-02 | CT | Futures | 117.04 | 117.26 | 115.2 | 116.54 | 13655.0 |
| 2012-04-02 | DC | Futures | 26.3 | 26.33 | 25.91 | 26.3 | 103.0 |
| 2012-04-02 | DX | Futures | 76.576 | 76.809 | 76.465 | 76.506 | 19340.0 |
| 2012-04-02 | E1 | Futures | 1.45432 | 1.45576 | 1.44463 | 1.45092 | 34246.0 |
| 2012-04-02 | E6 | Futures | 1.59545 | 1.59808 | 1.58566 | 1.59223 | 240814.0 |
| 2012-04-02 | E7 | Futures | 1.5801 | 1.5826 | 1.5706 | 1.577 | 3156.0 |
| 2012-04-02 | EBM | Futures | 288.05 | 288.73 | 286.03 | 287.04 | 9896.0 |
| 2012-04-02 | ED | Futures | 95.074 | 95.0788 | 95.0693 | 95.074 | 67028.0 |
| 2012-04-02 | ER | Futures | 97.523 | 97.533 | 97.508 | 97.528 | 57598.0 |
| 2012-04-02 | EW | Futures | 1004.4 | 1013.9 | 997.4 | 1007.9 | 26141.0 |
| 2012-04-02 | FBTP | Futures | 68.29 | 68.77 | 68.12 | 68.23 | 9904.0 |
| 2012-04-02 | FBTS | Futures | 85.648 | 85.835 | 85.559 | 85.591 | 2277.0 |
| 2012-04-02 | FCE | Futures | 2432.0 | 2466.1 | 2408.3 | 2454.7 | 140809.0 |
| 2012-04-02 | FDAX | Futures | 7718.8 | 7852.5 | 7652.4 | 7811.6 | 173502.0 |
| 2012-04-02 | FESX | Futures | 1667.5 | 1687.5 | 1644.7 | 1677.2 | 1243725.0 |
| 2012-04-02 | FGBL | Futures | 113.07 | 113.61 | 112.93 | 113.5 | 684911.0 |
| 2012-04-02 | FGBM | Futures | 113.58 | 113.86 | 113.46 | 113.77 | 402322.0 |
| 2012-04-02 | FGBS | Futures | 109.894 | 109.959 | 109.869 | 109.939 | 356405.0 |
| 2012-04-02 | FGBX | Futures | 117.34 | 118.4 | 116.98 | 118.14 | 5812.0 |
| 2012-04-02 | FTDX | Futures | 740.5 | 752.2 | 739.6 | 745.7 | 113.0 |
| 2012-04-02 | FTI | Futures | 272.77 | 275.99 | 270.19 | 274.84 | 45082.0 |
| 2012-04-02 | FTUK | Futures | 4189.2 | 4275.3 | 4158.6 | 4252.7 | 136191.0 |
| 2012-04-02 | FVSA | Futures | 7883.25 | 7950.2 | 7531.77 | 7531.77 | 2320.0 |
| 2012-04-02 | FXXP | Futures | 188.2 | 190.3 | 186.9 | 190.2 | 4004.0 |
| 2012-04-02 | G | Futures | 93.44 | 93.74 | 93.13 | 93.6 | 129314.0 |
| 2012-04-02 | GF | Futures | 313.035 | 314.709 | 308.901 | 312.982 | 2199.0 |
| 2012-04-02 | GSCI | Futures | 1086.87 | 1111.25 | 1083.55 | 1110.77 | 389.0 |
| 2012-04-02 | HE | Futures | 101.275 | 102.954 | 100.973 | 102.899 | 356.0 |
| 2012-04-02 | HG | Futures | 5.0475 | 5.1557 | 5.0193 | 5.1406 | 58034.0 |
| 2012-04-02 | HO | Futures | 2.6205 | 2.6827 | 2.5943 | 2.6768 | 27721.0 |
| 2012-04-02 | HRC | Futures | 2699.8 | 2699.8 | 2699.8 | 2699.8 | 0.0 |
| 2012-04-02 | J1 | Futures | 0.0151181 | 0.015325 | 0.0150605 | 0.0152686 | 123832.0 |
| 2012-04-02 | J7 | Futures | 0.015057 | 0.015253 | 0.014992 | 0.015197 | 1000.0 |
> showing 50 of 98 rows — these rows as CSV