PREVIEW / stock_daily / 2018-02-22

all stock daily files

  file:    by_date/stock_daily/2018/2018-02-22.parquet
  size:    217 KB
  rows:    6,478
  symbols: 2,846

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
2018-02-22	AAPL	Stock	42.95	43.4875	42.9275	43.125	123967600.0
2018-02-22	MSFT	Stock	92.05	92.73	91.36	91.73	24392800.0
2018-02-22	NVDA	Stock	6.0682	6.1408	5.9875	6.0538	534364000.0
2018-02-22	AMZN	Stock	74.768	75.127	73.788	74.267	97162000.0
2018-02-22	GOOGL	Stock	55.9585	56.273	55.2575	55.495	28010720.0
2018-02-22	META	Stock	178.7	180.21	177.41	178.99	18464200.0
2018-02-22	TSLA	Stock	22.3687	23.1627	22.3167	23.078	104547000.0
2018-02-22	TLT	Stock	117.24	117.66	117.0	117.09	9317852.0
2018-02-22	ES	Stock	57.48	58.06	57.13	57.48	3204800.0
2018-02-22	CL	Stock	69.28	69.78	69.16	69.39	3162100.0
2018-02-22	A	Stock	71.72	71.76	70.51	70.68	2403400.0
2018-02-22	AA	Stock	48.01	48.4	46.83	48.01	4232500.0
2018-02-22	AABA-DELISTED	Stock	75.82	75.99	75.06	75.51	7896906.0
2018-02-22	AAC-DELISTED	Stock	9.58	10.75	8.28	8.96	1040305.0
2018-02-22	AACG	Stock	5.39	5.45	5.25	5.25	12900.0
2018-02-22	AAIC-DELISTED	Stock	11.3	11.31	11.19	11.21	335346.0
2018-02-22	AAL	Stock	53.24	53.41	52.7	52.98	4356700.0
2018-02-22	AAM.A-DELISTED	Stock	25.44	25.67	25.33	25.43	43101.0
2018-02-22	AAMC-DELISTED	Stock	19.7059	19.9701	19.7059	19.9264	3733.0
2018-02-22	AAME	Stock	3.47	3.47	3.47	3.47	100.0
2018-02-22	AAMI	Stock	15.77	15.87	15.49	15.5	509300.0
2018-02-22	AAOI	Stock	28.66	29.0	26.11	27.51	10601700.0
2018-02-22	AAON	Stock	23.1	23.4667	22.9333	23.2333	103050.0
2018-02-22	AAP	Stock	115.1	115.5	110.2	110.49	1465800.0
2018-02-22	AAT	Stock	32.5	32.76	32.13	32.6	580500.0
2018-02-22	AAU-DELISTED	Stock	0.9196	0.92	0.9	0.9025	180773.0
2018-02-22	AAUAF-DELISTED	Stock	0.9196	0.92	0.9	0.91	183990.0
2018-02-22	AAV-DELISTED	Stock	2.95	3.0	2.85	2.925	107225.0
2018-02-22	AAWW-DELISTED	Stock	58.0	65.3666	58.0	63.65	893092.0
2018-02-22	AAXJ	Stock	78.0	78.485	77.63	77.74	1159278.0
2018-02-22	AAXN-DELISTED	Stock	28.15	28.47	28.1	28.2	331304.0
2018-02-22	AB	Stock	27.2	27.4	27.0	27.05	254900.0
2018-02-22	ABAC-DELISTED	Stock	2.3	2.4781	2.3	2.38	2377.0
2018-02-22	ABAX-DELISTED	Stock	68.71	68.71	66.35	66.95	80594.0
2018-02-22	ABB-DELISTED	Stock	24.85	25.08	24.77	24.9901	1607941.0
2018-02-22	ABBNY-DELISTED	Stock	24.87	25.08	24.77	25.0	1677003.0
2018-02-22	ABBV	Stock	118.57	119.73	116.58	117.56	5185700.0
2018-02-22	ABC-DELISTED	Stock	98.75	99.19	96.65	97.12	3146940.0
2018-02-22	ABCB	Stock	54.55	54.58	51.55	53.8	162400.0
2018-02-22	ABCD-DELISTED	Stock	7.19	7.26	7.02	7.03	59779.0
2018-02-22	ABDC-DELISTED	Stock	7.71	7.77	7.375	7.5	47498.0
2018-02-22	ABE-DELISTED	Stock	15.14	15.17	15.08	15.17	10715.0
2018-02-22	ABEO	Stock	298.75	341.25	296.75	333.75	85696.0
2018-02-22	ABEOW-DELISTED	Stock	7.35	9.0	7.35	8.45	4740.0
2018-02-22	ABEV	Stock	6.84	6.88	6.78	6.82	18530200.0
2018-02-22	ABG	Stock	67.5	68.5	67.15	67.6	190700.0
2018-02-22	ABIL-DELISTED	Stock	0.3805	0.3899	0.3721	0.3822	26857.0
2018-02-22	ABLX-DELISTED	Stock	54.09	54.185	53.9	53.94	47667.0
2018-02-22	ABM	Stock	36.34	36.54	35.99	36.14	1116500.0
2018-02-22	ABMD-DELISTED	Stock	269.64	271.1	261.32	264.19	501238.0

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

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