PREVIEW / stock_daily / 2012-11-26

all stock daily files

  file:    by_date/stock_daily/2012/2012-11-26.parquet
  size:    200 KB
  rows:    6,211
  symbols: 3,511

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
2012-11-26	AAPL	Stock	20.5679	21.0714	20.4896	21.0546	630579600.0
2012-11-26	MSFT	Stock	27.54	27.58	27.17	27.39	85198700.0
2012-11-26	NVDA	Stock	0.298	0.3035	0.2975	0.3028	364600000.0
2012-11-26	AMZN	Stock	12.0195	12.216	11.9	12.181	83566000.0
2012-11-26	META	Stock	24.94	26.09	24.81	25.94	123865000.0
2012-11-26	TSLA	Stock	2.14	2.1533	2.108	2.1513	7437000.0
2012-11-26	TLT	Stock	125.16	125.52	124.75	124.8	2799647.0
2012-11-26	ES	Stock	37.71	38.29	37.71	38.11	2089600.0
2012-11-26	CL	Stock	53.655	54.045	53.545	53.93	1964800.0
2012-11-26	A	Stock	26.2446	26.8026	26.1731	26.8026	4589634.0
2012-11-26	AABA-DELISTED	Stock	18.89	19.0	18.7	18.75	33416968.0
2012-11-26	AACC-DELISTED	Stock	4.33	4.4	4.19	4.4	20985.0
2012-11-26	AACG	Stock	4.38	4.4	4.35	4.35	3700.0
2012-11-26	AAIC-DELISTED	Stock	21.0	21.02	20.5	20.86	120181.0
2012-11-26	AAME	Stock	2.93	2.93	2.93	2.93	100.0
2012-11-26	AAMRQ-DELISTED	Stock	0.4411	0.53	0.4411	0.529	13811909.0
2012-11-26	AAON	Stock	6.0089	6.1156	5.9911	6.1067	124538.0
2012-11-26	AAP	Stock	78.58	79.05	77.59	78.16	741200.0
2012-11-26	AAT	Stock	27.76	27.91	27.6	27.85	114300.0
2012-11-26	AAU-DELISTED	Stock	2.57	3.0	2.57	2.73	864451.0
2012-11-26	AAUAF-DELISTED	Stock	2.57	3.0	2.57	2.72	865951.0
2012-11-26	AAV-DELISTED	Stock	3.41	3.44	3.34	3.35	617960.0
2012-11-26	AAWW-DELISTED	Stock	42.39	43.73	42.36	43.5	150102.0
2012-11-26	AAXJ	Stock	57.37	57.45	57.09	57.45	176149.0
2012-11-26	AAXN-DELISTED	Stock	8.04	8.58	7.89	8.541	909845.0
2012-11-26	AB	Stock	18.1	18.25	17.96	18.14	816800.0
2012-11-26	ABAC-DELISTED	Stock	0.8	0.921	0.7803	0.855	58091.0
2012-11-26	ABAX-DELISTED	Stock	36.75	37.12	36.71	37.12	55881.0
2012-11-26	ABB-DELISTED	Stock	18.74	18.88	18.73	18.88	1452092.0
2012-11-26	ABBNY-DELISTED	Stock	18.74	18.88	18.73	18.87	1517542.0
2012-11-26	ABC-DELISTED	Stock	41.35	41.49	41.15	41.46	2539617.0
2012-11-26	ABCB	Stock	10.87	10.98	10.64	10.94	43300.0
2012-11-26	ABCD-DELISTED	Stock	1.0	1.06	1.0	1.04	16580.0
2012-11-26	ABCO-DELISTED	Stock	43.62	43.87	42.93	43.29	209208.0
2012-11-26	ABCW-DELISTED	Stock	0.41	0.41	0.3701	0.4	20476.0
2012-11-26	ABE-DELISTED	Stock	20.07	20.35	20.07	20.23	28647.0
2012-11-26	ABEO	Stock	312.5	325.0	287.5	325.0	77.0
2012-11-26	ABFS-DELISTED	Stock	7.57	8.1599	7.55	8.05	564160.0
2012-11-26	ABG	Stock	30.67	30.73	29.24	29.83	257200.0
2012-11-26	ABM	Stock	18.94	19.02	18.76	18.97	161200.0
2012-11-26	ABMD-DELISTED	Stock	14.18	14.38	13.9825	14.32	683396.0
2012-11-26	ABR	Stock	5.21	5.31	5.17	5.23	112200.0
2012-11-26	ABT	Stock	30.7456	30.8943	30.4769	30.8799	11596915.0
2012-11-26	ABTL-DELISTED	Stock	3.8	4.0003	3.8	3.87	26183.0
2012-11-26	ABUS	Stock	5.3	5.68	5.24	5.58	148700.0
2012-11-26	ABV-DELISTED	Stock	41.16	41.2	40.65	41.06	1524388.0
2012-11-26	ABVA-DELISTED	Stock	4.58	5.03	4.51	4.62	5600.0
2012-11-26	ABX-DELISTED	Stock	35.49	35.5	34.73	35.26	6195287.0
2012-11-26	ACAD	Stock	2.23	2.37	2.17	2.3	3061700.0
2012-11-26	ACAS-DELISTED	Stock	11.81	11.91	11.7503	11.88	2188060.0

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

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