PREVIEW / stock_daily / 2024-08-21
file: by_date/stock_daily/2024/2024-08-21.parquet size: 246 KB rows: 7,149 symbols: 788
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-08-21 | AAPL | Stock | 226.52 | 227.98 | 225.05 | 226.4 | 33908239.0 |
| 2024-08-21 | MSFT | Stock | 424.075 | 426.4 | 421.72 | 424.14 | 14790202.0 |
| 2024-08-21 | NVDA | Stock | 127.315 | 129.35 | 126.66 | 128.5 | 255997726.0 |
| 2024-08-21 | AMZN | Stock | 179.92 | 182.385 | 178.8937 | 180.11 | 34108402.0 |
| 2024-08-21 | GOOGL | Stock | 165.15 | 166.85 | 164.67 | 165.85 | 22901997.0 |
| 2024-08-21 | META | Stock | 527.15 | 539.4 | 526.935 | 535.16 | 13249127.0 |
| 2024-08-21 | TSLA | Stock | 222.67 | 224.6594 | 218.86 | 223.27 | 69938376.0 |
| 2024-08-21 | TLT | Stock | 98.67 | 99.2 | 98.21 | 98.73 | 29229982.0 |
| 2024-08-21 | ES | Stock | 66.0 | 66.71 | 65.98 | 66.53 | 2207794.0 |
| 2024-08-21 | CL | Stock | 103.11 | 103.65 | 102.65 | 103.47 | 2960738.0 |
| 2024-08-21 | A | Stock | 139.98 | 140.79 | 139.145 | 139.99 | 2238711.0 |
| 2024-08-21 | AA | Stock | 34.04 | 34.05 | 32.92 | 33.29 | 4216233.0 |
| 2024-08-21 | AACG | Stock | 0.65 | 0.65 | 0.616 | 0.62 | 17790.0 |
| 2024-08-21 | AACT | Stock | 10.75 | 10.77 | 10.75 | 10.75 | 6601.0 |
| 2024-08-21 | AAGR-DELISTED | Stock | 0.14 | 0.14 | 0.1328 | 0.135 | 205268.0 |
| 2024-08-21 | AAGRW-DELISTED | Stock | 0.0119 | 0.0119 | 0.0095 | 0.0095 | 13108.0 |
| 2024-08-21 | AAL | Stock | 10.37 | 10.445 | 10.3 | 10.4 | 20178195.0 |
| 2024-08-21 | AAMC-DELISTED | Stock | 2.31 | 2.34 | 2.31 | 2.3101 | 3086.0 |
| 2024-08-21 | AAME | Stock | 1.55 | 1.6 | 1.5201 | 1.53 | 3488.0 |
| 2024-08-21 | AAMI | Stock | 23.3 | 23.31 | 22.97 | 23.3 | 64229.0 |
| 2024-08-21 | AAN-DELISTED | Stock | 10.09 | 10.1 | 10.08 | 10.09 | 371000.0 |
| 2024-08-21 | AAOI | Stock | 8.85 | 8.945 | 8.43 | 8.92 | 1496179.0 |
| 2024-08-21 | AAON | Stock | 89.69 | 92.01 | 89.57 | 91.95 | 279353.0 |
| 2024-08-21 | AAP | Stock | 61.48 | 61.97 | 60.81 | 61.92 | 1818401.0 |
| 2024-08-21 | AAT | Stock | 25.71 | 26.08 | 25.5311 | 26.03 | 172666.0 |
| 2024-08-21 | AATC | Stock | 7.25 | 7.275 | 7.1 | 7.15 | 18850.0 |
| 2024-08-21 | AAUAF-DELISTED | Stock | 0.0542 | 0.055 | 0.053 | 0.0542 | 40943.0 |
| 2024-08-21 | AAXJ | Stock | 72.92 | 73.42 | 72.92 | 73.3 | 108238.0 |
| 2024-08-21 | AB | Stock | 34.53 | 35.07 | 34.1501 | 35.07 | 265074.0 |
| 2024-08-21 | ABAT | Stock | 1.05 | 1.07 | 1.04 | 1.055 | 191561.0 |
| 2024-08-21 | ABBV | Stock | 196.44 | 197.335 | 195.67 | 196.53 | 4023122.0 |
| 2024-08-21 | ABCB | Stock | 58.05 | 58.215 | 57.41 | 58.1 | 192731.0 |
| 2024-08-21 | ABCL | Stock | 2.64 | 2.668 | 2.58 | 2.64 | 1185773.0 |
| 2024-08-21 | ABEO | Stock | 5.17 | 5.27 | 5.07 | 5.24 | 197979.0 |
| 2024-08-21 | ABEV | Stock | 2.39 | 2.4 | 2.33 | 2.36 | 32642811.0 |
| 2024-08-21 | ABG | Stock | 230.89 | 235.62 | 229.6725 | 235.04 | 137312.0 |
| 2024-08-21 | ABLLW | Stock | 1.49 | 1.55 | 1.4 | 1.45 | 142769.0 |
| 2024-08-21 | ABLV | Stock | 1.75 | 1.76 | 1.73 | 1.73 | 4409.0 |
| 2024-08-21 | ABM | Stock | 54.37 | 54.77 | 54.15 | 54.63 | 175905.0 |
| 2024-08-21 | ABNB | Stock | 118.04 | 118.27 | 116.7 | 117.68 | 5005194.0 |
| 2024-08-21 | ABOS | Stock | 2.89 | 2.89 | 2.76 | 2.85 | 118901.0 |
| 2024-08-21 | ABR | Stock | 12.95 | 13.18 | 12.9454 | 13.15 | 2649063.0 |
| 2024-08-21 | ABR.D | Stock | 17.5 | 17.8 | 17.5 | 17.6455 | 28570.0 |
| 2024-08-21 | ABR.E | Stock | 17.4452 | 17.45 | 17.4 | 17.4 | 5619.0 |
| 2024-08-21 | ABR.F | Stock | 17.95 | 18.2 | 17.95 | 18.13 | 35946.0 |
| 2024-08-21 | ABSI | Stock | 4.26 | 4.37 | 4.136 | 4.35 | 739165.0 |
| 2024-08-21 | ABT | Stock | 110.97 | 111.45 | 110.68 | 111.39 | 3936475.0 |
| 2024-08-21 | ABTC | Stock | 55.5 | 60.0 | 54.75 | 57.48 | 4100.066666666667 |
| 2024-08-21 | ABTS | Stock | 8.1 | 8.175 | 7.485 | 7.956 | 1457.0 |
| 2024-08-21 | ABUS | Stock | 3.85 | 3.94 | 3.8 | 3.87 | 1062647.0 |
> showing 50 of 7,149 rows — these rows as CSV