PREVIEW / stock_daily / 2024-09-26
file: by_date/stock_daily/2024/2024-09-26.parquet size: 246 KB rows: 7,137 symbols: 725
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-09-26 | AAPL | Stock | 227.3 | 228.5 | 225.41 | 227.52 | 34727020.0 |
| 2024-09-26 | MSFT | Stock | 435.085 | 435.3 | 429.13 | 431.31 | 13714887.0 |
| 2024-09-26 | NVDA | Stock | 126.8 | 127.665 | 121.8 | 124.04 | 299157963.0 |
| 2024-09-26 | AMZN | Stock | 194.31 | 194.53 | 189.54 | 191.16 | 35076116.0 |
| 2024-09-26 | GOOGL | Stock | 163.64 | 164.08 | 162.28 | 162.73 | 20319336.0 |
| 2024-09-26 | META | Stock | 575.73 | 577.4 | 562.3501 | 567.84 | 14243057.0 |
| 2024-09-26 | TSLA | Stock | 260.6 | 261.75 | 251.53 | 254.22 | 65890244.0 |
| 2024-09-26 | TLT | Stock | 98.07 | 98.245 | 97.42 | 98.06 | 33332315.0 |
| 2024-09-26 | ES | Stock | 65.98 | 67.0 | 65.81 | 65.99 | 1338992.0 |
| 2024-09-26 | CL | Stock | 102.64 | 104.03 | 102.26 | 103.06 | 3473869.0 |
| 2024-09-26 | A | Stock | 141.26 | 146.96 | 140.54 | 146.74 | 2007227.0 |
| 2024-09-26 | AA | Stock | 38.3 | 39.62 | 38.0 | 39.28 | 9291682.0 |
| 2024-09-26 | AACG | Stock | 0.73 | 0.7697 | 0.71 | 0.7224 | 23364.0 |
| 2024-09-26 | AACT | Stock | 10.81 | 10.83 | 10.81 | 10.81 | 94165.0 |
| 2024-09-26 | AAGR-DELISTED | Stock | 0.05 | 0.0556 | 0.0192 | 0.02 | 3170932.0 |
| 2024-09-26 | AAGRW-DELISTED | Stock | 0.0004 | 0.0007 | 0.0004 | 0.0007 | 14892.0 |
| 2024-09-26 | AAL | Stock | 11.36 | 11.98 | 11.35 | 11.79 | 62288600.0 |
| 2024-09-26 | AAM | Stock | 10.01 | 10.01 | 10.0 | 10.01 | 1623834.0 |
| 2024-09-26 | AAME | Stock | 1.65 | 1.7485 | 1.58 | 1.61 | 13545.0 |
| 2024-09-26 | AAMI | Stock | 26.05 | 26.05 | 25.49 | 25.54 | 132760.0 |
| 2024-09-26 | AAN-DELISTED | Stock | 10.06 | 10.06 | 10.02 | 10.03 | 2518020.0 |
| 2024-09-26 | AAOI | Stock | 15.95 | 16.6099 | 14.76 | 14.81 | 2460150.0 |
| 2024-09-26 | AAON | Stock | 108.39 | 108.76 | 106.1 | 107.02 | 370119.0 |
| 2024-09-26 | AAP | Stock | 39.89 | 40.9 | 39.8814 | 40.23 | 2925565.0 |
| 2024-09-26 | AAT | Stock | 27.22 | 27.22 | 26.48 | 26.49 | 144068.0 |
| 2024-09-26 | AATC | Stock | 7.962 | 7.962 | 7.8 | 7.8 | 1179.0 |
| 2024-09-26 | AAUAF-DELISTED | Stock | 0.05 | 0.0561 | 0.048 | 0.049 | 14212.0 |
| 2024-09-26 | AAXJ | Stock | 79.73 | 79.97 | 78.82 | 79.63 | 642795.0 |
| 2024-09-26 | AB | Stock | 34.95 | 35.05 | 34.68 | 34.69 | 167948.0 |
| 2024-09-26 | ABAT | Stock | 0.81 | 0.975 | 0.81 | 0.94 | 1397476.0 |
| 2024-09-26 | ABBV | Stock | 190.1 | 192.87 | 189.615 | 191.9 | 5932271.0 |
| 2024-09-26 | ABCB | Stock | 62.13 | 62.17 | 61.205 | 61.46 | 325869.0 |
| 2024-09-26 | ABCL | Stock | 2.46 | 2.56 | 2.46 | 2.56 | 1235705.0 |
| 2024-09-26 | ABEO | Stock | 5.97 | 6.04 | 5.76 | 5.93 | 202916.0 |
| 2024-09-26 | ABEV | Stock | 2.36 | 2.37 | 2.35 | 2.36 | 10484270.0 |
| 2024-09-26 | ABG | Stock | 234.74 | 240.91 | 231.62 | 238.21 | 201868.0 |
| 2024-09-26 | ABLLW | Stock | 1.8134 | 1.8134 | 1.62 | 1.7 | 22179.0 |
| 2024-09-26 | ABLV | Stock | 0.99 | 0.99 | 0.8407 | 0.95 | 13142.0 |
| 2024-09-26 | ABM | Stock | 51.15 | 52.215 | 51.065 | 51.73 | 513442.0 |
| 2024-09-26 | ABNB | Stock | 132.706 | 133.34 | 129.146 | 129.25 | 3759995.0 |
| 2024-09-26 | ABOS | Stock | 2.45 | 2.52 | 2.3607 | 2.43 | 188888.0 |
| 2024-09-26 | ABR | Stock | 15.47 | 15.59 | 15.385 | 15.51 | 2413338.0 |
| 2024-09-26 | ABR.D | Stock | 19.25 | 19.4178 | 19.15 | 19.3434 | 20363.0 |
| 2024-09-26 | ABR.E | Stock | 19.45 | 19.62 | 19.24 | 19.57 | 3418.0 |
| 2024-09-26 | ABR.F | Stock | 19.25 | 19.43 | 19.2486 | 19.37 | 33867.0 |
| 2024-09-26 | ABSI | Stock | 3.94 | 4.13 | 3.86 | 4.11 | 800978.0 |
| 2024-09-26 | ABT | Stock | 112.31 | 112.93 | 112.1 | 112.73 | 3286656.0 |
| 2024-09-26 | ABTC | Stock | 45.0 | 47.99400000000001 | 43.425000000000004 | 45.9 | 2287.2666666666664 |
| 2024-09-26 | ABTS | Stock | 6.9 | 7.5 | 6.9 | 7.4865 | 588.0 |
| 2024-09-26 | ABUS | Stock | 3.94 | 4.01 | 3.93 | 3.96 | 844804.0 |
> showing 50 of 7,137 rows — these rows as CSV