PREVIEW / stock_daily / 2014-04-28

all stock daily files

  file:    by_date/stock_daily/2014/2014-04-28.parquet
  size:    219 KB
  rows:    6,536
  symbols: 3,548

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
2014-04-28	AAPL	Stock	20.4571	21.2768	20.4482	21.2175	669485600.0
2014-04-28	MSFT	Stock	40.14	41.29	40.09	40.87	50610200.0
2014-04-28	NVDA	Stock	0.472	0.4745	0.4605	0.4662	226788000.0
2014-04-28	AMZN	Stock	15.2	15.2195	14.4	14.829	289596000.0
2014-04-28	GOOGL	Stock	26.29	26.295	25.55	26.149	75055580.0
2014-04-28	META	Stock	58.05	58.31	54.66	56.14	107758000.0
2014-04-28	TSLA	Stock	13.3333	13.586	12.7	13.234	105630000.0
2014-04-28	TLT	Stock	111.11	111.28	110.55	110.79	7606297.0
2014-04-28	ES	Stock	46.85	47.4	46.85	47.31	2126500.0
2014-04-28	CL	Stock	66.66	67.95	66.58	67.86	4539000.0
2014-04-28	A	Stock	39.2346	39.2918	37.8112	38.4335	4206582.0
2014-04-28	AABA-DELISTED	Stock	34.64	35.0	33.65	33.99	29782791.0
2014-04-28	AACG	Stock	4.13	4.13	4.02	4.06	7400.0
2014-04-28	AAIC-DELISTED	Stock	25.73	25.88	25.3	25.55	222497.0
2014-04-28	AAL	Stock	36.41	36.72	34.34	35.16	13149300.0
2014-04-28	AAMC-DELISTED	Stock	287.5103	289.0588	264.7059	266.9118	68231.0
2014-04-28	AAME	Stock	3.48	3.5	3.43	3.5	4300.0
2014-04-28	AAOI	Stock	23.53	24.25	22.188	22.68	192400.0
2014-04-28	AAON	Stock	12.6667	12.8711	12.4667	12.5867	300375.0
2014-04-28	AAP	Stock	121.6	123.23	119.6	121.44	714000.0
2014-04-28	AAT	Stock	33.69	33.91	33.39	33.71	109700.0
2014-04-28	AAU-DELISTED	Stock	1.45	1.47	1.4	1.4	52285.0
2014-04-28	AAUAF-DELISTED	Stock	1.44	1.46	1.4	1.41	53155.0
2014-04-28	AAV-DELISTED	Stock	5.94	6.23	5.81	6.09	901422.0
2014-04-28	AAWW-DELISTED	Stock	34.69	35.03	33.901	34.31	167597.0
2014-04-28	AAXJ	Stock	59.39	59.62	59.13	59.5	366107.0
2014-04-28	AAXN-DELISTED	Stock	17.85	17.9332	16.51	16.78	1121018.0
2014-04-28	AB	Stock	25.75	25.75	24.95	25.17	256100.0
2014-04-28	ABAC-DELISTED	Stock	2.24	2.24	2.01	2.01	43482.0
2014-04-28	ABAX-DELISTED	Stock	39.3	41.29	39.3	40.79	191778.0
2014-04-28	ABB-DELISTED	Stock	26.16	26.35	25.96	26.26	2537425.0
2014-04-28	ABBNY-DELISTED	Stock	26.16	26.35	25.96	26.26	4937839.0
2014-04-28	ABBV	Stock	49.55	50.92	49.5	50.87	7932200.0
2014-04-28	ABC-DELISTED	Stock	63.07	63.68	62.69	63.44	1498199.0
2014-04-28	ABCB	Stock	21.79	22.0	21.46	21.9	71100.0
2014-04-28	ABCD-DELISTED	Stock	2.2107	2.339	2.2107	2.24	10145.0
2014-04-28	ABCO-DELISTED	Stock	57.93	57.93	55.08	56.85	259672.0
2014-04-28	ABE-DELISTED	Stock	13.328	13.34	13.241	13.33	4092.0
2014-04-28	ABEO	Stock	600.0	650.0	562.5	650.0	22.0
2014-04-28	ABEV	Stock	7.69	7.74	7.63	7.7	8870600.0
2014-04-28	ABFS-DELISTED	Stock	38.26	39.36	37.3	37.83	328212.0
2014-04-28	ABG	Stock	60.07	61.44	58.93	59.8	343900.0
2014-04-28	ABGB-DELISTED	Stock	22.15	22.27	21.671	22.09	22125.0
2014-04-28	ABIL-DELISTED	Stock	9.7	9.85	9.66	9.7	186779.0
2014-04-28	ABM	Stock	27.14	27.26	26.66	27.1	175400.0
2014-04-28	ABMD-DELISTED	Stock	24.8	24.8	23.639	24.0	388229.0
2014-04-28	ABR	Stock	7.0	7.03	6.96	6.98	112500.0
2014-04-28	ABR.A-DELISTED	Stock	25.06	25.1	24.93	25.1	21405.0
2014-04-28	ABR.B-DELISTED	Stock	23.7501	23.98	23.73	23.9	23618.0
2014-04-28	ABR.C-DELISTED	Stock	25.0501	25.28	25.0501	25.28	22619.0

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

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