PREVIEW / stock_daily / 2008-11-06
file: by_date/stock_daily/2008/2008-11-06.parquet size: 176 KB rows: 5,729 symbols: 3,433
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-11-06 | AAPL | Stock | 3.6089 | 3.6707 | 3.5 | 3.5393 | 1319074400.0 |
| 2008-11-06 | MSFT | Stock | 21.87 | 22.08 | 20.86 | 20.88 | 95509700.0 |
| 2008-11-06 | NVDA | Stock | 0.2002 | 0.2078 | 0.19 | 0.1905 | 797936000.0 |
| 2008-11-06 | AMZN | Stock | 2.49 | 2.552 | 2.315 | 2.361 | 309756000.0 |
| 2008-11-06 | TLT | Stock | 94.6 | 95.05 | 93.81 | 94.88 | 919672.0 |
| 2008-11-06 | CL | Stock | 31.63 | 32.27 | 30.525 | 30.8 | 8843800.0 |
| 2008-11-06 | A | Stock | 16.4521 | 16.7167 | 15.2432 | 15.329 | 4442145.0 |
| 2008-11-06 | AABA-DELISTED | Stock | 14.85 | 14.89 | 13.75 | 13.95 | 44268177.0 |
| 2008-11-06 | AACC-DELISTED | Stock | 7.12 | 7.26 | 6.82 | 6.84 | 167850.0 |
| 2008-11-06 | AACG | Stock | 8.3 | 8.3 | 8.18 | 8.24 | 15300.0 |
| 2008-11-06 | AAI-DELISTED | Stock | 3.96 | 3.99 | 3.75 | 3.79 | 1815692.0 |
| 2008-11-06 | AAIC-DELISTED | Stock | 12.4 | 13.2 | 12.0 | 12.2 | 380247.0 |
| 2008-11-06 | AAME | Stock | 1.07 | 1.07 | 1.07 | 1.07 | 500.0 |
| 2008-11-06 | AAON | Stock | 3.5022 | 3.7669 | 3.3699 | 3.6247 | 668250.0 |
| 2008-11-06 | AAP | Stock | 29.32 | 29.9 | 27.95 | 28.07 | 1166300.0 |
| 2008-11-06 | AATI-DELISTED | Stock | 2.86 | 2.94 | 2.71 | 2.88 | 188108.0 |
| 2008-11-06 | AAU-DELISTED | Stock | 0.8 | 0.81 | 0.71 | 0.71 | 89130.0 |
| 2008-11-06 | AAUAF-DELISTED | Stock | 0.8 | 0.81 | 0.71 | 0.71 | 89230.0 |
| 2008-11-06 | AAV-DELISTED | Stock | 6.0 | 6.01 | 5.7 | 5.92 | 718128.0 |
| 2008-11-06 | AAWW-DELISTED | Stock | 22.61 | 22.82 | 20.86 | 21.03 | 280862.0 |
| 2008-11-06 | AAXJ | Stock | 31.83 | 31.83 | 29.23 | 29.23 | 118614.0 |
| 2008-11-06 | AAXN-DELISTED | Stock | 4.91 | 5.17 | 4.76 | 4.76 | 318441.0 |
| 2008-11-06 | AB | Stock | 22.64 | 23.02 | 20.71 | 21.07 | 542400.0 |
| 2008-11-06 | ABAX-DELISTED | Stock | 16.79 | 17.17 | 15.23 | 15.38 | 393380.0 |
| 2008-11-06 | ABB-DELISTED | Stock | 12.39 | 12.5 | 11.14 | 11.26 | 8503343.0 |
| 2008-11-06 | ABBC-DELISTED | Stock | 9.78 | 9.9892 | 9.54 | 9.72 | 46098.0 |
| 2008-11-06 | ABBNY-DELISTED | Stock | 12.39 | 12.5 | 11.14 | 11.22 | 8503443.0 |
| 2008-11-06 | ABC-DELISTED | Stock | 15.29 | 15.47 | 14.86 | 15.08 | 3616368.0 |
| 2008-11-06 | ABCB | Stock | 10.0571 | 10.8644 | 9.9696 | 10.3781 | 25189.0 |
| 2008-11-06 | ABCO-DELISTED | Stock | 11.727 | 11.882 | 10.978 | 11.338 | 338692.0 |
| 2008-11-06 | ABCW-DELISTED | Stock | 5.6544 | 5.9336 | 5.1657 | 5.2156 | 87640.0 |
| 2008-11-06 | ABD-DELISTED | Stock | 2.74 | 2.8 | 2.57 | 2.62 | 274060.0 |
| 2008-11-06 | ABE-DELISTED | Stock | 13.44 | 13.44 | 12.5 | 12.6932 | 21120.0 |
| 2008-11-06 | ABEO | Stock | 2312.5 | 2500.0 | 2250.0 | 2250.0 | 9.0 |
| 2008-11-06 | ABFS-DELISTED | Stock | 25.86 | 26.14 | 25.13 | 25.18 | 466210.0 |
| 2008-11-06 | ABG | Stock | 3.5 | 3.61 | 3.32 | 3.43 | 788000.0 |
| 2008-11-06 | ABII-DELISTED | Stock | 63.11 | 64.75 | 63.01 | 63.34 | 8780.0 |
| 2008-11-06 | ABK-DELISTED | Stock | 1.8 | 1.93 | 1.46 | 1.53 | 55671186.0 |
| 2008-11-06 | ABM | Stock | 15.48 | 15.81 | 15.16 | 15.16 | 181100.0 |
| 2008-11-06 | ABMD-DELISTED | Stock | 14.4 | 14.99 | 14.26 | 14.38 | 159556.0 |
| 2008-11-06 | ABR | Stock | 4.94 | 4.95 | 4.4 | 4.44 | 220200.0 |
| 2008-11-06 | ABT | Stock | 26.2643 | 26.8352 | 25.6069 | 25.7845 | 18032930.0 |
| 2008-11-06 | ABTL-DELISTED | Stock | 3.6 | 3.75 | 3.55 | 3.75 | 1880.0 |
| 2008-11-06 | ABV-DELISTED | Stock | 43.08 | 44.0 | 42.18 | 42.7 | 1050745.0 |
| 2008-11-06 | ABVA-DELISTED | Stock | 3.45 | 3.7 | 3.2 | 3.6 | 7445.0 |
| 2008-11-06 | ABX-DELISTED | Stock | 25.3 | 25.99 | 23.01 | 23.12 | 10822838.0 |
| 2008-11-06 | ACAD | Stock | 1.87 | 1.94 | 1.79 | 1.82 | 92000.0 |
| 2008-11-06 | ACAP-DELISTED | Stock | 36.84 | 38.6 | 36.5 | 36.54 | 124835.0 |
| 2008-11-06 | ACAS-DELISTED | Stock | 13.85 | 14.54 | 13.0 | 13.1 | 2629384.0 |
| 2008-11-06 | ACAT-DELISTED | Stock | 8.01 | 8.2 | 7.74 | 7.86 | 24112.0 |
> showing 50 of 5,729 rows — these rows as CSV