PREVIEW / stock_daily / 2024-08-01
file: by_date/stock_daily/2024/2024-08-01.parquet size: 246 KB rows: 7,204 symbols: 870
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-01 | AAPL | Stock | 224.37 | 224.48 | 217.02 | 218.36 | 60124537.0 |
| 2024-08-01 | MSFT | Stock | 420.785 | 427.46 | 413.0901 | 417.11 | 30152875.0 |
| 2024-08-01 | NVDA | Stock | 117.53 | 120.16 | 106.8104 | 109.21 | 515474588.0 |
| 2024-08-01 | AMZN | Stock | 189.285 | 190.6 | 181.87 | 184.07 | 66353111.0 |
| 2024-08-01 | GOOGL | Stock | 170.25 | 174.05 | 168.88 | 170.76 | 24531392.0 |
| 2024-08-01 | META | Stock | 521.0 | 527.1709 | 492.1 | 497.74 | 42731742.0 |
| 2024-08-01 | TSLA | Stock | 227.69 | 231.867 | 214.3328 | 216.86 | 82840177.0 |
| 2024-08-01 | TLT | Stock | 95.14 | 95.905 | 95.12 | 95.31 | 77254240.0 |
| 2024-08-01 | ES | Stock | 64.32 | 66.39 | 64.28 | 66.07 | 2489016.0 |
| 2024-08-01 | CL | Stock | 99.55 | 101.13 | 98.73 | 100.93 | 4735748.0 |
| 2024-08-01 | A | Stock | 142.24 | 144.22 | 141.75 | 142.86 | 2797067.0 |
| 2024-08-01 | AA | Stock | 32.95 | 33.27 | 31.09 | 31.47 | 17174923.0 |
| 2024-08-01 | AACG | Stock | 0.6601 | 0.6612 | 0.651 | 0.651 | 8163.0 |
| 2024-08-01 | AACIU | Stock | 10.99 | 10.99 | 10.99 | 10.99 | 615.0 |
| 2024-08-01 | AACT | Stock | 10.745 | 10.75 | 10.74 | 10.745 | 22655.0 |
| 2024-08-01 | AAGR-DELISTED | Stock | 0.1543 | 0.1568 | 0.141 | 0.145 | 264929.0 |
| 2024-08-01 | AAGRW-DELISTED | Stock | 0.01 | 0.01 | 0.0097 | 0.0098 | 24007.0 |
| 2024-08-01 | AAL | Stock | 10.65 | 10.68 | 10.09 | 10.14 | 46603089.0 |
| 2024-08-01 | AAMC-DELISTED | Stock | 3.55 | 4.47 | 2.41 | 3.23 | 196690.0 |
| 2024-08-01 | AAME | Stock | 1.53 | 1.54 | 1.516 | 1.5231 | 1655.0 |
| 2024-08-01 | AAMI | Stock | 25.55 | 25.67 | 23.37 | 24.27 | 299155.0 |
| 2024-08-01 | AAN-DELISTED | Stock | 10.1 | 10.14 | 10.05 | 10.06 | 1036569.0 |
| 2024-08-01 | AAOI | Stock | 9.61 | 9.98 | 8.305 | 8.4 | 3045864.0 |
| 2024-08-01 | AAON | Stock | 88.42 | 89.595 | 84.345 | 86.91 | 967479.0 |
| 2024-08-01 | AAP | Stock | 63.63 | 63.68 | 60.79 | 62.13 | 908608.0 |
| 2024-08-01 | AAT | Stock | 26.62 | 26.83 | 25.5452 | 26.04 | 350146.0 |
| 2024-08-01 | AATC | Stock | 6.95 | 6.95 | 6.81 | 6.85 | 1344.0 |
| 2024-08-01 | AAUAF-DELISTED | Stock | 0.05 | 0.05176 | 0.05 | 0.0512 | 48723.0 |
| 2024-08-01 | AAXJ | Stock | 71.86 | 72.08 | 70.83 | 71.05 | 375497.0 |
| 2024-08-01 | AB | Stock | 35.4 | 35.67 | 34.58 | 35.39 | 527583.0 |
| 2024-08-01 | ABAT | Stock | 1.07 | 1.07 | 0.9741 | 1.02 | 328033.0 |
| 2024-08-01 | ABBV | Stock | 187.77 | 190.9699 | 186.77 | 189.71 | 6279138.0 |
| 2024-08-01 | ABCB | Stock | 60.92 | 61.72 | 57.73 | 58.41 | 395235.0 |
| 2024-08-01 | ABCL | Stock | 3.32 | 3.33 | 3.01 | 3.05 | 981029.0 |
| 2024-08-01 | ABEO | Stock | 4.94 | 4.94 | 4.73 | 4.81 | 284509.0 |
| 2024-08-01 | ABEV | Stock | 2.1 | 2.11 | 2.05 | 2.05 | 18546904.0 |
| 2024-08-01 | ABG | Stock | 271.59 | 273.58 | 259.47 | 263.43 | 227127.0 |
| 2024-08-01 | ABLLW | Stock | 1.06 | 1.06 | 1.0 | 1.02 | 1930.0 |
| 2024-08-01 | ABLV | Stock | 1.19 | 1.25 | 1.09 | 1.1 | 11868.0 |
| 2024-08-01 | ABLVW | Stock | 0.0349 | 0.0349 | 0.0349 | 0.0349 | 372.0 |
| 2024-08-01 | ABM | Stock | 55.32 | 56.03 | 54.255 | 55.3 | 409320.0 |
| 2024-08-01 | ABNB | Stock | 139.7 | 139.78 | 132.9 | 135.09 | 5074615.0 |
| 2024-08-01 | ABOS | Stock | 3.28 | 3.28 | 3.132 | 3.23 | 239524.0 |
| 2024-08-01 | ABR | Stock | 13.55 | 13.59 | 13.13 | 13.2 | 2869233.0 |
| 2024-08-01 | ABR.D | Stock | 17.85 | 17.85 | 17.4 | 17.44 | 58061.0 |
| 2024-08-01 | ABR.E | Stock | 18.2 | 18.41 | 18.03 | 18.17 | 24303.0 |
| 2024-08-01 | ABR.F | Stock | 19.0 | 19.01 | 18.82 | 18.82 | 24671.0 |
| 2024-08-01 | ABSI | Stock | 4.4 | 4.47 | 4.01 | 4.04 | 813614.0 |
| 2024-08-01 | ABT | Stock | 106.65 | 110.68 | 106.33 | 110.15 | 8820820.0 |
| 2024-08-01 | ABTC | Stock | 65.7675 | 66.0 | 63.74250000000001 | 64.575 | 1867.0666666666666 |
> showing 50 of 7,204 rows — these rows as CSV