PREVIEW / stock_daily / 2009-04-13
file: by_date/stock_daily/2009/2009-04-13.parquet size: 177 KB rows: 5,770 symbols: 3,441
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-13 | AAPL | Stock | 4.2861 | 4.3207 | 4.25 | 4.2936 | 389236400.0 |
| 2009-04-13 | MSFT | Stock | 19.69 | 19.85 | 19.37 | 19.59 | 44444700.0 |
| 2009-04-13 | NVDA | Stock | 0.2972 | 0.2975 | 0.2848 | 0.2912 | 767628000.0 |
| 2009-04-13 | AMZN | Stock | 3.992 | 3.9985 | 3.8925 | 3.947 | 124244000.0 |
| 2009-04-13 | TLT | Stock | 102.96 | 103.51 | 102.93 | 103.29 | 946563.0 |
| 2009-04-13 | ES | Stock | 21.44 | 21.44 | 21.01 | 21.19 | 1035800.0 |
| 2009-04-13 | CL | Stock | 29.895 | 29.895 | 29.125 | 29.245 | 7106400.0 |
| 2009-04-13 | A | Stock | 12.0243 | 12.1388 | 11.8813 | 11.9313 | 4369449.0 |
| 2009-04-13 | AABA-DELISTED | Stock | 14.06 | 14.54 | 13.86 | 14.4 | 34798048.0 |
| 2009-04-13 | AACC-DELISTED | Stock | 7.15 | 7.4 | 6.68 | 6.8 | 46972.0 |
| 2009-04-13 | AACG | Stock | 4.19 | 4.73 | 4.19 | 4.5 | 83100.0 |
| 2009-04-13 | AAI-DELISTED | Stock | 5.37 | 5.65 | 5.28 | 5.61 | 2266747.0 |
| 2009-04-13 | AAIC-DELISTED | Stock | 7.2 | 7.202 | 6.0 | 6.8 | 587278.0 |
| 2009-04-13 | AAME | Stock | 0.6 | 0.67 | 0.6 | 0.6 | 2100.0 |
| 2009-04-13 | AAON | Stock | 3.4509 | 3.4509 | 3.3383 | 3.3521 | 238444.0 |
| 2009-04-13 | AAP | Stock | 42.05 | 42.15 | 40.56 | 41.22 | 1845400.0 |
| 2009-04-13 | AATI-DELISTED | Stock | 4.12 | 4.33 | 4.02 | 4.28 | 201073.0 |
| 2009-04-13 | AAU-DELISTED | Stock | 0.65 | 0.69 | 0.614 | 0.64 | 228180.0 |
| 2009-04-13 | AAUAF-DELISTED | Stock | 0.65 | 0.69 | 0.614 | 0.64 | 238180.0 |
| 2009-04-13 | AAV-DELISTED | Stock | 2.79 | 2.79 | 2.65 | 2.74 | 587754.0 |
| 2009-04-13 | AAWW-DELISTED | Stock | 20.75 | 22.48 | 20.3 | 22.35 | 249195.0 |
| 2009-04-13 | AAXJ | Stock | 36.59 | 37.4899 | 36.59 | 37.08 | 86187.0 |
| 2009-04-13 | AAXN-DELISTED | Stock | 5.07 | 5.43 | 5.04 | 5.4 | 492167.0 |
| 2009-04-13 | AB | Stock | 18.82 | 19.87 | 18.59 | 19.22 | 791300.0 |
| 2009-04-13 | ABAX-DELISTED | Stock | 15.93 | 16.05 | 15.7 | 15.86 | 177453.0 |
| 2009-04-13 | ABB-DELISTED | Stock | 14.64 | 15.34 | 14.55 | 15.21 | 2527449.0 |
| 2009-04-13 | ABBC-DELISTED | Stock | 8.75 | 9.0 | 8.6 | 8.97 | 37450.0 |
| 2009-04-13 | ABBNY-DELISTED | Stock | 14.64 | 15.34 | 14.55 | 15.24 | 2531549.0 |
| 2009-04-13 | ABC-DELISTED | Stock | 16.49 | 16.754 | 16.38 | 16.62 | 2158952.0 |
| 2009-04-13 | ABCB | Stock | 6.9057 | 7.7131 | 6.4875 | 7.5768 | 20769.0 |
| 2009-04-13 | ABCO-DELISTED | Stock | 9.078 | 9.233 | 8.767 | 9.078 | 151880.0 |
| 2009-04-13 | ABCW-DELISTED | Stock | 1.5 | 1.58 | 1.44 | 1.5 | 168200.0 |
| 2009-04-13 | ABD-DELISTED | Stock | 1.2697 | 1.3306 | 1.2494 | 1.29 | 179190.0 |
| 2009-04-13 | ABE-DELISTED | Stock | 12.9 | 13.19 | 12.85 | 13.19 | 15251.0 |
| 2009-04-13 | ABEO | Stock | 1887.5 | 2000.0 | 1887.5 | 2000.0 | 4.0 |
| 2009-04-13 | ABFS-DELISTED | Stock | 21.32 | 22.43 | 21.01 | 22.25 | 476736.0 |
| 2009-04-13 | ABG | Stock | 5.73 | 6.04 | 5.6 | 5.68 | 409000.0 |
| 2009-04-13 | ABII-DELISTED | Stock | 46.45 | 46.45 | 44.36 | 44.54 | 12144.0 |
| 2009-04-13 | ABK-DELISTED | Stock | 0.9606 | 1.15 | 0.94 | 1.12 | 16619782.0 |
| 2009-04-13 | ABM | Stock | 17.15 | 17.39 | 16.95 | 17.37 | 246700.0 |
| 2009-04-13 | ABMD-DELISTED | Stock | 5.74 | 5.7899 | 5.51 | 5.59 | 355195.0 |
| 2009-04-13 | ABR | Stock | 0.94 | 1.06 | 0.94 | 1.03 | 308900.0 |
| 2009-04-13 | ABT | Stock | 21.044 | 21.6054 | 21.0248 | 21.2935 | 20969362.0 |
| 2009-04-13 | ABTL-DELISTED | Stock | 1.35 | 1.35 | 1.2515 | 1.35 | 1030.0 |
| 2009-04-13 | ABV-DELISTED | Stock | 51.63 | 52.85 | 50.72 | 52.52 | 540830.0 |
| 2009-04-13 | ABVA-DELISTED | Stock | 1.95 | 1.95 | 1.91 | 1.95 | 3891.0 |
| 2009-04-13 | ABVT-DELISTED | Stock | 49.0 | 49.0 | 48.75 | 48.9 | 7000.0 |
| 2009-04-13 | ABX-DELISTED | Stock | 29.37 | 29.54 | 28.65 | 28.75 | 9323883.0 |
| 2009-04-13 | ACAD | Stock | 1.1 | 1.11 | 1.04 | 1.07 | 79400.0 |
| 2009-04-13 | ACAP-DELISTED | Stock | 41.54 | 42.46 | 41.54 | 42.04 | 33724.0 |
> showing 50 of 5,770 rows — these rows as CSV