PREVIEW / stock_daily / 2018-08-27

all stock daily files

  file:    by_date/stock_daily/2018/2018-08-27.parquet
  size:    219 KB
  rows:    6,555
  symbols: 2,773

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-08-27	AAPL	Stock	54.2875	54.685	54.0825	54.485	82100400.0
2018-08-27	MSFT	Stock	109.27	109.64	108.51	109.6	19662300.0
2018-08-27	NVDA	Stock	6.8355	6.9725	6.8038	6.8975	505776000.0
2018-08-27	AMZN	Stock	95.75	96.385	95.464	96.384	71380000.0
2018-08-27	GOOGL	Stock	62.207	62.8935	62.034	62.8135	28579840.0
2018-08-27	META	Stock	175.99	178.67	175.79	177.46	17921900.0
2018-08-27	TSLA	Stock	21.2	21.496	20.5873	21.2847	196189500.0
2018-08-27	TLT	Stock	121.78	121.87	121.52	121.59	6407403.0
2018-08-27	ES	Stock	62.93	62.93	61.85	62.21	1023600.0
2018-08-27	CL	Stock	67.14	67.32	66.61	67.09	2078100.0
2018-08-27	A	Stock	66.33	66.35	65.86	66.08	1158800.0
2018-08-27	AA	Stock	43.41	44.35	43.41	43.87	2358900.0
2018-08-27	AABA-DELISTED	Stock	69.68	70.89	69.53	70.89	3161365.0
2018-08-27	AAC-DELISTED	Stock	9.6	9.65	9.3	9.36	53292.0
2018-08-27	AACG	Stock	0.85	2.66	0.82	2.01	10367600.0
2018-08-27	AAIC-DELISTED	Stock	10.13	10.16	10.09	10.13	288999.0
2018-08-27	AAL	Stock	39.02	39.82	39.02	39.52	11236000.0
2018-08-27	AAM.A-DELISTED	Stock	25.87	25.97	25.8304	25.97	12232.0
2018-08-27	AAM.B-DELISTED	Stock	25.35	25.42	25.35	25.39	27808.0
2018-08-27	AAMC-DELISTED	Stock	18.4559	18.4559	18.4559	18.4559	826.0
2018-08-27	AAME	Stock	2.5	2.6	2.5	2.5	2700.0
2018-08-27	AAMI	Stock	12.48	12.84	12.4	12.76	412800.0
2018-08-27	AAOI	Stock	42.95	43.21	42.07	42.11	570900.0
2018-08-27	AAON	Stock	27.6667	27.9	26.9333	27.0667	222900.0
2018-08-27	AAP	Stock	164.87	164.99	161.84	161.98	1064200.0
2018-08-27	AAT	Stock	39.46	39.46	38.78	38.99	176800.0
2018-08-27	AAU-DELISTED	Stock	0.6034	0.6575	0.6034	0.6575	141774.0
2018-08-27	AAUAF-DELISTED	Stock	0.6034	0.6575	0.6034	0.6575	158840.0
2018-08-27	AAV-DELISTED	Stock	3.05	3.1338	3.0	3.075	65669.0
2018-08-27	AAWW-DELISTED	Stock	62.2	63.15	61.85	62.3	102210.0
2018-08-27	AAXJ	Stock	72.03	72.7	72.03	72.49	856363.0
2018-08-27	AAXN-DELISTED	Stock	65.89	67.3	65.8	66.68	301785.0
2018-08-27	AB	Stock	30.25	30.7	30.25	30.45	300200.0
2018-08-27	ABAC-DELISTED	Stock	1.9	1.9	1.9	1.9	1100.0
2018-08-27	ABB-DELISTED	Stock	23.63	23.87	23.61	23.79	2152595.0
2018-08-27	ABBNY-DELISTED	Stock	23.63	23.87	23.61	23.8	2227598.0
2018-08-27	ABBV	Stock	98.11	98.3	97.3	98.02	2456000.0
2018-08-27	ABC-DELISTED	Stock	88.63	89.65	88.23	88.45	658562.0
2018-08-27	ABCB	Stock	50.05	50.3	49.8	49.95	338300.0
2018-08-27	ABCD-DELISTED	Stock	13.74	13.78	13.6101	13.73	74447.0
2018-08-27	ABDC-DELISTED	Stock	6.12	6.1675	6.08	6.145	67119.0
2018-08-27	ABEO	Stock	358.75	365.0	342.5	353.75	22776.0
2018-08-27	ABEV	Stock	4.69	4.76	4.68	4.69	24193500.0
2018-08-27	ABG	Stock	75.35	76.05	75.35	75.6	154000.0
2018-08-27	ABIL-DELISTED	Stock	3.67	3.68	3.43	3.5	103050.0
2018-08-27	ABM	Stock	30.61	30.98	30.54	30.64	351700.0
2018-08-27	ABMD-DELISTED	Stock	384.0	388.0	378.4009	380.59	224367.0
2018-08-27	ABR	Stock	12.08	12.11	12.04	12.09	866300.0
2018-08-27	ABR.A-DELISTED	Stock	25.68	25.8103	25.68	25.8103	650.0
2018-08-27	ABR.B-DELISTED	Stock	25.45	25.4872	25.4	25.4291	4255.0

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

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