PREVIEW / stock_daily / 2018-03-23

all stock daily files

  file:    by_date/stock_daily/2018/2018-03-23.parquet
  size:    217 KB
  rows:    6,488
  symbols: 2,843

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-23	AAPL	Stock	42.0975	42.48	41.235	41.235	164115200.0
2018-03-23	MSFT	Stock	89.5	90.46	87.08	87.18	44068900.0
2018-03-23	NVDA	Stock	6.06	6.0625	5.813	5.8242	735620000.0
2018-03-23	AMZN	Stock	76.9505	77.451	74.768	74.778	160120000.0
2018-03-23	GOOGL	Stock	52.5685	53.339	51.2435	51.3275	49879420.0
2018-03-23	META	Stock	165.44	166.6	159.02	159.39	53609700.0
2018-03-23	TSLA	Stock	20.75	20.75	20.03	20.1027	99823500.0
2018-03-23	TLT	Stock	119.68	120.31	119.62	120.17	7250408.0
2018-03-23	ES	Stock	57.66	58.18	56.65	56.79	1359100.0
2018-03-23	CL	Stock	68.92	69.47	68.26	68.38	3743700.0
2018-03-23	A	Stock	67.58	67.73	65.94	66.06	2594100.0
2018-03-23	AA	Stock	45.17	46.0	44.6	44.71	3256200.0
2018-03-23	AABA-DELISTED	Stock	74.98	75.75	72.67	73.0	4461958.0
2018-03-23	AAC-DELISTED	Stock	12.48	12.67	11.88	12.02	93003.0
2018-03-23	AACG	Stock	5.1	5.28	5.1	5.28	4300.0
2018-03-23	AAIC-DELISTED	Stock	11.63	11.69	11.5	11.5	467681.0
2018-03-23	AAL	Stock	52.63	53.1	50.99	51.01	3966000.0
2018-03-23	AAM.A-DELISTED	Stock	25.1	25.1	25.06	25.06	24777.0
2018-03-23	AAMC-DELISTED	Stock	17.1618	17.1618	17.1618	17.1618	340.0
2018-03-23	AAME	Stock	3.13	3.25	3.1	3.25	1100.0
2018-03-23	AAMI	Stock	15.5	15.57	15.3	15.35	1305900.0
2018-03-23	AAOI	Stock	26.0	26.325	25.23	25.36	1127900.0
2018-03-23	AAON	Stock	25.7333	25.7667	24.8	24.8	228150.0
2018-03-23	AAP	Stock	112.41	113.26	110.34	110.84	1085900.0
2018-03-23	AAT	Stock	32.6	32.6	31.69	31.78	287600.0
2018-03-23	AAU-DELISTED	Stock	0.841	0.845	0.8205	0.8399	221990.0
2018-03-23	AAUAF-DELISTED	Stock	0.841	0.845	0.8205	0.8399	224952.0
2018-03-23	AAV-DELISTED	Stock	3.1	3.3	3.0892	3.175	707605.0
2018-03-23	AAWW-DELISTED	Stock	61.6	61.714	58.65	59.0	388778.0
2018-03-23	AAXJ	Stock	76.83	77.0	75.2	75.23	629470.0
2018-03-23	AAXN-DELISTED	Stock	38.57	39.16	37.89	37.9	663088.0
2018-03-23	AB	Stock	25.9	26.47	25.85	26.05	375400.0
2018-03-23	ABAC-DELISTED	Stock	2.4499	2.98	2.4245	2.8362	121998.0
2018-03-23	ABAX-DELISTED	Stock	72.89	73.5	72.22	72.52	116603.0
2018-03-23	ABB-DELISTED	Stock	23.44	23.5	23.0338	23.045	2454088.0
2018-03-23	ABBNY-DELISTED	Stock	23.43	23.5	23.03	23.03	2541590.0
2018-03-23	ABBV	Stock	98.99	100.32	97.37	97.46	14253600.0
2018-03-23	ABC-DELISTED	Stock	85.34	86.46	83.81	84.02	1341628.0
2018-03-23	ABCB	Stock	53.9	54.4	52.1	52.15	258500.0
2018-03-23	ABCD-DELISTED	Stock	10.26	10.589	10.15	10.2	196396.0
2018-03-23	ABDC-DELISTED	Stock	6.92	7.23	6.8522	7.15	121139.0
2018-03-23	ABE-DELISTED	Stock	14.841	14.841	14.73	14.73	2191.0
2018-03-23	ABEO	Stock	370.0	375.0	347.5	351.25	23376.0
2018-03-23	ABEOW-DELISTED	Stock	9.75	9.7853	9.75	9.7853	750.0
2018-03-23	ABEV	Stock	7.18	7.26	7.14	7.15	14800900.0
2018-03-23	ABG	Stock	64.4	65.1	63.9	63.9	158600.0
2018-03-23	ABIL-DELISTED	Stock	2.64	5.9499	2.64	3.65	273438.0
2018-03-23	ABLX-DELISTED	Stock	54.12	54.2803	54.06	54.09	26020.0
2018-03-23	ABM	Stock	33.53	33.55	32.46	32.46	666700.0
2018-03-23	ABMD-DELISTED	Stock	285.78	290.91	282.12	283.98	387669.0

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

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