PREVIEW / stock_daily / 2009-05-14
file: by_date/stock_daily/2009/2009-05-14.parquet size: 177 KB rows: 5,727 symbols: 3,419
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-05-14 | AAPL | Stock | 4.2779 | 4.4118 | 4.275 | 4.3911 | 447826400.0 |
| 2009-05-14 | MSFT | Stock | 19.83 | 20.23 | 19.8 | 20.06 | 54539500.0 |
| 2009-05-14 | NVDA | Stock | 0.2098 | 0.2175 | 0.2082 | 0.213 | 1017864000.0 |
| 2009-05-14 | AMZN | Stock | 3.6895 | 3.803 | 3.6655 | 3.7555 | 186872000.0 |
| 2009-05-14 | TLT | Stock | 97.6 | 98.25 | 97.3 | 98.07 | 1704583.0 |
| 2009-05-14 | ES | Stock | 21.17 | 21.5 | 20.83 | 21.03 | 1797300.0 |
| 2009-05-14 | CL | Stock | 32.125 | 32.205 | 31.575 | 31.72 | 8056600.0 |
| 2009-05-14 | A | Stock | 12.8469 | 13.2117 | 12.4034 | 13.1116 | 4686236.0 |
| 2009-05-14 | AABA-DELISTED | Stock | 14.5 | 14.86 | 14.4 | 14.77 | 18618315.0 |
| 2009-05-14 | AACC-DELISTED | Stock | 8.5 | 9.14 | 8.31 | 8.61 | 28814.0 |
| 2009-05-14 | AACG | Stock | 4.99 | 4.99 | 4.7 | 4.75 | 74100.0 |
| 2009-05-14 | AAI-DELISTED | Stock | 6.36 | 6.75 | 5.96 | 6.56 | 2913942.0 |
| 2009-05-14 | AAIC-DELISTED | Stock | 8.6 | 10.0 | 8.2 | 9.2 | 798657.0 |
| 2009-05-14 | AAON | Stock | 3.8775 | 3.9822 | 3.8736 | 3.9032 | 368550.0 |
| 2009-05-14 | AAP | Stock | 39.72 | 41.51 | 39.72 | 39.93 | 1478000.0 |
| 2009-05-14 | AATI-DELISTED | Stock | 4.38 | 4.67 | 4.33 | 4.66 | 253939.0 |
| 2009-05-14 | AAU-DELISTED | Stock | 0.6101 | 0.63 | 0.6099 | 0.61 | 34056.0 |
| 2009-05-14 | AAUAF-DELISTED | Stock | 0.6103 | 0.63 | 0.61 | 0.61 | 35050.0 |
| 2009-05-14 | AAV-DELISTED | Stock | 3.1 | 3.29 | 3.06 | 3.2744 | 658550.0 |
| 2009-05-14 | AAWW-DELISTED | Stock | 22.89 | 23.71 | 22.5 | 23.38 | 909695.0 |
| 2009-05-14 | AAXJ | Stock | 40.83 | 41.15 | 40.06 | 40.91 | 577924.0 |
| 2009-05-14 | AAXN-DELISTED | Stock | 4.15 | 4.29 | 4.15 | 4.24 | 422510.0 |
| 2009-05-14 | AB | Stock | 16.95 | 17.55 | 16.8 | 17.29 | 422100.0 |
| 2009-05-14 | ABAX-DELISTED | Stock | 16.13 | 16.49 | 15.812 | 16.23 | 203668.0 |
| 2009-05-14 | ABB-DELISTED | Stock | 14.86 | 15.03 | 14.68 | 14.86 | 8155533.0 |
| 2009-05-14 | ABBC-DELISTED | Stock | 8.62 | 8.93 | 8.62 | 8.81 | 33437.0 |
| 2009-05-14 | ABBNY-DELISTED | Stock | 14.86 | 15.03 | 14.68 | 14.88 | 8156133.0 |
| 2009-05-14 | ABC-DELISTED | Stock | 17.9 | 18.09 | 17.75 | 17.86 | 2845808.0 |
| 2009-05-14 | ABCB | Stock | 5.7385 | 6.2152 | 5.4176 | 5.9914 | 24161.0 |
| 2009-05-14 | ABCO-DELISTED | Stock | 10.825 | 11.01 | 10.715 | 10.785 | 450872.0 |
| 2009-05-14 | ABCW-DELISTED | Stock | 1.8127 | 1.9038 | 1.6 | 1.6 | 254540.0 |
| 2009-05-14 | ABD-DELISTED | Stock | 2.57 | 3.1706 | 2.37 | 2.82 | 314960.0 |
| 2009-05-14 | ABE-DELISTED | Stock | 14.0 | 14.21 | 13.67 | 14.06 | 11935.0 |
| 2009-05-14 | ABEO | Stock | 2125.0 | 2125.0 | 1812.5 | 1862.5 | 10.0 |
| 2009-05-14 | ABFS-DELISTED | Stock | 22.47 | 23.33 | 21.98 | 22.79 | 756570.0 |
| 2009-05-14 | ABG | Stock | 8.36 | 9.17 | 8.08 | 8.82 | 356700.0 |
| 2009-05-14 | ABII-DELISTED | Stock | 47.23 | 51.08 | 46.55 | 51.03 | 16989.0 |
| 2009-05-14 | ABK-DELISTED | Stock | 1.23 | 1.48 | 1.11 | 1.42 | 23066443.0 |
| 2009-05-14 | ABM | Stock | 16.23 | 16.79 | 16.21 | 16.61 | 353300.0 |
| 2009-05-14 | ABMD-DELISTED | Stock | 6.43 | 6.45 | 6.18 | 6.2 | 706480.0 |
| 2009-05-14 | ABR | Stock | 1.74 | 2.1 | 1.65 | 1.9 | 244600.0 |
| 2009-05-14 | ABT | Stock | 21.8165 | 21.8597 | 21.4087 | 21.4135 | 20020217.0 |
| 2009-05-14 | ABTL-DELISTED | Stock | 2.2521 | 2.35 | 2.2521 | 2.35 | 3463.0 |
| 2009-05-14 | ABV-DELISTED | Stock | 57.54 | 58.72 | 57.23 | 58.43 | 328380.0 |
| 2009-05-14 | ABVA-DELISTED | Stock | 2.23 | 2.45 | 2.23 | 2.45 | 3872.0 |
| 2009-05-14 | ABVT-DELISTED | Stock | 56.0 | 59.0 | 56.0 | 58.75 | 27550.0 |
| 2009-05-14 | ABX-DELISTED | Stock | 34.22 | 34.87 | 33.5 | 34.12 | 8936121.0 |
| 2009-05-14 | ACAD | Stock | 1.78 | 1.92 | 1.73 | 1.74 | 212100.0 |
| 2009-05-14 | ACAP-DELISTED | Stock | 38.92 | 39.08 | 38.47 | 38.65 | 91514.0 |
| 2009-05-14 | ACAS-DELISTED | Stock | 3.07 | 3.35 | 2.9 | 3.25 | 5199507.0 |
> showing 50 of 5,727 rows — these rows as CSV