PREVIEW / stock_daily / 2009-05-29
file: by_date/stock_daily/2009/2009-05-29.parquet size: 181 KB rows: 5,804 symbols: 3,473
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-29 | AAPL | Stock | 4.8354 | 4.8536 | 4.7804 | 4.8504 | 456534400.0 |
| 2009-05-29 | MSFT | Stock | 20.56 | 20.94 | 20.3 | 20.89 | 46134900.0 |
| 2009-05-29 | NVDA | Stock | 0.263 | 0.2635 | 0.2518 | 0.2608 | 834232000.0 |
| 2009-05-29 | AMZN | Stock | 3.886 | 3.9005 | 3.82 | 3.8995 | 101444000.0 |
| 2009-05-29 | TLT | Stock | 91.7 | 94.23 | 91.64 | 94.17 | 4746612.0 |
| 2009-05-29 | ES | Stock | 20.88 | 21.09 | 20.47 | 20.79 | 2548200.0 |
| 2009-05-29 | CL | Stock | 32.015 | 32.98 | 31.96 | 32.975 | 9748800.0 |
| 2009-05-29 | A | Stock | 12.9113 | 13.0401 | 12.711 | 13.0401 | 2769298.0 |
| 2009-05-29 | AABA-DELISTED | Stock | 15.2 | 15.84 | 15.11 | 15.83 | 28794217.0 |
| 2009-05-29 | AACC-DELISTED | Stock | 8.71 | 8.71 | 8.08 | 8.59 | 36589.0 |
| 2009-05-29 | AACG | Stock | 5.9 | 6.0 | 5.65 | 6.0 | 50400.0 |
| 2009-05-29 | AAI-DELISTED | Stock | 5.18 | 5.34 | 4.95 | 5.07 | 4413074.0 |
| 2009-05-29 | AAIC-DELISTED | Stock | 8.0 | 8.4 | 7.6 | 7.6 | 2827373.0 |
| 2009-05-29 | AAON | Stock | 4.0889 | 4.1185 | 4.0138 | 4.1086 | 273375.0 |
| 2009-05-29 | AAP | Stock | 43.45 | 43.46 | 41.98 | 42.59 | 3022800.0 |
| 2009-05-29 | AATI-DELISTED | Stock | 4.52 | 4.72 | 4.31 | 4.72 | 389266.0 |
| 2009-05-29 | AAU-DELISTED | Stock | 0.84 | 0.92 | 0.8201 | 0.9099 | 319509.0 |
| 2009-05-29 | AAUAF-DELISTED | Stock | 0.84 | 0.92 | 0.8201 | 0.9099 | 324409.0 |
| 2009-05-29 | AAV-DELISTED | Stock | 4.13 | 4.35 | 4.06 | 4.31 | 1082587.0 |
| 2009-05-29 | AAWW-DELISTED | Stock | 25.3 | 25.91 | 25.0 | 25.88 | 233263.0 |
| 2009-05-29 | AAXJ | Stock | 44.88 | 45.05 | 44.29 | 45.05 | 403928.0 |
| 2009-05-29 | AAXN-DELISTED | Stock | 4.17 | 4.35 | 4.15 | 4.35 | 704503.0 |
| 2009-05-29 | AB | Stock | 18.67 | 19.1 | 18.44 | 19.08 | 449900.0 |
| 2009-05-29 | ABAX-DELISTED | Stock | 17.29 | 17.54 | 16.91 | 17.48 | 211400.0 |
| 2009-05-29 | ABB-DELISTED | Stock | 16.29 | 16.48 | 16.22 | 16.46 | 3745983.0 |
| 2009-05-29 | ABBC-DELISTED | Stock | 8.02 | 8.21 | 7.84 | 8.12 | 116538.0 |
| 2009-05-29 | ABBNY-DELISTED | Stock | 16.29 | 16.48 | 16.22 | 16.46 | 3748886.0 |
| 2009-05-29 | ABC-DELISTED | Stock | 18.52 | 18.6 | 18.34 | 18.5 | 3295624.0 |
| 2009-05-29 | ABCB | Stock | 5.9623 | 6.1082 | 5.8748 | 6.0985 | 29816.0 |
| 2009-05-29 | ABCO-DELISTED | Stock | 11.592 | 11.733 | 11.347 | 11.592 | 260254.0 |
| 2009-05-29 | ABCW-DELISTED | Stock | 1.65 | 1.65 | 1.25 | 1.29 | 449520.0 |
| 2009-05-29 | ABD-DELISTED | Stock | 2.945 | 3.0852 | 2.8348 | 2.945 | 278280.0 |
| 2009-05-29 | ABE-DELISTED | Stock | 15.227 | 15.42 | 15.0878 | 15.34 | 41329.0 |
| 2009-05-29 | ABEO | Stock | 2125.0 | 2312.5 | 2062.5 | 2312.5 | 74.0 |
| 2009-05-29 | ABFS-DELISTED | Stock | 27.87 | 28.2 | 27.4 | 28.16 | 725463.0 |
| 2009-05-29 | ABG | Stock | 9.37 | 9.86 | 9.26 | 9.5 | 365800.0 |
| 2009-05-29 | ABII-DELISTED | Stock | 50.97 | 51.79 | 49.32 | 51.08 | 24685.0 |
| 2009-05-29 | ABK-DELISTED | Stock | 1.25 | 1.26 | 1.2 | 1.25 | 4930941.0 |
| 2009-05-29 | ABM | Stock | 16.16 | 16.18 | 15.88 | 16.18 | 307800.0 |
| 2009-05-29 | ABMD-DELISTED | Stock | 5.86 | 5.97 | 5.71 | 5.97 | 270417.0 |
| 2009-05-29 | ABR | Stock | 1.84 | 1.95 | 1.56 | 1.56 | 732500.0 |
| 2009-05-29 | ABT | Stock | 21.4423 | 21.6486 | 21.1448 | 21.6198 | 15190288.0 |
| 2009-05-29 | ABTL-DELISTED | Stock | 2.1005 | 2.3005 | 2.0505 | 2.2495 | 14239.0 |
| 2009-05-29 | ABV-DELISTED | Stock | 67.03 | 67.36 | 64.76 | 65.57 | 664237.0 |
| 2009-05-29 | ABVT-DELISTED | Stock | 71.96 | 72.5 | 69.62 | 72.0 | 75815.0 |
| 2009-05-29 | ABX-DELISTED | Stock | 38.54 | 38.96 | 37.78 | 38.09 | 10563071.0 |
| 2009-05-29 | ACAD | Stock | 1.86 | 1.96 | 1.82 | 1.96 | 240200.0 |
| 2009-05-29 | ACAP-DELISTED | Stock | 37.73 | 38.63 | 37.73 | 38.47 | 78761.0 |
| 2009-05-29 | ACAS-DELISTED | Stock | 2.99 | 3.0 | 2.55 | 2.75 | 8686097.0 |
| 2009-05-29 | ACAT-DELISTED | Stock | 4.52 | 4.52 | 3.95 | 4.01 | 97863.0 |
> showing 50 of 5,804 rows — these rows as CSV