PREVIEW / stock_daily / 2018-03-01

all stock daily files

  file:    by_date/stock_daily/2018/2018-03-01.parquet
  size:    216 KB
  rows:    6,463
  symbols: 2,847

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-01	AAPL	Stock	44.635	44.945	43.165	43.75	195208000.0
2018-03-01	MSFT	Stock	93.99	94.57	91.84	92.85	37135600.0
2018-03-01	NVDA	Stock	6.0478	6.1023	5.703	5.8053	1040120000.0
2018-03-01	AMZN	Stock	75.68	75.9245	73.25	74.6725	136704000.0
2018-03-01	GOOGL	Stock	55.477	55.5637	53.3642	53.5705	55337120.0
2018-03-01	META	Stock	179.01	180.12	174.41	175.94	23201600.0
2018-03-01	TSLA	Stock	23.0007	23.2447	22.0047	22.062	103284000.0
2018-03-01	TLT	Stock	118.43	119.62	118.15	119.32	12287700.0
2018-03-01	ES	Stock	57.0	57.73	56.45	56.55	2715400.0
2018-03-01	CL	Stock	68.87	69.46	68.39	68.86	4997400.0
2018-03-01	A	Stock	68.47	68.8	66.79	67.38	2401800.0
2018-03-01	AA	Stock	45.93	46.44	44.58	45.07	6501700.0
2018-03-01	AABA-DELISTED	Stock	75.04	75.39	72.91	73.75	9048565.0
2018-03-01	AAC-DELISTED	Stock	9.42	9.72	9.28	9.69	135384.0
2018-03-01	AAIC-DELISTED	Stock	10.8	10.92	10.73	10.86	464347.0
2018-03-01	AAL	Stock	54.14	55.31	53.3	53.48	5895600.0
2018-03-01	AAM.A-DELISTED	Stock	25.25	25.4999	25.25	25.4999	260988.0
2018-03-01	AAMC-DELISTED	Stock	20.1618	20.4559	19.2059	19.2059	5355.0
2018-03-01	AAME	Stock	3.35	3.4	3.35	3.4	1100.0
2018-03-01	AAMI	Stock	15.29	15.36	14.82	14.94	739700.0
2018-03-01	AAOI	Stock	27.9	28.2	27.111	27.82	1138200.0
2018-03-01	AAON	Stock	24.6	24.6	23.5667	23.6333	274350.0
2018-03-01	AAP	Stock	114.24	117.89	113.43	117.51	2062100.0
2018-03-01	AAT	Stock	30.72	32.06	30.62	31.72	487700.0
2018-03-01	AAU-DELISTED	Stock	0.8595	0.88	0.84	0.88	73509.0
2018-03-01	AAUAF-DELISTED	Stock	0.8595	0.88	0.84	0.88	79289.0
2018-03-01	AAV-DELISTED	Stock	2.8	2.825	2.7	2.775	359330.0
2018-03-01	AAWW-DELISTED	Stock	60.8	61.6	59.0	60.1	327965.0
2018-03-01	AAXJ	Stock	77.49	77.92	76.01	76.61	793121.0
2018-03-01	AAXN-DELISTED	Stock	34.9	39.74	34.85	37.7	5853789.0
2018-03-01	AB	Stock	26.6	26.7	25.83	26.25	376600.0
2018-03-01	ABAC-DELISTED	Stock	2.48	2.5	2.4658	2.4658	16395.0
2018-03-01	ABAX-DELISTED	Stock	66.64	67.8	65.23	66.19	105594.0
2018-03-01	ABB-DELISTED	Stock	24.23	24.31	23.86	24.02	2795408.0
2018-03-01	ABBNY-DELISTED	Stock	24.23	24.31	23.86	24.02	4569966.0
2018-03-01	ABBV	Stock	115.91	116.61	111.81	113.84	7148900.0
2018-03-01	ABC-DELISTED	Stock	94.84	95.34	92.51	93.29	1872405.0
2018-03-01	ABCB	Stock	53.35	54.0	52.75	53.0	424300.0
2018-03-01	ABCD-DELISTED	Stock	7.38	7.39	7.17	7.31	36109.0
2018-03-01	ABDC-DELISTED	Stock	7.53	7.68	7.21	7.46	56122.0
2018-03-01	ABE-DELISTED	Stock	15.08	15.19	14.97	15.0	7303.0
2018-03-01	ABEO	Stock	338.75	355.0	336.25	350.0	27700.0
2018-03-01	ABEOW-DELISTED	Stock	8.651	8.651	8.651	8.651	100.0
2018-03-01	ABEV	Stock	6.87	6.92	6.72	6.81	19621300.0
2018-03-01	ABG	Stock	65.7	66.4	64.15	64.95	194900.0
2018-03-01	ABIL-DELISTED	Stock	0.3846	0.3938	0.37	0.379	94889.0
2018-03-01	ABLX-DELISTED	Stock	53.5563	53.76	53.29	53.76	118139.0
2018-03-01	ABM	Stock	35.03	35.3	33.84	34.01	968700.0
2018-03-01	ABMD-DELISTED	Stock	268.0	269.9321	258.1	265.77	432996.0
2018-03-01	ABR	Stock	8.6	8.66	8.57	8.65	637200.0

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

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