PREVIEW / stock_daily / 2015-07-28

all stock daily files

  file:    by_date/stock_daily/2015/2015-07-28.parquet
  size:    224 KB
  rows:    6,679
  symbols: 3,487

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-07-28	AAPL	Stock	30.845	30.9775	30.6375	30.845	134472400.0
2015-07-28	MSFT	Stock	45.58	45.64	44.79	45.34	34328900.0
2015-07-28	NVDA	Stock	0.484	0.4965	0.479	0.4932	198308000.0
2015-07-28	AMZN	Stock	26.8	26.8195	26.156	26.3015	105462000.0
2015-07-28	GOOGL	Stock	33.088	33.205	32.6705	32.983	34363860.0
2015-07-28	META	Stock	94.84	95.56	93.31	95.29	35236000.0
2015-07-28	TSLA	Stock	17.05	17.6933	16.7893	17.6547	58437000.0
2015-07-28	TLT	Stock	121.16	121.565	120.9	121.15	9128181.0
2015-07-28	ES	Stock	47.87	48.18	47.64	48.12	1310500.0
2015-07-28	CL	Stock	67.44	68.47	67.27	68.39	5569600.0
2015-07-28	A	Stock	40.0	40.47	39.5	40.45	2768200.0
2015-07-28	AA.B-DELISTED	Stock	36.59	36.67	35.88	36.25	65727.0
2015-07-28	AABA-DELISTED	Stock	37.67	37.92	37.27	37.72	9735719.0
2015-07-28	AAC-DELISTED	Stock	38.97	39.82	37.8	39.63	130263.0
2015-07-28	AACG	Stock	3.69	3.76	3.61	3.67	9100.0
2015-07-28	AAIC-DELISTED	Stock	19.23	19.529	18.78	19.12	509157.0
2015-07-28	AAL	Stock	40.18	41.38	40.18	41.17	8186000.0
2015-07-28	AAMC-DELISTED	Stock	40.0029	40.0029	39.7059	39.7059	3478.0
2015-07-28	AAME	Stock	3.65	3.7	3.65	3.66	1100.0
2015-07-28	AAMI	Stock	17.53	17.98	17.24	17.71	178100.0
2015-07-28	AAOI	Stock	18.41	18.46	17.43	18.42	209200.0
2015-07-28	AAON	Stock	14.84	15.0333	14.48	14.9133	205650.0
2015-07-28	AAP	Stock	169.08	170.74	167.69	170.3	411100.0
2015-07-28	AAT	Stock	41.41	41.7	41.04	41.32	130700.0
2015-07-28	AAU-DELISTED	Stock	0.5817	0.6106	0.5817	0.6045	49572.0
2015-07-28	AAUAF-DELISTED	Stock	0.5817	0.6106	0.5817	0.6045	51867.0
2015-07-28	AAV-DELISTED	Stock	5.33	5.63	5.33	5.52	101920.0
2015-07-28	AAVL-DELISTED	Stock	14.32	14.71	14.08	14.29	490485.0
2015-07-28	AAWW-DELISTED	Stock	49.02	49.872	48.595	49.79	402439.0
2015-07-28	AAXJ	Stock	58.9	59.2	58.6405	59.14	773987.0
2015-07-28	AAXN-DELISTED	Stock	30.38	31.1	29.35	30.78	1937459.0
2015-07-28	AB	Stock	26.96	27.32	26.55	27.26	141000.0
2015-07-28	ABAC-DELISTED	Stock	1.1803	1.189	1.1803	1.189	6338.0
2015-07-28	ABAX-DELISTED	Stock	49.15	49.81	47.51	48.33	187197.0
2015-07-28	ABB-DELISTED	Stock	19.71	19.9	19.67	19.88	1814013.0
2015-07-28	ABBNY-DELISTED	Stock	19.71	19.9	19.67	19.87	1868691.0
2015-07-28	ABBV	Stock	69.5	71.44	69.08	71.23	10098300.0
2015-07-28	ABC-DELISTED	Stock	107.8	108.22	106.77	107.98	1532184.0
2015-07-28	ABCB	Stock	26.03	26.25	25.87	26.17	182300.0
2015-07-28	ABCD-DELISTED	Stock	4.83	4.92	4.7601	4.89	40477.0
2015-07-28	ABCO-DELISTED	Stock	57.21	57.83	56.61	57.82	280625.0
2015-07-28	ABCW-DELISTED	Stock	37.05	37.89	36.43	37.89	13364.0
2015-07-28	ABDC-DELISTED	Stock	12.56	12.58	12.2	12.42	20613.0
2015-07-28	ABE-DELISTED	Stock	12.75	12.8899	12.45	12.81	14860.0
2015-07-28	ABEO	Stock	146.5	152.5	137.75	148.75	16036.0
2015-07-28	ABEOW-DELISTED	Stock	2.0	2.8	1.65	2.07	40730.0
2015-07-28	ABEV	Stock	5.56	5.59	5.41	5.56	49027900.0
2015-07-28	ABG	Stock	83.59	84.35	82.5	83.65	325100.0
2015-07-28	ABGB-DELISTED	Stock	12.22	12.37	12.06	12.28	24350.0
2015-07-28	ABM	Stock	32.51	32.65	32.1	32.58	199800.0

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

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