PREVIEW / stock_daily / 2009-05-13
file: by_date/stock_daily/2009/2009-05-13.parquet size: 178 KB rows: 5,735 symbols: 3,419
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-13 | AAPL | Stock | 4.4004 | 4.4293 | 4.2636 | 4.2675 | 595971600.0 |
| 2009-05-13 | MSFT | Stock | 19.92 | 20.0 | 19.67 | 19.75 | 49281700.0 |
| 2009-05-13 | NVDA | Stock | 0.223 | 0.2243 | 0.2082 | 0.21 | 1305608000.0 |
| 2009-05-13 | AMZN | Stock | 3.8125 | 3.8325 | 3.7005 | 3.7095 | 175410000.0 |
| 2009-05-13 | TLT | Stock | 97.36 | 97.93 | 97.24 | 97.69 | 1917455.0 |
| 2009-05-13 | ES | Stock | 21.15 | 21.47 | 21.03 | 21.17 | 2533600.0 |
| 2009-05-13 | CL | Stock | 31.525 | 32.205 | 31.25 | 32.07 | 12716800.0 |
| 2009-05-13 | A | Stock | 13.3548 | 13.505 | 12.7682 | 12.9113 | 4229929.0 |
| 2009-05-13 | AABA-DELISTED | Stock | 14.88 | 14.95 | 14.5 | 14.51 | 19454795.0 |
| 2009-05-13 | AACC-DELISTED | Stock | 9.21 | 9.26 | 8.34 | 8.38 | 45317.0 |
| 2009-05-13 | AACG | Stock | 4.63 | 5.0 | 4.63 | 4.86 | 52200.0 |
| 2009-05-13 | AAI-DELISTED | Stock | 6.67 | 6.67 | 6.35 | 6.36 | 2207948.0 |
| 2009-05-13 | AAIC-DELISTED | Stock | 10.24 | 11.2 | 8.0 | 8.6 | 1456964.0 |
| 2009-05-13 | AAON | Stock | 4.002 | 4.0099 | 3.8558 | 3.8617 | 475875.0 |
| 2009-05-13 | AAP | Stock | 39.93 | 40.42 | 39.5 | 39.76 | 1657600.0 |
| 2009-05-13 | AATI-DELISTED | Stock | 4.43 | 4.57 | 4.32 | 4.35 | 293334.0 |
| 2009-05-13 | AAU-DELISTED | Stock | 0.65 | 0.65 | 0.61 | 0.63 | 49548.0 |
| 2009-05-13 | AAUAF-DELISTED | Stock | 0.65 | 0.65 | 0.61 | 0.63 | 49703.0 |
| 2009-05-13 | AAV-DELISTED | Stock | 3.33 | 3.4 | 3.1 | 3.14 | 914500.0 |
| 2009-05-13 | AAWW-DELISTED | Stock | 23.02 | 23.94 | 22.5 | 22.67 | 2065570.0 |
| 2009-05-13 | AAXJ | Stock | 41.3 | 43.25 | 40.38 | 40.47 | 192369.0 |
| 2009-05-13 | AAXN-DELISTED | Stock | 4.33 | 4.4 | 4.18 | 4.18 | 435569.0 |
| 2009-05-13 | AB | Stock | 17.62 | 17.74 | 16.75 | 16.93 | 387300.0 |
| 2009-05-13 | ABAX-DELISTED | Stock | 16.48 | 16.66 | 15.94 | 16.03 | 180232.0 |
| 2009-05-13 | ABB-DELISTED | Stock | 14.82 | 14.84 | 14.4178 | 14.45 | 5872626.0 |
| 2009-05-13 | ABBC-DELISTED | Stock | 8.61 | 8.74 | 8.43 | 8.56 | 56485.0 |
| 2009-05-13 | ABBNY-DELISTED | Stock | 14.83 | 14.84 | 14.4178 | 14.44 | 5913624.0 |
| 2009-05-13 | ABC-DELISTED | Stock | 17.92 | 18.05 | 17.77 | 17.84 | 3232546.0 |
| 2009-05-13 | ABCB | Stock | 5.8748 | 6.4 | 5.6316 | 5.6899 | 25909.0 |
| 2009-05-13 | ABCO-DELISTED | Stock | 10.718 | 10.932 | 10.718 | 10.787 | 176026.0 |
| 2009-05-13 | ABCW-DELISTED | Stock | 2.1 | 2.13 | 1.71 | 1.73 | 149670.0 |
| 2009-05-13 | ABD-DELISTED | Stock | 2.93 | 3.06 | 2.55 | 2.57 | 255450.0 |
| 2009-05-13 | ABE-DELISTED | Stock | 14.2 | 14.445 | 14.0 | 14.02 | 9664.0 |
| 2009-05-13 | ABEO | Stock | 2062.5 | 2062.5 | 1812.5 | 2037.5 | 11.0 |
| 2009-05-13 | ABFS-DELISTED | Stock | 23.94 | 24.08 | 21.71 | 22.21 | 1216004.0 |
| 2009-05-13 | ABG | Stock | 9.26 | 9.26 | 8.27 | 8.33 | 416100.0 |
| 2009-05-13 | ABII-DELISTED | Stock | 49.64 | 49.64 | 47.7575 | 48.57 | 7862.0 |
| 2009-05-13 | ABK-DELISTED | Stock | 1.5 | 1.51 | 1.26 | 1.26 | 22839316.0 |
| 2009-05-13 | ABM | Stock | 16.46 | 16.56 | 16.12 | 16.32 | 446100.0 |
| 2009-05-13 | ABMD-DELISTED | Stock | 6.6 | 6.62 | 6.27 | 6.28 | 399438.0 |
| 2009-05-13 | ABR | Stock | 2.13 | 2.15 | 1.74 | 1.77 | 483900.0 |
| 2009-05-13 | ABT | Stock | 21.663 | 22.2195 | 21.6102 | 21.8309 | 16314298.0 |
| 2009-05-13 | ABTL-DELISTED | Stock | 2.2521 | 2.3 | 2.2281 | 2.3 | 9719.0 |
| 2009-05-13 | ABV-DELISTED | Stock | 58.58 | 58.71 | 57.01 | 57.04 | 504552.0 |
| 2009-05-13 | ABVA-DELISTED | Stock | 2.17 | 2.23 | 2.17 | 2.23 | 1000.0 |
| 2009-05-13 | ABVT-DELISTED | Stock | 61.5 | 61.5 | 54.6 | 58.5 | 28125.0 |
| 2009-05-13 | ABX-DELISTED | Stock | 34.43 | 35.93 | 34.01 | 34.37 | 11031520.0 |
| 2009-05-13 | ACAD | Stock | 1.74 | 1.98 | 1.59 | 1.76 | 375700.0 |
| 2009-05-13 | ACAP-DELISTED | Stock | 40.25 | 40.77 | 38.86 | 38.88 | 85776.0 |
| 2009-05-13 | ACAS-DELISTED | Stock | 3.29 | 3.33 | 2.99 | 3.0 | 7363053.0 |
> showing 50 of 5,735 rows — these rows as CSV