PREVIEW / stock_daily / 2019-03-20

all stock daily files

  file:    by_date/stock_daily/2019/2019-03-20.parquet
  size:    220 KB
  rows:    6,504
  symbols: 2,598

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-03-20	AAPL	Stock	46.5575	47.3725	46.1825	47.04	124140800.0
2019-03-20	MSFT	Stock	117.39	118.75	116.71	117.52	28113300.0
2019-03-20	NVDA	Stock	4.422	4.4758	4.325	4.36	719148000.0
2019-03-20	AMZN	Stock	88.497	89.975	88.3515	89.8635	125312000.0
2019-03-20	GOOGL	Stock	60.07	61.4995	59.9795	61.3215	41508840.0
2019-03-20	META	Stock	161.5	166.12	161.24	165.44	20211500.0
2019-03-20	TSLA	Stock	17.9793	18.3313	17.7533	18.24	103623000.0
2019-03-20	TLT	Stock	121.74	122.85	121.73	122.68	10123663.0
2019-03-20	ES	Stock	70.66	70.89	70.0	70.22	2145900.0
2019-03-20	CL	Stock	65.88	65.88	64.89	65.11	3788900.0
2019-03-20	A	Stock	81.28	81.44	80.25	80.92	1768300.0
2019-03-20	AA	Stock	28.5	29.12	27.69	28.79	3381800.0
2019-03-20	AABA-DELISTED	Stock	73.67	74.0	72.88	73.76	6209255.0
2019-03-20	AAC-DELISTED	Stock	2.4	2.48	2.29	2.315	281663.0
2019-03-20	AACG	Stock	1.04	1.04	1.0	1.01	41000.0
2019-03-20	AAIC-DELISTED	Stock	8.41	8.41	8.12	8.19	1023473.0
2019-03-20	AAIC.C-DELISTED	Stock	24.0	24.49	23.36	24.49	15875.0
2019-03-20	AAL	Stock	31.5	31.55	30.77	30.96	6250200.0
2019-03-20	AAM.A-DELISTED	Stock	25.01	25.0799	25.0	25.04	26990.0
2019-03-20	AAM.B-DELISTED	Stock	24.94	24.94	24.74	24.83	29864.0
2019-03-20	AAMC-DELISTED	Stock	10.5882	10.5882	10.5882	10.5882	1040.0
2019-03-20	AAME	Stock	2.9	2.9	2.9	2.9	1300.0
2019-03-20	AAMI	Stock	13.59	13.63	13.29	13.32	336100.0
2019-03-20	AAOI	Stock	13.82	13.94	13.29	13.44	456800.0
2019-03-20	AAON	Stock	28.54	29.1267	28.2733	28.5467	244650.0
2019-03-20	AAP	Stock	164.51	165.62	162.59	164.15	875200.0
2019-03-20	AAT	Stock	45.08	45.52	44.9	44.97	459700.0
2019-03-20	AAU-DELISTED	Stock	0.6	0.6182	0.5855	0.6112	95047.0
2019-03-20	AAUAF-DELISTED	Stock	0.6	0.6182	0.5855	0.6112	100359.0
2019-03-20	AAWW-DELISTED	Stock	48.7	49.39	47.33	47.95	235560.0
2019-03-20	AAXJ	Stock	70.79	71.5425	70.34	71.05	1285963.0
2019-03-20	AAXN-DELISTED	Stock	52.26	53.06	50.86	52.65	581645.0
2019-03-20	AB	Stock	29.07	29.16	28.75	28.84	214400.0
2019-03-20	ABB-DELISTED	Stock	19.47	19.6	19.345	19.48	2009678.0
2019-03-20	ABBNY-DELISTED	Stock	19.47	19.6	19.345	19.48	2088078.0
2019-03-20	ABBV	Stock	80.72	80.91	80.06	80.43	5360900.0
2019-03-20	ABC-DELISTED	Stock	80.89	80.89	79.26	79.28	778813.0
2019-03-20	ABCB	Stock	37.01	37.2	35.31	35.37	496500.0
2019-03-20	ABDC-DELISTED	Stock	7.63	7.73	7.57	7.7	22041.0
2019-03-20	ABEO	Stock	198.0	203.25	191.75	196.5	14260.0
2019-03-20	ABEV	Stock	4.49	4.59	4.45	4.51	23984300.0
2019-03-20	ABG	Stock	68.34	69.34	67.92	68.08	134900.0
2019-03-20	ABIL-DELISTED	Stock	1.95	1.97	1.88	1.91	62662.0
2019-03-20	ABM	Stock	34.91	35.07	34.21	34.57	481700.0
2019-03-20	ABMD-DELISTED	Stock	337.9	344.69	337.9	339.86	294427.0
2019-03-20	ABR	Stock	12.83	12.89	12.72	12.72	649800.0
2019-03-20	ABR.A-DELISTED	Stock	25.73	25.73	25.7016	25.7016	310.0
2019-03-20	ABR.C-DELISTED	Stock	25.84	25.89	25.84	25.89	1000.0
2019-03-20	ABT	Stock	79.87	80.43	79.11	79.94	5388800.0
2019-03-20	ABTC	Stock	304500.0	304500.0	300900.0	302400.0	0.5333333333333333

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

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