PREVIEW / stock_daily / 2011-12-16

all stock daily files

  file:    by_date/stock_daily/2011/2011-12-16.parquet
  size:    198 KB
  rows:    6,163
  symbols: 3,562

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
2011-12-16	AAPL	Stock	13.5843	13.7196	13.5561	13.6079	421478400.0
2011-12-16	MSFT	Stock	25.67	26.17	25.63	26.0	101408100.0
2011-12-16	NVDA	Stock	0.3393	0.3458	0.3362	0.3378	619116000.0
2011-12-16	AMZN	Stock	9.121	9.2205	9.0155	9.063	133282000.0
2011-12-16	TSLA	Stock	1.9193	1.9287	1.8653	1.8667	15445500.0
2011-12-16	TLT	Stock	121.38	122.6201	121.29	122.32	9321865.0
2011-12-16	ES	Stock	34.82	35.15	34.53	34.74	2523500.0
2011-12-16	CL	Stock	45.5	45.52	44.64	44.945	6571400.0
2011-12-16	A	Stock	24.1273	24.4921	23.7911	23.9342	4365674.0
2011-12-16	AABA-DELISTED	Stock	15.05	15.255	14.92	14.96	31595180.0
2011-12-16	AACC-DELISTED	Stock	3.53	3.78	3.53	3.64	16332.0
2011-12-16	AACG	Stock	9.0	9.0	8.8	9.0	5400.0
2011-12-16	AAIC-DELISTED	Stock	22.48	22.67	21.7	21.86	99623.0
2011-12-16	AAME	Stock	2.0	2.0	1.98	1.98	700.0
2011-12-16	AAON	Stock	6.4089	6.5274	6.2252	6.2667	581175.0
2011-12-16	AAP	Stock	68.32	68.64	67.62	68.0	1083900.0
2011-12-16	AAT	Stock	20.42	20.84	20.01	20.58	518100.0
2011-12-16	AATI-DELISTED	Stock	5.76	5.76	5.74	5.74	883756.0
2011-12-16	AAU-DELISTED	Stock	2.15	2.364	2.1	2.13	376685.0
2011-12-16	AAUAF-DELISTED	Stock	2.11	2.32	2.07	2.13	384605.0
2011-12-16	AAV-DELISTED	Stock	3.71	3.98	3.71	3.92	431360.0
2011-12-16	AAWW-DELISTED	Stock	37.23	38.63	36.94	37.77	403089.0
2011-12-16	AAXJ	Stock	49.76	50.08	49.53	49.79	2073931.0
2011-12-16	AAXN-DELISTED	Stock	5.75	5.795	5.61	5.65	984661.0
2011-12-16	AB	Stock	13.05	13.18	12.7	13.02	546200.0
2011-12-16	ABAC-DELISTED	Stock	1.48	1.49	1.35	1.35	11770.0
2011-12-16	ABAX-DELISTED	Stock	27.31	27.83	27.21	27.73	177234.0
2011-12-16	ABB-DELISTED	Stock	17.88	18.01	17.63	17.79	1988439.0
2011-12-16	ABBNY-DELISTED	Stock	17.88	18.01	17.63	17.79	2344127.0
2011-12-16	ABC-DELISTED	Stock	36.57	36.99	36.32	36.755	5766122.0
2011-12-16	ABCB	Stock	10.34	10.46	10.1	10.18	93700.0
2011-12-16	ABCD-DELISTED	Stock	2.8	2.99	2.76	2.93	90368.0
2011-12-16	ABCO-DELISTED	Stock	36.15	36.2	35.71	36.0	345548.0
2011-12-16	ABCW-DELISTED	Stock	0.3524	0.3665	0.1406	0.1606	946140.0
2011-12-16	ABD-DELISTED	Stock	9.71	9.9	9.55	9.84	643440.0
2011-12-16	ABE-DELISTED	Stock	16.76	16.95	16.73	16.8999	7792.0
2011-12-16	ABEO	Stock	1800.0	1825.0	1650.0	1775.0	41.0
2011-12-16	ABFS-DELISTED	Stock	17.65	18.3	17.55	17.8	740958.0
2011-12-16	ABG	Stock	20.14	20.31	19.79	19.96	480200.0
2011-12-16	ABH-DELISTED	Stock	14.84	14.94	14.4	14.745	432371.0
2011-12-16	ABM	Stock	20.79	20.88	20.24	20.47	782200.0
2011-12-16	ABMD-DELISTED	Stock	20.02	20.35	19.24	19.24	712260.0
2011-12-16	ABR	Stock	3.23	3.57	3.23	3.5	130600.0
2011-12-16	ABT	Stock	26.3602	26.3698	26.2115	26.3362	22562318.0
2011-12-16	ABTL-DELISTED	Stock	3.7525	3.85	3.7038	3.85	15762.0
2011-12-16	ABUS	Stock	1.6	1.7	1.57	1.62	18100.0
2011-12-16	ABV-DELISTED	Stock	36.0	36.36	35.725	35.92	3621095.0
2011-12-16	ABVA-DELISTED	Stock	3.57	3.57	3.48	3.5	5945.0
2011-12-16	ABVT-DELISTED	Stock	65.29	65.79	64.63	65.71	251798.0
2011-12-16	ABX-DELISTED	Stock	44.7	45.79	44.57	45.01	10745209.0

> showing 50 of 6,163 rows — these rows as CSV

> unlock the full archive -- $79 one-time