PREVIEW / stock_daily / 2024-03-18
file: by_date/stock_daily/2024/2024-03-18.parquet size: 234 KB rows: 7,309 symbols: 1,077
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-03-18 | AAPL | Stock | 175.57 | 177.71 | 173.52 | 173.72 | 75604200.0 |
| 2024-03-18 | MSFT | Stock | 414.25 | 420.73 | 413.78 | 417.32 | 20106000.0 |
| 2024-03-18 | NVDA | Stock | 90.388 | 92.405 | 87.085 | 88.455 | 668976000.0 |
| 2024-03-18 | AMZN | Stock | 175.8 | 176.69 | 174.28 | 174.48 | 31250700.0 |
| 2024-03-18 | GOOGL | Stock | 148.61 | 152.15 | 147.17 | 147.68 | 69273699.0 |
| 2024-03-18 | META | Stock | 491.91 | 497.42 | 486.81 | 496.98 | 11755300.0 |
| 2024-03-18 | TSLA | Stock | 170.02 | 174.72 | 165.9 | 173.8 | 108214400.0 |
| 2024-03-18 | TLT | Stock | 92.73 | 92.99 | 92.5 | 92.66 | 29519539.0 |
| 2024-03-18 | ES | Stock | 58.92 | 59.37 | 58.42 | 58.96 | 2246500.0 |
| 2024-03-18 | CL | Stock | 88.25 | 88.98 | 88.09 | 88.27 | 3430700.0 |
| 2024-03-18 | A | Stock | 147.88 | 148.36 | 145.9 | 146.09 | 2281300.0 |
| 2024-03-18 | AA | Stock | 30.94 | 31.66 | 30.79 | 31.03 | 6844400.0 |
| 2024-03-18 | AACG | Stock | 1.65 | 1.65 | 1.4 | 1.55 | 44800.0 |
| 2024-03-18 | AACIU | Stock | 11.12 | 11.12 | 11.12 | 11.12 | 574.0 |
| 2024-03-18 | AACIW-DELISTED | Stock | 0.04 | 0.0785 | 0.04 | 0.07 | 76786.0 |
| 2024-03-18 | AACT | Stock | 10.55 | 10.57 | 10.55 | 10.57 | 156300.0 |
| 2024-03-18 | AAGR-DELISTED | Stock | 0.48 | 0.5 | 0.4493 | 0.4792 | 76107.0 |
| 2024-03-18 | AAGRW-DELISTED | Stock | 0.0191 | 0.0191 | 0.0162 | 0.0162 | 990.0 |
| 2024-03-18 | AAL | Stock | 13.98 | 14.17 | 13.86 | 14.11 | 23693800.0 |
| 2024-03-18 | AAMC-DELISTED | Stock | 3.71 | 5.0 | 3.55 | 3.98 | 73300.0 |
| 2024-03-18 | AAME | Stock | 2.72 | 2.87 | 2.68 | 2.68 | 10000.0 |
| 2024-03-18 | AAMI | Stock | 22.54 | 22.65 | 22.42 | 22.43 | 184500.0 |
| 2024-03-18 | AAN-DELISTED | Stock | 6.96 | 7.0 | 6.785 | 6.81 | 286200.0 |
| 2024-03-18 | AAOI | Stock | 12.72 | 13.205 | 12.38 | 12.98 | 1940000.0 |
| 2024-03-18 | AAON | Stock | 82.29 | 83.98 | 81.82 | 82.89 | 514100.0 |
| 2024-03-18 | AAP | Stock | 82.07 | 84.46 | 81.0 | 84.19 | 2178600.0 |
| 2024-03-18 | AAT | Stock | 21.17 | 21.24 | 21.03 | 21.11 | 338200.0 |
| 2024-03-18 | AATC | Stock | 7.27 | 7.43 | 7.03 | 7.3 | 22147.0 |
| 2024-03-18 | AAU-DELISTED | Stock | 0.14 | 0.1408 | 0.14 | 0.1406 | 308312.0 |
| 2024-03-18 | AAUAF-DELISTED | Stock | 0.14 | 0.1408 | 0.14 | 0.1406 | 297799.0 |
| 2024-03-18 | AAXJ | Stock | 67.84 | 67.99 | 67.59 | 67.65 | 399764.0 |
| 2024-03-18 | AB | Stock | 33.37 | 33.77 | 33.2 | 33.48 | 183200.0 |
| 2024-03-18 | ABAT | Stock | 2.03 | 2.28 | 2.01 | 2.17 | 485374.0 |
| 2024-03-18 | ABBV | Stock | 179.01 | 179.88 | 177.57 | 178.49 | 8569000.0 |
| 2024-03-18 | ABCB | Stock | 45.79 | 46.09 | 45.17 | 45.89 | 576800.0 |
| 2024-03-18 | ABCL | Stock | 4.785 | 4.785 | 4.53 | 4.59 | 1094800.0 |
| 2024-03-18 | ABEO | Stock | 7.9 | 7.94 | 6.65 | 6.99 | 1397800.0 |
| 2024-03-18 | ABEV | Stock | 2.5 | 2.51 | 2.47 | 2.51 | 12176200.0 |
| 2024-03-18 | ABG | Stock | 211.09 | 211.27 | 208.06 | 208.27 | 130900.0 |
| 2024-03-18 | ABLLW | Stock | 0.594 | 0.6 | 0.55 | 0.5999 | 12864.0 |
| 2024-03-18 | ABLV | Stock | 3.01 | 3.02 | 2.99 | 2.99 | 5300.0 |
| 2024-03-18 | ABM | Stock | 42.28 | 42.94 | 42.28 | 42.8 | 775700.0 |
| 2024-03-18 | ABNB | Stock | 161.945 | 162.87 | 160.6 | 161.86 | 4296900.0 |
| 2024-03-18 | ABOS | Stock | 4.23 | 4.23 | 3.975 | 3.98 | 261300.0 |
| 2024-03-18 | ABR | Stock | 12.9 | 13.0 | 12.76 | 12.79 | 2794900.0 |
| 2024-03-18 | ABR.D | Stock | 18.417 | 18.45 | 18.3 | 18.4 | 16782.0 |
| 2024-03-18 | ABR.E | Stock | 18.4251 | 18.75 | 18.4251 | 18.75 | 3212.0 |
| 2024-03-18 | ABR.F | Stock | 19.0 | 19.18 | 19.0 | 19.18 | 19261.0 |
| 2024-03-18 | ABSI | Stock | 4.94 | 4.94 | 4.58 | 4.66 | 991500.0 |
| 2024-03-18 | ABT | Stock | 115.35 | 115.76 | 112.29 | 112.44 | 12991000.0 |
> showing 50 of 7,309 rows — these rows as CSV