PREVIEW / futures_daily / 2011-04-14
file: by_date/futures_daily/2011/2011-04-14.parquet size: 9 KB rows: 95
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-04-14 | ES | Futures | 1296.17 | 1300.13 | 1285.28 | 1297.16 | 2027796.0 |
| 2011-04-14 | NQ | Futures | 2629.69 | 2633.1 | 2605.2 | 2620.29 | 291384.0 |
| 2011-04-14 | YM | Futures | 11471.1 | 11518.1 | 11383.7 | 11496.5 | 115990.0 |
| 2011-04-14 | CL | Futures | 208.01 | 210.32 | 205.1 | 209.47 | 208695.0 |
| 2011-04-14 | GC | Futures | 1973.6 | 1998.7 | 1966.9 | 1992.9 | 166787.0 |
| 2011-04-14 | ZN | Futures | 100.578867 | 100.934409 | 100.341839 | 100.460353 | 1414270.0 |
| 2011-04-14 | A6 | Futures | 0.89344 | 0.89824 | 0.89035 | 0.89739 | 87827.0 |
| 2011-04-14 | AD | Futures | 1.03277 | 1.03625 | 1.02829 | 1.03516 | 76858.0 |
| 2011-04-14 | B | Futures | 104.11 | 104.19 | 102.76 | 103.49 | 204364.0 |
| 2011-04-14 | B6 | Futures | 1.6884 | 1.7011 | 1.6873 | 1.6975 | 107846.0 |
| 2011-04-14 | BFX | Futures | 3137.0 | 3148.0 | 3101.6 | 3127.5 | 1388.0 |
| 2011-04-14 | BR | Futures | 0.2748 | 0.27709 | 0.2748 | 0.27588 | 44.0 |
| 2011-04-14 | BZ | Futures | 109.26 | 109.63 | 108.44 | 109.11 | 934.0 |
| 2011-04-14 | C | Futures | 2153.0 | 2188.0 | 2134.0 | 2168.0 | 1049.0 |
| 2011-04-14 | CB | Futures | 117.335 | 117.335 | 117.335 | 117.335 | 4.0 |
| 2011-04-14 | CC | Futures | 2458.0 | 2513.0 | 2431.0 | 2489.0 | 10775.0 |
| 2011-04-14 | CSC | Futures | 4.574 | 4.574 | 4.523 | 4.528 | 4.0 |
| 2011-04-14 | CT | Futures | 176.61 | 176.95 | 173.53 | 175.3 | 7182.0 |
| 2011-04-14 | DC | Futures | 30.29 | 30.29 | 29.98 | 30.12 | 118.0 |
| 2011-04-14 | DX | Futures | 74.785 | 74.994 | 74.462 | 74.514 | 24215.0 |
| 2011-04-14 | E1 | Futures | 1.46155 | 1.47228 | 1.4601 | 1.46783 | 39796.0 |
| 2011-04-14 | E6 | Futures | 1.70851 | 1.71692 | 1.69916 | 1.71408 | 299102.0 |
| 2011-04-14 | E7 | Futures | 1.6949 | 1.7041 | 1.6866 | 1.7013 | 5461.0 |
| 2011-04-14 | EBM | Futures | 225.45 | 225.92 | 220.28 | 223.34 | 6530.0 |
| 2011-04-14 | ED | Futures | 94.9406 | 94.9454 | 94.9264 | 94.9311 | 204504.0 |
| 2011-04-14 | ER | Futures | 97.242 | 97.272 | 97.237 | 97.252 | 122031.0 |
| 2011-04-14 | EW | Futures | 966.8 | 968.2 | 955.9 | 967.0 | 24224.0 |
| 2011-04-14 | FBTP | Futures | 64.69 | 64.71 | 64.46 | 64.51 | 8994.0 |
| 2011-04-14 | FCE | Futures | 2671.1 | 2673.9 | 2641.9 | 2655.8 | 115220.0 |
| 2011-04-14 | FDAX | Futures | 7677.7 | 7693.7 | 7596.6 | 7654.8 | 147091.0 |
| 2011-04-14 | FESX | Futures | 1835.0 | 1836.3 | 1810.7 | 1823.5 | 1318410.0 |
| 2011-04-14 | FEU3 | Futures | 97.78 | 97.8 | 97.78 | 97.795 | 5813.0 |
| 2011-04-14 | FGBL | Futures | 96.56 | 96.91 | 96.47 | 96.57 | 1046236.0 |
| 2011-04-14 | FGBM | Futures | 102.39 | 102.62 | 102.28 | 102.34 | 616354.0 |
| 2011-04-14 | FGBS | Futures | 106.161 | 106.241 | 106.122 | 106.137 | 662252.0 |
| 2011-04-14 | FGBX | Futures | 91.5 | 92.31 | 91.23 | 91.78 | 4292.0 |
| 2011-04-14 | FTDX | Futures | 823.4 | 824.3 | 813.6 | 816.7 | 726.0 |
| 2011-04-14 | FTI | Futures | 294.4 | 294.77 | 291.6 | 292.63 | 20247.0 |
| 2011-04-14 | FTUK | Futures | 4174.6 | 4174.6 | 4129.8 | 4150.4 | 93752.0 |
| 2011-04-14 | FXXP | Futures | 182.8 | 183.7 | 181.9 | 182.7 | 4789.0 |
| 2011-04-14 | G | Futures | 81.27 | 81.48 | 81.18 | 81.26 | 130141.0 |
| 2011-04-14 | GF | Futures | 319.902 | 323.873 | 319.12 | 321.948 | 1731.0 |
| 2011-04-14 | GSCI | Futures | 1146.66 | 1152.44 | 1138.53 | 1151.89 | 450.0 |
| 2011-04-14 | HE | Futures | 109.443 | 110.638 | 108.62 | 110.638 | 1177.0 |
| 2011-04-14 | HG | Futures | 5.7056 | 5.7509 | 5.655 | 5.7062 | 38043.0 |
| 2011-04-14 | HO | Futures | 2.6901 | 2.6908 | 2.6457 | 2.6603 | 31375.0 |
| 2011-04-14 | HRC | Futures | 3000.1 | 3000.1 | 3000.1 | 3000.1 | 0.0 |
| 2011-04-14 | J1 | Futures | 0.0149777 | 0.0151498 | 0.0149727 | 0.0150631 | 145709.0 |
| 2011-04-14 | J7 | Futures | 0.01491 | 0.015056 | 0.01489 | 0.014971 | 941.0 |
| 2011-04-14 | JB | Futures | 120.92 | 121.22 | 120.88 | 121.13 | 31.0 |
> showing 50 of 95 rows — these rows as CSV