PREVIEW / futures_daily / 2011-05-25
file: by_date/futures_daily/2011/2011-05-25.parquet size: 9 KB rows: 94
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-05-25 | ES | Futures | 1299.88 | 1311.27 | 1289.24 | 1303.35 | 2100699.0 |
| 2011-05-25 | NQ | Futures | 2620.29 | 2643.07 | 2597.8 | 2630.26 | 261109.0 |
| 2011-05-25 | YM | Futures | 11586.7 | 11677.0 | 11495.5 | 11612.1 | 118960.0 |
| 2011-05-25 | CL | Futures | 190.71 | 195.24 | 188.65 | 194.65 | 354880.0 |
| 2011-05-25 | GC | Futures | 2065.7 | 2074.3 | 2059.1 | 2066.4 | 194947.0 |
| 2011-05-25 | ZN | Futures | 103.765576 | 103.936763 | 103.673399 | 103.778745 | 1728277.0 |
| 2011-05-25 | A6 | Futures | 0.90322 | 0.90348 | 0.8931 | 0.9003 | 132891.0 |
| 2011-05-25 | AD | Futures | 1.01893 | 1.02142 | 1.01385 | 1.01853 | 68733.0 |
| 2011-05-25 | B | Futures | 95.5 | 98.07 | 94.81 | 98.01 | 67997.0 |
| 2011-05-25 | B6 | Futures | 1.681 | 1.6924 | 1.6756 | 1.6907 | 124678.0 |
| 2011-05-25 | BFX | Futures | 3140.6 | 3157.1 | 3140.6 | 3152.8 | 121.0 |
| 2011-05-25 | BR | Futures | 0.2702 | 0.2702 | 0.26815 | 0.26849 | 3159.0 |
| 2011-05-25 | BZ | Futures | 100.63 | 102.2 | 100.63 | 102.2 | 480.0 |
| 2011-05-25 | C | Futures | 1947.0 | 2017.0 | 1939.0 | 2002.0 | 6336.0 |
| 2011-05-25 | CB | Futures | 120.545 | 120.545 | 118.902 | 118.902 | 23.0 |
| 2011-05-25 | CC | Futures | 2289.0 | 2377.0 | 2288.0 | 2358.0 | 10878.0 |
| 2011-05-25 | CT | Futures | 152.3 | 158.04 | 152.08 | 154.43 | 9052.0 |
| 2011-05-25 | DC | Futures | 31.0 | 31.15 | 30.82 | 31.02 | 155.0 |
| 2011-05-25 | DX | Futures | 75.735 | 76.014 | 75.457 | 75.651 | 31543.0 |
| 2011-05-25 | E1 | Futures | 1.48826 | 1.50371 | 1.48564 | 1.50056 | 50255.0 |
| 2011-05-25 | E6 | Futures | 1.66919 | 1.67168 | 1.659 | 1.66658 | 377507.0 |
| 2011-05-25 | E7 | Futures | 1.6569 | 1.6594 | 1.6467 | 1.6542 | 7683.0 |
| 2011-05-25 | ED | Futures | 94.9549 | 94.9549 | 94.9478 | 94.9525 | 156904.0 |
| 2011-05-25 | ER | Futures | 97.291 | 97.321 | 97.291 | 97.316 | 134056.0 |
| 2011-05-25 | EW | Futures | 960.1 | 971.5 | 953.6 | 966.8 | 21148.0 |
| 2011-05-25 | FBTP | Futures | 64.98 | 65.27 | 64.82 | 65.22 | 9448.0 |
| 2011-05-25 | FCE | Futures | 2674.9 | 2719.7 | 2671.1 | 2710.3 | 108837.0 |
| 2011-05-25 | FDAX | Futures | 7558.1 | 7696.4 | 7546.9 | 7667.6 | 145511.0 |
| 2011-05-25 | FESX | Futures | 1768.4 | 1807.5 | 1765.2 | 1800.4 | 1318112.0 |
| 2011-05-25 | FEU3 | Futures | 97.84 | 97.86 | 97.84 | 97.86 | 324.0 |
| 2011-05-25 | FGBL | Futures | 100.12 | 100.2 | 99.91 | 100.03 | 1118620.0 |
| 2011-05-25 | FGBM | Futures | 104.45 | 104.58 | 104.38 | 104.46 | 729351.0 |
| 2011-05-25 | FGBS | Futures | 106.761 | 106.84 | 106.731 | 106.801 | 903404.0 |
| 2011-05-25 | FGBX | Futures | 97.34 | 97.45 | 97.01 | 97.16 | 5501.0 |
| 2011-05-25 | FTDX | Futures | 794.9 | 806.9 | 794.4 | 801.6 | 608.0 |
| 2011-05-25 | FTI | Futures | 278.73 | 284.02 | 278.2 | 282.91 | 35041.0 |
| 2011-05-25 | FTUK | Futures | 4082.2 | 4120.3 | 4044.4 | 4100.1 | 97595.0 |
| 2011-05-25 | FXXP | Futures | 183.1 | 185.5 | 183.1 | 185.3 | 5003.0 |
| 2011-05-25 | G | Futures | 83.9 | 83.9 | 83.65 | 83.71 | 218843.0 |
| 2011-05-25 | GF | Futures | 287.249 | 291.084 | 285.913 | 289.399 | 3148.0 |
| 2011-05-25 | GSCI | Futures | 1073.04 | 1091.67 | 1071.55 | 1088.77 | 95.0 |
| 2011-05-25 | HE | Futures | 92.34 | 94.193 | 92.128 | 93.505 | 11540.0 |
| 2011-05-25 | HG | Futures | 5.3401 | 5.483 | 5.3149 | 5.4564 | 37666.0 |
| 2011-05-25 | HO | Futures | 2.3797 | 2.4475 | 2.3701 | 2.4469 | 11452.0 |
| 2011-05-25 | HRC | Futures | 3077.0 | 3077.0 | 3077.0 | 3077.0 | 4.0 |
| 2011-05-25 | J1 | Futures | 0.0153257 | 0.0153609 | 0.0152868 | 0.0153207 | 95866.0 |
| 2011-05-25 | J7 | Futures | 0.015217 | 0.015266 | 0.015194 | 0.015227 | 310.0 |
| 2011-05-25 | JB | Futures | 122.61 | 122.68 | 122.5 | 122.61 | 169.0 |
| 2011-05-25 | KC | Futures | 626.83 | 646.14 | 621.08 | 635.11 | 12366.0 |
| 2011-05-25 | KE | Futures | 3610.0 | 3685.04 | 3606.05 | 3668.25 | 12664.0 |
> showing 50 of 94 rows — these rows as CSV