PREVIEW / stock_daily / 2018-11-13

all stock daily files

  file:    by_date/stock_daily/2018/2018-11-13.parquet
  size:    221 KB
  rows:    6,556
  symbols: 2,709

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-11-13	AAPL	Stock	47.9075	49.295	47.8625	48.0575	187531600.0
2018-11-13	MSFT	Stock	107.55	108.74	106.64	106.94	35374600.0
2018-11-13	NVDA	Stock	4.8373	5.1053	4.831	4.9828	644712000.0
2018-11-13	AMZN	Stock	82.4645	83.853	80.6875	81.5585	118666000.0
2018-11-13	GOOGL	Stock	52.7405	53.3332	52.02	52.3985	25749500.0
2018-11-13	META	Stock	142.0	144.88	141.62	142.16	15141700.0
2018-11-13	TSLA	Stock	22.2107	22.98	22.1467	22.582	81729000.0
2018-11-13	TLT	Stock	113.71	114.02	113.4845	114.02	6525830.0
2018-11-13	ES	Stock	65.62	65.96	65.03	65.77	1376800.0
2018-11-13	CL	Stock	61.56	62.59	61.13	61.86	5982000.0
2018-11-13	A	Stock	64.59	65.47	63.94	64.34	2216500.0
2018-11-13	AA	Stock	33.69	35.36	33.26	34.72	4016900.0
2018-11-13	AABA-DELISTED	Stock	60.13	62.38	60.13	61.27	8520653.0
2018-11-13	AAC-DELISTED	Stock	2.79	2.82	2.16	2.44	1108912.0
2018-11-13	AACG	Stock	1.08	1.1	1.03	1.05	41100.0
2018-11-13	AAIC-DELISTED	Stock	8.47	8.525	8.38	8.42	327497.0
2018-11-13	AAL	Stock	37.15	38.42	37.1	37.78	9694100.0
2018-11-13	AAM.A-DELISTED	Stock	24.6396	24.669	24.56	24.669	8007.0
2018-11-13	AAM.B-DELISTED	Stock	24.49	24.49	24.39	24.46	17329.0
2018-11-13	AAMC-DELISTED	Stock	14.2132	14.2132	12.6735	13.3853	9741.0
2018-11-13	AAME	Stock	3.11	3.28	2.96	3.2	6600.0
2018-11-13	AAMI	Stock	12.93	13.06	12.78	12.83	327900.0
2018-11-13	AAOI	Stock	19.55	20.82	19.55	20.16	1159700.0
2018-11-13	AAON	Stock	28.8133	29.4533	28.6	28.7467	300750.0
2018-11-13	AAP	Stock	184.07	185.5	177.51	184.72	3662700.0
2018-11-13	AAT	Stock	39.47	39.64	39.14	39.37	222200.0
2018-11-13	AAU-DELISTED	Stock	0.5	0.5099	0.491	0.5037	126089.0
2018-11-13	AAUAF-DELISTED	Stock	0.5	0.5099	0.491	0.5037	139405.0
2018-11-13	AAWW-DELISTED	Stock	54.0	55.5	53.52	54.78	163306.0
2018-11-13	AAXJ	Stock	64.11	65.01	64.0	64.42	509936.0
2018-11-13	AAXN-DELISTED	Stock	50.26	51.78	49.33	50.3	793745.0
2018-11-13	AB	Stock	29.76	30.13	29.48	30.07	367300.0
2018-11-13	ABAC-DELISTED	Stock	1.68	1.69	1.672	1.672	4204.0
2018-11-13	ABB-DELISTED	Stock	19.7	19.94	19.59	19.7	3124731.0
2018-11-13	ABBNY-DELISTED	Stock	19.7	19.94	19.59	19.7	3814465.0
2018-11-13	ABBV	Stock	90.0	90.88	88.2	88.22	7237200.0
2018-11-13	ABC-DELISTED	Stock	90.03	92.59	89.75	91.31	1356435.0
2018-11-13	ABCB	Stock	44.44	45.25	43.88	44.46	417100.0
2018-11-13	ABCD-DELISTED	Stock	14.41	14.44	14.4	14.42	551765.0
2018-11-13	ABDC-DELISTED	Stock	6.4	6.45	6.39	6.43	42249.0
2018-11-13	ABEO	Stock	192.75	214.0	187.25	191.75	37172.0
2018-11-13	ABEOW-DELISTED	Stock	3.67	3.67	3.67	3.67	1000.0
2018-11-13	ABEV	Stock	4.15	4.15	4.05	4.11	20714800.0
2018-11-13	ABG	Stock	68.64	69.69	68.36	68.64	144500.0
2018-11-13	ABIL-DELISTED	Stock	3.04	3.1139	2.77	2.87	71244.0
2018-11-13	ABM	Stock	30.72	30.86	29.85	30.07	506300.0
2018-11-13	ABMD-DELISTED	Stock	342.4	351.7376	329.3	330.62	590446.0
2018-11-13	ABR	Stock	12.5	12.69	12.48	12.66	1553500.0
2018-11-13	ABR.A-DELISTED	Stock	25.698	25.7399	25.67	25.72	4933.0
2018-11-13	ABR.B-DELISTED	Stock	25.5565	25.8	25.5565	25.79	932.0

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

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