PREVIEW / stock_daily / 2018-08-01

all stock daily files

  file:    by_date/stock_daily/2018/2018-08-01.parquet
  size:    219 KB
  rows:    6,523
  symbols: 2,764

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-01	AAPL	Stock	49.7825	50.44	49.3275	50.375	271742800.0
2018-08-01	MSFT	Stock	106.03	106.45	105.42	106.28	23628700.0
2018-08-01	NVDA	Stock	6.1532	6.209	6.0972	6.1618	283556000.0
2018-08-01	AMZN	Stock	89.2	89.922	88.801	89.8585	83062000.0
2018-08-01	GOOGL	Stock	61.9555	62.295	61.247	61.6495	36994800.0
2018-08-01	META	Stock	173.93	175.08	170.9	171.65	34042100.0
2018-08-01	TSLA	Stock	19.866	20.2	19.5333	20.056	151941000.0
2018-08-01	TLT	Stock	118.285	118.835	118.07	118.46	13312687.0
2018-08-01	ES	Stock	59.8	60.08	59.3	59.74	2446200.0
2018-08-01	CL	Stock	66.83	67.0	65.8	66.08	4375900.0
2018-08-01	A	Stock	65.84	66.17	64.63	64.98	2679200.0
2018-08-01	AA	Stock	43.01	43.01	41.9	42.04	3886600.0
2018-08-01	AABA-DELISTED	Stock	73.2	74.59	72.67	73.23	16596012.0
2018-08-01	AAC-DELISTED	Stock	10.46	10.46	9.4	9.7	185471.0
2018-08-01	AACG	Stock	4.5	4.65	4.5	4.5	2500.0
2018-08-01	AAIC-DELISTED	Stock	10.52	10.53	10.31	10.48	576283.0
2018-08-01	AAL	Stock	39.38	39.47	37.69	38.14	7080700.0
2018-08-01	AAM.A-DELISTED	Stock	25.36	25.42	25.32	25.3636	14397.0
2018-08-01	AAM.B-DELISTED	Stock	25.01	25.04	24.96	24.971	49278.0
2018-08-01	AAMI	Stock	14.2	14.25	13.48	13.8	954700.0
2018-08-01	AAOI	Stock	38.18	38.96	37.4	37.4	942700.0
2018-08-01	AAON	Stock	25.1667	25.2667	24.5	25.0	423600.0
2018-08-01	AAP	Stock	140.52	141.44	139.66	139.75	540200.0
2018-08-01	AAT	Stock	38.43	38.66	37.3	38.21	148500.0
2018-08-01	AAU-DELISTED	Stock	0.69	0.69	0.643	0.6495	108938.0
2018-08-01	AAUAF-DELISTED	Stock	0.69	0.69	0.643	0.6495	119663.0
2018-08-01	AAV-DELISTED	Stock	3.5	3.525	3.35	3.5	107732.0
2018-08-01	AAWW-DELISTED	Stock	67.05	68.075	65.8	67.4	201169.0
2018-08-01	AAXJ	Stock	72.5	72.73	72.24	72.4	797388.0
2018-08-01	AAXN-DELISTED	Stock	68.35	69.43	67.64	68.42	560397.0
2018-08-01	AB	Stock	30.3	30.5	29.55	29.7	471500.0
2018-08-01	ABAC-DELISTED	Stock	2.1828	2.275	2.1828	2.2	9150.0
2018-08-01	ABB-DELISTED	Stock	23.11	23.13	22.73	22.81	2006046.0
2018-08-01	ABBNY-DELISTED	Stock	23.11	23.13	22.73	22.82	2166909.0
2018-08-01	ABBV	Stock	92.29	94.48	92.28	93.91	5330400.0
2018-08-01	ABC-DELISTED	Stock	81.67	82.84	79.46	79.6	2026133.0
2018-08-01	ABCB	Stock	47.1	48.55	47.1	47.7	749000.0
2018-08-01	ABCD-DELISTED	Stock	11.86	12.2	11.72	12.11	97302.0
2018-08-01	ABDC-DELISTED	Stock	6.03	6.11	5.91	6.11	59094.0
2018-08-01	ABEO	Stock	360.0	365.0	353.75	361.25	21312.0
2018-08-01	ABEV	Stock	5.15	5.24	5.14	5.16	18750800.0
2018-08-01	ABG	Stock	70.3	70.8	68.3	70.7	253700.0
2018-08-01	ABIL-DELISTED	Stock	3.25	3.26	2.93	3.05	35326.0
2018-08-01	ABM	Stock	31.22	31.75	31.0	31.12	714900.0
2018-08-01	ABMD-DELISTED	Stock	353.1	368.5	351.76	363.29	567983.0
2018-08-01	ABR	Stock	11.35	11.41	11.22	11.38	957000.0
2018-08-01	ABR.A-DELISTED	Stock	25.9	25.97	25.87	25.9	3125.0
2018-08-01	ABR.C-DELISTED	Stock	26.38	26.38	26.38	26.38	126.0
2018-08-01	ABT	Stock	65.35	65.75	64.71	64.78	4162900.0
2018-08-01	ABTS	Stock	136.95	136.95	127.5	127.5	184.0

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

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