PREVIEW / stock_daily / 2009-04-17
file: by_date/stock_daily/2009/2009-04-17.parquet size: 177 KB rows: 5,753 symbols: 3,430
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-17 | AAPL | Stock | 4.3279 | 4.4375 | 4.2946 | 4.4079 | 497495600.0 |
| 2009-04-17 | MSFT | Stock | 19.69 | 19.69 | 19.0 | 19.2 | 61398500.0 |
| 2009-04-17 | NVDA | Stock | 0.292 | 0.2968 | 0.285 | 0.294 | 695764000.0 |
| 2009-04-17 | AMZN | Stock | 3.839 | 3.936 | 3.794 | 3.9025 | 148520000.0 |
| 2009-04-17 | TLT | Stock | 102.47 | 102.71 | 101.37 | 101.7 | 2582707.0 |
| 2009-04-17 | ES | Stock | 21.31 | 21.41 | 20.95 | 21.09 | 1844100.0 |
| 2009-04-17 | CL | Stock | 29.72 | 30.66 | 29.46 | 30.41 | 9646600.0 |
| 2009-04-17 | A | Stock | 12.0386 | 12.2961 | 11.9027 | 12.1674 | 4154576.0 |
| 2009-04-17 | AABA-DELISTED | Stock | 14.44 | 14.52 | 14.03 | 14.35 | 19656986.0 |
| 2009-04-17 | AACC-DELISTED | Stock | 6.65 | 6.94 | 6.33 | 6.89 | 113515.0 |
| 2009-04-17 | AACG | Stock | 4.3 | 4.3 | 4.21 | 4.3 | 13900.0 |
| 2009-04-17 | AAI-DELISTED | Stock | 5.4 | 5.6 | 5.25 | 5.5301 | 1742746.0 |
| 2009-04-17 | AAIC-DELISTED | Stock | 6.45 | 6.8 | 6.2 | 6.8 | 463444.0 |
| 2009-04-17 | AAME | Stock | 0.71 | 0.71 | 0.65 | 0.65 | 2700.0 |
| 2009-04-17 | AAON | Stock | 3.4212 | 3.524 | 3.3877 | 3.4785 | 424744.0 |
| 2009-04-17 | AAP | Stock | 43.74 | 43.85 | 43.01 | 43.34 | 1305000.0 |
| 2009-04-17 | AATI-DELISTED | Stock | 4.76 | 4.82 | 4.66 | 4.77 | 399718.0 |
| 2009-04-17 | AAU-DELISTED | Stock | 0.616 | 0.63 | 0.5545 | 0.61 | 221043.0 |
| 2009-04-17 | AAUAF-DELISTED | Stock | 0.611 | 0.62 | 0.55 | 0.605 | 231369.0 |
| 2009-04-17 | AAV-DELISTED | Stock | 3.18 | 3.24 | 3.12 | 3.12 | 982854.0 |
| 2009-04-17 | AAWW-DELISTED | Stock | 24.12 | 24.75 | 23.01 | 24.38 | 144585.0 |
| 2009-04-17 | AAXJ | Stock | 37.78 | 38.0 | 37.41 | 37.61 | 111094.0 |
| 2009-04-17 | AAXN-DELISTED | Stock | 5.11 | 5.17 | 4.98 | 5.13 | 437322.0 |
| 2009-04-17 | AB | Stock | 19.23 | 20.44 | 18.8 | 20.0 | 902200.0 |
| 2009-04-17 | ABAX-DELISTED | Stock | 15.31 | 15.5 | 15.05 | 15.32 | 164202.0 |
| 2009-04-17 | ABB-DELISTED | Stock | 15.23 | 15.5 | 15.1 | 15.37 | 3523615.0 |
| 2009-04-17 | ABBC-DELISTED | Stock | 8.5 | 9.2 | 8.5 | 9.05 | 64536.0 |
| 2009-04-17 | ABBNY-DELISTED | Stock | 15.23 | 15.5 | 15.1 | 15.36 | 3623915.0 |
| 2009-04-17 | ABC-DELISTED | Stock | 17.92 | 17.92 | 17.17 | 17.43 | 5417792.0 |
| 2009-04-17 | ABCB | Stock | 7.7909 | 8.1604 | 7.7131 | 7.8686 | 31152.0 |
| 2009-04-17 | ABCO-DELISTED | Stock | 9.175 | 9.342 | 8.982 | 9.26 | 145046.0 |
| 2009-04-17 | ABCW-DELISTED | Stock | 1.51 | 1.56 | 1.46 | 1.55 | 108500.0 |
| 2009-04-17 | ABD-DELISTED | Stock | 1.325 | 1.325 | 1.2246 | 1.315 | 214290.0 |
| 2009-04-17 | ABE-DELISTED | Stock | 12.98 | 13.43 | 12.93 | 13.15 | 9010.0 |
| 2009-04-17 | ABEO | Stock | 1937.5 | 1987.5 | 1887.5 | 1887.5 | 2.0 |
| 2009-04-17 | ABFS-DELISTED | Stock | 24.45 | 24.78 | 23.8 | 24.45 | 351912.0 |
| 2009-04-17 | ABG | Stock | 6.38 | 7.13 | 5.93 | 7.03 | 768600.0 |
| 2009-04-17 | ABII-DELISTED | Stock | 45.05 | 47.7 | 44.26 | 45.12 | 20124.0 |
| 2009-04-17 | ABK-DELISTED | Stock | 1.1 | 1.11 | 1.02 | 1.06 | 6620489.0 |
| 2009-04-17 | ABM | Stock | 17.58 | 17.95 | 17.38 | 17.87 | 358900.0 |
| 2009-04-17 | ABMD-DELISTED | Stock | 6.1 | 6.115 | 5.62 | 5.74 | 354882.0 |
| 2009-04-17 | ABR | Stock | 1.17 | 1.32 | 1.11 | 1.31 | 391000.0 |
| 2009-04-17 | ABT | Stock | 20.5738 | 21.1736 | 20.4683 | 21.0584 | 32104210.0 |
| 2009-04-17 | ABTL-DELISTED | Stock | 1.35 | 1.552 | 1.35 | 1.5 | 14840.0 |
| 2009-04-17 | ABV-DELISTED | Stock | 53.07 | 53.07 | 52.12 | 52.77 | 439733.0 |
| 2009-04-17 | ABVA-DELISTED | Stock | 1.952 | 1.952 | 1.952 | 1.952 | 1000.0 |
| 2009-04-17 | ABVT-DELISTED | Stock | 49.0 | 49.0 | 47.25 | 48.6 | 25860.0 |
| 2009-04-17 | ABX-DELISTED | Stock | 28.0 | 28.09 | 27.09 | 27.51 | 13179876.0 |
| 2009-04-17 | ACAD | Stock | 1.06 | 1.1 | 1.04 | 1.09 | 101000.0 |
| 2009-04-17 | ACAP-DELISTED | Stock | 42.22 | 42.33 | 41.35 | 41.49 | 39482.0 |
> showing 50 of 5,753 rows — these rows as CSV