PREVIEW / futures_daily / 2009-12-03
file: by_date/futures_daily/2009/2009-12-03.parquet size: 9 KB rows: 89
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-12-03 | ES | Futures | 1068.46 | 1077.38 | 1058.58 | 1059.06 | 2054949.0 |
| 2009-12-03 | NQ | Futures | 2022.32 | 2039.53 | 2006.8 | 2009.62 | 282247.0 |
| 2009-12-03 | YM | Futures | 9478.1 | 9532.6 | 9385.5 | 9398.2 | 131396.0 |
| 2009-12-03 | CL | Futures | 186.19 | 188.6 | 183.83 | 186.07 | 351788.0 |
| 2009-12-03 | GC | Futures | 1674.4 | 1689.6 | 1658.9 | 1676.9 | 222895.0 |
| 2009-12-03 | ZN | Futures | 95.99544 | 95.99544 | 95.484826 | 95.696544 | 56889.0 |
| 2009-12-03 | A6 | Futures | 0.74768 | 0.75278 | 0.7455 | 0.74906 | 94195.0 |
| 2009-12-03 | AD | Futures | 0.93789 | 0.94243 | 0.93138 | 0.93582 | 91746.0 |
| 2009-12-03 | B | Futures | 72.51 | 73.27 | 71.89 | 72.76 | 68478.0 |
| 2009-12-03 | B6 | Futures | 1.7309 | 1.7399 | 1.7199 | 1.7235 | 92306.0 |
| 2009-12-03 | BFX | Futures | 2869.8 | 2883.4 | 2856.0 | 2862.5 | 198.0 |
| 2009-12-03 | BR | Futures | 0.23172 | 0.23232 | 0.23172 | 0.23232 | 7.0 |
| 2009-12-03 | C | Futures | 2239.0 | 2276.0 | 2239.0 | 2275.0 | 2164.0 |
| 2009-12-03 | CB | Futures | 75.505 | 75.505 | 73.531 | 73.531 | 38.0 |
| 2009-12-03 | CC | Futures | 2870.0 | 2917.0 | 2870.0 | 2911.0 | 5549.0 |
| 2009-12-03 | CT | Futures | 60.21 | 61.22 | 60.21 | 60.53 | 4735.0 |
| 2009-12-03 | DC | Futures | 25.19 | 25.3 | 25.04 | 25.06 | 162.0 |
| 2009-12-03 | DX | Futures | 76.158 | 76.444 | 75.918 | 76.235 | 14420.0 |
| 2009-12-03 | E1 | Futures | 1.31879 | 1.32618 | 1.31866 | 1.32262 | 62999.0 |
| 2009-12-03 | E6 | Futures | 1.78317 | 1.79455 | 1.78305 | 1.78838 | 309711.0 |
| 2009-12-03 | E7 | Futures | 1.767 | 1.7773 | 1.7661 | 1.7712 | 3409.0 |
| 2009-12-03 | ED | Futures | 94.2805 | 94.2852 | 94.2758 | 94.2829 | 110957.0 |
| 2009-12-03 | ER | Futures | 97.154 | 97.179 | 97.144 | 97.174 | 136909.0 |
| 2009-12-03 | EW | Futures | 677.7 | 684.2 | 669.3 | 669.5 | 30782.0 |
| 2009-12-03 | FBTP | Futures | 63.32 | 63.43 | 63.22 | 63.39 | 4505.0 |
| 2009-12-03 | FCE | Futures | 2532.7 | 2546.7 | 2500.2 | 2519.4 | 100222.0 |
| 2009-12-03 | FDAX | Futures | 6343.0 | 6371.9 | 6227.7 | 6279.9 | 147015.0 |
| 2009-12-03 | FESX | Futures | 1732.2 | 1738.8 | 1703.5 | 1717.9 | 1131552.0 |
| 2009-12-03 | FEU3 | Futures | 97.722 | 97.746 | 97.722 | 97.746 | 492.0 |
| 2009-12-03 | FGBL | Futures | 94.96 | 95.12 | 94.72 | 95.06 | 1205305.0 |
| 2009-12-03 | FGBM | Futures | 100.07 | 100.09 | 99.8 | 100.07 | 1032873.0 |
| 2009-12-03 | FGBS | Futures | 105.069 | 105.113 | 104.89 | 105.065 | 1158788.0 |
| 2009-12-03 | FGBX | Futures | 88.44 | 88.61 | 88.08 | 88.58 | 22100.0 |
| 2009-12-03 | FTDX | Futures | 716.8 | 730.2 | 710.6 | 713.2 | 714.0 |
| 2009-12-03 | FTI | Futures | 260.36 | 261.55 | 257.46 | 259.38 | 29652.0 |
| 2009-12-03 | FTUK | Futures | 3557.1 | 3563.8 | 3502.4 | 3527.0 | 98093.0 |
| 2009-12-03 | G | Futures | 77.18 | 77.25 | 76.93 | 77.19 | 89421.0 |
| 2009-12-03 | GF | Futures | 254.695 | 254.966 | 251.711 | 252.525 | 2152.0 |
| 2009-12-03 | GSCI | Futures | 989.32 | 992.6 | 979.07 | 985.06 | 240.0 |
| 2009-12-03 | HE | Futures | 89.386 | 90.791 | 87.379 | 87.379 | 19549.0 |
| 2009-12-03 | HG | Futures | 4.5008 | 4.5173 | 4.4601 | 4.4766 | 21943.0 |
| 2009-12-03 | HO | Futures | 1.954 | 1.9695 | 1.9322 | 1.9582 | 6588.0 |
| 2009-12-03 | HRC | Futures | 2486.3 | 2536.5 | 2486.3 | 2536.5 | 5.0 |
| 2009-12-03 | J1 | Futures | 0.014336 | 0.0143549 | 0.0141904 | 0.0142356 | 115016.0 |
| 2009-12-03 | J7 | Futures | 0.01415 | 0.014155 | 0.01401 | 0.01405 | 75.0 |
| 2009-12-03 | JB | Futures | 118.36 | 118.39 | 118.0 | 118.07 | 1112.0 |
| 2009-12-03 | KC | Futures | 374.82 | 378.34 | 373.13 | 376.51 | 7986.0 |
| 2009-12-03 | KE | Futures | 2555.17 | 2583.44 | 2530.3 | 2541.61 | 6457.0 |
| 2009-12-03 | KRW | Futures | 0.0008517 | 0.0008551 | 0.0008517 | 0.0008544 | 80.0 |
| 2009-12-03 | L | Futures | 97.72 | 97.75 | 97.691 | 97.74 | 73986.0 |
> showing 50 of 89 rows — these rows as CSV