PREVIEW / futures_daily / 2009-03-20
file: by_date/futures_daily/2009/2009-03-20.parquet size: 8 KB rows: 85
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 |
|---|---|---|---|---|---|---|---|
| 2009-03-20 | ES | Futures | 743.41 | 748.65 | 725.78 | 728.16 | 2385394.0 |
| 2009-03-20 | NQ | Futures | 1353.55 | 1370.68 | 1322.65 | 1334.73 | 331995.0 |
| 2009-03-20 | YM | Futures | 6588.4 | 6639.5 | 6457.4 | 6471.8 | 161296.0 |
| 2009-03-20 | CL | Futures | 145.08 | 148.0 | 143.17 | 146.18 | 180152.0 |
| 2009-03-20 | GC | Futures | 1331.1 | 1343.0 | 1313.8 | 1326.9 | 108944.0 |
| 2009-03-20 | ZN | Futures | 96.696922 | 97.073175 | 96.611962 | 96.769745 | 520145.0 |
| 2009-03-20 | A6 | Futures | 0.5455 | 0.55028 | 0.54374 | 0.54478 | 36453.0 |
| 2009-03-20 | AD | Futures | 0.79582 | 0.80153 | 0.79159 | 0.79484 | 35455.0 |
| 2009-03-20 | B | Futures | 49.31 | 50.61 | 48.69 | 50.14 | 78278.0 |
| 2009-03-20 | B6 | Futures | 1.5112 | 1.5184 | 1.4976 | 1.5024 | 61651.0 |
| 2009-03-20 | BFX | Futures | 1834.0 | 1878.0 | 1833.7 | 1871.6 | 765.0 |
| 2009-03-20 | BR | Futures | 0.16575 | 0.16575 | 0.16499 | 0.16575 | 91.0 |
| 2009-03-20 | BZ | Futures | 51.3 | 52.51 | 51.13 | 52.3 | 36.0 |
| 2009-03-20 | C | Futures | 1948.0 | 1974.0 | 1947.0 | 1966.0 | 4237.0 |
| 2009-03-20 | CC | Futures | 2261.0 | 2285.0 | 2244.0 | 2274.0 | 4950.0 |
| 2009-03-20 | CT | Futures | 40.54 | 41.83 | 40.52 | 41.58 | 10454.0 |
| 2009-03-20 | DC | Futures | 31.36 | 31.98 | 30.16 | 30.38 | 250.0 |
| 2009-03-20 | DX | Futures | 86.093 | 87.066 | 85.758 | 86.85 | 7188.0 |
| 2009-03-20 | E1 | Futures | 1.1826 | 1.18923 | 1.17557 | 1.1761 | 30237.0 |
| 2009-03-20 | E6 | Futures | 1.62022 | 1.6271 | 1.6022 | 1.60659 | 185528.0 |
| 2009-03-20 | E7 | Futures | 1.6018 | 1.6083 | 1.5835 | 1.5879 | 2083.0 |
| 2009-03-20 | EBM | Futures | 213.63 | 214.01 | 212.47 | 213.24 | 2341.0 |
| 2009-03-20 | ED | Futures | 93.1435 | 93.167 | 93.0963 | 93.1246 | 171731.0 |
| 2009-03-20 | ER | Futures | 96.576 | 96.65 | 96.576 | 96.645 | 140970.0 |
| 2009-03-20 | EW | Futures | 461.4 | 464.2 | 443.8 | 445.6 | 22070.0 |
| 2009-03-20 | FCE | Futures | 1737.8 | 1776.2 | 1728.6 | 1771.7 | 142411.0 |
| 2009-03-20 | FDAX | Futures | 4378.2 | 4462.6 | 4361.9 | 4438.7 | 165068.0 |
| 2009-03-20 | FESX | Futures | 1167.7 | 1189.3 | 1158.7 | 1184.5 | 1466507.0 |
| 2009-03-20 | FEU3 | Futures | 97.185 | 97.229 | 97.185 | 97.229 | 744.0 |
| 2009-03-20 | FGBL | Futures | 93.53 | 94.12 | 93.49 | 94.04 | 649757.0 |
| 2009-03-20 | FGBM | Futures | 97.97 | 98.32 | 97.95 | 98.28 | 365449.0 |
| 2009-03-20 | FGBS | Futures | 103.623 | 103.81 | 103.613 | 103.8 | 403460.0 |
| 2009-03-20 | FGBX | Futures | 83.3 | 83.97 | 82.79 | 83.88 | 2889.0 |
| 2009-03-20 | FTDX | Futures | 388.5 | 395.7 | 386.7 | 393.9 | 1611.0 |
| 2009-03-20 | FTI | Futures | 169.21 | 174.02 | 169.21 | 173.41 | 30642.0 |
| 2009-03-20 | FTUK | Futures | 2497.0 | 2536.2 | 2478.6 | 2520.3 | 146538.0 |
| 2009-03-20 | G | Futures | 78.53 | 78.77 | 78.41 | 78.7 | 71723.0 |
| 2009-03-20 | GF | Futures | 263.32 | 264.717 | 261.785 | 261.854 | 257.0 |
| 2009-03-20 | GSCI | Futures | 784.69 | 795.74 | 783.3 | 795.32 | 266.0 |
| 2009-03-20 | HE | Futures | 121.916 | 122.081 | 120.183 | 120.967 | 60.0 |
| 2009-03-20 | HG | Futures | 2.5507 | 2.6106 | 2.5176 | 2.5303 | 11114.0 |
| 2009-03-20 | HO | Futures | 1.5187 | 1.5569 | 1.5095 | 1.5528 | 12114.0 |
| 2009-03-20 | HRC | Futures | 2833.7 | 2833.7 | 2833.7 | 2833.7 | 0.0 |
| 2009-03-20 | J1 | Futures | 0.0133563 | 0.0134004 | 0.0131055 | 0.0131483 | 56655.0 |
| 2009-03-20 | J7 | Futures | 0.013164 | 0.013207 | 0.012905 | 0.01297 | 62.0 |
| 2009-03-20 | KC | Futures | 325.46 | 332.21 | 323.91 | 326.87 | 10973.0 |
| 2009-03-20 | KE | Futures | 2982.67 | 2999.92 | 2913.65 | 2972.81 | 7077.0 |
| 2009-03-20 | L | Futures | 96.757 | 96.836 | 96.748 | 96.816 | 39050.0 |
| 2009-03-20 | LBS | Futures | 867.0 | 878.4 | 858.2 | 858.2 | 168.0 |
| 2009-03-20 | LE | Futures | 147.421 | 148.084 | 146.139 | 146.449 | 6695.0 |
> showing 50 of 85 rows — these rows as CSV