PREVIEW / stock_daily / 2015-09-21

all stock daily files

  file:    by_date/stock_daily/2015/2015-09-21.parquet
  size:    221 KB
  rows:    6,645
  symbols: 3,442

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-09-21	AAPL	Stock	28.4175	28.8425	28.415	28.8025	200888000.0
2015-09-21	MSFT	Stock	43.62	44.47	43.6	44.11	26177200.0
2015-09-21	NVDA	Stock	0.583	0.5895	0.58	0.5883	281840000.0
2015-09-21	AMZN	Stock	27.2165	27.489	26.9795	27.4195	65666000.0
2015-09-21	GOOGL	Stock	33.2755	33.45	32.9	33.349	39093340.0
2015-09-21	META	Stock	94.62	96.49	94.52	95.55	28790000.0
2015-09-21	TSLA	Stock	17.5987	18.1047	17.0533	17.6133	91803000.0
2015-09-21	TLT	Stock	121.01	121.11	119.78	120.11	10085551.0
2015-09-21	ES	Stock	47.37	47.66	47.15	47.51	1441900.0
2015-09-21	CL	Stock	63.16	63.43	62.93	63.1	3991200.0
2015-09-21	A	Stock	35.96	36.07	35.41	35.69	2640200.0
2015-09-21	AA.B-DELISTED	Stock	35.84	35.97	35.2256	35.3518	62608.0
2015-09-21	AABA-DELISTED	Stock	31.2	31.735	30.88	31.18	17705452.0
2015-09-21	AAC-DELISTED	Stock	23.87	23.87	22.94	23.55	157401.0
2015-09-21	AACG	Stock	2.44	2.58	2.36	2.5	35100.0
2015-09-21	AAIC-DELISTED	Stock	15.8	16.13	15.75	16.1	239246.0
2015-09-21	AAL	Stock	43.72	44.01	42.88	43.23	6687200.0
2015-09-21	AAMC-DELISTED	Stock	7.4618	8.4411	7.1147	7.25	47801.0
2015-09-21	AAME	Stock	3.72	3.72	3.54	3.69	11700.0
2015-09-21	AAMI	Stock	16.21	16.22	15.88	15.99	78100.0
2015-09-21	AAOI	Stock	19.62	19.8	18.87	19.72	274600.0
2015-09-21	AAON	Stock	13.4133	13.5467	13.2667	13.3933	166500.0
2015-09-21	AAP	Stock	174.32	175.65	173.04	174.75	453300.0
2015-09-21	AAT	Stock	39.7	40.39	39.61	40.2	137900.0
2015-09-21	AAU-DELISTED	Stock	0.5243	0.5625	0.5199	0.5316	69291.0
2015-09-21	AAUAF-DELISTED	Stock	0.5243	0.5625	0.5199	0.5316	69591.0
2015-09-21	AAV-DELISTED	Stock	5.38	5.61	5.38	5.48	63501.0
2015-09-21	AAVL-DELISTED	Stock	11.39	11.46	10.23	10.53	563191.0
2015-09-21	AAWW-DELISTED	Stock	38.27	38.8	37.91	38.04	167271.0
2015-09-21	AAXJ	Stock	54.3	54.361	53.94	54.12	1892792.0
2015-09-21	AAXN-DELISTED	Stock	24.0	24.16	23.56	23.8	1235464.0
2015-09-21	AB	Stock	26.67	27.13	26.67	26.99	75300.0
2015-09-21	ABAC-DELISTED	Stock	0.6799	0.6859	0.66	0.6799	28590.0
2015-09-21	ABAX-DELISTED	Stock	48.32	48.76	47.3	47.4	132304.0
2015-09-21	ABB-DELISTED	Stock	18.11	18.23	18.065	18.135	3076064.0
2015-09-21	ABBNY-DELISTED	Stock	18.11	18.23	18.065	18.13	3917332.0
2015-09-21	ABBV	Stock	61.24	61.74	59.29	59.39	11038100.0
2015-09-21	ABC-DELISTED	Stock	106.58	107.36	104.76	105.29	1238718.0
2015-09-21	ABCB	Stock	27.89	28.45	27.73	28.07	118900.0
2015-09-21	ABCD-DELISTED	Stock	4.99	5.12	4.86	4.91	58730.0
2015-09-21	ABCO-DELISTED	Stock	48.4	48.9433	47.82	48.29	125732.0
2015-09-21	ABCW-DELISTED	Stock	38.83	40.21	38.72	40.21	75854.0
2015-09-21	ABDC-DELISTED	Stock	12.77	12.875	12.59	12.82	26863.0
2015-09-21	ABE-DELISTED	Stock	11.3	11.35	11.19	11.234	5043.0
2015-09-21	ABEO	Stock	134.25	134.25	126.75	129.0	3892.0
2015-09-21	ABEV	Stock	4.88	4.92	4.81	4.84	10053000.0
2015-09-21	ABG	Stock	84.04	85.73	83.19	84.75	314200.0
2015-09-21	ABGB-DELISTED	Stock	4.68	4.75	4.6	4.75	58791.0
2015-09-21	ABM	Stock	29.81	29.84	29.37	29.41	407000.0
2015-09-21	ABMD-DELISTED	Stock	105.44	106.415	101.32	103.01	619853.0

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

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