PREVIEW / stock_daily / 2009-05-20
file: by_date/stock_daily/2009/2009-05-20.parquet size: 181 KB rows: 5,803 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-05-20 | AAPL | Stock | 4.5582 | 4.6146 | 4.475 | 4.4954 | 388584000.0 |
| 2009-05-20 | MSFT | Stock | 20.41 | 20.69 | 20.22 | 20.38 | 47450700.0 |
| 2009-05-20 | NVDA | Stock | 0.2405 | 0.2563 | 0.2395 | 0.2432 | 1309436000.0 |
| 2009-05-20 | AMZN | Stock | 3.925 | 4.0555 | 3.871 | 3.8985 | 147020000.0 |
| 2009-05-20 | TLT | Stock | 95.93 | 97.16 | 95.83 | 97.02 | 2825795.0 |
| 2009-05-20 | ES | Stock | 20.84 | 20.96 | 19.93 | 19.99 | 3341800.0 |
| 2009-05-20 | CL | Stock | 31.88 | 32.195 | 31.63 | 31.95 | 9370800.0 |
| 2009-05-20 | A | Stock | 13.269 | 13.5908 | 13.176 | 13.3333 | 3662341.0 |
| 2009-05-20 | AABA-DELISTED | Stock | 15.11 | 15.3125 | 14.8 | 14.97 | 15641689.0 |
| 2009-05-20 | AACC-DELISTED | Stock | 7.81 | 8.26 | 7.32 | 7.33 | 76132.0 |
| 2009-05-20 | AACG | Stock | 4.96 | 5.18 | 4.95 | 5.0 | 58000.0 |
| 2009-05-20 | AAI-DELISTED | Stock | 6.51 | 6.66 | 6.09 | 6.14 | 2740234.0 |
| 2009-05-20 | AAIC-DELISTED | Stock | 9.2 | 9.6 | 8.8 | 9.0 | 849036.0 |
| 2009-05-20 | AAME | Stock | 0.85 | 0.85 | 0.71 | 0.75 | 6300.0 |
| 2009-05-20 | AAON | Stock | 4.1284 | 4.1877 | 4.0395 | 4.1304 | 881887.0 |
| 2009-05-20 | AAP | Stock | 43.96 | 44.03 | 42.47 | 42.89 | 2950600.0 |
| 2009-05-20 | AATI-DELISTED | Stock | 4.74 | 4.75 | 4.46 | 4.48 | 256440.0 |
| 2009-05-20 | AAU-DELISTED | Stock | 0.6 | 0.66 | 0.5901 | 0.64 | 138913.0 |
| 2009-05-20 | AAUAF-DELISTED | Stock | 0.6 | 0.66 | 0.5901 | 0.64 | 136513.0 |
| 2009-05-20 | AAV-DELISTED | Stock | 3.8 | 4.42 | 3.8 | 4.05 | 1941085.0 |
| 2009-05-20 | AAWW-DELISTED | Stock | 25.13 | 25.71 | 23.33 | 23.47 | 688926.0 |
| 2009-05-20 | AAXJ | Stock | 43.25 | 44.0728 | 43.054 | 43.31 | 202951.0 |
| 2009-05-20 | AAXN-DELISTED | Stock | 4.33 | 4.42 | 4.2 | 4.21 | 377107.0 |
| 2009-05-20 | AB | Stock | 17.94 | 18.22 | 17.53 | 17.92 | 819900.0 |
| 2009-05-20 | ABAX-DELISTED | Stock | 17.03 | 17.29 | 16.7001 | 17.01 | 384712.0 |
| 2009-05-20 | ABB-DELISTED | Stock | 16.07 | 16.4025 | 16.02 | 16.04 | 4301361.0 |
| 2009-05-20 | ABBC-DELISTED | Stock | 8.55 | 8.57 | 7.99 | 8.06 | 63151.0 |
| 2009-05-20 | ABBNY-DELISTED | Stock | 16.07 | 16.4025 | 16.02 | 16.05 | 4301742.0 |
| 2009-05-20 | ABC-DELISTED | Stock | 18.1 | 18.64 | 18.0 | 18.48 | 5761264.0 |
| 2009-05-20 | ABCB | Stock | 6.4 | 6.5556 | 5.9428 | 6.361 | 42462.0 |
| 2009-05-20 | ABCO-DELISTED | Stock | 11.465 | 11.705 | 11.28 | 11.58 | 253592.0 |
| 2009-05-20 | ABCW-DELISTED | Stock | 1.67 | 1.68 | 1.64 | 1.66 | 76880.0 |
| 2009-05-20 | ABD-DELISTED | Stock | 3.06 | 3.5 | 2.9 | 2.94 | 293890.0 |
| 2009-05-20 | ABE-DELISTED | Stock | 15.0 | 15.29 | 14.87 | 14.9 | 11475.0 |
| 2009-05-20 | ABEO | Stock | 1875.0 | 2125.0 | 1750.0 | 1750.0 | 16.0 |
| 2009-05-20 | ABFS-DELISTED | Stock | 27.81 | 29.0 | 27.4675 | 27.7 | 1343402.0 |
| 2009-05-20 | ABG | Stock | 10.26 | 11.06 | 9.98 | 10.06 | 486200.0 |
| 2009-05-20 | ABII-DELISTED | Stock | 50.39 | 52.755 | 48.06 | 48.92 | 13282.0 |
| 2009-05-20 | ABK-DELISTED | Stock | 1.44 | 1.46 | 1.34 | 1.34 | 10207662.0 |
| 2009-05-20 | ABM | Stock | 16.16 | 16.46 | 15.92 | 16.01 | 278000.0 |
| 2009-05-20 | ABMD-DELISTED | Stock | 6.0 | 6.08 | 5.5701 | 5.65 | 547661.0 |
| 2009-05-20 | ABR | Stock | 1.98 | 2.37 | 1.92 | 1.96 | 602800.0 |
| 2009-05-20 | ABT | Stock | 20.7418 | 21.02 | 20.6314 | 20.6698 | 20836599.0 |
| 2009-05-20 | ABTL-DELISTED | Stock | 2.7 | 2.7 | 2.25 | 2.35 | 2984.0 |
| 2009-05-20 | ABV-DELISTED | Stock | 63.0 | 63.66 | 62.07 | 62.21 | 460363.0 |
| 2009-05-20 | ABVA-DELISTED | Stock | 3.48 | 3.49 | 2.97 | 3.3 | 3362.0 |
| 2009-05-20 | ABVT-DELISTED | Stock | 58.03 | 59.0 | 57.0 | 58.43 | 58052.0 |
| 2009-05-20 | ABX-DELISTED | Stock | 34.67 | 36.48 | 34.56 | 36.29 | 14567656.0 |
| 2009-05-20 | ACAD | Stock | 1.8 | 1.89 | 1.78 | 1.87 | 428800.0 |
| 2009-05-20 | ACAP-DELISTED | Stock | 38.14 | 38.28 | 36.36 | 36.54 | 79964.0 |
> showing 50 of 5,803 rows — these rows as CSV