PREVIEW / stock_daily / 2009-03-12
file: by_date/stock_daily/2009/2009-03-12.parquet size: 173 KB rows: 5,730 symbols: 3,414
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-03-12 | AAPL | Stock | 3.3179 | 3.4493 | 3.2857 | 3.4411 | 768457200.0 |
| 2009-03-12 | MSFT | Stock | 17.01 | 17.04 | 16.48 | 17.01 | 93694100.0 |
| 2009-03-12 | NVDA | Stock | 0.2318 | 0.2488 | 0.2288 | 0.2462 | 1604604000.0 |
| 2009-03-12 | AMZN | Stock | 3.4175 | 3.4935 | 3.3625 | 3.479 | 226978000.0 |
| 2009-03-12 | TLT | Stock | 102.66 | 103.97 | 102.31 | 103.18 | 3558831.0 |
| 2009-03-12 | ES | Stock | 20.15 | 20.62 | 20.07 | 20.57 | 1655100.0 |
| 2009-03-12 | CL | Stock | 28.115 | 28.31 | 27.66 | 28.255 | 9433400.0 |
| 2009-03-12 | A | Stock | 9.628 | 9.9356 | 9.3419 | 9.8784 | 5116680.0 |
| 2009-03-12 | AABA-DELISTED | Stock | 13.31 | 13.6 | 13.1 | 13.6 | 16555132.0 |
| 2009-03-12 | AACC-DELISTED | Stock | 4.07 | 5.37 | 4.07 | 5.09 | 76491.0 |
| 2009-03-12 | AACG | Stock | 4.81 | 4.82 | 4.62 | 4.8 | 16200.0 |
| 2009-03-12 | AAI-DELISTED | Stock | 3.49 | 4.0 | 3.34 | 3.92 | 3567791.0 |
| 2009-03-12 | AAIC-DELISTED | Stock | 2.2 | 3.0 | 2.2 | 3.0 | 559810.0 |
| 2009-03-12 | AAON | Stock | 3.4528 | 3.6504 | 3.3383 | 3.6168 | 776587.0 |
| 2009-03-12 | AAP | Stock | 39.32 | 39.99 | 38.7 | 39.86 | 2327800.0 |
| 2009-03-12 | AATI-DELISTED | Stock | 3.03 | 3.66 | 3.03 | 3.6 | 269716.0 |
| 2009-03-12 | AAU-DELISTED | Stock | 0.68 | 0.71 | 0.6501 | 0.71 | 81805.0 |
| 2009-03-12 | AAUAF-DELISTED | Stock | 0.68 | 0.71 | 0.6501 | 0.71 | 83805.0 |
| 2009-03-12 | AAV-DELISTED | Stock | 2.03 | 2.32 | 2.01 | 2.3 | 824402.0 |
| 2009-03-12 | AAWW-DELISTED | Stock | 11.49 | 12.91 | 11.13 | 12.83 | 251462.0 |
| 2009-03-12 | AAXJ | Stock | 29.36 | 30.8 | 29.29 | 30.8 | 246612.0 |
| 2009-03-12 | AAXN-DELISTED | Stock | 4.13 | 4.37 | 3.93 | 4.32 | 568761.0 |
| 2009-03-12 | AB | Stock | 12.23 | 13.49 | 11.66 | 13.36 | 735000.0 |
| 2009-03-12 | ABAX-DELISTED | Stock | 17.06 | 18.01 | 16.8 | 17.82 | 260947.0 |
| 2009-03-12 | ABB-DELISTED | Stock | 12.78 | 13.37 | 12.65 | 13.32 | 4918770.0 |
| 2009-03-12 | ABBC-DELISTED | Stock | 7.36 | 8.26 | 6.98 | 8.19 | 88936.0 |
| 2009-03-12 | ABBNY-DELISTED | Stock | 12.78 | 13.37 | 12.65 | 13.32 | 4923718.0 |
| 2009-03-12 | ABC-DELISTED | Stock | 14.1 | 14.78 | 13.75 | 14.7 | 10524420.0 |
| 2009-03-12 | ABCB | Stock | 4.6103 | 6.0791 | 4.6103 | 6.0109 | 43182.0 |
| 2009-03-12 | ABCO-DELISTED | Stock | 6.91 | 7.58 | 6.91 | 7.52 | 147934.0 |
| 2009-03-12 | ABCW-DELISTED | Stock | 0.49 | 0.8 | 0.49 | 0.68 | 205020.0 |
| 2009-03-12 | ABD-DELISTED | Stock | 1.25 | 1.31 | 1.17 | 1.23 | 376940.0 |
| 2009-03-12 | ABE-DELISTED | Stock | 11.2112 | 11.6 | 11.2 | 11.54 | 28556.0 |
| 2009-03-12 | ABEO | Stock | 2000.0 | 2275.0 | 1887.5 | 2125.0 | 9.0 |
| 2009-03-12 | ABFS-DELISTED | Stock | 17.66 | 19.15 | 17.45 | 18.97 | 457987.0 |
| 2009-03-12 | ABG | Stock | 2.01 | 2.18 | 2.0 | 2.13 | 236600.0 |
| 2009-03-12 | ABII-DELISTED | Stock | 55.44 | 56.19 | 53.55 | 54.8 | 26348.0 |
| 2009-03-12 | ABK-DELISTED | Stock | 0.46 | 0.53 | 0.42 | 0.53 | 6041450.0 |
| 2009-03-12 | ABM | Stock | 14.8 | 15.74 | 14.76 | 15.62 | 517600.0 |
| 2009-03-12 | ABMD-DELISTED | Stock | 5.84 | 5.9 | 5.68 | 5.83 | 663368.0 |
| 2009-03-12 | ABR | Stock | 0.79 | 1.14 | 0.78 | 1.13 | 221100.0 |
| 2009-03-12 | ABT | Stock | 21.2839 | 22.6849 | 21.1592 | 22.3827 | 27235098.0 |
| 2009-03-12 | ABTL-DELISTED | Stock | 1.25 | 1.4 | 1.2 | 1.35 | 7072.0 |
| 2009-03-12 | ABV-DELISTED | Stock | 42.26 | 43.74 | 41.92 | 43.66 | 855135.0 |
| 2009-03-12 | ABVT-DELISTED | Stock | 38.01 | 38.01 | 38.0 | 38.0 | 2448.0 |
| 2009-03-12 | ABX-DELISTED | Stock | 28.04 | 29.02 | 27.59 | 28.9 | 16913102.0 |
| 2009-03-12 | ACAD | Stock | 0.9 | 1.0 | 0.89 | 1.0 | 89700.0 |
| 2009-03-12 | ACAP-DELISTED | Stock | 40.0 | 43.99 | 39.53 | 43.42 | 47969.0 |
| 2009-03-12 | ACAS-DELISTED | Stock | 0.8734 | 1.1623 | 0.8315 | 1.1 | 8967752.0 |
| 2009-03-12 | ACAT-DELISTED | Stock | 3.3 | 3.49 | 3.16 | 3.49 | 29705.0 |
> showing 50 of 5,730 rows — these rows as CSV