PREVIEW / stock_daily / 2018-03-05

all stock daily files

  file:    by_date/stock_daily/2018/2018-03-05.parquet
  size:    216 KB
  rows:    6,479
  symbols: 2,854

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-05	AAPL	Stock	43.8025	44.435	43.63	44.205	113605600.0
2018-03-05	MSFT	Stock	92.34	94.27	92.26	93.64	23901600.0
2018-03-05	NVDA	Stock	5.8628	5.9312	5.738	5.8912	620776000.0
2018-03-05	AMZN	Stock	74.712	76.269	74.05	76.1805	104678000.0
2018-03-05	GOOGL	Stock	53.9065	55.059	53.6135	54.738	28647380.0
2018-03-05	META	Stock	176.2	181.15	175.89	180.4	16189300.0
2018-03-05	TSLA	Stock	22.1593	22.5167	21.9527	22.2233	57357000.0
2018-03-05	TLT	Stock	118.75	118.8	117.63	118.03	5658174.0
2018-03-05	ES	Stock	56.42	57.85	56.34	57.72	1812000.0
2018-03-05	CL	Stock	68.99	70.15	68.97	70.07	3096900.0
2018-03-05	A	Stock	67.25	67.85	66.51	67.55	1890900.0
2018-03-05	AA	Stock	45.18	46.46	44.85	45.65	4588000.0
2018-03-05	AABA-DELISTED	Stock	72.34	73.57	71.77	73.44	5693090.0
2018-03-05	AAC-DELISTED	Stock	9.83	10.25	9.66	9.77	325491.0
2018-03-05	AACG	Stock	5.21	5.24	5.18	5.18	3100.0
2018-03-05	AAIC-DELISTED	Stock	11.0	11.27	11.0	11.24	529740.0
2018-03-05	AAL	Stock	52.9	53.69	52.69	53.19	3974800.0
2018-03-05	AAM.A-DELISTED	Stock	25.4	25.58	25.4	25.58	17126.0
2018-03-05	AAMC-DELISTED	Stock	19.5441	19.5588	19.1765	19.1765	2655.0
2018-03-05	AAME	Stock	3.25	3.35	3.25	3.35	2500.0
2018-03-05	AAMI	Stock	14.89	15.04	14.76	14.96	447800.0
2018-03-05	AAOI	Stock	27.95	28.55	27.48	27.53	949400.0
2018-03-05	AAON	Stock	23.4667	23.8333	23.1667	23.6	183750.0
2018-03-05	AAP	Stock	115.45	117.55	115.12	116.36	1088500.0
2018-03-05	AAT	Stock	31.71	32.4	31.71	32.1	331600.0
2018-03-05	AAU-DELISTED	Stock	0.9	0.9	0.8703	0.8848	98788.0
2018-03-05	AAUAF-DELISTED	Stock	0.9	0.9	0.8703	0.8848	105366.0
2018-03-05	AAV-DELISTED	Stock	2.8	2.95	2.7748	2.875	330479.0
2018-03-05	AAWW-DELISTED	Stock	60.05	60.6	59.575	60.3	114913.0
2018-03-05	AAXJ	Stock	75.83	76.89	75.8	76.69	869693.0
2018-03-05	AAXN-DELISTED	Stock	38.74	39.75	36.91	38.28	1942123.0
2018-03-05	AB	Stock	26.2	26.75	26.1	26.6	330800.0
2018-03-05	ABAC-DELISTED	Stock	2.45	2.45	2.36	2.39	400.0
2018-03-05	ABAX-DELISTED	Stock	68.17	69.9699	67.57	69.6	71818.0
2018-03-05	ABB-DELISTED	Stock	23.96	24.27	23.93	24.185	1722707.0
2018-03-05	ABBNY-DELISTED	Stock	23.97	24.27	23.93	24.19	1795218.0
2018-03-05	ABBV	Stock	114.0	116.32	112.89	115.66	3975700.0
2018-03-05	ABC-DELISTED	Stock	93.01	95.26	92.84	94.93	1138810.0
2018-03-05	ABCB	Stock	53.8	55.45	53.3	55.1	204600.0
2018-03-05	ABCD-DELISTED	Stock	7.21	7.22	6.95	7.03	49326.0
2018-03-05	ABDC-DELISTED	Stock	7.38	7.48	7.25	7.48	43808.0
2018-03-05	ABE-DELISTED	Stock	15.06	15.11	14.955	15.0906	11813.0
2018-03-05	ABEO	Stock	391.25	408.75	383.75	385.0	55064.0
2018-03-05	ABEOW-DELISTED	Stock	10.85	11.1289	10.7	11.0999	3047.0
2018-03-05	ABEV	Stock	6.87	6.97	6.83	6.88	24869800.0
2018-03-05	ABG	Stock	65.6	67.6	65.5	67.1	130200.0
2018-03-05	ABIL-DELISTED	Stock	0.3885	0.3885	0.3701	0.3721	36145.0
2018-03-05	ABLX-DELISTED	Stock	53.97	54.21	53.74	54.17	31123.0
2018-03-05	ABM	Stock	33.29	35.17	33.29	35.01	827600.0
2018-03-05	ABMD-DELISTED	Stock	274.52	281.375	273.18	279.32	324020.0

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

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