PREVIEW / stock_daily / 2024-06-18
file: by_date/stock_daily/2024/2024-06-18.parquet size: 231 KB rows: 7,230 symbols: 941
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-18 | AAPL | Stock | 217.59 | 218.63 | 213.0 | 214.29 | 79943300.0 |
| 2024-06-18 | MSFT | Stock | 449.71 | 450.14 | 444.89 | 446.34 | 17112500.0 |
| 2024-06-18 | NVDA | Stock | 131.14 | 136.33 | 130.69 | 135.58 | 294335100.0 |
| 2024-06-18 | AMZN | Stock | 183.74 | 184.29 | 181.43 | 182.81 | 36659200.0 |
| 2024-06-18 | GOOGL | Stock | 177.14 | 177.385 | 174.1042 | 175.09 | 21869857.0 |
| 2024-06-18 | META | Stock | 504.56 | 506.0 | 495.02 | 499.49 | 13060400.0 |
| 2024-06-18 | TSLA | Stock | 186.56 | 187.2 | 182.37 | 184.86 | 68982300.0 |
| 2024-06-18 | TLT | Stock | 93.89 | 94.6 | 93.73 | 94.59 | 26881038.0 |
| 2024-06-18 | ES | Stock | 57.43 | 58.2 | 57.43 | 58.0 | 2352800.0 |
| 2024-06-18 | CL | Stock | 95.72 | 97.08 | 95.68 | 97.01 | 3722000.0 |
| 2024-06-18 | A | Stock | 132.13 | 135.15 | 131.56 | 134.9 | 3453000.0 |
| 2024-06-18 | AA | Stock | 37.01 | 38.23 | 36.79 | 37.49 | 3898400.0 |
| 2024-06-18 | AACG | Stock | 0.83 | 0.85 | 0.81 | 0.84 | 6900.0 |
| 2024-06-18 | AACT | Stock | 10.65 | 10.66 | 10.65 | 10.65 | 258500.0 |
| 2024-06-18 | AAGR-DELISTED | Stock | 0.3214 | 0.41 | 0.32 | 0.359 | 757147.0 |
| 2024-06-18 | AAGRW-DELISTED | Stock | 0.0145 | 0.0145 | 0.0144 | 0.0144 | 4766.0 |
| 2024-06-18 | AAL | Stock | 11.41 | 11.5 | 11.27 | 11.28 | 18841500.0 |
| 2024-06-18 | AAMC-DELISTED | Stock | 2.15 | 2.175 | 2.0 | 2.02 | 4900.0 |
| 2024-06-18 | AAME | Stock | 1.81 | 1.91 | 1.7 | 1.73 | 6500.0 |
| 2024-06-18 | AAMI | Stock | 21.77 | 21.98 | 21.56 | 21.96 | 227400.0 |
| 2024-06-18 | AAN-DELISTED | Stock | 10.02 | 10.06 | 9.995 | 10.03 | 3300100.0 |
| 2024-06-18 | AAOI | Stock | 10.21 | 10.39 | 9.92 | 10.04 | 927600.0 |
| 2024-06-18 | AAON | Stock | 79.37 | 81.25 | 78.36 | 80.62 | 867900.0 |
| 2024-06-18 | AAP | Stock | 64.09 | 65.16 | 64.09 | 64.28 | 1018600.0 |
| 2024-06-18 | AAT | Stock | 21.5 | 21.88 | 21.5 | 21.79 | 258400.0 |
| 2024-06-18 | AATC | Stock | 6.0288 | 6.11 | 5.95 | 5.95 | 7291.0 |
| 2024-06-18 | AAUAF-DELISTED | Stock | 0.06365 | 0.07 | 0.062 | 0.0641 | 163226.0 |
| 2024-06-18 | AAXJ | Stock | 72.28 | 72.79 | 72.24 | 72.68 | 180622.0 |
| 2024-06-18 | AB | Stock | 32.88 | 33.45 | 32.88 | 33.4 | 168400.0 |
| 2024-06-18 | ABAT | Stock | 1.05 | 1.0761 | 1.0 | 1.0 | 696233.0 |
| 2024-06-18 | ABBV | Stock | 170.44 | 173.01 | 169.87 | 171.36 | 4250900.0 |
| 2024-06-18 | ABCB | Stock | 47.58 | 48.62 | 47.58 | 48.16 | 255700.0 |
| 2024-06-18 | ABCL | Stock | 3.1 | 3.15 | 2.985 | 3.02 | 2146800.0 |
| 2024-06-18 | ABEO | Stock | 4.49 | 4.65 | 4.43 | 4.54 | 799400.0 |
| 2024-06-18 | ABEV | Stock | 2.08 | 2.11 | 2.06 | 2.08 | 34172100.0 |
| 2024-06-18 | ABG | Stock | 234.91 | 236.36 | 232.58 | 233.12 | 98500.0 |
| 2024-06-18 | ABLLW | Stock | 0.45 | 0.495 | 0.45 | 0.4512 | 176681.0 |
| 2024-06-18 | ABLV | Stock | 1.075 | 1.075 | 1.02 | 1.02 | 48900.0 |
| 2024-06-18 | ABLVW | Stock | 0.04 | 0.05 | 0.04 | 0.05 | 3879.0 |
| 2024-06-18 | ABM | Stock | 50.69 | 51.07 | 50.38 | 50.7 | 608700.0 |
| 2024-06-18 | ABNB | Stock | 149.9 | 150.549 | 146.9 | 147.29 | 3316700.0 |
| 2024-06-18 | ABOS | Stock | 2.49 | 2.5 | 2.33 | 2.33 | 408500.0 |
| 2024-06-18 | ABR | Stock | 14.0 | 14.08 | 13.92 | 13.96 | 1429600.0 |
| 2024-06-18 | ABR.D | Stock | 18.6 | 18.6 | 18.5731 | 18.5746 | 2985.0 |
| 2024-06-18 | ABR.E | Stock | 18.2 | 18.21 | 18.1101 | 18.2 | 5369.0 |
| 2024-06-18 | ABR.F | Stock | 19.98 | 20.06 | 19.92 | 19.93 | 12304.0 |
| 2024-06-18 | ABSI | Stock | 3.42 | 3.59 | 3.35 | 3.48 | 1491300.0 |
| 2024-06-18 | ABT | Stock | 103.26 | 104.09 | 103.25 | 103.99 | 4501000.0 |
| 2024-06-18 | ABTC | Stock | 96.75 | 96.75 | 90.0 | 93.75 | 3241.3333333333335 |
| 2024-06-18 | ABTS | Stock | 8.25 | 8.37 | 7.83 | 8.325 | 1193.0 |
> showing 50 of 7,230 rows — these rows as CSV