PREVIEW / stock_daily / 2010-04-30
file: by_date/stock_daily/2010/2010-04-30.parquet size: 194 KB rows: 5,984 symbols: 3,527
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 |
|---|---|---|---|---|---|---|---|
| 2010-04-30 | AAPL | Stock | 9.6182 | 9.6632 | 9.3214 | 9.3246 | 542463600.0 |
| 2010-04-30 | MSFT | Stock | 31.07 | 31.08 | 30.52 | 30.54 | 63214800.0 |
| 2010-04-30 | NVDA | Stock | 0.4112 | 0.412 | 0.3925 | 0.3928 | 1068048000.0 |
| 2010-04-30 | AMZN | Stock | 7.07 | 7.07 | 6.8455 | 6.855 | 122270000.0 |
| 2010-04-30 | TLT | Stock | 91.28 | 92.17 | 91.11 | 92.13 | 6924749.0 |
| 2010-04-30 | ES | Stock | 27.65 | 28.03 | 27.59 | 27.79 | 1411800.0 |
| 2010-04-30 | CL | Stock | 42.62 | 42.73 | 42.01 | 42.05 | 5243600.0 |
| 2010-04-30 | A | Stock | 26.6452 | 26.774 | 25.9156 | 25.9371 | 4195678.0 |
| 2010-04-30 | AABA-DELISTED | Stock | 17.08 | 17.1299 | 16.53 | 16.53 | 19400017.0 |
| 2010-04-30 | AACC-DELISTED | Stock | 7.4 | 7.44 | 6.91 | 7.35 | 70975.0 |
| 2010-04-30 | AACG | Stock | 3.55 | 3.55 | 3.5 | 3.53 | 18600.0 |
| 2010-04-30 | AAI-DELISTED | Stock | 5.33 | 5.43 | 5.27 | 5.28 | 3851155.0 |
| 2010-04-30 | AAIC-DELISTED | Stock | 20.75 | 20.89 | 20.14 | 20.16 | 25670.0 |
| 2010-04-30 | AAME | Stock | 1.78 | 1.88 | 1.76 | 1.79 | 7300.0 |
| 2010-04-30 | AAON | Stock | 4.8711 | 4.96 | 4.7684 | 4.7704 | 390319.0 |
| 2010-04-30 | AAP | Stock | 46.02 | 46.25 | 44.96 | 45.1 | 1376200.0 |
| 2010-04-30 | AATI-DELISTED | Stock | 4.0 | 4.01 | 3.8 | 3.8 | 474199.0 |
| 2010-04-30 | AAU-DELISTED | Stock | 1.11 | 1.18 | 1.11 | 1.17 | 256114.0 |
| 2010-04-30 | AAUAF-DELISTED | Stock | 1.11 | 1.18 | 1.11 | 1.17 | 257714.0 |
| 2010-04-30 | AAV-DELISTED | Stock | 7.19 | 7.19 | 7.09 | 7.12 | 278443.0 |
| 2010-04-30 | AAWW-DELISTED | Stock | 56.67 | 57.21 | 55.16 | 55.24 | 281288.0 |
| 2010-04-30 | AAXJ | Stock | 57.94 | 57.94 | 56.87 | 56.95 | 555055.0 |
| 2010-04-30 | AAXN-DELISTED | Stock | 4.86 | 4.91 | 4.73 | 4.73 | 1469980.0 |
| 2010-04-30 | AB | Stock | 32.28 | 32.32 | 31.31 | 31.39 | 354500.0 |
| 2010-04-30 | ABAX-DELISTED | Stock | 27.0 | 27.17 | 25.72 | 25.91 | 481614.0 |
| 2010-04-30 | ABB-DELISTED | Stock | 19.47 | 19.48 | 19.14 | 19.18 | 4136703.0 |
| 2010-04-30 | ABBC-DELISTED | Stock | 9.48 | 9.6 | 9.23 | 9.49 | 87203.0 |
| 2010-04-30 | ABBNY-DELISTED | Stock | 19.47 | 19.48 | 19.14 | 19.16 | 4200113.0 |
| 2010-04-30 | ABC-DELISTED | Stock | 31.42 | 31.6 | 30.85 | 30.86 | 3349668.0 |
| 2010-04-30 | ABCB | Stock | 10.9976 | 11.2962 | 10.8882 | 11.0773 | 265760.0 |
| 2010-04-30 | ABCD-DELISTED | Stock | 5.15 | 5.15 | 4.99 | 4.99 | 31607.0 |
| 2010-04-30 | ABCO-DELISTED | Stock | 17.185 | 17.19 | 16.465 | 16.465 | 93250.0 |
| 2010-04-30 | ABCW-DELISTED | Stock | 1.07 | 1.1 | 0.97 | 1.0 | 349350.0 |
| 2010-04-30 | ABD-DELISTED | Stock | 9.355 | 9.455 | 9.125 | 9.135 | 544050.0 |
| 2010-04-30 | ABE-DELISTED | Stock | 17.01 | 17.095 | 16.91 | 16.915 | 5860.0 |
| 2010-04-30 | ABEO | Stock | 3375.0 | 3375.0 | 3250.0 | 3300.0 | 23.0 |
| 2010-04-30 | ABFS-DELISTED | Stock | 31.14 | 32.05 | 30.46 | 30.47 | 620681.0 |
| 2010-04-30 | ABG | Stock | 16.31 | 16.85 | 15.52 | 15.55 | 650800.0 |
| 2010-04-30 | ABII-DELISTED | Stock | 49.94 | 50.66 | 49.59 | 49.97 | 41580.0 |
| 2010-04-30 | ABK-DELISTED | Stock | 1.65 | 1.67 | 1.44 | 1.49 | 49355983.0 |
| 2010-04-30 | ABM | Stock | 21.98 | 22.05 | 21.47 | 21.49 | 245300.0 |
| 2010-04-30 | ABMD-DELISTED | Stock | 9.8 | 9.9 | 9.5 | 9.63 | 202390.0 |
| 2010-04-30 | ABR | Stock | 4.22 | 4.49 | 4.04 | 4.08 | 213800.0 |
| 2010-04-30 | ABT | Stock | 24.3978 | 24.7097 | 24.2923 | 24.5466 | 22310754.0 |
| 2010-04-30 | ABTL-DELISTED | Stock | 4.6 | 4.6505 | 4.3 | 4.6 | 12266.0 |
| 2010-04-30 | ABV-DELISTED | Stock | 97.58 | 98.95 | 97.22 | 97.89 | 372818.0 |
| 2010-04-30 | ABVA-DELISTED | Stock | 3.115 | 3.115 | 3.1001 | 3.1001 | 200.0 |
| 2010-04-30 | ABVT-DELISTED | Stock | 50.97 | 51.555 | 50.45 | 50.47 | 87167.0 |
| 2010-04-30 | ABX-DELISTED | Stock | 43.4 | 44.37 | 43.27 | 43.54 | 14073551.0 |
| 2010-04-30 | ACAD | Stock | 1.65 | 1.69 | 1.6 | 1.66 | 421300.0 |
> showing 50 of 5,984 rows — these rows as CSV