PREVIEW / stock_daily / 2010-05-12
file: by_date/stock_daily/2010/2010-05-12.parquet size: 192 KB rows: 5,970 symbols: 3,523
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 |
|---|---|---|---|---|---|---|---|
| 2010-05-12 | AAPL | Stock | 9.2586 | 9.3975 | 9.2393 | 9.3604 | 654379600.0 |
| 2010-05-12 | MSFT | Stock | 28.98 | 29.58 | 28.92 | 29.44 | 47146800.0 |
| 2010-05-12 | NVDA | Stock | 0.3625 | 0.369 | 0.3602 | 0.367 | 901236000.0 |
| 2010-05-12 | AMZN | Stock | 6.5705 | 6.7065 | 6.484 | 6.6935 | 118090000.0 |
| 2010-05-12 | TLT | Stock | 93.14 | 93.26 | 92.61 | 92.65 | 5530849.0 |
| 2010-05-12 | ES | Stock | 26.52 | 26.93 | 26.35 | 26.93 | 1294100.0 |
| 2010-05-12 | CL | Stock | 41.4 | 41.84 | 41.23 | 41.775 | 4711400.0 |
| 2010-05-12 | A | Stock | 24.4349 | 25.0286 | 24.4134 | 24.8999 | 3972836.0 |
| 2010-05-12 | AABA-DELISTED | Stock | 16.45 | 16.5 | 16.33 | 16.47 | 16259110.0 |
| 2010-05-12 | AACC-DELISTED | Stock | 7.12 | 7.62 | 7.05 | 7.6 | 37068.0 |
| 2010-05-12 | AACG | Stock | 3.38 | 3.51 | 3.36 | 3.36 | 600.0 |
| 2010-05-12 | AAI-DELISTED | Stock | 5.21 | 5.46 | 5.21 | 5.43 | 3052793.0 |
| 2010-05-12 | AAIC-DELISTED | Stock | 18.69 | 20.0 | 18.61 | 19.96 | 56913.0 |
| 2010-05-12 | AAME | Stock | 1.58 | 1.76 | 1.58 | 1.69 | 7100.0 |
| 2010-05-12 | AAON | Stock | 4.6044 | 4.7802 | 4.561 | 4.7743 | 422212.0 |
| 2010-05-12 | AAP | Stock | 45.46 | 46.0 | 45.15 | 45.96 | 1253200.0 |
| 2010-05-12 | AATI-DELISTED | Stock | 3.72 | 4.13 | 3.65 | 4.07 | 595066.0 |
| 2010-05-12 | AAU-DELISTED | Stock | 1.27 | 1.34 | 1.23 | 1.29 | 412563.0 |
| 2010-05-12 | AAUAF-DELISTED | Stock | 1.27 | 1.34 | 1.23 | 1.29 | 411970.0 |
| 2010-05-12 | AAV-DELISTED | Stock | 6.36 | 6.68 | 6.36 | 6.67 | 462974.0 |
| 2010-05-12 | AAWW-DELISTED | Stock | 53.9 | 55.76 | 53.78 | 55.2 | 266329.0 |
| 2010-05-12 | AAXJ | Stock | 55.69 | 55.69 | 54.73 | 55.29 | 838826.0 |
| 2010-05-12 | AAXN-DELISTED | Stock | 4.68 | 4.9 | 4.652 | 4.9 | 915029.0 |
| 2010-05-12 | AB | Stock | 30.26 | 31.04 | 30.26 | 30.92 | 583200.0 |
| 2010-05-12 | ABAX-DELISTED | Stock | 24.93 | 25.43 | 24.64 | 25.38 | 114160.0 |
| 2010-05-12 | ABB-DELISTED | Stock | 18.92 | 19.16 | 18.8385 | 19.02 | 5303048.0 |
| 2010-05-12 | ABBC-DELISTED | Stock | 9.8 | 9.98 | 9.78 | 9.95 | 81110.0 |
| 2010-05-12 | ABBNY-DELISTED | Stock | 18.92 | 19.16 | 18.8385 | 19.0 | 5325440.0 |
| 2010-05-12 | ABC-DELISTED | Stock | 31.27 | 31.84 | 31.01 | 31.8 | 3154457.0 |
| 2010-05-12 | ABCB | Stock | 11.0673 | 11.3858 | 11.0673 | 11.2365 | 68927.0 |
| 2010-05-12 | ABCD-DELISTED | Stock | 4.91 | 5.38 | 4.91 | 5.23 | 81505.0 |
| 2010-05-12 | ABCO-DELISTED | Stock | 19.477 | 19.813 | 19.372 | 19.798 | 158782.0 |
| 2010-05-12 | ABCW-DELISTED | Stock | 0.9667 | 0.9677 | 0.9103 | 0.93 | 84920.0 |
| 2010-05-12 | ABD-DELISTED | Stock | 7.67 | 8.13 | 7.57 | 8.06 | 357580.0 |
| 2010-05-12 | ABE-DELISTED | Stock | 16.33 | 16.38 | 15.88 | 16.3 | 23218.0 |
| 2010-05-12 | ABEO | Stock | 3362.5 | 3362.5 | 2875.0 | 3000.0 | 25.0 |
| 2010-05-12 | ABFS-DELISTED | Stock | 29.34 | 29.82 | 29.14 | 29.5 | 340505.0 |
| 2010-05-12 | ABG | Stock | 14.8 | 15.41 | 14.77 | 15.41 | 153300.0 |
| 2010-05-12 | ABII-DELISTED | Stock | 46.16 | 48.32 | 45.75 | 47.91 | 35793.0 |
| 2010-05-12 | ABK-DELISTED | Stock | 1.38 | 1.45 | 1.33 | 1.36 | 29933426.0 |
| 2010-05-12 | ABM | Stock | 21.9 | 22.6 | 21.82 | 22.57 | 146200.0 |
| 2010-05-12 | ABMD-DELISTED | Stock | 9.43 | 9.91 | 9.43 | 9.82 | 213975.0 |
| 2010-05-12 | ABR | Stock | 4.21 | 4.36 | 4.16 | 4.36 | 112600.0 |
| 2010-05-12 | ABT | Stock | 23.7837 | 23.7933 | 23.4574 | 23.5822 | 18435181.0 |
| 2010-05-12 | ABTL-DELISTED | Stock | 5.35 | 5.35 | 4.85 | 5.15 | 252971.0 |
| 2010-05-12 | ABV-DELISTED | Stock | 99.79 | 101.3 | 99.71 | 100.73 | 579089.0 |
| 2010-05-12 | ABVA-DELISTED | Stock | 2.785 | 2.9599 | 2.785 | 2.8955 | 2265.0 |
| 2010-05-12 | ABVT-DELISTED | Stock | 46.77 | 48.58 | 46.38 | 48.43 | 279943.0 |
| 2010-05-12 | ABX-DELISTED | Stock | 46.7 | 47.21 | 45.62 | 45.64 | 18936789.0 |
| 2010-05-12 | ACAD | Stock | 1.57 | 1.57 | 1.48 | 1.48 | 590400.0 |
> showing 50 of 5,970 rows — these rows as CSV