PREVIEW / stock_daily / 2009-04-06
file: by_date/stock_daily/2009/2009-04-06.parquet size: 175 KB rows: 5,714 symbols: 3,410
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-04-06 | AAPL | Stock | 4.105 | 4.2411 | 4.0457 | 4.2304 | 658064400.0 |
| 2009-04-06 | MSFT | Stock | 18.54 | 18.76 | 18.27 | 18.76 | 47476100.0 |
| 2009-04-06 | NVDA | Stock | 0.2783 | 0.2862 | 0.2745 | 0.2838 | 887288000.0 |
| 2009-04-06 | AMZN | Stock | 3.863 | 3.918 | 3.8 | 3.8995 | 115026000.0 |
| 2009-04-06 | TLT | Stock | 103.54 | 103.59 | 102.22 | 102.48 | 1418006.0 |
| 2009-04-06 | ES | Stock | 21.0 | 21.39 | 20.92 | 21.22 | 1595000.0 |
| 2009-04-06 | CL | Stock | 30.105 | 30.605 | 30.01 | 30.555 | 5404600.0 |
| 2009-04-06 | A | Stock | 11.6667 | 11.6738 | 11.2589 | 11.4306 | 4691688.0 |
| 2009-04-06 | AABA-DELISTED | Stock | 13.1 | 13.24 | 12.99 | 13.22 | 11803082.0 |
| 2009-04-06 | AACC-DELISTED | Stock | 6.07 | 6.321 | 6.07 | 6.15 | 30365.0 |
| 2009-04-06 | AACG | Stock | 4.24 | 4.29 | 4.16 | 4.25 | 5800.0 |
| 2009-04-06 | AAI-DELISTED | Stock | 5.01 | 5.3 | 4.98 | 5.14 | 2234131.0 |
| 2009-04-06 | AAIC-DELISTED | Stock | 5.0 | 6.2 | 4.454 | 5.2 | 1238958.0 |
| 2009-04-06 | AAME | Stock | 0.5 | 0.55 | 0.5 | 0.55 | 1700.0 |
| 2009-04-06 | AAON | Stock | 3.6109 | 3.6109 | 3.4568 | 3.4943 | 374625.0 |
| 2009-04-06 | AAP | Stock | 40.16 | 40.48 | 39.38 | 40.3 | 2064200.0 |
| 2009-04-06 | AATI-DELISTED | Stock | 3.83 | 4.05 | 3.75 | 3.98 | 152660.0 |
| 2009-04-06 | AAU-DELISTED | Stock | 0.75 | 0.76 | 0.7 | 0.71 | 130922.0 |
| 2009-04-06 | AAUAF-DELISTED | Stock | 0.75 | 0.76 | 0.7 | 0.71 | 131172.0 |
| 2009-04-06 | AAV-DELISTED | Stock | 2.55 | 2.55 | 2.4 | 2.45 | 915376.0 |
| 2009-04-06 | AAWW-DELISTED | Stock | 19.5 | 19.5 | 18.22 | 18.97 | 220149.0 |
| 2009-04-06 | AAXJ | Stock | 36.11 | 36.28 | 35.5901 | 36.28 | 66826.0 |
| 2009-04-06 | AAXN-DELISTED | Stock | 4.74 | 4.94 | 4.63 | 4.93 | 1146926.0 |
| 2009-04-06 | AB | Stock | 16.6 | 16.99 | 16.17 | 16.76 | 738700.0 |
| 2009-04-06 | ABAX-DELISTED | Stock | 18.26 | 18.74 | 17.63 | 17.74 | 220025.0 |
| 2009-04-06 | ABB-DELISTED | Stock | 14.82 | 14.92 | 14.55 | 14.86 | 4789976.0 |
| 2009-04-06 | ABBC-DELISTED | Stock | 8.27 | 8.43 | 8.19 | 8.33 | 51214.0 |
| 2009-04-06 | ABBNY-DELISTED | Stock | 14.8 | 14.92 | 14.55 | 14.91 | 4790276.0 |
| 2009-04-06 | ABC-DELISTED | Stock | 16.25 | 16.61 | 16.18 | 16.42 | 2589792.0 |
| 2009-04-06 | ABCB | Stock | 6.2735 | 7.2559 | 5.8553 | 6.5848 | 46574.0 |
| 2009-04-06 | ABCO-DELISTED | Stock | 8.845 | 8.94 | 8.585 | 8.875 | 89302.0 |
| 2009-04-06 | ABCW-DELISTED | Stock | 1.35 | 1.49 | 1.35 | 1.43 | 100490.0 |
| 2009-04-06 | ABD-DELISTED | Stock | 1.51 | 1.51 | 1.2 | 1.2 | 563560.0 |
| 2009-04-06 | ABE-DELISTED | Stock | 12.8 | 12.8 | 12.43 | 12.58 | 3748.0 |
| 2009-04-06 | ABEO | Stock | 2037.5 | 2125.0 | 2012.5 | 2012.5 | 7.0 |
| 2009-04-06 | ABFS-DELISTED | Stock | 20.33 | 20.33 | 19.08 | 19.66 | 480952.0 |
| 2009-04-06 | ABG | Stock | 5.7 | 5.7 | 5.06 | 5.24 | 423300.0 |
| 2009-04-06 | ABII-DELISTED | Stock | 46.0 | 46.9 | 43.77 | 45.5 | 19034.0 |
| 2009-04-06 | ABK-DELISTED | Stock | 0.89 | 0.95 | 0.84 | 0.93 | 5889055.0 |
| 2009-04-06 | ABM | Stock | 16.72 | 17.29 | 16.72 | 17.11 | 586000.0 |
| 2009-04-06 | ABMD-DELISTED | Stock | 5.2 | 5.23 | 4.98 | 5.17 | 214363.0 |
| 2009-04-06 | ABR | Stock | 0.9 | 0.9 | 0.79 | 0.8 | 196600.0 |
| 2009-04-06 | ABT | Stock | 21.044 | 21.2647 | 20.5162 | 20.8041 | 35521676.0 |
| 2009-04-06 | ABTL-DELISTED | Stock | 1.3245 | 1.3245 | 1.2245 | 1.25 | 19230.0 |
| 2009-04-06 | ABV-DELISTED | Stock | 51.97 | 53.48 | 51.77 | 53.41 | 742083.0 |
| 2009-04-06 | ABVA-DELISTED | Stock | 1.98 | 1.98 | 1.98 | 1.98 | 500.0 |
| 2009-04-06 | ABVT-DELISTED | Stock | 48.0 | 48.0 | 46.75 | 46.75 | 44750.0 |
| 2009-04-06 | ABX-DELISTED | Stock | 29.74 | 29.74 | 28.65 | 28.73 | 15500562.0 |
| 2009-04-06 | ACAD | Stock | 1.05 | 1.09 | 1.01 | 1.02 | 92600.0 |
| 2009-04-06 | ACAP-DELISTED | Stock | 41.66 | 42.0381 | 41.23 | 41.68 | 29138.0 |
> showing 50 of 5,714 rows — these rows as CSV