PREVIEW / stock_daily / 2013-08-14

all stock daily files

  file:    by_date/stock_daily/2013/2013-08-14.parquet
  size:    213 KB
  rows:    6,388
  symbols: 3,535

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-08-14	AAPL	Stock	17.7814	18.0089	17.6214	17.8036	756372400.0
2013-08-14	MSFT	Stock	32.14	33.36	31.7	32.35	48519600.0
2013-08-14	NVDA	Stock	0.3598	0.378	0.3595	0.3758	828508000.0
2013-08-14	AMZN	Stock	14.7145	14.7145	14.527	14.567	28300000.0
2013-08-14	META	Stock	36.83	37.55	36.62	36.65	48423900.0
2013-08-14	TSLA	Stock	9.5147	9.656	9.2033	9.2907	175407000.0
2013-08-14	TLT	Stock	104.94	105.36	104.87	105.15	6433480.0
2013-08-14	ES	Stock	43.03	43.08	42.48	42.61	1541000.0
2013-08-14	CL	Stock	61.0	61.14	60.44	60.67	2383200.0
2013-08-14	A	Stock	33.4549	33.6195	33.1688	33.269	2778525.0
2013-08-14	AABA-DELISTED	Stock	28.19	28.21	28.005	28.05	8371231.0
2013-08-14	AACG	Stock	5.38	5.38	5.04	5.33	700.0
2013-08-14	AAIC-DELISTED	Stock	24.89	25.05	24.82	24.95	97912.0
2013-08-14	AAME	Stock	3.88	3.9	3.64	3.82	11600.0
2013-08-14	AAMRQ-DELISTED	Stock	2.875	3.33	2.06	2.74	78436263.0
2013-08-14	AAON	Stock	11.2444	11.4267	11.16	11.3467	191700.0
2013-08-14	AAP	Stock	84.28	84.67	83.51	83.55	405500.0
2013-08-14	AAT	Stock	31.97	31.97	31.55	31.73	99900.0
2013-08-14	AAU-DELISTED	Stock	1.78	1.95	1.78	1.92	198568.0
2013-08-14	AAUAF-DELISTED	Stock	1.78	1.95	1.78	1.92	199468.0
2013-08-14	AAV-DELISTED	Stock	3.64	3.719	3.63	3.71	172496.0
2013-08-14	AAWW-DELISTED	Stock	42.4	43.57	42.35	43.08	424337.0
2013-08-14	AAXJ	Stock	57.16	57.18	57.01	57.09	134444.0
2013-08-14	AAXN-DELISTED	Stock	8.74	9.4	8.74	9.35	1216192.0
2013-08-14	AB	Stock	20.73	21.0	20.48	20.49	209700.0
2013-08-14	ABAC-DELISTED	Stock	0.5901	0.64	0.59	0.59	14200.0
2013-08-14	ABAX-DELISTED	Stock	40.5	40.825	40.37	40.59	61415.0
2013-08-14	ABB-DELISTED	Stock	22.5	22.6484	22.47	22.61	897247.0
2013-08-14	ABBNY-DELISTED	Stock	22.5	22.6484	22.47	22.62	950569.0
2013-08-14	ABBV	Stock	44.85	45.23	44.45	44.58	2990500.0
2013-08-14	ABC-DELISTED	Stock	58.14	58.59	58.0	58.04	1703132.0
2013-08-14	ABCB	Stock	19.1	19.18	18.91	18.94	62200.0
2013-08-14	ABCD-DELISTED	Stock	1.25	1.25	1.23	1.23	259.0
2013-08-14	ABCO-DELISTED	Stock	59.43	59.49	57.8	57.97	88886.0
2013-08-14	ABE-DELISTED	Stock	19.967	20.039	19.91	20.0	1600.0
2013-08-14	ABEO	Stock	512.5	512.5	450.0	512.5	9.0
2013-08-14	ABFS-DELISTED	Stock	23.25	23.715	22.79	23.48	302036.0
2013-08-14	ABG	Stock	51.1	51.43	50.92	51.33	326500.0
2013-08-14	ABM	Stock	25.98	25.98	25.64	25.8	94100.0
2013-08-14	ABMD-DELISTED	Stock	23.19	23.82	22.899	23.49	406341.0
2013-08-14	ABR	Stock	7.42	7.48	7.3	7.38	77800.0
2013-08-14	ABR.A-DELISTED	Stock	24.691	24.7	24.49	24.6644	7620.0
2013-08-14	ABR.B-DELISTED	Stock	23.44	23.58	23.25	23.5	3210.0
2013-08-14	ABT	Stock	35.91	35.94	35.52	35.61	4960600.0
2013-08-14	ABTL-DELISTED	Stock	6.4301	6.54	6.338	6.48	137759.0
2013-08-14	ABUS	Stock	5.4	5.4	5.24	5.27	68800.0
2013-08-14	ABV-DELISTED	Stock	37.55	37.61	37.02	37.11	2218873.0
2013-08-14	ABX-DELISTED	Stock	17.99	18.86	17.9	18.72	19700785.0
2013-08-14	ACAD	Stock	20.12	20.4	19.93	20.05	948600.0
2013-08-14	ACAS-DELISTED	Stock	13.14	13.29	13.04	13.04	2689292.0

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

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