PREVIEW / stock_daily / 2014-12-01

all stock daily files

  file:    by_date/stock_daily/2014/2014-12-01.parquet
  size:    223 KB
  rows:    6,671
  symbols: 3,567

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-01	AAPL	Stock	29.7025	29.8125	27.8175	28.7675	335256000.0
2014-12-01	MSFT	Stock	47.88	48.78	47.71	48.62	31191600.0
2014-12-01	NVDA	Stock	0.522	0.525	0.5138	0.5145	190060000.0
2014-12-01	AMZN	Stock	16.906	17.032	16.2965	16.3	98898000.0
2014-12-01	GOOGL	Stock	27.2545	27.4395	26.931	26.9825	39887980.0
2014-12-01	META	Stock	77.26	77.31	74.8	75.1	31789900.0
2014-12-01	TSLA	Stock	16.0773	16.1647	15.2673	15.4427	129291000.0
2014-12-01	TLT	Stock	122.68	122.81	121.46	121.5	7728556.0
2014-12-01	ES	Stock	50.29	51.25	49.93	50.69	2265300.0
2014-12-01	CL	Stock	68.67	69.8	68.63	69.4	2507600.0
2014-12-01	A	Stock	42.69	42.73	41.58	41.59	4411200.0
2014-12-01	AA.B-DELISTED	Stock	53.36	53.36	52.796	53.01	101202.0
2014-12-01	AABA-DELISTED	Stock	51.43	51.43	49.66	50.12	21786937.0
2014-12-01	AAC-DELISTED	Stock	28.52	29.66	27.95	29.59	83558.0
2014-12-01	AACG	Stock	3.95	3.98	3.87	3.87	6000.0
2014-12-01	AAIC-DELISTED	Stock	27.79	27.82	27.51	27.59	215214.0
2014-12-01	AAL	Stock	49.0	49.47	47.36	47.88	15151400.0
2014-12-01	AAMC-DELISTED	Stock	147.7971	148.8235	144.6912	145.2941	38080.0
2014-12-01	AAME	Stock	3.85	3.85	3.83	3.85	2400.0
2014-12-01	AAMI	Stock	15.36	15.595	15.36	15.52	170200.0
2014-12-01	AAOI	Stock	10.8	11.01	10.17	10.27	807400.0
2014-12-01	AAON	Stock	13.8333	13.9333	13.6733	13.6933	316800.0
2014-12-01	AAP	Stock	146.41	147.77	146.13	147.07	1220300.0
2014-12-01	AAT	Stock	39.3	39.41	38.65	38.66	213700.0
2014-12-01	AAU-DELISTED	Stock	1.09	1.102	1.02	1.04	278478.0
2014-12-01	AAUAF-DELISTED	Stock	1.06	1.07	0.99	1.04	287620.0
2014-12-01	AAV-DELISTED	Stock	4.43	4.54	4.26	4.47	320202.0
2014-12-01	AAVL-DELISTED	Stock	39.3	39.737	37.035	38.08	141792.0
2014-12-01	AAWW-DELISTED	Stock	45.27	45.566	44.3	44.52	233921.0
2014-12-01	AAXJ	Stock	62.12	62.12	61.73	61.88	648409.0
2014-12-01	AAXN-DELISTED	Stock	21.35	22.4	20.79	22.09	4654920.0
2014-12-01	AB	Stock	26.7	26.75	26.07	26.43	194400.0
2014-12-01	ABAC-DELISTED	Stock	2.03	2.08	2.0101	2.02	5083.0
2014-12-01	ABAX-DELISTED	Stock	57.51	57.89	56.06	56.15	159178.0
2014-12-01	ABB-DELISTED	Stock	22.16	22.18	21.99	22.1301	1584002.0
2014-12-01	ABBNY-DELISTED	Stock	22.16	22.18	21.99	22.14	1644492.0
2014-12-01	ABBV	Stock	69.08	69.5	68.83	69.11	4885100.0
2014-12-01	ABC-DELISTED	Stock	90.64	91.4	90.28	90.85	1421374.0
2014-12-01	ABCB	Stock	25.19	25.26	24.47	24.54	135400.0
2014-12-01	ABCD-DELISTED	Stock	1.7	1.76	1.67	1.7	18582.0
2014-12-01	ABCO-DELISTED	Stock	42.6	42.82	42.18	42.25	412403.0
2014-12-01	ABCW-DELISTED	Stock	30.0	30.5	30.0	30.09	41682.0
2014-12-01	ABDC-DELISTED	Stock	12.92	12.9893	12.75	12.96	40631.0
2014-12-01	ABE-DELISTED	Stock	14.15	14.25	13.75	13.78	8349.0
2014-12-01	ABEO	Stock	175.25	175.25	175.25	175.25	68.0
2014-12-01	ABEV	Stock	6.37	6.4	6.19	6.23	19757300.0
2014-12-01	ABG	Stock	75.47	76.21	74.65	74.75	276600.0
2014-12-01	ABGB-DELISTED	Stock	12.31	12.31	11.7	11.83	106131.0
2014-12-01	ABM	Stock	27.05	27.28	26.78	26.97	184200.0
2014-12-01	ABMD-DELISTED	Stock	35.45	35.45	34.92	35.0	314114.0

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

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