PREVIEW / stock_daily / 2024-05-21
file: by_date/stock_daily/2024/2024-05-21.parquet size: 231 KB rows: 7,235 symbols: 972
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-21 | AAPL | Stock | 191.09 | 192.73 | 190.92 | 192.35 | 42309400.0 |
| 2024-05-21 | MSFT | Stock | 426.83 | 432.97 | 424.85 | 429.04 | 21453300.0 |
| 2024-05-21 | NVDA | Stock | 93.599 | 95.4 | 93.18 | 95.386 | 328946000.0 |
| 2024-05-21 | AMZN | Stock | 182.3 | 183.26 | 180.75 | 183.15 | 50839100.0 |
| 2024-05-21 | GOOGL | Stock | 176.9 | 178.15 | 175.81 | 177.85 | 16989369.0 |
| 2024-05-21 | META | Stock | 467.12 | 470.7 | 462.27 | 464.63 | 11742200.0 |
| 2024-05-21 | TSLA | Stock | 175.51 | 186.88 | 174.71 | 186.6 | 115266500.0 |
| 2024-05-21 | TLT | Stock | 91.73 | 91.77 | 91.43 | 91.59 | 15334425.0 |
| 2024-05-21 | ES | Stock | 60.82 | 61.35 | 60.68 | 61.22 | 1622600.0 |
| 2024-05-21 | CL | Stock | 94.83 | 95.23 | 94.43 | 95.17 | 4998200.0 |
| 2024-05-21 | A | Stock | 154.35 | 154.65 | 152.34 | 153.67 | 997100.0 |
| 2024-05-21 | AA | Stock | 42.27 | 44.57 | 42.18 | 44.09 | 9390700.0 |
| 2024-05-21 | AACG | Stock | 0.91 | 1.11 | 0.91 | 0.95 | 28500.0 |
| 2024-05-21 | AACIW-DELISTED | Stock | 0.145 | 0.15 | 0.13 | 0.1399 | 112658.0 |
| 2024-05-21 | AACT | Stock | 10.625 | 10.64 | 10.62 | 10.63 | 1389800.0 |
| 2024-05-21 | AAGR-DELISTED | Stock | 0.3757 | 0.379 | 0.3001 | 0.352 | 117327.0 |
| 2024-05-21 | AAGRW-DELISTED | Stock | 0.0115 | 0.0169 | 0.0115 | 0.0165 | 4636.0 |
| 2024-05-21 | AAL | Stock | 14.43 | 14.49 | 14.01 | 14.03 | 22692900.0 |
| 2024-05-21 | AAMC-DELISTED | Stock | 2.68 | 2.68 | 2.54 | 2.54 | 2000.0 |
| 2024-05-21 | AAME | Stock | 1.61 | 1.75 | 1.61 | 1.74 | 15600.0 |
| 2024-05-21 | AAMI | Stock | 22.28 | 22.48 | 22.22 | 22.3 | 211600.0 |
| 2024-05-21 | AAN-DELISTED | Stock | 7.64 | 7.64 | 7.44 | 7.47 | 101400.0 |
| 2024-05-21 | AAOI | Stock | 12.29 | 12.3 | 11.83 | 12.0 | 1485500.0 |
| 2024-05-21 | AAON | Stock | 74.78 | 77.07 | 74.41 | 76.79 | 634900.0 |
| 2024-05-21 | AAP | Stock | 72.65 | 73.16 | 69.93 | 70.72 | 1952500.0 |
| 2024-05-21 | AAT | Stock | 22.12 | 22.38 | 21.99 | 22.32 | 187900.0 |
| 2024-05-21 | AATC | Stock | 6.39 | 6.39 | 6.27 | 6.35 | 20562.0 |
| 2024-05-21 | AAUAF-DELISTED | Stock | 0.1219 | 0.12676 | 0.1219 | 0.1236 | 254721.0 |
| 2024-05-21 | AAXJ | Stock | 72.54 | 72.635 | 72.315 | 72.52 | 812632.0 |
| 2024-05-21 | AB | Stock | 33.78 | 34.36 | 33.78 | 33.97 | 297100.0 |
| 2024-05-21 | ABAT | Stock | 1.46 | 1.46 | 1.4 | 1.42 | 273315.0 |
| 2024-05-21 | ABBV | Stock | 165.37 | 165.71 | 162.5 | 162.93 | 3645200.0 |
| 2024-05-21 | ABCB | Stock | 49.6 | 49.91 | 49.48 | 49.68 | 171000.0 |
| 2024-05-21 | ABCL | Stock | 3.72 | 3.885 | 3.7 | 3.85 | 1986700.0 |
| 2024-05-21 | ABEO | Stock | 4.51 | 4.6 | 4.3 | 4.31 | 602900.0 |
| 2024-05-21 | ABEV | Stock | 2.38 | 2.38 | 2.32 | 2.32 | 30837500.0 |
| 2024-05-21 | ABG | Stock | 238.02 | 240.51 | 236.97 | 240.0 | 164000.0 |
| 2024-05-21 | ABLLW | Stock | 0.36285 | 0.3927 | 0.2559 | 0.3252 | 145579.0 |
| 2024-05-21 | ABLV | Stock | 1.745 | 1.81 | 1.745 | 1.81 | 1900.0 |
| 2024-05-21 | ABM | Stock | 47.12 | 48.4 | 46.82 | 48.38 | 455200.0 |
| 2024-05-21 | ABNB | Stock | 145.71 | 145.71 | 144.09 | 144.1 | 4485000.0 |
| 2024-05-21 | ABOS | Stock | 3.83 | 3.88 | 3.68 | 3.81 | 160600.0 |
| 2024-05-21 | ABR | Stock | 13.85 | 13.9 | 13.73 | 13.79 | 1998100.0 |
| 2024-05-21 | ABR.D | Stock | 18.65 | 18.8 | 18.37 | 18.5 | 16406.0 |
| 2024-05-21 | ABR.E | Stock | 18.135 | 18.25 | 18.09 | 18.09 | 9784.0 |
| 2024-05-21 | ABR.F | Stock | 19.87 | 19.97 | 19.78 | 19.9 | 14349.0 |
| 2024-05-21 | ABSI | Stock | 4.7 | 4.905 | 4.64 | 4.79 | 1265600.0 |
| 2024-05-21 | ABT | Stock | 103.52 | 103.86 | 102.41 | 102.96 | 4391600.0 |
| 2024-05-21 | ABTC | Stock | 127.5 | 129.375 | 116.25 | 119.25 | 6930.666666666667 |
| 2024-05-21 | ABTS | Stock | 10.035 | 10.44 | 9.99 | 10.05 | 573.0 |
> showing 50 of 7,235 rows — these rows as CSV