PREVIEW / stock_daily / 2009-10-06
file: by_date/stock_daily/2009/2009-10-06.parquet size: 186 KB rows: 5,850 symbols: 3,478
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-10-06 | AAPL | Stock | 6.705 | 6.7861 | 6.6893 | 6.7861 | 605085600.0 |
| 2009-10-06 | MSFT | Stock | 24.68 | 25.21 | 24.66 | 25.11 | 48795300.0 |
| 2009-10-06 | NVDA | Stock | 0.3488 | 0.3562 | 0.3462 | 0.3502 | 761272000.0 |
| 2009-10-06 | AMZN | Stock | 4.4665 | 4.554 | 4.42 | 4.5455 | 139274000.0 |
| 2009-10-06 | TLT | Stock | 98.76 | 98.8 | 97.98 | 98.04 | 3936124.0 |
| 2009-10-06 | ES | Stock | 23.29 | 23.4 | 23.12 | 23.31 | 1708400.0 |
| 2009-10-06 | CL | Stock | 38.565 | 39.06 | 38.54 | 38.96 | 4391200.0 |
| 2009-10-06 | A | Stock | 19.4349 | 19.6495 | 19.2561 | 19.4707 | 4036585.0 |
| 2009-10-06 | AABA-DELISTED | Stock | 16.96 | 17.35 | 16.95 | 17.3 | 20905899.0 |
| 2009-10-06 | AACC-DELISTED | Stock | 7.36 | 7.42 | 7.1 | 7.2 | 21682.0 |
| 2009-10-06 | AACG | Stock | 6.02 | 6.1 | 5.98 | 6.05 | 9100.0 |
| 2009-10-06 | AAI-DELISTED | Stock | 6.12 | 6.24 | 6.06 | 6.12 | 2574854.0 |
| 2009-10-06 | AAIC-DELISTED | Stock | 8.8 | 10.0 | 8.8 | 10.0 | 1319614.0 |
| 2009-10-06 | AAME | Stock | 1.1 | 1.17 | 1.06 | 1.15 | 86200.0 |
| 2009-10-06 | AAON | Stock | 3.763 | 3.7709 | 3.6958 | 3.7472 | 449550.0 |
| 2009-10-06 | AAP | Stock | 37.94 | 38.68 | 37.74 | 38.6 | 3566800.0 |
| 2009-10-06 | AATI-DELISTED | Stock | 3.31 | 3.33 | 3.11 | 3.24 | 1250320.0 |
| 2009-10-06 | AAU-DELISTED | Stock | 0.73 | 0.77 | 0.73 | 0.77 | 644730.0 |
| 2009-10-06 | AAUAF-DELISTED | Stock | 0.73 | 0.77 | 0.73 | 0.77 | 650535.0 |
| 2009-10-06 | AAV-DELISTED | Stock | 6.47 | 6.77 | 6.47 | 6.56 | 857339.0 |
| 2009-10-06 | AAWW-DELISTED | Stock | 30.47 | 31.91 | 30.32 | 31.6 | 222428.0 |
| 2009-10-06 | AAXJ | Stock | 52.79 | 53.25 | 52.53 | 52.9 | 120347.0 |
| 2009-10-06 | AAXN-DELISTED | Stock | 4.58 | 4.6 | 4.51 | 4.54 | 216480.0 |
| 2009-10-06 | AB | Stock | 25.89 | 26.4 | 25.73 | 26.07 | 368000.0 |
| 2009-10-06 | ABAX-DELISTED | Stock | 26.5 | 26.98 | 26.07 | 26.98 | 200339.0 |
| 2009-10-06 | ABB-DELISTED | Stock | 19.84 | 20.28 | 19.84 | 20.03 | 3031317.0 |
| 2009-10-06 | ABBC-DELISTED | Stock | 7.78 | 7.95 | 7.71 | 7.94 | 31913.0 |
| 2009-10-06 | ABBNY-DELISTED | Stock | 19.84 | 20.28 | 19.84 | 20.03 | 3031077.0 |
| 2009-10-06 | ABC-DELISTED | Stock | 22.03 | 22.23 | 21.76 | 22.13 | 2662619.0 |
| 2009-10-06 | ABCB | Stock | 7.2235 | 7.2235 | 6.8217 | 7.0274 | 10203.0 |
| 2009-10-06 | ABCO-DELISTED | Stock | 12.77 | 13.09 | 12.77 | 13.08 | 96260.0 |
| 2009-10-06 | ABCW-DELISTED | Stock | 1.2012 | 1.2598 | 1.2012 | 1.25 | 65760.0 |
| 2009-10-06 | ABD-DELISTED | Stock | 7.07 | 7.16 | 6.81 | 7.16 | 508180.0 |
| 2009-10-06 | ABE-DELISTED | Stock | 17.48 | 17.75 | 17.48 | 17.7 | 24208.0 |
| 2009-10-06 | ABEO | Stock | 4250.0 | 4375.0 | 4075.0 | 4125.0 | 152.0 |
| 2009-10-06 | ABFS-DELISTED | Stock | 27.46 | 28.44 | 27.15 | 27.94 | 391531.0 |
| 2009-10-06 | ABG | Stock | 12.81 | 13.21 | 12.66 | 13.0 | 164900.0 |
| 2009-10-06 | ABII-DELISTED | Stock | 37.24 | 38.75 | 36.8 | 37.22 | 69811.0 |
| 2009-10-06 | ABK-DELISTED | Stock | 1.58 | 1.62 | 1.52 | 1.55 | 11707946.0 |
| 2009-10-06 | ABM | Stock | 19.74 | 20.17 | 19.61 | 20.04 | 187000.0 |
| 2009-10-06 | ABMD-DELISTED | Stock | 10.03 | 10.3 | 9.97 | 10.14 | 362575.0 |
| 2009-10-06 | ABR | Stock | 2.68 | 2.8 | 2.63 | 2.63 | 162600.0 |
| 2009-10-06 | ABT | Stock | 24.2299 | 24.3307 | 23.918 | 24.0764 | 18420383.0 |
| 2009-10-06 | ABTL-DELISTED | Stock | 3.1 | 3.3 | 3.0505 | 3.3 | 2061.0 |
| 2009-10-06 | ABV-DELISTED | Stock | 87.19 | 90.26 | 87.19 | 89.27 | 670147.0 |
| 2009-10-06 | ABVA-DELISTED | Stock | 2.33 | 2.6885 | 2.15 | 2.6885 | 946.0 |
| 2009-10-06 | ABVT-DELISTED | Stock | 48.04 | 48.85 | 48.04 | 48.5 | 68500.0 |
| 2009-10-06 | ABX-DELISTED | Stock | 38.24 | 39.48 | 38.16 | 38.92 | 21285511.0 |
| 2009-10-06 | ACAD | Stock | 1.88 | 2.08 | 1.81 | 1.9 | 9429700.0 |
| 2009-10-06 | ACAP-DELISTED | Stock | 30.19 | 30.19 | 29.76 | 30.09 | 27992.0 |
> showing 50 of 5,850 rows — these rows as CSV