PREVIEW / stock_daily / 2009-04-03
file: by_date/stock_daily/2009/2009-04-03.parquet size: 176 KB rows: 5,755 symbols: 3,433
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 |
|---|---|---|---|---|---|---|---|
| 2009-04-03 | AAPL | Stock | 4.0782 | 4.1475 | 4.0543 | 4.1425 | 636241200.0 |
| 2009-04-03 | MSFT | Stock | 19.13 | 19.15 | 18.43 | 18.75 | 81858400.0 |
| 2009-04-03 | NVDA | Stock | 0.2648 | 0.2838 | 0.2603 | 0.283 | 1003208000.0 |
| 2009-04-03 | AMZN | Stock | 3.821 | 3.916 | 3.775 | 3.9085 | 116198000.0 |
| 2009-04-03 | TLT | Stock | 104.91 | 105.16 | 102.66 | 102.92 | 3316754.0 |
| 2009-04-03 | ES | Stock | 21.19 | 21.41 | 20.84 | 21.08 | 1708600.0 |
| 2009-04-03 | CL | Stock | 30.715 | 30.755 | 29.9 | 30.22 | 7900400.0 |
| 2009-04-03 | A | Stock | 11.2303 | 11.8741 | 11.2303 | 11.774 | 4024842.0 |
| 2009-04-03 | AABA-DELISTED | Stock | 12.95 | 13.39 | 12.78 | 13.34 | 18376450.0 |
| 2009-04-03 | AACC-DELISTED | Stock | 6.0 | 6.25 | 5.98 | 6.13 | 204181.0 |
| 2009-04-03 | AACG | Stock | 4.32 | 4.44 | 4.15 | 4.25 | 27500.0 |
| 2009-04-03 | AAI-DELISTED | Stock | 5.04 | 5.16 | 4.92 | 5.07 | 1589648.0 |
| 2009-04-03 | AAIC-DELISTED | Stock | 5.0 | 5.2 | 4.6 | 5.0 | 373099.0 |
| 2009-04-03 | AAME | Stock | 0.48 | 0.5 | 0.45 | 0.45 | 6200.0 |
| 2009-04-03 | AAON | Stock | 3.6899 | 3.6899 | 3.6089 | 3.6543 | 392850.0 |
| 2009-04-03 | AAP | Stock | 38.55 | 40.51 | 38.11 | 40.51 | 3577500.0 |
| 2009-04-03 | AATI-DELISTED | Stock | 3.83 | 3.9 | 3.68 | 3.9 | 151502.0 |
| 2009-04-03 | AAU-DELISTED | Stock | 0.77 | 0.79 | 0.75 | 0.79 | 66056.0 |
| 2009-04-03 | AAUAF-DELISTED | Stock | 0.77 | 0.79 | 0.75 | 0.79 | 65856.0 |
| 2009-04-03 | AAV-DELISTED | Stock | 2.61 | 2.67 | 2.52 | 2.54 | 730295.0 |
| 2009-04-03 | AAWW-DELISTED | Stock | 19.58 | 20.19 | 19.14 | 19.83 | 226439.0 |
| 2009-04-03 | AAXJ | Stock | 36.28 | 36.42 | 35.79 | 36.375 | 90718.0 |
| 2009-04-03 | AAXN-DELISTED | Stock | 4.87 | 4.94 | 4.68 | 4.8 | 720285.0 |
| 2009-04-03 | AB | Stock | 16.24 | 17.25 | 16.19 | 16.93 | 778500.0 |
| 2009-04-03 | ABAX-DELISTED | Stock | 18.57 | 18.75 | 17.94 | 18.5 | 192738.0 |
| 2009-04-03 | ABB-DELISTED | Stock | 15.15 | 15.23 | 14.85 | 15.19 | 3517107.0 |
| 2009-04-03 | ABBC-DELISTED | Stock | 8.39 | 8.54 | 8.26 | 8.35 | 40486.0 |
| 2009-04-03 | ABBNY-DELISTED | Stock | 15.15 | 15.23 | 14.85 | 15.2 | 3521607.0 |
| 2009-04-03 | ABC-DELISTED | Stock | 16.84 | 16.84 | 16.24 | 16.4 | 3377276.0 |
| 2009-04-03 | ABCB | Stock | 5.8845 | 6.5459 | 5.8067 | 6.4292 | 34854.0 |
| 2009-04-03 | ABCO-DELISTED | Stock | 8.782 | 9.093 | 8.712 | 8.953 | 61970.0 |
| 2009-04-03 | ABCW-DELISTED | Stock | 1.43 | 1.5 | 1.27 | 1.36 | 115290.0 |
| 2009-04-03 | ABD-DELISTED | Stock | 1.4896 | 1.715 | 1.323 | 1.47 | 411100.0 |
| 2009-04-03 | ABE-DELISTED | Stock | 12.77 | 12.9 | 12.53 | 12.73 | 11641.0 |
| 2009-04-03 | ABEO | Stock | 2050.0 | 2050.0 | 1875.0 | 1937.5 | 6.0 |
| 2009-04-03 | ABFS-DELISTED | Stock | 20.65 | 20.65 | 19.53 | 20.54 | 859384.0 |
| 2009-04-03 | ABG | Stock | 5.59 | 5.84 | 5.42 | 5.8 | 415500.0 |
| 2009-04-03 | ABII-DELISTED | Stock | 46.85 | 47.91 | 45.47 | 45.47 | 18865.0 |
| 2009-04-03 | ABK-DELISTED | Stock | 0.87 | 0.9 | 0.84 | 0.89 | 4908060.0 |
| 2009-04-03 | ABM | Stock | 16.28 | 16.85 | 16.22 | 16.81 | 410200.0 |
| 2009-04-03 | ABMD-DELISTED | Stock | 5.14 | 5.35 | 5.14 | 5.25 | 240442.0 |
| 2009-04-03 | ABR | Stock | 0.85 | 0.9 | 0.79 | 0.88 | 115600.0 |
| 2009-04-03 | ABT | Stock | 21.8549 | 22.1428 | 21.0008 | 21.1688 | 29112964.0 |
| 2009-04-03 | ABTL-DELISTED | Stock | 1.3755 | 1.3765 | 1.2736 | 1.35 | 5562.0 |
| 2009-04-03 | ABV-DELISTED | Stock | 51.72 | 53.21 | 50.71 | 53.02 | 832777.0 |
| 2009-04-03 | ABVT-DELISTED | Stock | 46.0 | 47.0 | 46.0 | 47.0 | 70700.0 |
| 2009-04-03 | ABX-DELISTED | Stock | 32.23 | 32.73 | 30.0 | 30.45 | 15632327.0 |
| 2009-04-03 | ACAD | Stock | 1.05 | 1.08 | 1.0 | 1.04 | 133300.0 |
| 2009-04-03 | ACAP-DELISTED | Stock | 42.11 | 42.49 | 41.49 | 42.13 | 20004.0 |
| 2009-04-03 | ACAS-DELISTED | Stock | 2.45 | 2.68 | 2.41 | 2.5 | 6197490.0 |
> showing 50 of 5,755 rows — these rows as CSV