PREVIEW / stock_daily / 2017-06-21

all stock daily files

  file:    by_date/stock_daily/2017/2017-06-21.parquet
  size:    215 KB
  rows:    6,453
  symbols: 2,999

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-21	AAPL	Stock	36.38	36.5175	36.1525	36.4675	85063200.0
2017-06-21	MSFT	Stock	70.21	70.62	69.94	70.27	19891100.0
2017-06-21	NVDA	Stock	3.9553	3.9905	3.8925	3.9868	682652000.0
2017-06-21	AMZN	Stock	49.935	50.136	49.6325	50.1115	58450000.0
2017-06-21	GOOGL	Stock	48.5395	48.9835	48.458	48.9295	23232140.0
2017-06-21	META	Stock	152.36	154.08	151.88	153.91	15039800.0
2017-06-21	TSLA	Stock	24.9567	25.1327	24.5347	25.0933	73848000.0
2017-06-21	TLT	Stock	127.11	127.645	126.9	127.56	5914825.0
2017-06-21	ES	Stock	62.95	63.07	62.4	62.72	1168200.0
2017-06-21	CL	Stock	76.35	76.36	75.56	75.68	2522800.0
2017-06-21	A	Stock	60.31	60.53	59.67	59.79	2247900.0
2017-06-21	AA	Stock	30.59	30.59	29.635	29.69	3489600.0
2017-06-21	AAAP-DELISTED	Stock	38.1	39.9	37.95	39.61	103988.0
2017-06-21	AABA-DELISTED	Stock	53.94	55.17	53.89	55.11	25073941.0
2017-06-21	AAC-DELISTED	Stock	6.79	6.967	6.52	6.57	42896.0
2017-06-21	AACG	Stock	4.83	4.85	4.83	4.84	12400.0
2017-06-21	AAIC-DELISTED	Stock	14.9	14.91	14.64	14.65	419373.0
2017-06-21	AAL	Stock	48.33	48.64	48.13	48.43	3469500.0
2017-06-21	AAM.A-DELISTED	Stock	25.88	25.98	25.8701	25.92	61777.0
2017-06-21	AAMC-DELISTED	Stock	26.0588	26.1765	25.7353	25.8676	10492.0
2017-06-21	AAME	Stock	3.7	3.7	3.7	3.7	600.0
2017-06-21	AAMI	Stock	14.68	14.68	14.51	14.54	338900.0
2017-06-21	AAOI	Stock	61.1	64.3	61.09	63.1	1830400.0
2017-06-21	AAON	Stock	24.6	24.64	24.0667	24.1	160800.0
2017-06-21	AAP	Stock	124.26	124.26	118.26	120.11	2492900.0
2017-06-21	AAT	Stock	39.56	39.74	39.15	39.53	182800.0
2017-06-21	AAU-DELISTED	Stock	1.4	1.4	1.34	1.35	116767.0
2017-06-21	AAUAF-DELISTED	Stock	1.4	1.4	1.34	1.34	117309.0
2017-06-21	AAV-DELISTED	Stock	6.15	6.35	6.05	6.05	81997.0
2017-06-21	AAWW-DELISTED	Stock	51.1	51.3	50.3	50.3	193948.0
2017-06-21	AAXJ	Stock	67.4	67.56	67.28	67.39	2022957.0
2017-06-21	AAXN-DELISTED	Stock	25.76	26.375	25.735	26.02	735171.0
2017-06-21	AB	Stock	23.2	23.48	23.18	23.3	309700.0
2017-06-21	ABAC-DELISTED	Stock	2.0	2.0699	1.9661	2.03	5353.0
2017-06-21	ABAX-DELISTED	Stock	51.25	51.91	51.13	51.49	53431.0
2017-06-21	ABB-DELISTED	Stock	25.25	25.3	25.14	25.19	2226784.0
2017-06-21	ABBNY-DELISTED	Stock	25.25	25.3	25.14	25.19	2275373.0
2017-06-21	ABBV	Stock	71.11	71.7	71.05	71.34	6096800.0
2017-06-21	ABC-DELISTED	Stock	93.93	95.65	92.9	95.64	957302.0
2017-06-21	ABCB	Stock	47.2	47.35	46.4	46.4	80900.0
2017-06-21	ABCD-DELISTED	Stock	4.9	5.01	4.83	4.86	65763.0
2017-06-21	ABCO-DELISTED	Stock	51.2	51.8	51.1	51.3	204917.0
2017-06-21	ABDC-DELISTED	Stock	13.45	13.69	13.4	13.43	35416.0
2017-06-21	ABE-DELISTED	Stock	13.99	13.99	13.91	13.98	2460.0
2017-06-21	ABEO	Stock	122.5	128.75	121.25	125.0	10388.0
2017-06-21	ABEV	Stock	5.4	5.46	5.37	5.42	38733100.0
2017-06-21	ABG	Stock	54.9	55.3	51.75	52.7	381300.0
2017-06-21	ABIL-DELISTED	Stock	1.17	1.17	1.05	1.14	188686.0
2017-06-21	ABM	Stock	41.52	41.55	41.34	41.44	213400.0
2017-06-21	ABMD-DELISTED	Stock	144.49	146.0	143.541	145.49	137758.0

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

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