PREVIEW / futures_daily / 2011-01-14
file: by_date/futures_daily/2011/2011-01-14.parquet size: 9 KB rows: 93
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 |
|---|---|---|---|---|---|---|---|
| 2011-01-14 | ES | Futures | 1261.17 | 1269.78 | 1254.28 | 1269.29 | 1631162.0 |
| 2011-01-14 | NQ | Futures | 2615.46 | 2637.31 | 2608.36 | 2633.91 | 177966.0 |
| 2011-01-14 | YM | Futures | 10941.0 | 10987.8 | 10882.0 | 10973.8 | 89003.0 |
| 2011-01-14 | CL | Futures | 187.3 | 188.53 | 185.47 | 188.32 | 238650.0 |
| 2011-01-14 | GC | Futures | 1867.1 | 1872.8 | 1841.2 | 1849.3 | 200388.0 |
| 2011-01-14 | ZN | Futures | 100.712517 | 101.063477 | 100.478544 | 100.543536 | 1123821.0 |
| 2011-01-14 | A6 | Futures | 0.84088 | 0.84122 | 0.8296 | 0.83299 | 102608.0 |
| 2011-01-14 | AD | Futures | 1.00207 | 1.00267 | 0.99354 | 1.00178 | 83226.0 |
| 2011-01-14 | B | Futures | 82.83 | 84.09 | 82.41 | 83.78 | 210318.0 |
| 2011-01-14 | B6 | Futures | 1.6417 | 1.6475 | 1.6393 | 1.6468 | 114305.0 |
| 2011-01-14 | BR | Futures | 0.25332 | 0.25411 | 0.25297 | 0.253 | 794.0 |
| 2011-01-14 | BZ | Futures | 88.44 | 89.31 | 88.44 | 89.24 | 391.0 |
| 2011-01-14 | C | Futures | 2152.0 | 2197.0 | 2135.0 | 2192.0 | 8509.0 |
| 2011-01-14 | CB | Futures | 116.162 | 117.335 | 116.162 | 117.321 | 4.0 |
| 2011-01-14 | CC | Futures | 2410.0 | 2475.0 | 2384.0 | 2450.0 | 10464.0 |
| 2011-01-14 | CSC | Futures | 3.537 | 3.54 | 3.537 | 3.537 | 2.0 |
| 2011-01-14 | CT | Futures | 123.48 | 125.15 | 121.07 | 121.28 | 11946.0 |
| 2011-01-14 | DC | Futures | 24.57 | 24.9 | 24.56 | 24.82 | 460.0 |
| 2011-01-14 | DX | Futures | 79.272 | 79.462 | 78.828 | 79.223 | 22289.0 |
| 2011-01-14 | E1 | Futures | 1.35975 | 1.36526 | 1.35359 | 1.3591 | 41642.0 |
| 2011-01-14 | E6 | Futures | 1.57877 | 1.59155 | 1.57463 | 1.57972 | 358114.0 |
| 2011-01-14 | E7 | Futures | 1.5671 | 1.5797 | 1.5629 | 1.568 | 6785.0 |
| 2011-01-14 | EBM | Futures | 230.59 | 230.59 | 224.23 | 227.86 | 8342.0 |
| 2011-01-14 | ED | Futures | 94.8242 | 94.8289 | 94.8194 | 94.8242 | 146443.0 |
| 2011-01-14 | ER | Futures | 97.276 | 97.291 | 97.257 | 97.271 | 219261.0 |
| 2011-01-14 | EW | Futures | 909.9 | 916.7 | 904.1 | 916.5 | 15355.0 |
| 2011-01-14 | FBTP | Futures | 64.18 | 64.49 | 64.06 | 64.31 | 6756.0 |
| 2011-01-14 | FCE | Futures | 2649.1 | 2675.8 | 2640.7 | 2660.8 | 4357.0 |
| 2011-01-14 | FDAX | Futures | 7561.3 | 7614.3 | 7520.6 | 7592.4 | 121166.0 |
| 2011-01-14 | FESX | Futures | 1802.9 | 1824.7 | 1793.0 | 1814.7 | 1074008.0 |
| 2011-01-14 | FEU3 | Futures | 97.825 | 97.845 | 97.825 | 97.83 | 9.0 |
| 2011-01-14 | FGBL | Futures | 98.88 | 99.13 | 98.59 | 98.92 | 916044.0 |
| 2011-01-14 | FGBM | Futures | 104.25 | 104.4 | 104.09 | 104.26 | 555455.0 |
| 2011-01-14 | FGBS | Futures | 107.065 | 107.119 | 106.986 | 107.01 | 740242.0 |
| 2011-01-14 | FGBX | Futures | 97.25 | 98.23 | 97.01 | 97.59 | 5002.0 |
| 2011-01-14 | FTDX | Futures | 772.3 | 774.5 | 767.9 | 773.2 | 446.0 |
| 2011-01-14 | FTI | Futures | 289.19 | 291.69 | 287.9 | 290.64 | 3926.0 |
| 2011-01-14 | FTUK | Futures | 4153.0 | 4165.9 | 4103.4 | 4140.2 | 101551.0 |
| 2011-01-14 | FXXP | Futures | 182.6 | 183.6 | 182.4 | 183.6 | 479.0 |
| 2011-01-14 | G | Futures | 80.9 | 81.0 | 80.59 | 80.82 | 89373.0 |
| 2011-01-14 | GF | Futures | 312.781 | 314.816 | 311.794 | 314.014 | 2239.0 |
| 2011-01-14 | GSCI | Futures | 1015.79 | 1026.3 | 1015.79 | 1025.5 | 1609.0 |
| 2011-01-14 | HE | Futures | 100.831 | 101.082 | 99.138 | 99.734 | 13622.0 |
| 2011-01-14 | HG | Futures | 5.8027 | 5.9166 | 5.7927 | 5.88 | 32948.0 |
| 2011-01-14 | HO | Futures | 2.195 | 2.2158 | 2.1758 | 2.215 | 29900.0 |
| 2011-01-14 | HRC | Futures | 2744.7 | 2744.7 | 2744.7 | 2744.7 | 0.0 |
| 2011-01-14 | J1 | Futures | 0.0151775 | 0.0152453 | 0.0151247 | 0.0151373 | 123473.0 |
| 2011-01-14 | J7 | Futures | 0.015072 | 0.015134 | 0.015018 | 0.01503 | 132.0 |
| 2011-01-14 | JB | Futures | 121.02 | 121.29 | 120.92 | 120.95 | 1739.0 |
| 2011-01-14 | KC | Futures | 583.64 | 586.46 | 567.82 | 575.3 | 13219.0 |
> showing 50 of 93 rows — these rows as CSV