PREVIEW / stock_daily / 2024-01-08
file: by_date/stock_daily/2024/2024-01-08.parquet size: 235 KB rows: 7,286 symbols: 1,176
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-08 | AAPL | Stock | 182.09 | 185.6 | 181.5 | 185.56 | 59144500.0 |
| 2024-01-08 | MSFT | Stock | 369.3 | 375.2 | 369.01 | 374.69 | 23134000.0 |
| 2024-01-08 | NVDA | Stock | 49.512 | 52.275 | 49.479 | 52.253 | 642510000.0 |
| 2024-01-08 | AMZN | Stock | 146.74 | 149.4 | 146.15 | 149.1 | 46757100.0 |
| 2024-01-08 | GOOGL | Stock | 136.29 | 139.01 | 136.26 | 138.84 | 21403982.0 |
| 2024-01-08 | META | Stock | 354.7 | 358.98 | 352.05 | 358.66 | 13890200.0 |
| 2024-01-08 | TSLA | Stock | 236.14 | 241.25 | 235.3 | 240.45 | 85166600.0 |
| 2024-01-08 | TLT | Stock | 96.23 | 97.38 | 96.09 | 97.24 | 39485848.0 |
| 2024-01-08 | ES | Stock | 61.92 | 62.88 | 61.83 | 62.87 | 1806600.0 |
| 2024-01-08 | CL | Stock | 80.12 | 80.44 | 79.77 | 80.4 | 3703300.0 |
| 2024-01-08 | A | Stock | 130.14 | 133.57 | 129.81 | 133.38 | 1311400.0 |
| 2024-01-08 | AA | Stock | 31.82 | 32.09 | 31.22 | 31.73 | 4992100.0 |
| 2024-01-08 | AACG | Stock | 1.06 | 1.06 | 1.03 | 1.05 | 17600.0 |
| 2024-01-08 | AACT | Stock | 10.48 | 10.48 | 10.45 | 10.45 | 379100.0 |
| 2024-01-08 | AAGR-DELISTED | Stock | 1.06 | 1.07 | 0.96 | 1.0 | 272969.0 |
| 2024-01-08 | AAGRW-DELISTED | Stock | 0.0243 | 0.02799 | 0.0155 | 0.0155 | 2191.0 |
| 2024-01-08 | AAL | Stock | 14.03 | 14.67 | 14.02 | 14.58 | 61134100.0 |
| 2024-01-08 | AAMC-DELISTED | Stock | 4.08 | 4.363 | 3.529 | 4.28 | 32000.0 |
| 2024-01-08 | AAME | Stock | 2.5 | 2.54 | 2.42 | 2.52 | 7700.0 |
| 2024-01-08 | AAMI | Stock | 18.4 | 18.86 | 18.31 | 18.85 | 557000.0 |
| 2024-01-08 | AAN-DELISTED | Stock | 11.27 | 11.59 | 11.21 | 11.46 | 245700.0 |
| 2024-01-08 | AAOI | Stock | 20.1 | 21.28 | 19.48 | 20.18 | 2624300.0 |
| 2024-01-08 | AAON | Stock | 72.36 | 73.76 | 72.36 | 73.7 | 234500.0 |
| 2024-01-08 | AAP | Stock | 61.19 | 62.61 | 60.85 | 61.91 | 1390100.0 |
| 2024-01-08 | AAT | Stock | 22.74 | 23.31 | 22.71 | 23.23 | 198800.0 |
| 2024-01-08 | AATC | Stock | 7.05 | 7.15 | 7.03 | 7.12 | 24031.0 |
| 2024-01-08 | AAU-DELISTED | Stock | 0.132 | 0.139 | 0.1301 | 0.1317 | 87338.0 |
| 2024-01-08 | AAUAF-DELISTED | Stock | 0.132 | 0.139 | 0.1301 | 0.1317 | 89379.0 |
| 2024-01-08 | AAXJ | Stock | 64.3 | 64.96 | 64.02 | 64.93 | 1452409.0 |
| 2024-01-08 | AB | Stock | 31.2 | 31.53 | 30.83 | 31.25 | 464900.0 |
| 2024-01-08 | ABAT | Stock | 4.15 | 4.17 | 3.98 | 4.12 | 350337.0 |
| 2024-01-08 | ABBNY-DELISTED | Stock | 42.54 | 43.03 | 42.54 | 42.94 | 162490.0 |
| 2024-01-08 | ABBV | Stock | 162.18 | 162.77 | 159.78 | 161.43 | 6001600.0 |
| 2024-01-08 | ABCB | Stock | 50.67 | 51.6 | 50.32 | 51.59 | 313900.0 |
| 2024-01-08 | ABCL | Stock | 5.84 | 6.055 | 5.725 | 5.97 | 993400.0 |
| 2024-01-08 | ABEO | Stock | 5.61 | 5.86 | 5.5 | 5.84 | 248800.0 |
| 2024-01-08 | ABEV | Stock | 2.76 | 2.81 | 2.76 | 2.79 | 6167500.0 |
| 2024-01-08 | ABG | Stock | 205.79 | 209.1 | 204.28 | 208.75 | 107500.0 |
| 2024-01-08 | ABLLW | Stock | 0.9 | 0.93 | 0.86 | 0.89 | 93627.0 |
| 2024-01-08 | ABLV | Stock | 2.54 | 2.55 | 2.54 | 2.54 | 3100.0 |
| 2024-01-08 | ABLVW | Stock | 0.0199 | 0.02 | 0.01866 | 0.02 | 130912.0 |
| 2024-01-08 | ABM | Stock | 42.42 | 42.74 | 42.27 | 42.54 | 370600.0 |
| 2024-01-08 | ABNB | Stock | 137.31 | 140.25 | 136.61 | 140.08 | 4179700.0 |
| 2024-01-08 | ABOS | Stock | 3.99 | 4.25 | 3.86 | 4.22 | 374000.0 |
| 2024-01-08 | ABR | Stock | 14.51 | 14.7 | 14.31 | 14.68 | 3596200.0 |
| 2024-01-08 | ABR.D | Stock | 17.85 | 18.15 | 17.83 | 18.15 | 44714.0 |
| 2024-01-08 | ABR.E | Stock | 18.1278 | 18.23 | 17.995 | 18.23 | 4687.0 |
| 2024-01-08 | ABR.F | Stock | 18.84 | 18.9 | 18.78 | 18.87 | 20659.0 |
| 2024-01-08 | ABSI | Stock | 3.62 | 4.18 | 3.52 | 4.18 | 1501500.0 |
| 2024-01-08 | ABT | Stock | 111.13 | 112.52 | 110.92 | 112.4 | 5030400.0 |
> showing 50 of 7,286 rows — these rows as CSV