PREVIEW / stock_daily / 2009-10-22
file: by_date/stock_daily/2009/2009-10-22.parquet size: 187 KB rows: 5,854 symbols: 3,473
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-10-22 | AAPL | Stock | 7.3107 | 7.4232 | 7.2325 | 7.3286 | 791392000.0 |
| 2009-10-22 | MSFT | Stock | 26.56 | 26.72 | 26.13 | 26.59 | 61600000.0 |
| 2009-10-22 | NVDA | Stock | 0.3328 | 0.3385 | 0.327 | 0.3368 | 379328000.0 |
| 2009-10-22 | AMZN | Stock | 4.683 | 4.705 | 4.585 | 4.6725 | 330370000.0 |
| 2009-10-22 | TLT | Stock | 95.38 | 95.83 | 95.3322 | 95.67 | 2572169.0 |
| 2009-10-22 | ES | Stock | 23.45 | 23.56 | 23.22 | 23.54 | 1088200.0 |
| 2009-10-22 | CL | Stock | 39.21 | 39.795 | 39.115 | 39.69 | 5971600.0 |
| 2009-10-22 | A | Stock | 19.3848 | 19.3848 | 18.8412 | 19.2203 | 3867287.0 |
| 2009-10-22 | AABA-DELISTED | Stock | 17.54 | 17.75 | 17.3 | 17.69 | 15835645.0 |
| 2009-10-22 | AACC-DELISTED | Stock | 6.96 | 7.2 | 6.96 | 7.18 | 11274.0 |
| 2009-10-22 | AAI-DELISTED | Stock | 5.1 | 5.1 | 4.68 | 4.88 | 11090592.0 |
| 2009-10-22 | AAIC-DELISTED | Stock | 14.0 | 14.2 | 13.36 | 14.2 | 202146.0 |
| 2009-10-22 | AAME | Stock | 1.47 | 1.53 | 1.38 | 1.52 | 6800.0 |
| 2009-10-22 | AAON | Stock | 3.759 | 3.8183 | 3.7235 | 3.8005 | 310837.0 |
| 2009-10-22 | AAP | Stock | 37.52 | 37.82 | 37.26 | 37.74 | 1332600.0 |
| 2009-10-22 | AATI-DELISTED | Stock | 3.34 | 3.38 | 3.3 | 3.36 | 545797.0 |
| 2009-10-22 | AAU-DELISTED | Stock | 0.7 | 0.7201 | 0.69 | 0.72 | 56246.0 |
| 2009-10-22 | AAUAF-DELISTED | Stock | 0.7 | 0.7201 | 0.69 | 0.72 | 66346.0 |
| 2009-10-22 | AAV-DELISTED | Stock | 7.56 | 7.67 | 7.22 | 7.42 | 1199782.0 |
| 2009-10-22 | AAWW-DELISTED | Stock | 35.62 | 36.77 | 34.15 | 36.24 | 565442.0 |
| 2009-10-22 | AAXJ | Stock | 54.38 | 54.729 | 53.754 | 54.64 | 562616.0 |
| 2009-10-22 | AAXN-DELISTED | Stock | 4.46 | 4.5 | 4.36 | 4.5 | 798747.0 |
| 2009-10-22 | AB | Stock | 27.01 | 28.01 | 26.71 | 27.98 | 416700.0 |
| 2009-10-22 | ABAX-DELISTED | Stock | 24.61 | 25.58 | 24.61 | 25.5 | 177413.0 |
| 2009-10-22 | ABB-DELISTED | Stock | 21.12 | 21.7 | 20.99 | 21.61 | 3805357.0 |
| 2009-10-22 | ABBC-DELISTED | Stock | 7.02 | 7.24 | 7.0 | 7.24 | 39448.0 |
| 2009-10-22 | ABBNY-DELISTED | Stock | 21.12 | 21.7 | 20.99 | 21.62 | 4088289.0 |
| 2009-10-22 | ABC-DELISTED | Stock | 23.46 | 23.64 | 23.33 | 23.49 | 3189862.0 |
| 2009-10-22 | ABCB | Stock | 6.165 | 6.6452 | 6.165 | 6.6354 | 35914.0 |
| 2009-10-22 | ABCO-DELISTED | Stock | 12.683 | 12.992 | 12.463 | 12.937 | 51348.0 |
| 2009-10-22 | ABCW-DELISTED | Stock | 1.03 | 1.03 | 0.91 | 0.92 | 167130.0 |
| 2009-10-22 | ABD-DELISTED | Stock | 7.14 | 7.56 | 7.03 | 7.48 | 323060.0 |
| 2009-10-22 | ABE-DELISTED | Stock | 16.98 | 17.2 | 16.86 | 17.2 | 122050.0 |
| 2009-10-22 | ABEO | Stock | 4325.0 | 4337.5 | 4137.5 | 4250.0 | 26.0 |
| 2009-10-22 | ABFS-DELISTED | Stock | 28.71 | 28.71 | 27.36 | 28.04 | 583212.0 |
| 2009-10-22 | ABG | Stock | 14.44 | 14.86 | 14.04 | 14.58 | 171600.0 |
| 2009-10-22 | ABII-DELISTED | Stock | 35.96 | 36.25 | 34.93 | 35.48 | 35066.0 |
| 2009-10-22 | ABK-DELISTED | Stock | 1.23 | 1.26 | 1.18 | 1.26 | 7436822.0 |
| 2009-10-22 | ABM | Stock | 19.76 | 19.93 | 19.28 | 19.79 | 231100.0 |
| 2009-10-22 | ABMD-DELISTED | Stock | 10.36 | 10.63 | 10.12 | 10.57 | 162178.0 |
| 2009-10-22 | ABR | Stock | 2.45 | 2.58 | 2.32 | 2.54 | 163500.0 |
| 2009-10-22 | ABT | Stock | 24.5274 | 25.0983 | 24.3786 | 25.0312 | 15557107.0 |
| 2009-10-22 | ABTL-DELISTED | Stock | 3.2497 | 3.3005 | 3.0466 | 3.3 | 7114.0 |
| 2009-10-22 | ABV-DELISTED | Stock | 93.57 | 96.18 | 93.08 | 95.84 | 627403.0 |
| 2009-10-22 | ABVA-DELISTED | Stock | 2.72 | 2.73 | 2.425 | 2.73 | 5110.0 |
| 2009-10-22 | ABVT-DELISTED | Stock | 48.0 | 48.74 | 47.89 | 48.51 | 132360.0 |
| 2009-10-22 | ABX-DELISTED | Stock | 37.87 | 38.38 | 37.3 | 37.91 | 10720230.0 |
| 2009-10-22 | ACAD | Stock | 1.62 | 1.68 | 1.6 | 1.62 | 352300.0 |
| 2009-10-22 | ACAP-DELISTED | Stock | 29.87 | 30.66 | 29.87 | 30.65 | 32311.0 |
| 2009-10-22 | ACAS-DELISTED | Stock | 3.09 | 3.15 | 3.08 | 3.13 | 2437091.0 |
> showing 50 of 5,854 rows — these rows as CSV