PREVIEW / stock_daily / 2009-10-15
file: by_date/stock_daily/2009/2009-10-15.parquet size: 187 KB rows: 5,849 symbols: 3,466
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-15 | AAPL | Stock | 6.7725 | 6.8186 | 6.7689 | 6.8057 | 373556400.0 |
| 2009-10-15 | MSFT | Stock | 25.9 | 26.71 | 25.9 | 26.71 | 65620100.0 |
| 2009-10-15 | NVDA | Stock | 0.348 | 0.3513 | 0.336 | 0.3382 | 1092196000.0 |
| 2009-10-15 | AMZN | Stock | 4.7565 | 4.853 | 4.754 | 4.8005 | 124842000.0 |
| 2009-10-15 | TLT | Stock | 94.57 | 95.42 | 94.37 | 94.68 | 3737309.0 |
| 2009-10-15 | ES | Stock | 23.42 | 23.67 | 23.23 | 23.65 | 1093700.0 |
| 2009-10-15 | CL | Stock | 39.265 | 39.46 | 39.105 | 39.385 | 5157200.0 |
| 2009-10-15 | A | Stock | 19.6638 | 19.7926 | 19.5994 | 19.7568 | 3953125.0 |
| 2009-10-15 | AABA-DELISTED | Stock | 16.84 | 16.89 | 16.46 | 16.55 | 24017889.0 |
| 2009-10-15 | AACC-DELISTED | Stock | 7.05 | 7.22 | 7.0 | 7.1 | 18925.0 |
| 2009-10-15 | AACG | Stock | 5.92 | 5.96 | 5.9 | 5.94 | 12900.0 |
| 2009-10-15 | AAI-DELISTED | Stock | 5.17 | 5.29 | 5.14 | 5.21 | 7160350.0 |
| 2009-10-15 | AAIC-DELISTED | Stock | 12.28 | 13.69 | 12.1 | 13.5 | 267145.0 |
| 2009-10-15 | AAME | Stock | 1.72 | 1.72 | 1.12 | 1.4 | 185400.0 |
| 2009-10-15 | AAON | Stock | 3.6741 | 3.7333 | 3.6563 | 3.7136 | 262237.0 |
| 2009-10-15 | AAP | Stock | 39.0 | 39.48 | 38.87 | 39.37 | 1151500.0 |
| 2009-10-15 | AATI-DELISTED | Stock | 3.45 | 3.59 | 3.3275 | 3.4 | 410498.0 |
| 2009-10-15 | AAU-DELISTED | Stock | 0.8 | 0.8 | 0.7611 | 0.78 | 73916.0 |
| 2009-10-15 | AAUAF-DELISTED | Stock | 0.8 | 0.8 | 0.7611 | 0.78 | 74216.0 |
| 2009-10-15 | AAV-DELISTED | Stock | 7.27 | 7.74 | 7.24 | 7.7301 | 1778947.0 |
| 2009-10-15 | AAWW-DELISTED | Stock | 36.55 | 37.23 | 35.47 | 36.91 | 272464.0 |
| 2009-10-15 | AAXJ | Stock | 54.55 | 54.89 | 54.268 | 54.89 | 522565.0 |
| 2009-10-15 | AAXN-DELISTED | Stock | 4.62 | 4.68 | 4.6 | 4.66 | 252161.0 |
| 2009-10-15 | AB | Stock | 28.41 | 28.86 | 28.2 | 28.38 | 355100.0 |
| 2009-10-15 | ABAX-DELISTED | Stock | 24.67 | 24.76 | 24.2 | 24.59 | 146209.0 |
| 2009-10-15 | ABB-DELISTED | Stock | 21.92 | 22.01 | 21.73 | 21.92 | 2551523.0 |
| 2009-10-15 | ABBC-DELISTED | Stock | 7.73 | 7.77 | 7.58 | 7.6 | 44767.0 |
| 2009-10-15 | ABBNY-DELISTED | Stock | 21.92 | 22.01 | 21.73 | 21.9 | 2552473.0 |
| 2009-10-15 | ABC-DELISTED | Stock | 23.06 | 23.39 | 22.95 | 23.34 | 2911645.0 |
| 2009-10-15 | ABCB | Stock | 6.7727 | 6.8021 | 6.4689 | 6.5178 | 25405.0 |
| 2009-10-15 | ABCO-DELISTED | Stock | 13.183 | 13.328 | 12.932 | 13.037 | 62691.0 |
| 2009-10-15 | ABCW-DELISTED | Stock | 1.14 | 1.2003 | 1.07 | 1.17 | 146690.0 |
| 2009-10-15 | ABD-DELISTED | Stock | 7.46 | 7.48 | 7.25 | 7.28 | 388570.0 |
| 2009-10-15 | ABE-DELISTED | Stock | 17.93 | 17.98 | 17.55 | 17.98 | 5771.0 |
| 2009-10-15 | ABEO | Stock | 4250.0 | 4412.5 | 4225.0 | 4375.0 | 49.0 |
| 2009-10-15 | ABFS-DELISTED | Stock | 30.22 | 30.22 | 29.73 | 30.07 | 608785.0 |
| 2009-10-15 | ABG | Stock | 14.07 | 14.3 | 13.88 | 14.1 | 118200.0 |
| 2009-10-15 | ABII-DELISTED | Stock | 38.0 | 38.21 | 37.4 | 37.57 | 38477.0 |
| 2009-10-15 | ABK-DELISTED | Stock | 1.47 | 1.49 | 1.44 | 1.44 | 7701593.0 |
| 2009-10-15 | ABM | Stock | 20.17 | 20.56 | 20.11 | 20.48 | 140100.0 |
| 2009-10-15 | ABMD-DELISTED | Stock | 10.85 | 10.92 | 10.75 | 10.85 | 85547.0 |
| 2009-10-15 | ABR | Stock | 2.62 | 2.77 | 2.53 | 2.77 | 266800.0 |
| 2009-10-15 | ABT | Stock | 24.6713 | 25.0264 | 24.5658 | 24.9064 | 20991038.0 |
| 2009-10-15 | ABTL-DELISTED | Stock | 3.125 | 3.2 | 3.05 | 3.05 | 6506.0 |
| 2009-10-15 | ABV-DELISTED | Stock | 93.75 | 95.14 | 93.35 | 94.93 | 396714.0 |
| 2009-10-15 | ABVA-DELISTED | Stock | 2.4077 | 2.44 | 2.25 | 2.25 | 1500.0 |
| 2009-10-15 | ABVT-DELISTED | Stock | 49.99 | 51.0 | 49.73 | 50.76 | 71697.0 |
| 2009-10-15 | ABX-DELISTED | Stock | 39.37 | 39.76 | 38.74 | 38.9 | 13601966.0 |
| 2009-10-15 | ACAD | Stock | 1.85 | 1.87 | 1.81 | 1.82 | 503700.0 |
| 2009-10-15 | ACAP-DELISTED | Stock | 29.72 | 30.09 | 29.67 | 29.99 | 28200.0 |
> showing 50 of 5,849 rows — these rows as CSV