PREVIEW / stock_daily / 2019-04-04

all stock daily files

  file:    by_date/stock_daily/2019/2019-04-04.parquet
  size:    220 KB
  rows:    6,522
  symbols: 2,592

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-04-04	AAPL	Stock	48.6975	49.0925	48.285	48.9225	76457200.0
2019-04-04	MSFT	Stock	120.1	120.23	118.38	119.36	20112800.0
2019-04-04	NVDA	Stock	4.7	4.7492	4.6432	4.7065	457376000.0
2019-04-04	AMZN	Stock	91.0325	91.4375	90.21	90.943	72478000.0
2019-04-04	GOOGL	Stock	60.5645	61.0275	60.452	60.9725	21021780.0
2019-04-04	META	Stock	176.02	178.0	175.53	176.02	17847700.0
2019-04-04	TSLA	Stock	17.4593	18.08	17.3727	17.852	355810500.0
2019-04-04	TLT	Stock	123.6	123.89	123.44	123.87	7503361.0
2019-04-04	ES	Stock	70.96	70.96	70.02	70.36	1576900.0
2019-04-04	CL	Stock	68.0	68.0	67.25	67.55	2541700.0
2019-04-04	A	Stock	81.84	82.05	80.44	80.83	2180100.0
2019-04-04	AA	Stock	28.6	29.34	28.38	29.29	2654500.0
2019-04-04	AABA-DELISTED	Stock	72.0	73.69	71.97	73.25	9764717.0
2019-04-04	AAC-DELISTED	Stock	2.06	2.06	1.97	1.99	82864.0
2019-04-04	AACG	Stock	1.01	1.06	0.99	1.0	225800.0
2019-04-04	AAIC-DELISTED	Stock	7.83	7.9	7.82	7.83	299520.0
2019-04-04	AAIC.C-DELISTED	Stock	23.35	23.81	23.3	23.8	18316.0
2019-04-04	AAL	Stock	33.96	34.12	33.35	33.93	6192300.0
2019-04-04	AAM.A-DELISTED	Stock	24.79	24.8158	24.67	24.8	33239.0
2019-04-04	AAM.B-DELISTED	Stock	24.6	24.7	24.58	24.7	48920.0
2019-04-04	AAMC-DELISTED	Stock	9.0882	9.0882	8.3853	8.8235	10373.0
2019-04-04	AAME	Stock	2.61	2.66	2.56	2.65	6200.0
2019-04-04	AAMI	Stock	13.86	14.01	13.832	14.01	524300.0
2019-04-04	AAOI	Stock	12.42	12.93	12.42	12.75	716200.0
2019-04-04	AAON	Stock	30.4933	30.8667	30.3067	30.56	172050.0
2019-04-04	AAP	Stock	172.14	174.41	171.58	174.0	1213800.0
2019-04-04	AAT	Stock	46.47	46.57	46.08	46.41	214600.0
2019-04-04	AAU-DELISTED	Stock	0.57	0.586	0.57	0.572	135552.0
2019-04-04	AAUAF-DELISTED	Stock	0.57	0.586	0.57	0.5767	143596.0
2019-04-04	AAWW-DELISTED	Stock	50.54	51.46	50.03	50.86	250591.0
2019-04-04	AAXJ	Stock	72.26	72.74	72.18	72.61	3520488.0
2019-04-04	AAXN-DELISTED	Stock	55.42	56.27	54.75	55.1	307068.0
2019-04-04	AB	Stock	29.17	29.41	29.0	29.35	153200.0
2019-04-04	ABB-DELISTED	Stock	19.66	19.71	19.62	19.655	1538863.0
2019-04-04	ABBNY-DELISTED	Stock	19.66	19.71	19.62	19.65	1712661.0
2019-04-04	ABBV	Stock	83.04	83.38	82.07	82.81	4827900.0
2019-04-04	ABC-DELISTED	Stock	75.27	76.12	74.2834	75.98	1274193.0
2019-04-04	ABCB	Stock	35.0	36.0	35.0	35.66	218200.0
2019-04-04	ABDC-DELISTED	Stock	7.52	7.66	7.5	7.59	41772.0
2019-04-04	ABEO	Stock	196.25	202.5	189.0	190.75	21412.0
2019-04-04	ABEV	Stock	4.36	4.51	4.36	4.5	20331500.0
2019-04-04	ABG	Stock	71.31	72.93	71.0	72.83	147900.0
2019-04-04	ABIL-DELISTED	Stock	1.65	1.7	1.63	1.67	53007.0
2019-04-04	ABM	Stock	37.04	37.47	36.56	36.83	368600.0
2019-04-04	ABMD-DELISTED	Stock	284.4	286.91	277.645	282.74	527337.0
2019-04-04	ABR	Stock	13.32	13.46	13.31	13.46	786600.0
2019-04-04	ABR.A-DELISTED	Stock	25.78	25.78	25.66	25.77	7546.0
2019-04-04	ABR.B-DELISTED	Stock	25.64	25.7	25.49	25.5172	1350.0
2019-04-04	ABR.C-DELISTED	Stock	26.1194	26.1956	26.0	26.1956	866.0
2019-04-04	ABT	Stock	79.47	79.51	78.0	78.62	4671200.0

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

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