PREVIEW / stock_daily / 2009-12-18
file: by_date/stock_daily/2009/2009-12-18.parquet size: 190 KB rows: 5,919 symbols: 3,509
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-12-18 | AAPL | Stock | 6.8989 | 6.9821 | 6.8786 | 6.9796 | 608770400.0 |
| 2009-12-18 | MSFT | Stock | 29.84 | 30.45 | 29.8 | 30.36 | 94118000.0 |
| 2009-12-18 | NVDA | Stock | 0.4242 | 0.4258 | 0.4155 | 0.4205 | 812828000.0 |
| 2009-12-18 | AMZN | Stock | 6.3955 | 6.4395 | 6.2825 | 6.424 | 192108000.0 |
| 2009-12-18 | TLT | Stock | 93.2 | 93.5 | 92.65 | 92.79 | 3789478.0 |
| 2009-12-18 | ES | Stock | 25.88 | 26.28 | 25.71 | 26.07 | 2329900.0 |
| 2009-12-18 | CL | Stock | 41.49 | 41.495 | 40.5 | 41.31 | 8689200.0 |
| 2009-12-18 | A | Stock | 21.1302 | 21.3376 | 20.9084 | 21.03 | 4618293.0 |
| 2009-12-18 | AABA-DELISTED | Stock | 15.94 | 16.13 | 15.78 | 16.13 | 26141906.0 |
| 2009-12-18 | AACC-DELISTED | Stock | 6.08 | 6.14 | 6.0 | 6.0 | 124799.0 |
| 2009-12-18 | AAI-DELISTED | Stock | 5.16 | 5.18 | 4.97 | 5.16 | 4569457.0 |
| 2009-12-18 | AAIC-DELISTED | Stock | 15.49 | 15.77 | 14.9 | 15.2 | 42443.0 |
| 2009-12-18 | AAME | Stock | 1.02 | 1.02 | 1.02 | 1.02 | 500.0 |
| 2009-12-18 | AAON | Stock | 3.8538 | 3.9131 | 3.8341 | 3.9131 | 888469.0 |
| 2009-12-18 | AAP | Stock | 41.06 | 41.18 | 40.63 | 40.92 | 1976000.0 |
| 2009-12-18 | AATI-DELISTED | Stock | 3.57 | 3.89 | 3.57 | 3.84 | 858338.0 |
| 2009-12-18 | AAU-DELISTED | Stock | 1.11 | 1.11 | 1.04 | 1.07 | 53832.0 |
| 2009-12-18 | AAUAF-DELISTED | Stock | 1.11 | 1.11 | 1.04 | 1.07 | 54924.0 |
| 2009-12-18 | AAV-DELISTED | Stock | 6.5 | 6.7 | 6.47 | 6.69 | 916658.0 |
| 2009-12-18 | AAWW-DELISTED | Stock | 37.0 | 37.4 | 36.0 | 36.93 | 894136.0 |
| 2009-12-18 | AAXJ | Stock | 54.26 | 54.64 | 54.09 | 54.6 | 317971.0 |
| 2009-12-18 | AAXN-DELISTED | Stock | 4.49 | 4.49 | 4.35 | 4.47 | 823647.0 |
| 2009-12-18 | AB | Stock | 26.21 | 26.3 | 25.91 | 25.93 | 737400.0 |
| 2009-12-18 | ABAX-DELISTED | Stock | 23.4 | 23.4 | 22.53 | 22.55 | 297135.0 |
| 2009-12-18 | ABB-DELISTED | Stock | 18.25 | 18.4 | 18.05 | 18.27 | 2419167.0 |
| 2009-12-18 | ABBC-DELISTED | Stock | 6.69 | 6.82 | 6.6 | 6.81 | 141583.0 |
| 2009-12-18 | ABBNY-DELISTED | Stock | 18.25 | 18.4 | 18.05 | 18.24 | 2419567.0 |
| 2009-12-18 | ABC-DELISTED | Stock | 26.0 | 26.15 | 25.78 | 26.04 | 4961567.0 |
| 2009-12-18 | ABCB | Stock | 6.5276 | 6.8021 | 6.165 | 6.6452 | 138554.0 |
| 2009-12-18 | ABCD-DELISTED | Stock | 4.9 | 5.91 | 4.9 | 5.91 | 210440.0 |
| 2009-12-18 | ABCO-DELISTED | Stock | 13.527 | 13.638 | 13.292 | 13.623 | 263623.0 |
| 2009-12-18 | ABCW-DELISTED | Stock | 0.58 | 0.5989 | 0.5788 | 0.58 | 117210.0 |
| 2009-12-18 | ABD-DELISTED | Stock | 7.46 | 7.8 | 7.31 | 7.42 | 522140.0 |
| 2009-12-18 | ABE-DELISTED | Stock | 16.92 | 16.92 | 16.43 | 16.44 | 11421.0 |
| 2009-12-18 | ABEO | Stock | 3800.0 | 4025.0 | 3737.5 | 3975.0 | 24.0 |
| 2009-12-18 | ABFS-DELISTED | Stock | 31.3 | 32.59 | 30.895 | 31.23 | 1725733.0 |
| 2009-12-18 | ABG | Stock | 11.53 | 11.57 | 11.06 | 11.11 | 459800.0 |
| 2009-12-18 | ABII-DELISTED | Stock | 36.55 | 37.46 | 35.24 | 35.28 | 35915.0 |
| 2009-12-18 | ABK-DELISTED | Stock | 0.79 | 0.81 | 0.77 | 0.77 | 13026372.0 |
| 2009-12-18 | ABM | Stock | 19.02 | 20.25 | 19.02 | 20.23 | 794700.0 |
| 2009-12-18 | ABMD-DELISTED | Stock | 8.18 | 8.28 | 8.075 | 8.16 | 343959.0 |
| 2009-12-18 | ABR | Stock | 1.71 | 1.74 | 1.68 | 1.68 | 73400.0 |
| 2009-12-18 | ABT | Stock | 25.7892 | 25.7892 | 25.4294 | 25.5925 | 19611088.0 |
| 2009-12-18 | ABTL-DELISTED | Stock | 4.2071 | 4.5076 | 4.0354 | 4.25 | 17349.0 |
| 2009-12-18 | ABV-DELISTED | Stock | 95.35 | 96.27 | 94.76 | 95.65 | 476564.0 |
| 2009-12-18 | ABVA-DELISTED | Stock | 2.305 | 3.99 | 2.3 | 3.9 | 26480.0 |
| 2009-12-18 | ABVT-DELISTED | Stock | 62.61 | 65.89 | 62.41 | 65.88 | 381040.0 |
| 2009-12-18 | ABX-DELISTED | Stock | 38.45 | 39.62 | 38.13 | 39.48 | 18462969.0 |
| 2009-12-18 | ACAD | Stock | 1.35 | 1.38 | 1.28 | 1.34 | 721700.0 |
| 2009-12-18 | ACAP-DELISTED | Stock | 28.93 | 28.93 | 28.33 | 28.62 | 239017.0 |
> showing 50 of 5,919 rows — these rows as CSV