PREVIEW / stock_daily / 2017-06-06

all stock daily files

  file:    by_date/stock_daily/2017/2017-06-06.parquet
  size:    215 KB
  rows:    6,465
  symbols: 3,012

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-06-06	AAPL	Stock	38.475	38.9525	38.445	38.6125	106499600.0
2017-06-06	MSFT	Stock	72.3	72.62	72.27	72.52	31511100.0
2017-06-06	NVDA	Stock	3.6955	3.7422	3.67	3.6835	758728000.0
2017-06-06	AMZN	Stock	50.6	50.825	50.0625	50.15	66928000.0
2017-06-06	GOOGL	Stock	50.1655	50.4305	49.74	49.834	31042280.0
2017-06-06	META	Stock	153.41	154.52	152.48	152.81	13457100.0
2017-06-06	TSLA	Stock	22.98	23.966	22.6647	23.5233	166302000.0
2017-06-06	TLT	Stock	125.69	125.87	125.4	125.52	12841474.0
2017-06-06	ES	Stock	62.26	62.39	62.08	62.16	1771100.0
2017-06-06	CL	Stock	77.0	77.25	76.62	77.0	2544500.0
2017-06-06	A	Stock	60.14	60.55	60.1	60.1	1968000.0
2017-06-06	AA	Stock	33.11	33.49	32.78	32.94	3631100.0
2017-06-06	AAAP-DELISTED	Stock	35.75	37.0	35.47	36.5	47978.0
2017-06-06	AABA-DELISTED	Stock	50.42	50.76	50.3	50.5	18670156.0
2017-06-06	AAC-DELISTED	Stock	6.3	6.38	6.02	6.28	106482.0
2017-06-06	AACG	Stock	3.73	3.88	3.58	3.6	94500.0
2017-06-06	AAIC-DELISTED	Stock	14.34	14.44	14.31	14.39	257606.0
2017-06-06	AAL	Stock	49.47	50.1	49.32	49.74	4473500.0
2017-06-06	AAM.A-DELISTED	Stock	25.55	25.62	25.5347	25.6	36190.0
2017-06-06	AAMC-DELISTED	Stock	26.4706	26.4706	25.5824	26.4118	20781.0
2017-06-06	AAME	Stock	3.8	3.85	3.76	3.85	3600.0
2017-06-06	AAMI	Stock	14.44	14.53	14.31	14.4	647200.0
2017-06-06	AAOI	Stock	71.35	75.59	70.5	73.41	2964600.0
2017-06-06	AAON	Stock	24.4	24.5333	24.2333	24.3667	164400.0
2017-06-06	AAP	Stock	134.99	134.99	129.95	131.3	2213000.0
2017-06-06	AAT	Stock	39.6	39.93	39.17	39.58	341900.0
2017-06-06	AAU-DELISTED	Stock	1.42	1.53	1.41	1.4557	469683.0
2017-06-06	AAUAF-DELISTED	Stock	1.42	1.53	1.41	1.44	472787.0
2017-06-06	AAV-DELISTED	Stock	6.1	6.3	6.1	6.25	68593.0
2017-06-06	AAWW-DELISTED	Stock	52.15	52.4	51.0	51.9	209408.0
2017-06-06	AAXJ	Stock	67.69	67.98	67.69	67.84	362004.0
2017-06-06	AAXN-DELISTED	Stock	24.24	24.74	24.2	24.66	414490.0
2017-06-06	AB	Stock	22.5	22.95	22.5	22.75	328300.0
2017-06-06	ABAC-DELISTED	Stock	2.074	2.27	2.0486	2.19	25791.0
2017-06-06	ABAX-DELISTED	Stock	50.15	50.91	49.22	50.385	58839.0
2017-06-06	ABB-DELISTED	Stock	25.61	25.61	25.46	25.54	1986969.0
2017-06-06	ABBNY-DELISTED	Stock	25.61	25.61	25.46	25.54	2503033.0
2017-06-06	ABBV	Stock	67.48	68.1	67.37	67.87	5494500.0
2017-06-06	ABC-DELISTED	Stock	93.19	93.2	91.46	91.66	1163236.0
2017-06-06	ABCB	Stock	43.6	43.95	42.9	43.9	287500.0
2017-06-06	ABCD-DELISTED	Stock	5.01	5.05	4.8601	5.03	18040.0
2017-06-06	ABCO-DELISTED	Stock	52.1	52.35	50.51	51.6	283392.0
2017-06-06	ABDC-DELISTED	Stock	13.21	13.3792	13.18	13.18	36723.0
2017-06-06	ABE-DELISTED	Stock	13.9293	13.9293	13.8801	13.8801	1263.0
2017-06-06	ABEO	Stock	132.5	133.75	122.5	126.25	12840.0
2017-06-06	ABEV	Stock	5.72	5.81	5.71	5.77	27891700.0
2017-06-06	ABG	Stock	56.05	56.65	55.25	56.3	145400.0
2017-06-06	ABIL-DELISTED	Stock	0.5885	0.6	0.57	0.57	13591.0
2017-06-06	ABM	Stock	43.39	43.62	42.86	42.95	264900.0
2017-06-06	ABMD-DELISTED	Stock	141.46	143.0	140.0	142.14	401745.0

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

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