PREVIEW / stock_daily / 2019-02-25

all stock daily files

  file:    by_date/stock_daily/2019/2019-02-25.parquet
  size:    220 KB
  rows:    6,523
  symbols: 2,619

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
2019-02-25	AAPL	Stock	43.54	43.9675	43.4875	43.5575	87493600.0
2019-02-25	MSFT	Stock	111.76	112.18	111.26	111.59	23750600.0
2019-02-25	NVDA	Stock	4.064	4.132	3.9585	3.9672	656020000.0
2019-02-25	AMZN	Stock	82.0725	82.73	81.5195	81.65	63690000.0
2019-02-25	GOOGL	Stock	56.0965	56.27	55.7055	55.8665	26207240.0
2019-02-25	META	Stock	163.07	166.07	162.9	164.62	18737100.0
2019-02-25	TSLA	Stock	19.8607	20.1933	19.8	19.918	99397500.0
2019-02-25	TLT	Stock	121.17	121.3	120.92	121.21	6293534.0
2019-02-25	ES	Stock	69.48	69.84	69.06	69.37	2706300.0
2019-02-25	CL	Stock	67.0	67.36	66.4	66.52	2939700.0
2019-02-25	A	Stock	78.9	79.84	78.85	79.34	1878000.0
2019-02-25	AA	Stock	30.47	30.87	30.39	30.78	3937600.0
2019-02-25	AABA-DELISTED	Stock	73.22	74.31	73.12	74.03	5403057.0
2019-02-25	AAC-DELISTED	Stock	2.98	3.16	2.98	3.09	220259.0
2019-02-25	AACG	Stock	1.1	1.21	1.09	1.1	648300.0
2019-02-25	AAIC-DELISTED	Stock	8.26	8.325	8.13	8.18	859106.0
2019-02-25	AAL	Stock	35.75	36.38	35.67	35.9	10905900.0
2019-02-25	AAM.A-DELISTED	Stock	24.98	25.05	24.94	25.05	38301.0
2019-02-25	AAM.B-DELISTED	Stock	24.689	24.7505	24.65	24.74	34105.0
2019-02-25	AAMC-DELISTED	Stock	11.4676	11.4735	11.1706	11.4706	10856.0
2019-02-25	AAME	Stock	2.91	2.91	2.79	2.79	1200.0
2019-02-25	AAMI	Stock	14.25	14.54	14.19	14.19	1072000.0
2019-02-25	AAOI	Stock	15.66	16.85	15.5	16.805	2073400.0
2019-02-25	AAON	Stock	28.1867	28.76	28.1667	28.1867	239850.0
2019-02-25	AAP	Stock	162.63	163.32	156.12	157.71	1787200.0
2019-02-25	AAT	Stock	43.98	43.99	43.39	43.39	147400.0
2019-02-25	AAU-DELISTED	Stock	0.7012	0.7072	0.678	0.678	428044.0
2019-02-25	AAUAF-DELISTED	Stock	0.7012	0.7072	0.6711	0.6711	434571.0
2019-02-25	AAWW-DELISTED	Stock	55.92	57.22	55.26	55.52	687467.0
2019-02-25	AAXJ	Stock	70.77	71.06	70.71	70.82	1042307.0
2019-02-25	AAXN-DELISTED	Stock	56.44	58.495	56.28	58.06	1209206.0
2019-02-25	AB	Stock	29.7	29.82	29.26	29.27	246400.0
2019-02-25	ABB-DELISTED	Stock	20.38	20.45	20.315	20.34	2387455.0
2019-02-25	ABBNY-DELISTED	Stock	20.38	20.45	20.315	20.34	2478993.0
2019-02-25	ABBV	Stock	80.46	80.62	79.88	80.29	5511800.0
2019-02-25	ABC-DELISTED	Stock	86.3	86.57	84.64	84.68	600073.0
2019-02-25	ABCB	Stock	41.62	42.01	41.55	41.55	499300.0
2019-02-25	ABDC-DELISTED	Stock	7.02	7.09	6.98	7.01	21500.0
2019-02-25	ABEO	Stock	169.25	186.0	165.75	183.25	41824.0
2019-02-25	ABEV	Stock	4.89	4.9	4.84	4.85	14976000.0
2019-02-25	ABG	Stock	70.69	71.26	70.12	70.78	219900.0
2019-02-25	ABIL-DELISTED	Stock	1.92	1.92	1.85	1.8835	73357.0
2019-02-25	ABM	Stock	37.05	37.34	36.53	36.55	422200.0
2019-02-25	ABMD-DELISTED	Stock	354.28	357.0	346.1656	352.51	252637.0
2019-02-25	ABR	Stock	13.08	13.19	12.92	13.06	1722200.0
2019-02-25	ABR.A-DELISTED	Stock	25.459	25.7	25.459	25.69	8604.0
2019-02-25	ABR.C-DELISTED	Stock	25.42	25.45	25.4134	25.45	2236.0
2019-02-25	ABT	Stock	76.39	77.05	76.24	76.86	5709600.0
2019-02-25	ABTC	Stock	304200.0	305100.0	303900.0	304350.0	0.3466666666666667
2019-02-25	ABTS	Stock	39.75	45.0	37.5	37.5	1620.0

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

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