PREVIEW / stock_daily / 2024-05-20
file: by_date/stock_daily/2024/2024-05-20.parquet size: 231 KB rows: 7,208 symbols: 969
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-05-20 | AAPL | Stock | 189.33 | 191.92 | 189.01 | 191.04 | 44361300.0 |
| 2024-05-20 | MSFT | Stock | 420.21 | 426.77 | 419.99 | 425.34 | 16272100.0 |
| 2024-05-20 | NVDA | Stock | 93.75 | 95.2 | 93.44 | 94.78 | 318764000.0 |
| 2024-05-20 | AMZN | Stock | 184.34 | 186.67 | 183.28 | 183.54 | 30511800.0 |
| 2024-05-20 | GOOGL | Stock | 176.192 | 178.77 | 176.08 | 176.92 | 22554400.0 |
| 2024-05-20 | META | Stock | 469.95 | 473.2 | 467.04 | 468.84 | 11745100.0 |
| 2024-05-20 | TSLA | Stock | 177.56 | 177.75 | 173.52 | 174.95 | 61727400.0 |
| 2024-05-20 | TLT | Stock | 91.08 | 91.315 | 91.01 | 91.12 | 17922808.0 |
| 2024-05-20 | ES | Stock | 61.0 | 61.01 | 60.61 | 60.78 | 980500.0 |
| 2024-05-20 | CL | Stock | 94.13 | 94.54 | 93.81 | 94.39 | 3900100.0 |
| 2024-05-20 | A | Stock | 153.97 | 154.95 | 153.47 | 154.64 | 906200.0 |
| 2024-05-20 | AA | Stock | 41.17 | 42.84 | 41.02 | 42.53 | 7220300.0 |
| 2024-05-20 | AACG | Stock | 0.91 | 0.94 | 0.9 | 0.91 | 8600.0 |
| 2024-05-20 | AACIW-DELISTED | Stock | 0.13 | 0.13845 | 0.13 | 0.13845 | 12499.0 |
| 2024-05-20 | AACT | Stock | 10.64 | 10.64 | 10.62 | 10.62 | 8500.0 |
| 2024-05-20 | AAGR-DELISTED | Stock | 0.382 | 0.3899 | 0.3325 | 0.3451 | 94675.0 |
| 2024-05-20 | AAGRW-DELISTED | Stock | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 2324.0 |
| 2024-05-20 | AAL | Stock | 14.77 | 14.78 | 14.42 | 14.52 | 26818800.0 |
| 2024-05-20 | AAMC-DELISTED | Stock | 2.88 | 2.88 | 2.55 | 2.67 | 11500.0 |
| 2024-05-20 | AAME | Stock | 1.73 | 1.84 | 1.62 | 1.64 | 8400.0 |
| 2024-05-20 | AAMI | Stock | 22.87 | 22.87 | 22.335 | 22.36 | 192900.0 |
| 2024-05-20 | AAN-DELISTED | Stock | 7.58 | 7.68 | 7.53 | 7.63 | 139400.0 |
| 2024-05-20 | AAOI | Stock | 11.7 | 12.463 | 11.63 | 12.4 | 1946200.0 |
| 2024-05-20 | AAON | Stock | 75.06 | 76.27 | 74.88 | 74.98 | 423900.0 |
| 2024-05-20 | AAP | Stock | 74.47 | 74.59 | 72.33 | 72.65 | 1442800.0 |
| 2024-05-20 | AAT | Stock | 22.9 | 22.97 | 22.16 | 22.16 | 295600.0 |
| 2024-05-20 | AATC | Stock | 6.43 | 6.5805 | 6.2305 | 6.38 | 43418.0 |
| 2024-05-20 | AAUAF-DELISTED | Stock | 0.1219 | 0.13 | 0.1219 | 0.1219 | 68628.0 |
| 2024-05-20 | AAXJ | Stock | 73.05 | 73.245 | 72.97 | 73.11 | 347985.0 |
| 2024-05-20 | AB | Stock | 33.85 | 34.11 | 33.68 | 33.91 | 201600.0 |
| 2024-05-20 | ABAT | Stock | 1.53 | 1.54 | 1.37 | 1.42 | 725717.0 |
| 2024-05-20 | ABBV | Stock | 166.01 | 166.42 | 164.41 | 164.56 | 3058700.0 |
| 2024-05-20 | ABCB | Stock | 50.32 | 50.81 | 49.52 | 49.54 | 187100.0 |
| 2024-05-20 | ABCL | Stock | 3.65 | 3.76 | 3.58 | 3.74 | 1034300.0 |
| 2024-05-20 | ABEO | Stock | 4.67 | 4.67 | 4.34 | 4.45 | 474300.0 |
| 2024-05-20 | ABEV | Stock | 2.38 | 2.41 | 2.34 | 2.34 | 22083700.0 |
| 2024-05-20 | ABG | Stock | 240.14 | 242.0 | 238.55 | 239.01 | 127600.0 |
| 2024-05-20 | ABLLW | Stock | 0.3657 | 0.39 | 0.35 | 0.3725 | 68755.0 |
| 2024-05-20 | ABLV | Stock | 1.72 | 1.96 | 1.7 | 1.7 | 2500.0 |
| 2024-05-20 | ABM | Stock | 47.06 | 47.5 | 46.94 | 47.27 | 428900.0 |
| 2024-05-20 | ABNB | Stock | 146.18 | 146.48 | 145.21 | 146.37 | 3747400.0 |
| 2024-05-20 | ABOS | Stock | 3.69 | 3.92 | 3.645 | 3.84 | 141600.0 |
| 2024-05-20 | ABR | Stock | 13.9 | 13.98 | 13.8 | 13.86 | 1798500.0 |
| 2024-05-20 | ABR.D | Stock | 18.5649 | 18.7342 | 18.45 | 18.5 | 8409.0 |
| 2024-05-20 | ABR.E | Stock | 18.189 | 18.5299 | 18.0902 | 18.19 | 12392.0 |
| 2024-05-20 | ABR.F | Stock | 19.96 | 19.97 | 19.86 | 19.97 | 10670.0 |
| 2024-05-20 | ABSI | Stock | 4.57 | 4.67 | 4.43 | 4.61 | 817100.0 |
| 2024-05-20 | ABT | Stock | 103.78 | 103.8 | 103.02 | 103.21 | 7165900.0 |
| 2024-05-20 | ABTC | Stock | 122.25 | 131.25 | 116.25 | 126.0 | 6266.666666666667 |
| 2024-05-20 | ABTS | Stock | 9.9 | 10.305 | 9.9 | 9.9 | 2333.0 |
> showing 50 of 7,208 rows — these rows as CSV