PREVIEW / stock_daily / 2010-11-04
file: by_date/stock_daily/2010/2010-11-04.parquet size: 195 KB rows: 6,049 symbols: 3,548
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-04 | AAPL | Stock | 11.2661 | 11.435 | 11.2511 | 11.3668 | 642488000.0 |
| 2010-11-04 | MSFT | Stock | 27.41 | 27.43 | 27.01 | 27.14 | 93599300.0 |
| 2010-11-04 | NVDA | Stock | 0.3125 | 0.3158 | 0.3095 | 0.31 | 700016000.0 |
| 2010-11-04 | AMZN | Stock | 8.493 | 8.6265 | 8.42 | 8.4465 | 147918000.0 |
| 2010-11-04 | TSLA | Stock | 1.5067 | 1.6887 | 1.4767 | 1.66 | 28110000.0 |
| 2010-11-04 | TLT | Stock | 99.17 | 99.8705 | 99.08 | 99.69 | 13247459.0 |
| 2010-11-04 | ES | Stock | 31.88 | 32.1 | 31.79 | 31.84 | 2147100.0 |
| 2010-11-04 | CL | Stock | 39.5 | 39.555 | 39.095 | 39.22 | 6851000.0 |
| 2010-11-04 | A | Stock | 25.3934 | 25.7797 | 25.329 | 25.7439 | 3856663.0 |
| 2010-11-04 | AABA-DELISTED | Stock | 16.32 | 16.35 | 16.02 | 16.2101 | 24680314.0 |
| 2010-11-04 | AACC-DELISTED | Stock | 6.04 | 6.09 | 5.99 | 6.08 | 51651.0 |
| 2010-11-04 | AAI-DELISTED | Stock | 7.45 | 7.5 | 7.44 | 7.46 | 3346532.0 |
| 2010-11-04 | AAIC-DELISTED | Stock | 24.35 | 24.52 | 24.28 | 24.52 | 55056.0 |
| 2010-11-04 | AAME | Stock | 1.69 | 1.7 | 1.65 | 1.7 | 6000.0 |
| 2010-11-04 | AAON | Stock | 4.9383 | 4.9521 | 4.883 | 4.9284 | 350831.0 |
| 2010-11-04 | AAP | Stock | 65.62 | 65.81 | 65.08 | 65.81 | 498100.0 |
| 2010-11-04 | AATI-DELISTED | Stock | 3.8 | 3.84 | 3.73 | 3.8 | 344845.0 |
| 2010-11-04 | AAU-DELISTED | Stock | 2.9 | 3.09 | 2.89 | 3.0401 | 586540.0 |
| 2010-11-04 | AAUAF-DELISTED | Stock | 2.9 | 3.09 | 2.89 | 3.0401 | 584540.0 |
| 2010-11-04 | AAV-DELISTED | Stock | 6.4 | 6.51 | 6.4 | 6.4899 | 742971.0 |
| 2010-11-04 | AAWW-DELISTED | Stock | 60.0 | 61.0 | 59.11 | 60.15 | 406773.0 |
| 2010-11-04 | AAXJ | Stock | 65.07 | 65.53 | 64.83 | 65.45 | 702173.0 |
| 2010-11-04 | AAXN-DELISTED | Stock | 3.99 | 4.18 | 3.97 | 4.12 | 617350.0 |
| 2010-11-04 | AB | Stock | 24.3 | 24.72 | 24.09 | 24.52 | 1114700.0 |
| 2010-11-04 | ABAC-DELISTED | Stock | 6.85 | 7.6102 | 6.85 | 7.02 | 414636.0 |
| 2010-11-04 | ABAX-DELISTED | Stock | 24.99 | 25.26 | 24.82 | 25.17 | 99662.0 |
| 2010-11-04 | ABB-DELISTED | Stock | 21.63 | 21.75 | 21.5 | 21.74 | 2168824.0 |
| 2010-11-04 | ABBC-DELISTED | Stock | 11.43 | 12.0 | 11.39 | 11.75 | 81902.0 |
| 2010-11-04 | ABBNY-DELISTED | Stock | 21.63 | 21.75 | 21.5 | 21.75 | 2172536.0 |
| 2010-11-04 | ABC-DELISTED | Stock | 31.95 | 32.1 | 31.82 | 31.96 | 3817618.0 |
| 2010-11-04 | ABCB | Stock | 9.23 | 9.3 | 9.15 | 9.27 | 70600.0 |
| 2010-11-04 | ABCD-DELISTED | Stock | 3.22 | 3.3 | 3.19 | 3.27 | 42212.0 |
| 2010-11-04 | ABCO-DELISTED | Stock | 24.36 | 24.5 | 23.97 | 24.3 | 94556.0 |
| 2010-11-04 | ABCW-DELISTED | Stock | 0.54 | 0.59 | 0.52 | 0.52 | 75920.0 |
| 2010-11-04 | ABD-DELISTED | Stock | 6.26 | 6.35 | 6.12 | 6.19 | 297030.0 |
| 2010-11-04 | ABE-DELISTED | Stock | 19.16 | 19.42 | 19.16 | 19.28 | 86566.0 |
| 2010-11-04 | ABEO | Stock | 3625.0 | 3675.0 | 3625.0 | 3650.0 | 27.0 |
| 2010-11-04 | ABFS-DELISTED | Stock | 26.65 | 26.68 | 25.39 | 25.88 | 477225.0 |
| 2010-11-04 | ABG | Stock | 15.37 | 16.05 | 15.34 | 15.83 | 425800.0 |
| 2010-11-04 | ABK-DELISTED | Stock | 0.5608 | 0.57 | 0.4752 | 0.5248 | 26625179.0 |
| 2010-11-04 | ABM | Stock | 23.77 | 24.0 | 23.62 | 23.87 | 199600.0 |
| 2010-11-04 | ABMD-DELISTED | Stock | 11.09 | 11.95 | 11.09 | 11.88 | 277831.0 |
| 2010-11-04 | ABR | Stock | 5.29 | 5.48 | 5.28 | 5.45 | 127300.0 |
| 2010-11-04 | ABT | Stock | 24.6473 | 24.7481 | 24.3355 | 24.4122 | 19313464.0 |
| 2010-11-04 | ABTL-DELISTED | Stock | 4.2 | 4.3 | 4.1 | 4.2 | 5318.0 |
| 2010-11-04 | ABV-DELISTED | Stock | 140.88 | 144.29 | 140.85 | 142.34 | 509436.0 |
| 2010-11-04 | ABVA-DELISTED | Stock | 2.91 | 3.031 | 2.91 | 3.031 | 1760.0 |
| 2010-11-04 | ABVT-DELISTED | Stock | 59.42 | 60.04 | 59.23 | 59.52 | 449578.0 |
| 2010-11-04 | ABX-DELISTED | Stock | 49.87 | 50.07 | 49.19 | 49.31 | 16943299.0 |
| 2010-11-04 | ACAD | Stock | 0.75 | 0.76 | 0.74 | 0.76 | 242600.0 |
> showing 50 of 6,049 rows — these rows as CSV