PREVIEW / stock_daily / 2009-03-05
file: by_date/stock_daily/2009/2009-03-05.parquet size: 173 KB rows: 5,769 symbols: 3,449
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-05 | AAPL | Stock | 3.2307 | 3.2811 | 3.1589 | 3.1729 | 706899200.0 |
| 2009-03-05 | MSFT | Stock | 15.86 | 15.88 | 15.27 | 15.27 | 89708500.0 |
| 2009-03-05 | NVDA | Stock | 0.2085 | 0.217 | 0.2055 | 0.2065 | 955252000.0 |
| 2009-03-05 | AMZN | Stock | 3.206 | 3.29 | 3.18 | 3.2385 | 235406000.0 |
| 2009-03-05 | TLT | Stock | 104.02 | 105.44 | 103.44 | 104.96 | 4562360.0 |
| 2009-03-05 | ES | Stock | 20.11 | 20.19 | 19.19 | 19.68 | 2468800.0 |
| 2009-03-05 | CL | Stock | 28.77 | 29.0 | 27.78 | 28.015 | 7896400.0 |
| 2009-03-05 | A | Stock | 9.2847 | 9.4635 | 8.9485 | 8.97 | 9678214.0 |
| 2009-03-05 | AABA-DELISTED | Stock | 12.81 | 13.07 | 12.48 | 12.53 | 18107633.0 |
| 2009-03-05 | AACC-DELISTED | Stock | 3.25 | 3.33 | 3.25 | 3.3 | 70881.0 |
| 2009-03-05 | AACG | Stock | 4.92 | 5.11 | 4.92 | 5.08 | 19500.0 |
| 2009-03-05 | AAI-DELISTED | Stock | 2.71 | 2.71 | 2.5 | 2.57 | 2467755.0 |
| 2009-03-05 | AAIC-DELISTED | Stock | 2.6 | 2.8 | 2.4 | 2.4 | 351579.0 |
| 2009-03-05 | AAME | Stock | 0.66 | 0.66 | 0.6 | 0.6 | 5000.0 |
| 2009-03-05 | AAON | Stock | 3.0598 | 3.1941 | 2.9294 | 2.961 | 531056.0 |
| 2009-03-05 | AAP | Stock | 36.92 | 38.26 | 36.25 | 37.19 | 2040700.0 |
| 2009-03-05 | AATI-DELISTED | Stock | 3.2 | 3.22 | 3.06 | 3.12 | 233006.0 |
| 2009-03-05 | AAU-DELISTED | Stock | 0.73 | 0.74 | 0.69 | 0.7 | 86489.0 |
| 2009-03-05 | AAUAF-DELISTED | Stock | 0.73 | 0.74 | 0.69 | 0.7 | 86628.0 |
| 2009-03-05 | AAV-DELISTED | Stock | 2.01 | 2.12 | 1.91 | 1.93 | 680441.0 |
| 2009-03-05 | AAWW-DELISTED | Stock | 11.65 | 11.94 | 10.27 | 10.34 | 351760.0 |
| 2009-03-05 | AAXJ | Stock | 28.59 | 28.59 | 27.69 | 27.87 | 53219.0 |
| 2009-03-05 | AAXN-DELISTED | Stock | 3.39 | 3.6 | 3.15 | 3.27 | 676553.0 |
| 2009-03-05 | AB | Stock | 11.42 | 11.42 | 10.2 | 10.49 | 615300.0 |
| 2009-03-05 | ABAX-DELISTED | Stock | 16.13 | 16.91 | 15.94 | 16.59 | 377230.0 |
| 2009-03-05 | ABB-DELISTED | Stock | 11.8 | 11.955 | 11.36 | 11.47 | 4183076.0 |
| 2009-03-05 | ABBC-DELISTED | Stock | 6.81 | 6.9 | 6.34 | 6.34 | 122324.0 |
| 2009-03-05 | ABBNY-DELISTED | Stock | 11.8 | 11.955 | 11.36 | 11.47 | 4184476.0 |
| 2009-03-05 | ABC-DELISTED | Stock | 15.34 | 15.605 | 15.155 | 15.5 | 5473338.0 |
| 2009-03-05 | ABCB | Stock | 4.0656 | 4.0656 | 3.3654 | 3.5598 | 52023.0 |
| 2009-03-05 | ABCO-DELISTED | Stock | 7.005 | 7.17 | 6.98 | 7.02 | 448700.0 |
| 2009-03-05 | ABCW-DELISTED | Stock | 0.5 | 0.5 | 0.42 | 0.42 | 190840.0 |
| 2009-03-05 | ABD-DELISTED | Stock | 1.3189 | 1.3883 | 1.1702 | 1.19 | 169690.0 |
| 2009-03-05 | ABE-DELISTED | Stock | 10.83 | 10.854 | 10.68 | 10.74 | 76376.0 |
| 2009-03-05 | ABEO | Stock | 937.5 | 1675.0 | 937.5 | 1612.5 | 8.0 |
| 2009-03-05 | ABFS-DELISTED | Stock | 17.03 | 17.57 | 16.86 | 17.38 | 761097.0 |
| 2009-03-05 | ABG | Stock | 2.37 | 2.42 | 2.13 | 2.14 | 149500.0 |
| 2009-03-05 | ABII-DELISTED | Stock | 60.0 | 62.44 | 60.0 | 60.82 | 25335.0 |
| 2009-03-05 | ABK-DELISTED | Stock | 0.4014 | 0.44 | 0.37 | 0.375 | 6134332.0 |
| 2009-03-05 | ABM | Stock | 13.77 | 13.89 | 13.0 | 13.13 | 627500.0 |
| 2009-03-05 | ABMD-DELISTED | Stock | 5.79 | 6.01 | 5.2 | 5.23 | 564636.0 |
| 2009-03-05 | ABR | Stock | 0.8 | 0.8 | 0.61 | 0.67 | 131200.0 |
| 2009-03-05 | ABT | Stock | 22.2627 | 22.661 | 21.9029 | 22.09 | 20373281.0 |
| 2009-03-05 | ABTL-DELISTED | Stock | 1.5029 | 1.696 | 1.3472 | 1.3971 | 31440.0 |
| 2009-03-05 | ABV-DELISTED | Stock | 38.46 | 39.81 | 38.13 | 39.3 | 767824.0 |
| 2009-03-05 | ABVA-DELISTED | Stock | 2.19 | 2.2 | 1.68 | 1.734 | 3396.0 |
| 2009-03-05 | ABVT-DELISTED | Stock | 36.0 | 36.0 | 36.0 | 36.0 | 150.0 |
| 2009-03-05 | ABX-DELISTED | Stock | 27.76 | 28.91 | 27.76 | 28.79 | 16583902.0 |
| 2009-03-05 | ACAD | Stock | 0.83 | 0.91 | 0.79 | 0.79 | 149800.0 |
| 2009-03-05 | ACAP-DELISTED | Stock | 39.52 | 41.9999 | 38.13 | 38.35 | 43719.0 |
> showing 50 of 5,769 rows — these rows as CSV