PREVIEW / stock_daily / 2017-09-29

all stock daily files

  file:    by_date/stock_daily/2017/2017-09-29.parquet
  size:    215 KB
  rows:    6,454
  symbols: 2,933

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
2017-09-29	AAPL	Stock	38.3025	38.5325	38.0	38.53	105199200.0
2017-09-29	MSFT	Stock	73.94	74.54	73.88	74.49	17079100.0
2017-09-29	NVDA	Stock	4.477	4.4932	4.4312	4.4693	619092000.0
2017-09-29	AMZN	Stock	48.0055	48.2415	47.919	48.0675	50876000.0
2017-09-29	GOOGL	Stock	48.3	48.7905	48.3	48.686	40621840.0
2017-09-29	META	Stock	168.83	171.66	168.81	170.87	15340400.0
2017-09-29	TSLA	Stock	22.7907	22.9787	22.5733	22.74	76606500.0
2017-09-29	TLT	Stock	124.76	125.03	124.27	124.76	11285465.0
2017-09-29	ES	Stock	60.5	60.73	60.25	60.44	3067600.0
2017-09-29	CL	Stock	73.13	73.29	72.77	72.85	2968400.0
2017-09-29	A	Stock	64.0	64.28	63.72	64.2	1672800.0
2017-09-29	AA	Stock	46.45	47.0	45.9	46.62	3825600.0
2017-09-29	AAAP-DELISTED	Stock	65.51	67.95	65.11	67.8	775204.0
2017-09-29	AABA-DELISTED	Stock	65.64	66.61	65.64	66.32	4628044.0
2017-09-29	AAC-DELISTED	Stock	10.24	10.36	9.81	9.93	67612.0
2017-09-29	AACG	Stock	4.82	4.85	4.82	4.85	5100.0
2017-09-29	AAIC-DELISTED	Stock	12.71	12.88	12.671	12.73	483918.0
2017-09-29	AAL	Stock	47.49	47.85	47.23	47.49	4904300.0
2017-09-29	AAM.A-DELISTED	Stock	26.0899	26.32	26.0648	26.32	37210.0
2017-09-29	AAMC-DELISTED	Stock	24.4118	24.5588	23.5735	23.5882	23348.0
2017-09-29	AAME	Stock	3.25	3.25	3.15	3.25	5300.0
2017-09-29	AAMI	Stock	14.66	14.96	14.5	14.92	1003000.0
2017-09-29	AAOI	Stock	64.0	66.23	64.0	64.67	1788800.0
2017-09-29	AAON	Stock	23.2667	23.3333	22.9333	22.9867	357600.0
2017-09-29	AAP	Stock	99.7	99.99	98.24	99.2	1878200.0
2017-09-29	AAT	Stock	40.02	40.14	39.38	39.77	179600.0
2017-09-29	AAU-DELISTED	Stock	1.16	1.19	1.14	1.15	100445.0
2017-09-29	AAUAF-DELISTED	Stock	1.16	1.19	1.14	1.15	101864.0
2017-09-29	AAV-DELISTED	Stock	6.4	6.4	6.2	6.3	84758.0
2017-09-29	AAWW-DELISTED	Stock	67.2	67.95	65.65	65.75	170476.0
2017-09-29	AAXJ	Stock	71.77	72.35	71.71	72.22	1549713.0
2017-09-29	AAXN-DELISTED	Stock	23.08	23.2	22.65	22.67	479290.0
2017-09-29	AB	Stock	24.35	24.45	24.2	24.3	166600.0
2017-09-29	ABAC-DELISTED	Stock	2.35	2.37	2.301	2.37	9854.0
2017-09-29	ABAX-DELISTED	Stock	44.41	44.78	44.0	44.64	86003.0
2017-09-29	ABB-DELISTED	Stock	24.53	24.775	24.49	24.75	1275957.0
2017-09-29	ABBNY-DELISTED	Stock	24.53	24.775	24.49	24.75	1365636.0
2017-09-29	ABBV	Stock	88.69	89.35	87.67	88.86	6769400.0
2017-09-29	ABC-DELISTED	Stock	81.71	83.84	81.42	82.75	1410903.0
2017-09-29	ABCB	Stock	47.8	48.6	47.8	48.0	251100.0
2017-09-29	ABCD-DELISTED	Stock	6.6	6.75	6.59	6.61	40583.0
2017-09-29	ABCO-DELISTED	Stock	53.8	53.9	53.55	53.6	769325.0
2017-09-29	ABDC-DELISTED	Stock	10.54	10.75	10.36	10.72	99050.0
2017-09-29	ABE-DELISTED	Stock	14.01	14.01	13.7284	13.968	1988.0
2017-09-29	ABEO	Stock	427.5	472.5	406.25	426.25	85320.0
2017-09-29	ABEOW-DELISTED	Stock	12.55	13.8	12.53	12.58	15300.0
2017-09-29	ABEV	Stock	6.64	6.65	6.55	6.59	32054500.0
2017-09-29	ABG	Stock	61.45	61.75	60.6	61.1	150300.0
2017-09-29	ABIL-DELISTED	Stock	0.7465	0.78	0.7118	0.7122	330566.0
2017-09-29	ABM	Stock	41.65	41.74	41.42	41.71	250500.0

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

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