PREVIEW / stock_daily / 2009-07-10
file: by_date/stock_daily/2009/2009-07-10.parquet size: 177 KB rows: 5,695 symbols: 3,385
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-07-10 | AAPL | Stock | 4.8693 | 4.9632 | 4.8686 | 4.9471 | 445275600.0 |
| 2009-07-10 | MSFT | Stock | 22.19 | 22.54 | 22.15 | 22.39 | 43229200.0 |
| 2009-07-10 | NVDA | Stock | 0.2583 | 0.261 | 0.2527 | 0.2592 | 520008000.0 |
| 2009-07-10 | AMZN | Stock | 3.876 | 3.941 | 3.8085 | 3.8815 | 119522000.0 |
| 2009-07-10 | TLT | Stock | 95.62 | 96.3326 | 95.43 | 96.23 | 3981804.0 |
| 2009-07-10 | ES | Stock | 21.47 | 21.48 | 21.13 | 21.38 | 1698200.0 |
| 2009-07-10 | CL | Stock | 36.42 | 36.42 | 35.495 | 35.615 | 8419400.0 |
| 2009-07-10 | A | Stock | 13.4335 | 13.6481 | 13.3906 | 13.5622 | 3415594.0 |
| 2009-07-10 | AABA-DELISTED | Stock | 14.77 | 15.18 | 14.75 | 14.9 | 22839472.0 |
| 2009-07-10 | AACC-DELISTED | Stock | 7.24 | 7.545 | 7.24 | 7.32 | 11534.0 |
| 2009-07-10 | AACG | Stock | 7.44 | 8.0 | 7.29 | 7.99 | 10700.0 |
| 2009-07-10 | AAI-DELISTED | Stock | 5.65 | 5.96 | 5.52 | 5.92 | 1834819.0 |
| 2009-07-10 | AAIC-DELISTED | Stock | 6.8 | 7.6 | 6.8 | 7.0 | 968107.0 |
| 2009-07-10 | AAON | Stock | 3.757 | 3.8459 | 3.6681 | 3.7156 | 178706.0 |
| 2009-07-10 | AAP | Stock | 44.02 | 44.39 | 43.62 | 44.18 | 1073100.0 |
| 2009-07-10 | AATI-DELISTED | Stock | 4.24 | 4.35 | 4.13 | 4.22 | 156202.0 |
| 2009-07-10 | AAU-DELISTED | Stock | 0.581 | 0.609 | 0.57 | 0.58 | 65668.0 |
| 2009-07-10 | AAUAF-DELISTED | Stock | 0.582 | 0.61 | 0.57 | 0.58 | 68056.0 |
| 2009-07-10 | AAV-DELISTED | Stock | 4.11 | 4.38 | 3.95 | 4.31 | 1577771.0 |
| 2009-07-10 | AAWW-DELISTED | Stock | 20.49 | 21.81 | 19.84 | 21.4 | 392197.0 |
| 2009-07-10 | AAXJ | Stock | 43.24 | 43.63 | 43.15 | 43.61 | 856399.0 |
| 2009-07-10 | AAXN-DELISTED | Stock | 4.16 | 4.31 | 4.16 | 4.26 | 150409.0 |
| 2009-07-10 | AB | Stock | 18.01 | 18.23 | 17.9 | 18.1 | 362400.0 |
| 2009-07-10 | ABAX-DELISTED | Stock | 18.86 | 19.025 | 18.6 | 18.69 | 139471.0 |
| 2009-07-10 | ABB-DELISTED | Stock | 14.85 | 15.11 | 14.85 | 15.03 | 3614717.0 |
| 2009-07-10 | ABBC-DELISTED | Stock | 7.91 | 8.21 | 7.87 | 8.09 | 23596.0 |
| 2009-07-10 | ABBNY-DELISTED | Stock | 14.89 | 15.11 | 14.86 | 15.02 | 3616707.0 |
| 2009-07-10 | ABC-DELISTED | Stock | 17.86 | 18.05 | 17.54 | 17.7 | 2809787.0 |
| 2009-07-10 | ABCB | Stock | 5.8164 | 6.1666 | 5.7385 | 6.1666 | 20563.0 |
| 2009-07-10 | ABCO-DELISTED | Stock | 11.588 | 11.593 | 11.257 | 11.367 | 173024.0 |
| 2009-07-10 | ABCW-DELISTED | Stock | 1.2013 | 1.2114 | 1.1198 | 1.13 | 45260.0 |
| 2009-07-10 | ABD-DELISTED | Stock | 2.465 | 2.5548 | 2.4151 | 2.435 | 173580.0 |
| 2009-07-10 | ABE-DELISTED | Stock | 14.62 | 14.64 | 14.301 | 14.64 | 10232.0 |
| 2009-07-10 | ABEO | Stock | 2212.5 | 2437.5 | 2212.5 | 2312.5 | 7.0 |
| 2009-07-10 | ABFS-DELISTED | Stock | 27.04 | 28.29 | 27.011 | 28.15 | 727762.0 |
| 2009-07-10 | ABG | Stock | 9.11 | 9.51 | 8.72 | 9.25 | 263000.0 |
| 2009-07-10 | ABII-DELISTED | Stock | 33.03 | 33.44 | 32.6599 | 33.05 | 18116.0 |
| 2009-07-10 | ABK-DELISTED | Stock | 0.8 | 0.8 | 0.76 | 0.77 | 2327882.0 |
| 2009-07-10 | ABM | Stock | 16.74 | 17.09 | 16.66 | 16.89 | 201300.0 |
| 2009-07-10 | ABMD-DELISTED | Stock | 7.98 | 8.04 | 7.76 | 7.91 | 118054.0 |
| 2009-07-10 | ABR | Stock | 1.5 | 1.53 | 1.5 | 1.5 | 64600.0 |
| 2009-07-10 | ABT | Stock | 21.9748 | 21.9748 | 21.7205 | 21.7877 | 13398499.0 |
| 2009-07-10 | ABTL-DELISTED | Stock | 2.1488 | 2.2 | 2.111 | 2.2 | 33512.0 |
| 2009-07-10 | ABV-DELISTED | Stock | 62.99 | 63.28 | 62.14 | 63.08 | 566256.0 |
| 2009-07-10 | ABVT-DELISTED | Stock | 70.11 | 71.33 | 69.62 | 70.29 | 29770.0 |
| 2009-07-10 | ABX-DELISTED | Stock | 31.43 | 32.04 | 31.03 | 31.64 | 6932097.0 |
| 2009-07-10 | ACAD | Stock | 2.01 | 2.05 | 1.96 | 2.01 | 29000.0 |
| 2009-07-10 | ACAP-DELISTED | Stock | 37.95 | 38.4 | 37.5 | 37.84 | 21866.0 |
| 2009-07-10 | ACAS-DELISTED | Stock | 2.78 | 2.87 | 2.74 | 2.84 | 1460942.0 |
| 2009-07-10 | ACAT-DELISTED | Stock | 3.89 | 3.95 | 3.89 | 3.89 | 3730.0 |
> showing 50 of 5,695 rows — these rows as CSV