PREVIEW / stock_daily / 2018-04-09

all stock daily files

  file:    by_date/stock_daily/2018/2018-04-09.parquet
  size:    215 KB
  rows:    6,470
  symbols: 2,823

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-04-09	AAPL	Stock	42.47	43.2725	42.4625	42.5125	116070800.0
2018-04-09	MSFT	Stock	91.04	93.17	90.62	90.77	31533900.0
2018-04-09	NVDA	Stock	5.42	5.5493	5.365	5.3852	499524000.0
2018-04-09	AMZN	Stock	71.2515	71.924	70.1285	70.304	84164000.0
2018-04-09	GOOGL	Stock	51.002	52.2295	50.96	51.0045	33220240.0
2018-04-09	META	Stock	157.82	160.53	156.04	157.93	34915200.0
2018-04-09	TSLA	Stock	20.0247	20.6333	19.2807	19.3107	153747000.0
2018-04-09	TLT	Stock	120.64	121.3	120.35	121.3	6307525.0
2018-04-09	ES	Stock	59.62	60.24	59.58	59.71	1576200.0
2018-04-09	CL	Stock	72.0	72.0	71.21	71.42	2665100.0
2018-04-09	A	Stock	64.92	66.25	64.08	65.19	2639800.0
2018-04-09	AA	Stock	49.78	52.02	49.32	50.62	6810000.0
2018-04-09	AABA-DELISTED	Stock	68.34	69.33	68.11	68.46	4172441.0
2018-04-09	AAC-DELISTED	Stock	11.481	11.58	11.36	11.41	34005.0
2018-04-09	AACG	Stock	5.34	5.34	5.3	5.3	9200.0
2018-04-09	AAIC-DELISTED	Stock	11.4	11.43	11.3	11.3	418650.0
2018-04-09	AAL	Stock	50.5	50.86	49.74	49.82	4330100.0
2018-04-09	AAM.A-DELISTED	Stock	24.85	25.02	24.84	24.8601	36412.0
2018-04-09	AAM.B-DELISTED	Stock	24.84	24.88	24.82	24.85	459489.0
2018-04-09	AAMC-DELISTED	Stock	18.2794	18.2794	18.2794	18.2794	962.0
2018-04-09	AAME	Stock	3.37	3.37	3.15	3.3	3300.0
2018-04-09	AAMI	Stock	14.92	15.12	14.7	14.84	720100.0
2018-04-09	AAOI	Stock	24.22	25.03	23.49	24.36	677600.0
2018-04-09	AAON	Stock	23.0	23.0667	22.6333	22.7333	213300.0
2018-04-09	AAP	Stock	112.94	114.89	110.19	110.35	829500.0
2018-04-09	AAT	Stock	34.48	34.49	34.02	34.02	183600.0
2018-04-09	AAU-DELISTED	Stock	0.785	0.8457	0.785	0.8059	347358.0
2018-04-09	AAUAF-DELISTED	Stock	0.785	0.8457	0.785	0.8059	352072.0
2018-04-09	AAV-DELISTED	Stock	3.15	3.25	3.1	3.15	344825.0
2018-04-09	AAWW-DELISTED	Stock	61.25	61.55	59.85	59.95	103575.0
2018-04-09	AAXJ	Stock	76.34	77.01	76.1	76.27	684984.0
2018-04-09	AAXN-DELISTED	Stock	42.24	42.34	40.84	41.3	1143668.0
2018-04-09	AB	Stock	26.65	27.1	26.4	26.75	551700.0
2018-04-09	ABAC-DELISTED	Stock	2.4975	2.95	2.431	2.6902	11132.0
2018-04-09	ABAX-DELISTED	Stock	69.48	70.58	68.96	69.42	78546.0
2018-04-09	ABB-DELISTED	Stock	22.63	22.86	22.575	22.63	2498113.0
2018-04-09	ABBNY-DELISTED	Stock	22.63	22.86	22.575	22.63	2889757.0
2018-04-09	ABBV	Stock	91.39	93.38	90.42	90.48	8302100.0
2018-04-09	ABC-DELISTED	Stock	85.81	87.69	85.34	86.79	967974.0
2018-04-09	ABCB	Stock	52.5	53.1	51.9	51.9	120800.0
2018-04-09	ABCD-DELISTED	Stock	11.1	11.34	10.912	11.16	198484.0
2018-04-09	ABDC-DELISTED	Stock	7.19	7.2	7.1	7.1	38964.0
2018-04-09	ABE-DELISTED	Stock	14.75	14.85	14.75	14.85	1077.0
2018-04-09	ABEO	Stock	385.0	427.5	367.5	413.75	88840.0
2018-04-09	ABEOW-DELISTED	Stock	10.0	11.7	10.0	11.7	2400.0
2018-04-09	ABEV	Stock	6.83	6.87	6.76	6.79	33428700.0
2018-04-09	ABG	Stock	67.3	68.1	65.25	65.3	148200.0
2018-04-09	ABIL-DELISTED	Stock	2.83	3.1412	2.703	3.04	30660.0
2018-04-09	ABLX-DELISTED	Stock	54.77	54.89	54.72	54.76	53756.0
2018-04-09	ABM	Stock	32.77	32.94	32.08	32.14	478400.0

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

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