PREVIEW / futures_daily / 2010-12-23
file: by_date/futures_daily/2010/2010-12-23.parquet size: 9 KB rows: 93
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-23 | ES | Futures | 1234.83 | 1236.07 | 1229.67 | 1233.36 | 594048.0 |
| 2010-12-23 | NQ | Futures | 2539.39 | 2541.95 | 2524.63 | 2532.3 | 87905.0 |
| 2010-12-23 | YM | Futures | 10756.6 | 10784.7 | 10743.5 | 10783.8 | 33695.0 |
| 2010-12-23 | CL | Futures | 185.69 | 187.78 | 185.11 | 187.53 | 145007.0 |
| 2010-12-23 | GC | Futures | 1884.1 | 1888.0 | 1865.7 | 1876.5 | 81033.0 |
| 2010-12-23 | ZN | Futures | 99.737628 | 99.867614 | 99.37367 | 99.490657 | 335613.0 |
| 2010-12-23 | A6 | Futures | 0.8391 | 0.84546 | 0.83859 | 0.84385 | 46621.0 |
| 2010-12-23 | AD | Futures | 0.97726 | 0.98401 | 0.97468 | 0.98252 | 46626.0 |
| 2010-12-23 | B | Futures | 79.65 | 80.28 | 79.21 | 80.03 | 86645.0 |
| 2010-12-23 | B6 | Futures | 1.5952 | 1.6014 | 1.5937 | 1.5979 | 58337.0 |
| 2010-12-23 | BFX | Futures | 3043.7 | 3072.6 | 3025.3 | 3041.4 | 116.0 |
| 2010-12-23 | BR | Futures | 0.24964 | 0.25024 | 0.24964 | 0.2502 | 142.0 |
| 2010-12-23 | BZ | Futures | 84.24 | 85.07 | 84.14 | 84.81 | 550.0 |
| 2010-12-23 | C | Futures | 2207.0 | 2245.0 | 2202.0 | 2229.0 | 10064.0 |
| 2010-12-23 | CB | Futures | 100.908 | 100.908 | 100.908 | 100.908 | 22.0 |
| 2010-12-23 | CC | Futures | 2422.0 | 2467.0 | 2421.0 | 2451.0 | 6170.0 |
| 2010-12-23 | CSC | Futures | 3.319 | 3.319 | 3.319 | 3.319 | 12.0 |
| 2010-12-23 | CT | Futures | 127.01 | 133.29 | 127.01 | 127.01 | 14229.0 |
| 2010-12-23 | DC | Futures | 22.39 | 22.54 | 22.39 | 22.47 | 24.0 |
| 2010-12-23 | DX | Futures | 80.829 | 81.039 | 80.555 | 80.686 | 10054.0 |
| 2010-12-23 | E1 | Futures | 1.37824 | 1.38191 | 1.35792 | 1.36657 | 33016.0 |
| 2010-12-23 | E6 | Futures | 1.54943 | 1.55547 | 1.54387 | 1.55109 | 201048.0 |
| 2010-12-23 | E7 | Futures | 1.5385 | 1.5438 | 1.5325 | 1.5395 | 4061.0 |
| 2010-12-23 | EBM | Futures | 222.42 | 223.55 | 221.51 | 221.73 | 4389.0 |
| 2010-12-23 | ED | Futures | 94.7766 | 94.7814 | 94.7623 | 94.7718 | 88557.0 |
| 2010-12-23 | ER | Futures | 97.36 | 97.375 | 97.35 | 97.36 | 88724.0 |
| 2010-12-23 | EW | Futures | 898.1 | 899.0 | 894.6 | 895.1 | 9685.0 |
| 2010-12-23 | FBTP | Futures | 64.05 | 64.11 | 63.95 | 63.98 | 1101.0 |
| 2010-12-23 | FCE | Futures | 2623.7 | 2625.0 | 2596.7 | 2612.0 | 58799.0 |
| 2010-12-23 | FDAX | Futures | 7603.1 | 7603.6 | 7557.0 | 7574.7 | 45516.0 |
| 2010-12-23 | FESX | Futures | 1785.5 | 1786.8 | 1771.2 | 1778.1 | 333918.0 |
| 2010-12-23 | FEU3 | Futures | 97.929 | 97.929 | 97.914 | 97.919 | 45.0 |
| 2010-12-23 | FGBL | Futures | 99.32 | 99.53 | 99.05 | 99.11 | 228194.0 |
| 2010-12-23 | FGBM | Futures | 104.81 | 105.09 | 104.75 | 104.78 | 166851.0 |
| 2010-12-23 | FGBS | Futures | 107.336 | 107.494 | 107.336 | 107.38 | 161990.0 |
| 2010-12-23 | FGBX | Futures | 98.16 | 98.61 | 97.72 | 97.94 | 1872.0 |
| 2010-12-23 | FTDX | Futures | 743.3 | 749.5 | 743.3 | 746.4 | 295.0 |
| 2010-12-23 | FTI | Futures | 285.8 | 285.84 | 284.84 | 285.24 | 8651.0 |
| 2010-12-23 | FTUK | Futures | 4140.2 | 4146.1 | 4129.8 | 4143.0 | 33112.0 |
| 2010-12-23 | FXXP | Futures | 182.2 | 182.3 | 181.7 | 182.1 | 1143.0 |
| 2010-12-23 | G | Futures | 81.34 | 81.57 | 81.23 | 81.38 | 31453.0 |
| 2010-12-23 | GF | Futures | 303.537 | 304.471 | 302.042 | 302.54 | 1469.0 |
| 2010-12-23 | GSCI | Futures | 1013.16 | 1020.38 | 1010.48 | 1018.84 | 136.0 |
| 2010-12-23 | HE | Futures | 98.793 | 99.201 | 98.104 | 98.731 | 10589.0 |
| 2010-12-23 | HG | Futures | 5.6974 | 5.7107 | 5.6108 | 5.6754 | 18323.0 |
| 2010-12-23 | HO | Futures | 2.127 | 2.1399 | 2.1212 | 2.1348 | 5033.0 |
| 2010-12-23 | HRC | Futures | 2615.9 | 2615.9 | 2615.9 | 2615.9 | 0.0 |
| 2010-12-23 | J1 | Futures | 0.0150381 | 0.0151699 | 0.0150368 | 0.0151599 | 94721.0 |
| 2010-12-23 | J7 | Futures | 0.014975 | 0.01506 | 0.014966 | 0.015052 | 150.0 |
| 2010-12-23 | KC | Futures | 570.15 | 582.78 | 562.43 | 578.49 | 6284.0 |
> showing 50 of 93 rows — these rows as CSV