PREVIEW / stock_daily / 2018-04-10

all stock daily files

  file:    by_date/stock_daily/2018/2018-04-10.parquet
  size:    216 KB
  rows:    6,499
  symbols: 2,835

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-04-10	AAPL	Stock	43.25	43.5	42.8825	43.3125	113634400.0
2018-04-10	MSFT	Stock	92.39	93.28	91.64	92.88	26812000.0
2018-04-10	NVDA	Stock	5.618	5.725	5.5602	5.6978	761676000.0
2018-04-10	AMZN	Stock	71.5995	71.919	70.785	71.811	85082000.0
2018-04-10	GOOGL	Stock	51.513	52.0605	50.7705	51.825	36733560.0
2018-04-10	META	Stock	157.93	165.98	157.01	165.04	57889300.0
2018-04-10	TSLA	Stock	19.9313	20.4733	19.5787	20.3133	164847000.0
2018-04-10	TLT	Stock	121.2	121.38	120.78	121.08	6048601.0
2018-04-10	ES	Stock	59.89	59.9	59.25	59.31	1565400.0
2018-04-10	CL	Stock	71.61	72.01	71.17	71.73	2901800.0
2018-04-10	A	Stock	66.14	66.79	65.9	66.64	1872800.0
2018-04-10	AA	Stock	51.8	55.18	51.65	54.08	8948800.0
2018-04-10	AABA-DELISTED	Stock	70.18	71.0772	69.82	70.8	7997460.0
2018-04-10	AAC-DELISTED	Stock	11.58	11.73	11.3	11.35	84130.0
2018-04-10	AACG	Stock	5.34	5.47	5.34	5.41	15100.0
2018-04-10	AAIC-DELISTED	Stock	11.35	11.4062	11.28	11.29	551950.0
2018-04-10	AAL	Stock	50.52	50.57	47.21	47.46	12805000.0
2018-04-10	AAM.A-DELISTED	Stock	24.87	24.98	24.85	24.85	19698.0
2018-04-10	AAM.B-DELISTED	Stock	24.86	24.87	24.76	24.79	236783.0
2018-04-10	AAME	Stock	3.25	3.25	3.25	3.25	600.0
2018-04-10	AAMI	Stock	15.06	15.08	14.93	14.95	484400.0
2018-04-10	AAOI	Stock	24.51	26.078	24.509	25.43	684800.0
2018-04-10	AAON	Stock	23.0	23.1333	22.8333	23.0333	174600.0
2018-04-10	AAP	Stock	111.14	112.68	109.53	112.14	926800.0
2018-04-10	AAT	Stock	34.16	34.24	33.9	34.1	182300.0
2018-04-10	AAU-DELISTED	Stock	0.8	0.82	0.7865	0.8099	381518.0
2018-04-10	AAUAF-DELISTED	Stock	0.8	0.82	0.7865	0.8099	385019.0
2018-04-10	AAV-DELISTED	Stock	3.15	3.35	3.15	3.34	730805.0
2018-04-10	AAWW-DELISTED	Stock	60.9	62.65	60.9	62.15	148484.0
2018-04-10	AAXJ	Stock	77.43	77.91	77.14	77.81	802495.0
2018-04-10	AAXN-DELISTED	Stock	41.62	42.3	41.38	42.1	651857.0
2018-04-10	AB	Stock	27.0	27.15	26.75	27.05	487900.0
2018-04-10	ABAC-DELISTED	Stock	2.72	2.7236	2.69	2.7	15677.0
2018-04-10	ABAX-DELISTED	Stock	70.35	71.75	69.58	71.06	78051.0
2018-04-10	ABB-DELISTED	Stock	23.12	23.13	22.87	22.965	1359398.0
2018-04-10	ABBNY-DELISTED	Stock	23.12	23.13	22.87	22.97	4469634.0
2018-04-10	ABBV	Stock	91.5	94.39	90.93	93.62	6253700.0
2018-04-10	ABC-DELISTED	Stock	87.62	89.47	87.35	88.92	993053.0
2018-04-10	ABCB	Stock	52.6	53.28	51.8	53.0	427900.0
2018-04-10	ABCD-DELISTED	Stock	11.2	11.44	10.62	11.235	252841.0
2018-04-10	ABDC-DELISTED	Stock	7.1	7.1778	6.99	7.0	39613.0
2018-04-10	ABE-DELISTED	Stock	14.89	14.8999	14.77	14.83	6244.0
2018-04-10	ABEO	Stock	418.75	447.5	401.25	443.75	66864.0
2018-04-10	ABEOW-DELISTED	Stock	11.08	11.9225	11.08	11.9225	1700.0
2018-04-10	ABEV	Stock	6.8	6.96	6.77	6.94	32378500.0
2018-04-10	ABG	Stock	65.95	68.35	65.87	68.0	217900.0
2018-04-10	ABIL-DELISTED	Stock	3.02	3.19	2.86	3.0	16635.0
2018-04-10	ABLX-DELISTED	Stock	54.93	54.97	54.8	54.87	132857.0
2018-04-10	ABM	Stock	32.5	32.87	32.35	32.52	411800.0
2018-04-10	ABMD-DELISTED	Stock	292.6	301.17	290.26	300.13	444592.0

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

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