PREVIEW / stock_daily / 2024-01-12
file: by_date/stock_daily/2024/2024-01-12.parquet size: 233 KB rows: 7,238 symbols: 1,159
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-12 | AAPL | Stock | 186.06 | 186.74 | 185.19 | 185.92 | 40444700.0 |
| 2024-01-12 | MSFT | Stock | 385.49 | 388.68 | 384.65 | 388.47 | 21645700.0 |
| 2024-01-12 | NVDA | Stock | 54.62 | 54.97 | 54.33 | 54.71 | 352994000.0 |
| 2024-01-12 | AMZN | Stock | 155.39 | 156.2 | 154.01 | 154.62 | 40460300.0 |
| 2024-01-12 | GOOGL | Stock | 142.67 | 143.195 | 141.82 | 142.65 | 18785514.0 |
| 2024-01-12 | META | Stock | 370.16 | 377.06 | 369.54 | 374.49 | 19295700.0 |
| 2024-01-12 | TSLA | Stock | 220.08 | 225.34 | 217.15 | 218.89 | 122889000.0 |
| 2024-01-12 | TLT | Stock | 96.78 | 97.27 | 96.27 | 96.52 | 38883928.0 |
| 2024-01-12 | ES | Stock | 57.49 | 57.66 | 56.63 | 56.88 | 2195400.0 |
| 2024-01-12 | CL | Stock | 81.09 | 81.25 | 80.65 | 80.91 | 5562200.0 |
| 2024-01-12 | A | Stock | 130.31 | 131.61 | 129.64 | 130.54 | 1285200.0 |
| 2024-01-12 | AA | Stock | 31.19 | 31.82 | 30.02 | 30.03 | 3933500.0 |
| 2024-01-12 | AACG | Stock | 1.02 | 1.08 | 1.02 | 1.06 | 3900.0 |
| 2024-01-12 | AACT | Stock | 10.45 | 10.45 | 10.45 | 10.45 | 2300.0 |
| 2024-01-12 | AAGR-DELISTED | Stock | 0.8599 | 0.985 | 0.84 | 0.9516 | 177920.0 |
| 2024-01-12 | AAGRW-DELISTED | Stock | 0.0151 | 0.0151 | 0.0151 | 0.0151 | 477.0 |
| 2024-01-12 | AAL | Stock | 13.93 | 13.98 | 13.19 | 13.21 | 80445800.0 |
| 2024-01-12 | AAMC-DELISTED | Stock | 3.39 | 3.55 | 3.39 | 3.55 | 7500.0 |
| 2024-01-12 | AAME | Stock | 2.48 | 2.74 | 2.46 | 2.61 | 21200.0 |
| 2024-01-12 | AAMI | Stock | 19.61 | 19.8 | 19.19 | 19.29 | 263400.0 |
| 2024-01-12 | AAN-DELISTED | Stock | 11.0 | 11.09 | 10.395 | 10.46 | 162500.0 |
| 2024-01-12 | AAOI | Stock | 18.03 | 18.568 | 17.26 | 17.41 | 1901000.0 |
| 2024-01-12 | AAON | Stock | 72.27 | 73.07 | 70.23 | 70.82 | 186600.0 |
| 2024-01-12 | AAP | Stock | 62.81 | 64.22 | 61.3 | 61.3 | 1238800.0 |
| 2024-01-12 | AAT | Stock | 23.85 | 23.85 | 23.26 | 23.43 | 153800.0 |
| 2024-01-12 | AATC | Stock | 7.51 | 7.925 | 7.51 | 7.925 | 4533.0 |
| 2024-01-12 | AAU-DELISTED | Stock | 0.135 | 0.139 | 0.135 | 0.1351 | 411665.0 |
| 2024-01-12 | AAUAF-DELISTED | Stock | 0.135 | 0.139 | 0.135 | 0.135 | 412596.0 |
| 2024-01-12 | AAXJ | Stock | 64.9 | 64.98 | 64.445 | 64.54 | 1021246.0 |
| 2024-01-12 | AB | Stock | 33.0 | 33.28 | 32.8 | 33.19 | 402900.0 |
| 2024-01-12 | ABAT | Stock | 3.65 | 3.71 | 3.48 | 3.56 | 634783.0 |
| 2024-01-12 | ABBNY-DELISTED | Stock | 43.03 | 43.13 | 42.78 | 42.92 | 181484.0 |
| 2024-01-12 | ABBV | Stock | 162.75 | 163.3 | 162.18 | 162.4 | 4971100.0 |
| 2024-01-12 | ABCB | Stock | 51.78 | 51.85 | 49.95 | 50.76 | 330200.0 |
| 2024-01-12 | ABCL | Stock | 5.46 | 5.69 | 5.38 | 5.39 | 853500.0 |
| 2024-01-12 | ABEO | Stock | 5.29 | 5.38 | 5.2 | 5.25 | 140300.0 |
| 2024-01-12 | ABEV | Stock | 2.8 | 2.82 | 2.75 | 2.77 | 7750900.0 |
| 2024-01-12 | ABG | Stock | 211.85 | 212.24 | 200.1 | 202.23 | 148500.0 |
| 2024-01-12 | ABLLW | Stock | 0.97 | 0.9889 | 0.9191 | 0.93 | 26110.0 |
| 2024-01-12 | ABLV | Stock | 2.416 | 2.47 | 2.35 | 2.35 | 1600.0 |
| 2024-01-12 | ABLVW | Stock | 0.035 | 0.035 | 0.035 | 0.035 | 900.0 |
| 2024-01-12 | ABM | Stock | 42.87 | 42.88 | 41.91 | 42.07 | 315700.0 |
| 2024-01-12 | ABNB | Stock | 139.35 | 140.99 | 137.13 | 137.14 | 2480600.0 |
| 2024-01-12 | ABOS | Stock | 3.88 | 4.1 | 3.83 | 3.88 | 267800.0 |
| 2024-01-12 | ABR | Stock | 15.19 | 15.32 | 14.6 | 14.71 | 3557800.0 |
| 2024-01-12 | ABR.D | Stock | 17.9 | 17.98 | 17.63 | 17.82 | 30437.0 |
| 2024-01-12 | ABR.E | Stock | 17.8 | 17.83 | 17.66 | 17.72 | 7408.0 |
| 2024-01-12 | ABR.F | Stock | 18.63 | 18.75 | 18.5828 | 18.71 | 24197.0 |
| 2024-01-12 | ABSI | Stock | 4.13 | 4.38 | 3.94 | 3.99 | 1064900.0 |
| 2024-01-12 | ABT | Stock | 114.17 | 114.94 | 113.45 | 113.92 | 3884800.0 |
> showing 50 of 7,238 rows — these rows as CSV