PREVIEW / futures_daily / 2009-05-20
file: by_date/futures_daily/2009/2009-05-20.parquet size: 8 KB rows: 86
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-05-20 | ES | Futures | 863.26 | 880.18 | 857.07 | 857.78 | 2781625.0 |
| 2009-05-20 | NQ | Futures | 1565.05 | 1598.76 | 1557.75 | 1564.49 | 332484.0 |
| 2009-05-20 | YM | Futures | 7571.5 | 7692.6 | 7523.0 | 7530.2 | 178657.0 |
| 2009-05-20 | CL | Futures | 160.21 | 165.75 | 159.36 | 165.16 | 270022.0 |
| 2009-05-20 | GC | Futures | 1281.6 | 1302.9 | 1281.2 | 1297.9 | 128003.0 |
| 2009-05-20 | ZN | Futures | 93.674764 | 94.148114 | 93.504843 | 93.953919 | 716545.0 |
| 2009-05-20 | A6 | Futures | 0.61592 | 0.62158 | 0.61185 | 0.62086 | 53782.0 |
| 2009-05-20 | AD | Futures | 0.85155 | 0.86661 | 0.84987 | 0.86622 | 62385.0 |
| 2009-05-20 | B | Futures | 56.73 | 58.56 | 56.6 | 58.36 | 105374.0 |
| 2009-05-20 | B6 | Futures | 1.6096 | 1.6431 | 1.6072 | 1.6415 | 101847.0 |
| 2009-05-20 | BFX | Futures | 2388.6 | 2403.4 | 2383.2 | 2395.7 | 113.0 |
| 2009-05-20 | BR | Futures | 0.1878 | 0.18837 | 0.18632 | 0.18818 | 7.0 |
| 2009-05-20 | BZ | Futures | 62.14 | 63.41 | 62.07 | 63.25 | 96.0 |
| 2009-05-20 | C | Futures | 1699.0 | 1725.0 | 1698.0 | 1719.0 | 2988.0 |
| 2009-05-20 | CB | Futures | 77.038 | 77.038 | 77.038 | 77.038 | 5.0 |
| 2009-05-20 | CC | Futures | 2050.0 | 2097.0 | 2022.0 | 2083.0 | 5056.0 |
| 2009-05-20 | CT | Futures | 51.86 | 53.29 | 51.67 | 52.88 | 9148.0 |
| 2009-05-20 | DC | Futures | 25.01 | 25.01 | 24.24 | 24.27 | 373.0 |
| 2009-05-20 | DX | Futures | 84.605 | 84.79 | 83.39 | 83.493 | 7661.0 |
| 2009-05-20 | E1 | Futures | 1.19573 | 1.20912 | 1.19175 | 1.20607 | 45170.0 |
| 2009-05-20 | E6 | Futures | 1.61524 | 1.63907 | 1.60979 | 1.63599 | 224853.0 |
| 2009-05-20 | E7 | Futures | 1.5969 | 1.6199 | 1.5913 | 1.617 | 2926.0 |
| 2009-05-20 | ED | Futures | 93.6431 | 93.7044 | 93.6337 | 93.6997 | 245177.0 |
| 2009-05-20 | ER | Futures | 96.821 | 96.831 | 96.767 | 96.772 | 186394.0 |
| 2009-05-20 | EW | Futures | 548.3 | 562.2 | 543.1 | 543.5 | 31869.0 |
| 2009-05-20 | FCE | Futures | 2103.3 | 2143.4 | 2096.8 | 2132.6 | 111139.0 |
| 2009-05-20 | FDAX | Futures | 5394.9 | 5514.7 | 5379.1 | 5484.2 | 157945.0 |
| 2009-05-20 | FESX | Futures | 1464.7 | 1495.9 | 1460.5 | 1486.9 | 1225964.0 |
| 2009-05-20 | FEU3 | Futures | 97.392 | 97.392 | 97.352 | 97.352 | 126.0 |
| 2009-05-20 | FGBL | Futures | 90.95 | 91.2 | 90.76 | 90.97 | 729273.0 |
| 2009-05-20 | FGBM | Futures | 97.31 | 97.4 | 97.16 | 97.29 | 389094.0 |
| 2009-05-20 | FGBS | Futures | 103.834 | 103.853 | 103.747 | 103.776 | 494518.0 |
| 2009-05-20 | FGBX | Futures | 80.21 | 80.66 | 80.02 | 80.19 | 1565.0 |
| 2009-05-20 | FTDX | Futures | 570.2 | 581.0 | 568.4 | 575.6 | 677.0 |
| 2009-05-20 | FTI | Futures | 214.74 | 220.01 | 214.66 | 219.4 | 33786.0 |
| 2009-05-20 | FTUK | Futures | 2963.1 | 2990.7 | 2923.1 | 2962.1 | 100922.0 |
| 2009-05-20 | G | Futures | 76.54 | 76.59 | 75.98 | 76.11 | 111727.0 |
| 2009-05-20 | GF | Futures | 279.076 | 280.867 | 277.353 | 280.316 | 1080.0 |
| 2009-05-20 | GSCI | Futures | 885.31 | 903.13 | 885.31 | 901.31 | 279.0 |
| 2009-05-20 | HE | Futures | 98.954 | 100.04 | 98.392 | 99.59 | 7180.0 |
| 2009-05-20 | HG | Futures | 2.9194 | 3.0108 | 2.9011 | 2.9637 | 13920.0 |
| 2009-05-20 | HO | Futures | 1.6061 | 1.6506 | 1.6061 | 1.6484 | 4118.0 |
| 2009-05-20 | HRC | Futures | 2495.0 | 2495.0 | 2495.0 | 2495.0 | 0.0 |
| 2009-05-20 | J1 | Futures | 0.013137 | 0.0133122 | 0.0131004 | 0.0132781 | 86926.0 |
| 2009-05-20 | J7 | Futures | 0.012939 | 0.013129 | 0.012939 | 0.013098 | 69.0 |
| 2009-05-20 | JB | Futures | 114.9 | 114.99 | 114.75 | 114.85 | 811.0 |
| 2009-05-20 | KC | Futures | 365.34 | 372.96 | 362.29 | 369.35 | 10990.0 |
| 2009-05-20 | KE | Futures | 3122.93 | 3213.13 | 3120.49 | 3169.25 | 7762.0 |
| 2009-05-20 | L | Futures | 97.151 | 97.18 | 97.141 | 97.17 | 40681.0 |
| 2009-05-20 | LBS | Futures | 812.3 | 815.5 | 806.4 | 812.7 | 98.0 |
> showing 50 of 86 rows — these rows as CSV