PREVIEW / stock_daily / 2017-07-18

all stock daily files

  file:    by_date/stock_daily/2017/2017-07-18.parquet
  size:    215 KB
  rows:    6,464
  symbols: 2,975

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-18	AAPL	Stock	37.3	37.5325	37.1675	37.52	71475200.0
2017-07-18	MSFT	Stock	73.09	73.39	72.66	73.3	26435300.0
2017-07-18	NVDA	Stock	4.0445	4.1638	4.0325	4.149	776640000.0
2017-07-18	AMZN	Stock	50.3	51.3015	50.2	51.2225	80152000.0
2017-07-18	GOOGL	Stock	48.668	49.5425	48.602	49.3475	28266700.0
2017-07-18	META	Stock	159.66	163.73	159.42	162.86	23722900.0
2017-07-18	TSLA	Stock	21.1667	21.942	21.044	21.8827	95605500.0
2017-07-18	TLT	Stock	124.43	124.77	124.23	124.75	9163037.0
2017-07-18	ES	Stock	60.43	60.63	60.32	60.44	979400.0
2017-07-18	CL	Stock	72.6	72.86	72.36	72.52	2872600.0
2017-07-18	A	Stock	61.43	61.54	60.95	61.21	1520100.0
2017-07-18	AA	Stock	36.4	36.48	35.8	36.43	3052600.0
2017-07-18	AAAP-DELISTED	Stock	39.8499	40.16	39.15	39.85	25361.0
2017-07-18	AABA-DELISTED	Stock	57.39	58.745	56.73	58.47	6457356.0
2017-07-18	AAC-DELISTED	Stock	6.9	7.1	6.73	6.87	92641.0
2017-07-18	AACG	Stock	4.51	4.75	4.5	4.57	4000.0
2017-07-18	AAIC-DELISTED	Stock	13.8	13.8	13.51	13.56	379767.0
2017-07-18	AAL	Stock	53.83	53.84	53.02	53.15	4101400.0
2017-07-18	AAM.A-DELISTED	Stock	26.02	26.0299	25.89	25.9999	21481.0
2017-07-18	AAMC-DELISTED	Stock	27.4412	28.2353	27.3088	27.6471	19176.0
2017-07-18	AAME	Stock	3.55	3.6	3.55	3.6	500.0
2017-07-18	AAMI	Stock	15.29	15.32	15.15	15.29	413100.0
2017-07-18	AAOI	Stock	83.5	91.46	83.07	90.18	5531700.0
2017-07-18	AAON	Stock	25.0333	25.1333	24.6667	24.7667	97350.0
2017-07-18	AAP	Stock	101.78	102.0	99.98	100.3	2218300.0
2017-07-18	AAT	Stock	39.86	40.15	39.72	40.04	132200.0
2017-07-18	AAU-DELISTED	Stock	1.25	1.26	1.23	1.25	247945.0
2017-07-18	AAUAF-DELISTED	Stock	1.25	1.26	1.23	1.25	249278.0
2017-07-18	AAV-DELISTED	Stock	7.0	7.1	6.9	7.05	108301.0
2017-07-18	AAWW-DELISTED	Stock	58.45	59.25	58.05	58.7	293041.0
2017-07-18	AAXJ	Stock	69.82	70.14	69.6999	70.11	683214.0
2017-07-18	AAXN-DELISTED	Stock	25.72	25.72	25.1971	25.24	380390.0
2017-07-18	AB	Stock	24.5	24.8	24.4	24.65	179900.0
2017-07-18	ABAC-DELISTED	Stock	2.509	2.509	2.41	2.42	4980.0
2017-07-18	ABAX-DELISTED	Stock	52.04	52.08	50.88	50.97	48983.0
2017-07-18	ABB-DELISTED	Stock	24.99	25.04	24.919	25.02	2039661.0
2017-07-18	ABBNY-DELISTED	Stock	24.99	25.04	24.919	25.02	2092388.0
2017-07-18	ABBV	Stock	72.63	72.86	71.75	72.23	5269100.0
2017-07-18	ABC-DELISTED	Stock	92.68	92.68	90.97	91.33	1087756.0
2017-07-18	ABCB	Stock	46.45	47.05	46.2	46.8	97800.0
2017-07-18	ABCD-DELISTED	Stock	4.84	4.85	4.82	4.84	7195.0
2017-07-18	ABCO-DELISTED	Stock	56.7	57.05	56.5	56.75	153790.0
2017-07-18	ABDC-DELISTED	Stock	12.74	12.8	12.43	12.44	177826.0
2017-07-18	ABE-DELISTED	Stock	14.1041	14.1669	14.1041	14.14	1175.0
2017-07-18	ABEO	Stock	225.0	232.0	217.5	223.75	19396.0
2017-07-18	ABEOW-DELISTED	Stock	4.5	4.5	4.5	4.5	300.0
2017-07-18	ABEV	Stock	5.87	5.91	5.83	5.89	7506100.0
2017-07-18	ABG	Stock	57.2	57.2	56.0	56.25	126900.0
2017-07-18	ABIL-DELISTED	Stock	1.06	1.06	0.96	1.04	149708.0
2017-07-18	ABM	Stock	43.1	43.28	42.7	43.01	205300.0

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

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