PREVIEW / stock_daily / 2013-12-12

all stock daily files

  file:    by_date/stock_daily/2013/2013-12-12.parquet
  size:    216 KB
  rows:    6,454
  symbols: 3,537

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
2013-12-12	AAPL	Stock	20.0764	20.1907	20.0011	20.0193	262290000.0
2013-12-12	MSFT	Stock	37.64	37.64	37.18	37.22	36012800.0
2013-12-12	NVDA	Stock	0.384	0.386	0.377	0.3778	258724000.0
2013-12-12	AMZN	Stock	19.063	19.25	18.975	19.0625	42474000.0
2013-12-12	META	Stock	51.05	52.07	50.66	51.83	92723000.0
2013-12-12	TSLA	Stock	9.3133	9.8827	9.2353	9.8313	161517000.0
2013-12-12	TLT	Stock	103.03	103.16	102.625	102.71	6208704.0
2013-12-12	ES	Stock	40.86	41.53	40.86	41.37	3132500.0
2013-12-12	CL	Stock	65.02	65.08	63.96	63.97	3165000.0
2013-12-12	A	Stock	39.0773	39.7139	38.8412	39.5279	3794591.0
2013-12-12	AABA-DELISTED	Stock	39.02	40.0	39.0	39.36	15590770.0
2013-12-12	AACG	Stock	4.0	4.01	3.93	3.93	6100.0
2013-12-12	AAIC-DELISTED	Stock	26.64	26.64	25.76	25.81	182801.0
2013-12-12	AAL	Stock	26.2	26.71	25.45	25.45	19981800.0
2013-12-12	AAMC-DELISTED	Stock	294.1176	305.3412	288.2382	297.3971	156029.0
2013-12-12	AAME	Stock	4.03	4.04	4.0	4.04	21300.0
2013-12-12	AAOI	Stock	16.0	16.1	14.69	15.14	97400.0
2013-12-12	AAON	Stock	12.9244	13.2444	12.9244	12.9911	171900.0
2013-12-12	AAP	Stock	106.78	108.08	106.56	107.93	941800.0
2013-12-12	AAT	Stock	31.14	31.65	30.87	31.24	117400.0
2013-12-12	AAU-DELISTED	Stock	1.07	1.08	1.05	1.06	64768.0
2013-12-12	AAUAF-DELISTED	Stock	1.07	1.08	1.05	1.06	65727.0
2013-12-12	AAV-DELISTED	Stock	4.14	4.25	4.1	4.18	58330.0
2013-12-12	AAWW-DELISTED	Stock	36.67	36.93	36.5	36.78	113344.0
2013-12-12	AAXJ	Stock	59.52	59.58	59.165	59.22	1282350.0
2013-12-12	AAXN-DELISTED	Stock	16.37	16.81	16.23	16.44	770512.0
2013-12-12	AB	Stock	21.64	22.0	21.5	21.67	368700.0
2013-12-12	ABAC-DELISTED	Stock	2.26	2.35	2.07	2.16	82271.0
2013-12-12	ABAX-DELISTED	Stock	35.36	35.39	35.02	35.24	79348.0
2013-12-12	ABB-DELISTED	Stock	24.66	24.7	24.48	24.6	1106209.0
2013-12-12	ABBNY-DELISTED	Stock	24.66	24.7	24.48	24.61	1150647.0
2013-12-12	ABBV	Stock	52.56	52.62	51.8	52.39	7766400.0
2013-12-12	ABC-DELISTED	Stock	69.2	69.56	68.69	68.75	2029079.0
2013-12-12	ABCB	Stock	19.99	20.38	19.99	20.03	44300.0
2013-12-12	ABCD-DELISTED	Stock	1.55	1.55	1.52	1.54	10100.0
2013-12-12	ABCO-DELISTED	Stock	61.28	61.52	60.4	60.71	163331.0
2013-12-12	ABE-DELISTED	Stock	19.95	19.98	19.86	19.86	31797.0
2013-12-12	ABEO	Stock	325.0	362.5	325.0	362.5	80.0
2013-12-12	ABEV	Stock	7.12	7.15	7.01	7.08	7704900.0
2013-12-12	ABFS-DELISTED	Stock	32.22	32.68	32.0	32.38	249808.0
2013-12-12	ABG	Stock	51.88	52.64	51.51	52.0	225000.0
2013-12-12	ABGB-DELISTED	Stock	13.25	13.5	13.1613	13.39	19790.0
2013-12-12	ABM	Stock	27.14	27.84	27.0	27.74	276300.0
2013-12-12	ABMD-DELISTED	Stock	26.62	27.01	26.061	26.61	221548.0
2013-12-12	ABR	Stock	6.55	6.58	6.49	6.49	76700.0
2013-12-12	ABR.A-DELISTED	Stock	23.52	24.0699	23.52	24.0699	756.0
2013-12-12	ABR.B-DELISTED	Stock	21.95	21.95	21.9	21.9	801.0
2013-12-12	ABT	Stock	36.57	36.63	36.27	36.29	6417800.0
2013-12-12	ABTL-DELISTED	Stock	11.65	11.98	11.65	11.74	81681.0
2013-12-12	ABUS	Stock	7.34	7.49	7.2	7.4	90600.0

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

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