PREVIEW / futures_daily / 2008-07-22
file: by_date/futures_daily/2008/2008-07-22.parquet size: 8 KB rows: 83
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-22 | ES | Futures | 1163.6 | 1182.1 | 1153.66 | 1178.63 | 2103273.0 |
| 2008-07-22 | NQ | Futures | 2026.62 | 2032.73 | 1988.79 | 2029.12 | 436295.0 |
| 2008-07-22 | YM | Futures | 10148.5 | 10304.8 | 10068.5 | 10270.1 | 181783.0 |
| 2008-07-22 | CL | Futures | 572.88 | 576.87 | 548.52 | 557.42 | 293435.0 |
| 2008-07-22 | GC | Futures | 1368.1 | 1383.6 | 1334.1 | 1343.2 | 193292.0 |
| 2008-07-22 | ZN | Futures | 83.894129 | 84.158779 | 83.399348 | 83.560439 | 882641.0 |
| 2008-07-22 | A6 | Futures | 0.74883 | 0.75107 | 0.74273 | 0.74489 | 34669.0 |
| 2008-07-22 | AD | Futures | 0.9815 | 0.98199 | 0.97001 | 0.97345 | 39339.0 |
| 2008-07-22 | B | Futures | 159.01 | 160.28 | 152.91 | 155.25 | 108072.0 |
| 2008-07-22 | B6 | Futures | 2.0542 | 2.0588 | 2.0401 | 2.0425 | 79193.0 |
| 2008-07-22 | BFX | Futures | 3551.1 | 3551.1 | 3440.8 | 3489.2 | 1289.0 |
| 2008-07-22 | BR | Futures | 0.22802 | 0.22871 | 0.22729 | 0.22871 | 2.0 |
| 2008-07-22 | BZ | Futures | 156.84 | 157.33 | 150.89 | 152.95 | 849.0 |
| 2008-07-22 | C | Futures | 1291.0 | 1307.0 | 1286.0 | 1288.0 | 3377.0 |
| 2008-07-22 | CB | Futures | 93.937 | 94.397 | 93.937 | 94.397 | 19.0 |
| 2008-07-22 | CC | Futures | 2537.0 | 2560.0 | 2489.0 | 2495.0 | 6495.0 |
| 2008-07-22 | CT | Futures | 73.06 | 73.19 | 71.78 | 71.88 | 91.0 |
| 2008-07-22 | DC | Futures | 52.42 | 52.42 | 51.2 | 51.35 | 262.0 |
| 2008-07-22 | DX | Futures | 76.352 | 77.077 | 76.162 | 76.918 | 7200.0 |
| 2008-07-22 | E1 | Futures | 1.31057 | 1.3155 | 1.29018 | 1.29365 | 88585.0 |
| 2008-07-22 | E6 | Futures | 1.85892 | 1.86161 | 1.83948 | 1.84276 | 236700.0 |
| 2008-07-22 | E7 | Futures | 1.8412 | 1.8436 | 1.8217 | 1.8249 | 3000.0 |
| 2008-07-22 | ED | Futures | 91.6502 | 91.6691 | 91.603 | 91.6124 | 191444.0 |
| 2008-07-22 | ER | Futures | 93.551 | 93.571 | 93.551 | 93.556 | 63299.0 |
| 2008-07-22 | EW | Futures | 796.4 | 808.2 | 789.8 | 806.4 | 26378.0 |
| 2008-07-22 | FCE | Futures | 2807.5 | 2856.1 | 2781.5 | 2828.4 | 114033.0 |
| 2008-07-22 | FDAX | Futures | 7212.9 | 7335.5 | 7129.4 | 7335.5 | 152626.0 |
| 2008-07-22 | FESX | Futures | 1955.6 | 1984.4 | 1928.0 | 1984.4 | 1361884.0 |
| 2008-07-22 | FEU3 | Futures | 94.107 | 94.117 | 94.102 | 94.102 | 790.0 |
| 2008-07-22 | FGBL | Futures | 83.03 | 83.27 | 82.82 | 82.82 | 752757.0 |
| 2008-07-22 | FGBM | Futures | 89.29 | 89.52 | 89.21 | 89.21 | 457325.0 |
| 2008-07-22 | FGBS | Futures | 99.023 | 99.134 | 98.989 | 98.989 | 444917.0 |
| 2008-07-22 | FGBX | Futures | 73.59 | 74.07 | 73.56 | 73.59 | 1767.0 |
| 2008-07-22 | FTDX | Futures | 663.3 | 677.8 | 657.9 | 677.8 | 928.0 |
| 2008-07-22 | FTI | Futures | 305.23 | 307.58 | 301.11 | 307.24 | 28445.0 |
| 2008-07-22 | FTUK | Futures | 3463.9 | 3514.4 | 3422.4 | 3481.7 | 85643.0 |
| 2008-07-22 | G | Futures | 67.08 | 67.32 | 67.04 | 67.22 | 61951.0 |
| 2008-07-22 | GF | Futures | 310.528 | 311.884 | 307.816 | 308.833 | 387.0 |
| 2008-07-22 | GSCI | Futures | 2038.18 | 2047.66 | 1993.5 | 2012.83 | 276.0 |
| 2008-07-22 | HE | Futures | 155.324 | 157.372 | 154.874 | 157.372 | 4287.0 |
| 2008-07-22 | HG | Futures | 5.1553 | 5.2194 | 5.1002 | 5.1434 | 10888.0 |
| 2008-07-22 | HO | Futures | 4.4015 | 4.426 | 4.2645 | 4.302 | 27615.0 |
| 2008-07-22 | J1 | Futures | 0.0119863 | 0.0120321 | 0.0118744 | 0.0119011 | 121456.0 |
| 2008-07-22 | J7 | Futures | 0.011785 | 0.011823 | 0.011671 | 0.011696 | 87.0 |
| 2008-07-22 | JB | Futures | 113.75 | 113.83 | 113.28 | 113.36 | 3490.0 |
| 2008-07-22 | KC | Futures | 418.12 | 420.39 | 414.63 | 417.06 | 6052.0 |
| 2008-07-22 | KE | Futures | 4365.74 | 4413.48 | 4352.47 | 4371.04 | 6394.0 |
| 2008-07-22 | L | Futures | 93.358 | 93.373 | 93.348 | 93.358 | 23759.0 |
| 2008-07-22 | LE | Futures | 195.789 | 196.252 | 193.566 | 193.751 | 5170.0 |
| 2008-07-22 | MP | Futures | 0.04723 | 0.04764 | 0.04712 | 0.04748 | 22294.0 |
> showing 50 of 83 rows — these rows as CSV