PREVIEW / stock_daily / 2017-07-17

all stock daily files

  file:    by_date/stock_daily/2017/2017-07-17.parquet
  size:    215 KB
  rows:    6,458
  symbols: 2,979

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-17	AAPL	Stock	37.205	37.725	37.1425	37.39	95174000.0
2017-07-17	MSFT	Stock	72.8	73.45	72.72	73.35	21803900.0
2017-07-17	NVDA	Stock	4.1583	4.1875	4.0438	4.1062	930792000.0
2017-07-17	AMZN	Stock	50.2345	50.7375	50.1905	50.502	74252000.0
2017-07-17	GOOGL	Stock	48.816	49.1675	48.54	48.798	33209280.0
2017-07-17	META	Stock	160.25	160.78	158.81	159.73	12858800.0
2017-07-17	TSLA	Stock	21.7027	21.8067	20.8967	21.3047	148153500.0
2017-07-17	TLT	Stock	123.33	123.99	123.27	123.67	4737647.0
2017-07-17	ES	Stock	60.21	60.43	59.96	60.32	902500.0
2017-07-17	CL	Stock	72.41	72.87	72.14	72.59	3297000.0
2017-07-17	A	Stock	61.6	61.84	61.4	61.55	1332700.0
2017-07-17	AA	Stock	36.44	36.69	36.205	36.4	3463700.0
2017-07-17	AAAP-DELISTED	Stock	39.99	40.3	39.56	39.67	45583.0
2017-07-17	AABA-DELISTED	Stock	57.68	57.88	57.13	57.635	6256602.0
2017-07-17	AAC-DELISTED	Stock	6.82	6.99	6.69	6.91	37103.0
2017-07-17	AACG	Stock	4.61	4.8	4.54	4.62	2200.0
2017-07-17	AAIC-DELISTED	Stock	13.9	13.9284	13.8	13.83	258178.0
2017-07-17	AAL	Stock	54.21	54.28	53.85	53.87	3727400.0
2017-07-17	AAM.A-DELISTED	Stock	26.03	26.03	25.8803	25.98	27705.0
2017-07-17	AAMC-DELISTED	Stock	27.4559	27.5	26.1717	27.1323	10343.0
2017-07-17	AAME	Stock	3.6	3.6	3.56	3.56	700.0
2017-07-17	AAMI	Stock	15.41	15.41	15.135	15.33	614500.0
2017-07-17	AAOI	Stock	85.77	85.879	82.09	84.18	4192900.0
2017-07-17	AAON	Stock	24.9667	25.1667	24.8	25.1	119250.0
2017-07-17	AAP	Stock	101.81	102.99	101.62	101.74	1646800.0
2017-07-17	AAT	Stock	39.68	40.07	39.44	39.89	186300.0
2017-07-17	AAU-DELISTED	Stock	1.2	1.25	1.2	1.22	170690.0
2017-07-17	AAUAF-DELISTED	Stock	1.2	1.25	1.2	1.23	171439.0
2017-07-17	AAV-DELISTED	Stock	6.85	7.0	6.85	6.9	71318.0
2017-07-17	AAWW-DELISTED	Stock	57.65	59.2	57.35	58.9	248249.0
2017-07-17	AAXJ	Stock	69.99	69.99	69.73	69.85	1305534.0
2017-07-17	AAXN-DELISTED	Stock	25.24	25.85	25.19	25.81	390816.0
2017-07-17	AB	Stock	24.3	24.9	24.3	24.75	280600.0
2017-07-17	ABAC-DELISTED	Stock	2.53	2.53	2.41	2.41	9235.0
2017-07-17	ABAX-DELISTED	Stock	51.71	52.14	51.6	52.13	69165.0
2017-07-17	ABB-DELISTED	Stock	25.1	25.17	25.05	25.08	1729681.0
2017-07-17	ABBNY-DELISTED	Stock	25.1	25.17	25.05	25.08	1767655.0
2017-07-17	ABBV	Stock	73.1	73.47	72.69	72.7	3461600.0
2017-07-17	ABC-DELISTED	Stock	93.05	93.37	92.55	92.73	868767.0
2017-07-17	ABCB	Stock	46.7	47.25	46.45	46.85	186900.0
2017-07-17	ABCD-DELISTED	Stock	4.85	4.95	4.8	4.85	16361.0
2017-07-17	ABCO-DELISTED	Stock	57.0	57.15	56.65	56.9	205424.0
2017-07-17	ABDC-DELISTED	Stock	13.06	13.2	12.45	12.72	304051.0
2017-07-17	ABE-DELISTED	Stock	14.0321	14.0826	14.0321	14.0826	3021.0
2017-07-17	ABEO	Stock	233.75	233.75	218.75	222.5	13732.0
2017-07-17	ABEOW-DELISTED	Stock	5.5	5.5	4.51	4.7	2358.0
2017-07-17	ABEV	Stock	5.85	5.9	5.84	5.88	11390700.0
2017-07-17	ABG	Stock	56.9	57.85	56.65	57.6	212400.0
2017-07-17	ABIL-DELISTED	Stock	1.04	1.1005	1.0224	1.08	92617.0
2017-07-17	ABM	Stock	42.98	43.28	42.8	43.16	360100.0

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

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