PREVIEW / stock_daily / 2014-07-18

all stock daily files

  file:    by_date/stock_daily/2014/2014-07-18.parquet
  size:    220 KB
  rows:    6,586
  symbols: 3,562

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-07-18	AAPL	Stock	23.405	23.685	23.255	23.6075	199952000.0
2014-07-18	MSFT	Stock	44.65	44.84	44.25	44.69	43407500.0
2014-07-18	NVDA	Stock	0.4725	0.4763	0.4603	0.461	567816000.0
2014-07-18	AMZN	Stock	17.72	17.984	17.604	17.933	68148000.0
2014-07-18	GOOGL	Stock	30.1505	30.335	29.546	30.2555	97485200.0
2014-07-18	META	Stock	66.8	68.46	66.16	68.42	42456000.0
2014-07-18	TSLA	Stock	14.3967	14.7473	14.3953	14.668	63805500.0
2014-07-18	TLT	Stock	114.88	114.96	114.11	114.52	6678134.0
2014-07-18	ES	Stock	45.24	45.57	44.93	45.54	720100.0
2014-07-18	CL	Stock	68.78	69.01	68.55	68.9	2395800.0
2014-07-18	A	Stock	39.6423	40.2361	39.5494	40.1645	2385268.0
2014-07-18	AABA-DELISTED	Stock	33.18	33.35	32.9301	33.33	19124957.0
2014-07-18	AACG	Stock	4.2	4.38	4.2	4.29	2000.0
2014-07-18	AAIC-DELISTED	Stock	26.43	26.779	26.42	26.71	117385.0
2014-07-18	AAL	Stock	42.23	43.22	42.15	42.92	8869000.0
2014-07-18	AAMC-DELISTED	Stock	206.8941	218.8235	206.8941	218.8235	24524.0
2014-07-18	AAME	Stock	3.97	4.0	3.88	4.0	8300.0
2014-07-18	AAOI	Stock	21.39	22.01	21.39	21.54	191000.0
2014-07-18	AAON	Stock	13.7333	14.2533	13.6867	14.2133	249750.0
2014-07-18	AAP	Stock	129.92	130.87	128.66	130.47	645400.0
2014-07-18	AAT	Stock	35.25	35.67	35.07	35.6	141700.0
2014-07-18	AAU-DELISTED	Stock	1.49	1.511	1.4599	1.47	104570.0
2014-07-18	AAUAF-DELISTED	Stock	1.47	1.49	1.44	1.47	107397.0
2014-07-18	AAV-DELISTED	Stock	5.44	5.55	5.43	5.5	164484.0
2014-07-18	AAWW-DELISTED	Stock	35.88	36.52	35.81	36.06	176308.0
2014-07-18	AAXJ	Stock	63.8	63.91	63.7	63.84	261028.0
2014-07-18	AAXN-DELISTED	Stock	10.5	11.4	10.5	11.37	1925147.0
2014-07-18	AB	Stock	27.45	27.8	27.3	27.76	137500.0
2014-07-18	ABAC-DELISTED	Stock	2.05	2.15	2.05	2.15	29511.0
2014-07-18	ABAX-DELISTED	Stock	42.0	42.77	41.61	42.55	96432.0
2014-07-18	ABB-DELISTED	Stock	22.67	22.82	22.66	22.8	1195329.0
2014-07-18	ABBNY-DELISTED	Stock	22.67	22.82	22.66	22.79	1287544.0
2014-07-18	ABBV	Stock	53.0	55.12	53.0	54.91	42456000.0
2014-07-18	ABC-DELISTED	Stock	72.85	73.3	72.56	73.06	1318619.0
2014-07-18	ABCB	Stock	20.85	21.35	20.85	21.15	69700.0
2014-07-18	ABCD-DELISTED	Stock	1.94	1.97	1.78	1.87	28503.0
2014-07-18	ABCO-DELISTED	Stock	49.68	50.74	49.63	50.33	128795.0
2014-07-18	ABDC-DELISTED	Stock	13.9	14.0	13.75	13.97	60409.0
2014-07-18	ABE-DELISTED	Stock	14.37	14.589	14.37	14.589	8212.0
2014-07-18	ABEO	Stock	300.0	300.0	287.5	287.5	38.0
2014-07-18	ABEV	Stock	7.25	7.42	7.21	7.37	15078100.0
2014-07-18	ABG	Stock	69.41	71.2	68.76	71.15	213200.0
2014-07-18	ABGB-DELISTED	Stock	26.58	26.909	26.5686	26.831	7432.0
2014-07-18	ABIL-DELISTED	Stock	9.76	9.79	9.75	9.75	9100.0
2014-07-18	ABM	Stock	25.44	25.88	25.39	25.7	187100.0
2014-07-18	ABMD-DELISTED	Stock	24.45	25.27	24.45	24.93	278623.0
2014-07-18	ABR	Stock	6.85	6.92	6.85	6.88	39200.0
2014-07-18	ABR.A-DELISTED	Stock	24.76	24.86	24.76	24.8599	18460.0
2014-07-18	ABR.B-DELISTED	Stock	24.7	24.7028	24.38	24.7028	1620.0
2014-07-18	ABR.C-DELISTED	Stock	25.34	25.37	25.331	25.37	1600.0

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

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