PREVIEW / stock_daily / 2009-08-19
file: by_date/stock_daily/2009/2009-08-19.parquet size: 183 KB rows: 5,796 symbols: 3,444
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-19 | AAPL | Stock | 5.8125 | 5.9036 | 5.8018 | 5.8786 | 413271600.0 |
| 2009-08-19 | MSFT | Stock | 23.25 | 23.72 | 23.25 | 23.65 | 41821300.0 |
| 2009-08-19 | NVDA | Stock | 0.3283 | 0.3315 | 0.325 | 0.3295 | 552996000.0 |
| 2009-08-19 | AMZN | Stock | 4.0455 | 4.15 | 4.0245 | 4.15 | 103412000.0 |
| 2009-08-19 | TLT | Stock | 95.17 | 95.37 | 94.4115 | 94.96 | 3518280.0 |
| 2009-08-19 | ES | Stock | 23.45 | 23.75 | 23.42 | 23.75 | 957700.0 |
| 2009-08-19 | CL | Stock | 35.435 | 36.07 | 35.365 | 35.985 | 3865000.0 |
| 2009-08-19 | A | Stock | 17.99 | 18.1617 | 17.8684 | 18.0615 | 7608895.0 |
| 2009-08-19 | AABA-DELISTED | Stock | 14.57 | 14.91 | 14.55 | 14.79 | 15209446.0 |
| 2009-08-19 | AACC-DELISTED | Stock | 7.2401 | 7.84 | 7.23 | 7.64 | 41586.0 |
| 2009-08-19 | AACG | Stock | 6.78 | 7.15 | 6.76 | 6.8 | 7600.0 |
| 2009-08-19 | AAI-DELISTED | Stock | 6.36 | 6.43 | 6.25 | 6.32 | 1629210.0 |
| 2009-08-19 | AAIC-DELISTED | Stock | 9.2 | 9.2 | 8.6 | 8.6 | 259354.0 |
| 2009-08-19 | AAON | Stock | 4.3457 | 4.3733 | 4.1541 | 4.2607 | 935044.0 |
| 2009-08-19 | AAP | Stock | 42.8 | 43.82 | 42.78 | 43.72 | 1927300.0 |
| 2009-08-19 | AATI-DELISTED | Stock | 4.5 | 4.64 | 4.47 | 4.56 | 139291.0 |
| 2009-08-19 | AAU-DELISTED | Stock | 0.61 | 0.63 | 0.6095 | 0.61 | 27622.0 |
| 2009-08-19 | AAUAF-DELISTED | Stock | 0.61 | 0.63 | 0.61 | 0.611 | 28100.0 |
| 2009-08-19 | AAV-DELISTED | Stock | 4.98 | 5.34 | 4.95 | 5.2699 | 1329609.0 |
| 2009-08-19 | AAWW-DELISTED | Stock | 24.22 | 24.4 | 23.26 | 24.04 | 256013.0 |
| 2009-08-19 | AAXJ | Stock | 47.17 | 48.09 | 47.17 | 48.08 | 177770.0 |
| 2009-08-19 | AAXN-DELISTED | Stock | 4.78 | 4.94 | 4.77 | 4.94 | 291790.0 |
| 2009-08-19 | AB | Stock | 20.29 | 20.89 | 20.29 | 20.42 | 269700.0 |
| 2009-08-19 | ABAX-DELISTED | Stock | 27.2 | 27.59 | 27.14 | 27.5 | 165765.0 |
| 2009-08-19 | ABB-DELISTED | Stock | 17.7 | 18.33 | 17.7 | 18.2 | 2451771.0 |
| 2009-08-19 | ABBC-DELISTED | Stock | 8.11 | 8.26 | 8.1 | 8.23 | 23686.0 |
| 2009-08-19 | ABBNY-DELISTED | Stock | 17.7 | 18.33 | 17.7 | 18.22 | 2460337.0 |
| 2009-08-19 | ABC-DELISTED | Stock | 20.33 | 21.03 | 20.33 | 20.83 | 2459211.0 |
| 2009-08-19 | ABCB | Stock | 6.0012 | 6.3319 | 5.9817 | 6.1471 | 48733.0 |
| 2009-08-19 | ABCO-DELISTED | Stock | 13.282 | 13.863 | 13.282 | 13.753 | 51032.0 |
| 2009-08-19 | ABCW-DELISTED | Stock | 1.42 | 1.5 | 1.42 | 1.43 | 46290.0 |
| 2009-08-19 | ABD-DELISTED | Stock | 5.25 | 5.3911 | 4.91 | 5.27 | 640020.0 |
| 2009-08-19 | ABE-DELISTED | Stock | 15.79 | 15.95 | 15.35 | 15.93 | 20326.0 |
| 2009-08-19 | ABEO | Stock | 4750.0 | 5000.0 | 4750.0 | 4875.0 | 9.0 |
| 2009-08-19 | ABFS-DELISTED | Stock | 29.12 | 29.96 | 28.95 | 29.84 | 352634.0 |
| 2009-08-19 | ABG | Stock | 12.58 | 13.18 | 12.32 | 13.12 | 186800.0 |
| 2009-08-19 | ABII-DELISTED | Stock | 28.0 | 28.99 | 25.82 | 27.14 | 179636.0 |
| 2009-08-19 | ABK-DELISTED | Stock | 1.02 | 1.09 | 1.01 | 1.06 | 8158801.0 |
| 2009-08-19 | ABM | Stock | 21.02 | 21.72 | 20.92 | 21.7 | 95700.0 |
| 2009-08-19 | ABMD-DELISTED | Stock | 7.44 | 7.68 | 7.44 | 7.65 | 77502.0 |
| 2009-08-19 | ABR | Stock | 1.93 | 1.96 | 1.84 | 1.85 | 67400.0 |
| 2009-08-19 | ABT | Stock | 21.1784 | 21.7301 | 21.1592 | 21.6726 | 19022093.0 |
| 2009-08-19 | ABTL-DELISTED | Stock | 2.5002 | 3.0503 | 2.4997 | 3.0498 | 179367.0 |
| 2009-08-19 | ABV-DELISTED | Stock | 72.71 | 74.41 | 72.41 | 74.27 | 391437.0 |
| 2009-08-19 | ABVT-DELISTED | Stock | 92.51 | 93.17 | 92.035 | 92.78 | 81813.0 |
| 2009-08-19 | ABX-DELISTED | Stock | 32.95 | 34.09 | 32.69 | 33.84 | 6530983.0 |
| 2009-08-19 | ACAD | Stock | 5.66 | 5.85 | 5.57 | 5.8 | 1097300.0 |
| 2009-08-19 | ACAP-DELISTED | Stock | 31.31 | 31.8 | 31.07 | 31.27 | 71465.0 |
| 2009-08-19 | ACAS-DELISTED | Stock | 2.79 | 2.9 | 2.76 | 2.81 | 3892307.0 |
| 2009-08-19 | ACAT-DELISTED | Stock | 7.0 | 7.15 | 7.0 | 7.06 | 16370.0 |
> showing 50 of 5,796 rows — these rows as CSV