PREVIEW / futures_daily / 2010-11-03
file: by_date/futures_daily/2010/2010-11-03.parquet size: 9 KB rows: 91
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-11-03 | ES | Futures | 1169.09 | 1174.23 | 1156.1 | 1173.5 | 2361808.0 |
| 2010-11-03 | NQ | Futures | 2439.29 | 2455.44 | 2415.19 | 2454.03 | 348195.0 |
| 2010-11-03 | YM | Futures | 10376.8 | 10409.4 | 10279.1 | 10400.1 | 149668.0 |
| 2010-11-03 | CL | Futures | 173.94 | 175.98 | 172.29 | 174.6 | 393735.0 |
| 2010-11-03 | GC | Futures | 1844.9 | 1855.1 | 1801.7 | 1818.1 | 258025.0 |
| 2010-11-03 | ZN | Futures | 104.496701 | 104.935437 | 104.161196 | 104.535413 | 1346316.0 |
| 2010-11-03 | A6 | Futures | 0.834 | 0.84055 | 0.82586 | 0.83543 | 120815.0 |
| 2010-11-03 | AD | Futures | 0.98064 | 0.98519 | 0.97439 | 0.984 | 106967.0 |
| 2010-11-03 | B | Futures | 73.19 | 74.08 | 72.71 | 73.66 | 106422.0 |
| 2010-11-03 | B6 | Futures | 1.6639 | 1.6796 | 1.6613 | 1.6723 | 139808.0 |
| 2010-11-03 | BFX | Futures | 3078.3 | 3078.3 | 3033.2 | 3039.0 | 259.0 |
| 2010-11-03 | BR | Futures | 0.25135 | 0.25135 | 0.24956 | 0.25061 | 134.0 |
| 2010-11-03 | BZ | Futures | 78.06 | 78.17 | 77.91 | 77.91 | 451.0 |
| 2010-11-03 | C | Futures | 2030.0 | 2035.0 | 1993.0 | 1994.0 | 4334.0 |
| 2010-11-03 | CB | Futures | 101.644 | 101.644 | 101.644 | 101.644 | 6.0 |
| 2010-11-03 | CC | Futures | 2325.0 | 2335.0 | 2283.0 | 2288.0 | 8528.0 |
| 2010-11-03 | CSC | Futures | 3.415 | 3.439 | 3.415 | 3.439 | 1.0 |
| 2010-11-03 | CT | Futures | 113.86 | 117.82 | 111.99 | 114.71 | 27582.0 |
| 2010-11-03 | DC | Futures | 23.58 | 23.64 | 23.15 | 23.2 | 532.0 |
| 2010-11-03 | DX | Futures | 77.12 | 77.621 | 75.475 | 76.867 | 41191.0 |
| 2010-11-03 | E1 | Futures | 1.34076 | 1.35533 | 1.33669 | 1.35008 | 40857.0 |
| 2010-11-03 | E6 | Futures | 1.65897 | 1.67979 | 1.65412 | 1.6676 | 438195.0 |
| 2010-11-03 | E7 | Futures | 1.6464 | 1.6718 | 1.6416 | 1.6549 | 5850.0 |
| 2010-11-03 | ED | Futures | 94.7458 | 94.7553 | 94.7411 | 94.7506 | 133796.0 |
| 2010-11-03 | ER | Futures | 97.178 | 97.193 | 97.178 | 97.188 | 89264.0 |
| 2010-11-03 | EW | Futures | 822.5 | 825.3 | 814.1 | 824.7 | 26828.0 |
| 2010-11-03 | FBTP | Futures | 66.96 | 67.19 | 66.96 | 67.01 | 4083.0 |
| 2010-11-03 | FCE | Futures | 2561.6 | 2575.9 | 2533.0 | 2544.6 | 112833.0 |
| 2010-11-03 | FDAX | Futures | 7178.5 | 7199.4 | 7108.0 | 7117.7 | 134306.0 |
| 2010-11-03 | FESX | Futures | 1781.2 | 1786.8 | 1753.1 | 1758.8 | 1223544.0 |
| 2010-11-03 | FEU3 | Futures | 97.751 | 97.751 | 97.751 | 97.751 | 150.0 |
| 2010-11-03 | FGBL | Futures | 102.56 | 103.05 | 102.55 | 102.99 | 845780.0 |
| 2010-11-03 | FGBM | Futures | 105.71 | 106.06 | 105.7 | 106.02 | 488132.0 |
| 2010-11-03 | FGBS | Futures | 107.199 | 107.272 | 107.194 | 107.253 | 345412.0 |
| 2010-11-03 | FGBX | Futures | 107.12 | 108.15 | 106.92 | 108.06 | 4271.0 |
| 2010-11-03 | FTDX | Futures | 723.1 | 725.8 | 717.4 | 718.3 | 612.0 |
| 2010-11-03 | FTI | Futures | 273.9 | 274.5 | 269.81 | 271.41 | 29051.0 |
| 2010-11-03 | FTUK | Futures | 3978.8 | 3988.8 | 3951.5 | 3962.6 | 81761.0 |
| 2010-11-03 | G | Futures | 84.23 | 84.42 | 84.13 | 84.34 | 90001.0 |
| 2010-11-03 | GF | Futures | 280.985 | 280.985 | 277.963 | 279.159 | 717.0 |
| 2010-11-03 | GSCI | Futures | 956.84 | 960.72 | 944.45 | 952.71 | 151.0 |
| 2010-11-03 | HE | Futures | 89.551 | 91.445 | 89.212 | 90.363 | 20893.0 |
| 2010-11-03 | HG | Futures | 5.1052 | 5.1379 | 5.0224 | 5.0518 | 35875.0 |
| 2010-11-03 | HO | Futures | 1.9476 | 1.9732 | 1.938 | 1.9639 | 60400.0 |
| 2010-11-03 | HRC | Futures | 2504.7 | 2504.7 | 2504.7 | 2504.7 | 0.0 |
| 2010-11-03 | J1 | Futures | 0.0155782 | 0.0155908 | 0.0153998 | 0.0154538 | 136978.0 |
| 2010-11-03 | J7 | Futures | 0.015481 | 0.015481 | 0.0153 | 0.015348 | 264.0 |
| 2010-11-03 | KC | Futures | 495.98 | 498.09 | 478.12 | 486.43 | 17371.0 |
| 2010-11-03 | KE | Futures | 3131.13 | 3150.95 | 3075.85 | 3114.45 | 9638.0 |
| 2010-11-03 | L | Futures | 98.165 | 98.175 | 98.155 | 98.175 | 12037.0 |
> showing 50 of 91 rows — these rows as CSV