PREVIEW / stock_daily / 2014-06-11

all stock daily files

  file:    by_date/stock_daily/2014/2014-06-11.parquet
  size:    219 KB
  rows:    6,528
  symbols: 3,531

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-11	AAPL	Stock	23.5325	23.69	23.3675	23.465	182724000.0
2014-06-11	MSFT	Stock	40.93	41.07	40.77	40.86	18040000.0
2014-06-11	NVDA	Stock	0.477	0.4862	0.477	0.485	266228000.0
2014-06-11	AMZN	Stock	16.8	17.036	16.694	16.76	88736000.0
2014-06-11	GOOGL	Stock	28.296	28.4485	28.184	28.375	22583460.0
2014-06-11	META	Stock	65.32	65.8	64.9	65.78	44242000.0
2014-06-11	TSLA	Stock	13.4333	13.6667	13.2833	13.6313	59662500.0
2014-06-11	TLT	Stock	111.26	111.54	110.85	111.22	5575789.0
2014-06-11	ES	Stock	45.1	45.24	44.65	44.66	1125700.0
2014-06-11	CL	Stock	68.61	68.7	68.31	68.62	2063900.0
2014-06-11	A	Stock	41.7239	42.2961	41.7096	42.1388	1972019.0
2014-06-11	AABA-DELISTED	Stock	36.25	36.84	36.11	36.63	12823525.0
2014-06-11	AACG	Stock	4.77	4.81	4.7	4.75	10400.0
2014-06-11	AAIC-DELISTED	Stock	27.72	27.91	27.67	27.7	406740.0
2014-06-11	AAL	Stock	42.9	43.29	42.03	42.29	13184000.0
2014-06-11	AAMC-DELISTED	Stock	315.7353	316.1765	310.6353	314.6324	18010.0
2014-06-11	AAME	Stock	3.63	3.73	3.63	3.7	5000.0
2014-06-11	AAOI	Stock	22.1	22.42	21.691	22.33	194600.0
2014-06-11	AAON	Stock	14.4889	14.56	14.3111	14.4267	157275.0
2014-06-11	AAP	Stock	126.53	126.92	125.44	126.14	351200.0
2014-06-11	AAT	Stock	34.14	34.27	33.85	34.03	163100.0
2014-06-11	AAU-DELISTED	Stock	1.36	1.371	1.3	1.3	89512.0
2014-06-11	AAUAF-DELISTED	Stock	1.34	1.35	1.28	1.32	92183.0
2014-06-11	AAV-DELISTED	Stock	6.69	6.71	6.5	6.66	511236.0
2014-06-11	AAWW-DELISTED	Stock	38.26	38.7	38.01	38.07	100409.0
2014-06-11	AAXJ	Stock	62.92	63.01	62.79	62.93	240367.0
2014-06-11	AAXN-DELISTED	Stock	14.1	14.23	13.7	13.91	946689.0
2014-06-11	AB	Stock	25.47	25.69	25.45	25.59	126300.0
2014-06-11	ABAC-DELISTED	Stock	2.17	2.19	2.13	2.18	17368.0
2014-06-11	ABAX-DELISTED	Stock	43.42	43.57	42.64	43.075	236856.0
2014-06-11	ABB-DELISTED	Stock	23.44	23.49	23.33	23.4	1173453.0
2014-06-11	ABBNY-DELISTED	Stock	23.44	23.49	23.33	23.38	1263262.0
2014-06-11	ABBV	Stock	53.85	54.7	53.75	54.23	5386800.0
2014-06-11	ABC-DELISTED	Stock	71.88	72.06	71.47	71.93	1218697.0
2014-06-11	ABCB	Stock	21.95	22.03	21.35	21.87	38600.0
2014-06-11	ABCD-DELISTED	Stock	2.0	2.03	2.0	2.02	9782.0
2014-06-11	ABCO-DELISTED	Stock	50.82	51.73	50.17	50.91	174884.0
2014-06-11	ABDC-DELISTED	Stock	14.51	14.75	14.5	14.5	26838.0
2014-06-11	ABE-DELISTED	Stock	14.66	14.69	14.6	14.69	23308.0
2014-06-11	ABEO	Stock	437.5	437.5	400.0	400.0	1.0
2014-06-11	ABEV	Stock	7.29	7.32	7.12	7.14	8711400.0
2014-06-11	ABG	Stock	65.29	65.29	64.18	64.62	203200.0
2014-06-11	ABGB-DELISTED	Stock	26.43	26.58	26.27	26.56	21264.0
2014-06-11	ABM	Stock	26.85	26.99	26.53	26.9	391200.0
2014-06-11	ABMD-DELISTED	Stock	22.97	23.16	22.68	22.92	205351.0
2014-06-11	ABR	Stock	7.25	7.26	7.18	7.19	394900.0
2014-06-11	ABR.A-DELISTED	Stock	24.25	24.32	24.23	24.25	4500.0
2014-06-11	ABR.B-DELISTED	Stock	23.6001	23.62	23.6001	23.6108	1310.0
2014-06-11	ABR.C-DELISTED	Stock	25.08	25.1	25.05	25.08	2600.0
2014-06-11	ABRN-DELISTED	Stock	24.99	25.01	24.9	24.99	10422.0

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

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