PREVIEW / stock_daily / 2024-06-27
file: by_date/stock_daily/2024/2024-06-27.parquet size: 231 KB rows: 7,214 symbols: 930
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 |
|---|---|---|---|---|---|---|---|
| 2024-06-27 | AAPL | Stock | 214.69 | 215.74 | 212.35 | 214.1 | 49772700.0 |
| 2024-06-27 | MSFT | Stock | 452.18 | 456.17 | 451.77 | 452.85 | 14806300.0 |
| 2024-06-27 | NVDA | Stock | 124.1 | 126.41 | 122.92 | 123.99 | 252571700.0 |
| 2024-06-27 | AMZN | Stock | 195.01 | 199.84 | 194.2 | 197.85 | 74397500.0 |
| 2024-06-27 | GOOGL | Stock | 184.18 | 186.05 | 184.02 | 185.41 | 18848884.0 |
| 2024-06-27 | META | Stock | 514.25 | 522.88 | 513.9 | 519.56 | 10121200.0 |
| 2024-06-27 | TSLA | Stock | 195.17 | 198.72 | 194.05 | 197.42 | 72746500.0 |
| 2024-06-27 | TLT | Stock | 93.52 | 93.71 | 93.42 | 93.52 | 23140767.0 |
| 2024-06-27 | ES | Stock | 56.91 | 57.66 | 56.77 | 57.19 | 1274000.0 |
| 2024-06-27 | CL | Stock | 98.22 | 98.53 | 97.76 | 98.17 | 3616400.0 |
| 2024-06-27 | A | Stock | 132.2 | 132.99 | 130.58 | 130.8 | 1898000.0 |
| 2024-06-27 | AA | Stock | 39.34 | 39.46 | 38.53 | 38.82 | 5027300.0 |
| 2024-06-27 | AACG | Stock | 0.85 | 0.85 | 0.79 | 0.8 | 10300.0 |
| 2024-06-27 | AACT | Stock | 10.7 | 10.7 | 10.655 | 10.67 | 1139400.0 |
| 2024-06-27 | AAGR-DELISTED | Stock | 0.243 | 0.25 | 0.222 | 0.2416 | 7431602.0 |
| 2024-06-27 | AAL | Stock | 11.12 | 11.32 | 11.02 | 11.28 | 23780800.0 |
| 2024-06-27 | AAMC-DELISTED | Stock | 1.9 | 2.33 | 1.9 | 1.95 | 11400.0 |
| 2024-06-27 | AAME | Stock | 1.66 | 1.72 | 1.66 | 1.72 | 1700.0 |
| 2024-06-27 | AAMI | Stock | 22.06 | 22.06 | 21.63 | 21.78 | 197800.0 |
| 2024-06-27 | AAN-DELISTED | Stock | 9.94 | 9.97 | 9.94 | 9.95 | 472900.0 |
| 2024-06-27 | AAOI | Stock | 8.5 | 9.05 | 8.4 | 8.52 | 1765100.0 |
| 2024-06-27 | AAON | Stock | 85.67 | 87.35 | 85.34 | 86.66 | 817400.0 |
| 2024-06-27 | AAP | Stock | 61.82 | 63.37 | 61.27 | 62.7 | 1116600.0 |
| 2024-06-27 | AAT | Stock | 21.37 | 21.59 | 21.2 | 21.57 | 174000.0 |
| 2024-06-27 | AATC | Stock | 6.08 | 6.1 | 6.075 | 6.1 | 5555.0 |
| 2024-06-27 | AAUAF-DELISTED | Stock | 0.065 | 0.07 | 0.065 | 0.0674 | 252606.0 |
| 2024-06-27 | AAXJ | Stock | 72.27 | 72.27 | 71.82 | 71.86 | 162423.0 |
| 2024-06-27 | AB | Stock | 33.25 | 33.74 | 33.01 | 33.5 | 317300.0 |
| 2024-06-27 | ABAT | Stock | 1.14 | 1.18 | 1.09 | 1.18 | 782398.0 |
| 2024-06-27 | ABBV | Stock | 171.29 | 171.56 | 167.75 | 168.99 | 5382000.0 |
| 2024-06-27 | ABCB | Stock | 48.57 | 49.15 | 48.5 | 49.1 | 316900.0 |
| 2024-06-27 | ABCL | Stock | 2.75 | 2.89 | 2.731 | 2.88 | 1939600.0 |
| 2024-06-27 | ABEO | Stock | 4.06 | 4.26 | 4.04 | 4.19 | 177600.0 |
| 2024-06-27 | ABEV | Stock | 2.08 | 2.11 | 2.07 | 2.09 | 21461200.0 |
| 2024-06-27 | ABG | Stock | 222.24 | 226.33 | 221.74 | 226.14 | 221300.0 |
| 2024-06-27 | ABLLW | Stock | 0.72 | 0.75 | 0.66 | 0.69 | 41747.0 |
| 2024-06-27 | ABLV | Stock | 0.91 | 1.05 | 0.91 | 0.925 | 5500.0 |
| 2024-06-27 | ABM | Stock | 50.89 | 51.01 | 50.0 | 50.09 | 449500.0 |
| 2024-06-27 | ABNB | Stock | 150.46 | 151.88 | 149.39 | 151.61 | 3588600.0 |
| 2024-06-27 | ABOS | Stock | 2.22 | 2.53 | 2.22 | 2.36 | 958400.0 |
| 2024-06-27 | ABR | Stock | 14.21 | 14.22 | 14.0 | 14.22 | 1517300.0 |
| 2024-06-27 | ABR.D | Stock | 18.88 | 18.8944 | 18.7015 | 18.73 | 7885.0 |
| 2024-06-27 | ABR.E | Stock | 18.23 | 18.23 | 18.1 | 18.1 | 1496.0 |
| 2024-06-27 | ABR.F | Stock | 19.83 | 19.83 | 19.39 | 19.39 | 42691.0 |
| 2024-06-27 | ABSI | Stock | 3.09 | 3.2 | 2.995 | 3.05 | 1511500.0 |
| 2024-06-27 | ABT | Stock | 105.25 | 105.32 | 103.92 | 104.65 | 4137600.0 |
| 2024-06-27 | ABTC | Stock | 84.0 | 84.75 | 81.0 | 83.25 | 3450.6666666666665 |
| 2024-06-27 | ABTS | Stock | 7.5 | 7.875 | 7.5 | 7.8 | 2413.0 |
| 2024-06-27 | ABUS | Stock | 3.03 | 3.14 | 3.03 | 3.1 | 644000.0 |
| 2024-06-27 | ABVC | Stock | 0.721 | 0.748 | 0.72 | 0.737 | 57800.0 |
> showing 50 of 7,214 rows — these rows as CSV