PREVIEW / stock_daily / 2009-12-28
file: by_date/stock_daily/2009/2009-12-28.parquet size: 188 KB rows: 5,907 symbols: 3,493
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-12-28 | AAPL | Stock | 7.5614 | 7.6411 | 7.4861 | 7.5575 | 644565600.0 |
| 2009-12-28 | MSFT | Stock | 31.0 | 31.18 | 30.89 | 31.17 | 25384000.0 |
| 2009-12-28 | NVDA | Stock | 0.4515 | 0.4555 | 0.4405 | 0.445 | 465760000.0 |
| 2009-12-28 | AMZN | Stock | 6.9875 | 7.099 | 6.9265 | 6.9655 | 175278000.0 |
| 2009-12-28 | TLT | Stock | 89.46 | 89.63 | 89.3 | 89.46 | 3170825.0 |
| 2009-12-28 | ES | Stock | 26.33 | 26.38 | 26.16 | 26.28 | 414300.0 |
| 2009-12-28 | CL | Stock | 41.72 | 41.72 | 41.26 | 41.475 | 5156400.0 |
| 2009-12-28 | A | Stock | 21.6953 | 21.774 | 21.6237 | 21.7454 | 2347661.0 |
| 2009-12-28 | AABA-DELISTED | Stock | 16.76 | 16.94 | 16.68 | 16.89 | 11444555.0 |
| 2009-12-28 | AACC-DELISTED | Stock | 6.27 | 6.65 | 6.26 | 6.5 | 20731.0 |
| 2009-12-28 | AACG | Stock | 4.52 | 4.6 | 4.4 | 4.5 | 7600.0 |
| 2009-12-28 | AAI-DELISTED | Stock | 5.37 | 5.39 | 5.16 | 5.2 | 3214414.0 |
| 2009-12-28 | AAIC-DELISTED | Stock | 15.89 | 15.9 | 15.33 | 15.6 | 11237.0 |
| 2009-12-28 | AAME | Stock | 1.28 | 1.36 | 1.26 | 1.26 | 26600.0 |
| 2009-12-28 | AAON | Stock | 3.921 | 3.921 | 3.8598 | 3.8874 | 130106.0 |
| 2009-12-28 | AAP | Stock | 41.54 | 41.66 | 41.02 | 41.22 | 1229400.0 |
| 2009-12-28 | AATI-DELISTED | Stock | 3.69 | 3.71 | 3.6 | 3.61 | 180071.0 |
| 2009-12-28 | AAU-DELISTED | Stock | 1.08 | 1.09 | 1.05 | 1.08 | 109352.0 |
| 2009-12-28 | AAUAF-DELISTED | Stock | 1.08 | 1.09 | 1.05 | 1.08 | 109769.0 |
| 2009-12-28 | AAV-DELISTED | Stock | 6.7 | 6.79 | 6.52 | 6.59 | 542844.0 |
| 2009-12-28 | AAWW-DELISTED | Stock | 38.06 | 38.18 | 37.57 | 37.86 | 155001.0 |
| 2009-12-28 | AAXJ | Stock | 55.8 | 55.8 | 55.21 | 55.45 | 172750.0 |
| 2009-12-28 | AAXN-DELISTED | Stock | 4.4 | 4.4 | 4.27 | 4.35 | 494321.0 |
| 2009-12-28 | AB | Stock | 27.1 | 27.15 | 26.68 | 26.85 | 234500.0 |
| 2009-12-28 | ABAX-DELISTED | Stock | 24.49 | 24.99 | 24.19 | 24.9 | 81771.0 |
| 2009-12-28 | ABB-DELISTED | Stock | 19.16 | 19.25 | 19.01 | 19.09 | 1800447.0 |
| 2009-12-28 | ABBC-DELISTED | Stock | 6.62 | 6.83 | 6.6 | 6.83 | 30490.0 |
| 2009-12-28 | ABBNY-DELISTED | Stock | 19.16 | 19.25 | 19.01 | 19.1 | 1801157.0 |
| 2009-12-28 | ABC-DELISTED | Stock | 26.39 | 26.53 | 26.27 | 26.42 | 1120900.0 |
| 2009-12-28 | ABCB | Stock | 6.6844 | 6.8707 | 6.508 | 6.8707 | 36832.0 |
| 2009-12-28 | ABCD-DELISTED | Stock | 4.14 | 4.33 | 3.67 | 3.93 | 176793.0 |
| 2009-12-28 | ABCO-DELISTED | Stock | 14.855 | 14.895 | 14.545 | 14.88 | 113378.0 |
| 2009-12-28 | ABCW-DELISTED | Stock | 0.62 | 0.69 | 0.62 | 0.64 | 82330.0 |
| 2009-12-28 | ABD-DELISTED | Stock | 7.66 | 7.72 | 7.42 | 7.59 | 125670.0 |
| 2009-12-28 | ABE-DELISTED | Stock | 16.47 | 16.69 | 16.47 | 16.59 | 9059.0 |
| 2009-12-28 | ABEO | Stock | 3875.0 | 4062.5 | 3750.0 | 4062.5 | 20.0 |
| 2009-12-28 | ABFS-DELISTED | Stock | 31.45 | 31.45 | 30.37 | 30.77 | 401107.0 |
| 2009-12-28 | ABG | Stock | 12.08 | 12.24 | 11.79 | 11.91 | 133800.0 |
| 2009-12-28 | ABII-DELISTED | Stock | 39.91 | 39.91 | 38.95 | 39.42 | 53868.0 |
| 2009-12-28 | ABK-DELISTED | Stock | 0.86 | 0.87 | 0.83 | 0.835 | 7204839.0 |
| 2009-12-28 | ABM | Stock | 21.14 | 21.41 | 21.1 | 21.37 | 84800.0 |
| 2009-12-28 | ABMD-DELISTED | Stock | 8.86 | 8.99 | 8.73 | 8.79 | 54601.0 |
| 2009-12-28 | ABR | Stock | 1.97 | 1.97 | 1.88 | 1.95 | 157000.0 |
| 2009-12-28 | ABT | Stock | 25.986 | 26.1731 | 25.938 | 26.1635 | 8517299.0 |
| 2009-12-28 | ABTL-DELISTED | Stock | 4.7946 | 5.2425 | 4.6366 | 4.9 | 20735.0 |
| 2009-12-28 | ABV-DELISTED | Stock | 99.19 | 99.19 | 98.32 | 98.98 | 428228.0 |
| 2009-12-28 | ABVA-DELISTED | Stock | 3.56 | 3.56 | 3.5 | 3.5 | 662.0 |
| 2009-12-28 | ABVT-DELISTED | Stock | 65.1 | 65.1 | 63.935 | 64.88 | 69612.0 |
| 2009-12-28 | ABX-DELISTED | Stock | 40.64 | 40.74 | 39.93 | 40.49 | 6187161.0 |
| 2009-12-28 | ACAD | Stock | 1.37 | 1.38 | 1.32 | 1.33 | 453900.0 |
> showing 50 of 5,907 rows — these rows as CSV