PREVIEW / stock_daily / 2024-02-20
file: by_date/stock_daily/2024/2024-02-20.parquet size: 234 KB rows: 7,288 symbols: 1,117
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-02-20 | AAPL | Stock | 181.79 | 182.43 | 180.0 | 181.56 | 53665600.0 |
| 2024-02-20 | MSFT | Stock | 403.24 | 404.49 | 398.01 | 402.79 | 24307900.0 |
| 2024-02-20 | NVDA | Stock | 71.947 | 71.956 | 67.734 | 69.452 | 704833000.0 |
| 2024-02-20 | AMZN | Stock | 167.83 | 168.71 | 165.74 | 167.08 | 41980300.0 |
| 2024-02-20 | GOOGL | Stock | 139.655 | 142.08 | 139.49 | 141.12 | 24935710.0 |
| 2024-02-20 | META | Stock | 469.72 | 476.18 | 466.56 | 471.75 | 18015500.0 |
| 2024-02-20 | TSLA | Stock | 196.13 | 198.6 | 189.13 | 193.76 | 104545800.0 |
| 2024-02-20 | TLT | Stock | 92.79 | 93.19 | 92.72 | 92.84 | 24469329.0 |
| 2024-02-20 | ES | Stock | 58.71 | 59.55 | 57.51 | 57.52 | 3555300.0 |
| 2024-02-20 | CL | Stock | 83.95 | 85.13 | 83.7 | 84.61 | 5404600.0 |
| 2024-02-20 | A | Stock | 133.67 | 135.33 | 133.57 | 134.14 | 1563900.0 |
| 2024-02-20 | AA | Stock | 26.88 | 26.88 | 26.16 | 26.69 | 4711800.0 |
| 2024-02-20 | AACG | Stock | 1.38 | 1.42 | 1.31 | 1.34 | 9200.0 |
| 2024-02-20 | AACT | Stock | 10.53 | 10.56 | 10.52 | 10.54 | 307800.0 |
| 2024-02-20 | AAGR-DELISTED | Stock | 0.8002 | 0.8499 | 0.7712 | 0.8 | 134695.0 |
| 2024-02-20 | AAGRW-DELISTED | Stock | 0.016 | 0.02 | 0.015 | 0.02 | 14110.0 |
| 2024-02-20 | AAL | Stock | 14.5 | 14.95 | 14.49 | 14.7 | 30253100.0 |
| 2024-02-20 | AAMC-DELISTED | Stock | 4.39 | 4.44 | 4.36 | 4.36 | 1600.0 |
| 2024-02-20 | AAME | Stock | 2.51 | 2.58 | 2.38 | 2.51 | 12400.0 |
| 2024-02-20 | AAMI | Stock | 21.37 | 22.52 | 21.37 | 22.41 | 523200.0 |
| 2024-02-20 | AAN-DELISTED | Stock | 10.31 | 10.61 | 10.3 | 10.52 | 155400.0 |
| 2024-02-20 | AAOI | Stock | 20.72 | 21.34 | 18.87 | 19.83 | 2849300.0 |
| 2024-02-20 | AAON | Stock | 83.28 | 83.67 | 81.25 | 81.75 | 566900.0 |
| 2024-02-20 | AAP | Stock | 64.43 | 65.07 | 61.75 | 61.81 | 1914300.0 |
| 2024-02-20 | AAT | Stock | 21.49 | 21.92 | 21.49 | 21.63 | 206500.0 |
| 2024-02-20 | AATC | Stock | 6.97 | 7.36 | 6.97 | 7.3375 | 24204.0 |
| 2024-02-20 | AAU-DELISTED | Stock | 0.135 | 0.1359 | 0.135 | 0.135 | 75925.0 |
| 2024-02-20 | AAUAF-DELISTED | Stock | 0.135 | 0.1359 | 0.135 | 0.1351 | 78576.0 |
| 2024-02-20 | AAXJ | Stock | 66.07 | 66.3 | 65.77 | 65.92 | 782373.0 |
| 2024-02-20 | AB | Stock | 32.7 | 33.4 | 32.55 | 32.59 | 259900.0 |
| 2024-02-20 | ABAT | Stock | 2.0 | 2.005 | 1.85 | 1.96 | 987370.0 |
| 2024-02-20 | ABBV | Stock | 175.83 | 178.68 | 175.52 | 175.75 | 5484100.0 |
| 2024-02-20 | ABCB | Stock | 46.65 | 47.16 | 46.09 | 46.5 | 346900.0 |
| 2024-02-20 | ABCL | Stock | 5.4 | 5.45 | 5.225 | 5.31 | 1397400.0 |
| 2024-02-20 | ABEO | Stock | 7.1 | 7.5 | 6.16 | 6.74 | 477000.0 |
| 2024-02-20 | ABEV | Stock | 2.61 | 2.63 | 2.56 | 2.56 | 24204300.0 |
| 2024-02-20 | ABG | Stock | 212.2 | 214.1 | 207.59 | 208.18 | 159000.0 |
| 2024-02-20 | ABLLW | Stock | 0.75 | 0.85 | 0.74 | 0.85 | 122746.0 |
| 2024-02-20 | ABLV | Stock | 2.51 | 2.68 | 2.48 | 2.63 | 45000.0 |
| 2024-02-20 | ABM | Stock | 40.14 | 40.71 | 39.77 | 40.43 | 659300.0 |
| 2024-02-20 | ABNB | Stock | 150.31 | 150.68 | 145.88 | 148.15 | 5229700.0 |
| 2024-02-20 | ABOS | Stock | 3.24 | 3.41 | 3.24 | 3.32 | 272000.0 |
| 2024-02-20 | ABR | Stock | 13.82 | 13.95 | 13.22 | 13.41 | 10606300.0 |
| 2024-02-20 | ABR.D | Stock | 17.76 | 17.9725 | 17.7593 | 17.9539 | 33686.0 |
| 2024-02-20 | ABR.E | Stock | 18.18 | 18.2 | 17.7501 | 18.2 | 7879.0 |
| 2024-02-20 | ABR.F | Stock | 18.67 | 18.84 | 18.5667 | 18.68 | 91250.0 |
| 2024-02-20 | ABSI | Stock | 5.3 | 5.3 | 4.64 | 4.81 | 2080700.0 |
| 2024-02-20 | ABT | Stock | 114.33 | 117.19 | 113.96 | 116.64 | 9601100.0 |
| 2024-02-20 | ABTC | Stock | 150.0 | 206.25 | 141.75 | 177.0 | 16309.333333333334 |
| 2024-02-20 | ABTS | Stock | 15.9 | 15.9 | 14.7 | 14.745 | 2387.0 |
> showing 50 of 7,288 rows — these rows as CSV