PREVIEW / stock_daily / 2010-11-05
file: by_date/stock_daily/2010/2010-11-05.parquet size: 195 KB rows: 6,041 symbols: 3,539
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-05 | AAPL | Stock | 11.3568 | 11.4132 | 11.3125 | 11.3261 | 361253200.0 |
| 2010-11-05 | MSFT | Stock | 27.17 | 27.19 | 26.53 | 26.85 | 110953700.0 |
| 2010-11-05 | NVDA | Stock | 0.3123 | 0.318 | 0.3108 | 0.3153 | 735116000.0 |
| 2010-11-05 | AMZN | Stock | 8.4675 | 8.5825 | 8.4295 | 8.5385 | 104244000.0 |
| 2010-11-05 | TSLA | Stock | 1.658 | 1.6647 | 1.5813 | 1.6293 | 15165000.0 |
| 2010-11-05 | TLT | Stock | 98.35 | 98.8 | 97.98 | 97.98 | 12434996.0 |
| 2010-11-05 | ES | Stock | 31.89 | 31.98 | 31.6 | 31.75 | 1210500.0 |
| 2010-11-05 | CL | Stock | 39.15 | 39.15 | 38.565 | 38.785 | 5781000.0 |
| 2010-11-05 | A | Stock | 25.7296 | 26.0372 | 25.6438 | 26.0229 | 3263212.0 |
| 2010-11-05 | AABA-DELISTED | Stock | 16.18 | 16.4 | 16.18 | 16.26 | 12841921.0 |
| 2010-11-05 | AACC-DELISTED | Stock | 6.05 | 6.07 | 6.03 | 6.04 | 62892.0 |
| 2010-11-05 | AACG | Stock | 3.36 | 3.53 | 3.36 | 3.53 | 1000.0 |
| 2010-11-05 | AAI-DELISTED | Stock | 7.47 | 7.47 | 7.44 | 7.45 | 1234434.0 |
| 2010-11-05 | AAIC-DELISTED | Stock | 24.55 | 25.47 | 24.55 | 25.43 | 49021.0 |
| 2010-11-05 | AAME | Stock | 1.7 | 1.82 | 1.7 | 1.82 | 4400.0 |
| 2010-11-05 | AAON | Stock | 4.9343 | 4.9521 | 4.9185 | 4.9264 | 143269.0 |
| 2010-11-05 | AAP | Stock | 65.99 | 66.11 | 65.37 | 65.63 | 647800.0 |
| 2010-11-05 | AATI-DELISTED | Stock | 3.82 | 3.82 | 3.74 | 3.79 | 194698.0 |
| 2010-11-05 | AAU-DELISTED | Stock | 3.05 | 3.19 | 3.01 | 3.06 | 411115.0 |
| 2010-11-05 | AAUAF-DELISTED | Stock | 3.05 | 3.19 | 3.01 | 3.06 | 412215.0 |
| 2010-11-05 | AAV-DELISTED | Stock | 6.46 | 6.6 | 6.43 | 6.52 | 350799.0 |
| 2010-11-05 | AAWW-DELISTED | Stock | 60.89 | 61.44 | 60.5001 | 61.16 | 271802.0 |
| 2010-11-05 | AAXJ | Stock | 65.4 | 65.71 | 65.28 | 65.56 | 390311.0 |
| 2010-11-05 | AAXN-DELISTED | Stock | 4.12 | 4.2 | 4.07 | 4.11 | 256360.0 |
| 2010-11-05 | AB | Stock | 24.66 | 25.79 | 24.66 | 25.27 | 711000.0 |
| 2010-11-05 | ABAC-DELISTED | Stock | 7.1 | 8.13 | 6.88 | 7.68 | 589718.0 |
| 2010-11-05 | ABAX-DELISTED | Stock | 25.26 | 25.49 | 25.0425 | 25.46 | 70007.0 |
| 2010-11-05 | ABB-DELISTED | Stock | 21.57 | 21.71 | 21.56 | 21.64 | 1828886.0 |
| 2010-11-05 | ABBC-DELISTED | Stock | 11.75 | 11.88 | 11.48 | 11.5 | 29339.0 |
| 2010-11-05 | ABBNY-DELISTED | Stock | 21.57 | 21.71 | 21.56 | 21.67 | 1832896.0 |
| 2010-11-05 | ABC-DELISTED | Stock | 31.91 | 32.08 | 31.635 | 31.67 | 2556664.0 |
| 2010-11-05 | ABCB | Stock | 9.3 | 9.3 | 9.07 | 9.14 | 42700.0 |
| 2010-11-05 | ABCD-DELISTED | Stock | 3.25 | 3.25 | 3.11 | 3.23 | 122808.0 |
| 2010-11-05 | ABCO-DELISTED | Stock | 24.37 | 25.2 | 23.45 | 25.19 | 131029.0 |
| 2010-11-05 | ABCW-DELISTED | Stock | 0.5104 | 0.5987 | 0.5104 | 0.53 | 84620.0 |
| 2010-11-05 | ABD-DELISTED | Stock | 6.2349 | 6.5551 | 6.1949 | 6.5351 | 320380.0 |
| 2010-11-05 | ABE-DELISTED | Stock | 19.37 | 19.37 | 19.17 | 19.37 | 24890.0 |
| 2010-11-05 | ABEO | Stock | 3712.5 | 3875.0 | 3662.5 | 3762.5 | 72.0 |
| 2010-11-05 | ABFS-DELISTED | Stock | 25.98 | 26.27 | 25.41 | 25.48 | 376512.0 |
| 2010-11-05 | ABG | Stock | 15.91 | 16.07 | 15.57 | 15.81 | 191000.0 |
| 2010-11-05 | ABK-DELISTED | Stock | 0.5398 | 0.5398 | 0.4961 | 0.5 | 13452616.0 |
| 2010-11-05 | ABM | Stock | 23.91 | 24.15 | 23.78 | 23.92 | 135500.0 |
| 2010-11-05 | ABMD-DELISTED | Stock | 11.94 | 12.0 | 11.69 | 11.88 | 114004.0 |
| 2010-11-05 | ABR | Stock | 5.5 | 5.52 | 5.38 | 5.41 | 41900.0 |
| 2010-11-05 | ABT | Stock | 24.4026 | 24.4986 | 24.2827 | 24.4314 | 13746978.0 |
| 2010-11-05 | ABTL-DELISTED | Stock | 4.1 | 4.2 | 4.1 | 4.15 | 5750.0 |
| 2010-11-05 | ABV-DELISTED | Stock | 142.46 | 143.64 | 141.98 | 143.62 | 358999.0 |
| 2010-11-05 | ABVA-DELISTED | Stock | 3.0901 | 3.25 | 3.09 | 3.25 | 6243.0 |
| 2010-11-05 | ABVT-DELISTED | Stock | 59.95 | 63.23 | 59.87 | 62.7 | 435459.0 |
| 2010-11-05 | ABX-DELISTED | Stock | 49.24 | 49.96 | 48.81 | 49.2 | 9581894.0 |
> showing 50 of 6,041 rows — these rows as CSV