PREVIEW / stock_daily / 2013-07-15

all stock daily files

  file:    by_date/stock_daily/2013/2013-07-15.parquet
  size:    212 KB
  rows:    6,371
  symbols: 3,524

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-07-15	AAPL	Stock	15.1789	15.4093	15.1714	15.2657	241917200.0
2013-07-15	MSFT	Stock	35.66	36.22	35.58	36.17	34142600.0
2013-07-15	NVDA	Stock	0.3668	0.3668	0.3595	0.3652	201332000.0
2013-07-15	AMZN	Stock	15.3635	15.3995	15.2175	15.3285	44912000.0
2013-07-15	META	Stock	25.93	26.43	25.65	26.28	24234000.0
2013-07-15	TSLA	Stock	8.8687	8.884	8.4547	8.484	148836000.0
2013-07-15	TLT	Stock	107.8	108.32	107.7	108.29	4574779.0
2013-07-15	ES	Stock	43.22	44.15	43.17	44.1	962700.0
2013-07-15	CL	Stock	59.24	59.27	58.58	58.82	3302400.0
2013-07-15	A	Stock	32.6896	33.1044	32.6753	32.9828	3401054.0
2013-07-15	AABA-DELISTED	Stock	27.47	27.47	27.0601	27.36	14621327.0
2013-07-15	AACG	Stock	4.56	4.56	4.56	4.56	100.0
2013-07-15	AAIC-DELISTED	Stock	25.36	25.554	25.25	25.46	131211.0
2013-07-15	AAMC-DELISTED	Stock	80.9559	80.9559	78.0882	78.2353	11679.0
2013-07-15	AAME	Stock	3.8	3.81	3.78	3.78	2800.0
2013-07-15	AAMRQ-DELISTED	Stock	4.985	5.15	4.95	5.14	2919933.0
2013-07-15	AAON	Stock	11.4667	11.96	11.3733	11.3822	570375.0
2013-07-15	AAP	Stock	82.9	83.48	82.13	83.38	461200.0
2013-07-15	AAT	Stock	33.74	34.24	33.63	33.86	297400.0
2013-07-15	AAU-DELISTED	Stock	1.47	1.52	1.41	1.41	65299.0
2013-07-15	AAUAF-DELISTED	Stock	1.47	1.52	1.41	1.41	65609.0
2013-07-15	AAV-DELISTED	Stock	4.14	4.22	4.12	4.14	112362.0
2013-07-15	AAWW-DELISTED	Stock	43.81	44.1099	43.37	43.89	307285.0
2013-07-15	AAXJ	Stock	56.07	56.45	56.07	56.3	425737.0
2013-07-15	AAXN-DELISTED	Stock	9.19	9.28	9.04	9.1	288427.0
2013-07-15	AB	Stock	20.15	20.4	19.92	20.33	368100.0
2013-07-15	ABAC-DELISTED	Stock	0.58	0.59	0.5799	0.588	8300.0
2013-07-15	ABAX-DELISTED	Stock	50.75	51.52	49.7201	50.07	165318.0
2013-07-15	ABB-DELISTED	Stock	22.53	22.61	22.43	22.56	782974.0
2013-07-15	ABBNY-DELISTED	Stock	22.53	22.61	22.43	22.55	968699.0
2013-07-15	ABBV	Stock	44.95	44.97	44.54	44.62	3265800.0
2013-07-15	ABC-DELISTED	Stock	58.57	58.82	58.07	58.25	1685618.0
2013-07-15	ABCB	Stock	18.03	18.19	17.86	17.92	55500.0
2013-07-15	ABCD-DELISTED	Stock	1.3	1.3	1.22	1.23	8356.0
2013-07-15	ABCO-DELISTED	Stock	56.5	56.86	55.66	56.64	106266.0
2013-07-15	ABCW-DELISTED	Stock	0.35	0.47	0.35	0.36	15967.0
2013-07-15	ABE-DELISTED	Stock	19.65	20.0199	19.65	19.76	11659.0
2013-07-15	ABEO	Stock	562.5	562.5	512.5	562.5	8.0
2013-07-15	ABFS-DELISTED	Stock	22.79	23.46	22.67	23.27	539000.0
2013-07-15	ABG	Stock	43.69	44.33	43.17	44.15	161700.0
2013-07-15	ABM	Stock	25.42	25.58	25.38	25.58	124600.0
2013-07-15	ABMD-DELISTED	Stock	23.25	23.7	22.95	23.65	247115.0
2013-07-15	ABR	Stock	6.44	6.52	6.32	6.52	65100.0
2013-07-15	ABR.A-DELISTED	Stock	25.34	25.34	25.051	25.31	500.0
2013-07-15	ABR.B-DELISTED	Stock	24.2	24.23	24.2	24.23	200.0
2013-07-15	ABT	Stock	35.23	35.52	35.15	35.48	6487200.0
2013-07-15	ABTL-DELISTED	Stock	5.0	5.05	4.92	5.03	35873.0
2013-07-15	ABUS	Stock	5.03	5.32	4.9	5.32	176400.0
2013-07-15	ABV-DELISTED	Stock	36.5	37.45	36.45	37.39	2885606.0
2013-07-15	ABX-DELISTED	Stock	15.25	15.35	14.92	15.06	14015115.0

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

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