PREVIEW / stock_daily / 2024-04-12
file: by_date/stock_daily/2024/2024-04-12.parquet size: 232 KB rows: 7,231 symbols: 1,009
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-04-12 | AAPL | Stock | 174.26 | 178.36 | 174.21 | 176.55 | 101593300.0 |
| 2024-04-12 | MSFT | Stock | 424.05 | 425.18 | 419.77 | 421.9 | 19232100.0 |
| 2024-04-12 | NVDA | Stock | 89.699 | 90.175 | 87.53 | 88.186 | 426805000.0 |
| 2024-04-12 | AMZN | Stock | 187.72 | 188.38 | 185.08 | 186.13 | 38554300.0 |
| 2024-04-12 | GOOGL | Stock | 157.96 | 160.2225 | 157.14 | 157.73 | 25353746.0 |
| 2024-04-12 | META | Stock | 517.75 | 520.19 | 509.33 | 511.9 | 11944900.0 |
| 2024-04-12 | TSLA | Stock | 172.34 | 173.81 | 170.36 | 171.05 | 64506600.0 |
| 2024-04-12 | TLT | Stock | 90.64 | 90.95 | 90.28 | 90.29 | 47900106.0 |
| 2024-04-12 | ES | Stock | 59.35 | 59.5 | 58.43 | 58.79 | 2204600.0 |
| 2024-04-12 | CL | Stock | 85.73 | 86.25 | 85.68 | 85.85 | 5907600.0 |
| 2024-04-12 | A | Stock | 143.59 | 144.66 | 140.26 | 140.73 | 1124500.0 |
| 2024-04-12 | AA | Stock | 37.47 | 38.03 | 34.96 | 35.2 | 7433200.0 |
| 2024-04-12 | AACG | Stock | 1.01 | 1.06 | 0.88 | 0.92 | 143400.0 |
| 2024-04-12 | AACIW-DELISTED | Stock | 0.1816 | 0.1816 | 0.1599 | 0.16 | 6125.0 |
| 2024-04-12 | AACT | Stock | 10.64 | 10.64 | 10.61 | 10.61 | 2500.0 |
| 2024-04-12 | AAGR-DELISTED | Stock | 0.4485 | 0.529 | 0.4006 | 0.469 | 436405.0 |
| 2024-04-12 | AAGRW-DELISTED | Stock | 0.0174 | 0.0174 | 0.0131 | 0.0135 | 2319.0 |
| 2024-04-12 | AAL | Stock | 13.24 | 13.3 | 13.02 | 13.15 | 35529200.0 |
| 2024-04-12 | AAMC-DELISTED | Stock | 3.6 | 3.785 | 3.375 | 3.785 | 9300.0 |
| 2024-04-12 | AAME | Stock | 2.24 | 2.24 | 2.17 | 2.19 | 3700.0 |
| 2024-04-12 | AAMI | Stock | 22.48 | 22.59 | 22.305 | 22.35 | 205600.0 |
| 2024-04-12 | AAN-DELISTED | Stock | 7.06 | 7.16 | 6.99 | 7.16 | 242000.0 |
| 2024-04-12 | AAOI | Stock | 11.68 | 11.82 | 11.21 | 11.23 | 1090200.0 |
| 2024-04-12 | AAON | Stock | 86.96 | 88.19 | 86.42 | 88.01 | 429300.0 |
| 2024-04-12 | AAP | Stock | 74.11 | 74.75 | 70.38 | 70.5 | 1580400.0 |
| 2024-04-12 | AAT | Stock | 21.04 | 21.04 | 20.65 | 20.77 | 291300.0 |
| 2024-04-12 | AATC | Stock | 6.4 | 6.427 | 6.3 | 6.3 | 7223.0 |
| 2024-04-12 | AAUAF-DELISTED | Stock | 0.125 | 0.129 | 0.115 | 0.1207 | 163417.0 |
| 2024-04-12 | AAXJ | Stock | 67.29 | 67.41 | 66.68 | 66.79 | 514332.0 |
| 2024-04-12 | AB | Stock | 33.0 | 33.52 | 32.74 | 33.15 | 292200.0 |
| 2024-04-12 | ABAT | Stock | 1.75 | 1.77 | 1.69 | 1.71 | 513284.0 |
| 2024-04-12 | ABBV | Stock | 164.45 | 164.45 | 160.0 | 162.28 | 7029400.0 |
| 2024-04-12 | ABCB | Stock | 44.72 | 45.25 | 44.64 | 45.16 | 213800.0 |
| 2024-04-12 | ABCL | Stock | 4.35 | 4.42 | 4.25 | 4.34 | 1009900.0 |
| 2024-04-12 | ABEO | Stock | 7.69 | 7.84 | 7.43 | 7.55 | 188000.0 |
| 2024-04-12 | ABEV | Stock | 2.37 | 2.37 | 2.33 | 2.35 | 9751600.0 |
| 2024-04-12 | ABG | Stock | 220.19 | 220.19 | 216.6 | 217.51 | 182000.0 |
| 2024-04-12 | ABLLW | Stock | 0.5247 | 0.6 | 0.4236 | 0.54 | 86208.0 |
| 2024-04-12 | ABLV | Stock | 2.035 | 2.15 | 1.905 | 1.971 | 117000.0 |
| 2024-04-12 | ABM | Stock | 43.68 | 44.09 | 43.34 | 43.57 | 387600.0 |
| 2024-04-12 | ABNB | Stock | 162.42 | 162.712 | 158.78 | 159.37 | 3699900.0 |
| 2024-04-12 | ABOS | Stock | 3.85 | 3.93 | 3.705 | 3.74 | 184200.0 |
| 2024-04-12 | ABR | Stock | 12.18 | 12.38 | 12.11 | 12.2 | 3397700.0 |
| 2024-04-12 | ABR.D | Stock | 18.48 | 18.8555 | 18.48 | 18.55 | 14535.0 |
| 2024-04-12 | ABR.E | Stock | 18.59 | 18.83 | 18.42 | 18.48 | 5595.0 |
| 2024-04-12 | ABR.F | Stock | 19.4 | 19.4 | 19.2 | 19.21 | 29674.0 |
| 2024-04-12 | ABSI | Stock | 6.01 | 6.02 | 5.65 | 5.83 | 1271600.0 |
| 2024-04-12 | ABT | Stock | 110.27 | 110.5 | 108.49 | 109.11 | 4041500.0 |
| 2024-04-12 | ABTC | Stock | 120.0 | 126.67500000000001 | 107.25 | 110.25 | 3213.3333333333335 |
| 2024-04-12 | ABTS | Stock | 10.5 | 11.7 | 10.5 | 11.25 | 30687.0 |
> showing 50 of 7,231 rows — these rows as CSV