PREVIEW / stock_daily / 2009-12-15
file: by_date/stock_daily/2009/2009-12-15.parquet size: 188 KB rows: 5,896 symbols: 3,492
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-15 | AAPL | Stock | 6.9939 | 7.0539 | 6.9025 | 6.9346 | 419459600.0 |
| 2009-12-15 | MSFT | Stock | 29.89 | 30.21 | 29.88 | 30.02 | 49473200.0 |
| 2009-12-15 | NVDA | Stock | 0.389 | 0.3978 | 0.388 | 0.3913 | 446152000.0 |
| 2009-12-15 | AMZN | Stock | 6.538 | 6.623 | 6.4795 | 6.5115 | 148576000.0 |
| 2009-12-15 | TLT | Stock | 91.57 | 92.0 | 91.49 | 91.79 | 2993879.0 |
| 2009-12-15 | ES | Stock | 25.72 | 25.84 | 25.65 | 25.83 | 1162100.0 |
| 2009-12-15 | CL | Stock | 42.2 | 42.335 | 41.81 | 42.25 | 4503800.0 |
| 2009-12-15 | A | Stock | 21.3662 | 21.5165 | 21.2446 | 21.3877 | 2617056.0 |
| 2009-12-15 | AABA-DELISTED | Stock | 15.77 | 15.88 | 15.65 | 15.75 | 13012293.0 |
| 2009-12-15 | AACC-DELISTED | Stock | 6.37 | 6.39 | 6.0 | 6.0 | 28670.0 |
| 2009-12-15 | AACG | Stock | 5.14 | 5.14 | 5.02 | 5.02 | 1400.0 |
| 2009-12-15 | AAI-DELISTED | Stock | 5.31 | 5.35 | 5.11 | 5.19 | 3447471.0 |
| 2009-12-15 | AAIC-DELISTED | Stock | 14.42 | 14.88 | 14.42 | 14.75 | 24505.0 |
| 2009-12-15 | AAME | Stock | 1.21 | 1.24 | 1.2 | 1.24 | 5600.0 |
| 2009-12-15 | AAON | Stock | 3.7946 | 3.8084 | 3.757 | 3.759 | 277931.0 |
| 2009-12-15 | AAP | Stock | 40.98 | 41.13 | 40.53 | 40.59 | 957400.0 |
| 2009-12-15 | AATI-DELISTED | Stock | 3.78 | 3.85 | 3.62 | 3.63 | 341240.0 |
| 2009-12-15 | AAU-DELISTED | Stock | 1.08 | 1.08 | 1.04 | 1.07 | 197710.0 |
| 2009-12-15 | AAUAF-DELISTED | Stock | 1.08 | 1.08 | 1.04 | 1.07 | 233010.0 |
| 2009-12-15 | AAV-DELISTED | Stock | 6.14 | 6.17 | 6.06 | 6.13 | 501521.0 |
| 2009-12-15 | AAWW-DELISTED | Stock | 35.37 | 35.63 | 35.27 | 35.51 | 451449.0 |
| 2009-12-15 | AAXJ | Stock | 55.46 | 55.61 | 55.1 | 55.1 | 435292.0 |
| 2009-12-15 | AAXN-DELISTED | Stock | 4.39 | 4.47 | 4.34 | 4.45 | 460857.0 |
| 2009-12-15 | AB | Stock | 25.81 | 26.56 | 25.68 | 26.56 | 916900.0 |
| 2009-12-15 | ABAX-DELISTED | Stock | 23.25 | 23.62 | 22.99 | 23.38 | 110093.0 |
| 2009-12-15 | ABB-DELISTED | Stock | 18.17 | 18.27 | 18.03 | 18.11 | 2718396.0 |
| 2009-12-15 | ABBC-DELISTED | Stock | 6.78 | 6.79 | 6.55 | 6.65 | 56015.0 |
| 2009-12-15 | ABBNY-DELISTED | Stock | 18.17 | 18.27 | 18.03 | 18.07 | 2738896.0 |
| 2009-12-15 | ABC-DELISTED | Stock | 25.2 | 25.925 | 25.0 | 25.8 | 5804529.0 |
| 2009-12-15 | ABCB | Stock | 6.6158 | 6.8609 | 6.606 | 6.6648 | 68767.0 |
| 2009-12-15 | ABCD-DELISTED | Stock | 3.78 | 4.51 | 3.74 | 4.51 | 500.0 |
| 2009-12-15 | ABCO-DELISTED | Stock | 13.223 | 13.957 | 13.188 | 13.747 | 120936.0 |
| 2009-12-15 | ABCW-DELISTED | Stock | 0.68 | 0.68 | 0.6 | 0.64 | 111700.0 |
| 2009-12-15 | ABD-DELISTED | Stock | 7.21 | 7.48 | 7.11 | 7.23 | 316040.0 |
| 2009-12-15 | ABE-DELISTED | Stock | 16.7 | 16.82 | 16.63 | 16.79 | 8993.0 |
| 2009-12-15 | ABEO | Stock | 3462.5 | 3800.0 | 3462.5 | 3762.5 | 36.0 |
| 2009-12-15 | ABFS-DELISTED | Stock | 28.24 | 28.69 | 27.99 | 28.17 | 190482.0 |
| 2009-12-15 | ABG | Stock | 11.64 | 11.75 | 11.08 | 11.26 | 389400.0 |
| 2009-12-15 | ABII-DELISTED | Stock | 39.35 | 39.35 | 37.34 | 38.56 | 38798.0 |
| 2009-12-15 | ABK-DELISTED | Stock | 0.83 | 0.86 | 0.81 | 0.81 | 9242010.0 |
| 2009-12-15 | ABM | Stock | 20.09 | 20.25 | 20.04 | 20.09 | 171000.0 |
| 2009-12-15 | ABMD-DELISTED | Stock | 8.43 | 8.54 | 8.2 | 8.29 | 118258.0 |
| 2009-12-15 | ABR | Stock | 1.8 | 1.8 | 1.72 | 1.76 | 79900.0 |
| 2009-12-15 | ABT | Stock | 25.8036 | 26.0148 | 25.6789 | 25.9044 | 9195081.0 |
| 2009-12-15 | ABTL-DELISTED | Stock | 5.5 | 5.75 | 5.25 | 5.25 | 4787.0 |
| 2009-12-15 | ABV-DELISTED | Stock | 97.71 | 98.64 | 97.48 | 97.73 | 371496.0 |
| 2009-12-15 | ABVA-DELISTED | Stock | 2.36 | 2.36 | 2.3 | 2.3 | 2400.0 |
| 2009-12-15 | ABVT-DELISTED | Stock | 61.5 | 62.75 | 59.9 | 60.03 | 162700.0 |
| 2009-12-15 | ABX-DELISTED | Stock | 39.83 | 40.28 | 39.08 | 39.11 | 14374011.0 |
| 2009-12-15 | ACAD | Stock | 1.18 | 1.38 | 1.17 | 1.34 | 3580000.0 |
> showing 50 of 5,896 rows — these rows as CSV