PREVIEW / stock_daily / 2009-06-22
file: by_date/stock_daily/2009/2009-06-22.parquet size: 180 KB rows: 5,772 symbols: 3,448
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-22 | AAPL | Stock | 5.0239 | 5.0557 | 4.8689 | 4.9061 | 634914000.0 |
| 2009-06-22 | MSFT | Stock | 23.95 | 23.95 | 23.25 | 23.28 | 71291600.0 |
| 2009-06-22 | NVDA | Stock | 0.2805 | 0.2805 | 0.2628 | 0.2638 | 574864000.0 |
| 2009-06-22 | AMZN | Stock | 4.1205 | 4.1215 | 3.928 | 3.9575 | 194888000.0 |
| 2009-06-22 | TLT | Stock | 92.44 | 92.91 | 92.06 | 92.58 | 3952348.0 |
| 2009-06-22 | ES | Stock | 21.85 | 22.5 | 21.63 | 22.11 | 2326800.0 |
| 2009-06-22 | CL | Stock | 34.995 | 35.58 | 34.98 | 35.275 | 4858800.0 |
| 2009-06-22 | A | Stock | 13.4192 | 13.4907 | 13.1187 | 13.1617 | 4045952.0 |
| 2009-06-22 | AABA-DELISTED | Stock | 15.55 | 15.61 | 14.71 | 14.71 | 26068679.0 |
| 2009-06-22 | AACC-DELISTED | Stock | 8.14 | 8.68 | 7.98 | 8.32 | 184107.0 |
| 2009-06-22 | AACG | Stock | 7.86 | 12.2 | 7.86 | 9.41 | 1016600.0 |
| 2009-06-22 | AAI-DELISTED | Stock | 5.9 | 5.9 | 5.5 | 5.51 | 1431994.0 |
| 2009-06-22 | AAIC-DELISTED | Stock | 8.0 | 8.4 | 7.4 | 8.0 | 1112610.0 |
| 2009-06-22 | AAON | Stock | 3.7412 | 3.7472 | 3.6741 | 3.6919 | 438412.0 |
| 2009-06-22 | AAP | Stock | 42.5 | 42.62 | 41.48 | 42.25 | 1576200.0 |
| 2009-06-22 | AATI-DELISTED | Stock | 4.71 | 4.77 | 4.422 | 4.47 | 201126.0 |
| 2009-06-22 | AAU-DELISTED | Stock | 0.66 | 0.67 | 0.62 | 0.62 | 100930.0 |
| 2009-06-22 | AAUAF-DELISTED | Stock | 0.66 | 0.67 | 0.62 | 0.62 | 101030.0 |
| 2009-06-22 | AAV-DELISTED | Stock | 4.73 | 4.82 | 4.39 | 4.49 | 1480822.0 |
| 2009-06-22 | AAWW-DELISTED | Stock | 23.27 | 23.56 | 22.0 | 22.04 | 246832.0 |
| 2009-06-22 | AAXJ | Stock | 42.01 | 43.23 | 41.75 | 42.4 | 325631.0 |
| 2009-06-22 | AAXN-DELISTED | Stock | 4.5 | 4.52 | 4.38 | 4.46 | 331551.0 |
| 2009-06-22 | AB | Stock | 20.05 | 20.16 | 18.9 | 18.93 | 420900.0 |
| 2009-06-22 | ABAX-DELISTED | Stock | 18.94 | 19.31 | 18.655 | 19.28 | 360094.0 |
| 2009-06-22 | ABB-DELISTED | Stock | 15.2 | 15.26 | 14.97 | 15.01 | 6258273.0 |
| 2009-06-22 | ABBC-DELISTED | Stock | 8.73 | 8.73 | 8.28 | 8.3 | 96814.0 |
| 2009-06-22 | ABBNY-DELISTED | Stock | 15.2 | 15.26 | 14.97 | 14.99 | 6441221.0 |
| 2009-06-22 | ABC-DELISTED | Stock | 18.2 | 18.26 | 17.97 | 18.02 | 1959088.0 |
| 2009-06-22 | ABCB | Stock | 6.2055 | 6.2638 | 5.8164 | 5.8164 | 19123.0 |
| 2009-06-22 | ABCO-DELISTED | Stock | 12.84 | 12.975 | 12.635 | 12.78 | 269150.0 |
| 2009-06-22 | ABCW-DELISTED | Stock | 1.01 | 1.1 | 0.8499 | 0.85 | 304790.0 |
| 2009-06-22 | ABD-DELISTED | Stock | 3.1747 | 3.1847 | 2.8353 | 2.8453 | 314930.0 |
| 2009-06-22 | ABE-DELISTED | Stock | 14.5 | 14.55 | 14.185 | 14.25 | 64410.0 |
| 2009-06-22 | ABEO | Stock | 2812.5 | 2812.5 | 2750.0 | 2800.0 | 9.0 |
| 2009-06-22 | ABFS-DELISTED | Stock | 29.84 | 29.84 | 28.17 | 28.25 | 496319.0 |
| 2009-06-22 | ABG | Stock | 10.23 | 10.23 | 9.6 | 9.77 | 328100.0 |
| 2009-06-22 | ABII-DELISTED | Stock | 37.52 | 38.9 | 35.25 | 36.64 | 23677.0 |
| 2009-06-22 | ABK-DELISTED | Stock | 1.12 | 1.12 | 1.02 | 1.02 | 5100802.0 |
| 2009-06-22 | ABM | Stock | 17.27 | 17.27 | 16.84 | 16.99 | 323600.0 |
| 2009-06-22 | ABMD-DELISTED | Stock | 8.21 | 8.35 | 8.15 | 8.19 | 309282.0 |
| 2009-06-22 | ABR | Stock | 2.0 | 2.0 | 1.75 | 1.79 | 223900.0 |
| 2009-06-22 | ABT | Stock | 22.637 | 22.7233 | 22.3491 | 22.4115 | 19041892.0 |
| 2009-06-22 | ABTL-DELISTED | Stock | 2.2508 | 2.2508 | 1.9967 | 2.1992 | 465128.0 |
| 2009-06-22 | ABV-DELISTED | Stock | 64.45 | 64.56 | 62.24 | 62.29 | 645871.0 |
| 2009-06-22 | ABVA-DELISTED | Stock | 2.56 | 2.9358 | 2.56 | 2.9358 | 1580.0 |
| 2009-06-22 | ABVT-DELISTED | Stock | 80.83 | 81.92 | 76.82 | 76.86 | 56570.0 |
| 2009-06-22 | ABX-DELISTED | Stock | 32.93 | 32.95 | 31.76 | 31.81 | 9059623.0 |
| 2009-06-22 | ACAD | Stock | 2.21 | 2.27 | 1.97 | 1.97 | 236300.0 |
| 2009-06-22 | ACAP-DELISTED | Stock | 39.4 | 39.65 | 39.25 | 39.43 | 47731.0 |
| 2009-06-22 | ACAS-DELISTED | Stock | 3.1 | 3.14 | 2.87 | 2.87 | 4974058.0 |
> showing 50 of 5,772 rows — these rows as CSV