PREVIEW / stock_daily / 2009-04-15
file: by_date/stock_daily/2009/2009-04-15.parquet size: 175 KB rows: 5,710 symbols: 3,412
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-15 | AAPL | Stock | 4.1857 | 4.2232 | 4.1343 | 4.2014 | 412882400.0 |
| 2009-04-15 | MSFT | Stock | 19.21 | 19.25 | 18.51 | 18.83 | 72725500.0 |
| 2009-04-15 | NVDA | Stock | 0.2828 | 0.286 | 0.2728 | 0.2848 | 1045368000.0 |
| 2009-04-15 | AMZN | Stock | 3.775 | 3.7905 | 3.6755 | 3.7355 | 188256000.0 |
| 2009-04-15 | TLT | Stock | 104.13 | 104.3 | 102.88 | 103.65 | 1152418.0 |
| 2009-04-15 | ES | Stock | 20.75 | 21.09 | 20.7 | 21.09 | 1238300.0 |
| 2009-04-15 | CL | Stock | 28.575 | 29.025 | 28.575 | 29.015 | 7496000.0 |
| 2009-04-15 | A | Stock | 11.7454 | 11.9099 | 11.5236 | 11.7024 | 3482138.0 |
| 2009-04-15 | AABA-DELISTED | Stock | 13.94 | 14.09 | 13.77 | 14.0 | 12301032.0 |
| 2009-04-15 | AACC-DELISTED | Stock | 6.36 | 6.58 | 6.35 | 6.5 | 13804.0 |
| 2009-04-15 | AACG | Stock | 4.02 | 4.08 | 3.94 | 4.0 | 41800.0 |
| 2009-04-15 | AAI-DELISTED | Stock | 5.25 | 5.52 | 4.99 | 5.32 | 2249949.0 |
| 2009-04-15 | AAIC-DELISTED | Stock | 6.2 | 6.4 | 5.8 | 6.0 | 312721.0 |
| 2009-04-15 | AAME | Stock | 0.64 | 0.65 | 0.64 | 0.65 | 5100.0 |
| 2009-04-15 | AAON | Stock | 3.1842 | 3.3343 | 3.1506 | 3.3027 | 433350.0 |
| 2009-04-15 | AAP | Stock | 40.5 | 42.16 | 40.09 | 42.07 | 2367600.0 |
| 2009-04-15 | AATI-DELISTED | Stock | 4.41 | 4.6 | 4.38 | 4.58 | 263334.0 |
| 2009-04-15 | AAU-DELISTED | Stock | 0.65 | 0.66 | 0.62 | 0.63 | 39932.0 |
| 2009-04-15 | AAUAF-DELISTED | Stock | 0.65 | 0.66 | 0.62 | 0.63 | 40764.0 |
| 2009-04-15 | AAV-DELISTED | Stock | 2.95 | 3.09 | 2.85 | 3.07 | 1351249.0 |
| 2009-04-15 | AAWW-DELISTED | Stock | 21.43 | 22.47 | 20.97 | 22.02 | 192782.0 |
| 2009-04-15 | AAXJ | Stock | 37.36 | 37.58 | 37.04 | 37.58 | 67447.0 |
| 2009-04-15 | AAXN-DELISTED | Stock | 4.79 | 4.95 | 4.77 | 4.87 | 506159.0 |
| 2009-04-15 | AB | Stock | 18.51 | 19.29 | 18.51 | 19.17 | 442000.0 |
| 2009-04-15 | ABAX-DELISTED | Stock | 15.55 | 16.08 | 15.04 | 15.19 | 376230.0 |
| 2009-04-15 | ABB-DELISTED | Stock | 14.89 | 15.23 | 14.82 | 15.22 | 3174566.0 |
| 2009-04-15 | ABBC-DELISTED | Stock | 8.72 | 8.95 | 8.72 | 8.95 | 50674.0 |
| 2009-04-15 | ABBNY-DELISTED | Stock | 14.89 | 15.23 | 14.82 | 15.2 | 3226466.0 |
| 2009-04-15 | ABC-DELISTED | Stock | 16.57 | 16.63 | 16.18 | 16.42 | 2263548.0 |
| 2009-04-15 | ABCB | Stock | 6.7502 | 7.5671 | 6.7502 | 7.3629 | 14497.0 |
| 2009-04-15 | ABCO-DELISTED | Stock | 8.982 | 9.258 | 8.872 | 9.143 | 97699.0 |
| 2009-04-15 | ABCW-DELISTED | Stock | 1.62 | 1.71 | 1.45 | 1.5 | 135840.0 |
| 2009-04-15 | ABD-DELISTED | Stock | 1.15 | 1.26 | 1.15 | 1.2 | 302710.0 |
| 2009-04-15 | ABE-DELISTED | Stock | 13.0406 | 13.87 | 12.55 | 13.1 | 28866.0 |
| 2009-04-15 | ABEO | Stock | 1937.5 | 2000.0 | 1937.5 | 2000.0 | 11.0 |
| 2009-04-15 | ABFS-DELISTED | Stock | 23.16 | 23.41 | 22.52 | 23.04 | 411947.0 |
| 2009-04-15 | ABG | Stock | 5.87 | 5.87 | 5.5 | 5.77 | 544800.0 |
| 2009-04-15 | ABII-DELISTED | Stock | 44.1 | 45.27 | 43.73 | 44.93 | 18969.0 |
| 2009-04-15 | ABK-DELISTED | Stock | 1.0 | 1.08 | 0.995 | 1.06 | 6776966.0 |
| 2009-04-15 | ABM | Stock | 16.87 | 17.48 | 16.75 | 17.34 | 186500.0 |
| 2009-04-15 | ABMD-DELISTED | Stock | 5.37 | 5.56 | 5.25 | 5.56 | 247355.0 |
| 2009-04-15 | ABR | Stock | 1.28 | 1.28 | 1.13 | 1.2 | 141900.0 |
| 2009-04-15 | ABT | Stock | 20.8281 | 21.212 | 20.094 | 20.4683 | 55736974.0 |
| 2009-04-15 | ABTL-DELISTED | Stock | 1.3228 | 1.7807 | 1.2729 | 1.45 | 24441.0 |
| 2009-04-15 | ABV-DELISTED | Stock | 51.53 | 52.39 | 51.3 | 52.13 | 676771.0 |
| 2009-04-15 | ABVT-DELISTED | Stock | 48.0 | 48.0 | 48.0 | 48.0 | 900.0 |
| 2009-04-15 | ABX-DELISTED | Stock | 29.27 | 29.93 | 29.23 | 29.8 | 8406529.0 |
| 2009-04-15 | ACAD | Stock | 0.96 | 1.1 | 0.96 | 1.09 | 85800.0 |
| 2009-04-15 | ACAP-DELISTED | Stock | 40.7 | 42.44 | 40.68 | 42.43 | 36215.0 |
| 2009-04-15 | ACAS-DELISTED | Stock | 2.68 | 2.75 | 2.51 | 2.62 | 4962351.0 |
> showing 50 of 5,710 rows — these rows as CSV