PREVIEW / futures_daily / 2010-02-04
file: by_date/futures_daily/2010/2010-02-04.parquet size: 9 KB rows: 90
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-02-04 | ES | Futures | 1062.64 | 1064.58 | 1026.78 | 1029.2 | 3302110.0 |
| 2010-02-04 | NQ | Futures | 2018.35 | 2026.84 | 1958.41 | 1962.09 | 483901.0 |
| 2010-02-04 | YM | Futures | 9353.6 | 9367.3 | 9093.3 | 9115.2 | 201473.0 |
| 2010-02-04 | CL | Futures | 182.09 | 182.27 | 171.05 | 172.76 | 523892.0 |
| 2010-02-04 | GC | Futures | 1523.1 | 1525.7 | 1453.0 | 1458.5 | 280754.0 |
| 2010-02-04 | ZN | Futures | 94.756339 | 95.436408 | 94.718557 | 95.31047 | 1220163.0 |
| 2010-02-04 | A6 | Futures | 0.71364 | 0.71445 | 0.69666 | 0.70113 | 155200.0 |
| 2010-02-04 | AD | Futures | 0.9296 | 0.93167 | 0.91785 | 0.92101 | 101088.0 |
| 2010-02-04 | B | Futures | 68.68 | 68.68 | 64.43 | 65.05 | 146376.0 |
| 2010-02-04 | B6 | Futures | 1.6512 | 1.6532 | 1.6333 | 1.6361 | 165376.0 |
| 2010-02-04 | BFX | Futures | 2852.2 | 2866.2 | 2767.1 | 2773.1 | 344.0 |
| 2010-02-04 | BR | Futures | 0.21256 | 0.21322 | 0.21256 | 0.21322 | 154.0 |
| 2010-02-04 | C | Futures | 2275.0 | 2292.0 | 2262.0 | 2283.0 | 3987.0 |
| 2010-02-04 | CB | Futures | 70.57 | 70.57 | 70.57 | 70.57 | 20.0 |
| 2010-02-04 | CC | Futures | 2684.0 | 2692.0 | 2619.0 | 2645.0 | 9789.0 |
| 2010-02-04 | CT | Futures | 56.92 | 57.11 | 55.61 | 56.25 | 10586.0 |
| 2010-02-04 | DC | Futures | 22.43 | 22.46 | 22.13 | 22.41 | 137.0 |
| 2010-02-04 | DX | Futures | 80.984 | 81.584 | 80.857 | 81.432 | 28966.0 |
| 2010-02-04 | E1 | Futures | 1.24594 | 1.24647 | 1.23539 | 1.23803 | 66572.0 |
| 2010-02-04 | E6 | Futures | 1.64461 | 1.64568 | 1.62449 | 1.62697 | 409551.0 |
| 2010-02-04 | E7 | Futures | 1.6328 | 1.6342 | 1.6134 | 1.6157 | 3548.0 |
| 2010-02-04 | EBM | Futures | 211.66 | 212.93 | 211.66 | 212.5 | 4125.0 |
| 2010-02-04 | ED | Futures | 94.3725 | 94.3867 | 94.3725 | 94.3725 | 182048.0 |
| 2010-02-04 | ER | Futures | 97.301 | 97.321 | 97.301 | 97.311 | 132849.0 |
| 2010-02-04 | EW | Futures | 699.6 | 701.0 | 674.6 | 677.1 | 41815.0 |
| 2010-02-04 | FBTP | Futures | 63.26 | 63.48 | 63.08 | 63.39 | 9469.0 |
| 2010-02-04 | FCE | Futures | 2477.5 | 2479.1 | 2385.7 | 2403.6 | 167596.0 |
| 2010-02-04 | FDAX | Futures | 6221.0 | 6224.2 | 6015.6 | 6044.5 | 228064.0 |
| 2010-02-04 | FESX | Futures | 1685.0 | 1685.0 | 1609.6 | 1622.2 | 2176307.0 |
| 2010-02-04 | FEU3 | Futures | 97.874 | 97.874 | 97.874 | 97.874 | 1892.0 |
| 2010-02-04 | FGBL | Futures | 94.85 | 95.57 | 94.84 | 95.38 | 1210006.0 |
| 2010-02-04 | FGBM | Futures | 100.64 | 101.19 | 100.63 | 101.01 | 634957.0 |
| 2010-02-04 | FGBS | Futures | 105.659 | 105.883 | 105.649 | 105.795 | 748992.0 |
| 2010-02-04 | FGBX | Futures | 89.1 | 89.84 | 88.85 | 89.62 | 2636.0 |
| 2010-02-04 | FTDX | Futures | 726.1 | 726.1 | 697.4 | 702.7 | 1358.0 |
| 2010-02-04 | FTI | Futures | 270.26 | 270.54 | 259.98 | 261.93 | 47590.0 |
| 2010-02-04 | FTUK | Futures | 3495.2 | 3496.2 | 3390.0 | 3417.8 | 157887.0 |
| 2010-02-04 | G | Futures | 75.99 | 76.27 | 75.72 | 76.07 | 137686.0 |
| 2010-02-04 | GF | Futures | 263.299 | 264.177 | 262.421 | 262.691 | 3564.0 |
| 2010-02-04 | GSCI | Futures | 937.2 | 937.2 | 902.63 | 906.36 | 1633.0 |
| 2010-02-04 | HE | Futures | 89.286 | 89.888 | 88.449 | 89.553 | 9440.0 |
| 2010-02-04 | HG | Futures | 4.1117 | 4.1676 | 3.94 | 3.9717 | 42321.0 |
| 2010-02-04 | HO | Futures | 1.8813 | 1.8862 | 1.7845 | 1.8015 | 59532.0 |
| 2010-02-04 | J1 | Futures | 0.0138327 | 0.014214 | 0.0138189 | 0.0141133 | 218018.0 |
| 2010-02-04 | J7 | Futures | 0.013662 | 0.014033 | 0.013648 | 0.013937 | 241.0 |
| 2010-02-04 | JB | Futures | 117.42 | 117.42 | 117.08 | 117.26 | 2189.0 |
| 2010-02-04 | KC | Futures | 345.54 | 346.58 | 338.51 | 342.42 | 13757.0 |
| 2010-02-04 | KE | Futures | 2194.51 | 2229.56 | 2171.9 | 2209.21 | 10357.0 |
| 2010-02-04 | KRW | Futures | 0.000839 | 0.0008494 | 0.0008348 | 0.0008494 | 30.0 |
| 2010-02-04 | L | Futures | 97.848 | 97.868 | 97.829 | 97.838 | 74451.0 |
> showing 50 of 90 rows — these rows as CSV