PREVIEW / stock_daily / 2018-12-06

all stock daily files

  file:    by_date/stock_daily/2018/2018-12-06.parquet
  size:    221 KB
  rows:    6,601
  symbols: 2,721

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-12-06	AAPL	Stock	42.94	43.695	42.605	43.68	172393600.0
2018-12-06	MSFT	Stock	105.82	109.24	105.0	109.19	49107400.0
2018-12-06	NVDA	Stock	3.786	3.9623	3.7702	3.9572	692308000.0
2018-12-06	AMZN	Stock	80.7435	85.0525	80.4925	84.9595	175788000.0
2018-12-06	GOOGL	Stock	52.25	53.971	52.124	53.904	47436500.0
2018-12-06	META	Stock	133.82	139.7	133.67	139.63	28218100.0
2018-12-06	TSLA	Stock	23.734	24.492	23.384	24.204	117637500.0
2018-12-06	TLT	Stock	118.54	119.2	118.13	118.19	15319440.0
2018-12-06	ES	Stock	69.24	69.42	67.72	69.14	2344700.0
2018-12-06	CL	Stock	62.85	63.29	61.87	63.23	5080700.0
2018-12-06	A	Stock	71.2	71.93	69.9	71.91	3505900.0
2018-12-06	AA	Stock	29.66	29.68	28.12	29.65	4244200.0
2018-12-06	AABA-DELISTED	Stock	62.89	63.93	62.17	63.81	7361804.0
2018-12-06	AAC-DELISTED	Stock	2.12	2.12	1.92	2.02	474316.0
2018-12-06	AACG	Stock	1.09	1.09	1.05	1.07	103100.0
2018-12-06	AAIC-DELISTED	Stock	8.3	8.38	8.13	8.38	394046.0
2018-12-06	AAL	Stock	36.0	37.1	35.79	36.94	9378900.0
2018-12-06	AAM.A-DELISTED	Stock	22.65	23.0432	22.21	22.6593	66697.0
2018-12-06	AAM.B-DELISTED	Stock	22.88	23.0217	22.35	22.73	44948.0
2018-12-06	AAMC-DELISTED	Stock	14.7059	14.7059	14.2971	14.6941	4128.0
2018-12-06	AAME	Stock	2.68	2.68	2.67	2.68	2600.0
2018-12-06	AAMI	Stock	12.44	12.45	11.81	12.0	659500.0
2018-12-06	AAOI	Stock	20.61	20.82	18.68	20.02	973600.0
2018-12-06	AAON	Stock	23.8733	24.2867	23.2333	23.7867	309300.0
2018-12-06	AAP	Stock	176.31	177.0	170.75	175.76	1226600.0
2018-12-06	AAT	Stock	41.43	42.82	41.05	42.81	302900.0
2018-12-06	AAU-DELISTED	Stock	0.61	0.63	0.61	0.618	175282.0
2018-12-06	AAUAF-DELISTED	Stock	0.61	0.63	0.61	0.618	178817.0
2018-12-06	AAWW-DELISTED	Stock	49.92	51.89	49.1	51.83	160203.0
2018-12-06	AAXJ	Stock	65.02	66.07	64.65	66.02	2513480.0
2018-12-06	AAXN-DELISTED	Stock	42.6	44.65	42.0	44.5	678889.0
2018-12-06	AB	Stock	28.12	28.82	25.88	27.6	2312600.0
2018-12-06	ABAC-DELISTED	Stock	1.35	1.35	1.2	1.2855	7228.0
2018-12-06	ABB-DELISTED	Stock	19.16	19.26	18.94	19.23	3956950.0
2018-12-06	ABBNY-DELISTED	Stock	19.16	19.26	18.94	19.22	4161335.0
2018-12-06	ABBV	Stock	89.7	90.48	87.17	90.33	8734300.0
2018-12-06	ABC-DELISTED	Stock	86.99	86.99	83.33	85.96	1350300.0
2018-12-06	ABCB	Stock	38.3	39.0	37.7	38.33	364700.0
2018-12-06	ABCD-DELISTED	Stock	14.46	14.47	14.45	14.47	554925.0
2018-12-06	ABDC-DELISTED	Stock	6.46	6.47	6.35	6.41	54155.0
2018-12-06	ABEO	Stock	184.75	203.75	182.5	203.75	27612.0
2018-12-06	ABEV	Stock	4.13	4.2	4.07	4.17	30050700.0
2018-12-06	ABG	Stock	64.98	66.06	63.57	65.95	229500.0
2018-12-06	ABIL-DELISTED	Stock	2.43	2.53	2.3	2.49	210867.0
2018-12-06	ABM	Stock	29.28	29.46	28.39	29.11	684100.0
2018-12-06	ABMD-DELISTED	Stock	318.0	333.26	310.5797	332.97	340588.0
2018-12-06	ABR	Stock	11.7	11.86	11.61	11.81	1542700.0
2018-12-06	ABR.A-DELISTED	Stock	25.39	25.39	25.25	25.3469	3619.0
2018-12-06	ABR.B-DELISTED	Stock	25.3161	25.7781	25.3161	25.7781	3365.0
2018-12-06	ABR.C-DELISTED	Stock	25.5288	25.75	25.4505	25.62	11289.0

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

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