PREVIEW / stock_daily / 2018-03-21

all stock daily files

  file:    by_date/stock_daily/2018/2018-03-21.parquet
  size:    217 KB
  rows:    6,474
  symbols: 2,840

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-03-21	AAPL	Stock	43.76	43.7725	42.815	42.8175	148219600.0
2018-03-21	MSFT	Stock	92.93	94.05	92.21	92.48	24457100.0
2018-03-21	NVDA	Stock	6.233	6.3	6.1833	6.214	438688000.0
2018-03-21	AMZN	Stock	79.3225	79.5	78.1585	79.093	95016000.0
2018-03-21	GOOGL	Stock	54.6285	55.435	54.3605	54.7	44897300.0
2018-03-21	META	Stock	164.8	173.4	163.3	169.39	106598800.0
2018-03-21	TSLA	Stock	20.6833	21.496	20.6793	21.102	89376000.0
2018-03-21	TLT	Stock	118.66	119.42	118.11	119.08	9742409.0
2018-03-21	ES	Stock	57.79	58.26	57.16	57.46	1607700.0
2018-03-21	CL	Stock	69.64	69.67	68.58	68.69	4184500.0
2018-03-21	A	Stock	69.88	70.09	69.36	69.4	1583200.0
2018-03-21	AA	Stock	46.42	48.062	46.31	47.95	2138100.0
2018-03-21	AABA-DELISTED	Stock	78.97	79.09	77.89	78.055	5187719.0
2018-03-21	AAC-DELISTED	Stock	12.65	12.87	12.58	12.7	107943.0
2018-03-21	AACG	Stock	5.25	5.29	5.25	5.29	500.0
2018-03-21	AAIC-DELISTED	Stock	11.57	11.67	11.51	11.61	368792.0
2018-03-21	AAL	Stock	54.21	54.61	53.17	54.09	4811600.0
2018-03-21	AAM.A-DELISTED	Stock	25.08	25.11	25.03	25.09	27939.0
2018-03-21	AAME	Stock	3.25	3.25	3.1	3.25	1300.0
2018-03-21	AAMI	Stock	15.72	16.02	15.69	15.87	641000.0
2018-03-21	AAOI	Stock	26.51	27.24	26.46	26.71	920700.0
2018-03-21	AAON	Stock	26.2	26.5	25.9333	26.0333	250500.0
2018-03-21	AAP	Stock	114.66	116.29	114.24	115.24	689600.0
2018-03-21	AAT	Stock	32.86	32.95	32.36	32.46	274000.0
2018-03-21	AAU-DELISTED	Stock	0.79	0.84	0.79	0.83	100593.0
2018-03-21	AAUAF-DELISTED	Stock	0.79	0.84	0.79	0.83	107047.0
2018-03-21	AAV-DELISTED	Stock	2.9	3.1	2.9	3.075	546212.0
2018-03-21	AAWW-DELISTED	Stock	64.05	64.75	63.5	63.55	153610.0
2018-03-21	AAXJ	Stock	79.21	79.79	78.96	79.55	408214.0
2018-03-21	AAXN-DELISTED	Stock	38.45	38.98	38.13	38.79	591362.0
2018-03-21	AB	Stock	26.45	26.66	26.4	26.45	156600.0
2018-03-21	ABAC-DELISTED	Stock	2.34	2.45	2.27	2.3	5521.0
2018-03-21	ABAX-DELISTED	Stock	73.01	74.27	72.52	73.89	81253.0
2018-03-21	ABB-DELISTED	Stock	23.94	24.01	23.82	23.855	1642046.0
2018-03-21	ABBNY-DELISTED	Stock	23.94	24.01	23.82	23.86	1702004.0
2018-03-21	ABBV	Stock	113.08	113.79	111.73	112.45	4618000.0
2018-03-21	ABC-DELISTED	Stock	89.45	91.46	89.27	89.5	1518130.0
2018-03-21	ABCB	Stock	56.25	56.45	55.4	56.05	170300.0
2018-03-21	ABCD-DELISTED	Stock	10.7	10.75	9.76	10.05	274248.0
2018-03-21	ABDC-DELISTED	Stock	6.62	6.89	6.47	6.76	271125.0
2018-03-21	ABE-DELISTED	Stock	15.11	15.11	15.11	15.11	720.0
2018-03-21	ABEO	Stock	365.0	402.5	362.75	393.75	40968.0
2018-03-21	ABEOW-DELISTED	Stock	10.0	10.0	10.0	10.0	300.0
2018-03-21	ABEV	Stock	7.14	7.31	7.1	7.26	24703400.0
2018-03-21	ABG	Stock	64.8	66.15	64.5	65.4	114900.0
2018-03-21	ABIL-DELISTED	Stock	0.4029	0.4087	0.39	0.39	44227.0
2018-03-21	ABLX-DELISTED	Stock	53.85	54.21	53.7	54.19	27108.0
2018-03-21	ABM	Stock	34.35	34.65	34.22	34.44	624600.0
2018-03-21	ABMD-DELISTED	Stock	294.68	295.5	290.36	292.31	322463.0
2018-03-21	ABR	Stock	8.85	8.95	8.84	8.88	440300.0

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

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