PREVIEW / stock_daily / 2024-06-04
file: by_date/stock_daily/2024/2024-06-04.parquet size: 231 KB rows: 7,218 symbols: 975
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-06-04 | AAPL | Stock | 194.64 | 195.32 | 193.03 | 194.35 | 47471400.0 |
| 2024-06-04 | MSFT | Stock | 412.43 | 416.44 | 409.68 | 416.07 | 14348900.0 |
| 2024-06-04 | NVDA | Stock | 115.716 | 116.6 | 114.045 | 116.437 | 403324000.0 |
| 2024-06-04 | AMZN | Stock | 177.64 | 179.82 | 176.44 | 179.34 | 27198400.0 |
| 2024-06-04 | GOOGL | Stock | 173.28 | 173.845 | 171.89 | 173.79 | 26879596.0 |
| 2024-06-04 | META | Stock | 477.0 | 478.89 | 473.23 | 476.99 | 7088700.0 |
| 2024-06-04 | TSLA | Stock | 174.78 | 177.76 | 174.0 | 174.77 | 60056300.0 |
| 2024-06-04 | TLT | Stock | 92.2 | 92.8 | 91.99 | 92.67 | 42581462.0 |
| 2024-06-04 | ES | Stock | 59.64 | 61.03 | 59.43 | 60.82 | 2705300.0 |
| 2024-06-04 | CL | Stock | 92.7 | 94.02 | 92.48 | 93.81 | 3599100.0 |
| 2024-06-04 | A | Stock | 131.24 | 132.25 | 130.28 | 130.85 | 2893700.0 |
| 2024-06-04 | AA | Stock | 43.01 | 43.28 | 41.28 | 42.01 | 6500600.0 |
| 2024-06-04 | AACG | Stock | 0.92 | 0.92 | 0.89 | 0.9 | 8300.0 |
| 2024-06-04 | AACT | Stock | 10.64 | 10.66 | 10.64 | 10.66 | 578500.0 |
| 2024-06-04 | AAGR-DELISTED | Stock | 0.367 | 0.3799 | 0.3401 | 0.37 | 47091.0 |
| 2024-06-04 | AAGRW-DELISTED | Stock | 0.0165 | 0.0165 | 0.01534 | 0.01534 | 420.0 |
| 2024-06-04 | AAL | Stock | 11.54 | 11.79 | 11.48 | 11.5 | 39161500.0 |
| 2024-06-04 | AAMC-DELISTED | Stock | 2.71 | 2.71 | 2.56 | 2.56 | 1100.0 |
| 2024-06-04 | AAME | Stock | 1.64 | 1.79 | 1.64 | 1.79 | 10600.0 |
| 2024-06-04 | AAMI | Stock | 22.53 | 22.73 | 22.45 | 22.54 | 342700.0 |
| 2024-06-04 | AAN-DELISTED | Stock | 8.12 | 8.18 | 7.955 | 8.11 | 273200.0 |
| 2024-06-04 | AAOI | Stock | 10.6 | 10.65 | 9.87 | 10.05 | 2232700.0 |
| 2024-06-04 | AAON | Stock | 73.44 | 73.44 | 71.19 | 72.0 | 844400.0 |
| 2024-06-04 | AAP | Stock | 67.0 | 67.0 | 64.51 | 65.21 | 1264900.0 |
| 2024-06-04 | AAT | Stock | 21.72 | 22.13 | 21.61 | 21.82 | 297000.0 |
| 2024-06-04 | AATC | Stock | 6.095 | 6.13 | 6.095 | 6.13 | 9144.0 |
| 2024-06-04 | AAUAF-DELISTED | Stock | 0.106 | 0.125 | 0.0956 | 0.0956 | 28549.0 |
| 2024-06-04 | AAXJ | Stock | 70.14 | 70.24 | 69.74 | 70.2 | 948603.0 |
| 2024-06-04 | AB | Stock | 34.04 | 34.1 | 33.55 | 33.77 | 165400.0 |
| 2024-06-04 | ABAT | Stock | 1.41 | 1.46 | 1.39 | 1.45 | 643200.0 |
| 2024-06-04 | ABBV | Stock | 160.19 | 162.81 | 159.77 | 162.14 | 4215500.0 |
| 2024-06-04 | ABCB | Stock | 47.29 | 47.82 | 46.96 | 47.3 | 224200.0 |
| 2024-06-04 | ABCL | Stock | 3.88 | 3.895 | 3.76 | 3.78 | 1077000.0 |
| 2024-06-04 | ABEO | Stock | 4.44 | 4.53 | 4.28 | 4.33 | 405600.0 |
| 2024-06-04 | ABEV | Stock | 2.19 | 2.22 | 2.17 | 2.21 | 13919600.0 |
| 2024-06-04 | ABG | Stock | 240.51 | 241.77 | 236.12 | 237.73 | 161300.0 |
| 2024-06-04 | ABLLW | Stock | 0.44 | 0.44 | 0.3626 | 0.4089 | 17958.0 |
| 2024-06-04 | ABLV | Stock | 0.97 | 1.35 | 0.97 | 1.13 | 6500.0 |
| 2024-06-04 | ABM | Stock | 47.28 | 47.69 | 47.04 | 47.56 | 341400.0 |
| 2024-06-04 | ABNB | Stock | 145.82 | 147.92 | 145.44 | 147.08 | 3048500.0 |
| 2024-06-04 | ABOS | Stock | 2.71 | 2.91 | 2.7 | 2.73 | 323900.0 |
| 2024-06-04 | ABR | Stock | 13.9 | 14.07 | 13.73 | 13.76 | 2472300.0 |
| 2024-06-04 | ABR.D | Stock | 18.7 | 18.8337 | 18.5 | 18.8337 | 30915.0 |
| 2024-06-04 | ABR.E | Stock | 18.15 | 18.4199 | 18.1177 | 18.23 | 7167.0 |
| 2024-06-04 | ABR.F | Stock | 20.1 | 20.2 | 19.95 | 19.95 | 14688.0 |
| 2024-06-04 | ABSI | Stock | 4.22 | 4.4 | 4.205 | 4.35 | 1302000.0 |
| 2024-06-04 | ABT | Stock | 102.8 | 103.49 | 102.54 | 103.43 | 3880400.0 |
| 2024-06-04 | ABTC | Stock | 90.75 | 94.5 | 90.75 | 91.5 | 2173.3333333333335 |
| 2024-06-04 | ABTS | Stock | 9.45 | 9.75 | 9.45 | 9.45 | 273.0 |
| 2024-06-04 | ABUS | Stock | 3.42 | 3.44 | 3.33 | 3.34 | 1002000.0 |
> showing 50 of 7,218 rows — these rows as CSV