PREVIEW / stock_daily / 2017-07-28

all stock daily files

  file:    by_date/stock_daily/2017/2017-07-28.parquet
  size:    214 KB
  rows:    6,407
  symbols: 2,939

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-28	AAPL	Stock	37.4725	37.5575	37.2975	37.375	68854800.0
2017-07-28	MSFT	Stock	72.67	73.31	72.54	73.04	18306700.0
2017-07-28	NVDA	Stock	4.0072	4.1345	3.982	4.1098	513348000.0
2017-07-28	AMZN	Stock	50.607	51.6425	50.05	51.002	154188000.0
2017-07-28	GOOGL	Stock	47.3995	48.0895	47.2655	47.9165	36275880.0
2017-07-28	META	Stock	169.07	173.43	169.05	172.45	24557600.0
2017-07-28	TSLA	Stock	22.4593	22.64	22.1673	22.338	73206000.0
2017-07-28	TLT	Stock	123.27	123.99	123.26	123.89	5491761.0
2017-07-28	ES	Stock	60.64	60.97	60.22	60.53	1116300.0
2017-07-28	CL	Stock	72.83	73.11	72.26	72.54	3407500.0
2017-07-28	A	Stock	59.91	60.23	59.61	60.08	1236400.0
2017-07-28	AA	Stock	36.17	36.32	35.54	35.64	2859000.0
2017-07-28	AAAP-DELISTED	Stock	42.52	47.63	42.27	47.38	128330.0
2017-07-28	AABA-DELISTED	Stock	58.11	59.64	57.98	59.19	4964710.0
2017-07-28	AAC-DELISTED	Stock	6.42	6.56	6.295	6.53	62798.0
2017-07-28	AACG	Stock	4.54	4.7	4.54	4.7	9400.0
2017-07-28	AAIC-DELISTED	Stock	12.99	13.0	12.805	12.85	380834.0
2017-07-28	AAL	Stock	49.02	50.67	48.73	50.49	9153400.0
2017-07-28	AAM.A-DELISTED	Stock	26.19	26.23	26.02	26.22	40879.0
2017-07-28	AAMC-DELISTED	Stock	27.0294	27.0294	27.0294	27.0294	2441.0
2017-07-28	AAMI	Stock	14.84	14.9	14.75	14.84	371900.0
2017-07-28	AAOI	Stock	94.82	99.0	94.4	96.64	2629700.0
2017-07-28	AAON	Stock	22.5667	22.7333	22.32	22.5333	188850.0
2017-07-28	AAP	Stock	109.9	111.19	109.25	110.21	1033100.0
2017-07-28	AAT	Stock	40.41	40.73	40.03	40.2	145000.0
2017-07-28	AAU-DELISTED	Stock	1.19	1.21	1.1841	1.2	156177.0
2017-07-28	AAUAF-DELISTED	Stock	1.19	1.21	1.1841	1.19	161874.0
2017-07-28	AAV-DELISTED	Stock	7.15	7.275	7.0	7.0	126813.0
2017-07-28	AAWW-DELISTED	Stock	57.7	59.05	57.425	58.95	230415.0
2017-07-28	AAXJ	Stock	70.51	70.75	70.35	70.7	663620.0
2017-07-28	AAXN-DELISTED	Stock	24.85	25.0	24.67	24.72	357214.0
2017-07-28	AB	Stock	24.15	24.55	23.65	24.25	536300.0
2017-07-28	ABAC-DELISTED	Stock	2.48	2.69	2.3319	2.45	22744.0
2017-07-28	ABAX-DELISTED	Stock	49.25	51.83	47.04	47.64	262320.0
2017-07-28	ABB-DELISTED	Stock	23.36	23.52	23.32	23.51	1118420.0
2017-07-28	ABBNY-DELISTED	Stock	23.36	23.52	23.32	23.5	1156239.0
2017-07-28	ABBV	Stock	71.64	72.44	69.38	70.44	8012400.0
2017-07-28	ABC-DELISTED	Stock	93.0	94.17	92.38	93.96	700869.0
2017-07-28	ABCB	Stock	46.0	46.2	45.4	45.75	102000.0
2017-07-28	ABCD-DELISTED	Stock	4.83	4.93	4.83	4.85	23727.0
2017-07-28	ABCO-DELISTED	Stock	56.15	57.25	56.15	57.15	415665.0
2017-07-28	ABDC-DELISTED	Stock	11.74	11.97	11.6001	11.91	82187.0
2017-07-28	ABE-DELISTED	Stock	14.1	14.21	14.1	14.21	2432.0
2017-07-28	ABEO	Stock	207.5	225.0	205.25	218.75	23744.0
2017-07-28	ABEOW-DELISTED	Stock	3.95	4.925	3.95	4.65	4804.0
2017-07-28	ABEV	Stock	6.0	6.09	5.97	6.05	14726500.0
2017-07-28	ABG	Stock	53.9	55.35	53.45	55.2	179800.0
2017-07-28	ABIL-DELISTED	Stock	0.77	0.77	0.7	0.708	185924.0
2017-07-28	ABM	Stock	44.72	44.85	44.46	44.74	190200.0
2017-07-28	ABMD-DELISTED	Stock	143.01	147.54	142.221	146.26	276776.0

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

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