PREVIEW / stock_daily / 2007-05-29
file: by_date/stock_daily/2007/2007-05-29.parquet size: 176 KB rows: 5,397 symbols: 3,240
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 |
|---|---|---|---|---|---|---|---|
| 2007-05-29 | AAPL | Stock | 4.0875 | 4.1021 | 4.0246 | 4.0839 | 645694000.0 |
| 2007-05-29 | MSFT | Stock | 30.49 | 30.83 | 30.39 | 30.79 | 42373100.0 |
| 2007-05-29 | NVDA | Stock | 0.5587 | 0.5688 | 0.557 | 0.567 | 316242000.0 |
| 2007-05-29 | AMZN | Stock | 3.4215 | 3.489 | 3.386 | 3.4815 | 234616000.0 |
| 2007-05-29 | TLT | Stock | 86.51 | 86.5699 | 85.83 | 86.36 | 1055700.0 |
| 2007-05-29 | CL | Stock | 33.225 | 33.5 | 33.175 | 33.415 | 3113000.0 |
| 2007-05-29 | A | Stock | 27.5393 | 27.5894 | 27.2532 | 27.4106 | 2971729.0 |
| 2007-05-29 | AABA-DELISTED | Stock | 28.36 | 28.73 | 28.2 | 28.4 | 13639858.0 |
| 2007-05-29 | AACC-DELISTED | Stock | 18.58 | 18.85 | 18.55 | 18.84 | 117995.0 |
| 2007-05-29 | AAI-DELISTED | Stock | 12.03 | 12.43 | 11.98 | 12.15 | 1647191.0 |
| 2007-05-29 | AAIC-DELISTED | Stock | 128.0 | 130.4 | 123.6 | 126.6 | 2498000.0 |
| 2007-05-29 | AAME | Stock | 5.19 | 5.19 | 5.11 | 5.11 | 5600.0 |
| 2007-05-29 | AAON | Stock | 3.6333 | 3.7768 | 3.6333 | 3.7689 | 442716.0 |
| 2007-05-29 | AAP | Stock | 40.6 | 40.75 | 40.0 | 40.68 | 1377600.0 |
| 2007-05-29 | AATI-DELISTED | Stock | 8.96 | 9.0 | 8.84 | 8.9 | 559691.0 |
| 2007-05-29 | AAU-DELISTED | Stock | 2.25 | 2.39 | 2.23 | 2.23 | 99300.0 |
| 2007-05-29 | AAUAF-DELISTED | Stock | 2.25 | 2.39 | 2.23 | 2.23 | 99300.0 |
| 2007-05-29 | AAV-DELISTED | Stock | 12.96 | 12.96 | 12.67 | 12.75 | 587600.0 |
| 2007-05-29 | AAWW-DELISTED | Stock | 58.52 | 59.52 | 58.04 | 58.86 | 108368.0 |
| 2007-05-29 | AAXN-DELISTED | Stock | 10.5 | 10.62 | 10.35 | 10.45 | 3025955.0 |
| 2007-05-29 | AB | Stock | 88.05 | 90.06 | 88.05 | 89.1 | 180500.0 |
| 2007-05-29 | ABAX-DELISTED | Stock | 22.28 | 22.28 | 22.0 | 22.22 | 75392.0 |
| 2007-05-29 | ABB-DELISTED | Stock | 21.2 | 21.28 | 21.08 | 21.19 | 1387700.0 |
| 2007-05-29 | ABBC-DELISTED | Stock | 18.26 | 18.36 | 18.14 | 18.29 | 4167.0 |
| 2007-05-29 | ABBNY-DELISTED | Stock | 21.2 | 21.28 | 21.08 | 21.19 | 1387900.0 |
| 2007-05-29 | ABC-DELISTED | Stock | 26.54 | 26.54 | 25.94 | 26.18 | 2424600.0 |
| 2007-05-29 | ABCB | Stock | 22.2444 | 23.003 | 22.1956 | 22.9349 | 33517.0 |
| 2007-05-29 | ABCO-DELISTED | Stock | 25.47 | 25.62 | 25.36 | 25.57 | 208246.0 |
| 2007-05-29 | ABCW-DELISTED | Stock | 28.6 | 28.82 | 28.2 | 28.51 | 105670.0 |
| 2007-05-29 | ABD-DELISTED | Stock | 24.46 | 24.62 | 24.06 | 24.11 | 544870.0 |
| 2007-05-29 | ABE-DELISTED | Stock | 22.15 | 22.5 | 22.15 | 22.35 | 43000.0 |
| 2007-05-29 | ABEO | Stock | 6312.5 | 6312.5 | 6187.5 | 6250.0 | 4.0 |
| 2007-05-29 | ABFS-DELISTED | Stock | 39.58 | 40.1 | 39.56 | 40.1 | 191374.0 |
| 2007-05-29 | ABG | Stock | 26.87 | 27.17 | 26.77 | 26.96 | 281600.0 |
| 2007-05-29 | ABK-DELISTED | Stock | 90.45 | 92.08 | 90.45 | 91.91 | 1332900.0 |
| 2007-05-29 | ABM | Stock | 29.06 | 29.26 | 28.96 | 29.18 | 163800.0 |
| 2007-05-29 | ABMD-DELISTED | Stock | 11.92 | 11.92 | 11.29 | 11.45 | 227097.0 |
| 2007-05-29 | ABP-DELISTED | Stock | 4.39 | 4.5 | 3.91 | 4.0 | 640100.0 |
| 2007-05-29 | ABR | Stock | 28.17 | 28.32 | 27.87 | 28.22 | 350300.0 |
| 2007-05-29 | ABT | Stock | 26.9504 | 27.2958 | 26.9072 | 27.1807 | 11822426.0 |
| 2007-05-29 | ABTL-DELISTED | Stock | 21.85 | 22.05 | 21.6 | 21.85 | 21464.0 |
| 2007-05-29 | ABV-DELISTED | Stock | 66.75 | 67.7 | 66.19 | 66.59 | 585820.0 |
| 2007-05-29 | ABVA-DELISTED | Stock | 13.67 | 14.19 | 13.67 | 14.04 | 14450.0 |
| 2007-05-29 | ABX-DELISTED | Stock | 29.48 | 29.48 | 28.53 | 28.57 | 5609837.0 |
| 2007-05-29 | ACAD | Stock | 13.26 | 13.26 | 12.84 | 12.9 | 161600.0 |
| 2007-05-29 | ACAP-DELISTED | Stock | 39.69 | 40.27 | 39.59 | 40.26 | 56451.0 |
| 2007-05-29 | ACAS-DELISTED | Stock | 47.53 | 47.77 | 46.91 | 47.6 | 1042880.0 |
| 2007-05-29 | ACAT-DELISTED | Stock | 19.25 | 19.4 | 18.99 | 19.15 | 203397.0 |
| 2007-05-29 | ACC-DELISTED | Stock | 27.99 | 28.61 | 27.99 | 28.34 | 123100.0 |
| 2007-05-29 | ACCL-DELISTED | Stock | 6.5 | 6.5 | 6.38 | 6.45 | 44457.0 |
> showing 50 of 5,397 rows — these rows as CSV