PREVIEW / stock_daily / 2009-04-30
file: by_date/stock_daily/2009/2009-04-30.parquet size: 179 KB rows: 5,771 symbols: 3,443
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-04-30 | AAPL | Stock | 4.5079 | 4.5357 | 4.4614 | 4.4939 | 498489600.0 |
| 2009-04-30 | MSFT | Stock | 20.6 | 21.1 | 20.01 | 20.26 | 87439900.0 |
| 2009-04-30 | NVDA | Stock | 0.2772 | 0.295 | 0.275 | 0.287 | 1110276000.0 |
| 2009-04-30 | AMZN | Stock | 4.0465 | 4.1335 | 3.9945 | 4.026 | 170752000.0 |
| 2009-04-30 | TLT | Stock | 97.98 | 98.36 | 97.39 | 98.08 | 2778208.0 |
| 2009-04-30 | ES | Stock | 20.66 | 21.36 | 20.43 | 21.02 | 3437000.0 |
| 2009-04-30 | CL | Stock | 30.22 | 30.22 | 29.09 | 29.5 | 11936200.0 |
| 2009-04-30 | A | Stock | 12.9471 | 13.5479 | 12.9471 | 13.0615 | 4977998.0 |
| 2009-04-30 | AABA-DELISTED | Stock | 14.13 | 14.595 | 14.12 | 14.28 | 24522081.0 |
| 2009-04-30 | AACC-DELISTED | Stock | 7.02 | 8.5 | 6.91 | 8.26 | 103235.0 |
| 2009-04-30 | AACG | Stock | 4.26 | 5.0 | 4.25 | 4.9 | 105600.0 |
| 2009-04-30 | AAI-DELISTED | Stock | 7.16 | 7.27 | 6.945 | 6.95 | 4712818.0 |
| 2009-04-30 | AAIC-DELISTED | Stock | 6.4 | 6.4 | 5.0 | 5.4 | 609859.0 |
| 2009-04-30 | AAON | Stock | 3.8123 | 3.9269 | 3.7827 | 3.8479 | 673312.0 |
| 2009-04-30 | AAP | Stock | 43.97 | 44.89 | 43.3 | 43.75 | 2504700.0 |
| 2009-04-30 | AATI-DELISTED | Stock | 5.06 | 5.06 | 4.8 | 4.8 | 456057.0 |
| 2009-04-30 | AAU-DELISTED | Stock | 0.71 | 0.71 | 0.64 | 0.64 | 188277.0 |
| 2009-04-30 | AAUAF-DELISTED | Stock | 0.71 | 0.71 | 0.64 | 0.64 | 189277.0 |
| 2009-04-30 | AAV-DELISTED | Stock | 2.78 | 2.8309 | 2.62 | 2.67 | 790611.0 |
| 2009-04-30 | AAWW-DELISTED | Stock | 26.71 | 28.96 | 26.53 | 26.55 | 259176.0 |
| 2009-04-30 | AAXJ | Stock | 38.98 | 39.29 | 38.54 | 38.84 | 146684.0 |
| 2009-04-30 | AAXN-DELISTED | Stock | 5.02 | 5.12 | 4.8 | 4.8 | 573588.0 |
| 2009-04-30 | AB | Stock | 17.36 | 18.02 | 17.25 | 17.52 | 1468300.0 |
| 2009-04-30 | ABAX-DELISTED | Stock | 14.45 | 15.48 | 13.54 | 15.12 | 844848.0 |
| 2009-04-30 | ABB-DELISTED | Stock | 14.42 | 14.65 | 14.04 | 14.2 | 4689020.0 |
| 2009-04-30 | ABBC-DELISTED | Stock | 9.29 | 9.4 | 8.75 | 8.78 | 84340.0 |
| 2009-04-30 | ABBNY-DELISTED | Stock | 14.42 | 14.65 | 14.04 | 14.22 | 4807170.0 |
| 2009-04-30 | ABC-DELISTED | Stock | 17.42 | 17.49 | 16.75 | 16.86 | 6260130.0 |
| 2009-04-30 | ABCB | Stock | 6.7891 | 7.0128 | 6.1763 | 6.3709 | 46677.0 |
| 2009-04-30 | ABCO-DELISTED | Stock | 8.92 | 9.525 | 8.855 | 9.325 | 333737.0 |
| 2009-04-30 | ABCW-DELISTED | Stock | 1.65 | 1.67 | 1.6 | 1.63 | 108790.0 |
| 2009-04-30 | ABD-DELISTED | Stock | 1.9665 | 2.223 | 1.9665 | 2.09 | 429300.0 |
| 2009-04-30 | ABE-DELISTED | Stock | 13.68 | 14.0264 | 13.65 | 14.01 | 28440.0 |
| 2009-04-30 | ABEO | Stock | 1887.5 | 1887.5 | 1675.0 | 1875.0 | 2.0 |
| 2009-04-30 | ABFS-DELISTED | Stock | 22.71 | 23.99 | 22.36 | 23.08 | 698889.0 |
| 2009-04-30 | ABG | Stock | 9.5 | 10.33 | 9.37 | 9.67 | 859900.0 |
| 2009-04-30 | ABII-DELISTED | Stock | 48.95 | 49.48 | 47.2603 | 47.7 | 9189.0 |
| 2009-04-30 | ABK-DELISTED | Stock | 0.98 | 0.99 | 0.9 | 0.91 | 4821021.0 |
| 2009-04-30 | ABM | Stock | 17.87 | 18.1 | 17.51 | 17.52 | 329600.0 |
| 2009-04-30 | ABMD-DELISTED | Stock | 6.6 | 6.86 | 6.55 | 6.67 | 449439.0 |
| 2009-04-30 | ABR | Stock | 2.69 | 3.05 | 2.62 | 2.81 | 602900.0 |
| 2009-04-30 | ABT | Stock | 20.6314 | 20.665 | 19.8493 | 20.0796 | 35132555.0 |
| 2009-04-30 | ABTL-DELISTED | Stock | 2.7005 | 2.808 | 2.7 | 2.7 | 25806.0 |
| 2009-04-30 | ABV-DELISTED | Stock | 56.25 | 58.31 | 55.85 | 56.52 | 842948.0 |
| 2009-04-30 | ABVA-DELISTED | Stock | 2.1 | 2.11 | 2.1 | 2.1 | 17628.0 |
| 2009-04-30 | ABVT-DELISTED | Stock | 49.0 | 49.0 | 48.5 | 48.5 | 4398.0 |
| 2009-04-30 | ABX-DELISTED | Stock | 29.34 | 29.88 | 29.09 | 29.12 | 8785973.0 |
| 2009-04-30 | ACAD | Stock | 1.03 | 1.04 | 0.97 | 0.99 | 120300.0 |
| 2009-04-30 | ACAP-DELISTED | Stock | 42.85 | 42.85 | 41.47 | 41.66 | 67018.0 |
| 2009-04-30 | ACAS-DELISTED | Stock | 3.0 | 3.2318 | 2.95 | 3.09 | 6600163.0 |
> showing 50 of 5,771 rows — these rows as CSV