PREVIEW / stock_daily / 2015-07-21

all stock daily files

  file:    by_date/stock_daily/2015/2015-07-21.parquet
  size:    224 KB
  rows:    6,654
  symbols: 3,471

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
2015-07-21	AAPL	Stock	33.2125	33.23	32.58	32.6875	307025600.0
2015-07-21	MSFT	Stock	46.78	47.33	46.48	47.28	42781900.0
2015-07-21	NVDA	Stock	0.4915	0.5018	0.4915	0.4948	149720000.0
2015-07-21	AMZN	Stock	24.395	24.444	24.1275	24.4	63636000.0
2015-07-21	GOOGL	Stock	34.244	35.28	34.2075	34.7675	75604600.0
2015-07-21	META	Stock	98.95	99.24	97.14	98.39	39453300.0
2015-07-21	TSLA	Stock	18.0033	18.2333	17.77	17.7847	91630500.0
2015-07-21	TLT	Stock	117.68	118.93	117.66	118.86	5627455.0
2015-07-21	ES	Stock	47.58	47.68	46.93	47.52	1683300.0
2015-07-21	CL	Stock	67.57	67.64	66.77	66.94	2699400.0
2015-07-21	A	Stock	39.97	40.01	39.54	39.57	1160900.0
2015-07-21	AA.B-DELISTED	Stock	38.0	38.43	37.62	37.7	227568.0
2015-07-21	AABA-DELISTED	Stock	39.63	39.85	39.355	39.72	13603242.0
2015-07-21	AAC-DELISTED	Stock	41.3	41.3	37.69	38.98	652937.0
2015-07-21	AACG	Stock	4.44	4.44	4.05	4.1	154900.0
2015-07-21	AAIC-DELISTED	Stock	19.93	19.96	19.72	19.93	352700.0
2015-07-21	AAL	Stock	40.5	41.3	40.49	40.9	7300000.0
2015-07-21	AAMC-DELISTED	Stock	40.2971	40.8088	39.6324	39.7853	29821.0
2015-07-21	AAME	Stock	3.7	3.7	3.7	3.7	700.0
2015-07-21	AAMI	Stock	17.72	17.94	17.61	17.75	175900.0
2015-07-21	AAOI	Stock	18.51	18.93	18.23	18.67	176600.0
2015-07-21	AAON	Stock	15.3333	15.4933	15.0	15.0867	193200.0
2015-07-21	AAP	Stock	168.54	168.93	166.55	167.53	525700.0
2015-07-21	AAT	Stock	41.27	41.52	40.89	40.96	115800.0
2015-07-21	AAU-DELISTED	Stock	0.708	0.71	0.65	0.66	125524.0
2015-07-21	AAUAF-DELISTED	Stock	0.705	0.71	0.65	0.66	126472.0
2015-07-21	AAV-DELISTED	Stock	5.61	5.85	5.61	5.84	91127.0
2015-07-21	AAVL-DELISTED	Stock	16.75	16.9	16.44	16.61	242057.0
2015-07-21	AAWW-DELISTED	Stock	51.03	52.34	50.97	51.71	602316.0
2015-07-21	AAXJ	Stock	61.43	61.66	61.25	61.3	724842.0
2015-07-21	AAXN-DELISTED	Stock	32.46	32.96	32.01	32.62	908684.0
2015-07-21	AB	Stock	28.31	28.56	28.23	28.5	106400.0
2015-07-21	ABAC-DELISTED	Stock	1.07	1.18	1.07	1.15	25565.0
2015-07-21	ABAX-DELISTED	Stock	53.81	55.94	53.67	55.94	112426.0
2015-07-21	ABB-DELISTED	Stock	20.74	20.81	20.62	20.63	1528968.0
2015-07-21	ABBNY-DELISTED	Stock	20.74	20.81	20.62	20.64	1600889.0
2015-07-21	ABBV	Stock	70.81	71.6	70.22	70.54	5028500.0
2015-07-21	ABC-DELISTED	Stock	114.65	114.94	113.5	114.06	1287251.0
2015-07-21	ABCB	Stock	25.96	26.32	25.87	26.04	65300.0
2015-07-21	ABCD-DELISTED	Stock	5.01	5.0999	4.97	5.06	94756.0
2015-07-21	ABCO-DELISTED	Stock	58.56	59.0	57.385	57.66	186668.0
2015-07-21	ABCW-DELISTED	Stock	40.53	40.58	39.53	40.04	19350.0
2015-07-21	ABDC-DELISTED	Stock	13.15	13.2875	12.75	12.76	45284.0
2015-07-21	ABE-DELISTED	Stock	13.08	13.13	13.058	13.13	1771.0
2015-07-21	ABEO	Stock	145.25	145.75	140.75	144.5	5312.0
2015-07-21	ABEOW-DELISTED	Stock	2.01	2.01	1.984	1.984	300.0
2015-07-21	ABEV	Stock	6.15	6.18	6.11	6.14	11323600.0
2015-07-21	ABG	Stock	93.25	94.36	89.99	91.4	1215400.0
2015-07-21	ABGB-DELISTED	Stock	15.13	15.18	14.7138	14.84	9863.0
2015-07-21	ABM	Stock	32.56	32.74	32.19	32.3	119400.0

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

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