PREVIEW / stock_daily / 2017-04-27

all stock daily files

  file:    by_date/stock_daily/2017/2017-04-27.parquet
  size:    215 KB
  rows:    6,422
  symbols: 3,006

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-04-27	AAPL	Stock	35.98	36.04	35.8275	35.9475	56985200.0
2017-04-27	MSFT	Stock	68.15	68.38	67.58	68.27	34971000.0
2017-04-27	NVDA	Stock	2.608	2.6495	2.5898	2.641	319700000.0
2017-04-27	AMZN	Stock	45.7195	46.093	45.6055	45.919	106110000.0
2017-04-27	GOOGL	Stock	44.5	44.6689	44.359	44.572	46846060.0
2017-04-27	META	Stock	146.67	147.75	146.14	147.7	11275100.0
2017-04-27	TSLA	Stock	20.7793	20.8727	20.5	20.5753	52029000.0
2017-04-27	TLT	Stock	121.75	122.35	121.58	122.08	4978328.0
2017-04-27	ES	Stock	59.75	60.3	59.7	59.77	1489500.0
2017-04-27	CL	Stock	73.52	73.85	73.25	73.3	3907000.0
2017-04-27	A	Stock	54.93	55.51	54.83	55.43	1529000.0
2017-04-27	AA	Stock	35.75	35.9	34.155	34.52	14773500.0
2017-04-27	AAAP-DELISTED	Stock	37.26	37.66	36.72	37.45	30341.0
2017-04-27	AABA-DELISTED	Stock	48.16	48.47	48.02	48.36	8364877.0
2017-04-27	AAC-DELISTED	Stock	7.5	7.65	7.07	7.1	61570.0
2017-04-27	AACG	Stock	3.81	3.81	3.68	3.7	10500.0
2017-04-27	AAIC-DELISTED	Stock	14.85	14.88	14.45	14.63	377710.0
2017-04-27	AAL	Stock	43.91	44.21	42.41	43.98	18988600.0
2017-04-27	AAM.A-DELISTED	Stock	25.37	25.43	25.36	25.4	122358.0
2017-04-27	AAMC-DELISTED	Stock	21.8088	21.8088	21.0441	21.7059	6011.0
2017-04-27	AAMI	Stock	15.68	15.75	15.54	15.65	199400.0
2017-04-27	AAOI	Stock	47.85	49.83	46.92	49.36	2356200.0
2017-04-27	AAON	Stock	24.9	25.0667	24.6867	24.8667	208200.0
2017-04-27	AAP	Stock	145.75	148.28	140.96	143.19	2079700.0
2017-04-27	AAT	Stock	43.28	43.5	43.0	43.22	280500.0
2017-04-27	AAU-DELISTED	Stock	1.53	1.55	1.48	1.5	295358.0
2017-04-27	AAUAF-DELISTED	Stock	1.53	1.55	1.48	1.5	314129.0
2017-04-27	AAV-DELISTED	Stock	6.2	6.3	6.025	6.25	50977.0
2017-04-27	AAWW-DELISTED	Stock	59.4	60.1	59.0	59.8	157636.0
2017-04-27	AAXJ	Stock	64.38	64.38	64.08	64.24	694325.0
2017-04-27	AAXN-DELISTED	Stock	24.36	24.73	24.36	24.705	604350.0
2017-04-27	AB	Stock	23.0	23.0	22.6	22.8	404300.0
2017-04-27	ABAC-DELISTED	Stock	1.77	1.79	1.65	1.77	28874.0
2017-04-27	ABAX-DELISTED	Stock	49.22	49.46	48.99	49.31	102405.0
2017-04-27	ABB-DELISTED	Stock	24.48	24.58	24.41	24.53	2591380.0
2017-04-27	ABBNY-DELISTED	Stock	24.48	24.58	24.41	24.53	2648766.0
2017-04-27	ABBV	Stock	65.45	67.5	65.12	66.07	11692900.0
2017-04-27	ABC-DELISTED	Stock	81.38	82.19	81.3	82.12	1468353.0
2017-04-27	ABCB	Stock	49.25	49.25	48.2	48.25	135900.0
2017-04-27	ABCD-DELISTED	Stock	4.96	4.96	4.82	4.91	16728.0
2017-04-27	ABCO-DELISTED	Stock	46.55	49.15	45.95	49.05	1397114.0
2017-04-27	ABDC-DELISTED	Stock	13.89	14.1	13.61	13.89	86012.0
2017-04-27	ABE-DELISTED	Stock	13.54	13.54	13.48	13.51	1022.0
2017-04-27	ABEO	Stock	146.25	148.75	137.5	140.0	5572.0
2017-04-27	ABEV	Stock	5.69	5.71	5.62	5.68	24408500.0
2017-04-27	ABG	Stock	63.35	65.05	62.85	63.65	207900.0
2017-04-27	ABIL-DELISTED	Stock	0.79	0.8502	0.7611	0.77	60210.0
2017-04-27	ABM	Stock	43.73	43.94	43.42	43.5	239200.0
2017-04-27	ABMD-DELISTED	Stock	130.47	131.68	128.23	130.91	188111.0
2017-04-27	ABR	Stock	8.75	8.76	8.66	8.68	119300.0

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

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