PREVIEW / stock_daily / 2009-08-25
file: by_date/stock_daily/2009/2009-08-25.parquet size: 184 KB rows: 5,802 symbols: 3,452
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-25 | AAPL | Stock | 6.0521 | 6.105 | 6.0404 | 6.05 | 324354800.0 |
| 2009-08-25 | MSFT | Stock | 24.6 | 24.82 | 24.46 | 24.64 | 43980300.0 |
| 2009-08-25 | NVDA | Stock | 0.3402 | 0.345 | 0.3345 | 0.3415 | 444088000.0 |
| 2009-08-25 | AMZN | Stock | 4.233 | 4.317 | 4.1975 | 4.2095 | 95820000.0 |
| 2009-08-25 | TLT | Stock | 95.37 | 96.09 | 94.91 | 96.01 | 3359651.0 |
| 2009-08-25 | ES | Stock | 24.31 | 24.53 | 24.24 | 24.37 | 839600.0 |
| 2009-08-25 | CL | Stock | 36.475 | 36.71 | 36.315 | 36.545 | 4257200.0 |
| 2009-08-25 | A | Stock | 18.2403 | 18.3834 | 18.0472 | 18.1259 | 4318702.0 |
| 2009-08-25 | AABA-DELISTED | Stock | 15.09 | 15.21 | 14.94 | 15.1 | 22814174.0 |
| 2009-08-25 | AACC-DELISTED | Stock | 8.4 | 8.45 | 7.805 | 8.41 | 31087.0 |
| 2009-08-25 | AACG | Stock | 6.82 | 6.94 | 6.6 | 6.93 | 3700.0 |
| 2009-08-25 | AAI-DELISTED | Stock | 6.76 | 7.0 | 6.76 | 6.9 | 1367773.0 |
| 2009-08-25 | AAIC-DELISTED | Stock | 9.6 | 9.6 | 9.0 | 9.0 | 378508.0 |
| 2009-08-25 | AAME | Stock | 0.89 | 0.89 | 0.89 | 0.89 | 200.0 |
| 2009-08-25 | AAON | Stock | 4.3279 | 4.3457 | 4.2825 | 4.3358 | 572569.0 |
| 2009-08-25 | AAP | Stock | 42.8 | 43.64 | 42.8 | 43.01 | 1995300.0 |
| 2009-08-25 | AATI-DELISTED | Stock | 4.74 | 4.78 | 4.55 | 4.58 | 136296.0 |
| 2009-08-25 | AAU-DELISTED | Stock | 0.67 | 0.67 | 0.64 | 0.66 | 43720.0 |
| 2009-08-25 | AAUAF-DELISTED | Stock | 0.67 | 0.67 | 0.64 | 0.66 | 45720.0 |
| 2009-08-25 | AAV-DELISTED | Stock | 5.72 | 5.78 | 5.6 | 5.7 | 1197656.0 |
| 2009-08-25 | AAWW-DELISTED | Stock | 24.0 | 24.63 | 23.61 | 23.99 | 460920.0 |
| 2009-08-25 | AAXJ | Stock | 49.8 | 49.92 | 49.35 | 49.6 | 99875.0 |
| 2009-08-25 | AAXN-DELISTED | Stock | 4.85 | 4.97 | 4.84 | 4.87 | 301168.0 |
| 2009-08-25 | AB | Stock | 20.71 | 21.29 | 20.71 | 21.21 | 663300.0 |
| 2009-08-25 | ABAX-DELISTED | Stock | 27.95 | 28.16 | 27.59 | 27.9 | 246119.0 |
| 2009-08-25 | ABB-DELISTED | Stock | 19.63 | 19.8399 | 19.49 | 19.6 | 3574339.0 |
| 2009-08-25 | ABBC-DELISTED | Stock | 8.41 | 8.5 | 8.25 | 8.33 | 29805.0 |
| 2009-08-25 | ABBNY-DELISTED | Stock | 19.63 | 19.8399 | 19.49 | 19.59 | 3604839.0 |
| 2009-08-25 | ABC-DELISTED | Stock | 20.85 | 21.05 | 20.8 | 20.92 | 1826754.0 |
| 2009-08-25 | ABCB | Stock | 6.4778 | 6.5653 | 6.4778 | 6.5653 | 19432.0 |
| 2009-08-25 | ABCO-DELISTED | Stock | 13.55 | 13.72 | 13.41 | 13.525 | 144362.0 |
| 2009-08-25 | ABCW-DELISTED | Stock | 1.5021 | 1.5021 | 1.36 | 1.36 | 49680.0 |
| 2009-08-25 | ABD-DELISTED | Stock | 5.53 | 6.0 | 5.52 | 5.88 | 448860.0 |
| 2009-08-25 | ABE-DELISTED | Stock | 16.56 | 16.6799 | 16.34 | 16.6 | 31586.0 |
| 2009-08-25 | ABEO | Stock | 4500.0 | 4687.5 | 4012.5 | 4237.5 | 43.0 |
| 2009-08-25 | ABFS-DELISTED | Stock | 31.25 | 32.15 | 31.15 | 31.84 | 483617.0 |
| 2009-08-25 | ABG | Stock | 13.17 | 13.41 | 12.86 | 13.28 | 484500.0 |
| 2009-08-25 | ABII-DELISTED | Stock | 27.81 | 28.23 | 27.52 | 27.91 | 57744.0 |
| 2009-08-25 | ABK-DELISTED | Stock | 1.3 | 1.38 | 1.25 | 1.3 | 28617228.0 |
| 2009-08-25 | ABM | Stock | 22.97 | 23.32 | 22.91 | 22.97 | 141300.0 |
| 2009-08-25 | ABMD-DELISTED | Stock | 8.73 | 8.98 | 8.58 | 8.82 | 174019.0 |
| 2009-08-25 | ABR | Stock | 1.9 | 2.07 | 1.88 | 2.02 | 364100.0 |
| 2009-08-25 | ABT | Stock | 22.0804 | 22.2195 | 22.0228 | 22.0324 | 14439767.0 |
| 2009-08-25 | ABTL-DELISTED | Stock | 2.9605 | 3.09 | 2.9605 | 3.0895 | 11689.0 |
| 2009-08-25 | ABV-DELISTED | Stock | 77.92 | 77.98 | 75.62 | 75.72 | 439086.0 |
| 2009-08-25 | ABVT-DELISTED | Stock | 96.45 | 96.45 | 94.0 | 94.25 | 68693.0 |
| 2009-08-25 | ABX-DELISTED | Stock | 34.96 | 35.09 | 34.16 | 34.51 | 6433487.0 |
| 2009-08-25 | ACAD | Stock | 6.29 | 6.29 | 5.95 | 6.04 | 1555000.0 |
| 2009-08-25 | ACAP-DELISTED | Stock | 32.18 | 32.42 | 31.49 | 31.86 | 49460.0 |
| 2009-08-25 | ACAS-DELISTED | Stock | 2.72 | 2.74 | 2.38 | 2.54 | 10456956.0 |
> showing 50 of 5,802 rows — these rows as CSV