PREVIEW / stock_daily / 2014-03-18

all stock daily files

  file:    by_date/stock_daily/2014/2014-03-18.parquet
  size:    219 KB
  rows:    6,516
  symbols: 3,563

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-03-18	AAPL	Stock	18.7821	18.9989	18.7571	18.9786	209647200.0
2014-03-18	MSFT	Stock	38.26	39.9	38.22	39.55	64063900.0
2014-03-18	NVDA	Stock	0.4472	0.459	0.4452	0.456	293904000.0
2014-03-18	AMZN	Stock	18.866	18.95	18.75	18.9385	49670000.0
2014-03-18	META	Stock	68.76	69.6	68.3	69.19	40827000.0
2014-03-18	TSLA	Stock	15.7967	16.1	15.668	16.0027	93634500.0
2014-03-18	TLT	Stock	107.68	108.1499	107.6	108.1	4819536.0
2014-03-18	ES	Stock	45.17	45.3	44.87	45.23	1009200.0
2014-03-18	CL	Stock	64.52	64.59	64.21	64.34	2148700.0
2014-03-18	A	Stock	40.0358	40.6366	39.9428	40.6223	1809991.0
2014-03-18	AABA-DELISTED	Stock	39.0	39.51	38.8	39.46	15734213.0
2014-03-18	AACG	Stock	4.31	4.37	4.29	4.37	3600.0
2014-03-18	AAIC-DELISTED	Stock	27.71	28.1	27.51	27.79	195735.0
2014-03-18	AAL	Stock	37.75	38.04	37.09	37.35	5715900.0
2014-03-18	AAMC-DELISTED	Stock	315.8765	315.8765	294.4588	301.1206	52459.0
2014-03-18	AAME	Stock	3.5	3.6	3.5	3.58	1800.0
2014-03-18	AAOI	Stock	25.68	25.92	24.8	25.51	174800.0
2014-03-18	AAON	Stock	12.0978	12.6444	12.0267	12.6311	254700.0
2014-03-18	AAP	Stock	126.19	126.19	124.65	125.95	798700.0
2014-03-18	AAT	Stock	33.36	33.69	33.15	33.64	90100.0
2014-03-18	AAU-DELISTED	Stock	1.513	1.54	1.48	1.507	216401.0
2014-03-18	AAUAF-DELISTED	Stock	1.51	1.54	1.48	1.51	219454.0
2014-03-18	AAV-DELISTED	Stock	4.2	4.3	4.14	4.22	350197.0
2014-03-18	AAWW-DELISTED	Stock	32.04	32.43	31.92	32.15	134406.0
2014-03-18	AAXJ	Stock	57.42	57.83	57.4	57.72	242366.0
2014-03-18	AAXN-DELISTED	Stock	18.31	18.86	18.2701	18.5	807931.0
2014-03-18	AB	Stock	25.06	25.55	24.92	25.51	483900.0
2014-03-18	ABAC-DELISTED	Stock	1.85	1.96	1.7704	1.867	108690.0
2014-03-18	ABAX-DELISTED	Stock	38.65	39.7663	38.648	39.65	104542.0
2014-03-18	ABB-DELISTED	Stock	25.08	25.34	25.06	25.29	1029725.0
2014-03-18	ABBNY-DELISTED	Stock	25.08	25.34	25.06	25.29	1093094.0
2014-03-18	ABBV	Stock	52.08	53.22	51.97	53.1	4712300.0
2014-03-18	ABC-DELISTED	Stock	68.08	68.43	67.775	67.84	1456202.0
2014-03-18	ABCB	Stock	23.98	24.22	23.2	24.0	108600.0
2014-03-18	ABCD-DELISTED	Stock	2.1999	2.2	2.07	2.08	29536.0
2014-03-18	ABCO-DELISTED	Stock	67.42	68.92	67.17	68.61	97469.0
2014-03-18	ABE-DELISTED	Stock	12.37	12.71	12.37	12.68	10191.0
2014-03-18	ABEO	Stock	587.5	612.5	550.0	612.5	73.0
2014-03-18	ABEV	Stock	7.03	7.15	7.02	7.12	8005900.0
2014-03-18	ABFS-DELISTED	Stock	35.68	36.76	35.42	36.55	352411.0
2014-03-18	ABG	Stock	52.76	54.0	52.69	53.97	173600.0
2014-03-18	ABGB-DELISTED	Stock	22.5592	22.9375	22.5592	22.9296	3732.0
2014-03-18	ABIL-DELISTED	Stock	9.67	9.73	9.62	9.62	2400.0
2014-03-18	ABM	Stock	28.48	28.88	28.45	28.88	168800.0
2014-03-18	ABMD-DELISTED	Stock	25.72	25.93	25.26	25.74	1526609.0
2014-03-18	ABR	Stock	6.73	6.78	6.7	6.74	96100.0
2014-03-18	ABR.A-DELISTED	Stock	24.3496	24.49	24.3496	24.49	4500.0
2014-03-18	ABR.B-DELISTED	Stock	22.97	23.0	22.848	23.0	14104.0
2014-03-18	ABR.C-DELISTED	Stock	24.7	24.75	24.7	24.7	11950.0
2014-03-18	ABT	Stock	39.5	39.89	39.48	39.73	5534300.0

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

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