PREVIEW / stock_daily / 2009-03-19
file: by_date/stock_daily/2009/2009-03-19.parquet size: 174 KB rows: 5,741 symbols: 3,434
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-03-19 | AAPL | Stock | 3.6375 | 3.6857 | 3.5804 | 3.6293 | 500180800.0 |
| 2009-03-19 | MSFT | Stock | 17.37 | 17.45 | 16.92 | 17.14 | 58994600.0 |
| 2009-03-19 | NVDA | Stock | 0.2568 | 0.2568 | 0.2503 | 0.252 | 822648000.0 |
| 2009-03-19 | AMZN | Stock | 3.57 | 3.5955 | 3.462 | 3.505 | 176382000.0 |
| 2009-03-19 | TLT | Stock | 105.62 | 105.66 | 104.22 | 104.5 | 3650881.0 |
| 2009-03-19 | ES | Stock | 21.3 | 21.75 | 20.97 | 21.65 | 3377800.0 |
| 2009-03-19 | CL | Stock | 29.0 | 29.115 | 28.555 | 28.655 | 6654200.0 |
| 2009-03-19 | A | Stock | 10.4435 | 10.6795 | 10.3362 | 10.5436 | 3904474.0 |
| 2009-03-19 | AABA-DELISTED | Stock | 13.66 | 14.14 | 13.605 | 13.74 | 25508891.0 |
| 2009-03-19 | AACC-DELISTED | Stock | 5.43 | 5.43 | 5.0 | 5.2 | 17401.0 |
| 2009-03-19 | AACG | Stock | 4.5 | 4.79 | 4.49 | 4.58 | 19700.0 |
| 2009-03-19 | AAI-DELISTED | Stock | 4.58 | 4.58 | 3.8 | 3.82 | 3679656.0 |
| 2009-03-19 | AAIC-DELISTED | Stock | 3.996 | 4.0 | 3.2 | 4.0 | 474281.0 |
| 2009-03-19 | AAME | Stock | 0.46 | 0.72 | 0.46 | 0.61 | 8200.0 |
| 2009-03-19 | AAON | Stock | 3.7511 | 3.7847 | 3.5852 | 3.6385 | 407531.0 |
| 2009-03-19 | AAP | Stock | 41.75 | 41.75 | 40.11 | 41.06 | 1545100.0 |
| 2009-03-19 | AATI-DELISTED | Stock | 3.6 | 3.64 | 3.35 | 3.58 | 202729.0 |
| 2009-03-19 | AAU-DELISTED | Stock | 0.7 | 0.8 | 0.7 | 0.79 | 180856.0 |
| 2009-03-19 | AAUAF-DELISTED | Stock | 0.7 | 0.8 | 0.7 | 0.79 | 181256.0 |
| 2009-03-19 | AAV-DELISTED | Stock | 2.97 | 3.03 | 2.34 | 2.46 | 4817869.0 |
| 2009-03-19 | AAWW-DELISTED | Stock | 16.85 | 17.94 | 16.61 | 17.07 | 405098.0 |
| 2009-03-19 | AAXJ | Stock | 32.61 | 32.62 | 31.74 | 31.85 | 126669.0 |
| 2009-03-19 | AAXN-DELISTED | Stock | 4.43 | 4.4484 | 4.19 | 4.22 | 359823.0 |
| 2009-03-19 | AB | Stock | 14.65 | 14.65 | 13.11 | 13.21 | 679200.0 |
| 2009-03-19 | ABAX-DELISTED | Stock | 19.03 | 19.11 | 17.86 | 17.9 | 180757.0 |
| 2009-03-19 | ABB-DELISTED | Stock | 14.08 | 14.08 | 13.69 | 13.7 | 4083151.0 |
| 2009-03-19 | ABBC-DELISTED | Stock | 9.02 | 9.05 | 8.53 | 8.61 | 49521.0 |
| 2009-03-19 | ABBNY-DELISTED | Stock | 14.08 | 14.08 | 13.69 | 13.69 | 4088751.0 |
| 2009-03-19 | ABC-DELISTED | Stock | 15.535 | 15.77 | 15.0 | 15.26 | 4908252.0 |
| 2009-03-19 | ABCB | Stock | 7.1295 | 7.1295 | 6.1957 | 6.3416 | 16142.0 |
| 2009-03-19 | ABCO-DELISTED | Stock | 7.983 | 7.983 | 7.652 | 7.677 | 117405.0 |
| 2009-03-19 | ABCW-DELISTED | Stock | 1.03 | 1.2 | 0.77 | 0.82 | 309550.0 |
| 2009-03-19 | ABD-DELISTED | Stock | 1.4 | 1.4 | 1.2 | 1.24 | 150920.0 |
| 2009-03-19 | ABE-DELISTED | Stock | 12.25 | 12.8 | 11.95 | 12.0 | 26829.0 |
| 2009-03-19 | ABEO | Stock | 1875.0 | 1937.5 | 1687.5 | 1875.0 | 11.0 |
| 2009-03-19 | ABFS-DELISTED | Stock | 20.72 | 20.75 | 19.66 | 19.68 | 509560.0 |
| 2009-03-19 | ABG | Stock | 4.14 | 4.56 | 3.91 | 4.0 | 602000.0 |
| 2009-03-19 | ABII-DELISTED | Stock | 49.19 | 49.7 | 47.6 | 47.7 | 7961.0 |
| 2009-03-19 | ABK-DELISTED | Stock | 1.17 | 1.2 | 0.79 | 0.83 | 21889010.0 |
| 2009-03-19 | ABM | Stock | 16.3 | 16.56 | 16.16 | 16.34 | 441900.0 |
| 2009-03-19 | ABMD-DELISTED | Stock | 5.59 | 5.7 | 5.29 | 5.34 | 297708.0 |
| 2009-03-19 | ABR | Stock | 1.18 | 1.21 | 1.05 | 1.11 | 101000.0 |
| 2009-03-19 | ABT | Stock | 23.5006 | 23.5054 | 22.5554 | 22.8049 | 19328887.0 |
| 2009-03-19 | ABTL-DELISTED | Stock | 1.325 | 1.35 | 1.15 | 1.15 | 50792.0 |
| 2009-03-19 | ABV-DELISTED | Stock | 46.9 | 46.9 | 45.35 | 46.25 | 896358.0 |
| 2009-03-19 | ABVA-DELISTED | Stock | 1.63 | 1.65 | 1.63 | 1.65 | 1267.0 |
| 2009-03-19 | ABVT-DELISTED | Stock | 47.0 | 48.0 | 47.0 | 47.0 | 1400.0 |
| 2009-03-19 | ABX-DELISTED | Stock | 33.26 | 34.25 | 32.89 | 33.41 | 24469100.0 |
| 2009-03-19 | ACAD | Stock | 1.01 | 1.02 | 0.91 | 1.0 | 69600.0 |
| 2009-03-19 | ACAP-DELISTED | Stock | 44.25 | 44.25 | 42.57 | 42.91 | 68252.0 |
> showing 50 of 5,741 rows — these rows as CSV