PREVIEW / futures_daily / 2012-05-25
file: by_date/futures_daily/2012/2012-05-25.parquet size: 9 KB rows: 97
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 |
|---|---|---|---|---|---|---|---|
| 2012-05-25 | ES | Futures | 1332.7 | 1340.01 | 1322.12 | 1325.15 | 1521622.0 |
| 2012-05-25 | NQ | Futures | 2905.83 | 2923.3 | 2885.21 | 2891.8 | 186910.0 |
| 2012-05-25 | YM | Futures | 12193.1 | 12239.8 | 12059.8 | 12087.1 | 135469.0 |
| 2012-05-25 | CL | Futures | 166.39 | 167.36 | 165.31 | 166.52 | 153921.0 |
| 2012-05-25 | GC | Futures | 2085.1 | 2106.8 | 2076.3 | 2100.4 | 63101.0 |
| 2012-05-25 | ZN | Futures | 115.587277 | 115.966341 | 115.519587 | 115.898651 | 1269599.0 |
| 2012-05-25 | A6 | Futures | 0.87688 | 0.87976 | 0.8731 | 0.87751 | 121959.0 |
| 2012-05-25 | AD | Futures | 0.97925 | 0.98136 | 0.97563 | 0.97684 | 79573.0 |
| 2012-05-25 | B | Futures | 96.35 | 96.86 | 95.75 | 96.58 | 94880.0 |
| 2012-05-25 | B6 | Futures | 1.6444 | 1.6476 | 1.6402 | 1.6418 | 90558.0 |
| 2012-05-25 | BFX | Futures | 2574.7 | 2585.7 | 2558.6 | 2577.8 | 11.0 |
| 2012-05-25 | BR | Futures | 0.23329 | 0.23587 | 0.23329 | 0.23582 | 302.0 |
| 2012-05-25 | BZ | Futures | 102.68 | 102.68 | 102.68 | 102.68 | 924.0 |
| 2012-05-25 | C | Futures | 1481.0 | 1484.0 | 1466.0 | 1475.0 | 4037.0 |
| 2012-05-25 | CC | Futures | 1597.0 | 1608.0 | 1577.0 | 1591.0 | 9664.0 |
| 2012-05-25 | CSC | Futures | 3.591 | 3.606 | 3.591 | 3.606 | 10.0 |
| 2012-05-25 | CT | Futures | 90.89 | 91.46 | 88.88 | 90.06 | 10104.0 |
| 2012-05-25 | DC | Futures | 25.55 | 25.9 | 25.42 | 25.74 | 100.0 |
| 2012-05-25 | DX | Futures | 79.88 | 80.04 | 79.57 | 79.956 | 26572.0 |
| 2012-05-25 | E1 | Futures | 1.36647 | 1.37262 | 1.36254 | 1.3649 | 46657.0 |
| 2012-05-25 | E6 | Futures | 1.49673 | 1.50461 | 1.49171 | 1.49434 | 278740.0 |
| 2012-05-25 | E7 | Futures | 1.4824 | 1.4899 | 1.4774 | 1.48 | 3389.0 |
| 2012-05-25 | ED | Futures | 95.0573 | 95.0621 | 95.0549 | 95.0573 | 77120.0 |
| 2012-05-25 | ER | Futures | 97.548 | 97.557 | 97.538 | 97.553 | 45731.0 |
| 2012-05-25 | EW | Futures | 948.9 | 954.6 | 941.1 | 942.9 | 14926.0 |
| 2012-05-25 | FBTP | Futures | 66.45 | 67.49 | 65.93 | 66.08 | 26066.0 |
| 2012-05-25 | FBTS | Futures | 84.672 | 85.046 | 84.428 | 84.525 | 2482.0 |
| 2012-05-25 | FCE | Futures | 2215.5 | 2246.9 | 2205.9 | 2228.8 | 127402.0 |
| 2012-05-25 | FDAX | Futures | 6956.0 | 7084.8 | 6941.1 | 7013.5 | 165528.0 |
| 2012-05-25 | FESX | Futures | 1478.4 | 1501.2 | 1470.8 | 1488.8 | 1179070.0 |
| 2012-05-25 | FGBL | Futures | 118.09 | 118.4 | 117.77 | 118.26 | 683157.0 |
| 2012-05-25 | FGBM | Futures | 115.72 | 115.89 | 115.61 | 115.83 | 330629.0 |
| 2012-05-25 | FGBS | Futures | 110.298 | 110.358 | 110.288 | 110.328 | 251737.0 |
| 2012-05-25 | FGBX | Futures | 128.18 | 129.26 | 127.66 | 128.53 | 7872.0 |
| 2012-05-25 | FOAT | Futures | 98.45 | 99.38 | 98.45 | 98.66 | 34886.0 |
| 2012-05-25 | FTDX | Futures | 708.7 | 711.1 | 700.3 | 702.6 | 80.0 |
| 2012-05-25 | FTI | Futures | 253.41 | 256.01 | 251.76 | 253.71 | 36179.0 |
| 2012-05-25 | FTUK | Futures | 3895.6 | 3917.5 | 3862.4 | 3890.1 | 111334.0 |
| 2012-05-25 | FVSA | Futures | 10164.14 | 10257.96 | 9929.58 | 10085.95 | 1017.0 |
| 2012-05-25 | FXXP | Futures | 175.6 | 176.6 | 174.2 | 175.5 | 1922.0 |
| 2012-05-25 | G | Futures | 97.85 | 98.18 | 97.68 | 98.02 | 189531.0 |
| 2012-05-25 | GF | Futures | 314.394 | 315.726 | 312.667 | 312.815 | 2293.0 |
| 2012-05-25 | GSCI | Futures | 983.7 | 986.47 | 982.43 | 982.43 | 34.0 |
| 2012-05-25 | HE | Futures | 89.872 | 91.153 | 89.819 | 90.886 | 10628.0 |
| 2012-05-25 | HG | Futures | 4.4952 | 4.5411 | 4.4756 | 4.5155 | 46038.0 |
| 2012-05-25 | HO | Futures | 2.3285 | 2.3331 | 2.3177 | 2.329 | 6458.0 |
| 2012-05-25 | HRC | Futures | 2550.0 | 2550.0 | 2550.0 | 2550.0 | 0.0 |
| 2012-05-25 | J1 | Futures | 0.0157589 | 0.0157739 | 0.0157087 | 0.0157476 | 49336.0 |
| 2012-05-25 | J7 | Futures | 0.015687 | 0.0157 | 0.015637 | 0.015673 | 165.0 |
| 2012-05-25 | JB | Futures | 125.56 | 125.63 | 125.35 | 125.42 | 4354.0 |
> showing 50 of 97 rows — these rows as CSV