PREVIEW / stock_daily / 2009-09-24
file: by_date/stock_daily/2009/2009-09-24.parquet size: 187 KB rows: 5,844 symbols: 3,483
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-09-24 | AAPL | Stock | 6.6857 | 6.7036 | 6.5275 | 6.565 | 550880400.0 |
| 2009-09-24 | MSFT | Stock | 25.92 | 26.11 | 25.66 | 25.94 | 56302900.0 |
| 2009-09-24 | NVDA | Stock | 0.3798 | 0.3798 | 0.3672 | 0.3685 | 552876000.0 |
| 2009-09-24 | AMZN | Stock | 4.6 | 4.6355 | 4.5385 | 4.6055 | 101502000.0 |
| 2009-09-24 | TLT | Stock | 96.5 | 97.09 | 96.17 | 96.75 | 4658339.0 |
| 2009-09-24 | ES | Stock | 23.84 | 23.89 | 23.65 | 23.79 | 1348800.0 |
| 2009-09-24 | CL | Stock | 38.21 | 38.625 | 38.045 | 38.19 | 4650600.0 |
| 2009-09-24 | A | Stock | 20.3004 | 20.3505 | 19.7282 | 19.907 | 4159190.0 |
| 2009-09-24 | AABA-DELISTED | Stock | 17.31 | 17.32 | 16.65 | 16.9 | 25940573.0 |
| 2009-09-24 | AACC-DELISTED | Stock | 7.65 | 7.65 | 7.5 | 7.5 | 40464.0 |
| 2009-09-24 | AACG | Stock | 6.51 | 6.51 | 6.3 | 6.3 | 6100.0 |
| 2009-09-24 | AAI-DELISTED | Stock | 6.5 | 6.57 | 6.3 | 6.35 | 2738187.0 |
| 2009-09-24 | AAIC-DELISTED | Stock | 10.6 | 11.4 | 10.0 | 10.0 | 792002.0 |
| 2009-09-24 | AAME | Stock | 1.05 | 1.09 | 1.0 | 1.0 | 16700.0 |
| 2009-09-24 | AAON | Stock | 4.0849 | 4.1165 | 4.0395 | 4.0593 | 251606.0 |
| 2009-09-24 | AAP | Stock | 38.77 | 39.63 | 38.44 | 38.98 | 3797200.0 |
| 2009-09-24 | AATI-DELISTED | Stock | 4.23 | 4.29 | 3.99 | 4.07 | 346526.0 |
| 2009-09-24 | AAU-DELISTED | Stock | 0.71 | 0.73 | 0.6587 | 0.662 | 167039.0 |
| 2009-09-24 | AAUAF-DELISTED | Stock | 0.71 | 0.73 | 0.6601 | 0.663 | 170775.0 |
| 2009-09-24 | AAV-DELISTED | Stock | 7.01 | 7.05 | 6.63 | 6.7 | 1361197.0 |
| 2009-09-24 | AAWW-DELISTED | Stock | 33.91 | 33.93 | 32.46 | 32.88 | 298629.0 |
| 2009-09-24 | AAXJ | Stock | 52.54 | 52.5589 | 51.28 | 51.82 | 148814.0 |
| 2009-09-24 | AAXN-DELISTED | Stock | 4.61 | 4.67 | 4.5 | 4.54 | 251650.0 |
| 2009-09-24 | AB | Stock | 26.52 | 26.75 | 25.16 | 25.91 | 433500.0 |
| 2009-09-24 | ABAX-DELISTED | Stock | 27.84 | 27.96 | 26.63 | 26.88 | 116824.0 |
| 2009-09-24 | ABB-DELISTED | Stock | 20.99 | 21.0094 | 20.3 | 20.48 | 2957595.0 |
| 2009-09-24 | ABBC-DELISTED | Stock | 7.8 | 7.85 | 7.66 | 7.73 | 87509.0 |
| 2009-09-24 | ABBNY-DELISTED | Stock | 20.99 | 21.0094 | 20.3 | 20.49 | 2961411.0 |
| 2009-09-24 | ABC-DELISTED | Stock | 21.63 | 21.74 | 21.35 | 21.52 | 2288907.0 |
| 2009-09-24 | ABCB | Stock | 7.0128 | 7.1489 | 6.682 | 6.9544 | 20974.0 |
| 2009-09-24 | ABCO-DELISTED | Stock | 13.255 | 13.33 | 12.995 | 13.065 | 61987.0 |
| 2009-09-24 | ABCW-DELISTED | Stock | 1.43 | 1.43 | 1.25 | 1.33 | 109630.0 |
| 2009-09-24 | ABD-DELISTED | Stock | 7.28 | 7.42 | 7.03 | 7.17 | 486270.0 |
| 2009-09-24 | ABE-DELISTED | Stock | 17.45 | 17.45 | 17.11 | 17.3 | 8875.0 |
| 2009-09-24 | ABEO | Stock | 4062.5 | 4125.0 | 4000.0 | 4100.0 | 10.0 |
| 2009-09-24 | ABFS-DELISTED | Stock | 31.3 | 31.984 | 30.14 | 31.04 | 731824.0 |
| 2009-09-24 | ABG | Stock | 13.17 | 13.24 | 12.44 | 12.54 | 310500.0 |
| 2009-09-24 | ABII-DELISTED | Stock | 30.56 | 31.53 | 30.56 | 31.1 | 55460.0 |
| 2009-09-24 | ABK-DELISTED | Stock | 1.82 | 1.92 | 1.69 | 1.75 | 29493491.0 |
| 2009-09-24 | ABM | Stock | 20.42 | 20.61 | 19.77 | 20.29 | 191500.0 |
| 2009-09-24 | ABMD-DELISTED | Stock | 9.58 | 9.6199 | 9.0 | 9.33 | 319592.0 |
| 2009-09-24 | ABR | Stock | 3.18 | 3.18 | 2.74 | 2.78 | 751800.0 |
| 2009-09-24 | ABT | Stock | 22.2099 | 22.5602 | 22.0756 | 22.5218 | 24673614.0 |
| 2009-09-24 | ABTL-DELISTED | Stock | 2.7431 | 3.0154 | 2.6395 | 3.0069 | 25454.0 |
| 2009-09-24 | ABV-DELISTED | Stock | 81.21 | 81.21 | 79.34 | 79.79 | 340028.0 |
| 2009-09-24 | ABVA-DELISTED | Stock | 2.6 | 2.6 | 2.59 | 2.6 | 15000.0 |
| 2009-09-24 | ABVT-DELISTED | Stock | 48.95 | 50.57 | 47.37 | 48.13 | 282639.0 |
| 2009-09-24 | ABX-DELISTED | Stock | 37.56 | 37.62 | 35.85 | 36.43 | 20966344.0 |
| 2009-09-24 | ACAD | Stock | 1.85 | 1.87 | 1.77 | 1.81 | 1377600.0 |
| 2009-09-24 | ACAP-DELISTED | Stock | 29.865 | 30.08 | 29.02 | 29.07 | 38308.0 |
> showing 50 of 5,844 rows — these rows as CSV