PREVIEW / stock_daily / 2024-02-07
file: by_date/stock_daily/2024/2024-02-07.parquet size: 234 KB rows: 7,276 symbols: 1,153
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-07 | AAPL | Stock | 190.64 | 191.05 | 188.61 | 189.41 | 53439000.0 |
| 2024-02-07 | MSFT | Stock | 407.44 | 414.3 | 407.4 | 414.05 | 22340500.0 |
| 2024-02-07 | NVDA | Stock | 68.319 | 70.22 | 67.6 | 70.099 | 495575000.0 |
| 2024-02-07 | AMZN | Stock | 169.48 | 170.88 | 168.94 | 170.53 | 47174100.0 |
| 2024-02-07 | GOOGL | Stock | 144.76 | 145.615 | 143.925 | 145.54 | 25208862.0 |
| 2024-02-07 | META | Stock | 458.0 | 471.52 | 456.18 | 469.59 | 23066000.0 |
| 2024-02-07 | TSLA | Stock | 188.18 | 189.79 | 182.68 | 187.58 | 111535200.0 |
| 2024-02-07 | TLT | Stock | 94.57 | 95.23 | 94.52 | 94.59 | 40120215.0 |
| 2024-02-07 | ES | Stock | 53.92 | 53.97 | 53.01 | 53.79 | 2379600.0 |
| 2024-02-07 | CL | Stock | 84.09 | 84.29 | 83.6 | 83.86 | 5530400.0 |
| 2024-02-07 | A | Stock | 136.52 | 136.91 | 132.34 | 132.79 | 1758000.0 |
| 2024-02-07 | AA | Stock | 27.6 | 27.765 | 26.93 | 27.53 | 5017200.0 |
| 2024-02-07 | AACG | Stock | 1.09 | 1.2 | 1.09 | 1.16 | 62400.0 |
| 2024-02-07 | AACT | Stock | 10.51 | 10.52 | 10.5 | 10.5 | 1300500.0 |
| 2024-02-07 | AAGR-DELISTED | Stock | 0.96 | 0.97 | 0.84 | 0.9099 | 151020.0 |
| 2024-02-07 | AAGRW-DELISTED | Stock | 0.035 | 0.035 | 0.0231 | 0.0231 | 20025.0 |
| 2024-02-07 | AAL | Stock | 14.92 | 15.03 | 14.71 | 14.91 | 31178200.0 |
| 2024-02-07 | AAMC-DELISTED | Stock | 4.7 | 4.722 | 4.28 | 4.52 | 21000.0 |
| 2024-02-07 | AAME | Stock | 2.6 | 2.6 | 2.4 | 2.4 | 3700.0 |
| 2024-02-07 | AAMI | Stock | 20.58 | 21.215 | 20.46 | 20.86 | 616600.0 |
| 2024-02-07 | AAN-DELISTED | Stock | 10.39 | 10.39 | 10.1 | 10.15 | 165700.0 |
| 2024-02-07 | AAOI | Stock | 19.19 | 19.92 | 18.76 | 19.13 | 2039900.0 |
| 2024-02-07 | AAON | Stock | 72.62 | 75.56 | 72.28 | 75.33 | 357800.0 |
| 2024-02-07 | AAP | Stock | 66.4 | 66.76 | 65.2 | 66.09 | 1087600.0 |
| 2024-02-07 | AAT | Stock | 21.66 | 21.84 | 21.18 | 21.61 | 527600.0 |
| 2024-02-07 | AATC | Stock | 6.95 | 7.0 | 6.8 | 6.98 | 21829.0 |
| 2024-02-07 | AAU-DELISTED | Stock | 0.135 | 0.1358 | 0.135 | 0.135 | 256679.0 |
| 2024-02-07 | AAUAF-DELISTED | Stock | 0.135 | 0.1358 | 0.135 | 0.135 | 257737.0 |
| 2024-02-07 | AAXJ | Stock | 65.08 | 65.31 | 64.96 | 65.14 | 370052.0 |
| 2024-02-07 | AB | Stock | 34.09 | 34.75 | 32.26 | 33.15 | 842200.0 |
| 2024-02-07 | ABAT | Stock | 2.74 | 2.7499 | 2.48 | 2.48 | 729763.0 |
| 2024-02-07 | ABBV | Stock | 174.01 | 175.56 | 173.32 | 175.01 | 6409100.0 |
| 2024-02-07 | ABCB | Stock | 46.93 | 47.23 | 45.79 | 47.05 | 409500.0 |
| 2024-02-07 | ABCL | Stock | 5.18 | 5.19 | 4.88 | 4.91 | 1125200.0 |
| 2024-02-07 | ABEO | Stock | 4.53 | 5.04 | 4.4 | 4.9 | 459400.0 |
| 2024-02-07 | ABEV | Stock | 2.63 | 2.64 | 2.57 | 2.59 | 27160700.0 |
| 2024-02-07 | ABG | Stock | 211.07 | 211.88 | 207.2 | 210.74 | 252400.0 |
| 2024-02-07 | ABLLW | Stock | 0.9 | 0.9 | 0.88 | 0.9 | 36647.0 |
| 2024-02-07 | ABLV | Stock | 2.929 | 2.963 | 2.81 | 2.93 | 177900.0 |
| 2024-02-07 | ABM | Stock | 40.65 | 40.65 | 39.96 | 40.25 | 272900.0 |
| 2024-02-07 | ABNB | Stock | 145.12 | 148.77 | 143.86 | 147.55 | 4214100.0 |
| 2024-02-07 | ABOS | Stock | 3.2 | 3.258 | 3.09 | 3.14 | 265500.0 |
| 2024-02-07 | ABR | Stock | 12.58 | 12.59 | 12.0 | 12.25 | 9332600.0 |
| 2024-02-07 | ABR.D | Stock | 17.6833 | 17.6833 | 17.2002 | 17.4 | 9390.0 |
| 2024-02-07 | ABR.E | Stock | 17.3 | 17.47 | 17.0 | 17.326 | 3645.0 |
| 2024-02-07 | ABR.F | Stock | 18.49 | 18.49 | 18.15 | 18.15 | 26380.0 |
| 2024-02-07 | ABSI | Stock | 4.35 | 4.35 | 3.901 | 3.97 | 975000.0 |
| 2024-02-07 | ABT | Stock | 114.6 | 114.6 | 112.89 | 113.31 | 4757500.0 |
| 2024-02-07 | ABTC | Stock | 391.5 | 391.5 | 327.0 | 343.5 | 413.5333333333333 |
| 2024-02-07 | ABTS | Stock | 14.4 | 14.4 | 13.65 | 13.8 | 2040.0 |
> showing 50 of 7,276 rows — these rows as CSV