PREVIEW / stock_daily / 2018-09-25

all stock daily files

  file:    by_date/stock_daily/2018/2018-09-25.parquet
  size:    219 KB
  rows:    6,531
  symbols: 2,739

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-09-25	AAPL	Stock	54.9375	55.705	54.925	55.5475	98217600.0
2018-09-25	MSFT	Stock	114.8	115.1	113.75	114.45	22668000.0
2018-09-25	NVDA	Stock	6.7093	6.7355	6.6228	6.7103	280388000.0
2018-09-25	AMZN	Stock	97.145	98.7955	96.9425	98.7275	90768000.0
2018-09-25	GOOGL	Stock	59.2125	59.843	58.7045	59.6945	33156180.0
2018-09-25	META	Stock	161.99	165.59	161.15	164.91	27622800.0
2018-09-25	TSLA	Stock	20.0	20.3067	19.7667	20.066	67225500.0
2018-09-25	TLT	Stock	116.48	116.74	116.4	116.68	6650853.0
2018-09-25	ES	Stock	61.47	61.55	60.42	60.68	1484400.0
2018-09-25	CL	Stock	68.14	68.2	67.08	67.14	2347700.0
2018-09-25	A	Stock	70.17	70.83	69.91	70.38	2090200.0
2018-09-25	AA	Stock	41.65	41.94	40.6	41.24	5152100.0
2018-09-25	AABA-DELISTED	Stock	67.62	68.45	67.51	67.89	10415481.0
2018-09-25	AAC-DELISTED	Stock	7.25	7.4	7.2	7.26	102882.0
2018-09-25	AACG	Stock	1.04	1.13	1.04	1.12	78900.0
2018-09-25	AAIC-DELISTED	Stock	10.12	10.18	10.06	10.06	335603.0
2018-09-25	AAL	Stock	42.0	42.19	40.27	40.81	6744200.0
2018-09-25	AAM.A-DELISTED	Stock	25.1125	25.14	24.92	24.92	31102.0
2018-09-25	AAM.B-DELISTED	Stock	24.82	24.82	24.61	24.63	56102.0
2018-09-25	AAME	Stock	2.59	2.59	2.35	2.55	1400.0
2018-09-25	AAMI	Stock	12.76	12.79	12.56	12.6	449500.0
2018-09-25	AAOI	Stock	33.327	33.79	32.669	33.56	738100.0
2018-09-25	AAON	Stock	26.2	26.2	25.7333	25.8667	254850.0
2018-09-25	AAP	Stock	168.0	168.43	165.74	167.32	691800.0
2018-09-25	AAT	Stock	36.84	37.38	36.76	37.23	106900.0
2018-09-25	AAU-DELISTED	Stock	0.62	0.65	0.6199	0.6446	154837.0
2018-09-25	AAUAF-DELISTED	Stock	0.62	0.65	0.6199	0.6459	157267.0
2018-09-25	AAWW-DELISTED	Stock	62.45	62.8	61.9	62.6	336522.0
2018-09-25	AAXJ	Stock	70.68	70.845	70.5801	70.69	485113.0
2018-09-25	AAXN-DELISTED	Stock	63.91	67.34	63.83	66.94	557639.0
2018-09-25	AB	Stock	30.35	30.6	30.35	30.45	134600.0
2018-09-25	ABAC-DELISTED	Stock	2.11	2.15	2.07	2.08	34314.0
2018-09-25	ABB-DELISTED	Stock	23.9	23.99	23.81	23.825	1395507.0
2018-09-25	ABBNY-DELISTED	Stock	23.9	23.99	23.81	23.83	1444617.0
2018-09-25	ABBV	Stock	93.48	94.64	93.4	93.78	5303900.0
2018-09-25	ABC-DELISTED	Stock	89.68	90.58	89.43	89.53	757174.0
2018-09-25	ABCB	Stock	47.4	47.5	47.0	47.05	225400.0
2018-09-25	ABCD-DELISTED	Stock	11.91	11.97	11.7424	11.84	104531.0
2018-09-25	ABDC-DELISTED	Stock	6.34	6.34	6.18	6.2201	49669.0
2018-09-25	ABEO	Stock	342.5	350.0	339.0	343.75	22452.0
2018-09-25	ABEV	Stock	4.41	4.54	4.41	4.53	25465600.0
2018-09-25	ABG	Stock	71.2	71.2	69.6	70.15	316300.0
2018-09-25	ABIL-DELISTED	Stock	3.86	3.9776	3.6325	3.72	236221.0
2018-09-25	ABM	Stock	33.19	33.49	33.06	33.43	329100.0
2018-09-25	ABMD-DELISTED	Stock	420.0	445.695	419.06	441.52	913166.0
2018-09-25	ABR	Stock	11.5	11.54	11.45	11.46	913800.0
2018-09-25	ABR.A-DELISTED	Stock	25.53	25.65	25.2501	25.5332	6118.0
2018-09-25	ABR.C-DELISTED	Stock	26.15	26.34	26.0	26.34	1618.0
2018-09-25	ABT	Stock	71.74	72.23	71.41	72.2	8257300.0
2018-09-25	ABTS	Stock	64.5	64.5	57.0	57.0	801.0

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

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