PREVIEW / stock_daily / 2018-12-18

all stock daily files

  file:    by_date/stock_daily/2018/2018-12-18.parquet
  size:    221 KB
  rows:    6,570
  symbols: 2,695

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-18	AAPL	Stock	41.345	41.8825	41.0975	41.5175	135366000.0
2018-12-18	MSFT	Stock	103.75	104.51	102.52	103.97	49319200.0
2018-12-18	NVDA	Stock	3.6338	3.7582	3.6062	3.6735	564372000.0
2018-12-18	AMZN	Stock	77.0	78.3775	76.1505	77.574	130460000.0
2018-12-18	GOOGL	Stock	51.7	52.9845	51.524	52.1705	43640380.0
2018-12-18	META	Stock	141.08	145.93	139.83	143.66	24709100.0
2018-12-18	TSLA	Stock	23.3693	23.4367	22.246	22.4687	106500000.0
2018-12-18	TLT	Stock	119.07	119.785	118.94	119.6	10019103.0
2018-12-18	ES	Stock	67.51	68.25	66.83	67.06	1838500.0
2018-12-18	CL	Stock	63.39	63.44	62.01	62.46	4294400.0
2018-12-18	A	Stock	68.45	69.03	67.39	67.99	2112000.0
2018-12-18	AA	Stock	28.12	28.66	28.09	28.24	2107800.0
2018-12-18	AABA-DELISTED	Stock	60.4	60.53	58.78	59.08	4995623.0
2018-12-18	AAC-DELISTED	Stock	2.0	2.02	1.95	1.95	174910.0
2018-12-18	AACG	Stock	0.97	1.05	0.97	1.01	43800.0
2018-12-18	AAIC-DELISTED	Stock	8.12	8.1538	7.95	8.02	474999.0
2018-12-18	AAL	Stock	32.47	33.65	32.47	33.54	9117600.0
2018-12-18	AAM.A-DELISTED	Stock	21.35	21.4961	21.09	21.45	123719.0
2018-12-18	AAM.B-DELISTED	Stock	21.47	21.5	21.1	21.4546	83806.0
2018-12-18	AAMC-DELISTED	Stock	12.1412	13.2353	12.1412	12.2294	7609.0
2018-12-18	AAME	Stock	2.4	2.42	2.33	2.42	7100.0
2018-12-18	AAMI	Stock	10.88	11.04	10.7	10.81	504500.0
2018-12-18	AAOI	Stock	17.31	17.68	15.14	15.41	1744800.0
2018-12-18	AAON	Stock	22.94	23.56	22.94	23.0867	221400.0
2018-12-18	AAP	Stock	160.0	162.89	157.83	158.24	1312500.0
2018-12-18	AAT	Stock	41.0	41.4	40.75	41.1	297000.0
2018-12-18	AAU-DELISTED	Stock	0.63	0.63	0.5958	0.5968	425652.0
2018-12-18	AAUAF-DELISTED	Stock	0.63	0.63	0.5958	0.5968	441901.0
2018-12-18	AAWW-DELISTED	Stock	43.14	43.5	41.975	42.11	363305.0
2018-12-18	AAXJ	Stock	63.91	64.24	63.69	63.85	2664591.0
2018-12-18	AAXN-DELISTED	Stock	44.44	45.43	44.13	44.45	625681.0
2018-12-18	AB	Stock	25.42	26.56	25.42	25.78	525100.0
2018-12-18	ABAC-DELISTED	Stock	1.04	1.17	0.952	1.15	1052.0
2018-12-18	ABB-DELISTED	Stock	19.54	19.64	19.335	19.41	2823471.0
2018-12-18	ABBNY-DELISTED	Stock	19.54	19.64	19.335	19.41	3064617.0
2018-12-18	ABBV	Stock	85.46	85.5	82.8	83.58	5288600.0
2018-12-18	ABC-DELISTED	Stock	77.46	78.6	75.42	76.24	1061739.0
2018-12-18	ABCB	Stock	31.61	32.45	31.15	32.16	1413600.0
2018-12-18	ABDC-DELISTED	Stock	6.46	6.55	6.45	6.47	130812.0
2018-12-18	ABEO	Stock	185.75	187.25	171.5	179.75	32020.0
2018-12-18	ABEV	Stock	4.07	4.07	4.0	4.01	15147100.0
2018-12-18	ABG	Stock	67.53	68.15	66.36	66.38	283500.0
2018-12-18	ABIL-DELISTED	Stock	2.29	2.3702	2.17	2.29	212179.0
2018-12-18	ABM	Stock	26.24	27.24	26.21	27.06	949900.0
2018-12-18	ABMD-DELISTED	Stock	305.11	306.75	299.14	304.8	389535.0
2018-12-18	ABR	Stock	10.95	11.2	10.62	10.85	1781500.0
2018-12-18	ABR.A-DELISTED	Stock	25.06	25.06	24.0	24.6879	6796.0
2018-12-18	ABR.B-DELISTED	Stock	25.22	25.22	24.44	25.0218	2321.0
2018-12-18	ABR.C-DELISTED	Stock	25.27	25.4265	24.0	24.81	9620.0
2018-12-18	ABT	Stock	70.85	70.9	69.31	70.08	8392400.0

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

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