PREVIEW / stock_daily / 2009-05-12
file: by_date/stock_daily/2009/2009-05-12.parquet size: 179 KB rows: 5,771 symbols: 3,455
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-12 | AAPL | Stock | 4.6271 | 4.6325 | 4.4018 | 4.4436 | 609481600.0 |
| 2009-05-12 | MSFT | Stock | 19.51 | 20.06 | 19.47 | 19.89 | 71966800.0 |
| 2009-05-12 | NVDA | Stock | 0.241 | 0.241 | 0.22 | 0.2245 | 1201384000.0 |
| 2009-05-12 | AMZN | Stock | 3.935 | 3.9485 | 3.8265 | 3.8965 | 110974000.0 |
| 2009-05-12 | TLT | Stock | 96.18 | 97.02 | 95.8023 | 96.64 | 2304726.0 |
| 2009-05-12 | ES | Stock | 21.2 | 21.46 | 21.1 | 21.38 | 1645300.0 |
| 2009-05-12 | CL | Stock | 31.17 | 31.795 | 31.0 | 31.73 | 9083000.0 |
| 2009-05-12 | A | Stock | 13.4907 | 13.7124 | 13.3619 | 13.5837 | 3025412.0 |
| 2009-05-12 | AABA-DELISTED | Stock | 15.5 | 15.5 | 14.9 | 15.09 | 25613408.0 |
| 2009-05-12 | AACC-DELISTED | Stock | 9.66 | 9.66 | 9.14 | 9.4 | 73814.0 |
| 2009-05-12 | AACG | Stock | 4.95 | 5.0 | 4.9 | 4.95 | 14700.0 |
| 2009-05-12 | AAI-DELISTED | Stock | 7.07 | 7.19 | 6.55 | 6.79 | 3668302.0 |
| 2009-05-12 | AAIC-DELISTED | Stock | 11.2 | 12.0 | 10.2 | 10.8 | 2272351.0 |
| 2009-05-12 | AAME | Stock | 0.76 | 0.76 | 0.68 | 0.68 | 7100.0 |
| 2009-05-12 | AAON | Stock | 4.0514 | 4.1225 | 3.9526 | 4.0553 | 380194.0 |
| 2009-05-12 | AAP | Stock | 41.52 | 41.96 | 39.8 | 40.43 | 1424000.0 |
| 2009-05-12 | AATI-DELISTED | Stock | 4.76 | 4.87 | 4.46 | 4.51 | 283562.0 |
| 2009-05-12 | AAU-DELISTED | Stock | 0.63 | 0.64 | 0.62 | 0.64 | 82050.0 |
| 2009-05-12 | AAUAF-DELISTED | Stock | 0.63 | 0.64 | 0.62 | 0.64 | 82350.0 |
| 2009-05-12 | AAV-DELISTED | Stock | 3.44 | 3.5 | 3.25 | 3.42 | 876124.0 |
| 2009-05-12 | AAWW-DELISTED | Stock | 28.25 | 28.25 | 24.94 | 25.94 | 621837.0 |
| 2009-05-12 | AAXJ | Stock | 42.09 | 42.09 | 40.97 | 41.59 | 258182.0 |
| 2009-05-12 | AAXN-DELISTED | Stock | 4.54 | 4.56 | 4.33 | 4.45 | 372743.0 |
| 2009-05-12 | AB | Stock | 18.64 | 18.89 | 17.25 | 17.93 | 730800.0 |
| 2009-05-12 | ABAX-DELISTED | Stock | 17.01 | 17.01 | 16.5 | 16.77 | 145355.0 |
| 2009-05-12 | ABB-DELISTED | Stock | 16.02 | 16.05 | 15.26 | 15.54 | 5222263.0 |
| 2009-05-12 | ABBC-DELISTED | Stock | 8.61 | 8.8 | 8.53 | 8.77 | 57479.0 |
| 2009-05-12 | ABBNY-DELISTED | Stock | 16.02 | 16.05 | 15.26 | 15.52 | 5237738.0 |
| 2009-05-12 | ABC-DELISTED | Stock | 17.87 | 18.14 | 17.85 | 17.95 | 3104516.0 |
| 2009-05-12 | ABCB | Stock | 6.1374 | 6.3709 | 5.9331 | 5.9428 | 18609.0 |
| 2009-05-12 | ABCO-DELISTED | Stock | 10.975 | 11.105 | 10.755 | 10.815 | 512728.0 |
| 2009-05-12 | ABCW-DELISTED | Stock | 1.98 | 2.42 | 1.98 | 2.13 | 309410.0 |
| 2009-05-12 | ABD-DELISTED | Stock | 3.26 | 3.31 | 2.95 | 3.04 | 538680.0 |
| 2009-05-12 | ABE-DELISTED | Stock | 14.41 | 14.8 | 14.4 | 14.62 | 18858.0 |
| 2009-05-12 | ABEO | Stock | 2025.0 | 2187.5 | 2025.0 | 2062.5 | 17.0 |
| 2009-05-12 | ABFS-DELISTED | Stock | 25.0 | 25.0 | 24.09 | 24.37 | 692761.0 |
| 2009-05-12 | ABG | Stock | 9.52 | 9.71 | 9.11 | 9.42 | 571000.0 |
| 2009-05-12 | ABII-DELISTED | Stock | 49.96 | 50.45 | 48.86 | 49.32 | 6324.0 |
| 2009-05-12 | ABK-DELISTED | Stock | 1.94 | 1.97 | 1.55 | 1.5699 | 33979834.0 |
| 2009-05-12 | ABM | Stock | 16.76 | 16.95 | 16.24 | 16.76 | 293100.0 |
| 2009-05-12 | ABMD-DELISTED | Stock | 7.5 | 7.5 | 6.53 | 6.73 | 406899.0 |
| 2009-05-12 | ABR | Stock | 2.57 | 2.57 | 2.15 | 2.18 | 245000.0 |
| 2009-05-12 | ABT | Stock | 21.6198 | 21.9892 | 21.5526 | 21.7877 | 19091288.0 |
| 2009-05-12 | ABTL-DELISTED | Stock | 2.25 | 2.425 | 2.25 | 2.4 | 58464.0 |
| 2009-05-12 | ABV-DELISTED | Stock | 61.5 | 61.5 | 58.91 | 59.27 | 771823.0 |
| 2009-05-12 | ABVA-DELISTED | Stock | 2.05 | 2.13 | 2.05 | 2.13 | 10915.0 |
| 2009-05-12 | ABVT-DELISTED | Stock | 59.0 | 64.97 | 59.0 | 61.0 | 119550.0 |
| 2009-05-12 | ABX-DELISTED | Stock | 34.3 | 35.24 | 34.16 | 35.1 | 12414658.0 |
| 2009-05-12 | ACAD | Stock | 1.96 | 1.96 | 1.54 | 1.7 | 556200.0 |
| 2009-05-12 | ACAP-DELISTED | Stock | 41.54 | 41.54 | 40.25 | 40.26 | 64500.0 |
> showing 50 of 5,771 rows — these rows as CSV