PREVIEW / stock_daily / 2018-03-29

all stock daily files

  file:    by_date/stock_daily/2018/2018-03-29.parquet
  size:    217 KB
  rows:    6,506
  symbols: 2,857

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-29	AAPL	Stock	41.9525	42.9375	41.725	41.945	153594000.0
2018-03-29	MSFT	Stock	90.18	92.29	88.4	91.27	45867500.0
2018-03-29	NVDA	Stock	5.6028	5.8875	5.5175	5.7898	916628000.0
2018-03-29	AMZN	Stock	70.3	72.7735	68.26	72.367	251622000.0
2018-03-29	GOOGL	Stock	50.5605	52.4025	50.202	51.857	69337520.0
2018-03-29	META	Stock	155.15	161.42	154.14	159.79	59434300.0
2018-03-29	TSLA	Stock	17.0993	18.064	16.5473	17.742	227560500.0
2018-03-29	TLT	Stock	121.54	122.29	121.51	121.9	9694323.0
2018-03-29	ES	Stock	58.75	59.39	58.54	58.92	1846300.0
2018-03-29	CL	Stock	71.12	72.29	71.03	71.68	4829800.0
2018-03-29	A	Stock	66.75	67.58	66.11	66.9	2711300.0
2018-03-29	AA	Stock	44.74	45.663	44.5	44.96	2279200.0
2018-03-29	AABA-DELISTED	Stock	73.1	74.59	72.33	74.04	4495688.0
2018-03-29	AAC-DELISTED	Stock	11.5	11.79	11.42	11.48	77575.0
2018-03-29	AACG	Stock	5.2	5.37	5.2	5.2	9500.0
2018-03-29	AAIC-DELISTED	Stock	10.8	11.17	10.75	11.04	836266.0
2018-03-29	AAL	Stock	51.3	52.43	51.03	51.96	3074100.0
2018-03-29	AAM.A-DELISTED	Stock	24.91	25.06	24.91	25.0499	26103.0
2018-03-29	AAM.B-DELISTED	Stock	24.86	24.94	24.85	24.9	329821.0
2018-03-29	AAME	Stock	3.1	3.3	3.1	3.3	800.0
2018-03-29	AAMI	Stock	15.56	15.84	15.45	15.76	587300.0
2018-03-29	AAOI	Stock	23.98	25.19	23.88	25.06	872900.0
2018-03-29	AAON	Stock	25.8333	26.4	25.6333	26.0	401550.0
2018-03-29	AAP	Stock	116.34	119.22	115.4	118.55	780800.0
2018-03-29	AAT	Stock	34.07	34.07	33.16	33.41	800100.0
2018-03-29	AAU-DELISTED	Stock	0.79	0.8375	0.79	0.8375	77088.0
2018-03-29	AAUAF-DELISTED	Stock	0.79	0.8375	0.79	0.8375	83199.0
2018-03-29	AAV-DELISTED	Stock	2.85	3.0	2.85	2.975	182301.0
2018-03-29	AAWW-DELISTED	Stock	59.6	61.2	59.5	60.4	252474.0
2018-03-29	AAXJ	Stock	76.65	77.77	76.55	77.53	635985.0
2018-03-29	AAXN-DELISTED	Stock	38.19	39.89	38.15	39.32	647439.0
2018-03-29	AB	Stock	26.45	26.95	26.3	26.85	274000.0
2018-03-29	ABAC-DELISTED	Stock	2.36	2.41	2.2501	2.28	15969.0
2018-03-29	ABAX-DELISTED	Stock	69.04	71.44	68.34	70.63	121076.0
2018-03-29	ABB-DELISTED	Stock	23.65	23.87	23.6238	23.745	1271699.0
2018-03-29	ABBNY-DELISTED	Stock	23.65	23.87	23.6238	23.74	1352963.0
2018-03-29	ABBV	Stock	94.52	95.54	93.5	94.65	7399400.0
2018-03-29	ABC-DELISTED	Stock	85.13	86.62	85.04	86.22	1315683.0
2018-03-29	ABCB	Stock	52.75	53.45	52.6	52.9	176300.0
2018-03-29	ABCD-DELISTED	Stock	10.27	11.35	10.22	11.18	547517.0
2018-03-29	ABDC-DELISTED	Stock	7.07	7.13	6.8853	6.96	98936.0
2018-03-29	ABE-DELISTED	Stock	14.52	14.8894	14.52	14.8037	22940.0
2018-03-29	ABEO	Stock	343.75	365.0	333.75	358.75	28656.0
2018-03-29	ABEOW-DELISTED	Stock	9.2	9.5	9.2	9.5	2100.0
2018-03-29	ABEV	Stock	7.16	7.29	7.15	7.27	15230000.0
2018-03-29	ABG	Stock	65.9	67.8	65.85	67.5	231100.0
2018-03-29	ABIL-DELISTED	Stock	4.05	4.05	3.08	3.28	119093.0
2018-03-29	ABLX-DELISTED	Stock	54.81	55.01	54.52	54.6	46823.0
2018-03-29	ABM	Stock	33.48	33.86	33.22	33.48	2581000.0
2018-03-29	ABMD-DELISTED	Stock	284.05	294.85	283.15	291.0	312040.0

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

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