PREVIEW / stock_daily / 2009-08-06
file: by_date/stock_daily/2009/2009-08-06.parquet size: 183 KB rows: 5,771 symbols: 3,432
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-08-06 | AAPL | Stock | 5.9136 | 5.9468 | 5.8246 | 5.8539 | 341616800.0 |
| 2009-08-06 | MSFT | Stock | 23.93 | 23.98 | 23.27 | 23.46 | 59686000.0 |
| 2009-08-06 | NVDA | Stock | 0.3362 | 0.3422 | 0.326 | 0.328 | 957588000.0 |
| 2009-08-06 | AMZN | Stock | 4.2155 | 4.242 | 4.1525 | 4.2235 | 93860000.0 |
| 2009-08-06 | TLT | Stock | 90.9 | 91.89 | 90.42 | 91.25 | 3228611.0 |
| 2009-08-06 | ES | Stock | 23.34 | 23.34 | 22.89 | 22.92 | 1828200.0 |
| 2009-08-06 | CL | Stock | 35.845 | 35.865 | 35.51 | 35.75 | 5720600.0 |
| 2009-08-06 | A | Stock | 16.8169 | 16.9313 | 16.5522 | 16.6452 | 5083967.0 |
| 2009-08-06 | AABA-DELISTED | Stock | 14.76 | 14.86 | 14.63 | 14.75 | 35521992.0 |
| 2009-08-06 | AACC-DELISTED | Stock | 7.33 | 7.54 | 7.22 | 7.32 | 28449.0 |
| 2009-08-06 | AACG | Stock | 8.06 | 8.17 | 7.9 | 7.9 | 11500.0 |
| 2009-08-06 | AAI-DELISTED | Stock | 7.14 | 7.14 | 6.74 | 6.77 | 2201967.0 |
| 2009-08-06 | AAIC-DELISTED | Stock | 8.7 | 9.602 | 8.6 | 9.0 | 1920179.0 |
| 2009-08-06 | AAME | Stock | 0.78 | 0.88 | 0.78 | 0.88 | 5700.0 |
| 2009-08-06 | AAON | Stock | 4.1047 | 4.158 | 3.9486 | 3.9881 | 187312.0 |
| 2009-08-06 | AAP | Stock | 45.14 | 45.83 | 44.4 | 45.33 | 1356400.0 |
| 2009-08-06 | AATI-DELISTED | Stock | 4.9 | 5.01 | 4.6 | 4.64 | 154935.0 |
| 2009-08-06 | AAU-DELISTED | Stock | 0.66 | 0.66 | 0.62 | 0.63 | 41414.0 |
| 2009-08-06 | AAUAF-DELISTED | Stock | 0.66 | 0.66 | 0.62 | 0.63 | 42114.0 |
| 2009-08-06 | AAV-DELISTED | Stock | 5.14 | 5.24 | 5.12 | 5.152 | 685065.0 |
| 2009-08-06 | AAWW-DELISTED | Stock | 28.56 | 29.25 | 27.23 | 27.99 | 216118.0 |
| 2009-08-06 | AAXJ | Stock | 50.61 | 50.61 | 49.5 | 49.9799 | 557342.0 |
| 2009-08-06 | AAXN-DELISTED | Stock | 5.13 | 5.2 | 5.03 | 5.04 | 292677.0 |
| 2009-08-06 | AB | Stock | 21.27 | 21.63 | 21.12 | 21.31 | 550100.0 |
| 2009-08-06 | ABAX-DELISTED | Stock | 27.33 | 27.49 | 26.93 | 27.0 | 338865.0 |
| 2009-08-06 | ABB-DELISTED | Stock | 18.44 | 18.57 | 18.13 | 18.291 | 3310961.0 |
| 2009-08-06 | ABBC-DELISTED | Stock | 8.24 | 8.28 | 8.05 | 8.06 | 43586.0 |
| 2009-08-06 | ABBNY-DELISTED | Stock | 18.44 | 18.57 | 18.13 | 18.31 | 3319693.0 |
| 2009-08-06 | ABC-DELISTED | Stock | 20.5 | 20.55 | 20.07 | 20.45 | 4310010.0 |
| 2009-08-06 | ABCB | Stock | 6.3513 | 6.575 | 6.2638 | 6.2638 | 17478.0 |
| 2009-08-06 | ABCO-DELISTED | Stock | 13.0 | 13.0 | 12.76 | 12.885 | 298020.0 |
| 2009-08-06 | ABCW-DELISTED | Stock | 1.5 | 1.52 | 1.44 | 1.49 | 137100.0 |
| 2009-08-06 | ABD-DELISTED | Stock | 4.4251 | 4.6144 | 4.2457 | 4.4649 | 634980.0 |
| 2009-08-06 | ABE-DELISTED | Stock | 16.94 | 16.94 | 16.6 | 16.7 | 8362.0 |
| 2009-08-06 | ABEO | Stock | 5875.0 | 5937.5 | 5500.0 | 5875.0 | 15.0 |
| 2009-08-06 | ABFS-DELISTED | Stock | 27.26 | 27.6 | 26.99 | 27.0 | 393221.0 |
| 2009-08-06 | ABG | Stock | 13.93 | 14.1 | 13.43 | 13.5 | 280000.0 |
| 2009-08-06 | ABII-DELISTED | Stock | 32.97 | 33.38 | 29.75 | 31.23 | 41131.0 |
| 2009-08-06 | ABK-DELISTED | Stock | 1.5 | 1.64 | 1.25 | 1.37 | 64857699.0 |
| 2009-08-06 | ABM | Stock | 21.36 | 21.51 | 20.74 | 21.06 | 147900.0 |
| 2009-08-06 | ABMD-DELISTED | Stock | 7.88 | 7.88 | 7.05 | 7.09 | 262777.0 |
| 2009-08-06 | ABR | Stock | 2.12 | 2.29 | 1.94 | 2.09 | 666200.0 |
| 2009-08-06 | ABT | Stock | 21.1928 | 21.1976 | 20.8665 | 20.9337 | 20409546.0 |
| 2009-08-06 | ABTL-DELISTED | Stock | 2.5 | 2.5 | 2.4 | 2.5 | 47380.0 |
| 2009-08-06 | ABV-DELISTED | Stock | 74.74 | 74.94 | 72.9201 | 73.73 | 445649.0 |
| 2009-08-06 | ABVA-DELISTED | Stock | 2.7399 | 2.7399 | 2.7399 | 2.7399 | 200.0 |
| 2009-08-06 | ABVT-DELISTED | Stock | 86.81 | 87.08 | 84.6 | 84.99 | 64703.0 |
| 2009-08-06 | ABX-DELISTED | Stock | 36.53 | 36.71 | 35.3 | 35.74 | 7457372.0 |
| 2009-08-06 | ACAD | Stock | 4.41 | 4.5 | 4.1 | 4.37 | 1762100.0 |
| 2009-08-06 | ACAP-DELISTED | Stock | 32.87 | 33.51 | 31.5 | 32.16 | 96443.0 |
> showing 50 of 5,771 rows — these rows as CSV