PREVIEW / stock_daily / 2019-04-02

all stock daily files

  file:    by_date/stock_daily/2019/2019-04-02.parquet
  size:    221 KB
  rows:    6,546
  symbols: 2,603

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-02	AAPL	Stock	47.7725	48.615	47.7625	48.505	91062800.0
2019-04-02	MSFT	Stock	119.06	119.48	118.52	119.19	18142300.0
2019-04-02	NVDA	Stock	4.5812	4.6198	4.538	4.575	440920000.0
2019-04-02	AMZN	Stock	90.551	91.0	90.256	90.699	68962000.0
2019-04-02	GOOGL	Stock	60.0025	60.2905	59.562	60.277	18288260.0
2019-04-02	META	Stock	170.14	174.9	169.55	174.2	23946500.0
2019-04-02	TSLA	Stock	19.22	19.296	18.9253	19.0587	82183500.0
2019-04-02	TLT	Stock	124.48	124.7369	124.245	124.6	9725032.0
2019-04-02	ES	Stock	70.96	70.96	70.29	70.73	1440100.0
2019-04-02	CL	Stock	68.21	68.68	67.79	68.37	3130000.0
2019-04-02	A	Stock	81.71	81.76	81.03	81.14	1203000.0
2019-04-02	AA	Stock	29.13	29.29	28.18	28.54	3838800.0
2019-04-02	AABA-DELISTED	Stock	73.58	74.55	73.5	73.94	2832764.0
2019-04-02	AAC-DELISTED	Stock	2.12	2.12	1.8801	2.0	172032.0
2019-04-02	AACG	Stock	1.01	1.01	0.98	1.0	12100.0
2019-04-02	AAIC-DELISTED	Stock	7.96	7.96	7.85	7.86	513013.0
2019-04-02	AAIC.C-DELISTED	Stock	23.4	23.45	23.16	23.25	9327.0
2019-04-02	AAL	Stock	33.04	33.47	32.46	32.99	10406100.0
2019-04-02	AAM.A-DELISTED	Stock	25.02	25.059	24.87	24.94	106507.0
2019-04-02	AAM.B-DELISTED	Stock	24.74	24.8199	24.701	24.75	40002.0
2019-04-02	AAMC-DELISTED	Stock	8.9765	9.0294	8.6765	8.8235	63662.0
2019-04-02	AAME	Stock	2.58	2.7	2.54	2.59	20000.0
2019-04-02	AAMI	Stock	13.81	13.84	13.635	13.72	310500.0
2019-04-02	AAOI	Stock	12.65	12.74	12.13	12.13	644600.0
2019-04-02	AAON	Stock	30.9	30.92	30.1933	30.22	207600.0
2019-04-02	AAP	Stock	173.54	173.94	170.93	173.34	670600.0
2019-04-02	AAT	Stock	46.37	46.44	45.61	46.4	251300.0
2019-04-02	AAU-DELISTED	Stock	0.5935	0.5993	0.576	0.5772	122544.0
2019-04-02	AAUAF-DELISTED	Stock	0.5935	0.5993	0.576	0.5772	131637.0
2019-04-02	AAWW-DELISTED	Stock	51.6	51.64	50.1	50.5	279400.0
2019-04-02	AAXJ	Stock	71.77	71.8	71.43	71.59	1608171.0
2019-04-02	AAXN-DELISTED	Stock	55.44	55.59	54.32	54.38	358295.0
2019-04-02	AB	Stock	29.2	29.21	28.66	28.79	135700.0
2019-04-02	ABB-DELISTED	Stock	19.31	19.315	19.19	19.27	1788867.0
2019-04-02	ABBNY-DELISTED	Stock	19.31	19.315	19.19	19.26	1910070.0
2019-04-02	ABBV	Stock	80.89	83.49	80.8	83.07	6355800.0
2019-04-02	ABC-DELISTED	Stock	76.88	77.05	74.41	74.5	2007162.0
2019-04-02	ABCB	Stock	35.35	35.71	35.03	35.07	180400.0
2019-04-02	ABDC-DELISTED	Stock	7.58	7.59	7.46	7.5	36006.0
2019-04-02	ABEO	Stock	183.5	189.0	182.5	186.75	6944.0
2019-04-02	ABEV	Stock	4.39	4.43	4.32	4.35	26246200.0
2019-04-02	ABG	Stock	71.1	71.15	69.64	70.22	158200.0
2019-04-02	ABIL-DELISTED	Stock	1.68	1.71	1.6593	1.69	71371.0
2019-04-02	ABM	Stock	37.03	37.4	36.81	37.38	325900.0
2019-04-02	ABMD-DELISTED	Stock	277.77	284.9847	275.53	284.24	401474.0
2019-04-02	ABR	Stock	13.08	13.25	13.03	13.24	868300.0
2019-04-02	ABR.A-DELISTED	Stock	25.9399	25.9399	25.8	25.8001	1952.0
2019-04-02	ABR.B-DELISTED	Stock	25.5	25.6311	25.425	25.55	3855.0
2019-04-02	ABR.C-DELISTED	Stock	26.0479	26.0479	26.0	26.0	1635.0
2019-04-02	ABT	Stock	79.83	79.83	79.07	79.62	3717900.0

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

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