PREVIEW / stock_daily / 2006-05-24
file: by_date/stock_daily/2006/2006-05-24.parquet size: 148 KB rows: 4,439 symbols: 2,805
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 |
|---|---|---|---|---|---|---|---|
| 2006-05-24 | AAPL | Stock | 2.2496 | 2.2732 | 2.1986 | 2.2621 | 916031200.0 |
| 2006-05-24 | MSFT | Stock | 22.99 | 23.54 | 22.98 | 23.5 | 107356700.0 |
| 2006-05-24 | NVDA | Stock | 0.3992 | 0.4127 | 0.3902 | 0.4008 | 579522000.0 |
| 2006-05-24 | AMZN | Stock | 1.6705 | 1.7615 | 1.6685 | 1.7595 | 190842000.0 |
| 2006-05-24 | CL | Stock | 29.76 | 30.03 | 29.595 | 29.895 | 7402200.0 |
| 2006-05-24 | A | Stock | 24.5994 | 25.0501 | 23.9628 | 24.4063 | 4552587.0 |
| 2006-05-24 | AABA-DELISTED | Stock | 30.9500007629395 | 32.0200004577637 | 30.7099990844727 | 31.7900009155273 | 27286300.0 |
| 2006-05-24 | AACC-DELISTED | Stock | 17.37 | 17.92 | 17.37 | 17.72 | 391364.0 |
| 2006-05-24 | AACQ-DELISTED | Stock | 5.34 | 5.35 | 5.34 | 5.35 | 9775.0 |
| 2006-05-24 | AACQU-DELISTED | Stock | 6.42 | 6.5 | 6.42 | 6.5 | 10775.0 |
| 2006-05-24 | AACQW-DELISTED | Stock | 0.59 | 0.6 | 0.59 | 0.6 | 27550.0 |
| 2006-05-24 | AAI-DELISTED | Stock | 12.7 | 12.82 | 12.01 | 12.19 | 2460200.0 |
| 2006-05-24 | AAIC-DELISTED | Stock | 191.6 | 196.8 | 190.2 | 194.8 | 1050400.0 |
| 2006-05-24 | AAME | Stock | 2.84 | 3.1 | 2.84 | 3.01 | 2500.0 |
| 2006-05-24 | AAON | Stock | 3.0749 | 3.0749 | 2.7681 | 3.0551 | 230091.0 |
| 2006-05-24 | AAP | Stock | 37.98 | 38.59 | 37.6 | 38.17 | 1146300.0 |
| 2006-05-24 | AATI-DELISTED | Stock | 10.63 | 11.0 | 10.47 | 10.96 | 248340.0 |
| 2006-05-24 | AAU-DELISTED | Stock | 2.49 | 2.49 | 2.22 | 2.32 | 128400.0 |
| 2006-05-24 | AAUAF-DELISTED | Stock | 2.49 | 2.49 | 2.22 | 2.32 | 128400.0 |
| 2006-05-24 | AAV-DELISTED | Stock | 18.85 | 18.85 | 18.3 | 18.57 | 283800.0 |
| 2006-05-24 | AAWW-DELISTED | Stock | 49.47 | 49.9 | 47.5 | 48.5 | 353500.0 |
| 2006-05-24 | AAXN-DELISTED | Stock | 9.51000022888184 | 9.64000034332275 | 9.3100004196167 | 9.57999992370605 | 2034200.0 |
| 2006-05-24 | AB | Stock | 62.6 | 63.77 | 61.5 | 62.65 | 297400.0 |
| 2006-05-24 | ABAX-DELISTED | Stock | 16.98 | 17.11 | 16.47 | 16.82 | 806665.0 |
| 2006-05-24 | ABB-DELISTED | Stock | 12.24 | 12.29 | 12.02 | 12.21 | 2352800.0 |
| 2006-05-24 | ABBC-DELISTED | Stock | 13.77 | 13.8 | 13.67 | 13.76 | 7907.0 |
| 2006-05-24 | ABC-DELISTED | Stock | 21.88 | 22.03 | 21.69 | 21.83 | 2328000.0 |
| 2006-05-24 | ABCB | Stock | 20.6687 | 21.155 | 20.4547 | 21.1161 | 12029.0 |
| 2006-05-24 | ABCO-DELISTED | Stock | 25.13 | 25.7 | 24.75 | 25.19 | 353410.0 |
| 2006-05-24 | ABCW-DELISTED | Stock | 29.25 | 29.58 | 28.52 | 29.49 | 76040.0 |
| 2006-05-24 | ABD-DELISTED | Stock | 22.47 | 22.68 | 21.97 | 22.14 | 646200.0 |
| 2006-05-24 | ABE-DELISTED | Stock | 12.4 | 12.4 | 11.6 | 11.89 | 58800.0 |
| 2006-05-24 | ABFS-DELISTED | Stock | 42.73 | 42.88 | 41.3 | 41.99 | 376915.0 |
| 2006-05-24 | ABG | Stock | 19.91 | 20.95 | 19.8 | 20.29 | 173700.0 |
| 2006-05-24 | ABK-DELISTED | Stock | 80.6 | 81.2 | 80.07 | 80.6 | 896200.0 |
| 2006-05-24 | ABM | Stock | 17.35 | 17.8 | 17.16 | 17.73 | 236600.0 |
| 2006-05-24 | ABMD-DELISTED | Stock | 11.75 | 12.54 | 11.75 | 12.46 | 105669.0 |
| 2006-05-24 | ABP-DELISTED | Stock | 4.32 | 4.5 | 4.22 | 4.26 | 288500.0 |
| 2006-05-24 | ABR | Stock | 23.9 | 24.0 | 23.51 | 23.76 | 614300.0 |
| 2006-05-24 | ABT | Stock | 19.9597 | 20.2668 | 19.9117 | 20.2236 | 11594623.0 |
| 2006-05-24 | ABTL-DELISTED | Stock | 15.45 | 16.35 | 15.35 | 16.25 | 48907.0 |
| 2006-05-24 | ABV-DELISTED | Stock | 40.75 | 40.88 | 38.4 | 39.6 | 884800.0 |
| 2006-05-24 | ABVA-DELISTED | Stock | 18.5 | 18.65 | 18.5 | 18.65 | 353.0 |
| 2006-05-24 | ABVT-DELISTED | Stock | 44.0 | 44.0 | 44.0 | 44.0 | 100.0 |
| 2006-05-24 | ABX-DELISTED | Stock | 30.4 | 30.97 | 29.72 | 30.08 | 7432600.0 |
| 2006-05-24 | ACAD | Stock | 9.86 | 10.1 | 9.52 | 9.81 | 227800.0 |
| 2006-05-24 | ACAP-DELISTED | Stock | 44.21 | 46.42 | 44.14 | 46.17 | 46135.0 |
| 2006-05-24 | ACAS-DELISTED | Stock | 34.05 | 34.14 | 33.69 | 34.14 | 1470202.0 |
| 2006-05-24 | ACAT-DELISTED | Stock | 19.17 | 19.73 | 18.9 | 19.14 | 79598.0 |
| 2006-05-24 | ACC-DELISTED | Stock | 23.55 | 23.61 | 23.2 | 23.37 | 651900.0 |
> showing 50 of 4,439 rows — these rows as CSV