PREVIEW / stock_daily / 2018-10-01

all stock daily files

  file:    by_date/stock_daily/2018/2018-10-01.parquet
  size:    221 KB
  rows:    6,562
  symbols: 2,749

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-10-01	AAPL	Stock	56.9875	57.355	56.5875	56.815	94403200.0
2018-10-01	MSFT	Stock	114.75	115.68	114.73	115.61	18883100.0
2018-10-01	NVDA	Stock	7.104	7.3015	7.065	7.234	622060000.0
2018-10-01	AMZN	Stock	101.0995	101.6595	100.18	100.218	69210000.0
2018-10-01	GOOGL	Stock	60.65	61.21	60.1595	60.4265	33187280.0
2018-10-01	META	Stock	163.03	165.88	161.26	162.44	26407700.0
2018-10-01	TSLA	Stock	20.3847	20.7627	20.07	20.7133	326664000.0
2018-10-01	TLT	Stock	116.66	116.83	116.12	116.15	22442374.0
2018-10-01	ES	Stock	61.27	61.6	61.08	61.52	922500.0
2018-10-01	CL	Stock	66.96	67.31	66.89	67.07	2116300.0
2018-10-01	A	Stock	70.68	71.58	70.65	71.26	2837500.0
2018-10-01	AA	Stock	40.75	40.96	39.88	40.86	3624900.0
2018-10-01	AABA-DELISTED	Stock	68.54	68.7	67.12	67.15	4330148.0
2018-10-01	AAC-DELISTED	Stock	7.69	7.99	7.4	7.42	106223.0
2018-10-01	AACG	Stock	1.05	1.07	0.95	0.97	85400.0
2018-10-01	AAIC-DELISTED	Stock	9.35	9.3889	9.05	9.2	853105.0
2018-10-01	AAL	Stock	41.41	41.75	39.6	39.61	7210700.0
2018-10-01	AAM.A-DELISTED	Stock	25.17	25.17	24.83	24.83	28715.0
2018-10-01	AAM.B-DELISTED	Stock	24.84	24.91	24.6	24.61	138025.0
2018-10-01	AAMC-DELISTED	Stock	16.9853	17.6324	16.7647	17.0941	14035.0
2018-10-01	AAME	Stock	2.55	2.6	2.4	2.6	2400.0
2018-10-01	AAMI	Stock	12.42	12.53	12.295	12.3	445200.0
2018-10-01	AAOI	Stock	25.37	25.48	23.93	24.0	2171000.0
2018-10-01	AAON	Stock	25.3133	25.4	24.2467	24.3467	252900.0
2018-10-01	AAP	Stock	169.02	170.64	168.19	169.6	591600.0
2018-10-01	AAT	Stock	37.33	37.37	36.9	36.96	345300.0
2018-10-01	AAU-DELISTED	Stock	0.612	0.6536	0.55	0.5939	301708.0
2018-10-01	AAUAF-DELISTED	Stock	0.612	0.6536	0.55	0.5939	304759.0
2018-10-01	AAWW-DELISTED	Stock	63.99	64.47	61.73	61.94	115560.0
2018-10-01	AAXJ	Stock	70.93	70.93	70.33	70.46	1649467.0
2018-10-01	AAXN-DELISTED	Stock	68.61	69.82	66.5813	66.79	278616.0
2018-10-01	AB	Stock	30.55	31.18	30.42	30.69	236300.0
2018-10-01	ABAC-DELISTED	Stock	2.04	2.14	1.86	1.87	43031.0
2018-10-01	ABB-DELISTED	Stock	23.44	23.52	23.35	23.42	1576670.0
2018-10-01	ABBNY-DELISTED	Stock	23.44	23.52	23.35	23.42	1759638.0
2018-10-01	ABBV	Stock	94.74	95.64	94.33	95.0	3763800.0
2018-10-01	ABC-DELISTED	Stock	92.75	93.94	92.3	92.79	1037599.0
2018-10-01	ABCB	Stock	45.94	46.21	44.85	44.91	198700.0
2018-10-01	ABCD-DELISTED	Stock	11.81	11.915	11.54	11.68	82043.0
2018-10-01	ABDC-DELISTED	Stock	6.01	6.05	5.98	6.05	129606.0
2018-10-01	ABEO	Stock	320.25	325.5	313.5	314.0	19080.0
2018-10-01	ABEV	Stock	4.59	4.63	4.57	4.61	15052500.0
2018-10-01	ABG	Stock	69.15	69.78	67.9	68.26	223700.0
2018-10-01	ABIL-DELISTED	Stock	3.5	3.5	3.36	3.399	71622.0
2018-10-01	ABM	Stock	32.44	32.59	32.08	32.12	1075600.0
2018-10-01	ABMD-DELISTED	Stock	452.9	459.75	442.9259	444.22	373455.0
2018-10-01	ABR	Stock	11.5	11.56	11.37	11.4	876800.0
2018-10-01	ABR.A-DELISTED	Stock	25.66	25.66	25.46	25.5404	2136.0
2018-10-01	ABR.B-DELISTED	Stock	25.64	25.6778	25.59	25.59	640.0
2018-10-01	ABR.C-DELISTED	Stock	26.0136	26.0576	26.0136	26.0576	2195.0

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

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