PREVIEW / stock_daily / 2008-08-18
file: by_date/stock_daily/2008/2008-08-18.parquet size: 184 KB rows: 5,750 symbols: 3,461
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-18 | AAPL | Stock | 6.2704 | 6.3504 | 6.2079 | 6.2639 | 552014400.0 |
| 2008-08-18 | MSFT | Stock | 27.78 | 28.05 | 27.55 | 27.69 | 38078200.0 |
| 2008-08-18 | NVDA | Stock | 0.3263 | 0.3335 | 0.3228 | 0.3305 | 893968000.0 |
| 2008-08-18 | AMZN | Stock | 4.3045 | 4.314 | 4.152 | 4.1555 | 130948000.0 |
| 2008-08-18 | TLT | Stock | 93.08 | 93.538 | 92.96 | 93.41 | 1263123.0 |
| 2008-08-18 | CL | Stock | 39.22 | 39.255 | 38.56 | 38.875 | 4874800.0 |
| 2008-08-18 | A | Stock | 26.0372 | 26.0372 | 25.4363 | 25.5937 | 4201829.0 |
| 2008-08-18 | AABA-DELISTED | Stock | 20.41 | 20.52 | 19.66 | 19.77 | 14740337.0 |
| 2008-08-18 | AACC-DELISTED | Stock | 11.36 | 11.36 | 10.88 | 11.07 | 127893.0 |
| 2008-08-18 | AACG | Stock | 13.46 | 13.5 | 13.31 | 13.5 | 14300.0 |
| 2008-08-18 | AAI-DELISTED | Stock | 3.19 | 3.29 | 3.05 | 3.08 | 2427118.0 |
| 2008-08-18 | AAIC-DELISTED | Stock | 37.8 | 39.8 | 36.6 | 38.4 | 320967.0 |
| 2008-08-18 | AAME | Stock | 1.61 | 1.61 | 1.47 | 1.47 | 2400.0 |
| 2008-08-18 | AAON | Stock | 4.3417 | 4.3852 | 4.2074 | 4.241 | 325519.0 |
| 2008-08-18 | AAP | Stock | 44.84 | 44.86 | 44.0 | 44.3 | 1043400.0 |
| 2008-08-18 | AATI-DELISTED | Stock | 4.89 | 4.9 | 4.61 | 4.62 | 207729.0 |
| 2008-08-18 | AAU-DELISTED | Stock | 1.42 | 1.49 | 1.4 | 1.46 | 70239.0 |
| 2008-08-18 | AAUAF-DELISTED | Stock | 1.42 | 1.49 | 1.4 | 1.46 | 72678.0 |
| 2008-08-18 | AAV-DELISTED | Stock | 10.25 | 10.45 | 9.96 | 10.04 | 632661.0 |
| 2008-08-18 | AAWW-DELISTED | Stock | 53.53 | 54.06 | 52.75 | 52.92 | 155645.0 |
| 2008-08-18 | AAXJ | Stock | 49.77 | 49.77 | 49.0 | 49.0 | 25516.0 |
| 2008-08-18 | AAXN-DELISTED | Stock | 5.9 | 5.96 | 5.75 | 5.94 | 587798.0 |
| 2008-08-18 | AB | Stock | 53.43 | 53.43 | 51.61 | 51.87 | 236000.0 |
| 2008-08-18 | ABAX-DELISTED | Stock | 22.3 | 22.37 | 21.7 | 21.9 | 352281.0 |
| 2008-08-18 | ABB-DELISTED | Stock | 24.16 | 24.23 | 23.79 | 23.84 | 3033217.0 |
| 2008-08-18 | ABBC-DELISTED | Stock | 9.94 | 10.0 | 9.83 | 9.93 | 50454.0 |
| 2008-08-18 | ABBNY-DELISTED | Stock | 24.16 | 24.23 | 23.79 | 23.83 | 3035697.0 |
| 2008-08-18 | ABC-DELISTED | Stock | 21.28 | 21.28 | 20.7 | 20.82 | 2100626.0 |
| 2008-08-18 | ABCB | Stock | 12.2942 | 12.3817 | 11.6425 | 12.3429 | 27554.0 |
| 2008-08-18 | ABCO-DELISTED | Stock | 15.88 | 16.145 | 15.535 | 15.745 | 497304.0 |
| 2008-08-18 | ABCW-DELISTED | Stock | 7.83 | 7.91 | 7.33 | 7.41 | 204940.0 |
| 2008-08-18 | ABD-DELISTED | Stock | 8.97 | 9.17 | 8.76 | 8.85 | 331450.0 |
| 2008-08-18 | ABE-DELISTED | Stock | 18.75 | 19.75 | 18.75 | 19.45 | 37498.0 |
| 2008-08-18 | ABEO | Stock | 3737.5 | 4000.0 | 3625.0 | 3837.5 | 13.0 |
| 2008-08-18 | ABFS-DELISTED | Stock | 38.43 | 38.43 | 37.01 | 37.48 | 265651.0 |
| 2008-08-18 | ABG | Stock | 13.16 | 13.28 | 12.91 | 13.04 | 285300.0 |
| 2008-08-18 | ABII-DELISTED | Stock | 74.1001 | 75.04 | 73.43 | 74.71 | 10688.0 |
| 2008-08-18 | ABK-DELISTED | Stock | 5.82 | 6.33 | 5.25 | 5.94 | 57405406.0 |
| 2008-08-18 | ABM | Stock | 25.63 | 26.41 | 25.34 | 25.64 | 206200.0 |
| 2008-08-18 | ABMD-DELISTED | Stock | 19.0 | 19.1 | 18.71 | 18.88 | 132980.0 |
| 2008-08-18 | ABR | Stock | 10.05 | 10.68 | 10.04 | 10.46 | 426500.0 |
| 2008-08-18 | ABT | Stock | 28.6633 | 28.6633 | 28.1067 | 28.289 | 9091913.0 |
| 2008-08-18 | ABTL-DELISTED | Stock | 5.85 | 5.85 | 5.7 | 5.7 | 3107.0 |
| 2008-08-18 | ABV-DELISTED | Stock | 61.45 | 61.65 | 60.3 | 60.47 | 365217.0 |
| 2008-08-18 | ABVA-DELISTED | Stock | 2.4 | 2.54 | 2.32 | 2.32 | 900.0 |
| 2008-08-18 | ABVT-DELISTED | Stock | 60.0 | 65.0 | 58.97 | 58.97 | 2011.0 |
| 2008-08-18 | ABX-DELISTED | Stock | 33.02 | 33.43 | 32.52 | 32.99 | 9958098.0 |
| 2008-08-18 | ACAD | Stock | 3.09 | 3.11 | 2.95 | 2.97 | 69400.0 |
| 2008-08-18 | ACAP-DELISTED | Stock | 45.56 | 45.89 | 44.57 | 45.1 | 64197.0 |
| 2008-08-18 | ACAS-DELISTED | Stock | 23.23 | 23.23 | 21.65 | 21.72 | 3288866.0 |
> showing 50 of 5,750 rows — these rows as CSV