PREVIEW / stock_daily / 2015-06-26

all stock daily files

  file:    by_date/stock_daily/2015/2015-06-26.parquet
  size:    224 KB
  rows:    6,653
  symbols: 3,500

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-06-26	AAPL	Stock	31.9175	31.9975	31.6275	31.6875	176267200.0
2015-06-26	MSFT	Stock	45.65	46.28	45.03	45.26	49835300.0
2015-06-26	NVDA	Stock	0.525	0.5255	0.5162	0.5185	421296000.0
2015-06-26	AMZN	Stock	22.088	22.1745	21.753	21.905	52490000.0
2015-06-26	GOOGL	Stock	27.9855	28.0	27.5925	27.653	43675060.0
2015-06-26	META	Stock	88.12	88.34	86.83	88.01	38214600.0
2015-06-26	TSLA	Stock	17.926	17.9407	17.7333	17.806	57576000.0
2015-06-26	TLT	Stock	115.67	115.87	114.88	115.23	11672979.0
2015-06-26	ES	Stock	45.44	46.15	45.2	45.99	2279500.0
2015-06-26	CL	Stock	66.76	67.0	66.44	66.5	2588200.0
2015-06-26	A	Stock	40.0	40.17	39.78	40.02	3350500.0
2015-06-26	AA.B-DELISTED	Stock	41.61	41.97	41.45	41.8499	38775.0
2015-06-26	AABA-DELISTED	Stock	40.83	40.87	39.93	40.065	14811629.0
2015-06-26	AAC-DELISTED	Stock	43.43	43.482	42.3328	43.16	281010.0
2015-06-26	AACG	Stock	6.15	6.31	6.01	6.05	27600.0
2015-06-26	AAIC-DELISTED	Stock	19.76	19.93	19.5	19.8	594734.0
2015-06-26	AAL	Stock	42.44	42.58	41.33	41.44	9819900.0
2015-06-26	AAMC-DELISTED	Stock	41.6029	43.4706	41.4706	42.9412	148998.0
2015-06-26	AAMI	Stock	17.75	18.24	17.52	17.89	1051300.0
2015-06-26	AAOI	Stock	19.18	19.76	18.16	18.71	557100.0
2015-06-26	AAON	Stock	15.34	15.5067	15.0067	15.1933	793350.0
2015-06-26	AAP	Stock	164.98	165.16	163.48	164.28	858600.0
2015-06-26	AAT	Stock	38.98	39.58	38.97	39.51	752500.0
2015-06-26	AAU-DELISTED	Stock	0.8114	0.826	0.8092	0.8186	80006.0
2015-06-26	AAUAF-DELISTED	Stock	0.8098	0.8243	0.8076	0.8195	81639.0
2015-06-26	AAV-DELISTED	Stock	6.43	6.43	6.31	6.4	55860.0
2015-06-26	AAVL-DELISTED	Stock	16.2	16.4	15.61	15.85	1662577.0
2015-06-26	AAWW-DELISTED	Stock	58.07	58.81	57.5	57.59	516004.0
2015-06-26	AAXJ	Stock	63.97	64.07	63.69	63.73	401638.0
2015-06-26	AAXN-DELISTED	Stock	33.86	34.11	33.46	33.56	1344761.0
2015-06-26	AB	Stock	29.12	30.09	29.11	30.09	234900.0
2015-06-26	ABAC-DELISTED	Stock	1.4	1.42	1.37	1.39	26608.0
2015-06-26	ABAX-DELISTED	Stock	52.67	52.79	51.67	52.06	114120.0
2015-06-26	ABB-DELISTED	Stock	21.58	21.87	21.575	21.85	4349011.0
2015-06-26	ABBNY-DELISTED	Stock	21.58	21.87	21.575	21.87	4590649.0
2015-06-26	ABBV	Stock	69.95	70.6	69.68	70.46	9669500.0
2015-06-26	ABC-DELISTED	Stock	108.07	108.56	107.32	107.81	1310180.0
2015-06-26	ABCB	Stock	25.75	26.01	25.54	25.96	248700.0
2015-06-26	ABCD-DELISTED	Stock	4.23	4.28	4.07	4.09	787767.0
2015-06-26	ABCO-DELISTED	Stock	54.0	54.38	53.43	54.322	256134.0
2015-06-26	ABCW-DELISTED	Stock	37.47	38.49	37.35	38.28	141434.0
2015-06-26	ABDC-DELISTED	Stock	13.4	13.6	12.76	13.445	122275.0
2015-06-26	ABE-DELISTED	Stock	12.51	12.656	12.51	12.61	18537.0
2015-06-26	ABEO	Stock	159.0	159.75	150.0	154.25	78740.0
2015-06-26	ABEOW-DELISTED	Stock	2.23	2.23	2.0	2.05	3300.0
2015-06-26	ABEV	Stock	6.06	6.15	6.04	6.12	7979300.0
2015-06-26	ABG	Stock	92.73	93.29	91.88	92.53	356000.0
2015-06-26	ABGB-DELISTED	Stock	17.24	17.32	16.84	17.0	5810.0
2015-06-26	ABIL-DELISTED	Stock	9.95	9.95	9.95	9.95	100.0
2015-06-26	ABM	Stock	33.56	33.64	33.14	33.32	482600.0

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

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