PREVIEW / stock_daily / 2009-03-25
file: by_date/stock_daily/2009/2009-03-25.parquet size: 175 KB rows: 5,732 symbols: 3,432
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-25 | AAPL | Stock | 3.8421 | 3.87 | 3.7093 | 3.8032 | 646618000.0 |
| 2009-03-25 | MSFT | Stock | 17.98 | 18.31 | 17.52 | 17.88 | 73927100.0 |
| 2009-03-25 | NVDA | Stock | 0.252 | 0.26 | 0.239 | 0.2485 | 1243852000.0 |
| 2009-03-25 | AMZN | Stock | 3.6545 | 3.6975 | 3.492 | 3.62 | 157912000.0 |
| 2009-03-25 | TLT | Stock | 103.29 | 103.72 | 102.31 | 102.6 | 2549522.0 |
| 2009-03-25 | ES | Stock | 21.91 | 22.06 | 21.48 | 21.65 | 2315300.0 |
| 2009-03-25 | CL | Stock | 29.505 | 29.87 | 29.25 | 29.615 | 6344000.0 |
| 2009-03-25 | A | Stock | 11.4449 | 11.7525 | 11.1159 | 11.4163 | 4095301.0 |
| 2009-03-25 | AABA-DELISTED | Stock | 13.67 | 13.88 | 13.3475 | 13.57 | 16557182.0 |
| 2009-03-25 | AACC-DELISTED | Stock | 5.76 | 6.41 | 5.76 | 6.285 | 45642.0 |
| 2009-03-25 | AACG | Stock | 4.52 | 4.52 | 4.0 | 4.13 | 25300.0 |
| 2009-03-25 | AAI-DELISTED | Stock | 4.04 | 4.37 | 4.04 | 4.36 | 5570695.0 |
| 2009-03-25 | AAIC-DELISTED | Stock | 4.6 | 4.6 | 3.6 | 4.4 | 939063.0 |
| 2009-03-25 | AAME | Stock | 0.65 | 0.68 | 0.65 | 0.68 | 1000.0 |
| 2009-03-25 | AAON | Stock | 3.5911 | 3.7195 | 3.4035 | 3.6543 | 384750.0 |
| 2009-03-25 | AAP | Stock | 39.4 | 40.0 | 38.45 | 40.0 | 2606700.0 |
| 2009-03-25 | AATI-DELISTED | Stock | 3.63 | 3.71 | 3.43 | 3.57 | 716064.0 |
| 2009-03-25 | AAU-DELISTED | Stock | 0.7604 | 0.8 | 0.75 | 0.77 | 47450.0 |
| 2009-03-25 | AAUAF-DELISTED | Stock | 0.7604 | 0.8 | 0.75 | 0.77 | 47550.0 |
| 2009-03-25 | AAV-DELISTED | Stock | 2.25 | 2.38 | 2.15 | 2.28 | 1837983.0 |
| 2009-03-25 | AAWW-DELISTED | Stock | 18.65 | 19.55 | 16.93 | 18.44 | 306723.0 |
| 2009-03-25 | AAXJ | Stock | 33.79 | 34.35 | 33.3 | 33.6726 | 41849.0 |
| 2009-03-25 | AAXN-DELISTED | Stock | 4.78 | 4.9884 | 4.37 | 4.69 | 500893.0 |
| 2009-03-25 | AB | Stock | 15.28 | 17.12 | 14.89 | 15.4 | 1437900.0 |
| 2009-03-25 | ABAX-DELISTED | Stock | 18.16 | 19.02 | 17.58 | 18.22 | 207175.0 |
| 2009-03-25 | ABB-DELISTED | Stock | 13.89 | 14.32 | 13.85 | 14.22 | 7219204.0 |
| 2009-03-25 | ABBC-DELISTED | Stock | 8.7 | 8.96 | 8.46 | 8.85 | 88068.0 |
| 2009-03-25 | ABBNY-DELISTED | Stock | 13.89 | 14.32 | 13.85 | 14.26 | 7415255.0 |
| 2009-03-25 | ABC-DELISTED | Stock | 16.03 | 16.37 | 15.98 | 16.18 | 2931814.0 |
| 2009-03-25 | ABCB | Stock | 5.9428 | 6.2638 | 5.7678 | 6.2638 | 55313.0 |
| 2009-03-25 | ABCO-DELISTED | Stock | 7.99 | 8.52 | 7.855 | 8.3 | 119274.0 |
| 2009-03-25 | ABCW-DELISTED | Stock | 1.1 | 1.4 | 1.03 | 1.16 | 286250.0 |
| 2009-03-25 | ABD-DELISTED | Stock | 1.17 | 1.23 | 1.13 | 1.2 | 252420.0 |
| 2009-03-25 | ABE-DELISTED | Stock | 12.31 | 12.48 | 12.17 | 12.3 | 7666.0 |
| 2009-03-25 | ABEO | Stock | 1887.5 | 2125.0 | 1887.5 | 2125.0 | 3.0 |
| 2009-03-25 | ABFS-DELISTED | Stock | 20.72 | 21.34 | 19.9 | 20.41 | 1297068.0 |
| 2009-03-25 | ABG | Stock | 4.24 | 4.45 | 3.94 | 4.2 | 517600.0 |
| 2009-03-25 | ABII-DELISTED | Stock | 44.06 | 45.77 | 43.4 | 44.4 | 26422.0 |
| 2009-03-25 | ABK-DELISTED | Stock | 0.935 | 0.95 | 0.7916 | 0.898 | 8464638.0 |
| 2009-03-25 | ABM | Stock | 16.56 | 17.09 | 16.13 | 16.8 | 289300.0 |
| 2009-03-25 | ABMD-DELISTED | Stock | 5.94 | 6.08 | 5.35 | 5.45 | 637038.0 |
| 2009-03-25 | ABR | Stock | 1.15 | 1.2 | 1.03 | 1.1 | 148900.0 |
| 2009-03-25 | ABT | Stock | 22.493 | 22.5506 | 21.6102 | 22.0852 | 41004168.0 |
| 2009-03-25 | ABTL-DELISTED | Stock | 1.5 | 1.5 | 1.25 | 1.25 | 30382.0 |
| 2009-03-25 | ABV-DELISTED | Stock | 48.84 | 49.94 | 48.28 | 49.09 | 855988.0 |
| 2009-03-25 | ABVA-DELISTED | Stock | 2.2 | 2.21 | 1.85 | 1.85 | 3083.0 |
| 2009-03-25 | ABVT-DELISTED | Stock | 45.0 | 45.0 | 45.0 | 45.0 | 100.0 |
| 2009-03-25 | ABX-DELISTED | Stock | 32.24 | 33.75 | 31.8 | 32.91 | 15695691.0 |
| 2009-03-25 | ACAD | Stock | 1.0 | 1.05 | 0.95 | 1.04 | 134300.0 |
| 2009-03-25 | ACAP-DELISTED | Stock | 42.74 | 43.59 | 40.0 | 41.88 | 60442.0 |
> showing 50 of 5,732 rows — these rows as CSV