PREVIEW / stock_daily / 2009-03-30
file: by_date/stock_daily/2009/2009-03-30.parquet size: 174 KB rows: 5,707 symbols: 3,409
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-03-30 | AAPL | Stock | 3.7325 | 3.7504 | 3.6646 | 3.7318 | 502796000.0 |
| 2009-03-30 | MSFT | Stock | 17.74 | 17.76 | 17.27 | 17.48 | 49633000.0 |
| 2009-03-30 | NVDA | Stock | 0.2515 | 0.2547 | 0.2412 | 0.2448 | 780052000.0 |
| 2009-03-30 | AMZN | Stock | 3.52 | 3.5835 | 3.4875 | 3.572 | 167462000.0 |
| 2009-03-30 | TLT | Stock | 105.44 | 105.87 | 103.94 | 104.96 | 2300003.0 |
| 2009-03-30 | ES | Stock | 21.36 | 21.73 | 21.26 | 21.52 | 2678800.0 |
| 2009-03-30 | CL | Stock | 29.5 | 29.555 | 28.95 | 29.395 | 5664200.0 |
| 2009-03-30 | A | Stock | 11.3162 | 11.3448 | 10.8298 | 11.0086 | 5550759.0 |
| 2009-03-30 | AABA-DELISTED | Stock | 12.925 | 13.14 | 12.51 | 12.7 | 16499773.0 |
| 2009-03-30 | AACC-DELISTED | Stock | 5.48 | 5.61 | 5.185 | 5.54 | 32018.0 |
| 2009-03-30 | AACG | Stock | 4.48 | 4.56 | 4.18 | 4.5 | 17500.0 |
| 2009-03-30 | AAI-DELISTED | Stock | 4.55 | 4.66 | 4.11 | 4.5 | 2183186.0 |
| 2009-03-30 | AAIC-DELISTED | Stock | 4.2 | 4.4 | 4.0 | 4.0 | 304854.0 |
| 2009-03-30 | AAON | Stock | 3.5595 | 3.5595 | 3.2928 | 3.3916 | 651037.0 |
| 2009-03-30 | AAP | Stock | 41.12 | 41.64 | 40.43 | 41.64 | 1594300.0 |
| 2009-03-30 | AATI-DELISTED | Stock | 3.62 | 3.62 | 3.37 | 3.6 | 249327.0 |
| 2009-03-30 | AAU-DELISTED | Stock | 0.8 | 0.81 | 0.77 | 0.78 | 22470.0 |
| 2009-03-30 | AAUAF-DELISTED | Stock | 0.8 | 0.81 | 0.77 | 0.78 | 22970.0 |
| 2009-03-30 | AAV-DELISTED | Stock | 2.46 | 2.49 | 2.27 | 2.45 | 1037235.0 |
| 2009-03-30 | AAWW-DELISTED | Stock | 17.34 | 17.76 | 15.21 | 16.24 | 223231.0 |
| 2009-03-30 | AAXJ | Stock | 32.7 | 33.57 | 32.18 | 32.36 | 90774.0 |
| 2009-03-30 | AAXN-DELISTED | Stock | 4.5 | 4.5 | 4.32 | 4.36 | 396325.0 |
| 2009-03-30 | AB | Stock | 15.19 | 15.19 | 13.81 | 13.92 | 496900.0 |
| 2009-03-30 | ABAX-DELISTED | Stock | 17.48 | 18.0 | 16.62 | 17.31 | 348617.0 |
| 2009-03-30 | ABB-DELISTED | Stock | 13.44 | 13.47 | 13.1 | 13.29 | 3340235.0 |
| 2009-03-30 | ABBC-DELISTED | Stock | 8.59 | 8.59 | 7.45 | 7.79 | 151407.0 |
| 2009-03-30 | ABBNY-DELISTED | Stock | 13.46 | 13.47 | 13.1 | 13.29 | 3340235.0 |
| 2009-03-30 | ABC-DELISTED | Stock | 16.05 | 16.16 | 15.75 | 16.13 | 3276284.0 |
| 2009-03-30 | ABCB | Stock | 5.5635 | 5.5635 | 5.0674 | 5.3009 | 25498.0 |
| 2009-03-30 | ABCO-DELISTED | Stock | 8.223 | 8.387 | 8.068 | 8.377 | 113795.0 |
| 2009-03-30 | ABCW-DELISTED | Stock | 1.1 | 1.32 | 1.01 | 1.24 | 276330.0 |
| 2009-03-30 | ABD-DELISTED | Stock | 1.2 | 1.22 | 1.1 | 1.16 | 303380.0 |
| 2009-03-30 | ABE-DELISTED | Stock | 11.33 | 11.92 | 11.33 | 11.548 | 18728.0 |
| 2009-03-30 | ABEO | Stock | 2125.0 | 2125.0 | 1887.5 | 1912.5 | 9.0 |
| 2009-03-30 | ABFS-DELISTED | Stock | 20.67 | 20.86 | 18.43 | 19.03 | 720551.0 |
| 2009-03-30 | ABG | Stock | 4.76 | 4.94 | 4.32 | 4.47 | 260700.0 |
| 2009-03-30 | ABII-DELISTED | Stock | 44.99 | 45.82 | 42.78 | 45.82 | 20533.0 |
| 2009-03-30 | ABK-DELISTED | Stock | 0.75 | 0.75 | 0.7 | 0.72 | 5283324.0 |
| 2009-03-30 | ABM | Stock | 16.3 | 16.46 | 15.81 | 16.14 | 289100.0 |
| 2009-03-30 | ABMD-DELISTED | Stock | 5.36 | 5.49 | 5.13 | 5.23 | 194176.0 |
| 2009-03-30 | ABR | Stock | 0.9 | 0.96 | 0.75 | 0.75 | 223200.0 |
| 2009-03-30 | ABT | Stock | 22.4019 | 23.088 | 22.3827 | 22.9776 | 29511463.0 |
| 2009-03-30 | ABTL-DELISTED | Stock | 1.35 | 1.35 | 1.2 | 1.25 | 10796.0 |
| 2009-03-30 | ABV-DELISTED | Stock | 47.65 | 48.14 | 46.47 | 47.16 | 696820.0 |
| 2009-03-30 | ABVA-DELISTED | Stock | 1.99 | 2.0 | 1.99 | 2.0 | 5300.0 |
| 2009-03-30 | ABVT-DELISTED | Stock | 45.0 | 45.25 | 44.0 | 44.0 | 607.0 |
| 2009-03-30 | ABX-DELISTED | Stock | 31.43 | 33.12 | 31.14 | 32.24 | 11239567.0 |
| 2009-03-30 | ACAD | Stock | 1.0 | 1.07 | 0.99 | 1.05 | 84200.0 |
| 2009-03-30 | ACAP-DELISTED | Stock | 41.0 | 42.34 | 41.0 | 41.64 | 42423.0 |
| 2009-03-30 | ACAS-DELISTED | Stock | 1.91 | 2.0168 | 1.7413 | 1.82 | 5156504.0 |
> showing 50 of 5,707 rows — these rows as CSV