PREVIEW / stock_daily / 2018-07-23

all stock daily files

  file:    by_date/stock_daily/2018/2018-07-23.parquet
  size:    218 KB
  rows:    6,480
  symbols: 2,760

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-07-23	AAPL	Stock	47.67	47.99	47.39	47.9025	63957600.0
2018-07-23	MSFT	Stock	106.3	108.14	106.13	107.97	29707000.0
2018-07-23	NVDA	Stock	6.2455	6.2472	6.082	6.2353	301584000.0
2018-07-23	AMZN	Stock	90.6105	90.95	88.4995	90.1	77770000.0
2018-07-23	GOOGL	Stock	59.783	60.755	59.6005	60.55	65446080.0
2018-07-23	META	Stock	210.58	211.62	208.8	210.91	16732000.0
2018-07-23	TSLA	Stock	20.1227	20.3667	19.524	20.2133	164893500.0
2018-07-23	TLT	Stock	120.38	120.38	119.18	119.27	11571846.0
2018-07-23	ES	Stock	58.76	58.88	58.14	58.46	1358900.0
2018-07-23	CL	Stock	65.96	66.14	65.54	65.84	5332400.0
2018-07-23	A	Stock	63.7	64.0	63.37	63.72	1417500.0
2018-07-23	AA	Stock	40.86	41.82	40.08	41.33	7709800.0
2018-07-23	AABA-DELISTED	Stock	73.1	73.45	72.31	73.17	4381481.0
2018-07-23	AAC-DELISTED	Stock	9.6	9.815	9.19	9.74	102223.0
2018-07-23	AACG	Stock	4.24	4.24	4.21	4.22	1600.0
2018-07-23	AAIC-DELISTED	Stock	10.0	10.09	9.91	10.06	796671.0
2018-07-23	AAL	Stock	37.65	38.22	37.36	38.04	4697300.0
2018-07-23	AAM.A-DELISTED	Stock	25.47	25.54	25.39	25.44	20725.0
2018-07-23	AAM.B-DELISTED	Stock	24.92	25.0	24.896	24.9	53728.0
2018-07-23	AAME	Stock	2.5	2.63	2.5	2.56	6800.0
2018-07-23	AAMI	Stock	13.77	14.14	13.77	14.0	502100.0
2018-07-23	AAOI	Stock	41.39	42.318	40.6	41.99	1080900.0
2018-07-23	AAON	Stock	24.4	24.5	24.2	24.3667	239700.0
2018-07-23	AAP	Stock	142.14	145.2	142.14	144.66	686100.0
2018-07-23	AAT	Stock	37.41	37.61	37.17	37.52	141100.0
2018-07-23	AAU-DELISTED	Stock	0.69	0.7099	0.68	0.694	162734.0
2018-07-23	AAUAF-DELISTED	Stock	0.69	0.7099	0.68	0.694	188100.0
2018-07-23	AAV-DELISTED	Stock	3.35	3.35	3.15	3.25	188839.0
2018-07-23	AAWW-DELISTED	Stock	68.75	69.05	68.25	68.55	148944.0
2018-07-23	AAXJ	Stock	71.69	71.69	71.33	71.51	2096714.0
2018-07-23	AAXN-DELISTED	Stock	73.6	75.18	73.1488	74.89	676028.0
2018-07-23	AB	Stock	30.1	30.48	29.95	30.25	683700.0
2018-07-23	ABAC-DELISTED	Stock	2.25	2.31	2.2	2.279	7731.0
2018-07-23	ABAX-DELISTED	Stock	83.26	83.26	83.06	83.15	168354.0
2018-07-23	ABB-DELISTED	Stock	22.35	22.38	22.27	22.33	1576155.0
2018-07-23	ABBNY-DELISTED	Stock	22.35	22.38	22.27	22.33	1712339.0
2018-07-23	ABBV	Stock	89.17	89.99	88.64	89.4	6316800.0
2018-07-23	ABC-DELISTED	Stock	84.5	85.72	84.5	84.77	556631.0
2018-07-23	ABCB	Stock	51.75	52.48	51.75	52.15	200000.0
2018-07-23	ABCD-DELISTED	Stock	12.1	12.4	11.99	12.19	124656.0
2018-07-23	ABDC-DELISTED	Stock	6.37	6.5	6.18	6.49	35184.0
2018-07-23	ABEO	Stock	357.5	362.5	342.5	346.25	19180.0
2018-07-23	ABEOW-DELISTED	Stock	9.0	9.0	9.0	9.0	150.0
2018-07-23	ABEV	Stock	4.93	4.96	4.87	4.9	22886800.0
2018-07-23	ABG	Stock	69.25	69.65	68.55	69.35	153800.0
2018-07-23	ABIL-DELISTED	Stock	5.04	5.4536	5.01	5.07	144838.0
2018-07-23	ABM	Stock	29.94	30.0	29.67	29.84	378800.0
2018-07-23	ABMD-DELISTED	Stock	423.5	431.66	418.21	430.9	349425.0
2018-07-23	ABR	Stock	11.31	11.4	11.18	11.27	1364500.0
2018-07-23	ABR.A-DELISTED	Stock	26.1046	26.1046	25.82	25.82	2220.0

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

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