PREVIEW / futures_daily / 2010-04-06
file: by_date/futures_daily/2010/2010-04-06.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 |
|---|---|---|---|---|---|---|---|
| 2010-04-06 | ES | Futures | 1151.99 | 1156.86 | 1146.39 | 1154.67 | 1395387.0 |
| 2010-04-06 | NQ | Futures | 2238.24 | 2252.7 | 2229.45 | 2244.76 | 190613.0 |
| 2010-04-06 | YM | Futures | 10029.2 | 10044.8 | 9989.7 | 10032.0 | 78087.0 |
| 2010-04-06 | CL | Futures | 202.95 | 203.77 | 201.52 | 203.18 | 290480.0 |
| 2010-04-06 | GC | Futures | 1553.0 | 1563.6 | 1541.5 | 1558.6 | 126657.0 |
| 2010-04-06 | ZN | Futures | 93.905014 | 94.262116 | 93.89226 | 94.045304 | 966662.0 |
| 2010-04-06 | A6 | Futures | 0.75004 | 0.75628 | 0.74627 | 0.75513 | 97217.0 |
| 2010-04-06 | AD | Futures | 0.98498 | 0.98834 | 0.98242 | 0.98715 | 57921.0 |
| 2010-04-06 | B | Futures | 77.19 | 77.83 | 76.7 | 77.41 | 80541.0 |
| 2010-04-06 | B6 | Futures | 1.5867 | 1.5886 | 1.57 | 1.5852 | 115848.0 |
| 2010-04-06 | BFX | Futures | 3022.8 | 3038.1 | 3015.7 | 3035.8 | 96.0 |
| 2010-04-06 | BZ | Futures | 81.11 | 81.11 | 81.11 | 81.11 | 2.0 |
| 2010-04-06 | C | Futures | 2262.0 | 2279.0 | 2191.0 | 2199.0 | 8396.0 |
| 2010-04-06 | CB | Futures | 76.492 | 76.492 | 76.492 | 76.492 | 2.0 |
| 2010-04-06 | CC | Futures | 2520.0 | 2529.0 | 2428.0 | 2474.0 | 6332.0 |
| 2010-04-06 | CT | Futures | 67.05 | 67.63 | 66.68 | 66.92 | 8439.0 |
| 2010-04-06 | DC | Futures | 23.12 | 23.72 | 23.1 | 23.64 | 723.0 |
| 2010-04-06 | DX | Futures | 82.401 | 82.908 | 82.401 | 82.66 | 18767.0 |
| 2010-04-06 | E1 | Futures | 1.23998 | 1.24064 | 1.22814 | 1.23169 | 50634.0 |
| 2010-04-06 | E6 | Futures | 1.59502 | 1.5968 | 1.57988 | 1.58449 | 310565.0 |
| 2010-04-06 | E7 | Futures | 1.5817 | 1.5836 | 1.5669 | 1.5715 | 3389.0 |
| 2010-04-06 | EBM | Futures | 205.63 | 208.5 | 205.22 | 207.27 | 5109.0 |
| 2010-04-06 | ED | Futures | 94.3802 | 94.3944 | 94.3755 | 94.3897 | 175409.0 |
| 2010-04-06 | ER | Futures | 97.365 | 97.37 | 97.355 | 97.355 | 156567.0 |
| 2010-04-06 | EW | Futures | 787.2 | 792.6 | 782.3 | 791.1 | 18903.0 |
| 2010-04-06 | FBTP | Futures | 64.93 | 64.93 | 64.62 | 64.71 | 5012.0 |
| 2010-04-06 | FCE | Futures | 2591.5 | 2653.9 | 2576.4 | 2595.0 | 99525.0 |
| 2010-04-06 | FDAX | Futures | 6809.1 | 6823.8 | 6766.1 | 6801.5 | 95659.0 |
| 2010-04-06 | FESX | Futures | 1788.8 | 1793.1 | 1771.1 | 1784.5 | 761158.0 |
| 2010-04-06 | FEU3 | Futures | 97.929 | 97.929 | 97.914 | 97.914 | 563.0 |
| 2010-04-06 | FGBL | Futures | 95.97 | 96.13 | 95.63 | 95.9 | 884345.0 |
| 2010-04-06 | FGBM | Futures | 101.66 | 101.83 | 101.37 | 101.65 | 610709.0 |
| 2010-04-06 | FGBS | Futures | 106.297 | 106.41 | 106.229 | 106.356 | 696697.0 |
| 2010-04-06 | FGBX | Futures | 91.66 | 91.77 | 91.13 | 91.33 | 3364.0 |
| 2010-04-06 | FTDX | Futures | 735.8 | 746.4 | 735.4 | 740.7 | 658.0 |
| 2010-04-06 | FTI | Futures | 285.59 | 288.15 | 284.95 | 287.22 | 28600.0 |
| 2010-04-06 | FTUK | Futures | 3863.4 | 3886.1 | 3855.6 | 3878.0 | 97155.0 |
| 2010-04-06 | G | Futures | 76.22 | 76.34 | 76.05 | 76.09 | 82870.0 |
| 2010-04-06 | GF | Futures | 293.298 | 296.625 | 291.732 | 292.776 | 744.0 |
| 2010-04-06 | GSCI | Futures | 1006.24 | 1012.13 | 1004.4 | 1006.79 | 8228.0 |
| 2010-04-06 | HE | Futures | 101.393 | 102.186 | 100.142 | 100.691 | 944.0 |
| 2010-04-06 | HG | Futures | 4.9677 | 4.9711 | 4.9192 | 4.9417 | 24737.0 |
| 2010-04-06 | HO | Futures | 2.0741 | 2.0938 | 2.0714 | 2.0828 | 24652.0 |
| 2010-04-06 | J1 | Futures | 0.0133324 | 0.0134293 | 0.0133262 | 0.0133941 | 101211.0 |
| 2010-04-06 | J7 | Futures | 0.013227 | 0.01332 | 0.013222 | 0.013287 | 119.0 |
| 2010-04-06 | JB | Futures | 117.72 | 117.72 | 117.38 | 117.41 | 2546.0 |
| 2010-04-06 | KC | Futures | 358.28 | 358.92 | 353.78 | 357.51 | 9849.0 |
| 2010-04-06 | KE | Futures | 2091.56 | 2164.68 | 2074.94 | 2133.66 | 8694.0 |
| 2010-04-06 | L | Futures | 97.868 | 97.888 | 97.858 | 97.878 | 24742.0 |
| 2010-04-06 | LBS | Futures | 936.6 | 940.3 | 913.0 | 921.5 | 489.0 |
> showing 50 of 89 rows — these rows as CSV