PREVIEW / stock_daily / 2009-06-12
file: by_date/stock_daily/2009/2009-06-12.parquet size: 182 KB rows: 5,799 symbols: 3,464
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-06-12 | AAPL | Stock | 4.9575 | 4.9679 | 4.8586 | 4.8918 | 563085600.0 |
| 2009-06-12 | MSFT | Stock | 22.9 | 23.38 | 22.74 | 23.33 | 50963500.0 |
| 2009-06-12 | NVDA | Stock | 0.285 | 0.2888 | 0.2785 | 0.2878 | 595000000.0 |
| 2009-06-12 | AMZN | Stock | 4.2515 | 4.26 | 4.1005 | 4.204 | 124460000.0 |
| 2009-06-12 | TLT | Stock | 89.42 | 90.65 | 89.42 | 89.97 | 6607128.0 |
| 2009-06-12 | ES | Stock | 21.65 | 22.19 | 21.36 | 22.12 | 1615900.0 |
| 2009-06-12 | CL | Stock | 34.98 | 36.0 | 34.895 | 35.69 | 6137200.0 |
| 2009-06-12 | A | Stock | 14.0701 | 14.0701 | 13.5479 | 13.8484 | 3673525.0 |
| 2009-06-12 | AABA-DELISTED | Stock | 16.16 | 16.47 | 16.1 | 16.42 | 16804984.0 |
| 2009-06-12 | AACC-DELISTED | Stock | 8.99 | 9.06 | 8.45 | 9.03 | 19444.0 |
| 2009-06-12 | AACG | Stock | 6.8 | 7.15 | 6.52 | 7.0 | 45000.0 |
| 2009-06-12 | AAI-DELISTED | Stock | 5.47 | 5.55 | 5.33 | 5.4 | 1923378.0 |
| 2009-06-12 | AAIC-DELISTED | Stock | 8.4 | 9.2 | 8.4 | 8.8 | 419658.0 |
| 2009-06-12 | AAME | Stock | 0.75 | 0.75 | 0.73 | 0.73 | 2000.0 |
| 2009-06-12 | AAON | Stock | 4.0909 | 4.2074 | 4.0533 | 4.1521 | 138712.0 |
| 2009-06-12 | AAP | Stock | 41.39 | 41.56 | 40.69 | 41.24 | 1932600.0 |
| 2009-06-12 | AATI-DELISTED | Stock | 4.78 | 4.85 | 4.65 | 4.84 | 234586.0 |
| 2009-06-12 | AAU-DELISTED | Stock | 0.75 | 0.75 | 0.69 | 0.69 | 145635.0 |
| 2009-06-12 | AAUAF-DELISTED | Stock | 0.75 | 0.75 | 0.69 | 0.69 | 154735.0 |
| 2009-06-12 | AAV-DELISTED | Stock | 5.69 | 5.88 | 5.52 | 5.81 | 1535329.0 |
| 2009-06-12 | AAWW-DELISTED | Stock | 24.9 | 24.94 | 24.15 | 24.63 | 131782.0 |
| 2009-06-12 | AAXJ | Stock | 45.77 | 45.89 | 45.44 | 45.89 | 261491.0 |
| 2009-06-12 | AAXN-DELISTED | Stock | 4.45 | 4.5 | 4.41 | 4.46 | 156532.0 |
| 2009-06-12 | AB | Stock | 22.12 | 22.62 | 22.05 | 22.49 | 402900.0 |
| 2009-06-12 | ABAX-DELISTED | Stock | 17.35 | 17.75 | 17.19 | 17.51 | 129982.0 |
| 2009-06-12 | ABB-DELISTED | Stock | 16.6 | 16.66 | 16.43 | 16.64 | 2768263.0 |
| 2009-06-12 | ABBC-DELISTED | Stock | 8.3 | 8.67 | 8.03 | 8.6 | 59277.0 |
| 2009-06-12 | ABBNY-DELISTED | Stock | 16.6 | 16.66 | 16.43 | 16.64 | 2771747.0 |
| 2009-06-12 | ABC-DELISTED | Stock | 18.45 | 18.57 | 18.17 | 18.26 | 3117412.0 |
| 2009-06-12 | ABCB | Stock | 6.0791 | 6.3124 | 6.0791 | 6.2638 | 11309.0 |
| 2009-06-12 | ABCO-DELISTED | Stock | 12.628 | 12.787 | 12.378 | 12.772 | 193836.0 |
| 2009-06-12 | ABCW-DELISTED | Stock | 1.42 | 1.42 | 1.28 | 1.32 | 183720.0 |
| 2009-06-12 | ABD-DELISTED | Stock | 3.3649 | 3.4551 | 3.2648 | 3.4451 | 184530.0 |
| 2009-06-12 | ABE-DELISTED | Stock | 15.76 | 15.9 | 15.56 | 15.57 | 32019.0 |
| 2009-06-12 | ABEO | Stock | 2750.0 | 2812.5 | 2750.0 | 2812.5 | 12.0 |
| 2009-06-12 | ABFS-DELISTED | Stock | 28.98 | 29.4499 | 27.78 | 28.5 | 489403.0 |
| 2009-06-12 | ABG | Stock | 11.81 | 11.83 | 11.3 | 11.7 | 281700.0 |
| 2009-06-12 | ABII-DELISTED | Stock | 42.64 | 42.79 | 41.52 | 42.26 | 31352.0 |
| 2009-06-12 | ABK-DELISTED | Stock | 1.24 | 1.25 | 1.18 | 1.21 | 3897197.0 |
| 2009-06-12 | ABM | Stock | 18.44 | 18.59 | 18.29 | 18.5 | 166600.0 |
| 2009-06-12 | ABMD-DELISTED | Stock | 7.48 | 8.19 | 7.39 | 8.18 | 488671.0 |
| 2009-06-12 | ABR | Stock | 2.07 | 2.49 | 2.06 | 2.25 | 1033500.0 |
| 2009-06-12 | ABT | Stock | 21.3367 | 22.0708 | 21.3367 | 21.7925 | 21434348.0 |
| 2009-06-12 | ABTL-DELISTED | Stock | 2.125 | 2.125 | 2.05 | 2.05 | 11227.0 |
| 2009-06-12 | ABV-DELISTED | Stock | 66.13 | 66.68 | 65.51 | 66.64 | 490464.0 |
| 2009-06-12 | ABVA-DELISTED | Stock | 2.56 | 3.3 | 2.56 | 2.99 | 530.0 |
| 2009-06-12 | ABVT-DELISTED | Stock | 76.14 | 79.67 | 74.64 | 79.67 | 64491.0 |
| 2009-06-12 | ABX-DELISTED | Stock | 33.74 | 34.13 | 33.26 | 33.86 | 8812571.0 |
| 2009-06-12 | ACAD | Stock | 2.21 | 2.23 | 2.12 | 2.16 | 173200.0 |
| 2009-06-12 | ACAP-DELISTED | Stock | 40.23 | 41.58 | 39.99 | 40.94 | 35899.0 |
> showing 50 of 5,799 rows — these rows as CSV