PREVIEW / stock_daily / 2014-06-18

all stock daily files

  file:    by_date/stock_daily/2014/2014-06-18.parquet
  size:    221 KB
  rows:    6,592
  symbols: 3,572

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-18	AAPL	Stock	23.0675	23.0725	22.8375	23.045	134056000.0
2014-06-18	MSFT	Stock	41.61	41.74	41.18	41.65	27097000.0
2014-06-18	NVDA	Stock	0.489	0.492	0.4845	0.4898	215536000.0
2014-06-18	AMZN	Stock	16.4	16.7875	16.25	16.719	128030000.0
2014-06-18	GOOGL	Stock	27.64	28.07	27.579	28.033	41213620.0
2014-06-18	META	Stock	64.49	65.75	64.05	65.6	35570000.0
2014-06-18	TSLA	Stock	15.4333	15.4473	15.0747	15.1413	104103000.0
2014-06-18	TLT	Stock	111.8	112.76	111.56	112.4	11256460.0
2014-06-18	ES	Stock	45.52	46.87	45.52	46.8	1763200.0
2014-06-18	CL	Stock	67.76	68.77	67.76	68.73	2337700.0
2014-06-18	A	Stock	42.103	42.432	41.867	42.3963	1558351.0
2014-06-18	AABA-DELISTED	Stock	34.67	35.01	34.26	34.93	16822522.0
2014-06-18	AACG	Stock	4.88	4.95	4.5	4.75	12400.0
2014-06-18	AAIC-DELISTED	Stock	27.7	27.87	27.52	27.79	254754.0
2014-06-18	AAL	Stock	41.93	42.82	41.57	42.66	11249400.0
2014-06-18	AAMC-DELISTED	Stock	321.4706	322.0588	316.3529	322.0588	34122.0
2014-06-18	AAME	Stock	3.9	4.0	3.81	3.95	13100.0
2014-06-18	AAOI	Stock	21.86	23.1	21.68	23.04	353000.0
2014-06-18	AAON	Stock	14.5778	14.9156	14.4489	14.8889	315000.0
2014-06-18	AAP	Stock	126.71	130.51	126.71	129.72	935400.0
2014-06-18	AAT	Stock	34.09	34.43	33.89	34.36	108000.0
2014-06-18	AAU-DELISTED	Stock	1.39	1.405	1.375	1.4	111938.0
2014-06-18	AAUAF-DELISTED	Stock	1.39	1.41	1.38	1.4	113517.0
2014-06-18	AAV-DELISTED	Stock	7.11	7.17	6.98	7.05	520373.0
2014-06-18	AAWW-DELISTED	Stock	36.61	37.18	36.21	37.0	105936.0
2014-06-18	AAXJ	Stock	62.56	63.1	62.344	63.07	961357.0
2014-06-18	AAXN-DELISTED	Stock	14.08	14.12	13.81	13.85	438272.0
2014-06-18	AB	Stock	25.51	25.84	25.11	25.76	293300.0
2014-06-18	ABAC-DELISTED	Stock	2.19	2.23	2.14	2.19	130905.0
2014-06-18	ABAX-DELISTED	Stock	43.63	43.6999	43.0	43.19	132358.0
2014-06-18	ABB-DELISTED	Stock	23.37	23.4	23.18	23.36	961488.0
2014-06-18	ABBNY-DELISTED	Stock	23.37	23.4	23.18	23.35	999921.0
2014-06-18	ABBV	Stock	54.27	54.61	54.0	54.57	3337300.0
2014-06-18	ABC-DELISTED	Stock	71.65	72.24	71.18	72.1	924712.0
2014-06-18	ABCB	Stock	21.79	21.8	21.51	21.75	25200.0
2014-06-18	ABCD-DELISTED	Stock	1.98	2.03	1.98	2.0	4802.0
2014-06-18	ABCO-DELISTED	Stock	50.75	52.46	50.31	52.19	205538.0
2014-06-18	ABDC-DELISTED	Stock	14.35	14.49	14.25	14.36	36512.0
2014-06-18	ABE-DELISTED	Stock	14.48	14.51	14.25	14.48	12944.0
2014-06-18	ABEO	Stock	400.0	412.5	400.0	412.5	3.0
2014-06-18	ABEV	Stock	6.94	7.1	6.91	7.09	10068100.0
2014-06-18	ABG	Stock	63.63	64.67	63.24	64.58	175400.0
2014-06-18	ABGB-DELISTED	Stock	27.74	28.15	27.55	28.13	10266.0
2014-06-18	ABM	Stock	26.29	26.48	26.22	26.45	210500.0
2014-06-18	ABMD-DELISTED	Stock	23.4	23.42	23.0	23.38	170103.0
2014-06-18	ABR	Stock	7.02	7.08	7.0	7.05	76700.0
2014-06-18	ABR.A-DELISTED	Stock	24.36	24.4599	24.355	24.37	3975.0
2014-06-18	ABR.B-DELISTED	Stock	23.81	23.98	23.77	23.77	6300.0
2014-06-18	ABR.C-DELISTED	Stock	25.1099	25.11	25.0501	25.0501	2250.0
2014-06-18	ABRN-DELISTED	Stock	24.95	24.97	24.9091	24.96	20699.0

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

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