PREVIEW / stock_daily / 2009-07-29
file: by_date/stock_daily/2009/2009-07-29.parquet size: 181 KB rows: 5,755 symbols: 3,433
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-07-29 | AAPL | Stock | 5.675 | 5.7304 | 5.6518 | 5.7154 | 382158000.0 |
| 2009-07-29 | MSFT | Stock | 23.73 | 23.91 | 23.34 | 23.8 | 73626900.0 |
| 2009-07-29 | NVDA | Stock | 0.3223 | 0.3243 | 0.3163 | 0.3195 | 373972000.0 |
| 2009-07-29 | AMZN | Stock | 4.2235 | 4.275 | 4.176 | 4.217 | 130058000.0 |
| 2009-07-29 | TLT | Stock | 92.17 | 92.29 | 90.94 | 91.7 | 2911690.0 |
| 2009-07-29 | ES | Stock | 22.71 | 22.92 | 22.35 | 22.66 | 989200.0 |
| 2009-07-29 | CL | Stock | 37.45 | 38.0 | 37.35 | 37.925 | 4886600.0 |
| 2009-07-29 | A | Stock | 16.6237 | 16.7239 | 16.0587 | 16.1874 | 6997130.0 |
| 2009-07-29 | AABA-DELISTED | Stock | 16.0 | 16.2 | 15.05 | 15.14 | 125704860.0 |
| 2009-07-29 | AACC-DELISTED | Stock | 8.5 | 8.55 | 8.38 | 8.43 | 56579.0 |
| 2009-07-29 | AACG | Stock | 8.25 | 8.5 | 8.21 | 8.21 | 8200.0 |
| 2009-07-29 | AAI-DELISTED | Stock | 7.22 | 7.38 | 7.14 | 7.31 | 2325619.0 |
| 2009-07-29 | AAIC-DELISTED | Stock | 8.0 | 8.2 | 7.8 | 8.0 | 340212.0 |
| 2009-07-29 | AAME | Stock | 0.68 | 0.68 | 0.68 | 0.68 | 400.0 |
| 2009-07-29 | AAON | Stock | 3.8736 | 3.919 | 3.8519 | 3.8775 | 286537.0 |
| 2009-07-29 | AAP | Stock | 45.7 | 46.25 | 44.91 | 45.35 | 1145300.0 |
| 2009-07-29 | AATI-DELISTED | Stock | 4.75 | 4.8 | 4.61 | 4.62 | 236077.0 |
| 2009-07-29 | AAU-DELISTED | Stock | 0.675 | 0.675 | 0.65 | 0.65 | 25500.0 |
| 2009-07-29 | AAUAF-DELISTED | Stock | 0.675 | 0.675 | 0.65 | 0.65 | 26100.0 |
| 2009-07-29 | AAV-DELISTED | Stock | 5.06 | 5.08 | 4.84 | 4.96 | 865964.0 |
| 2009-07-29 | AAWW-DELISTED | Stock | 24.4 | 25.01 | 24.26 | 24.97 | 153686.0 |
| 2009-07-29 | AAXJ | Stock | 49.0 | 49.0 | 48.33 | 48.68 | 121896.0 |
| 2009-07-29 | AAXN-DELISTED | Stock | 5.47 | 5.48 | 5.22 | 5.24 | 595599.0 |
| 2009-07-29 | AB | Stock | 22.6 | 22.9 | 21.76 | 21.85 | 756300.0 |
| 2009-07-29 | ABAX-DELISTED | Stock | 20.56 | 20.76 | 20.39 | 20.59 | 190374.0 |
| 2009-07-29 | ABB-DELISTED | Stock | 17.61 | 17.62 | 17.29 | 17.45 | 3847439.0 |
| 2009-07-29 | ABBC-DELISTED | Stock | 8.23 | 8.25 | 8.0 | 8.23 | 28517.0 |
| 2009-07-29 | ABBNY-DELISTED | Stock | 17.6 | 17.62 | 17.29 | 17.46 | 3869639.0 |
| 2009-07-29 | ABC-DELISTED | Stock | 20.11 | 20.54 | 19.76 | 20.31 | 6474563.0 |
| 2009-07-29 | ABCB | Stock | 6.4486 | 6.8085 | 6.1277 | 6.5459 | 42564.0 |
| 2009-07-29 | ABCO-DELISTED | Stock | 11.882 | 12.147 | 11.813 | 11.838 | 105651.0 |
| 2009-07-29 | ABCW-DELISTED | Stock | 1.1719 | 1.25 | 1.123 | 1.25 | 86920.0 |
| 2009-07-29 | ABD-DELISTED | Stock | 4.555 | 4.7352 | 4.525 | 4.545 | 469220.0 |
| 2009-07-29 | ABE-DELISTED | Stock | 16.16 | 16.29 | 15.53 | 15.925 | 19575.0 |
| 2009-07-29 | ABEO | Stock | 5375.0 | 5725.0 | 5000.0 | 5725.0 | 106.0 |
| 2009-07-29 | ABFS-DELISTED | Stock | 26.73 | 26.74 | 25.9608 | 26.25 | 452146.0 |
| 2009-07-29 | ABG | Stock | 11.99 | 12.46 | 11.28 | 11.95 | 519600.0 |
| 2009-07-29 | ABII-DELISTED | Stock | 31.27 | 31.2769 | 30.41 | 30.72 | 25174.0 |
| 2009-07-29 | ABK-DELISTED | Stock | 0.772 | 0.79 | 0.74 | 0.77 | 9559323.0 |
| 2009-07-29 | ABM | Stock | 20.41 | 20.62 | 20.29 | 20.39 | 117800.0 |
| 2009-07-29 | ABMD-DELISTED | Stock | 7.52 | 7.7 | 7.5002 | 7.63 | 303618.0 |
| 2009-07-29 | ABR | Stock | 1.91 | 1.98 | 1.75 | 1.79 | 269200.0 |
| 2009-07-29 | ABT | Stock | 21.7733 | 22.0084 | 21.6486 | 21.9221 | 13059608.0 |
| 2009-07-29 | ABTL-DELISTED | Stock | 2.5 | 2.5 | 2.35 | 2.5 | 28231.0 |
| 2009-07-29 | ABV-DELISTED | Stock | 69.71 | 69.85 | 69.19 | 69.69 | 687050.0 |
| 2009-07-29 | ABVT-DELISTED | Stock | 82.25 | 82.51 | 81.85 | 81.88 | 11151.0 |
| 2009-07-29 | ABX-DELISTED | Stock | 33.24 | 33.36 | 32.55 | 32.85 | 6724398.0 |
| 2009-07-29 | ACAD | Stock | 4.24 | 4.84 | 4.2 | 4.39 | 2744200.0 |
| 2009-07-29 | ACAP-DELISTED | Stock | 41.42 | 41.9025 | 41.23 | 41.48 | 17148.0 |
| 2009-07-29 | ACAS-DELISTED | Stock | 3.35 | 3.35 | 3.16 | 3.18 | 1650031.0 |
> showing 50 of 5,755 rows — these rows as CSV