PREVIEW / stock_daily / 2009-09-10
file: by_date/stock_daily/2009/2009-09-10.parquet size: 185 KB rows: 5,823 symbols: 3,467
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-10 | AAPL | Stock | 6.145 | 6.1875 | 6.1004 | 6.1629 | 491134000.0 |
| 2009-09-10 | MSFT | Stock | 24.8 | 25.05 | 24.65 | 25.0 | 46256000.0 |
| 2009-09-10 | NVDA | Stock | 0.4003 | 0.4122 | 0.3958 | 0.4118 | 607952000.0 |
| 2009-09-10 | AMZN | Stock | 4.1165 | 4.2035 | 4.115 | 4.1925 | 140462000.0 |
| 2009-09-10 | TLT | Stock | 94.93 | 96.71 | 94.91 | 96.17 | 4417337.0 |
| 2009-09-10 | ES | Stock | 23.69 | 23.72 | 23.43 | 23.48 | 1032200.0 |
| 2009-09-10 | CL | Stock | 36.08 | 36.615 | 35.97 | 36.615 | 8159000.0 |
| 2009-09-10 | A | Stock | 19.3705 | 19.9428 | 19.2704 | 19.9285 | 6009722.0 |
| 2009-09-10 | AABA-DELISTED | Stock | 15.27 | 15.63 | 15.15 | 15.45 | 47682349.0 |
| 2009-09-10 | AACC-DELISTED | Stock | 7.48 | 7.75 | 7.217 | 7.64 | 34287.0 |
| 2009-09-10 | AACG | Stock | 6.8 | 6.83 | 6.75 | 6.75 | 18400.0 |
| 2009-09-10 | AAI-DELISTED | Stock | 6.59 | 6.78 | 6.45 | 6.64 | 1829100.0 |
| 2009-09-10 | AAIC-DELISTED | Stock | 9.4 | 10.0 | 9.4 | 9.4 | 209716.0 |
| 2009-09-10 | AAON | Stock | 3.9348 | 3.9783 | 3.9012 | 3.9625 | 605981.0 |
| 2009-09-10 | AAP | Stock | 41.48 | 41.76 | 40.36 | 40.61 | 3503400.0 |
| 2009-09-10 | AATI-DELISTED | Stock | 4.52 | 4.62 | 4.46 | 4.55 | 117285.0 |
| 2009-09-10 | AAU-DELISTED | Stock | 0.68 | 0.74 | 0.6743 | 0.69 | 132677.0 |
| 2009-09-10 | AAUAF-DELISTED | Stock | 0.68 | 0.74 | 0.6743 | 0.69 | 133977.0 |
| 2009-09-10 | AAV-DELISTED | Stock | 6.01 | 6.21 | 5.9499 | 6.17 | 1065639.0 |
| 2009-09-10 | AAWW-DELISTED | Stock | 25.44 | 26.88 | 24.76 | 26.79 | 1952135.0 |
| 2009-09-10 | AAXJ | Stock | 51.62 | 52.05 | 51.1053 | 52.05 | 746070.0 |
| 2009-09-10 | AAXN-DELISTED | Stock | 4.55 | 4.59 | 4.47 | 4.5295 | 451079.0 |
| 2009-09-10 | AB | Stock | 24.9 | 25.71 | 24.53 | 25.18 | 1222600.0 |
| 2009-09-10 | ABAX-DELISTED | Stock | 27.26 | 28.12 | 26.9 | 27.98 | 189550.0 |
| 2009-09-10 | ABB-DELISTED | Stock | 20.72 | 20.84 | 20.44 | 20.78 | 4503883.0 |
| 2009-09-10 | ABBC-DELISTED | Stock | 7.8 | 7.85 | 7.75 | 7.78 | 24064.0 |
| 2009-09-10 | ABBNY-DELISTED | Stock | 20.72 | 20.84 | 20.44 | 20.8 | 4574633.0 |
| 2009-09-10 | ABC-DELISTED | Stock | 21.39 | 21.61 | 21.25 | 21.54 | 2310787.0 |
| 2009-09-10 | ABCB | Stock | 6.0012 | 6.2346 | 5.9234 | 6.0693 | 13468.0 |
| 2009-09-10 | ABCO-DELISTED | Stock | 13.56 | 13.83 | 13.42 | 13.75 | 141008.0 |
| 2009-09-10 | ABCW-DELISTED | Stock | 1.29 | 1.31 | 1.21 | 1.23 | 47190.0 |
| 2009-09-10 | ABD-DELISTED | Stock | 5.75 | 5.89 | 5.72 | 5.81 | 479090.0 |
| 2009-09-10 | ABE-DELISTED | Stock | 16.91 | 17.01 | 16.18 | 16.91 | 30731.0 |
| 2009-09-10 | ABEO | Stock | 4375.0 | 4500.0 | 4250.0 | 4412.5 | 23.0 |
| 2009-09-10 | ABFS-DELISTED | Stock | 32.495 | 33.55 | 32.495 | 33.55 | 388335.0 |
| 2009-09-10 | ABG | Stock | 13.39 | 14.4 | 13.35 | 14.05 | 380600.0 |
| 2009-09-10 | ABII-DELISTED | Stock | 25.22 | 26.47 | 25.0 | 25.93 | 56005.0 |
| 2009-09-10 | ABK-DELISTED | Stock | 1.66 | 1.69 | 1.61 | 1.65 | 10894349.0 |
| 2009-09-10 | ABM | Stock | 20.21 | 20.46 | 20.19 | 20.41 | 116000.0 |
| 2009-09-10 | ABMD-DELISTED | Stock | 8.09 | 8.15 | 8.04 | 8.05 | 124715.0 |
| 2009-09-10 | ABR | Stock | 1.9 | 1.93 | 1.87 | 1.9 | 121300.0 |
| 2009-09-10 | ABT | Stock | 22.2483 | 22.4882 | 21.9796 | 22.4882 | 20663610.0 |
| 2009-09-10 | ABTL-DELISTED | Stock | 2.9003 | 2.9997 | 2.9003 | 2.9997 | 3381.0 |
| 2009-09-10 | ABV-DELISTED | Stock | 75.3 | 76.65 | 74.76 | 76.51 | 587538.0 |
| 2009-09-10 | ABVA-DELISTED | Stock | 2.6799 | 2.68 | 2.4 | 2.6799 | 8088.0 |
| 2009-09-10 | ABVT-DELISTED | Stock | 44.84 | 45.31 | 43.2701 | 45.19 | 63658.0 |
| 2009-09-10 | ABX-DELISTED | Stock | 36.98 | 38.01 | 36.7 | 37.99 | 29854104.0 |
| 2009-09-10 | ACAD | Stock | 1.96 | 1.99 | 1.94 | 1.95 | 1642100.0 |
| 2009-09-10 | ACAP-DELISTED | Stock | 31.91 | 32.08 | 31.26 | 31.54 | 17473.0 |
| 2009-09-10 | ACAS-DELISTED | Stock | 2.28 | 2.3 | 2.22 | 2.28 | 2293217.0 |
> showing 50 of 5,823 rows — these rows as CSV