PREVIEW / stock_daily / 2009-06-01
file: by_date/stock_daily/2009/2009-06-01.parquet size: 182 KB rows: 5,796 symbols: 3,451
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-06-01 | AAPL | Stock | 4.8739 | 4.9996 | 4.8571 | 4.9768 | 452499600.0 |
| 2009-06-01 | MSFT | Stock | 21.0 | 21.5 | 20.86 | 21.4 | 57317100.0 |
| 2009-06-01 | NVDA | Stock | 0.2638 | 0.275 | 0.2628 | 0.2735 | 1022764000.0 |
| 2009-06-01 | AMZN | Stock | 3.9105 | 4.24 | 3.8745 | 4.1525 | 215930000.0 |
| 2009-06-01 | TLT | Stock | 92.34 | 92.38 | 90.57 | 91.09 | 6986934.0 |
| 2009-06-01 | ES | Stock | 20.9 | 21.74 | 20.79 | 21.67 | 2601900.0 |
| 2009-06-01 | CL | Stock | 33.145 | 34.78 | 33.145 | 34.71 | 14844800.0 |
| 2009-06-01 | A | Stock | 13.1903 | 13.7411 | 13.1903 | 13.505 | 5764513.0 |
| 2009-06-01 | AABA-DELISTED | Stock | 16.17 | 16.65 | 16.13 | 16.59 | 27377149.0 |
| 2009-06-01 | AACC-DELISTED | Stock | 8.81 | 9.2 | 8.18 | 9.0 | 54096.0 |
| 2009-06-01 | AACG | Stock | 6.0 | 6.0 | 5.8 | 5.95 | 48400.0 |
| 2009-06-01 | AAI-DELISTED | Stock | 5.19 | 5.53 | 5.11 | 5.39 | 4115515.0 |
| 2009-06-01 | AAIC-DELISTED | Stock | 7.4 | 8.4 | 7.4 | 8.2 | 1885200.0 |
| 2009-06-01 | AAME | Stock | 0.7 | 0.7 | 0.7 | 0.7 | 2600.0 |
| 2009-06-01 | AAON | Stock | 4.1205 | 4.1857 | 4.0948 | 4.1699 | 637875.0 |
| 2009-06-01 | AAP | Stock | 43.19 | 44.11 | 42.63 | 43.85 | 2640900.0 |
| 2009-06-01 | AATI-DELISTED | Stock | 4.75 | 4.86 | 4.6775 | 4.84 | 451601.0 |
| 2009-06-01 | AAU-DELISTED | Stock | 0.89 | 0.94 | 0.85 | 0.8597 | 162491.0 |
| 2009-06-01 | AAUAF-DELISTED | Stock | 0.89 | 0.94 | 0.85 | 0.8597 | 163751.0 |
| 2009-06-01 | AAV-DELISTED | Stock | 4.41 | 4.56 | 4.341 | 4.52 | 1135386.0 |
| 2009-06-01 | AAWW-DELISTED | Stock | 26.32 | 26.95 | 25.52 | 26.18 | 304839.0 |
| 2009-06-01 | AAXJ | Stock | 45.77 | 46.97 | 45.77 | 46.86 | 310477.0 |
| 2009-06-01 | AAXN-DELISTED | Stock | 4.41 | 4.63 | 4.4 | 4.56 | 580679.0 |
| 2009-06-01 | AB | Stock | 19.36 | 20.73 | 19.36 | 20.57 | 839300.0 |
| 2009-06-01 | ABAX-DELISTED | Stock | 17.69 | 18.24 | 17.68 | 18.14 | 198474.0 |
| 2009-06-01 | ABB-DELISTED | Stock | 16.9 | 17.39 | 16.77 | 17.2 | 5468728.0 |
| 2009-06-01 | ABBC-DELISTED | Stock | 8.21 | 8.8 | 8.21 | 8.8 | 100727.0 |
| 2009-06-01 | ABBNY-DELISTED | Stock | 16.9 | 17.39 | 16.77 | 17.18 | 5544765.0 |
| 2009-06-01 | ABC-DELISTED | Stock | 18.7 | 18.87 | 18.52 | 18.82 | 3851964.0 |
| 2009-06-01 | ABCB | Stock | 6.2735 | 6.4681 | 6.0985 | 6.4097 | 31358.0 |
| 2009-06-01 | ABCO-DELISTED | Stock | 11.742 | 12.188 | 11.737 | 12.078 | 332239.0 |
| 2009-06-01 | ABCW-DELISTED | Stock | 1.5 | 1.59 | 1.4 | 1.48 | 213030.0 |
| 2009-06-01 | ABD-DELISTED | Stock | 3.0494 | 3.4607 | 3.0494 | 3.4206 | 357170.0 |
| 2009-06-01 | ABE-DELISTED | Stock | 15.87 | 15.87 | 15.0 | 15.55 | 20643.0 |
| 2009-06-01 | ABEO | Stock | 2312.5 | 3062.5 | 2262.5 | 2687.5 | 56.0 |
| 2009-06-01 | ABFS-DELISTED | Stock | 28.49 | 31.08 | 28.3801 | 30.37 | 983683.0 |
| 2009-06-01 | ABG | Stock | 9.71 | 10.21 | 9.52 | 10.21 | 494600.0 |
| 2009-06-01 | ABII-DELISTED | Stock | 48.76 | 49.4499 | 42.9 | 43.3 | 124977.0 |
| 2009-06-01 | ABK-DELISTED | Stock | 1.28 | 1.37 | 1.25 | 1.34 | 10103790.0 |
| 2009-06-01 | ABM | Stock | 16.41 | 17.08 | 16.41 | 16.85 | 282500.0 |
| 2009-06-01 | ABMD-DELISTED | Stock | 6.01 | 6.2 | 5.9499 | 6.19 | 211986.0 |
| 2009-06-01 | ABR | Stock | 1.6 | 1.74 | 1.6 | 1.71 | 251900.0 |
| 2009-06-01 | ABT | Stock | 21.7349 | 21.7925 | 21.4279 | 21.5814 | 14323677.0 |
| 2009-06-01 | ABTL-DELISTED | Stock | 2.2005 | 2.283 | 2.2005 | 2.2495 | 322720.0 |
| 2009-06-01 | ABV-DELISTED | Stock | 66.81 | 68.25 | 66.65 | 67.7 | 545457.0 |
| 2009-06-01 | ABVA-DELISTED | Stock | 3.015 | 3.015 | 3.015 | 3.015 | 200.0 |
| 2009-06-01 | ABVT-DELISTED | Stock | 72.5 | 73.0 | 71.2675 | 72.65 | 69245.0 |
| 2009-06-01 | ABX-DELISTED | Stock | 38.55 | 38.63 | 36.85 | 36.99 | 13396558.0 |
| 2009-06-01 | ACAD | Stock | 1.96 | 1.99 | 1.9 | 1.97 | 158400.0 |
| 2009-06-01 | ACAP-DELISTED | Stock | 40.09 | 40.41 | 38.92 | 40.2 | 56559.0 |
> showing 50 of 5,796 rows — these rows as CSV