PREVIEW / stock_daily / 2009-08-24
file: by_date/stock_daily/2009/2009-08-24.parquet size: 185 KB rows: 5,845 symbols: 3,481
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-24 | AAPL | Stock | 6.0757 | 6.0968 | 6.0096 | 6.0379 | 406929600.0 |
| 2009-08-24 | MSFT | Stock | 24.41 | 24.73 | 24.28 | 24.64 | 54180900.0 |
| 2009-08-24 | NVDA | Stock | 0.3462 | 0.35 | 0.3365 | 0.3385 | 461456000.0 |
| 2009-08-24 | AMZN | Stock | 4.2585 | 4.2795 | 4.212 | 4.225 | 94464000.0 |
| 2009-08-24 | TLT | Stock | 93.49 | 95.47 | 93.46 | 95.47 | 4460290.0 |
| 2009-08-24 | ES | Stock | 24.34 | 24.43 | 24.18 | 24.39 | 769800.0 |
| 2009-08-24 | CL | Stock | 36.645 | 36.74 | 36.175 | 36.41 | 3456600.0 |
| 2009-08-24 | A | Stock | 18.3405 | 18.412 | 18.1187 | 18.2403 | 3110270.0 |
| 2009-08-24 | AABA-DELISTED | Stock | 14.89 | 15.19 | 14.83 | 15.01 | 25868638.0 |
| 2009-08-24 | AACC-DELISTED | Stock | 8.2 | 8.4 | 8.2 | 8.37 | 75753.0 |
| 2009-08-24 | AACG | Stock | 6.71 | 6.95 | 6.6 | 6.76 | 36400.0 |
| 2009-08-24 | AAI-DELISTED | Stock | 6.65 | 7.0 | 6.63 | 6.69 | 2203816.0 |
| 2009-08-24 | AAIC-DELISTED | Stock | 9.6 | 10.4 | 8.804 | 9.402 | 2396393.0 |
| 2009-08-24 | AAON | Stock | 4.3101 | 4.3378 | 4.2588 | 4.2844 | 376650.0 |
| 2009-08-24 | AAP | Stock | 43.38 | 43.39 | 42.42 | 42.58 | 2031700.0 |
| 2009-08-24 | AATI-DELISTED | Stock | 4.8 | 4.89 | 4.67 | 4.7 | 87778.0 |
| 2009-08-24 | AAU-DELISTED | Stock | 0.66 | 0.69 | 0.65 | 0.66 | 55612.0 |
| 2009-08-24 | AAUAF-DELISTED | Stock | 0.66 | 0.69 | 0.65 | 0.66 | 56412.0 |
| 2009-08-24 | AAV-DELISTED | Stock | 5.64 | 5.78 | 5.54 | 5.67 | 1396482.0 |
| 2009-08-24 | AAWW-DELISTED | Stock | 24.55 | 24.72 | 23.9 | 23.96 | 247427.0 |
| 2009-08-24 | AAXJ | Stock | 49.66 | 49.84 | 49.33 | 49.62 | 150788.0 |
| 2009-08-24 | AAXN-DELISTED | Stock | 5.01 | 5.05 | 4.75 | 4.84 | 735761.0 |
| 2009-08-24 | AB | Stock | 21.3 | 21.55 | 20.55 | 20.66 | 491000.0 |
| 2009-08-24 | ABAX-DELISTED | Stock | 27.9 | 28.26 | 27.82 | 27.9 | 169145.0 |
| 2009-08-24 | ABB-DELISTED | Stock | 19.46 | 19.52 | 19.15 | 19.21 | 3529418.0 |
| 2009-08-24 | ABBC-DELISTED | Stock | 8.56 | 8.57 | 8.23 | 8.35 | 31654.0 |
| 2009-08-24 | ABBNY-DELISTED | Stock | 19.46 | 19.52 | 19.15 | 19.23 | 3529418.0 |
| 2009-08-24 | ABC-DELISTED | Stock | 21.16 | 21.18 | 20.71 | 20.8 | 3090630.0 |
| 2009-08-24 | ABCB | Stock | 6.5653 | 6.6626 | 6.3416 | 6.4292 | 37013.0 |
| 2009-08-24 | ABCO-DELISTED | Stock | 13.555 | 13.685 | 13.355 | 13.46 | 64372.0 |
| 2009-08-24 | ABCW-DELISTED | Stock | 1.5213 | 1.5213 | 1.43 | 1.43 | 70440.0 |
| 2009-08-24 | ABD-DELISTED | Stock | 5.64 | 5.65 | 5.24 | 5.51 | 411670.0 |
| 2009-08-24 | ABE-DELISTED | Stock | 16.15 | 16.8597 | 16.15 | 16.6489 | 57527.0 |
| 2009-08-24 | ABEO | Stock | 4812.5 | 5000.0 | 4562.5 | 4687.5 | 22.0 |
| 2009-08-24 | ABFS-DELISTED | Stock | 30.98 | 31.18 | 30.59 | 31.08 | 368195.0 |
| 2009-08-24 | ABG | Stock | 13.35 | 13.38 | 12.95 | 13.05 | 264400.0 |
| 2009-08-24 | ABII-DELISTED | Stock | 28.36 | 28.99 | 27.42 | 27.92 | 73787.0 |
| 2009-08-24 | ABK-DELISTED | Stock | 1.19 | 1.36 | 1.14 | 1.21 | 45005127.0 |
| 2009-08-24 | ABM | Stock | 22.82 | 23.1 | 22.72 | 22.79 | 133100.0 |
| 2009-08-24 | ABMD-DELISTED | Stock | 8.14 | 8.73 | 8.0601 | 8.72 | 403793.0 |
| 2009-08-24 | ABR | Stock | 1.8 | 1.94 | 1.8 | 1.9 | 152000.0 |
| 2009-08-24 | ABT | Stock | 21.9413 | 22.1332 | 21.711 | 22.1092 | 19214256.0 |
| 2009-08-24 | ABTL-DELISTED | Stock | 3.05 | 3.2 | 2.9 | 2.95 | 13449.0 |
| 2009-08-24 | ABV-DELISTED | Stock | 77.94 | 78.37 | 75.83 | 76.42 | 519319.0 |
| 2009-08-24 | ABVA-DELISTED | Stock | 2.72 | 2.85 | 2.4899 | 2.4899 | 3793.0 |
| 2009-08-24 | ABVT-DELISTED | Stock | 93.59 | 94.6 | 93.41 | 94.25 | 49147.0 |
| 2009-08-24 | ABX-DELISTED | Stock | 34.93 | 35.25 | 34.28 | 34.41 | 6756529.0 |
| 2009-08-24 | ACAD | Stock | 5.75 | 6.4 | 5.65 | 6.23 | 3712200.0 |
| 2009-08-24 | ACAP-DELISTED | Stock | 31.89 | 32.2 | 31.721 | 32.02 | 33383.0 |
| 2009-08-24 | ACAS-DELISTED | Stock | 2.85 | 2.85 | 2.71 | 2.74 | 6646536.0 |
> showing 50 of 5,845 rows — these rows as CSV