PREVIEW / stock_daily / 2013-02-12
file: by_date/stock_daily/2013/2013-02-12.parquet size: 207 KB rows: 6,286 symbols: 3,497
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 |
|---|---|---|---|---|---|---|---|
| 2013-02-12 | AAPL | Stock | 17.1254 | 17.2279 | 16.705 | 16.7107 | 609053200.0 |
| 2013-02-12 | MSFT | Stock | 27.88 | 28.0 | 27.75 | 27.88 | 35990900.0 |
| 2013-02-12 | NVDA | Stock | 0.31 | 0.3143 | 0.3095 | 0.3108 | 277804000.0 |
| 2013-02-12 | AMZN | Stock | 12.9595 | 13.008 | 12.85 | 12.935 | 58874000.0 |
| 2013-02-12 | META | Stock | 27.67 | 28.16 | 27.1 | 27.37 | 93498700.0 |
| 2013-02-12 | TSLA | Stock | 2.5633 | 2.5913 | 2.486 | 2.526 | 33919500.0 |
| 2013-02-12 | TLT | Stock | 116.69 | 117.02 | 116.46 | 116.74 | 4513646.0 |
| 2013-02-12 | ES | Stock | 41.06 | 41.16 | 40.83 | 41.15 | 1093100.0 |
| 2013-02-12 | CL | Stock | 54.2 | 54.24 | 53.895 | 54.025 | 2875600.0 |
| 2013-02-12 | A | Stock | 32.0529 | 32.1531 | 31.8312 | 31.917 | 3318572.0 |
| 2013-02-12 | AABA-DELISTED | Stock | 20.91 | 21.4 | 20.887 | 21.21 | 27477550.0 |
| 2013-02-12 | AACC-DELISTED | Stock | 5.36 | 5.63 | 5.33 | 5.55 | 15969.0 |
| 2013-02-12 | AACG | Stock | 4.61 | 4.99 | 4.0 | 4.31 | 68500.0 |
| 2013-02-12 | AAIC-DELISTED | Stock | 25.12 | 25.69 | 25.09 | 25.37 | 291183.0 |
| 2013-02-12 | AAMC-DELISTED | Stock | 39.4118 | 39.6765 | 36.7647 | 36.7647 | 26982.0 |
| 2013-02-12 | AAME | Stock | 3.38 | 3.42 | 3.38 | 3.42 | 3000.0 |
| 2013-02-12 | AAMRQ-DELISTED | Stock | 1.445 | 1.45 | 1.17 | 1.255 | 14222772.0 |
| 2013-02-12 | AAON | Stock | 7.0222 | 7.1022 | 7.0074 | 7.0785 | 188325.0 |
| 2013-02-12 | AAP | Stock | 78.39 | 78.63 | 77.51 | 78.6 | 876100.0 |
| 2013-02-12 | AAT | Stock | 29.65 | 29.77 | 29.46 | 29.77 | 114500.0 |
| 2013-02-12 | AAU-DELISTED | Stock | 2.49 | 2.509 | 2.41 | 2.47 | 179483.0 |
| 2013-02-12 | AAUAF-DELISTED | Stock | 2.49 | 2.509 | 2.41 | 2.47 | 180383.0 |
| 2013-02-12 | AAV-DELISTED | Stock | 3.11 | 3.15 | 3.09 | 3.09 | 414224.0 |
| 2013-02-12 | AAWW-DELISTED | Stock | 45.44 | 46.54 | 45.44 | 46.15 | 269157.0 |
| 2013-02-12 | AAXJ | Stock | 60.24 | 60.5 | 60.01 | 60.3 | 518543.0 |
| 2013-02-12 | AAXN-DELISTED | Stock | 8.57 | 8.8 | 8.51 | 8.77 | 793918.0 |
| 2013-02-12 | AB | Stock | 21.33 | 21.45 | 20.6 | 20.92 | 1074400.0 |
| 2013-02-12 | ABAC-DELISTED | Stock | 0.85 | 0.909 | 0.85 | 0.9 | 8870.0 |
| 2013-02-12 | ABAX-DELISTED | Stock | 42.97 | 43.65 | 42.7 | 43.07 | 173097.0 |
| 2013-02-12 | ABB-DELISTED | Stock | 20.93 | 21.2 | 20.905 | 21.12 | 1688705.0 |
| 2013-02-12 | ABBNY-DELISTED | Stock | 20.93 | 21.2 | 20.905 | 21.11 | 1732356.0 |
| 2013-02-12 | ABBV | Stock | 35.77 | 35.9 | 35.2 | 35.42 | 7473800.0 |
| 2013-02-12 | ABC-DELISTED | Stock | 46.7 | 47.05 | 46.6 | 46.97 | 1313847.0 |
| 2013-02-12 | ABCB | Stock | 13.53 | 13.7 | 13.49 | 13.6 | 98000.0 |
| 2013-02-12 | ABCD-DELISTED | Stock | 1.31 | 1.32 | 1.31 | 1.32 | 200.0 |
| 2013-02-12 | ABCO-DELISTED | Stock | 50.25 | 50.61 | 49.97 | 50.54 | 266064.0 |
| 2013-02-12 | ABCW-DELISTED | Stock | 0.62 | 0.68 | 0.62 | 0.68 | 6774.0 |
| 2013-02-12 | ABE-DELISTED | Stock | 21.63 | 21.68 | 21.59 | 21.61 | 2255.0 |
| 2013-02-12 | ABEO | Stock | 562.5 | 637.5 | 562.5 | 637.5 | 1.0 |
| 2013-02-12 | ABFS-DELISTED | Stock | 10.93 | 11.25 | 10.86 | 11.0 | 239344.0 |
| 2013-02-12 | ABG | Stock | 36.08 | 36.61 | 36.02 | 36.21 | 100900.0 |
| 2013-02-12 | ABM | Stock | 22.03 | 22.21 | 22.03 | 22.14 | 114000.0 |
| 2013-02-12 | ABMD-DELISTED | Stock | 14.01 | 14.22 | 13.895 | 14.04 | 553611.0 |
| 2013-02-12 | ABR | Stock | 7.21 | 7.32 | 7.14 | 7.3 | 126800.0 |
| 2013-02-12 | ABR.A-DELISTED | Stock | 25.4 | 25.4 | 25.11 | 25.19 | 58400.0 |
| 2013-02-12 | ABT | Stock | 34.27 | 34.5 | 34.21 | 34.3 | 7069100.0 |
| 2013-02-12 | ABTL-DELISTED | Stock | 4.48 | 4.48 | 4.1625 | 4.27 | 19874.0 |
| 2013-02-12 | ABUS | Stock | 4.7 | 4.83 | 4.7 | 4.81 | 9700.0 |
| 2013-02-12 | ABV-DELISTED | Stock | 46.22 | 46.62 | 46.0 | 46.32 | 618712.0 |
| 2013-02-12 | ABX-DELISTED | Stock | 32.07 | 32.5 | 31.84 | 32.49 | 7573537.0 |
> showing 50 of 6,286 rows — these rows as CSV