PREVIEW / stock_daily / 2014-06-26

all stock daily files

  file:    by_date/stock_daily/2014/2014-06-26.parquet
  size:    220 KB
  rows:    6,571
  symbols: 3,560

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-06-26	AAPL	Stock	22.5925	22.7625	22.45	22.725	130516000.0
2014-06-26	MSFT	Stock	41.93	41.94	41.43	41.72	23604400.0
2014-06-26	NVDA	Stock	0.4652	0.4655	0.4575	0.459	256908000.0
2014-06-26	AMZN	Stock	16.4245	16.4325	16.1065	16.2845	53990000.0
2014-06-26	GOOGL	Stock	29.465	29.48	28.98	29.2385	40247200.0
2014-06-26	META	Stock	68.0	68.0	66.9	67.13	47714000.0
2014-06-26	TSLA	Stock	15.8113	16.0267	15.614	15.7067	76821000.0
2014-06-26	TLT	Stock	113.21	113.8	113.21	113.41	6628920.0
2014-06-26	ES	Stock	46.69	46.79	46.42	46.77	856700.0
2014-06-26	CL	Stock	67.84	68.03	67.51	67.9	2154600.0
2014-06-26	A	Stock	41.4807	41.5308	41.0587	41.3591	1541155.0
2014-06-26	AABA-DELISTED	Stock	33.25	33.75	33.02	33.66	15298314.0
2014-06-26	AACG	Stock	4.4	4.63	4.4	4.51	18100.0
2014-06-26	AAIC-DELISTED	Stock	26.99	27.32	26.75	27.2	314521.0
2014-06-26	AAL	Stock	43.96	44.6	43.5	44.55	11174300.0
2014-06-26	AAMC-DELISTED	Stock	238.2324	247.5529	230.5882	244.1176	124875.0
2014-06-26	AAME	Stock	3.93	3.97	3.82	3.92	3500.0
2014-06-26	AAOI	Stock	23.27	23.43	22.63	22.68	109700.0
2014-06-26	AAON	Stock	14.6178	14.6311	14.4089	14.5644	151425.0
2014-06-26	AAP	Stock	130.3	131.71	130.02	130.53	1157700.0
2014-06-26	AAT	Stock	34.51	34.57	34.26	34.44	58400.0
2014-06-26	AAU-DELISTED	Stock	1.38	1.41	1.35	1.38	76583.0
2014-06-26	AAUAF-DELISTED	Stock	1.37	1.4	1.35	1.38	78351.0
2014-06-26	AAV-DELISTED	Stock	6.75	6.75	6.55	6.74	401143.0
2014-06-26	AAWW-DELISTED	Stock	36.95	36.95	35.98	36.33	228045.0
2014-06-26	AAXJ	Stock	62.74	62.74	62.32	62.51	437251.0
2014-06-26	AAXN-DELISTED	Stock	13.45	13.53	13.14	13.29	374192.0
2014-06-26	AB	Stock	25.06	25.57	24.79	25.49	181500.0
2014-06-26	ABAC-DELISTED	Stock	2.14	2.15	2.02	2.12	42669.0
2014-06-26	ABAX-DELISTED	Stock	44.7	44.7	43.79	44.13	87929.0
2014-06-26	ABB-DELISTED	Stock	22.69	22.84	22.58	22.81	1132245.0
2014-06-26	ABBNY-DELISTED	Stock	22.69	22.84	22.58	22.8	1162036.0
2014-06-26	ABBV	Stock	55.07	56.54	54.97	56.51	10716400.0
2014-06-26	ABC-DELISTED	Stock	72.74	72.85	72.39	72.73	842405.0
2014-06-26	ABCB	Stock	21.5	21.59	21.17	21.48	22400.0
2014-06-26	ABCD-DELISTED	Stock	2.1	2.21	1.94	2.1	54529.0
2014-06-26	ABCO-DELISTED	Stock	50.9	51.18	50.32	51.0	160274.0
2014-06-26	ABDC-DELISTED	Stock	14.26	14.52	14.14	14.52	80334.0
2014-06-26	ABE-DELISTED	Stock	14.38	14.38	14.291	14.31	5216.0
2014-06-26	ABEO	Stock	375.0	375.0	337.5	350.0	90.0
2014-06-26	ABEV	Stock	7.0	7.1	6.99	7.09	7222200.0
2014-06-26	ABG	Stock	66.3	67.04	65.44	66.74	146000.0
2014-06-26	ABGB-DELISTED	Stock	26.74	26.8399	26.42	26.78	4664.0
2014-06-26	ABIL-DELISTED	Stock	9.75	9.76	9.75	9.76	878.0
2014-06-26	ABM	Stock	26.55	26.57	26.23	26.47	134900.0
2014-06-26	ABMD-DELISTED	Stock	24.21	24.55	23.8526	24.51	235551.0
2014-06-26	ABR	Stock	6.99	7.05	6.97	7.02	48000.0
2014-06-26	ABR.A-DELISTED	Stock	24.49	24.67	24.49	24.66	12330.0
2014-06-26	ABR.B-DELISTED	Stock	24.18	24.38	24.0	24.38	16948.0
2014-06-26	ABR.C-DELISTED	Stock	25.02	25.09	25.02	25.09	2690.0

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

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