PREVIEW / stock_daily / 2009-04-29
file: by_date/stock_daily/2009/2009-04-29.parquet size: 178 KB rows: 5,733 symbols: 3,428
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-29 | AAPL | Stock | 4.4589 | 4.5304 | 4.4225 | 4.4693 | 458110800.0 |
| 2009-04-29 | MSFT | Stock | 20.11 | 20.89 | 20.06 | 20.25 | 79301600.0 |
| 2009-04-29 | NVDA | Stock | 0.2775 | 0.2788 | 0.2688 | 0.272 | 859668000.0 |
| 2009-04-29 | AMZN | Stock | 4.1495 | 4.1495 | 3.963 | 3.9895 | 194702000.0 |
| 2009-04-29 | TLT | Stock | 99.67 | 100.08 | 98.15 | 98.47 | 3752505.0 |
| 2009-04-29 | ES | Stock | 20.7 | 20.82 | 20.42 | 20.5 | 2014400.0 |
| 2009-04-29 | CL | Stock | 29.655 | 30.03 | 29.465 | 29.855 | 7450200.0 |
| 2009-04-29 | A | Stock | 12.3104 | 13.0114 | 12.2389 | 12.897 | 5516508.0 |
| 2009-04-29 | AABA-DELISTED | Stock | 13.74 | 14.35 | 13.7 | 14.02 | 16138874.0 |
| 2009-04-29 | AACC-DELISTED | Stock | 6.41 | 6.97 | 6.1 | 6.97 | 38554.0 |
| 2009-04-29 | AACG | Stock | 4.41 | 4.5 | 4.17 | 4.49 | 28100.0 |
| 2009-04-29 | AAI-DELISTED | Stock | 6.51 | 7.15 | 6.5 | 7.06 | 4495642.0 |
| 2009-04-29 | AAIC-DELISTED | Stock | 5.6 | 6.2 | 5.4 | 6.0 | 664032.0 |
| 2009-04-29 | AAME | Stock | 0.74 | 0.74 | 0.61 | 0.61 | 4100.0 |
| 2009-04-29 | AAON | Stock | 3.7393 | 3.8815 | 3.6741 | 3.84 | 319444.0 |
| 2009-04-29 | AAP | Stock | 43.86 | 44.38 | 42.32 | 42.6 | 1593800.0 |
| 2009-04-29 | AATI-DELISTED | Stock | 4.71 | 5.01 | 4.69 | 5.0 | 503906.0 |
| 2009-04-29 | AAU-DELISTED | Stock | 0.69 | 0.7 | 0.6797 | 0.69 | 46288.0 |
| 2009-04-29 | AAUAF-DELISTED | Stock | 0.69 | 0.7 | 0.6797 | 0.69 | 46838.0 |
| 2009-04-29 | AAV-DELISTED | Stock | 2.68 | 2.82 | 2.68 | 2.77 | 576146.0 |
| 2009-04-29 | AAWW-DELISTED | Stock | 25.1 | 26.84 | 24.33 | 26.22 | 390872.0 |
| 2009-04-29 | AAXJ | Stock | 37.08 | 38.38 | 36.84 | 38.11 | 139295.0 |
| 2009-04-29 | AAXN-DELISTED | Stock | 4.71 | 5.0 | 4.71 | 4.98 | 418045.0 |
| 2009-04-29 | AB | Stock | 15.54 | 17.22 | 15.07 | 16.99 | 1681700.0 |
| 2009-04-29 | ABAX-DELISTED | Stock | 14.94 | 15.49 | 14.82 | 15.21 | 372637.0 |
| 2009-04-29 | ABB-DELISTED | Stock | 14.02 | 14.45 | 13.98 | 14.25 | 4747732.0 |
| 2009-04-29 | ABBC-DELISTED | Stock | 8.96 | 9.3 | 8.85 | 9.25 | 60089.0 |
| 2009-04-29 | ABBNY-DELISTED | Stock | 14.02 | 14.45 | 13.98 | 14.24 | 4974832.0 |
| 2009-04-29 | ABC-DELISTED | Stock | 17.64 | 17.64 | 17.26 | 17.36 | 4873772.0 |
| 2009-04-29 | ABCB | Stock | 6.1763 | 6.8085 | 6.1763 | 6.7113 | 28582.0 |
| 2009-04-29 | ABCO-DELISTED | Stock | 8.225 | 8.945 | 8.155 | 8.89 | 258346.0 |
| 2009-04-29 | ABCW-DELISTED | Stock | 1.555 | 1.6955 | 1.535 | 1.545 | 62920.0 |
| 2009-04-29 | ABD-DELISTED | Stock | 2.06 | 2.1004 | 1.8681 | 2.06 | 309800.0 |
| 2009-04-29 | ABE-DELISTED | Stock | 13.44 | 13.66 | 12.9 | 13.65 | 31650.0 |
| 2009-04-29 | ABEO | Stock | 1687.5 | 1887.5 | 1675.0 | 1887.5 | 5.0 |
| 2009-04-29 | ABFS-DELISTED | Stock | 21.47 | 22.88 | 21.06 | 22.54 | 486095.0 |
| 2009-04-29 | ABG | Stock | 8.6 | 9.51 | 8.4 | 9.09 | 1170000.0 |
| 2009-04-29 | ABII-DELISTED | Stock | 46.36 | 48.76 | 46.09 | 47.7 | 6964.0 |
| 2009-04-29 | ABK-DELISTED | Stock | 0.94 | 0.97 | 0.92 | 0.95 | 3083592.0 |
| 2009-04-29 | ABM | Stock | 17.11 | 17.89 | 17.1 | 17.75 | 183200.0 |
| 2009-04-29 | ABMD-DELISTED | Stock | 6.09 | 6.54 | 5.92 | 6.52 | 385541.0 |
| 2009-04-29 | ABR | Stock | 1.95 | 2.68 | 1.95 | 2.54 | 624000.0 |
| 2009-04-29 | ABT | Stock | 20.6938 | 20.7178 | 20.3387 | 20.4491 | 16898291.0 |
| 2009-04-29 | ABTL-DELISTED | Stock | 2.55 | 2.6 | 2.45 | 2.5 | 14114.0 |
| 2009-04-29 | ABV-DELISTED | Stock | 55.06 | 56.39 | 55.01 | 56.11 | 763558.0 |
| 2009-04-29 | ABVA-DELISTED | Stock | 2.15 | 2.15 | 2.05 | 2.05 | 3500.0 |
| 2009-04-29 | ABVT-DELISTED | Stock | 49.0 | 49.0 | 49.0 | 49.0 | 7820.0 |
| 2009-04-29 | ABX-DELISTED | Stock | 29.74 | 29.99 | 29.25 | 29.62 | 7870539.0 |
| 2009-04-29 | ACAD | Stock | 0.96 | 1.03 | 0.94 | 1.01 | 120900.0 |
| 2009-04-29 | ACAP-DELISTED | Stock | 40.53 | 42.94 | 40.53 | 42.46 | 39840.0 |
> showing 50 of 5,733 rows — these rows as CSV