PREVIEW / stock_daily / 2009-06-29
file: by_date/stock_daily/2009/2009-06-29.parquet size: 180 KB rows: 5,757 symbols: 3,433
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-29 | AAPL | Stock | 5.1236 | 5.1411 | 5.055 | 5.0704 | 567616000.0 |
| 2009-06-29 | MSFT | Stock | 23.6 | 24.03 | 23.55 | 23.86 | 62854900.0 |
| 2009-06-29 | NVDA | Stock | 0.29 | 0.2945 | 0.2862 | 0.2892 | 510056000.0 |
| 2009-06-29 | AMZN | Stock | 4.1935 | 4.21 | 4.1205 | 4.1515 | 125406000.0 |
| 2009-06-29 | TLT | Stock | 95.07 | 95.37 | 94.58 | 94.73 | 4334831.0 |
| 2009-06-29 | ES | Stock | 22.16 | 22.41 | 21.94 | 22.4 | 797300.0 |
| 2009-06-29 | CL | Stock | 35.885 | 36.245 | 35.74 | 35.87 | 5767200.0 |
| 2009-06-29 | A | Stock | 14.6209 | 14.6638 | 14.392 | 14.6137 | 3079794.0 |
| 2009-06-29 | AABA-DELISTED | Stock | 15.86 | 16.01 | 15.6 | 15.92 | 12209355.0 |
| 2009-06-29 | AACC-DELISTED | Stock | 8.5 | 8.5 | 8.01 | 8.06 | 63423.0 |
| 2009-06-29 | AACG | Stock | 9.7 | 10.2 | 8.64 | 9.1 | 45500.0 |
| 2009-06-29 | AAI-DELISTED | Stock | 5.99 | 6.36 | 5.87 | 6.25 | 2664604.0 |
| 2009-06-29 | AAIC-DELISTED | Stock | 7.2 | 7.8 | 6.8 | 7.4 | 1976153.0 |
| 2009-06-29 | AAON | Stock | 4.0138 | 4.1383 | 4.0138 | 4.0691 | 267300.0 |
| 2009-06-29 | AAP | Stock | 42.07 | 42.18 | 41.3 | 41.56 | 1601500.0 |
| 2009-06-29 | AATI-DELISTED | Stock | 4.61 | 4.61 | 4.45 | 4.59 | 297137.0 |
| 2009-06-29 | AAU-DELISTED | Stock | 0.67 | 0.67 | 0.639 | 0.6408 | 65079.0 |
| 2009-06-29 | AAUAF-DELISTED | Stock | 0.67 | 0.67 | 0.64 | 0.6416 | 65501.0 |
| 2009-06-29 | AAV-DELISTED | Stock | 4.36 | 4.4 | 4.24 | 4.32 | 605422.0 |
| 2009-06-29 | AAWW-DELISTED | Stock | 24.04 | 24.04 | 22.86 | 23.75 | 240321.0 |
| 2009-06-29 | AAXJ | Stock | 44.75 | 44.92 | 44.23 | 44.91 | 213957.0 |
| 2009-06-29 | AAXN-DELISTED | Stock | 4.61 | 4.84 | 4.47 | 4.56 | 785773.0 |
| 2009-06-29 | AB | Stock | 20.01 | 20.27 | 19.72 | 20.01 | 363600.0 |
| 2009-06-29 | ABAX-DELISTED | Stock | 20.22 | 20.6 | 19.875 | 20.53 | 207895.0 |
| 2009-06-29 | ABB-DELISTED | Stock | 15.89 | 16.15 | 15.8 | 16.0 | 4222979.0 |
| 2009-06-29 | ABBC-DELISTED | Stock | 8.22 | 8.3 | 8.01 | 8.2 | 52637.0 |
| 2009-06-29 | ABBNY-DELISTED | Stock | 15.89 | 16.15 | 15.8 | 15.99 | 4232879.0 |
| 2009-06-29 | ABC-DELISTED | Stock | 18.1 | 18.19 | 17.8 | 18.06 | 2778158.0 |
| 2009-06-29 | ABCB | Stock | 6.0888 | 6.361 | 5.8748 | 6.2444 | 24161.0 |
| 2009-06-29 | ABCO-DELISTED | Stock | 12.997 | 13.207 | 12.758 | 12.973 | 103043.0 |
| 2009-06-29 | ABCW-DELISTED | Stock | 1.2544 | 1.3605 | 1.0614 | 1.1 | 432180.0 |
| 2009-06-29 | ABD-DELISTED | Stock | 3.2 | 3.26 | 2.82 | 3.0 | 287240.0 |
| 2009-06-29 | ABE-DELISTED | Stock | 14.94 | 15.52 | 14.94 | 15.25 | 13500.0 |
| 2009-06-29 | ABEO | Stock | 2725.0 | 2812.5 | 2575.0 | 2812.5 | 16.0 |
| 2009-06-29 | ABFS-DELISTED | Stock | 28.19 | 28.19 | 26.21 | 26.59 | 965399.0 |
| 2009-06-29 | ABG | Stock | 11.4 | 11.6 | 10.58 | 10.99 | 225200.0 |
| 2009-06-29 | ABII-DELISTED | Stock | 37.0 | 37.9 | 36.93 | 37.19 | 26116.0 |
| 2009-06-29 | ABK-DELISTED | Stock | 0.99 | 0.99 | 0.93 | 0.94 | 3392911.0 |
| 2009-06-29 | ABM | Stock | 17.8 | 18.4 | 17.75 | 18.14 | 224000.0 |
| 2009-06-29 | ABMD-DELISTED | Stock | 8.59 | 8.81 | 8.415 | 8.67 | 282819.0 |
| 2009-06-29 | ABR | Stock | 1.73 | 1.79 | 1.62 | 1.68 | 513600.0 |
| 2009-06-29 | ABT | Stock | 22.8337 | 22.9536 | 22.3827 | 22.944 | 14043143.0 |
| 2009-06-29 | ABTL-DELISTED | Stock | 2.1503 | 2.1503 | 2.0502 | 2.1497 | 12779.0 |
| 2009-06-29 | ABV-DELISTED | Stock | 66.88 | 66.88 | 64.54 | 64.68 | 614914.0 |
| 2009-06-29 | ABVA-DELISTED | Stock | 2.5 | 2.5 | 2.5 | 2.5 | 508.0 |
| 2009-06-29 | ABVT-DELISTED | Stock | 81.15 | 81.88 | 79.27 | 81.62 | 83849.0 |
| 2009-06-29 | ABX-DELISTED | Stock | 35.1 | 35.35 | 34.62 | 34.87 | 4272854.0 |
| 2009-06-29 | ACAD | Stock | 2.12 | 2.15 | 1.97 | 2.01 | 241900.0 |
| 2009-06-29 | ACAP-DELISTED | Stock | 40.17 | 40.24 | 39.03 | 39.42 | 31162.0 |
| 2009-06-29 | ACAS-DELISTED | Stock | 3.07 | 3.17 | 2.93 | 3.09 | 4709488.0 |
> showing 50 of 5,757 rows — these rows as CSV