PREVIEW / stock_daily / 2018-01-25

all stock daily files

  file:    by_date/stock_daily/2018/2018-01-25.parquet
  size:    217 KB
  rows:    6,473
  symbols: 2,858

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-01-25	AAPL	Stock	43.6275	43.7375	42.6325	42.7775	166116000.0
2018-01-25	MSFT	Stock	92.47	93.24	91.93	92.33	26383200.0
2018-01-25	NVDA	Stock	5.95	5.9938	5.8938	5.9088	409884000.0
2018-01-25	AMZN	Stock	68.4	68.917	67.881	68.8975	95060000.0
2018-01-25	GOOGL	Stock	59.0355	59.25	58.592	59.107	29984940.0
2018-01-25	META	Stock	187.95	188.62	186.6	187.48	17377700.0
2018-01-25	TSLA	Stock	23.218	23.28	22.4267	22.5093	101104500.0
2018-01-25	TLT	Stock	123.16	124.15	122.8	124.05	12173297.0
2018-01-25	ES	Stock	61.17	64.88	61.08	64.57	6160700.0
2018-01-25	CL	Stock	77.07	77.36	76.62	77.31	4236300.0
2018-01-25	A	Stock	74.17	74.49	73.65	73.86	1664100.0
2018-01-25	AA	Stock	53.74	53.89	52.72	53.11	3762700.0
2018-01-25	AAAP-DELISTED	Stock	82.13	82.28	81.775	81.95	66000.0
2018-01-25	AABA-DELISTED	Stock	78.21	78.99	77.32	78.61	6593753.0
2018-01-25	AAC-DELISTED	Stock	9.0	9.06	8.9	9.05	194206.0
2018-01-25	AACG	Stock	5.25	5.58	5.21	5.21	2100.0
2018-01-25	AAIC-DELISTED	Stock	11.6	11.62	11.29	11.34	840614.0
2018-01-25	AAL	Stock	54.0	54.55	52.21	53.05	10223100.0
2018-01-25	AAM.A-DELISTED	Stock	25.44	25.44	25.3	25.4294	23684.0
2018-01-25	AAME	Stock	3.35	3.6	3.35	3.6	400.0
2018-01-25	AAMI	Stock	18.49	18.537	18.09	18.17	396900.0
2018-01-25	AAOI	Stock	34.32	35.11	34.09	35.1	627600.0
2018-01-25	AAON	Stock	24.0667	24.1333	23.9	24.0333	264000.0
2018-01-25	AAP	Stock	121.12	121.34	119.63	120.92	1250700.0
2018-01-25	AAT	Stock	36.24	36.42	35.83	36.19	187600.0
2018-01-25	AAU-DELISTED	Stock	0.92	0.95	0.905	0.93	150469.0
2018-01-25	AAUAF-DELISTED	Stock	0.92	0.95	0.905	0.93	158860.0
2018-01-25	AAV-DELISTED	Stock	3.65	3.65	3.475	3.575	304387.0
2018-01-25	AAWW-DELISTED	Stock	61.1	61.4	58.95	59.05	162002.0
2018-01-25	AAXJ	Stock	82.47	82.82	81.98	82.25	881924.0
2018-01-25	AAXN-DELISTED	Stock	27.31	27.52	27.01	27.515	266407.0
2018-01-25	AB	Stock	27.4	27.6	27.2	27.45	147600.0
2018-01-25	ABAC-DELISTED	Stock	2.83	2.92	2.83	2.91	4419.0
2018-01-25	ABAX-DELISTED	Stock	65.67	66.75	63.89	64.25	225574.0
2018-01-25	ABB-DELISTED	Stock	28.58	28.62	28.1969	28.29	1508475.0
2018-01-25	ABBNY-DELISTED	Stock	28.58	28.62	28.1969	28.28	1968441.0
2018-01-25	ABBV	Stock	105.95	108.37	105.74	108.3	6327500.0
2018-01-25	ABC-DELISTED	Stock	104.67	104.67	103.435	104.37	780499.0
2018-01-25	ABCB	Stock	53.95	53.95	53.1	53.45	282200.0
2018-01-25	ABCD-DELISTED	Stock	6.8	7.29	6.8	7.18	140784.0
2018-01-25	ABDC-DELISTED	Stock	8.25	8.35	8.2145	8.27	31422.0
2018-01-25	ABE-DELISTED	Stock	15.59	15.68	15.55	15.57	17811.0
2018-01-25	ABEO	Stock	390.0	427.5	377.5	425.0	53700.0
2018-01-25	ABEOW-DELISTED	Stock	10.66	12.0	6.09	11.95	4460.0
2018-01-25	ABEV	Stock	6.9	7.0	6.82	6.82	21436900.0
2018-01-25	ABG	Stock	76.35	76.35	74.5	75.15	209000.0
2018-01-25	ABIL-DELISTED	Stock	0.4871	0.4988	0.45	0.45	69450.0
2018-01-25	ABLX-DELISTED	Stock	44.48	45.175	44.4418	44.75	77827.0
2018-01-25	ABM	Stock	39.48	39.76	38.77	39.4	453000.0
2018-01-25	ABMD-DELISTED	Stock	234.0	237.4	232.931	236.36	178621.0

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

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