PREVIEW / stock_daily / 2014-12-03

all stock daily files

  file:    by_date/stock_daily/2014/2014-12-03.parquet
  size:    223 KB
  rows:    6,655
  symbols: 3,571

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-12-03	AAPL	Stock	28.9375	29.0875	28.7775	28.9825	172253600.0
2014-12-03	MSFT	Stock	48.44	48.5	47.81	48.08	23534800.0
2014-12-03	NVDA	Stock	0.5178	0.5287	0.5162	0.5285	284424000.0
2014-12-03	AMZN	Stock	16.2865	16.3385	15.718	15.825	113620000.0
2014-12-03	GOOGL	Stock	26.875	27.0702	26.7605	26.8485	32479540.0
2014-12-03	META	Stock	75.38	75.73	74.4	74.88	16689900.0
2014-12-03	TSLA	Stock	15.0833	15.3147	15.0333	15.2867	79615500.0
2014-12-03	TLT	Stock	120.3	120.8	120.13	120.79	4868551.0
2014-12-03	ES	Stock	51.14	51.27	50.86	51.22	1558000.0
2014-12-03	CL	Stock	69.7	69.7	68.78	69.06	2408700.0
2014-12-03	A	Stock	41.98	42.37	41.82	42.23	2250300.0
2014-12-03	AA.B-DELISTED	Stock	53.4	53.57	53.0	53.172	115695.0
2014-12-03	AABA-DELISTED	Stock	50.62	50.97	50.2	50.27	13680637.0
2014-12-03	AAC-DELISTED	Stock	31.43	32.49	31.12	31.12	54666.0
2014-12-03	AACG	Stock	3.7	3.85	3.51	3.51	12800.0
2014-12-03	AAIC-DELISTED	Stock	27.85	28.15	27.76	28.09	272797.0
2014-12-03	AAL	Stock	47.74	48.47	46.93	48.24	8913700.0
2014-12-03	AAMC-DELISTED	Stock	147.9441	147.9441	142.8029	144.1324	9370.0
2014-12-03	AAME	Stock	3.85	3.85	3.85	3.85	1100.0
2014-12-03	AAMI	Stock	15.58	15.76	15.3	15.58	174600.0
2014-12-03	AAOI	Stock	9.97	10.2	9.86	10.15	316200.0
2014-12-03	AAON	Stock	13.8333	13.9333	13.78	13.86	247200.0
2014-12-03	AAP	Stock	148.44	152.15	148.36	152.04	1046300.0
2014-12-03	AAT	Stock	39.13	39.3	38.91	39.18	151500.0
2014-12-03	AAU-DELISTED	Stock	1.05	1.05	1.03	1.05	30252.0
2014-12-03	AAUAF-DELISTED	Stock	1.05	1.05	1.03	1.05	30642.0
2014-12-03	AAV-DELISTED	Stock	4.44	4.66	4.42	4.56	151512.0
2014-12-03	AAVL-DELISTED	Stock	39.99	42.54	39.29	41.185	177109.0
2014-12-03	AAWW-DELISTED	Stock	46.51	47.48	46.02	47.08	209157.0
2014-12-03	AAXJ	Stock	62.2	62.36	62.1	62.3	1450484.0
2014-12-03	AAXN-DELISTED	Stock	22.33	22.98	21.63	22.86	7661367.0
2014-12-03	AB	Stock	26.43	26.65	26.26	26.65	94900.0
2014-12-03	ABAC-DELISTED	Stock	2.09	2.09	2.0301	2.0301	2508.0
2014-12-03	ABAX-DELISTED	Stock	57.12	58.16	56.2	58.06	168216.0
2014-12-03	ABB-DELISTED	Stock	21.91	22.1199	21.9	22.09	1940741.0
2014-12-03	ABBNY-DELISTED	Stock	21.91	22.1199	21.9	22.1	2155225.0
2014-12-03	ABBV	Stock	69.17	69.48	68.41	68.5	5817700.0
2014-12-03	ABC-DELISTED	Stock	91.99	92.39	91.715	91.98	1363217.0
2014-12-03	ABCB	Stock	24.7	25.0	24.61	24.92	86600.0
2014-12-03	ABCD-DELISTED	Stock	1.7	1.75	1.62	1.69	2100.0
2014-12-03	ABCO-DELISTED	Stock	40.81	41.6	40.6576	41.02	277471.0
2014-12-03	ABCW-DELISTED	Stock	31.7	31.95	31.0	31.49	9826.0
2014-12-03	ABDC-DELISTED	Stock	12.77	12.8499	12.65	12.65	32096.0
2014-12-03	ABE-DELISTED	Stock	14.02	14.12	14.0199	14.06	4536.0
2014-12-03	ABEO	Stock	160.5	178.75	160.5	175.0	28.0
2014-12-03	ABEV	Stock	6.24	6.25	6.12	6.14	17260200.0
2014-12-03	ABG	Stock	75.72	77.59	75.56	76.93	351000.0
2014-12-03	ABGB-DELISTED	Stock	12.41	12.41	11.88	11.97	140601.0
2014-12-03	ABIL-DELISTED	Stock	9.74	9.79	9.74	9.79	200.0
2014-12-03	ABM	Stock	27.19	27.57	27.12	27.39	164900.0

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

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