PREVIEW / stock_daily / 2009-03-18
file: by_date/stock_daily/2009/2009-03-18.parquet size: 175 KB rows: 5,750 symbols: 3,444
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-03-18 | AAPL | Stock | 3.5682 | 3.6957 | 3.5614 | 3.6257 | 796037200.0 |
| 2009-03-18 | MSFT | Stock | 17.03 | 17.22 | 16.6 | 16.96 | 70710700.0 |
| 2009-03-18 | NVDA | Stock | 0.2435 | 0.2623 | 0.2432 | 0.255 | 1359560000.0 |
| 2009-03-18 | AMZN | Stock | 3.5485 | 3.6955 | 3.5065 | 3.5625 | 208034000.0 |
| 2009-03-18 | TLT | Stock | 101.12 | 108.07 | 100.9 | 104.37 | 8579974.0 |
| 2009-03-18 | ES | Stock | 20.49 | 21.34 | 20.23 | 21.31 | 4879000.0 |
| 2009-03-18 | CL | Stock | 29.335 | 29.36 | 28.695 | 28.87 | 7761400.0 |
| 2009-03-18 | A | Stock | 10.3362 | 10.6867 | 10.2217 | 10.3934 | 5001904.0 |
| 2009-03-18 | AABA-DELISTED | Stock | 13.82 | 13.95 | 13.23 | 13.45 | 26150589.0 |
| 2009-03-18 | AACC-DELISTED | Stock | 5.18 | 5.38 | 5.1 | 5.35 | 85990.0 |
| 2009-03-18 | AACG | Stock | 4.41 | 4.61 | 4.41 | 4.5 | 29900.0 |
| 2009-03-18 | AAI-DELISTED | Stock | 4.39 | 4.61 | 4.2219 | 4.54 | 3095768.0 |
| 2009-03-18 | AAIC-DELISTED | Stock | 3.4 | 3.6 | 3.0 | 3.6 | 538391.0 |
| 2009-03-18 | AAME | Stock | 0.46 | 0.46 | 0.46 | 0.46 | 200.0 |
| 2009-03-18 | AAON | Stock | 3.7096 | 3.7847 | 3.5378 | 3.7057 | 648506.0 |
| 2009-03-18 | AAP | Stock | 39.54 | 41.53 | 39.34 | 41.04 | 2790700.0 |
| 2009-03-18 | AATI-DELISTED | Stock | 3.4 | 3.62 | 3.4 | 3.55 | 261571.0 |
| 2009-03-18 | AAU-DELISTED | Stock | 0.62 | 0.69 | 0.61 | 0.69 | 170689.0 |
| 2009-03-18 | AAUAF-DELISTED | Stock | 0.62 | 0.69 | 0.61 | 0.69 | 170985.0 |
| 2009-03-18 | AAV-DELISTED | Stock | 2.94 | 2.98 | 2.73 | 2.96 | 973748.0 |
| 2009-03-18 | AAWW-DELISTED | Stock | 13.56 | 16.81 | 13.56 | 16.6 | 373158.0 |
| 2009-03-18 | AAXJ | Stock | 31.82 | 32.5699 | 31.11 | 32.25 | 86905.0 |
| 2009-03-18 | AAXN-DELISTED | Stock | 4.12 | 4.46 | 3.98 | 4.37 | 564870.0 |
| 2009-03-18 | AB | Stock | 13.4 | 14.92 | 13.3 | 14.22 | 836400.0 |
| 2009-03-18 | ABAX-DELISTED | Stock | 18.31 | 19.12 | 17.84 | 18.8 | 300444.0 |
| 2009-03-18 | ABB-DELISTED | Stock | 13.45 | 14.09 | 13.14 | 13.88 | 5374432.0 |
| 2009-03-18 | ABBC-DELISTED | Stock | 8.52 | 9.09 | 8.4608 | 9.0 | 112056.0 |
| 2009-03-18 | ABBNY-DELISTED | Stock | 13.45 | 14.09 | 13.14 | 13.88 | 5384232.0 |
| 2009-03-18 | ABC-DELISTED | Stock | 15.6 | 15.82 | 15.4 | 15.58 | 4429064.0 |
| 2009-03-18 | ABCB | Stock | 7.2073 | 7.285 | 6.5556 | 6.9544 | 47808.0 |
| 2009-03-18 | ABCO-DELISTED | Stock | 8.023 | 8.038 | 7.617 | 7.917 | 89320.0 |
| 2009-03-18 | ABCW-DELISTED | Stock | 0.8384 | 1.0101 | 0.8081 | 1.0 | 210940.0 |
| 2009-03-18 | ABD-DELISTED | Stock | 1.25 | 1.4576 | 1.24 | 1.38 | 215850.0 |
| 2009-03-18 | ABE-DELISTED | Stock | 11.79 | 12.4292 | 11.79 | 12.275 | 28261.0 |
| 2009-03-18 | ABEO | Stock | 1862.5 | 1937.5 | 1687.5 | 1937.5 | 12.0 |
| 2009-03-18 | ABFS-DELISTED | Stock | 20.37 | 20.88 | 19.77 | 20.72 | 534192.0 |
| 2009-03-18 | ABG | Stock | 3.79 | 3.79 | 3.38 | 3.65 | 487800.0 |
| 2009-03-18 | ABII-DELISTED | Stock | 50.41 | 51.5071 | 49.45 | 49.45 | 21045.0 |
| 2009-03-18 | ABK-DELISTED | Stock | 0.75 | 1.0 | 0.71 | 0.908 | 20751938.0 |
| 2009-03-18 | ABM | Stock | 16.01 | 16.32 | 15.72 | 16.15 | 624300.0 |
| 2009-03-18 | ABMD-DELISTED | Stock | 5.57 | 5.62 | 5.25 | 5.5 | 700814.0 |
| 2009-03-18 | ABR | Stock | 0.99 | 1.11 | 0.96 | 1.11 | 178300.0 |
| 2009-03-18 | ABT | Stock | 23.467 | 23.7789 | 23.1935 | 23.3327 | 17961025.0 |
| 2009-03-18 | ABTL-DELISTED | Stock | 1.15 | 1.5 | 1.15 | 1.35 | 22162.0 |
| 2009-03-18 | ABV-DELISTED | Stock | 44.27 | 46.17 | 43.62 | 45.92 | 1014361.0 |
| 2009-03-18 | ABVA-DELISTED | Stock | 1.65 | 1.65 | 1.65 | 1.65 | 800.0 |
| 2009-03-18 | ABVT-DELISTED | Stock | 44.0 | 44.0 | 44.0 | 44.0 | 527.0 |
| 2009-03-18 | ABX-DELISTED | Stock | 28.54 | 31.97 | 27.22 | 31.92 | 28593845.0 |
| 2009-03-18 | ACAD | Stock | 0.98 | 1.02 | 0.97 | 0.99 | 42900.0 |
| 2009-03-18 | ACAP-DELISTED | Stock | 43.51 | 45.64 | 43.17 | 44.24 | 72135.0 |
> showing 50 of 5,750 rows — these rows as CSV