PREVIEW / stock_daily / 2009-08-12
file: by_date/stock_daily/2009/2009-08-12.parquet size: 184 KB rows: 5,821 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 |
|---|---|---|---|---|---|---|---|
| 2009-08-12 | AAPL | Stock | 5.8054 | 5.9539 | 5.8021 | 5.9039 | 445071200.0 |
| 2009-08-12 | MSFT | Stock | 23.13 | 23.9 | 23.03 | 23.53 | 61972300.0 |
| 2009-08-12 | NVDA | Stock | 0.324 | 0.3393 | 0.3238 | 0.3358 | 634940000.0 |
| 2009-08-12 | AMZN | Stock | 4.171 | 4.33 | 4.169 | 4.298 | 112388000.0 |
| 2009-08-12 | TLT | Stock | 92.95 | 93.07 | 91.09 | 91.69 | 4729247.0 |
| 2009-08-12 | ES | Stock | 23.28 | 23.73 | 23.14 | 23.58 | 754000.0 |
| 2009-08-12 | CL | Stock | 35.805 | 36.21 | 35.585 | 35.91 | 5017400.0 |
| 2009-08-12 | A | Stock | 17.1388 | 17.6824 | 17.103 | 17.4392 | 4757254.0 |
| 2009-08-12 | AABA-DELISTED | Stock | 14.47 | 14.76 | 14.41 | 14.68 | 24203443.0 |
| 2009-08-12 | AACC-DELISTED | Stock | 7.32 | 7.99 | 7.32 | 7.68 | 44735.0 |
| 2009-08-12 | AACG | Stock | 7.9 | 8.16 | 7.57 | 7.79 | 21000.0 |
| 2009-08-12 | AAI-DELISTED | Stock | 6.7 | 6.97 | 6.64 | 6.85 | 1576611.0 |
| 2009-08-12 | AAIC-DELISTED | Stock | 8.2 | 9.2 | 8.0 | 9.2 | 861611.0 |
| 2009-08-12 | AAME | Stock | 0.75 | 0.75 | 0.75 | 0.75 | 2800.0 |
| 2009-08-12 | AAON | Stock | 4.2272 | 4.3872 | 4.1086 | 4.3398 | 2423419.0 |
| 2009-08-12 | AAP | Stock | 45.27 | 46.17 | 44.86 | 45.63 | 1597400.0 |
| 2009-08-12 | AATI-DELISTED | Stock | 4.35 | 4.62 | 4.2825 | 4.53 | 249138.0 |
| 2009-08-12 | AAU-DELISTED | Stock | 0.62 | 0.6399 | 0.62 | 0.62 | 29099.0 |
| 2009-08-12 | AAUAF-DELISTED | Stock | 0.62 | 0.6399 | 0.62 | 0.62 | 29099.0 |
| 2009-08-12 | AAV-DELISTED | Stock | 4.94 | 5.18 | 4.89 | 5.15 | 470413.0 |
| 2009-08-12 | AAWW-DELISTED | Stock | 27.88 | 28.435 | 27.57 | 27.99 | 367851.0 |
| 2009-08-12 | AAXJ | Stock | 49.2 | 50.01 | 48.5 | 49.51 | 169897.0 |
| 2009-08-12 | AAXN-DELISTED | Stock | 5.14 | 5.16 | 5.05 | 5.07 | 389021.0 |
| 2009-08-12 | AB | Stock | 20.68 | 21.41 | 20.59 | 21.14 | 596700.0 |
| 2009-08-12 | ABAX-DELISTED | Stock | 28.25 | 29.18 | 27.85 | 28.82 | 218239.0 |
| 2009-08-12 | ABB-DELISTED | Stock | 18.04 | 18.42 | 18.04 | 18.25 | 2111135.0 |
| 2009-08-12 | ABBC-DELISTED | Stock | 8.31 | 8.55 | 8.13 | 8.5 | 63672.0 |
| 2009-08-12 | ABBNY-DELISTED | Stock | 18.04 | 18.42 | 18.04 | 18.24 | 2111435.0 |
| 2009-08-12 | ABC-DELISTED | Stock | 20.25 | 20.58 | 20.09 | 20.42 | 3145209.0 |
| 2009-08-12 | ABCB | Stock | 6.3903 | 6.5264 | 6.3221 | 6.4195 | 24057.0 |
| 2009-08-12 | ABCO-DELISTED | Stock | 13.44 | 13.85 | 13.33 | 13.655 | 187068.0 |
| 2009-08-12 | ABCW-DELISTED | Stock | 1.58 | 1.64 | 1.53 | 1.59 | 92400.0 |
| 2009-08-12 | ABD-DELISTED | Stock | 4.72 | 4.83 | 4.66 | 4.68 | 351970.0 |
| 2009-08-12 | ABE-DELISTED | Stock | 16.4404 | 16.66 | 16.4404 | 16.5825 | 11573.0 |
| 2009-08-12 | ABEO | Stock | 5625.0 | 5625.0 | 5025.0 | 5187.5 | 31.0 |
| 2009-08-12 | ABFS-DELISTED | Stock | 29.15 | 30.302 | 28.8 | 30.07 | 488979.0 |
| 2009-08-12 | ABG | Stock | 13.19 | 13.84 | 13.18 | 13.62 | 282800.0 |
| 2009-08-12 | ABII-DELISTED | Stock | 29.59 | 30.25 | 29.51 | 29.8625 | 27614.0 |
| 2009-08-12 | ABK-DELISTED | Stock | 1.1 | 1.12 | 1.05 | 1.06 | 9109612.0 |
| 2009-08-12 | ABM | Stock | 21.66 | 22.2 | 21.64 | 21.97 | 161400.0 |
| 2009-08-12 | ABMD-DELISTED | Stock | 7.28 | 7.85 | 7.28 | 7.67 | 271993.0 |
| 2009-08-12 | ABR | Stock | 2.2 | 2.2 | 2.11 | 2.11 | 177900.0 |
| 2009-08-12 | ABT | Stock | 21.3175 | 21.3751 | 20.9912 | 21.116 | 25867653.0 |
| 2009-08-12 | ABTL-DELISTED | Stock | 2.45 | 2.5 | 2.35 | 2.45 | 22873.0 |
| 2009-08-12 | ABV-DELISTED | Stock | 72.52 | 74.41 | 72.44 | 73.98 | 362498.0 |
| 2009-08-12 | ABVA-DELISTED | Stock | 2.535 | 2.535 | 2.535 | 2.535 | 400.0 |
| 2009-08-12 | ABVT-DELISTED | Stock | 90.44 | 92.33 | 84.71 | 92.15 | 182563.0 |
| 2009-08-12 | ABX-DELISTED | Stock | 33.5 | 34.07 | 33.34 | 33.58 | 6938218.0 |
| 2009-08-12 | ACAD | Stock | 5.48 | 5.58 | 5.21 | 5.29 | 1146600.0 |
| 2009-08-12 | ACAP-DELISTED | Stock | 32.91 | 33.1 | 32.65 | 32.78 | 52025.0 |
> showing 50 of 5,821 rows — these rows as CSV