PREVIEW / stock_daily / 2024-01-25
file: by_date/stock_daily/2024/2024-01-25.parquet size: 233 KB rows: 7,270 symbols: 1,157
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-01-25 | AAPL | Stock | 195.22 | 196.27 | 193.11 | 194.17 | 54822100.0 |
| 2024-01-25 | MSFT | Stock | 404.32 | 407.01 | 402.53 | 404.87 | 21021200.0 |
| 2024-01-25 | NVDA | Stock | 62.35 | 62.719 | 60.85 | 61.617 | 482777000.0 |
| 2024-01-25 | AMZN | Stock | 156.95 | 158.51 | 154.55 | 157.75 | 43638600.0 |
| 2024-01-25 | GOOGL | Stock | 150.065 | 153.05 | 149.54 | 151.87 | 29149069.0 |
| 2024-01-25 | META | Stock | 390.17 | 395.49 | 385.66 | 393.18 | 15091100.0 |
| 2024-01-25 | TSLA | Stock | 189.7 | 193.0 | 180.06 | 182.63 | 198076800.0 |
| 2024-01-25 | TLT | Stock | 94.0 | 94.216 | 93.57 | 93.96 | 57019409.0 |
| 2024-01-25 | ES | Stock | 54.47 | 55.06 | 53.87 | 54.86 | 4503500.0 |
| 2024-01-25 | CL | Stock | 80.24 | 81.44 | 80.03 | 81.22 | 7526400.0 |
| 2024-01-25 | A | Stock | 131.11 | 131.43 | 129.43 | 129.88 | 1120900.0 |
| 2024-01-25 | AA | Stock | 29.96 | 30.45 | 29.21 | 29.88 | 4683300.0 |
| 2024-01-25 | AACG | Stock | 1.03 | 1.11 | 1.03 | 1.11 | 21300.0 |
| 2024-01-25 | AACT | Stock | 10.48 | 10.48 | 10.48 | 10.48 | 25000.0 |
| 2024-01-25 | AAGR-DELISTED | Stock | 0.9293 | 0.978 | 0.87 | 0.94 | 104658.0 |
| 2024-01-25 | AAL | Stock | 14.59 | 15.46 | 14.52 | 15.36 | 96168300.0 |
| 2024-01-25 | AAMC-DELISTED | Stock | 5.13 | 5.35 | 5.1 | 5.14 | 7900.0 |
| 2024-01-25 | AAME | Stock | 2.59 | 2.66 | 2.54 | 2.66 | 6300.0 |
| 2024-01-25 | AAMI | Stock | 22.09 | 22.33 | 21.81 | 22.12 | 381800.0 |
| 2024-01-25 | AAN-DELISTED | Stock | 10.69 | 10.79 | 10.63 | 10.72 | 164300.0 |
| 2024-01-25 | AAOI | Stock | 16.89 | 17.13 | 16.15 | 16.34 | 1694100.0 |
| 2024-01-25 | AAON | Stock | 70.98 | 71.17 | 69.61 | 70.24 | 295500.0 |
| 2024-01-25 | AAP | Stock | 66.21 | 67.73 | 65.19 | 66.13 | 919800.0 |
| 2024-01-25 | AAT | Stock | 23.77 | 23.82 | 23.55 | 23.75 | 512500.0 |
| 2024-01-25 | AATC | Stock | 7.98 | 8.06 | 7.98 | 8.06 | 12451.0 |
| 2024-01-25 | AAU-DELISTED | Stock | 0.135 | 0.1359 | 0.134 | 0.1351 | 184557.0 |
| 2024-01-25 | AAUAF-DELISTED | Stock | 0.135 | 0.1359 | 0.134 | 0.1351 | 179019.0 |
| 2024-01-25 | AAXJ | Stock | 64.22 | 64.38 | 63.8913 | 64.04 | 1098411.0 |
| 2024-01-25 | AB | Stock | 33.94 | 34.33 | 33.55 | 34.01 | 255600.0 |
| 2024-01-25 | ABAT | Stock | 2.7 | 2.78 | 2.5 | 2.78 | 777174.0 |
| 2024-01-25 | ABBNY-DELISTED | Stock | 42.09 | 42.26 | 41.9 | 42.25 | 552107.0 |
| 2024-01-25 | ABBV | Stock | 164.0 | 165.21 | 163.2 | 165.13 | 4465800.0 |
| 2024-01-25 | ABCB | Stock | 53.89 | 53.89 | 52.04 | 52.77 | 634700.0 |
| 2024-01-25 | ABCL | Stock | 5.31 | 5.4 | 5.25 | 5.32 | 948300.0 |
| 2024-01-25 | ABEO | Stock | 4.76 | 4.82 | 4.73 | 4.76 | 68000.0 |
| 2024-01-25 | ABEV | Stock | 2.67 | 2.68 | 2.65 | 2.67 | 6721600.0 |
| 2024-01-25 | ABG | Stock | 208.99 | 211.8 | 205.37 | 211.59 | 233100.0 |
| 2024-01-25 | ABLLW | Stock | 0.925 | 0.97 | 0.92 | 0.9203 | 308903.0 |
| 2024-01-25 | ABLV | Stock | 2.19 | 2.625 | 2.19 | 2.52 | 11300.0 |
| 2024-01-25 | ABM | Stock | 42.61 | 42.72 | 41.56 | 41.93 | 261700.0 |
| 2024-01-25 | ABNB | Stock | 143.2 | 143.29 | 140.368 | 142.11 | 3677500.0 |
| 2024-01-25 | ABOS | Stock | 3.28 | 3.375 | 3.16 | 3.25 | 321500.0 |
| 2024-01-25 | ABR | Stock | 13.62 | 13.73 | 13.47 | 13.62 | 4753300.0 |
| 2024-01-25 | ABR.D | Stock | 17.7848 | 17.82 | 17.64 | 17.71 | 44847.0 |
| 2024-01-25 | ABR.E | Stock | 17.62 | 17.73 | 17.55 | 17.55 | 8013.0 |
| 2024-01-25 | ABR.F | Stock | 18.7 | 18.99 | 18.6 | 18.77 | 53706.0 |
| 2024-01-25 | ABSI | Stock | 3.56 | 3.66 | 3.39 | 3.65 | 1098900.0 |
| 2024-01-25 | ABT | Stock | 111.41 | 112.57 | 110.79 | 112.45 | 5648600.0 |
| 2024-01-25 | ABTC | Stock | 421.5 | 510.0 | 412.5 | 504.0 | 306.93333333333334 |
| 2024-01-25 | ABTS | Stock | 16.5 | 16.5 | 14.85 | 15.0 | 6907.0 |
> showing 50 of 7,270 rows — these rows as CSV