PREVIEW / stock_daily / 2024-06-20
file: by_date/stock_daily/2024/2024-06-20.parquet size: 232 KB rows: 7,268 symbols: 959
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-20 | AAPL | Stock | 213.93 | 214.24 | 208.85 | 209.68 | 86172500.0 |
| 2024-06-20 | MSFT | Stock | 446.3 | 446.53 | 441.27 | 445.7 | 19877400.0 |
| 2024-06-20 | NVDA | Stock | 139.8 | 140.76 | 129.52 | 130.78 | 517768400.0 |
| 2024-06-20 | AMZN | Stock | 182.91 | 186.51 | 182.72 | 186.1 | 44726800.0 |
| 2024-06-20 | GOOGL | Stock | 175.37 | 177.29 | 174.99 | 176.3 | 20160085.0 |
| 2024-06-20 | META | Stock | 502.0 | 503.67 | 496.77 | 501.7 | 11801200.0 |
| 2024-06-20 | TSLA | Stock | 184.68 | 185.21 | 179.66 | 181.57 | 55893100.0 |
| 2024-06-20 | TLT | Stock | 93.41 | 94.0 | 93.34 | 93.96 | 30246274.0 |
| 2024-06-20 | ES | Stock | 57.8 | 58.47 | 57.5 | 57.99 | 1734500.0 |
| 2024-06-20 | CL | Stock | 96.79 | 97.41 | 96.25 | 96.95 | 4381700.0 |
| 2024-06-20 | A | Stock | 133.26 | 134.65 | 132.53 | 132.73 | 2887400.0 |
| 2024-06-20 | AA | Stock | 38.1 | 39.11 | 37.9 | 38.98 | 7089800.0 |
| 2024-06-20 | AACG | Stock | 0.83 | 0.85 | 0.78 | 0.83 | 10000.0 |
| 2024-06-20 | AACIW-DELISTED | Stock | 0.11601 | 0.1248 | 0.11601 | 0.1205 | 2400.0 |
| 2024-06-20 | AACT | Stock | 10.65 | 10.66 | 10.645 | 10.655 | 188800.0 |
| 2024-06-20 | AAGR-DELISTED | Stock | 0.35 | 0.35 | 0.2501 | 0.2904 | 237307.0 |
| 2024-06-20 | AAGRW-DELISTED | Stock | 0.0113 | 0.0127 | 0.0113 | 0.0127 | 744.0 |
| 2024-06-20 | AAL | Stock | 11.3 | 11.31 | 11.19 | 11.24 | 21364400.0 |
| 2024-06-20 | AAMC-DELISTED | Stock | 2.0 | 2.0 | 1.8 | 1.9 | 4800.0 |
| 2024-06-20 | AAME | Stock | 1.74 | 1.82 | 1.74 | 1.8 | 5200.0 |
| 2024-06-20 | AAMI | Stock | 21.87 | 22.47 | 21.78 | 22.39 | 223200.0 |
| 2024-06-20 | AAN-DELISTED | Stock | 10.02 | 10.05 | 9.98 | 9.98 | 1814200.0 |
| 2024-06-20 | AAOI | Stock | 10.0 | 10.09 | 8.8 | 8.87 | 1992200.0 |
| 2024-06-20 | AAON | Stock | 80.38 | 84.41 | 80.18 | 80.25 | 1431000.0 |
| 2024-06-20 | AAP | Stock | 63.91 | 66.39 | 63.83 | 66.14 | 1454700.0 |
| 2024-06-20 | AAT | Stock | 21.65 | 21.91 | 21.46 | 21.5 | 263700.0 |
| 2024-06-20 | AATC | Stock | 5.95 | 6.0 | 5.93 | 5.985 | 8359.0 |
| 2024-06-20 | AAUAF-DELISTED | Stock | 0.06 | 0.06832 | 0.06 | 0.0614 | 124379.0 |
| 2024-06-20 | AAXJ | Stock | 72.94 | 72.94 | 72.24 | 72.59 | 358188.0 |
| 2024-06-20 | AB | Stock | 33.23 | 34.0 | 33.23 | 33.97 | 189200.0 |
| 2024-06-20 | ABAT | Stock | 1.05 | 1.15 | 1.01 | 1.04 | 484149.0 |
| 2024-06-20 | ABBV | Stock | 171.18 | 172.81 | 170.02 | 172.13 | 5847500.0 |
| 2024-06-20 | ABCB | Stock | 47.82 | 48.35 | 47.61 | 47.94 | 581600.0 |
| 2024-06-20 | ABCL | Stock | 2.96 | 3.0 | 2.86 | 2.94 | 3320800.0 |
| 2024-06-20 | ABEO | Stock | 4.56 | 4.71 | 4.49 | 4.52 | 213600.0 |
| 2024-06-20 | ABEV | Stock | 2.09 | 2.11 | 2.05 | 2.08 | 22011100.0 |
| 2024-06-20 | ABG | Stock | 231.16 | 233.34 | 226.91 | 228.22 | 262000.0 |
| 2024-06-20 | ABLLW | Stock | 0.45 | 0.55 | 0.45 | 0.54 | 158941.0 |
| 2024-06-20 | ABLV | Stock | 1.07 | 1.07 | 0.998 | 1.01 | 37600.0 |
| 2024-06-20 | ABLVW | Stock | 0.05 | 0.05 | 0.0253 | 0.0253 | 843.0 |
| 2024-06-20 | ABM | Stock | 50.28 | 51.67 | 50.28 | 51.37 | 751700.0 |
| 2024-06-20 | ABNB | Stock | 147.77 | 149.75 | 147.6 | 147.88 | 2874200.0 |
| 2024-06-20 | ABOS | Stock | 2.33 | 2.36 | 2.17 | 2.21 | 475300.0 |
| 2024-06-20 | ABR | Stock | 14.04 | 14.12 | 13.98 | 14.1 | 1957400.0 |
| 2024-06-20 | ABR.D | Stock | 18.5 | 18.53 | 18.442 | 18.4989 | 10291.0 |
| 2024-06-20 | ABR.E | Stock | 18.2 | 18.25 | 18.13 | 18.25 | 22999.0 |
| 2024-06-20 | ABR.F | Stock | 20.03 | 20.07 | 19.9 | 19.99 | 16207.0 |
| 2024-06-20 | ABSI | Stock | 3.5 | 3.5 | 2.795 | 2.92 | 3968800.0 |
| 2024-06-20 | ABT | Stock | 103.53 | 106.84 | 103.47 | 106.57 | 9154900.0 |
| 2024-06-20 | ABTC | Stock | 96.75 | 96.75 | 91.875 | 93.0 | 3738.6666666666665 |
> showing 50 of 7,268 rows — these rows as CSV