PREVIEW / stock_daily / 2013-07-25

all stock daily files

  file:    by_date/stock_daily/2013/2013-07-25.parquet
  size:    212 KB
  rows:    6,333
  symbols: 3,509

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-25	AAPL	Stock	15.7393	15.7643	15.5646	15.6607	229493600.0
2013-07-25	MSFT	Stock	31.62	31.65	31.25	31.39	63213000.0
2013-07-25	NVDA	Stock	0.355	0.3612	0.3525	0.3565	243320000.0
2013-07-25	AMZN	Stock	14.95	15.225	14.8375	15.17	108116000.0
2013-07-25	META	Stock	33.54	34.88	32.75	34.36	365457900.0
2013-07-25	TSLA	Stock	8.0267	8.3167	8.0127	8.2713	79264500.0
2013-07-25	TLT	Stock	106.97	107.6	106.81	107.48	6443388.0
2013-07-25	ES	Stock	44.12	44.46	43.91	44.37	1072500.0
2013-07-25	CL	Stock	58.7	59.9	58.5	59.62	4558000.0
2013-07-25	A	Stock	33.3476	33.5479	33.1831	33.3763	1985579.0
2013-07-25	AABA-DELISTED	Stock	27.73	28.46	27.65	28.265	19202403.0
2013-07-25	AACG	Stock	4.9	5.28	4.75	5.0	7300.0
2013-07-25	AAIC-DELISTED	Stock	25.85	26.08	25.64	25.87	120288.0
2013-07-25	AAMC-DELISTED	Stock	98.2353	98.5294	94.1176	94.1176	9649.0
2013-07-25	AAME	Stock	3.63	3.81	3.63	3.66	13000.0
2013-07-25	AAMRQ-DELISTED	Stock	5.6	5.9	5.51	5.75	8610999.0
2013-07-25	AAON	Stock	9.5467	10.3778	9.5467	10.3111	297225.0
2013-07-25	AAP	Stock	81.9	82.46	81.05	82.22	925300.0
2013-07-25	AAT	Stock	33.04	33.84	33.0	33.6	85000.0
2013-07-25	AAU-DELISTED	Stock	1.65	1.74	1.65	1.73	77714.0
2013-07-25	AAUAF-DELISTED	Stock	1.67	1.76	1.67	1.73	77041.0
2013-07-25	AAV-DELISTED	Stock	3.9	3.98	3.7801	3.82	217849.0
2013-07-25	AAWW-DELISTED	Stock	44.8	44.91	44.08	44.79	309088.0
2013-07-25	AAXJ	Stock	56.69	56.99	56.5	56.99	288567.0
2013-07-25	AAXN-DELISTED	Stock	8.91	8.9599	8.77	8.82	344682.0
2013-07-25	AB	Stock	22.31	22.56	22.22	22.41	143200.0
2013-07-25	ABAC-DELISTED	Stock	0.58	0.6	0.58	0.5999	3804.0
2013-07-25	ABAX-DELISTED	Stock	49.36	51.37	48.92	49.42	204043.0
2013-07-25	ABB-DELISTED	Stock	21.98	22.45	21.98	22.4	2249067.0
2013-07-25	ABBNY-DELISTED	Stock	21.98	22.45	21.98	22.42	2306780.0
2013-07-25	ABBV	Stock	43.41	44.43	43.35	44.24	4088500.0
2013-07-25	ABC-DELISTED	Stock	56.2	57.69	55.8	57.63	2768675.0
2013-07-25	ABCB	Stock	18.67	19.81	18.66	19.79	186100.0
2013-07-25	ABCO-DELISTED	Stock	56.67	57.84	56.65	57.75	75047.0
2013-07-25	ABCW-DELISTED	Stock	0.401	0.43	0.4	0.401	25761.0
2013-07-25	ABE-DELISTED	Stock	20.34	20.34	20.22	20.29	2776.0
2013-07-25	ABFS-DELISTED	Stock	21.32	22.07	20.65	21.96	533407.0
2013-07-25	ABG	Stock	46.89	47.08	46.37	47.04	332600.0
2013-07-25	ABM	Stock	25.77	26.14	25.51	26.08	183000.0
2013-07-25	ABMD-DELISTED	Stock	24.37	24.77	24.0	24.5	232039.0
2013-07-25	ABR	Stock	7.62	7.72	7.58	7.68	161100.0
2013-07-25	ABR.A-DELISTED	Stock	25.31	25.3899	25.251	25.3899	1400.0
2013-07-25	ABR.B-DELISTED	Stock	24.3482	24.3482	24.24	24.24	500.0
2013-07-25	ABT	Stock	36.42	36.6	36.24	36.58	7492500.0
2013-07-25	ABTL-DELISTED	Stock	5.14	5.37	5.13	5.37	53550.0
2013-07-25	ABUS	Stock	4.85	5.23	4.85	5.23	237000.0
2013-07-25	ABV-DELISTED	Stock	36.02	36.47	35.92	36.32	1725368.0
2013-07-25	ABX-DELISTED	Stock	17.19	17.81	17.03	17.51	13167986.0
2013-07-25	ACAD	Stock	18.85	19.26	18.55	19.04	1114400.0
2013-07-25	ACAS-DELISTED	Stock	13.53	13.74	13.52	13.67	2107503.0

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

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