PREVIEW / stock_daily / 2017-07-21

all stock daily files

  file:    by_date/stock_daily/2017/2017-07-21.parquet
  size:    214 KB
  rows:    6,442
  symbols: 2,960

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-07-21	AAPL	Stock	37.4975	37.61	37.22	37.5675	105010400.0
2017-07-21	MSFT	Stock	73.45	74.29	73.17	73.79	46717100.0
2017-07-21	NVDA	Stock	4.1667	4.2325	4.1523	4.2025	648332000.0
2017-07-21	AMZN	Stock	51.064	51.305	50.55	51.2835	54692000.0
2017-07-21	GOOGL	Stock	49.45	49.7555	49.2085	49.692	29266440.0
2017-07-21	META	Stock	164.16	165.05	163.75	164.43	14744000.0
2017-07-21	TSLA	Stock	21.964	22.084	21.72	21.8933	73524000.0
2017-07-21	TLT	Stock	125.73	126.03	125.57	125.69	6201481.0
2017-07-21	ES	Stock	61.12	61.56	60.97	61.54	1223700.0
2017-07-21	CL	Stock	69.8	73.68	69.78	73.27	7173300.0
2017-07-21	A	Stock	60.83	61.6	60.76	61.37	1283200.0
2017-07-21	AA	Stock	36.55	36.859	36.506	36.62	2527500.0
2017-07-21	AAAP-DELISTED	Stock	41.51	41.59	40.56	41.33	74788.0
2017-07-21	AABA-DELISTED	Stock	58.19	58.4	57.76	58.16	5602713.0
2017-07-21	AAC-DELISTED	Stock	6.68	6.81	6.45	6.74	125016.0
2017-07-21	AACG	Stock	4.81	4.82	4.81	4.82	300.0
2017-07-21	AAIC-DELISTED	Stock	13.76	13.81	13.58	13.78	294950.0
2017-07-21	AAL	Stock	52.13	52.55	51.45	51.91	4544400.0
2017-07-21	AAM.A-DELISTED	Stock	26.05	26.14	26.01	26.11	50921.0
2017-07-21	AAMC-DELISTED	Stock	26.9542	27.9412	26.9542	27.9412	8561.0
2017-07-21	AAME	Stock	3.6	3.6	3.6	3.6	1400.0
2017-07-21	AAMI	Stock	15.17	15.17	14.78	14.79	662700.0
2017-07-21	AAOI	Stock	90.48	91.768	85.62	89.95	5134600.0
2017-07-21	AAON	Stock	25.1333	25.1667	24.8333	24.8667	168600.0
2017-07-21	AAP	Stock	103.37	105.46	103.36	105.27	1216400.0
2017-07-21	AAT	Stock	40.76	40.76	39.79	40.2	235900.0
2017-07-21	AAU-DELISTED	Stock	1.24	1.265	1.22	1.235	90760.0
2017-07-21	AAUAF-DELISTED	Stock	1.24	1.265	1.22	1.24	92700.0
2017-07-21	AAV-DELISTED	Stock	7.0	7.0	6.825	6.975	72607.0
2017-07-21	AAWW-DELISTED	Stock	57.65	57.75	56.725	57.75	179013.0
2017-07-21	AAXJ	Stock	70.41	70.52	70.335	70.51	808184.0
2017-07-21	AAXN-DELISTED	Stock	25.58	25.58	25.19	25.24	297935.0
2017-07-21	AB	Stock	24.6	24.85	24.6	24.75	125900.0
2017-07-21	ABAC-DELISTED	Stock	2.13	2.15	2.02	2.12	31763.0
2017-07-21	ABAX-DELISTED	Stock	52.12	52.1299	51.07	51.14	92395.0
2017-07-21	ABB-DELISTED	Stock	23.96	23.98	23.69	23.81	5453929.0
2017-07-21	ABBNY-DELISTED	Stock	23.96	23.98	23.69	23.8	6616535.0
2017-07-21	ABBV	Stock	73.98	75.04	73.85	74.63	4961500.0
2017-07-21	ABC-DELISTED	Stock	91.59	92.08	91.44	91.6	496847.0
2017-07-21	ABCB	Stock	51.25	51.28	46.35	46.95	218100.0
2017-07-21	ABCD-DELISTED	Stock	4.95	4.97	4.82	4.85	27957.0
2017-07-21	ABCO-DELISTED	Stock	57.05	57.25	56.55	57.2	314985.0
2017-07-21	ABDC-DELISTED	Stock	12.45	12.53	12.21	12.46	73249.0
2017-07-21	ABE-DELISTED	Stock	14.03	14.03	13.96	13.99	4262.0
2017-07-21	ABEO	Stock	245.0	252.5	238.75	245.0	21656.0
2017-07-21	ABEOW-DELISTED	Stock	5.17	5.4799	5.1291	5.25	6020.0
2017-07-21	ABEV	Stock	5.97	5.98	5.92	5.94	12815500.0
2017-07-21	ABG	Stock	57.75	57.8	56.5	57.35	260100.0
2017-07-21	ABIL-DELISTED	Stock	0.91	0.945	0.9	0.93	52075.0
2017-07-21	ABM	Stock	44.23	44.24	43.71	43.95	219600.0

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

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