PREVIEW / stock_daily / 2017-11-22

all stock daily files

  file:    by_date/stock_daily/2017/2017-11-22.parquet
  size:    215 KB
  rows:    6,469
  symbols: 2,908

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-11-22	AAPL	Stock	43.34	43.75	43.2625	43.74	102355600.0
2017-11-22	MSFT	Stock	83.83	83.9	83.04	83.11	20553100.0
2017-11-22	NVDA	Stock	5.425	5.425	5.3403	5.3733	356640000.0
2017-11-22	AMZN	Stock	57.05	58.0135	57.05	57.808	71106000.0
2017-11-22	GOOGL	Stock	52.558	52.7715	52.3625	52.596	14537960.0
2017-11-22	META	Stock	181.3	181.73	180.44	180.87	10376300.0
2017-11-22	TSLA	Stock	21.118	21.1613	20.7893	20.84	73764000.0
2017-11-22	TLT	Stock	126.62	127.2048	126.51	127.15	4140708.0
2017-11-22	ES	Stock	63.86	63.96	63.44	63.81	1466000.0
2017-11-22	CL	Stock	72.28	72.51	71.58	71.75	2951100.0
2017-11-22	A	Stock	69.14	69.37	68.3	68.69	3041600.0
2017-11-22	AA	Stock	41.84	42.68	41.775	42.64	3254600.0
2017-11-22	AAAP-DELISTED	Stock	81.1	81.25	81.1	81.18	267965.0
2017-11-22	AABA-DELISTED	Stock	73.02	73.25	72.46	72.6	5978381.0
2017-11-22	AAC-DELISTED	Stock	9.03	9.26	8.97	9.03	129905.0
2017-11-22	AACG	Stock	4.49	4.5	4.46	4.5	3800.0
2017-11-22	AAIC-DELISTED	Stock	11.74	11.89	11.74	11.77	296126.0
2017-11-22	AAL	Stock	48.58	48.97	48.27	48.66	2326900.0
2017-11-22	AAM.A-DELISTED	Stock	26.31	26.4	26.31	26.4	13413.0
2017-11-22	AAMC-DELISTED	Stock	20.6621	24.7059	20.3824	24.7059	9486.0
2017-11-22	AAME	Stock	3.8	3.8	3.7	3.7	1200.0
2017-11-22	AAMI	Stock	16.07	16.3	15.95	16.04	679900.0
2017-11-22	AAOI	Stock	43.0	43.539	41.69	41.95	1062200.0
2017-11-22	AAON	Stock	23.8333	23.9	23.5867	23.8	135300.0
2017-11-22	AAP	Stock	89.2	90.31	88.82	89.62	907700.0
2017-11-22	AAT	Stock	39.33	39.75	39.29	39.55	197400.0
2017-11-22	AAU-DELISTED	Stock	0.9003	0.9306	0.9003	0.9273	212471.0
2017-11-22	AAUAF-DELISTED	Stock	0.9003	0.9306	0.9003	0.93	233250.0
2017-11-22	AAV-DELISTED	Stock	4.95	5.05	4.9	4.9	63901.0
2017-11-22	AAWW-DELISTED	Stock	55.2	55.595	54.2	54.5	111805.0
2017-11-22	AAXJ	Stock	78.31	78.44	78.11	78.36	1317286.0
2017-11-22	AAXN-DELISTED	Stock	23.86	24.0	23.55	23.76	587733.0
2017-11-22	AB	Stock	25.7	25.8	25.45	25.5	145800.0
2017-11-22	ABAC-DELISTED	Stock	3.0829	3.21	3.0629	3.16	21116.0
2017-11-22	ABAX-DELISTED	Stock	50.19	50.82	49.74	50.195	51219.0
2017-11-22	ABB-DELISTED	Stock	25.6	25.6	25.31	25.4	1916040.0
2017-11-22	ABBNY-DELISTED	Stock	25.6	25.6	25.31	25.4	2258103.0
2017-11-22	ABBV	Stock	94.69	95.4	94.22	94.47	2560700.0
2017-11-22	ABC-DELISTED	Stock	79.98	81.99	79.58	81.39	1697576.0
2017-11-22	ABCB	Stock	48.9	49.2	48.45	48.9	224900.0
2017-11-22	ABCD-DELISTED	Stock	5.9	5.98	5.79	5.79	30231.0
2017-11-22	ABDC-DELISTED	Stock	7.72	7.95	7.72	7.87	136466.0
2017-11-22	ABE-DELISTED	Stock	14.5	14.54	14.35	14.4101	9507.0
2017-11-22	ABEO	Stock	402.5	408.75	395.0	403.75	20012.0
2017-11-22	ABEOW-DELISTED	Stock	10.83	11.1515	10.83	11.1515	200.0
2017-11-22	ABEV	Stock	6.37	6.42	6.35	6.4	13423200.0
2017-11-22	ABG	Stock	63.3	64.45	63.3	64.25	251400.0
2017-11-22	ABIL-DELISTED	Stock	0.52	0.55	0.511	0.5422	238671.0
2017-11-22	ABLX-DELISTED	Stock	23.46	23.63	23.35	23.5997	195755.0
2017-11-22	ABM	Stock	40.87	41.0	40.8	40.94	187400.0

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

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