PREVIEW / stock_daily / 2013-04-16

all stock daily files

  file:    by_date/stock_daily/2013/2013-04-16.parquet
  size:    208 KB
  rows:    6,287
  symbols: 3,494

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-04-16	AAPL	Stock	15.0561	15.2361	15.0204	15.2229	305771200.0
2013-04-16	MSFT	Stock	28.9	29.14	28.7	28.97	52797300.0
2013-04-16	NVDA	Stock	0.3235	0.3263	0.3218	0.324	468844000.0
2013-04-16	AMZN	Stock	13.4655	13.64	13.403	13.617	42744000.0
2013-04-16	META	Stock	26.81	27.11	26.4	26.92	27365900.0
2013-04-16	TSLA	Stock	2.946	3.076	2.9273	3.0393	47706000.0
2013-04-16	TLT	Stock	121.92	122.52	121.8834	121.98	6554363.0
2013-04-16	ES	Stock	44.04	44.53	43.61	44.48	1123000.0
2013-04-16	CL	Stock	58.73	59.74	58.535	59.665	3551800.0
2013-04-16	A	Stock	31.0873	31.2947	30.6438	31.0372	6298270.0
2013-04-16	AABA-DELISTED	Stock	24.06	24.2599	23.755	23.79	30572889.0
2013-04-16	AACC-DELISTED	Stock	6.55	6.55	6.49	6.49	322309.0
2013-04-16	AAIC-DELISTED	Stock	25.6	26.13	25.51	25.93	241737.0
2013-04-16	AAMC-DELISTED	Stock	38.2353	38.5294	38.2353	38.4559	3825.0
2013-04-16	AAME	Stock	3.36	3.39	3.35	3.37	3200.0
2013-04-16	AAMRQ-DELISTED	Stock	3.77	4.08	3.76	4.01	15074002.0
2013-04-16	AAON	Stock	8.1481	8.2548	8.1185	8.2163	226125.0
2013-04-16	AAP	Stock	80.69	80.97	79.8	80.47	720300.0
2013-04-16	AAT	Stock	32.48	32.66	32.08	32.61	150300.0
2013-04-16	AAU-DELISTED	Stock	1.7014	1.763	1.6	1.64	241543.0
2013-04-16	AAUAF-DELISTED	Stock	1.66	1.72	1.6	1.64	254942.0
2013-04-16	AAV-DELISTED	Stock	3.66	3.7	3.62	3.64	160063.0
2013-04-16	AAWW-DELISTED	Stock	39.28	39.49	38.65	38.72	239665.0
2013-04-16	AAXJ	Stock	57.75	57.9	57.52	57.84	263212.0
2013-04-16	AAXN-DELISTED	Stock	7.75	7.95	7.7	7.93	579180.0
2013-04-16	AB	Stock	22.36	22.59	22.12	22.47	208000.0
2013-04-16	ABAC-DELISTED	Stock	0.868	0.87	0.82	0.85	57394.0
2013-04-16	ABAX-DELISTED	Stock	45.3	45.7399	44.6775	45.59	84420.0
2013-04-16	ABB-DELISTED	Stock	22.39	22.56	22.25	22.52	973198.0
2013-04-16	ABBNY-DELISTED	Stock	22.39	22.56	22.25	22.51	1013697.0
2013-04-16	ABBV	Stock	41.67	42.53	41.13	42.45	6998000.0
2013-04-16	ABC-DELISTED	Stock	54.48	54.9875	54.12	54.95	2027606.0
2013-04-16	ABCB	Stock	13.56	13.67	13.36	13.56	47200.0
2013-04-16	ABCD-DELISTED	Stock	0.99	1.02	0.99	1.02	13682.0
2013-04-16	ABCO-DELISTED	Stock	51.96	51.96	51.2402	51.38	202523.0
2013-04-16	ABCW-DELISTED	Stock	0.65	0.67	0.62	0.67	8881.0
2013-04-16	ABE-DELISTED	Stock	21.51	21.51	20.58	20.9238	1921.0
2013-04-16	ABEO	Stock	512.5	550.0	512.5	550.0	1.0
2013-04-16	ABFS-DELISTED	Stock	10.25	10.8	10.25	10.68	315119.0
2013-04-16	ABG	Stock	35.7	35.9	35.19	35.6	220100.0
2013-04-16	ABM	Stock	20.84	20.91	20.64	20.89	236800.0
2013-04-16	ABMD-DELISTED	Stock	16.46	16.48	16.05	16.33	404487.0
2013-04-16	ABR	Stock	7.45	7.67	7.45	7.51	188900.0
2013-04-16	ABR.A-DELISTED	Stock	25.77	25.87	25.77	25.87	9947.0
2013-04-16	ABT	Stock	36.28	36.48	35.9	36.4	7866000.0
2013-04-16	ABTL-DELISTED	Stock	4.21	4.23	4.15	4.21	3600.0
2013-04-16	ABUS	Stock	4.6	4.67	4.56	4.56	92600.0
2013-04-16	ABV-DELISTED	Stock	39.74	39.92	39.375	39.75	5202939.0
2013-04-16	ABX-DELISTED	Stock	20.75	20.77	18.669	18.869	40771795.0
2013-04-16	ACAD	Stock	12.3	12.65	12.15	12.39	3297000.0

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

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