PREVIEW / futures_daily / 2009-01-15
file: by_date/futures_daily/2009/2009-01-15.parquet size: 8 KB rows: 87
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-01-15 | ES | Futures | 792.73 | 801.23 | 767.47 | 792.49 | 3371389.0 |
| 2009-01-15 | NQ | Futures | 1302.73 | 1331.52 | 1272.83 | 1316.15 | 384576.0 |
| 2009-01-15 | YM | Futures | 7268.3 | 7338.6 | 7074.2 | 7267.4 | 262159.0 |
| 2009-01-15 | CL | Futures | 147.67 | 150.39 | 135.91 | 144.64 | 272603.0 |
| 2009-01-15 | GC | Futures | 1129.7 | 1146.2 | 1117.5 | 1125.6 | 134944.0 |
| 2009-01-15 | ZN | Futures | 97.248324 | 97.547145 | 96.93755 | 97.164654 | 454528.0 |
| 2009-01-15 | A6 | Futures | 0.52051 | 0.52892 | 0.51567 | 0.52598 | 40902.0 |
| 2009-01-15 | AD | Futures | 0.7869 | 0.79132 | 0.77452 | 0.78513 | 34376.0 |
| 2009-01-15 | B | Futures | 49.16 | 51.16 | 46.48 | 49.2 | 149258.0 |
| 2009-01-15 | B6 | Futures | 1.5148 | 1.5243 | 1.5017 | 1.5213 | 63885.0 |
| 2009-01-15 | BFX | Futures | 2074.6 | 2074.6 | 2026.2 | 2043.5 | 2429.0 |
| 2009-01-15 | BR | Futures | 0.14976 | 0.15319 | 0.14976 | 0.15319 | 3.0 |
| 2009-01-15 | BZ | Futures | 50.33 | 50.33 | 46.78 | 49.39 | 139.0 |
| 2009-01-15 | C | Futures | 1727.0 | 1738.0 | 1707.0 | 1728.0 | 6567.0 |
| 2009-01-15 | CB | Futures | 77.333 | 77.333 | 76.672 | 76.672 | 22.0 |
| 2009-01-15 | CC | Futures | 2104.0 | 2116.0 | 2074.0 | 2088.0 | 8576.0 |
| 2009-01-15 | CT | Futures | 44.75 | 47.7 | 44.41 | 47.24 | 7224.0 |
| 2009-01-15 | DC | Futures | 26.43 | 26.43 | 25.63 | 25.9 | 305.0 |
| 2009-01-15 | DX | Futures | 88.362 | 89.093 | 87.895 | 88.3 | 3984.0 |
| 2009-01-15 | E1 | Futures | 1.19026 | 1.19451 | 1.17431 | 1.18521 | 45045.0 |
| 2009-01-15 | E6 | Futures | 1.55565 | 1.56547 | 1.53895 | 1.55553 | 227300.0 |
| 2009-01-15 | E7 | Futures | 1.5375 | 1.5471 | 1.5216 | 1.5377 | 2932.0 |
| 2009-01-15 | EBM | Futures | 222.42 | 224.72 | 220.89 | 224.34 | 2183.0 |
| 2009-01-15 | ED | Futures | 93.3168 | 93.3309 | 93.119 | 93.1849 | 335729.0 |
| 2009-01-15 | ER | Futures | 96.135 | 96.204 | 96.008 | 96.096 | 333628.0 |
| 2009-01-15 | EW | Futures | 488.3 | 502.0 | 472.0 | 496.3 | 48003.0 |
| 2009-01-15 | FCE | Futures | 1881.1 | 1903.1 | 1831.0 | 1856.4 | 90436.0 |
| 2009-01-15 | FDAX | Futures | 4787.6 | 4877.1 | 4699.2 | 4741.7 | 210271.0 |
| 2009-01-15 | FESX | Futures | 1309.9 | 1331.2 | 1284.1 | 1296.1 | 1756209.0 |
| 2009-01-15 | FEU3 | Futures | 96.687 | 96.726 | 96.637 | 96.662 | 2614.0 |
| 2009-01-15 | FGBL | Futures | 94.19 | 94.51 | 93.88 | 94.25 | 742634.0 |
| 2009-01-15 | FGBM | Futures | 98.22 | 98.33 | 97.97 | 98.1 | 408490.0 |
| 2009-01-15 | FGBS | Futures | 103.599 | 103.618 | 103.397 | 103.455 | 541667.0 |
| 2009-01-15 | FGBX | Futures | 85.11 | 85.94 | 85.06 | 85.51 | 2892.0 |
| 2009-01-15 | FTDX | Futures | 408.1 | 416.1 | 395.6 | 409.9 | 1067.0 |
| 2009-01-15 | FTI | Futures | 198.3 | 200.36 | 194.19 | 195.72 | 16500.0 |
| 2009-01-15 | FTUK | Futures | 2709.2 | 2739.4 | 2656.8 | 2668.9 | 167928.0 |
| 2009-01-15 | G | Futures | 76.69 | 76.82 | 76.23 | 76.58 | 79239.0 |
| 2009-01-15 | GF | Futures | 266.097 | 266.097 | 260.907 | 264.554 | 618.0 |
| 2009-01-15 | GSCI | Futures | 816.76 | 817.11 | 780.29 | 805.62 | 109.0 |
| 2009-01-15 | HE | Futures | 115.502 | 115.841 | 114.246 | 115.647 | 5635.0 |
| 2009-01-15 | HG | Futures | 2.0795 | 2.1302 | 2.0176 | 2.0458 | 12974.0 |
| 2009-01-15 | HO | Futures | 1.6322 | 1.6854 | 1.5815 | 1.6495 | 27152.0 |
| 2009-01-15 | HRC | Futures | 3130.5 | 3130.5 | 3130.5 | 3130.5 | 0.0 |
| 2009-01-15 | J1 | Futures | 0.0142127 | 0.014291 | 0.0140435 | 0.0140978 | 88530.0 |
| 2009-01-15 | J7 | Futures | 0.014034 | 0.014114 | 0.013877 | 0.013928 | 96.0 |
| 2009-01-15 | JB | Futures | 117.22 | 117.34 | 116.95 | 117.22 | 26.0 |
| 2009-01-15 | KC | Futures | 328.67 | 330.53 | 323.67 | 325.53 | 7020.0 |
| 2009-01-15 | KE | Futures | 2995.4 | 3017.89 | 2951.69 | 2970.42 | 5119.0 |
| 2009-01-15 | L | Futures | 96.945 | 96.945 | 96.856 | 96.871 | 84620.0 |
> showing 50 of 87 rows — these rows as CSV