PREVIEW / stock_daily / 2018-06-04

all stock daily files

  file:    by_date/stock_daily/2018/2018-06-04.parquet
  size:    218 KB
  rows:    6,507
  symbols: 2,802

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-06-04	AAPL	Stock	47.91	48.355	47.8375	47.9575	105064800.0
2018-06-04	MSFT	Stock	101.26	101.86	100.85	101.67	27281600.0
2018-06-04	NVDA	Stock	6.475	6.6435	6.4425	6.6213	642024000.0
2018-06-04	AMZN	Stock	82.445	83.284	82.2745	83.2635	63754000.0
2018-06-04	GOOGL	Stock	56.925	57.8929	56.85	57.652	44754020.0
2018-06-04	META	Stock	191.84	193.98	191.47	193.28	18939800.0
2018-06-04	TSLA	Stock	19.6227	19.9333	19.57	19.7827	71967000.0
2018-06-04	TLT	Stock	120.11	120.14	119.37	119.43	7156542.0
2018-06-04	ES	Stock	55.97	56.24	55.49	55.5	2165200.0
2018-06-04	CL	Stock	62.69	63.04	62.52	62.71	3441400.0
2018-06-04	A	Stock	63.17	63.51	62.76	63.38	1958000.0
2018-06-04	AA	Stock	48.13	48.82	48.13	48.46	2229500.0
2018-06-04	AABA-DELISTED	Stock	79.25	80.51	79.25	80.24	2962879.0
2018-06-04	AAC-DELISTED	Stock	10.49	10.55	10.03	10.08	105021.0
2018-06-04	AACG	Stock	5.08	5.28	5.08	5.28	9700.0
2018-06-04	AAIC-DELISTED	Stock	11.55	11.79	11.55	11.77	938883.0
2018-06-04	AAL	Stock	44.04	45.01	43.96	44.86	5685200.0
2018-06-04	AAM.A-DELISTED	Stock	25.06	25.06	24.931	25.03	23389.0
2018-06-04	AAM.B-DELISTED	Stock	24.36	24.47	24.36	24.47	46048.0
2018-06-04	AAMC-DELISTED	Stock	19.8676	20.0	18.3676	19.7941	10125.0
2018-06-04	AAME	Stock	2.83	2.9	2.83	2.9	1600.0
2018-06-04	AAMI	Stock	15.84	15.96	15.79	15.9	372700.0
2018-06-04	AAOI	Stock	45.47	49.75	45.281	46.95	3245100.0
2018-06-04	AAON	Stock	20.8	21.3333	20.8	21.2333	312000.0
2018-06-04	AAP	Stock	129.0	131.98	128.99	129.91	1008600.0
2018-06-04	AAT	Stock	36.48	36.8	36.38	36.63	392500.0
2018-06-04	AAU-DELISTED	Stock	0.72	0.73	0.716	0.72	173813.0
2018-06-04	AAUAF-DELISTED	Stock	0.72	0.73	0.716	0.72	197620.0
2018-06-04	AAV-DELISTED	Stock	3.1	3.1	2.9	2.95	403462.0
2018-06-04	AAWW-DELISTED	Stock	69.3	70.525	68.55	70.35	198074.0
2018-06-04	AAXJ	Stock	77.25	77.71	77.25	77.61	366982.0
2018-06-04	AAXN-DELISTED	Stock	65.27	66.13	64.6748	66.07	860932.0
2018-06-04	AB	Stock	28.75	28.9	28.65	28.85	240700.0
2018-06-04	ABAC-DELISTED	Stock	2.211	3.39	2.21	2.55	785863.0
2018-06-04	ABAX-DELISTED	Stock	82.98	83.18	82.73	82.955	193974.0
2018-06-04	ABB-DELISTED	Stock	23.12	23.19	23.05	23.08	1396986.0
2018-06-04	ABBNY-DELISTED	Stock	23.12	23.19	23.05	23.07	1440634.0
2018-06-04	ABBV	Stock	98.48	99.46	97.62	99.1	10922500.0
2018-06-04	ABC-DELISTED	Stock	82.87	85.235	82.74	84.32	895667.0
2018-06-04	ABCB	Stock	56.0	57.05	56.0	56.9	311300.0
2018-06-04	ABCD-DELISTED	Stock	10.09	10.24	10.0101	10.11	105027.0
2018-06-04	ABDC-DELISTED	Stock	6.8552	6.8552	6.54	6.73	43635.0
2018-06-04	ABEO	Stock	440.0	446.25	387.5	388.25	66728.0
2018-06-04	ABEOW-DELISTED	Stock	11.3	11.3	10.95	10.95	2000.0
2018-06-04	ABEV	Stock	5.38	5.4	5.31	5.34	19277400.0
2018-06-04	ABG	Stock	70.6	71.1	69.95	71.0	146600.0
2018-06-04	ABIL-DELISTED	Stock	2.31	2.44	2.31	2.36	1620.0
2018-06-04	ABLX-DELISTED	Stock	52.42	52.42	52.42	52.42	100.0
2018-06-04	ABM	Stock	28.61	28.93	28.25	28.93	1380900.0
2018-06-04	ABMD-DELISTED	Stock	395.61	406.34	392.373	405.91	651962.0

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

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