PREVIEW / stock_daily / 2008-08-20
file: by_date/stock_daily/2008/2008-08-20.parquet size: 183 KB rows: 5,720 symbols: 3,451
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 |
|---|---|---|---|---|---|---|---|
| 2008-08-20 | AAPL | Stock | 6.2418 | 6.3193 | 6.2004 | 6.28 | 506951200.0 |
| 2008-08-20 | MSFT | Stock | 27.54 | 27.58 | 27.17 | 27.29 | 41497200.0 |
| 2008-08-20 | NVDA | Stock | 0.3405 | 0.353 | 0.338 | 0.352 | 1143692000.0 |
| 2008-08-20 | AMZN | Stock | 4.1 | 4.1625 | 4.06 | 4.1065 | 119012000.0 |
| 2008-08-20 | TLT | Stock | 93.38 | 93.71 | 93.15 | 93.31 | 2499938.0 |
| 2008-08-20 | CL | Stock | 38.58 | 38.75 | 38.045 | 38.245 | 6788800.0 |
| 2008-08-20 | A | Stock | 25.2289 | 25.2718 | 24.6924 | 24.8927 | 2776708.0 |
| 2008-08-20 | AABA-DELISTED | Stock | 19.56 | 19.65 | 19.1 | 19.17 | 15872908.0 |
| 2008-08-20 | AACC-DELISTED | Stock | 10.89 | 10.99 | 10.73 | 10.83 | 58492.0 |
| 2008-08-20 | AACG | Stock | 13.15 | 13.15 | 12.77 | 13.08 | 14900.0 |
| 2008-08-20 | AAI-DELISTED | Stock | 2.72 | 2.86 | 2.46 | 2.6 | 3587735.0 |
| 2008-08-20 | AAIC-DELISTED | Stock | 36.2 | 36.8 | 34.2 | 34.4 | 424470.0 |
| 2008-08-20 | AAON | Stock | 4.1343 | 4.1995 | 4.0889 | 4.1659 | 412594.0 |
| 2008-08-20 | AAP | Stock | 41.59 | 43.04 | 41.08 | 42.19 | 1577400.0 |
| 2008-08-20 | AATI-DELISTED | Stock | 4.58 | 5.01 | 4.58 | 4.71 | 1035051.0 |
| 2008-08-20 | AAU-DELISTED | Stock | 1.5 | 1.5 | 1.4 | 1.43 | 79815.0 |
| 2008-08-20 | AAUAF-DELISTED | Stock | 1.5 | 1.5 | 1.4 | 1.43 | 86335.0 |
| 2008-08-20 | AAV-DELISTED | Stock | 10.4 | 10.8 | 10.31 | 10.73 | 511575.0 |
| 2008-08-20 | AAWW-DELISTED | Stock | 52.37 | 53.07 | 50.74 | 51.36 | 243102.0 |
| 2008-08-20 | AAXJ | Stock | 49.05 | 49.05 | 49.02 | 49.02 | 4000.0 |
| 2008-08-20 | AAXN-DELISTED | Stock | 6.26 | 6.4 | 6.13 | 6.1901 | 984528.0 |
| 2008-08-20 | AB | Stock | 51.98 | 53.3 | 51.01 | 53.06 | 396900.0 |
| 2008-08-20 | ABAX-DELISTED | Stock | 21.72 | 21.95 | 21.3 | 21.42 | 216449.0 |
| 2008-08-20 | ABB-DELISTED | Stock | 23.45 | 23.48 | 22.99 | 23.35 | 6925311.0 |
| 2008-08-20 | ABBC-DELISTED | Stock | 9.93 | 10.0 | 9.81 | 9.86 | 27100.0 |
| 2008-08-20 | ABBNY-DELISTED | Stock | 23.45 | 23.48 | 22.99 | 23.39 | 6927807.0 |
| 2008-08-20 | ABC-DELISTED | Stock | 20.82 | 20.86 | 20.56 | 20.8 | 2526734.0 |
| 2008-08-20 | ABCB | Stock | 11.8662 | 12.0413 | 11.7009 | 11.9343 | 16347.0 |
| 2008-08-20 | ABCO-DELISTED | Stock | 15.64 | 16.145 | 15.595 | 15.85 | 474468.0 |
| 2008-08-20 | ABCW-DELISTED | Stock | 7.1 | 7.42 | 6.87 | 7.1 | 193410.0 |
| 2008-08-20 | ABD-DELISTED | Stock | 8.675 | 9.014 | 8.325 | 8.405 | 378650.0 |
| 2008-08-20 | ABE-DELISTED | Stock | 19.0 | 19.24 | 18.94 | 19.059 | 7138.0 |
| 2008-08-20 | ABEO | Stock | 3500.0 | 3625.0 | 3437.5 | 3550.0 | 19.0 |
| 2008-08-20 | ABFS-DELISTED | Stock | 34.98 | 35.66 | 33.93 | 34.87 | 764882.0 |
| 2008-08-20 | ABG | Stock | 12.7 | 12.92 | 12.3 | 12.43 | 481400.0 |
| 2008-08-20 | ABII-DELISTED | Stock | 72.51 | 72.51 | 69.21 | 70.98 | 26240.0 |
| 2008-08-20 | ABK-DELISTED | Stock | 5.65 | 5.79 | 4.9 | 5.22 | 27322842.0 |
| 2008-08-20 | ABM | Stock | 25.09 | 25.47 | 24.69 | 25.01 | 169000.0 |
| 2008-08-20 | ABMD-DELISTED | Stock | 18.11 | 18.31 | 17.8 | 18.11 | 440224.0 |
| 2008-08-20 | ABR | Stock | 10.1 | 10.29 | 9.95 | 10.04 | 192700.0 |
| 2008-08-20 | ABT | Stock | 28.1451 | 28.2938 | 27.7708 | 27.9915 | 9884118.0 |
| 2008-08-20 | ABTL-DELISTED | Stock | 5.6 | 5.65 | 5.0 | 5.5 | 32663.0 |
| 2008-08-20 | ABV-DELISTED | Stock | 61.09 | 61.75 | 60.69 | 61.63 | 534093.0 |
| 2008-08-20 | ABVA-DELISTED | Stock | 2.9 | 2.9 | 2.83 | 2.88 | 7305.0 |
| 2008-08-20 | ABX-DELISTED | Stock | 33.9 | 34.5 | 33.08 | 33.69 | 11042812.0 |
| 2008-08-20 | ACAD | Stock | 2.91 | 2.98 | 2.73 | 2.73 | 100900.0 |
| 2008-08-20 | ACAP-DELISTED | Stock | 44.87 | 44.87 | 43.71 | 44.14 | 38214.0 |
| 2008-08-20 | ACAS-DELISTED | Stock | 21.43 | 21.49 | 20.62 | 21.2 | 4005918.0 |
| 2008-08-20 | ACAT-DELISTED | Stock | 10.175 | 10.75 | 10.13 | 10.18 | 116262.0 |
| 2008-08-20 | ACC-DELISTED | Stock | 28.99 | 29.42 | 28.6 | 29.12 | 373330.0 |
> showing 50 of 5,720 rows — these rows as CSV