PREVIEW / stock_daily / 2015-05-07

all stock daily files

  file:    by_date/stock_daily/2015/2015-05-07.parquet
  size:    223 KB
  rows:    6,645
  symbols: 3,511

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
2015-05-07	AAPL	Stock	31.1925	31.52	31.005	31.315	175763600.0
2015-05-07	MSFT	Stock	46.27	47.09	46.16	46.7	32971700.0
2015-05-07	NVDA	Stock	0.5502	0.564	0.5485	0.5622	534564000.0
2015-05-07	AMZN	Stock	21.2075	21.425	21.1425	21.344	55322000.0
2015-05-07	GOOGL	Stock	26.795	27.26	26.6725	27.102	31844400.0
2015-05-07	META	Stock	78.0	78.94	77.56	78.43	19749400.0
2015-05-07	TSLA	Stock	14.7333	15.832	14.6833	15.7867	141838500.0
2015-05-07	TLT	Stock	121.43	122.57	121.35	122.18	11933674.0
2015-05-07	ES	Stock	47.98	48.34	47.85	47.92	1823200.0
2015-05-07	CL	Stock	67.97	68.25	67.5	67.88	2338200.0
2015-05-07	A	Stock	41.59	41.85	41.31	41.8	999700.0
2015-05-07	AA.B-DELISTED	Stock	46.25	46.4	45.67	46.35	99730.0
2015-05-07	AABA-DELISTED	Stock	44.99	45.0	43.545	43.86	26988185.0
2015-05-07	AAC-DELISTED	Stock	30.69	31.56	30.0	31.0	99697.0
2015-05-07	AACG	Stock	4.6	4.65	4.43	4.44	2600.0
2015-05-07	AAIC-DELISTED	Stock	21.05	21.33	21.01	21.24	324339.0
2015-05-07	AAL	Stock	47.4	49.62	47.4	49.06	11428000.0
2015-05-07	AAMC-DELISTED	Stock	63.7765	67.0265	63.2853	66.8676	17105.0
2015-05-07	AAME	Stock	3.89	3.96	3.89	3.96	1000.0
2015-05-07	AAMI	Stock	19.52	19.65	19.25	19.41	46500.0
2015-05-07	AAOI	Stock	13.67	13.89	13.5	13.85	169400.0
2015-05-07	AAON	Stock	15.8467	15.8467	14.28	15.18	1059000.0
2015-05-07	AAP	Stock	144.39	145.84	143.89	144.53	782500.0
2015-05-07	AAT	Stock	39.33	40.22	39.33	40.18	120200.0
2015-05-07	AAU-DELISTED	Stock	0.7701	0.8117	0.75	0.7931	122323.0
2015-05-07	AAUAF-DELISTED	Stock	0.7701	0.8117	0.75	0.7931	122766.0
2015-05-07	AAV-DELISTED	Stock	5.85	5.85	5.73	5.8	49839.0
2015-05-07	AAVL-DELISTED	Stock	33.51	34.26	32.1001	33.04	185378.0
2015-05-07	AAWW-DELISTED	Stock	55.8	57.98	55.5	56.74	827604.0
2015-05-07	AAXJ	Stock	66.62	66.9299	66.47	66.915	1534223.0
2015-05-07	AAXN-DELISTED	Stock	33.25	33.35	31.94	32.57	4270897.0
2015-05-07	AB	Stock	31.25	31.49	30.58	31.33	308300.0
2015-05-07	ABAC-DELISTED	Stock	1.63	1.64	1.63	1.63	12720.0
2015-05-07	ABAX-DELISTED	Stock	52.61	54.63	52.164	54.48	164326.0
2015-05-07	ABB-DELISTED	Stock	21.47	21.5	21.32	21.35	1218105.0
2015-05-07	ABBNY-DELISTED	Stock	21.47	21.5	21.32	21.35	1307140.0
2015-05-07	ABBV	Stock	63.59	64.81	63.59	64.7	8638200.0
2015-05-07	ABC-DELISTED	Stock	114.28	115.07	113.79	114.05	1483169.0
2015-05-07	ABCB	Stock	24.7	25.22	24.45	25.14	104200.0
2015-05-07	ABCD-DELISTED	Stock	2.9652	3.01	2.9652	2.98	6330.0
2015-05-07	ABCO-DELISTED	Stock	50.01	51.0	49.42	49.48	183821.0
2015-05-07	ABCW-DELISTED	Stock	37.43	37.67	36.18	36.69	14224.0
2015-05-07	ABDC-DELISTED	Stock	13.71	13.78	13.65	13.76	17904.0
2015-05-07	ABE-DELISTED	Stock	13.07	13.07	12.95	12.98	7272.0
2015-05-07	ABEO	Stock	256.75	262.5	179.25	182.5	702860.0
2015-05-07	ABEOW-DELISTED	Stock	5.25	5.3804	2.55	2.65	460826.0
2015-05-07	ABEV	Stock	6.47	6.51	6.4	6.48	12167700.0
2015-05-07	ABG	Stock	84.46	85.78	84.25	84.8	382900.0
2015-05-07	ABGB-DELISTED	Stock	15.8	15.97	15.7	15.84	14256.0
2015-05-07	ABIL-DELISTED	Stock	10.05	10.39	9.9	9.9999	39058.0

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

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