PREVIEW / stock_daily / 2014-06-10

all stock daily files

  file:    by_date/stock_daily/2014/2014-06-10.parquet
  size:    219 KB
  rows:    6,551
  symbols: 3,550

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-06-10	AAPL	Stock	23.6825	23.7625	23.3925	23.5625	251108000.0
2014-06-10	MSFT	Stock	41.03	41.16	40.86	41.11	15117700.0
2014-06-10	NVDA	Stock	0.4745	0.481	0.4725	0.4788	217608000.0
2014-06-10	AMZN	Stock	16.3825	16.775	16.375	16.6205	73268000.0
2014-06-10	GOOGL	Stock	28.439	28.6	28.3065	28.415	29702300.0
2014-06-10	META	Stock	63.53	65.82	63.5	65.77	69338000.0
2014-06-10	TSLA	Stock	13.6287	13.798	13.4367	13.4867	52720500.0
2014-06-10	TLT	Stock	111.04	111.27	110.83	111.02	5990158.0
2014-06-10	ES	Stock	45.21	45.25	44.99	45.16	1110800.0
2014-06-10	CL	Stock	68.29	68.94	68.27	68.69	2931800.0
2014-06-10	A	Stock	42.3176	42.382	41.9027	42.1245	1772384.0
2014-06-10	AABA-DELISTED	Stock	35.87	36.52	35.86	36.31	8802398.0
2014-06-10	AACG	Stock	4.86	4.89	4.8	4.8	2500.0
2014-06-10	AAIC-DELISTED	Stock	27.89	27.944	27.641	27.7	321125.0
2014-06-10	AAL	Stock	43.5	43.86	42.93	43.66	8384400.0
2014-06-10	AAMC-DELISTED	Stock	320.5906	322.4926	314.7059	318.8	25282.0
2014-06-10	AAME	Stock	3.66	3.7	3.56	3.7	9900.0
2014-06-10	AAOI	Stock	21.23	22.32	21.02	22.28	201200.0
2014-06-10	AAON	Stock	14.7556	14.8356	14.5022	14.6044	157950.0
2014-06-10	AAP	Stock	127.07	127.63	126.21	126.97	519200.0
2014-06-10	AAT	Stock	34.53	34.62	33.85	34.29	237300.0
2014-06-10	AAU-DELISTED	Stock	1.36	1.36	1.31	1.31	111234.0
2014-06-10	AAUAF-DELISTED	Stock	1.36	1.36	1.31	1.31	114604.0
2014-06-10	AAV-DELISTED	Stock	6.79	6.83	6.6807	6.76	347216.0
2014-06-10	AAWW-DELISTED	Stock	38.58	38.95	38.146	38.45	139126.0
2014-06-10	AAXJ	Stock	63.13	63.28	63.04	63.26	316859.0
2014-06-10	AAXN-DELISTED	Stock	13.42	14.65	13.18	14.28	2417897.0
2014-06-10	AB	Stock	25.65	25.74	25.31	25.64	164000.0
2014-06-10	ABAC-DELISTED	Stock	2.131	2.17	2.12	2.12	10064.0
2014-06-10	ABAX-DELISTED	Stock	44.08	44.16	43.34	43.48	113373.0
2014-06-10	ABB-DELISTED	Stock	23.7	23.805	23.63	23.75	1237160.0
2014-06-10	ABBNY-DELISTED	Stock	23.7	23.805	23.63	23.73	1340770.0
2014-06-10	ABBV	Stock	53.14	54.08	52.29	53.97	8414700.0
2014-06-10	ABC-DELISTED	Stock	72.17	72.57	71.68	72.02	1645259.0
2014-06-10	ABCB	Stock	22.25	22.25	21.84	22.08	29300.0
2014-06-10	ABCD-DELISTED	Stock	1.99	2.04	1.9	2.0	48913.0
2014-06-10	ABCO-DELISTED	Stock	51.11	51.44	50.31	50.95	138746.0
2014-06-10	ABDC-DELISTED	Stock	14.73	14.75	14.55	14.74	24951.0
2014-06-10	ABE-DELISTED	Stock	14.6	14.7	14.6	14.7	16212.0
2014-06-10	ABEO	Stock	425.0	425.0	400.0	400.0	11.0
2014-06-10	ABEV	Stock	7.22	7.32	7.21	7.25	7769600.0
2014-06-10	ABG	Stock	65.18	65.86	64.86	65.5	225400.0
2014-06-10	ABGB-DELISTED	Stock	27.53	27.65	27.3	27.3101	7073.0
2014-06-10	ABIL-DELISTED	Stock	9.75	9.75	9.75	9.75	272.0
2014-06-10	ABM	Stock	26.91	27.07	26.69	26.99	253600.0
2014-06-10	ABMD-DELISTED	Stock	23.39	23.4	22.71	23.16	147788.0
2014-06-10	ABR	Stock	7.22	7.25	7.18	7.2	84300.0
2014-06-10	ABR.A-DELISTED	Stock	24.25	24.2999	24.24	24.2999	4705.0
2014-06-10	ABR.B-DELISTED	Stock	23.7	23.84	23.5	23.59	4720.0
2014-06-10	ABR.C-DELISTED	Stock	24.95	25.02	24.95	25.0199	3275.0

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

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