PREVIEW / stock_daily / 2018-04-13

all stock daily files

  file:    by_date/stock_daily/2018/2018-04-13.parquet
  size:    216 KB
  rows:    6,475
  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-13	AAPL	Stock	43.695	43.96	43.4625	43.6825	100497200.0
2018-04-13	MSFT	Stock	94.05	94.18	92.44	93.08	23346100.0
2018-04-13	NVDA	Stock	5.9292	5.9378	5.7388	5.7875	503036000.0
2018-04-13	AMZN	Stock	72.457	72.989	71.226	71.5395	73706000.0
2018-04-13	GOOGL	Stock	52.3445	52.649	51.5075	51.802	25409220.0
2018-04-13	META	Stock	164.58	165.7	163.77	164.52	19990600.0
2018-04-13	TSLA	Stock	20.24	20.2633	19.732	20.0227	109908000.0
2018-04-13	TLT	Stock	120.52	121.13	120.5	120.9	4963954.0
2018-04-13	ES	Stock	58.85	59.35	58.85	59.03	1221300.0
2018-04-13	CL	Stock	71.01	71.66	70.91	71.6	3847900.0
2018-04-13	A	Stock	67.5	67.67	66.88	67.21	2043900.0
2018-04-13	AA	Stock	54.95	55.38	54.27	54.96	2685800.0
2018-04-13	AABA-DELISTED	Stock	71.31	71.31	69.07	69.29	4183575.0
2018-04-13	AAC-DELISTED	Stock	11.18	11.2	10.65	10.78	117798.0
2018-04-13	AACG	Stock	5.25	5.29	5.25	5.25	700.0
2018-04-13	AAIC-DELISTED	Stock	11.26	11.26	11.14	11.15	517299.0
2018-04-13	AAL	Stock	46.75	47.05	45.75	45.87	5226300.0
2018-04-13	AAM.A-DELISTED	Stock	24.79	24.8426	24.72	24.75	12409.0
2018-04-13	AAM.B-DELISTED	Stock	24.74	24.75	24.58	24.59	122289.0
2018-04-13	AAMC-DELISTED	Stock	18.3088	18.3088	18.3088	18.3088	683.0
2018-04-13	AAME	Stock	3.2	3.2	3.13	3.15	4400.0
2018-04-13	AAMI	Stock	14.89	14.98	14.56	14.6	787900.0
2018-04-13	AAOI	Stock	30.28	30.59	29.27	30.19	1413400.0
2018-04-13	AAON	Stock	23.0667	23.1333	22.8667	22.9667	199950.0
2018-04-13	AAP	Stock	111.14	112.4	105.39	106.61	1530400.0
2018-04-13	AAT	Stock	33.58	33.74	33.35	33.71	160900.0
2018-04-13	AAU-DELISTED	Stock	0.83	0.83	0.7952	0.8002	331514.0
2018-04-13	AAUAF-DELISTED	Stock	0.83	0.83	0.7952	0.8002	343693.0
2018-04-13	AAV-DELISTED	Stock	3.4	3.44	3.2	3.25	211098.0
2018-04-13	AAWW-DELISTED	Stock	63.35	63.85	63.2	63.3	131549.0
2018-04-13	AAXJ	Stock	77.68	77.84	76.87	77.09	201641.0
2018-04-13	AAXN-DELISTED	Stock	43.77	43.77	42.65	42.79	709157.0
2018-04-13	AB	Stock	26.9	26.91	26.55	26.55	153700.0
2018-04-13	ABAC-DELISTED	Stock	2.57	2.62	2.4836	2.5452	3200.0
2018-04-13	ABAX-DELISTED	Stock	72.49	72.49	71.03	72.23	48791.0
2018-04-13	ABB-DELISTED	Stock	22.99	23.01	22.76	22.85	1123528.0
2018-04-13	ABBNY-DELISTED	Stock	22.99	23.01	22.76	22.86	1971938.0
2018-04-13	ABBV	Stock	92.63	92.64	91.09	91.83	4630000.0
2018-04-13	ABC-DELISTED	Stock	88.39	88.78	86.11	86.81	1100134.0
2018-04-13	ABCB	Stock	53.95	53.95	52.0	52.1	182700.0
2018-04-13	ABCD-DELISTED	Stock	12.0	12.0142	11.5201	11.54	194582.0
2018-04-13	ABDC-DELISTED	Stock	7.01	7.01	6.72	6.72	59438.0
2018-04-13	ABE-DELISTED	Stock	14.9	14.91	14.9	14.9	4501.0
2018-04-13	ABEO	Stock	473.75	497.5	467.5	493.75	43768.0
2018-04-13	ABEOW-DELISTED	Stock	14.7	14.75	14.41	14.75	9935.0
2018-04-13	ABEV	Stock	6.81	6.83	6.69	6.75	16657300.0
2018-04-13	ABG	Stock	66.7	67.1	65.85	66.65	154000.0
2018-04-13	ABIL-DELISTED	Stock	3.11	3.19	2.86	3.13	11377.0
2018-04-13	ABLX-DELISTED	Stock	54.77	54.84	54.72	54.74	5174.0
2018-04-13	ABM	Stock	32.55	32.7	32.11	32.25	440600.0

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

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