PREVIEW / stock_daily / 2009-11-11
file: by_date/stock_daily/2009/2009-11-11.parquet size: 186 KB rows: 5,845 symbols: 3,477
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-11-11 | AAPL | Stock | 7.3057 | 7.3214 | 7.2082 | 7.2589 | 443870000.0 |
| 2009-11-11 | MSFT | Stock | 29.08 | 29.3 | 29.02 | 29.12 | 49693400.0 |
| 2009-11-11 | NVDA | Stock | 0.3338 | 0.3455 | 0.3333 | 0.3375 | 871512000.0 |
| 2009-11-11 | AMZN | Stock | 6.554 | 6.5655 | 6.4165 | 6.4955 | 148684000.0 |
| 2009-11-11 | TLT | Stock | 93.63 | 94.16 | 93.48 | 93.66 | 1771032.0 |
| 2009-11-11 | ES | Stock | 23.69 | 23.74 | 23.45 | 23.64 | 2022100.0 |
| 2009-11-11 | CL | Stock | 40.92 | 41.04 | 40.635 | 40.86 | 4315800.0 |
| 2009-11-11 | A | Stock | 19.5422 | 19.6423 | 19.3276 | 19.6423 | 4522250.0 |
| 2009-11-11 | AABA-DELISTED | Stock | 16.0 | 16.16 | 15.92 | 16.09 | 15980055.0 |
| 2009-11-11 | AACC-DELISTED | Stock | 5.3 | 5.48 | 5.15 | 5.25 | 18994.0 |
| 2009-11-11 | AACG | Stock | 4.25 | 4.73 | 4.18 | 4.25 | 41200.0 |
| 2009-11-11 | AAI-DELISTED | Stock | 4.59 | 4.71 | 4.55 | 4.68 | 2823506.0 |
| 2009-11-11 | AAIC-DELISTED | Stock | 13.85 | 14.22 | 13.37 | 13.77 | 90787.0 |
| 2009-11-11 | AAON | Stock | 3.9625 | 3.9802 | 3.9407 | 3.9644 | 207056.0 |
| 2009-11-11 | AAP | Stock | 39.43 | 40.34 | 39.16 | 40.28 | 3886100.0 |
| 2009-11-11 | AATI-DELISTED | Stock | 3.05 | 3.13 | 3.02 | 3.12 | 266266.0 |
| 2009-11-11 | AAU-DELISTED | Stock | 0.69 | 0.71 | 0.67 | 0.68 | 228050.0 |
| 2009-11-11 | AAUAF-DELISTED | Stock | 0.69 | 0.71 | 0.67 | 0.68 | 228250.0 |
| 2009-11-11 | AAV-DELISTED | Stock | 6.7 | 6.7 | 6.31 | 6.38 | 947037.0 |
| 2009-11-11 | AAWW-DELISTED | Stock | 28.44 | 29.15 | 28.04 | 29.0 | 706684.0 |
| 2009-11-11 | AAXJ | Stock | 55.0 | 55.56 | 55.0 | 55.39 | 149252.0 |
| 2009-11-11 | AAXN-DELISTED | Stock | 4.31 | 4.4 | 4.25 | 4.28 | 361811.0 |
| 2009-11-11 | AB | Stock | 26.98 | 27.44 | 26.85 | 26.9 | 525000.0 |
| 2009-11-11 | ABAX-DELISTED | Stock | 22.74 | 23.06 | 22.57 | 22.95 | 94159.0 |
| 2009-11-11 | ABB-DELISTED | Stock | 20.16 | 20.3275 | 19.89 | 20.0 | 3727403.0 |
| 2009-11-11 | ABBC-DELISTED | Stock | 6.61 | 6.61 | 6.28 | 6.58 | 93826.0 |
| 2009-11-11 | ABBNY-DELISTED | Stock | 20.16 | 20.3275 | 19.89 | 19.99 | 3904054.0 |
| 2009-11-11 | ABC-DELISTED | Stock | 24.34 | 24.46 | 24.05 | 24.27 | 1684003.0 |
| 2009-11-11 | ABCB | Stock | 6.3218 | 6.361 | 6.1552 | 6.2434 | 19385.0 |
| 2009-11-11 | ABCO-DELISTED | Stock | 13.298 | 13.403 | 13.062 | 13.177 | 32625.0 |
| 2009-11-11 | ABCW-DELISTED | Stock | 0.49 | 0.49 | 0.4 | 0.42 | 370540.0 |
| 2009-11-11 | ABD-DELISTED | Stock | 7.04 | 7.2 | 6.8 | 6.94 | 211050.0 |
| 2009-11-11 | ABE-DELISTED | Stock | 16.7 | 16.8244 | 16.7 | 16.75 | 4742.0 |
| 2009-11-11 | ABEO | Stock | 3687.5 | 3937.5 | 3562.5 | 3937.5 | 31.0 |
| 2009-11-11 | ABFS-DELISTED | Stock | 24.7 | 26.35 | 24.5 | 26.19 | 967631.0 |
| 2009-11-11 | ABG | Stock | 10.32 | 10.79 | 10.25 | 10.53 | 306500.0 |
| 2009-11-11 | ABII-DELISTED | Stock | 35.16 | 35.39 | 34.08 | 34.41 | 62375.0 |
| 2009-11-11 | ABK-DELISTED | Stock | 0.82 | 0.84 | 0.64 | 0.79 | 56735738.0 |
| 2009-11-11 | ABM | Stock | 19.6 | 19.62 | 19.23 | 19.44 | 98600.0 |
| 2009-11-11 | ABMD-DELISTED | Stock | 9.43 | 9.54 | 9.22 | 9.32 | 257958.0 |
| 2009-11-11 | ABR | Stock | 2.07 | 2.07 | 1.95 | 1.97 | 79100.0 |
| 2009-11-11 | ABT | Stock | 25.6309 | 25.6933 | 25.4342 | 25.5541 | 12811171.0 |
| 2009-11-11 | ABTL-DELISTED | Stock | 4.0 | 4.15 | 3.75 | 4.15 | 4922.0 |
| 2009-11-11 | ABV-DELISTED | Stock | 102.09 | 103.59 | 101.5606 | 101.65 | 868477.0 |
| 2009-11-11 | ABVA-DELISTED | Stock | 2.2 | 2.21 | 2.17 | 2.17 | 1400.0 |
| 2009-11-11 | ABVT-DELISTED | Stock | 53.75 | 54.09 | 52.94 | 53.08 | 83429.0 |
| 2009-11-11 | ABX-DELISTED | Stock | 43.96 | 44.05 | 42.91 | 43.03 | 11728408.0 |
| 2009-11-11 | ACAD | Stock | 1.56 | 1.57 | 1.42 | 1.51 | 649900.0 |
| 2009-11-11 | ACAP-DELISTED | Stock | 29.53 | 29.99 | 29.3715 | 29.54 | 21093.0 |
| 2009-11-11 | ACAS-DELISTED | Stock | 2.945 | 2.98 | 2.89 | 2.92 | 3843769.0 |
> showing 50 of 5,845 rows — these rows as CSV