PREVIEW / stock_daily / 2024-10-17
file: by_date/stock_daily/2024/2024-10-17.parquet size: 245 KB rows: 7,138 symbols: 690
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-10-17 | AAPL | Stock | 233.43 | 233.85 | 230.52 | 232.15 | 29016863.0 |
| 2024-10-17 | MSFT | Stock | 422.36 | 422.5 | 415.59 | 416.72 | 14323970.0 |
| 2024-10-17 | NVDA | Stock | 139.34 | 140.89 | 136.87 | 136.93 | 302281013.0 |
| 2024-10-17 | AMZN | Stock | 188.22 | 188.94 | 186.0 | 187.53 | 24472951.0 |
| 2024-10-17 | GOOGL | Stock | 165.73 | 166.37 | 162.76 | 162.93 | 21453395.0 |
| 2024-10-17 | META | Stock | 583.33 | 584.97 | 575.2 | 576.93 | 8571730.0 |
| 2024-10-17 | TSLA | Stock | 221.59 | 222.08 | 217.9 | 220.89 | 49227857.0 |
| 2024-10-17 | TLT | Stock | 94.29 | 94.44 | 93.6701 | 93.8 | 43427214.0 |
| 2024-10-17 | ES | Stock | 65.87 | 65.875 | 64.96 | 65.0 | 1557970.0 |
| 2024-10-17 | CL | Stock | 101.83 | 101.89 | 100.07 | 100.53 | 3309320.0 |
| 2024-10-17 | A | Stock | 141.81 | 142.53 | 136.48 | 137.42 | 1556302.0 |
| 2024-10-17 | AA | Stock | 42.8 | 42.95 | 40.02 | 40.35 | 11049791.0 |
| 2024-10-17 | AACG | Stock | 1.01 | 1.03 | 0.9499 | 1.0 | 66555.0 |
| 2024-10-17 | AACT | Stock | 10.84 | 10.86 | 10.84 | 10.85 | 219802.0 |
| 2024-10-17 | AAGR-DELISTED | Stock | 0.0003 | 0.0004 | 0.0003 | 0.0004 | 233993.0 |
| 2024-10-17 | AAGRW-DELISTED | Stock | 0.002 | 0.002 | 0.0001 | 0.0001 | 11456.0 |
| 2024-10-17 | AAL | Stock | 12.865 | 12.97 | 12.67 | 12.81 | 30117199.0 |
| 2024-10-17 | AAM | Stock | 10.02 | 10.03 | 10.02 | 10.02 | 1555610.0 |
| 2024-10-17 | AAME | Stock | 1.595 | 1.65 | 1.551 | 1.63 | 3546.0 |
| 2024-10-17 | AAMI | Stock | 27.19 | 27.28 | 26.95 | 27.07 | 147725.0 |
| 2024-10-17 | AAOI | Stock | 19.44 | 19.54 | 18.52 | 19.0 | 2488866.0 |
| 2024-10-17 | AAON | Stock | 111.38 | 112.36 | 110.8515 | 111.11 | 368038.0 |
| 2024-10-17 | AAP | Stock | 38.39 | 39.48 | 38.243 | 39.38 | 2152368.0 |
| 2024-10-17 | AAT | Stock | 27.87 | 27.97 | 27.58 | 27.88 | 133602.0 |
| 2024-10-17 | AATC | Stock | 7.3125 | 7.54 | 7.31 | 7.35 | 5247.0 |
| 2024-10-17 | AAUAF-DELISTED | Stock | 0.0462 | 0.04967 | 0.046 | 0.046 | 50870.0 |
| 2024-10-17 | AAXJ | Stock | 77.62 | 77.87 | 77.34 | 77.68 | 494398.0 |
| 2024-10-17 | AB | Stock | 38.0 | 38.45 | 37.7701 | 38.41 | 435263.0 |
| 2024-10-17 | ABAT | Stock | 1.05 | 1.05 | 1.0 | 1.03 | 350444.0 |
| 2024-10-17 | ABBV | Stock | 190.54 | 191.62 | 188.46 | 188.57 | 4291784.0 |
| 2024-10-17 | ABCB | Stock | 65.94 | 66.51 | 65.49 | 66.46 | 202091.0 |
| 2024-10-17 | ABCL | Stock | 2.62 | 2.69 | 2.59 | 2.68 | 2329764.0 |
| 2024-10-17 | ABEO | Stock | 6.54 | 6.78 | 6.4 | 6.74 | 196687.0 |
| 2024-10-17 | ABEV | Stock | 2.28 | 2.31 | 2.27 | 2.3 | 16545613.0 |
| 2024-10-17 | ABG | Stock | 235.06 | 235.54 | 231.555 | 235.28 | 101538.0 |
| 2024-10-17 | ABLLW | Stock | 1.56 | 1.61 | 1.45 | 1.61 | 20524.0 |
| 2024-10-17 | ABLV | Stock | 0.92 | 0.92 | 0.87 | 0.885 | 22024.0 |
| 2024-10-17 | ABM | Stock | 53.68 | 54.43 | 53.49 | 54.33 | 298038.0 |
| 2024-10-17 | ABNB | Stock | 135.7 | 136.65 | 135.11 | 136.02 | 3747194.0 |
| 2024-10-17 | ABOS | Stock | 2.4 | 2.66 | 2.38 | 2.66 | 1002253.0 |
| 2024-10-17 | ABR | Stock | 15.3 | 15.33 | 14.97 | 15.19 | 1385593.0 |
| 2024-10-17 | ABR.D | Stock | 19.55 | 19.75 | 19.5 | 19.5375 | 12321.0 |
| 2024-10-17 | ABR.E | Stock | 19.88 | 20.23 | 19.78 | 20.23 | 4638.0 |
| 2024-10-17 | ABR.F | Stock | 19.71 | 19.92 | 19.6 | 19.8 | 19322.0 |
| 2024-10-17 | ABSI | Stock | 4.13 | 4.14 | 4.01 | 4.02 | 482265.0 |
| 2024-10-17 | ABT | Stock | 118.71 | 118.76 | 117.19 | 117.89 | 4926902.0 |
| 2024-10-17 | ABTC | Stock | 47.25 | 49.455000000000005 | 45.495 | 46.68 | 1702.2 |
| 2024-10-17 | ABTS | Stock | 7.11 | 7.56 | 6.7515 | 7.0725 | 1335.0 |
| 2024-10-17 | ABUS | Stock | 4.2 | 4.208 | 4.08 | 4.12 | 893482.0 |
| 2024-10-17 | ABVC | Stock | 0.5255 | 0.561 | 0.523 | 0.5467 | 54064.0 |
> showing 50 of 7,138 rows — these rows as CSV