PREVIEW / stock_daily / 2009-01-22
file: by_date/stock_daily/2009/2009-01-22.parquet size: 174 KB rows: 5,680 symbols: 3,393
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-01-22 | AAPL | Stock | 3.1443 | 3.2143 | 3.065 | 3.1557 | 1409528400.0 |
| 2009-01-22 | MSFT | Stock | 18.05 | 18.18 | 17.07 | 17.11 | 222436600.0 |
| 2009-01-22 | NVDA | Stock | 0.183 | 0.1905 | 0.1788 | 0.1855 | 547656000.0 |
| 2009-01-22 | AMZN | Stock | 2.471 | 2.544 | 2.413 | 2.497 | 142666000.0 |
| 2009-01-22 | TLT | Stock | 110.6 | 110.77 | 107.88 | 108.54 | 4016596.0 |
| 2009-01-22 | CL | Stock | 31.275 | 31.495 | 30.67 | 31.285 | 7801600.0 |
| 2009-01-22 | A | Stock | 13.5265 | 13.7268 | 13.1974 | 13.5193 | 5811905.0 |
| 2009-01-22 | AABA-DELISTED | Stock | 11.32 | 11.51 | 10.9 | 11.28 | 17053739.0 |
| 2009-01-22 | AACC-DELISTED | Stock | 4.21 | 4.21 | 3.94 | 4.04 | 27058.0 |
| 2009-01-22 | AACG | Stock | 3.51 | 3.84 | 3.3 | 3.84 | 14400.0 |
| 2009-01-22 | AAI-DELISTED | Stock | 4.23 | 4.54 | 4.01 | 4.45 | 2794362.0 |
| 2009-01-22 | AAIC-DELISTED | Stock | 3.2 | 4.0 | 3.2 | 3.2 | 240519.0 |
| 2009-01-22 | AAON | Stock | 3.603 | 3.6049 | 3.3916 | 3.4686 | 291600.0 |
| 2009-01-22 | AAP | Stock | 32.28 | 33.19 | 31.7 | 32.71 | 2429000.0 |
| 2009-01-22 | AATI-DELISTED | Stock | 2.88 | 3.06 | 2.78 | 3.01 | 117543.0 |
| 2009-01-22 | AAU-DELISTED | Stock | 0.62 | 0.63 | 0.58 | 0.59 | 187211.0 |
| 2009-01-22 | AAUAF-DELISTED | Stock | 0.62 | 0.63 | 0.58 | 0.59 | 182311.0 |
| 2009-01-22 | AAV-DELISTED | Stock | 4.35 | 4.38 | 4.16 | 4.24 | 728548.0 |
| 2009-01-22 | AAWW-DELISTED | Stock | 17.01 | 17.58 | 16.26 | 16.98 | 173551.0 |
| 2009-01-22 | AAXJ | Stock | 29.14 | 30.06 | 29.14 | 29.43 | 113455.0 |
| 2009-01-22 | AAXN-DELISTED | Stock | 5.06 | 5.14 | 4.82 | 4.94 | 633723.0 |
| 2009-01-22 | AB | Stock | 16.78 | 17.88 | 15.5 | 16.23 | 1099100.0 |
| 2009-01-22 | ABAX-DELISTED | Stock | 14.08 | 14.49 | 13.73 | 14.09 | 199982.0 |
| 2009-01-22 | ABB-DELISTED | Stock | 12.31 | 12.66 | 12.1588 | 12.41 | 4763312.0 |
| 2009-01-22 | ABBC-DELISTED | Stock | 7.23 | 7.43 | 7.1 | 7.37 | 39951.0 |
| 2009-01-22 | ABBNY-DELISTED | Stock | 12.31 | 12.66 | 12.1588 | 12.42 | 5344312.0 |
| 2009-01-22 | ABC-DELISTED | Stock | 18.8 | 19.24 | 18.49 | 18.74 | 9794114.0 |
| 2009-01-22 | ABCB | Stock | 8.0924 | 8.1507 | 7.606 | 7.8103 | 15216.0 |
| 2009-01-22 | ABCO-DELISTED | Stock | 9.911 | 10.051 | 9.486 | 9.519 | 205097.0 |
| 2009-01-22 | ABCW-DELISTED | Stock | 2.47 | 2.55 | 2.19 | 2.26 | 244130.0 |
| 2009-01-22 | ABD-DELISTED | Stock | 2.18 | 2.32 | 1.94 | 2.01 | 272050.0 |
| 2009-01-22 | ABE-DELISTED | Stock | 12.28 | 12.28 | 11.71 | 11.8 | 36704.0 |
| 2009-01-22 | ABEO | Stock | 962.5 | 1187.5 | 962.5 | 1187.5 | 7.0 |
| 2009-01-22 | ABFS-DELISTED | Stock | 23.43 | 24.13 | 23.12 | 23.45 | 518922.0 |
| 2009-01-22 | ABG | Stock | 3.44 | 3.64 | 3.25 | 3.5 | 218000.0 |
| 2009-01-22 | ABII-DELISTED | Stock | 65.57 | 69.995 | 65.57 | 69.3 | 7259.0 |
| 2009-01-22 | ABK-DELISTED | Stock | 1.04 | 1.06 | 1.01 | 1.01 | 5501281.0 |
| 2009-01-22 | ABM | Stock | 16.7 | 17.0 | 16.08 | 16.39 | 343400.0 |
| 2009-01-22 | ABMD-DELISTED | Stock | 12.65 | 13.08 | 12.48 | 12.77 | 218936.0 |
| 2009-01-22 | ABR | Stock | 2.34 | 2.35 | 2.21 | 2.24 | 64000.0 |
| 2009-01-22 | ABT | Stock | 24.7817 | 25.535 | 24.6617 | 25.4342 | 25371613.0 |
| 2009-01-22 | ABTL-DELISTED | Stock | 2.0503 | 2.0503 | 1.8992 | 1.9997 | 3638.0 |
| 2009-01-22 | ABV-DELISTED | Stock | 40.54 | 41.65 | 39.99 | 41.28 | 872085.0 |
| 2009-01-22 | ABVA-DELISTED | Stock | 1.66 | 1.66 | 1.5 | 1.52 | 60100.0 |
| 2009-01-22 | ABVT-DELISTED | Stock | 34.0 | 34.0 | 34.0 | 34.0 | 160.0 |
| 2009-01-22 | ABX-DELISTED | Stock | 35.86 | 37.03 | 35.36 | 35.57 | 15996827.0 |
| 2009-01-22 | ACAD | Stock | 1.06 | 1.15 | 1.0 | 1.06 | 68200.0 |
| 2009-01-22 | ACAP-DELISTED | Stock | 40.85 | 41.67 | 39.73 | 41.03 | 76612.0 |
| 2009-01-22 | ACAS-DELISTED | Stock | 3.93 | 4.05 | 3.74 | 3.83 | 2490675.0 |
| 2009-01-22 | ACAT-DELISTED | Stock | 4.7 | 5.04 | 4.7 | 4.93 | 29333.0 |
> showing 50 of 5,680 rows — these rows as CSV