PREVIEW / stock_daily / 2009-08-05
file: by_date/stock_daily/2009/2009-08-05.parquet size: 183 KB rows: 5,775 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-08-05 | AAPL | Stock | 5.9196 | 5.9782 | 5.8646 | 5.8968 | 423183600.0 |
| 2009-08-05 | MSFT | Stock | 23.84 | 24.25 | 23.79 | 23.81 | 53310300.0 |
| 2009-08-05 | NVDA | Stock | 0.3322 | 0.3375 | 0.3283 | 0.335 | 610768000.0 |
| 2009-08-05 | AMZN | Stock | 4.282 | 4.2875 | 4.151 | 4.2145 | 145588000.0 |
| 2009-08-05 | TLT | Stock | 91.31 | 92.75 | 90.87 | 90.94 | 4458231.0 |
| 2009-08-05 | ES | Stock | 22.76 | 23.73 | 22.76 | 23.14 | 2298300.0 |
| 2009-08-05 | CL | Stock | 36.14 | 36.14 | 35.595 | 35.8 | 5519800.0 |
| 2009-08-05 | A | Stock | 17.3319 | 17.4535 | 16.7668 | 16.8312 | 3551339.0 |
| 2009-08-05 | AABA-DELISTED | Stock | 14.76 | 14.91 | 14.61 | 14.65 | 47846564.0 |
| 2009-08-05 | AACC-DELISTED | Stock | 7.42 | 7.45 | 7.05 | 7.28 | 40619.0 |
| 2009-08-05 | AACG | Stock | 8.29 | 8.29 | 7.9 | 8.0 | 78800.0 |
| 2009-08-05 | AAI-DELISTED | Stock | 7.17 | 7.24 | 6.91 | 7.13 | 2094973.0 |
| 2009-08-05 | AAIC-DELISTED | Stock | 8.8 | 8.8 | 8.436 | 8.698 | 509573.0 |
| 2009-08-05 | AAME | Stock | 0.7 | 0.7 | 0.7 | 0.7 | 2800.0 |
| 2009-08-05 | AAON | Stock | 4.1481 | 4.1659 | 4.0672 | 4.0988 | 620156.0 |
| 2009-08-05 | AAP | Stock | 45.5 | 45.66 | 44.22 | 45.13 | 2025600.0 |
| 2009-08-05 | AATI-DELISTED | Stock | 4.89 | 4.9 | 4.76 | 4.88 | 582859.0 |
| 2009-08-05 | AAU-DELISTED | Stock | 0.67 | 0.69 | 0.65 | 0.65 | 62208.0 |
| 2009-08-05 | AAUAF-DELISTED | Stock | 0.67 | 0.69 | 0.65 | 0.65 | 72208.0 |
| 2009-08-05 | AAV-DELISTED | Stock | 5.21 | 5.23 | 5.11 | 5.21 | 550129.0 |
| 2009-08-05 | AAWW-DELISTED | Stock | 27.76 | 29.61 | 25.72 | 28.44 | 1093418.0 |
| 2009-08-05 | AAXJ | Stock | 50.5 | 50.5 | 49.68 | 50.18 | 179710.0 |
| 2009-08-05 | AAXN-DELISTED | Stock | 5.23 | 5.29 | 5.1 | 5.12 | 290491.0 |
| 2009-08-05 | AB | Stock | 20.55 | 21.49 | 20.42 | 21.3 | 736400.0 |
| 2009-08-05 | ABAX-DELISTED | Stock | 26.94 | 27.44 | 26.55 | 27.34 | 490913.0 |
| 2009-08-05 | ABB-DELISTED | Stock | 18.53 | 18.65 | 18.17 | 18.52 | 3030937.0 |
| 2009-08-05 | ABBC-DELISTED | Stock | 8.35 | 8.35 | 8.0 | 8.23 | 73074.0 |
| 2009-08-05 | ABBNY-DELISTED | Stock | 18.53 | 18.65 | 18.17 | 18.5 | 3062237.0 |
| 2009-08-05 | ABC-DELISTED | Stock | 20.41 | 20.52 | 20.05 | 20.44 | 3908181.0 |
| 2009-08-05 | ABCB | Stock | 6.575 | 6.575 | 6.3124 | 6.3124 | 15730.0 |
| 2009-08-05 | ABCO-DELISTED | Stock | 13.203 | 13.473 | 12.687 | 12.917 | 239538.0 |
| 2009-08-05 | ABCW-DELISTED | Stock | 1.41 | 1.53 | 1.41 | 1.53 | 132000.0 |
| 2009-08-05 | ABD-DELISTED | Stock | 4.34 | 4.5471 | 4.18 | 4.42 | 514070.0 |
| 2009-08-05 | ABE-DELISTED | Stock | 17.31 | 17.31 | 16.82 | 16.89 | 7770.0 |
| 2009-08-05 | ABEO | Stock | 5625.0 | 5812.5 | 5437.5 | 5800.0 | 19.0 |
| 2009-08-05 | ABFS-DELISTED | Stock | 27.62 | 28.08 | 27.03 | 27.18 | 382446.0 |
| 2009-08-05 | ABG | Stock | 13.91 | 14.26 | 13.58 | 13.81 | 388600.0 |
| 2009-08-05 | ABII-DELISTED | Stock | 30.68 | 32.0 | 30.353 | 32.0 | 19602.0 |
| 2009-08-05 | ABK-DELISTED | Stock | 1.03 | 1.21 | 1.0 | 1.19 | 39474454.0 |
| 2009-08-05 | ABM | Stock | 21.53 | 21.91 | 21.05 | 21.34 | 151700.0 |
| 2009-08-05 | ABMD-DELISTED | Stock | 7.75 | 7.75 | 7.26 | 7.49 | 195964.0 |
| 2009-08-05 | ABR | Stock | 1.93 | 2.18 | 1.9 | 2.12 | 935500.0 |
| 2009-08-05 | ABT | Stock | 21.2791 | 21.2791 | 21.0968 | 21.1112 | 16416424.0 |
| 2009-08-05 | ABTL-DELISTED | Stock | 2.45 | 2.5 | 2.425 | 2.5 | 9050.0 |
| 2009-08-05 | ABV-DELISTED | Stock | 74.6 | 74.94 | 73.56 | 74.85 | 545591.0 |
| 2009-08-05 | ABVT-DELISTED | Stock | 84.28 | 86.88 | 84.28 | 85.9 | 75148.0 |
| 2009-08-05 | ABX-DELISTED | Stock | 36.32 | 36.55 | 35.34 | 35.98 | 7062760.0 |
| 2009-08-05 | ACAD | Stock | 4.93 | 4.94 | 4.4 | 4.74 | 1581900.0 |
| 2009-08-05 | ACAP-DELISTED | Stock | 34.0 | 34.0 | 32.06 | 32.58 | 81480.0 |
| 2009-08-05 | ACAS-DELISTED | Stock | 2.84 | 3.13 | 2.81 | 3.02 | 14015851.0 |
> showing 50 of 5,775 rows — these rows as CSV