PREVIEW / stock_daily / 2009-11-25
file: by_date/stock_daily/2009/2009-11-25.parquet size: 186 KB rows: 5,857 symbols: 3,478
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-11-25 | AAPL | Stock | 7.3357 | 7.3446 | 7.2771 | 7.2925 | 286454000.0 |
| 2009-11-25 | MSFT | Stock | 29.81 | 29.86 | 29.58 | 29.79 | 32033500.0 |
| 2009-11-25 | NVDA | Stock | 0.3268 | 0.3313 | 0.3245 | 0.3268 | 441760000.0 |
| 2009-11-25 | AMZN | Stock | 6.6655 | 6.71 | 6.62 | 6.7015 | 101424000.0 |
| 2009-11-25 | TLT | Stock | 95.49 | 96.2299 | 94.97 | 96.04 | 2789426.0 |
| 2009-11-25 | ES | Stock | 24.3 | 24.6 | 24.21 | 24.49 | 1304800.0 |
| 2009-11-25 | CL | Stock | 42.64 | 42.74 | 42.185 | 42.23 | 3835000.0 |
| 2009-11-25 | A | Stock | 20.887 | 21.1302 | 20.887 | 21.1302 | 2104689.0 |
| 2009-11-25 | AABA-DELISTED | Stock | 15.28 | 15.35 | 15.17 | 15.3 | 21237441.0 |
| 2009-11-25 | AACC-DELISTED | Stock | 5.78 | 5.93 | 5.74 | 5.85 | 14860.0 |
| 2009-11-25 | AACG | Stock | 5.57 | 5.6 | 5.18 | 5.18 | 35900.0 |
| 2009-11-25 | AAI-DELISTED | Stock | 4.13 | 4.16 | 4.1 | 4.15 | 2134819.0 |
| 2009-11-25 | AAIC-DELISTED | Stock | 13.18 | 13.31 | 13.11 | 13.15 | 11910.0 |
| 2009-11-25 | AAON | Stock | 3.8558 | 3.8617 | 3.8104 | 3.8242 | 225281.0 |
| 2009-11-25 | AAP | Stock | 39.35 | 39.54 | 38.54 | 39.47 | 1456700.0 |
| 2009-11-25 | AATI-DELISTED | Stock | 3.43 | 3.46 | 3.34 | 3.43 | 130726.0 |
| 2009-11-25 | AAU-DELISTED | Stock | 0.77 | 0.78 | 0.7601 | 0.78 | 124998.0 |
| 2009-11-25 | AAUAF-DELISTED | Stock | 0.77 | 0.78 | 0.7601 | 0.78 | 125198.0 |
| 2009-11-25 | AAV-DELISTED | Stock | 5.68 | 5.91 | 5.6 | 5.87 | 1191580.0 |
| 2009-11-25 | AAWW-DELISTED | Stock | 30.95 | 31.14 | 30.28 | 30.55 | 309031.0 |
| 2009-11-25 | AAXJ | Stock | 56.04 | 56.1 | 55.69 | 56.07 | 360473.0 |
| 2009-11-25 | AAXN-DELISTED | Stock | 4.3 | 4.43 | 4.3 | 4.39 | 314315.0 |
| 2009-11-25 | AB | Stock | 26.8 | 26.89 | 26.4 | 26.5 | 245400.0 |
| 2009-11-25 | ABAX-DELISTED | Stock | 23.39 | 24.15 | 23.27 | 23.78 | 153953.0 |
| 2009-11-25 | ABB-DELISTED | Stock | 19.12 | 19.22 | 19.04 | 19.21 | 3549129.0 |
| 2009-11-25 | ABBC-DELISTED | Stock | 6.9 | 6.91 | 6.69 | 6.69 | 14771.0 |
| 2009-11-25 | ABBNY-DELISTED | Stock | 19.11 | 19.22 | 19.04 | 19.21 | 3561184.0 |
| 2009-11-25 | ABC-DELISTED | Stock | 25.19 | 25.19 | 24.96 | 24.97 | 1757797.0 |
| 2009-11-25 | ABCB | Stock | 6.3708 | 6.6648 | 6.3708 | 6.5864 | 47239.0 |
| 2009-11-25 | ABCO-DELISTED | Stock | 13.235 | 13.41 | 12.544 | 13.235 | 439062.0 |
| 2009-11-25 | ABCW-DELISTED | Stock | 0.58 | 0.62 | 0.58 | 0.6 | 158950.0 |
| 2009-11-25 | ABD-DELISTED | Stock | 6.22 | 6.4508 | 6.07 | 6.41 | 315190.0 |
| 2009-11-25 | ABE-DELISTED | Stock | 16.76 | 16.93 | 16.76 | 16.93 | 11251.0 |
| 2009-11-25 | ABEO | Stock | 3625.0 | 3900.0 | 3587.5 | 3875.0 | 12.0 |
| 2009-11-25 | ABFS-DELISTED | Stock | 25.11 | 25.26 | 24.63 | 24.98 | 191885.0 |
| 2009-11-25 | ABG | Stock | 11.14 | 11.24 | 10.92 | 11.03 | 363100.0 |
| 2009-11-25 | ABII-DELISTED | Stock | 33.75 | 34.27 | 33.45 | 34.0 | 12508.0 |
| 2009-11-25 | ABK-DELISTED | Stock | 0.88 | 0.883 | 0.83 | 0.8328 | 10436863.0 |
| 2009-11-25 | ABM | Stock | 19.21 | 19.37 | 19.02 | 19.09 | 90200.0 |
| 2009-11-25 | ABMD-DELISTED | Stock | 9.0 | 9.2099 | 8.94 | 8.98 | 126643.0 |
| 2009-11-25 | ABR | Stock | 1.9 | 1.9 | 1.78 | 1.8 | 48900.0 |
| 2009-11-25 | ABT | Stock | 26.0531 | 26.1923 | 25.962 | 26.1059 | 8726344.0 |
| 2009-11-25 | ABTL-DELISTED | Stock | 4.9 | 4.95 | 4.7505 | 4.9 | 7322.0 |
| 2009-11-25 | ABV-DELISTED | Stock | 99.71 | 99.8 | 97.57 | 98.45 | 541343.0 |
| 2009-11-25 | ABVA-DELISTED | Stock | 2.67 | 2.7 | 2.67 | 2.7 | 625.0 |
| 2009-11-25 | ABVT-DELISTED | Stock | 53.54 | 54.11 | 53.36 | 53.98 | 137341.0 |
| 2009-11-25 | ABX-DELISTED | Stock | 43.81 | 44.06 | 43.37 | 43.97 | 13841766.0 |
| 2009-11-25 | ACAD | Stock | 1.33 | 1.35 | 1.31 | 1.35 | 151500.0 |
| 2009-11-25 | ACAP-DELISTED | Stock | 28.63 | 29.28 | 28.133 | 28.21 | 30488.0 |
| 2009-11-25 | ACAS-DELISTED | Stock | 3.07 | 3.08 | 3.01 | 3.01 | 2931593.0 |
> showing 50 of 5,857 rows — these rows as CSV