PREVIEW / stock_daily / 2018-08-24

all stock daily files

  file:    by_date/stock_daily/2018/2018-08-24.parquet
  size:    218 KB
  rows:    6,510
  symbols: 2,745

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-24	AAPL	Stock	54.15	54.225	53.7775	54.04	73905600.0
2018-08-24	MSFT	Stock	107.67	108.56	107.56	108.4	17234000.0
2018-08-24	NVDA	Stock	6.6795	6.8202	6.675	6.8055	531512000.0
2018-08-24	AMZN	Stock	95.5255	95.8005	95.127	95.2695	56018000.0
2018-08-24	GOOGL	Stock	61.3	61.87	61.071	61.8375	24453060.0
2018-08-24	META	Stock	173.7	174.82	172.92	174.65	14631600.0
2018-08-24	TSLA	Stock	21.38	21.59	21.2933	21.5213	54039000.0
2018-08-24	TLT	Stock	121.62	122.33	121.49	122.29	6092150.0
2018-08-24	ES	Stock	62.52	62.81	62.06	62.76	882800.0
2018-08-24	CL	Stock	66.55	67.01	66.34	66.88	2046000.0
2018-08-24	A	Stock	65.74	66.26	65.59	65.98	1904200.0
2018-08-24	AA	Stock	42.71	43.53	42.18	43.44	4630500.0
2018-08-24	AABA-DELISTED	Stock	69.08	69.6	68.17	68.9	3892299.0
2018-08-24	AAC-DELISTED	Stock	9.82	9.82	9.46	9.5	130449.0
2018-08-24	AACG	Stock	6.62	6.76	6.55	6.72	135600.0
2018-08-24	AAIC-DELISTED	Stock	10.13	10.16	10.06	10.14	221764.0
2018-08-24	AAL	Stock	38.9	39.15	38.53	38.82	3561700.0
2018-08-24	AAM.A-DELISTED	Stock	25.83	25.87	25.7858	25.87	13332.0
2018-08-24	AAM.B-DELISTED	Stock	25.26	25.42	25.25	25.33	14013.0
2018-08-24	AAMC-DELISTED	Stock	18.4412	18.4412	18.4412	18.4412	646.0
2018-08-24	AAME	Stock	2.6	2.7	2.6	2.7	900.0
2018-08-24	AAMI	Stock	12.49	12.59	12.35	12.5	369700.0
2018-08-24	AAOI	Stock	43.1	43.3	42.465	42.87	734500.0
2018-08-24	AAON	Stock	27.5667	27.7	27.2	27.5667	342450.0
2018-08-24	AAP	Stock	163.15	165.07	162.57	164.36	729300.0
2018-08-24	AAT	Stock	39.29	39.44	39.13	39.42	124300.0
2018-08-24	AAU-DELISTED	Stock	0.585	0.6149	0.585	0.5976	138718.0
2018-08-24	AAUAF-DELISTED	Stock	0.585	0.6149	0.585	0.5975	147274.0
2018-08-24	AAV-DELISTED	Stock	3.05	3.15	3.05	3.05	93735.0
2018-08-24	AAWW-DELISTED	Stock	61.8	62.55	61.7	62.025	184176.0
2018-08-24	AAXJ	Stock	71.13	71.52	71.05	71.48	870993.0
2018-08-24	AAXN-DELISTED	Stock	64.0	65.8	64.0	65.54	379616.0
2018-08-24	AB	Stock	30.05	30.3	29.95	30.2	285500.0
2018-08-24	ABAC-DELISTED	Stock	1.81	2.06	1.78	1.9	30755.0
2018-08-24	ABB-DELISTED	Stock	23.44	23.52	23.31	23.43	2492666.0
2018-08-24	ABBNY-DELISTED	Stock	23.44	23.52	23.31	23.44	2544980.0
2018-08-24	ABBV	Stock	97.14	97.59	96.55	97.4	2996100.0
2018-08-24	ABC-DELISTED	Stock	88.6	88.98	87.92	88.32	505450.0
2018-08-24	ABCB	Stock	50.2	50.25	49.8	49.85	309100.0
2018-08-24	ABCD-DELISTED	Stock	13.19	13.86	13.11	13.72	190279.0
2018-08-24	ABDC-DELISTED	Stock	6.18	6.25	6.08	6.12	52168.0
2018-08-24	ABEO	Stock	353.75	358.75	352.5	356.25	15472.0
2018-08-24	ABEOW-DELISTED	Stock	9.2886	9.2943	9.25	9.2943	600.0
2018-08-24	ABEV	Stock	4.67	4.7	4.61	4.66	32974800.0
2018-08-24	ABG	Stock	75.75	76.2	74.9	75.35	84600.0
2018-08-24	ABIL-DELISTED	Stock	4.0	4.0	3.38	3.67	336713.0
2018-08-24	ABM	Stock	30.27	30.55	30.05	30.5	599300.0
2018-08-24	ABMD-DELISTED	Stock	378.07	384.44	376.6	381.02	298288.0
2018-08-24	ABR	Stock	11.96	12.05	11.93	12.04	1144300.0
2018-08-24	ABR.A-DELISTED	Stock	25.9696	25.9696	25.9199	25.9199	400.0

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

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