PREVIEW / stock_daily / 2019-03-25

all stock daily files

  file:    by_date/stock_daily/2019/2019-03-25.parquet
  size:    219 KB
  rows:    6,528
  symbols: 2,602

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-25	AAPL	Stock	47.8775	47.995	46.65	47.185	175381200.0
2019-03-25	MSFT	Stock	116.56	118.01	116.32	117.66	27067100.0
2019-03-25	NVDA	Stock	4.3965	4.4612	4.2778	4.3445	525212000.0
2019-03-25	AMZN	Stock	87.8895	89.134	87.375	88.713	102076000.0
2019-03-25	GOOGL	Stock	59.978	60.472	59.5002	59.869	27576980.0
2019-03-25	META	Stock	163.0	166.54	162.0	166.29	12631200.0
2019-03-25	TSLA	Stock	17.314	17.5453	16.964	17.3613	153225000.0
2019-03-25	TLT	Stock	124.81	125.94	124.5099	125.06	9736593.0
2019-03-25	ES	Stock	71.72	71.99	71.4	71.77	1579600.0
2019-03-25	CL	Stock	65.91	66.47	65.83	66.26	2972600.0
2019-03-25	A	Stock	79.09	79.86	78.66	79.52	923000.0
2019-03-25	AA	Stock	28.12	28.56	27.77	28.02	2871100.0
2019-03-25	AABA-DELISTED	Stock	71.65	72.88	71.33	72.77	3293244.0
2019-03-25	AAC-DELISTED	Stock	2.12	2.17	2.0	2.0	145551.0
2019-03-25	AACG	Stock	1.01	1.01	0.96	0.99	43800.0
2019-03-25	AAIC-DELISTED	Stock	8.27	8.315	8.13	8.19	597505.0
2019-03-25	AAIC.C-DELISTED	Stock	23.32	23.32	23.02	23.1286	17817.0
2019-03-25	AAL	Stock	30.53	30.72	30.16	30.21	5172000.0
2019-03-25	AAM.A-DELISTED	Stock	25.02	25.0609	25.0	25.02	19701.0
2019-03-25	AAM.B-DELISTED	Stock	24.68	24.75	24.59	24.64	37773.0
2019-03-25	AAMC-DELISTED	Stock	10.0	10.0	7.7088	8.9853	47930.0
2019-03-25	AAME	Stock	2.64	2.64	2.64	2.64	100.0
2019-03-25	AAMI	Stock	12.56	12.755	12.51	12.63	1177700.0
2019-03-25	AAOI	Stock	12.65	12.76	12.13	12.32	816400.0
2019-03-25	AAON	Stock	28.26	29.0	28.0667	28.7867	135750.0
2019-03-25	AAP	Stock	165.5	168.95	164.29	167.78	841100.0
2019-03-25	AAT	Stock	45.09	45.55	44.91	45.32	191400.0
2019-03-25	AAU-DELISTED	Stock	0.6079	0.61	0.5975	0.6074	235659.0
2019-03-25	AAUAF-DELISTED	Stock	0.6079	0.61	0.5975	0.6074	240379.0
2019-03-25	AAWW-DELISTED	Stock	46.65	47.9	46.16	46.5	156083.0
2019-03-25	AAXJ	Stock	69.38	69.82	69.33	69.61	954664.0
2019-03-25	AAXN-DELISTED	Stock	52.0	53.35	51.4388	52.93	263531.0
2019-03-25	AB	Stock	27.72	27.78	27.37	27.57	220900.0
2019-03-25	ABB-DELISTED	Stock	18.54	18.655	18.515	18.58	1556910.0
2019-03-25	ABBNY-DELISTED	Stock	18.54	18.655	18.515	18.58	1837608.0
2019-03-25	ABBV	Stock	79.5	80.04	78.41	79.51	4008400.0
2019-03-25	ABC-DELISTED	Stock	78.77	78.77	76.87	77.12	1472547.0
2019-03-25	ABCB	Stock	33.46	33.76	32.91	33.32	323400.0
2019-03-25	ABDC-DELISTED	Stock	7.49	7.63	7.49	7.63	30037.0
2019-03-25	ABEO	Stock	188.5	191.0	184.0	187.75	10856.0
2019-03-25	ABEV	Stock	4.23	4.32	4.21	4.27	24441100.0
2019-03-25	ABG	Stock	66.71	68.76	66.46	67.94	136100.0
2019-03-25	ABIL-DELISTED	Stock	1.89	1.98	1.855	1.9708	125738.0
2019-03-25	ABM	Stock	33.92	34.64	33.66	34.52	405500.0
2019-03-25	ABMD-DELISTED	Stock	321.3	322.14	313.0	313.04	593632.0
2019-03-25	ABR	Stock	12.85	12.96	12.75	12.91	684100.0
2019-03-25	ABR.A-DELISTED	Stock	25.77	25.78	25.76	25.78	2788.0
2019-03-25	ABR.C-DELISTED	Stock	25.8716	25.8716	25.8716	25.8716	200.0
2019-03-25	ABT	Stock	77.81	78.67	77.62	78.23	3844500.0
2019-03-25	ABTC	Stock	304500.0	304500.0	303000.0	303300.0	0.3466666666666667

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

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