PREVIEW / futures_daily / 2011-01-20
file: by_date/futures_daily/2011/2011-01-20.parquet size: 9 KB rows: 94
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 |
|---|---|---|---|---|---|---|---|
| 2011-01-20 | ES | Futures | 1259.2 | 1261.41 | 1247.63 | 1256.24 | 2534106.0 |
| 2011-01-20 | NQ | Futures | 2608.65 | 2610.63 | 2573.73 | 2590.2 | 351068.0 |
| 2011-01-20 | YM | Futures | 11030.9 | 11044.9 | 10944.7 | 11019.6 | 130472.0 |
| 2011-01-20 | CL | Futures | 186.41 | 186.76 | 180.86 | 182.26 | 442041.0 |
| 2011-01-20 | GC | Futures | 1862.0 | 1863.4 | 1824.7 | 1830.2 | 242891.0 |
| 2011-01-20 | ZN | Futures | 100.439548 | 100.621528 | 99.568648 | 99.685634 | 1423201.0 |
| 2011-01-20 | A6 | Futures | 0.84088 | 0.8413 | 0.82833 | 0.8324 | 142842.0 |
| 2011-01-20 | AD | Futures | 0.99572 | 0.99612 | 0.98818 | 0.99413 | 97933.0 |
| 2011-01-20 | B | Futures | 83.35 | 83.58 | 81.27 | 82.25 | 210891.0 |
| 2011-01-20 | B6 | Futures | 1.6582 | 1.6603 | 1.6422 | 1.6499 | 148483.0 |
| 2011-01-20 | BFX | Futures | 3046.0 | 3057.5 | 3025.4 | 3040.2 | 1190.0 |
| 2011-01-20 | BR | Futures | 0.25506 | 0.25547 | 0.25498 | 0.25547 | 191.0 |
| 2011-01-20 | BZ | Futures | 88.71 | 88.73 | 86.59 | 87.61 | 804.0 |
| 2011-01-20 | C | Futures | 2250.0 | 2327.0 | 2249.0 | 2325.0 | 11139.0 |
| 2011-01-20 | CB | Futures | 113.801 | 114.402 | 113.801 | 113.815 | 17.0 |
| 2011-01-20 | CC | Futures | 2508.0 | 2589.0 | 2507.0 | 2579.0 | 14413.0 |
| 2011-01-20 | CSC | Futures | 3.48 | 3.579 | 3.48 | 3.579 | 2.0 |
| 2011-01-20 | CT | Futures | 127.98 | 131.15 | 126.93 | 131.15 | 10918.0 |
| 2011-01-20 | DC | Futures | 24.36 | 25.47 | 24.21 | 25.42 | 975.0 |
| 2011-01-20 | DX | Futures | 78.743 | 79.197 | 78.458 | 78.842 | 24004.0 |
| 2011-01-20 | E1 | Futures | 1.37221 | 1.3764 | 1.35399 | 1.35556 | 51279.0 |
| 2011-01-20 | E6 | Futures | 1.59179 | 1.59924 | 1.5841 | 1.59309 | 384487.0 |
| 2011-01-20 | E7 | Futures | 1.5802 | 1.5875 | 1.5723 | 1.5812 | 6407.0 |
| 2011-01-20 | EBM | Futures | 235.35 | 235.81 | 232.63 | 234.9 | 5023.0 |
| 2011-01-20 | ED | Futures | 94.8289 | 94.8384 | 94.8242 | 94.8289 | 160160.0 |
| 2011-01-20 | ER | Futures | 97.286 | 97.296 | 97.252 | 97.257 | 251839.0 |
| 2011-01-20 | EW | Futures | 910.0 | 911.2 | 897.4 | 900.6 | 23928.0 |
| 2011-01-20 | FBTP | Futures | 63.77 | 64.16 | 63.75 | 63.8 | 4298.0 |
| 2011-01-20 | FCE | Futures | 2653.1 | 2668.8 | 2638.1 | 2647.4 | 138964.0 |
| 2011-01-20 | FDAX | Futures | 7581.7 | 7597.7 | 7512.6 | 7531.9 | 160920.0 |
| 2011-01-20 | FESX | Futures | 1812.3 | 1832.1 | 1806.7 | 1817.2 | 1446349.0 |
| 2011-01-20 | FEU3 | Futures | 97.845 | 97.845 | 97.815 | 97.815 | 216.0 |
| 2011-01-20 | FGBL | Futures | 98.58 | 98.6 | 97.79 | 97.94 | 1068753.0 |
| 2011-01-20 | FGBM | Futures | 104.12 | 104.15 | 103.51 | 103.61 | 713454.0 |
| 2011-01-20 | FGBS | Futures | 107.03 | 107.055 | 106.798 | 106.843 | 761016.0 |
| 2011-01-20 | FGBX | Futures | 96.61 | 96.83 | 95.18 | 95.54 | 3680.0 |
| 2011-01-20 | FTDX | Futures | 769.2 | 770.6 | 753.4 | 757.4 | 1613.0 |
| 2011-01-20 | FTI | Futures | 286.53 | 288.02 | 285.08 | 286.37 | 43568.0 |
| 2011-01-20 | FTUK | Futures | 4127.3 | 4130.1 | 4046.4 | 4050.5 | 148554.0 |
| 2011-01-20 | FXXP | Futures | 182.7 | 182.7 | 180.6 | 180.8 | 8946.0 |
| 2011-01-20 | G | Futures | 80.62 | 80.68 | 80.21 | 80.35 | 117157.0 |
| 2011-01-20 | GF | Futures | 313.706 | 314.508 | 311.054 | 311.548 | 3114.0 |
| 2011-01-20 | GSCI | Futures | 1013.88 | 1013.88 | 1001.14 | 1012.76 | 181.0 |
| 2011-01-20 | HE | Futures | 101.047 | 101.543 | 99.909 | 101.222 | 11809.0 |
| 2011-01-20 | HG | Futures | 5.8067 | 5.8493 | 5.6354 | 5.6934 | 49518.0 |
| 2011-01-20 | HO | Futures | 2.2224 | 2.2237 | 2.1736 | 2.1965 | 47690.0 |
| 2011-01-20 | HRC | Futures | 2691.6 | 2691.6 | 2691.6 | 2691.6 | 0.0 |
| 2011-01-20 | J1 | Futures | 0.0153043 | 0.0153131 | 0.0151122 | 0.015131 | 156433.0 |
| 2011-01-20 | J7 | Futures | 0.015194 | 0.015202 | 0.015006 | 0.015023 | 381.0 |
| 2011-01-20 | JB | Futures | 120.34 | 120.83 | 120.32 | 120.79 | 2689.0 |
> showing 50 of 94 rows — these rows as CSV