PREVIEW / stock_daily / 2019-03-11

all stock daily files

  file:    by_date/stock_daily/2019/2019-03-11.parquet
  size:    220 KB
  rows:    6,534
  symbols: 2,617

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-11	AAPL	Stock	43.8725	44.78	43.8375	44.725	128044000.0
2019-03-11	MSFT	Stock	110.99	112.95	110.98	112.83	26491600.0
2019-03-11	NVDA	Stock	3.7898	4.0515	3.7422	4.0285	859728000.0
2019-03-11	AMZN	Stock	81.306	83.6145	81.3005	83.531	77528000.0
2019-03-11	GOOGL	Stock	57.6	58.9955	57.5785	58.963	30032660.0
2019-03-11	META	Stock	171.6	174.3	171.58	172.07	18884000.0
2019-03-11	TSLA	Stock	18.9013	19.4187	18.7	19.3947	110884500.0
2019-03-11	TLT	Stock	121.4	121.42	120.98	121.21	5158011.0
2019-03-11	ES	Stock	69.76	70.29	69.54	70.28	1904600.0
2019-03-11	CL	Stock	65.3	65.89	65.22	65.85	2722600.0
2019-03-11	A	Stock	78.28	79.47	78.26	79.3	1210900.0
2019-03-11	AA	Stock	26.76	27.57	26.73	27.52	3497700.0
2019-03-11	AABA-DELISTED	Stock	72.65	74.01	72.51	73.48	11062443.0
2019-03-11	AAC-DELISTED	Stock	2.33	2.6	2.31	2.56	128718.0
2019-03-11	AACG	Stock	1.08	1.1	1.08	1.08	32100.0
2019-03-11	AAIC-DELISTED	Stock	8.03	8.16	8.03	8.1	358827.0
2019-03-11	AAL	Stock	31.64	32.27	31.57	32.05	8944000.0
2019-03-11	AAM.A-DELISTED	Stock	25.0	25.14	25.0	25.0	19488.0
2019-03-11	AAM.B-DELISTED	Stock	24.67	24.895	24.67	24.76	28912.0
2019-03-11	AAMC-DELISTED	Stock	10.8529	10.8529	10.2265	10.2265	1530.0
2019-03-11	AAME	Stock	2.52	2.52	2.52	2.52	1100.0
2019-03-11	AAMI	Stock	13.66	13.94	13.55	13.71	296100.0
2019-03-11	AAOI	Stock	13.01	13.32	12.92	13.3	628700.0
2019-03-11	AAON	Stock	27.7533	27.9267	27.4667	27.58	201600.0
2019-03-11	AAP	Stock	152.26	155.78	152.08	155.46	1047800.0
2019-03-11	AAT	Stock	45.51	45.79	44.97	45.57	219400.0
2019-03-11	AAU-DELISTED	Stock	0.605	0.6271	0.6	0.6004	361461.0
2019-03-11	AAUAF-DELISTED	Stock	0.605	0.6271	0.6	0.6004	376410.0
2019-03-11	AAWW-DELISTED	Stock	49.13	50.56	48.99	49.14	163269.0
2019-03-11	AAXJ	Stock	68.73	69.43	68.7	69.4	666555.0
2019-03-11	AAXN-DELISTED	Stock	46.86	48.15	46.5	47.97	520083.0
2019-03-11	AB	Stock	29.0	29.5	29.0	29.07	236700.0
2019-03-11	ABB-DELISTED	Stock	18.82	19.06	18.82	19.04	2853834.0
2019-03-11	ABBNY-DELISTED	Stock	18.82	19.06	18.82	19.04	2931162.0
2019-03-11	ABBV	Stock	77.57	78.31	77.27	78.08	8078100.0
2019-03-11	ABC-DELISTED	Stock	76.52	78.05	76.08	77.94	988887.0
2019-03-11	ABCB	Stock	38.16	38.49	37.84	38.33	322400.0
2019-03-11	ABDC-DELISTED	Stock	7.61	7.68	7.42	7.46	35810.0
2019-03-11	ABEO	Stock	181.0	188.75	179.5	188.0	10968.0
2019-03-11	ABEV	Stock	4.29	4.46	4.29	4.43	27822000.0
2019-03-11	ABG	Stock	66.86	67.94	66.68	67.63	118800.0
2019-03-11	ABIL-DELISTED	Stock	1.8	1.88	1.79	1.85	67585.0
2019-03-11	ABM	Stock	32.71	33.52	31.9	33.5	573300.0
2019-03-11	ABMD-DELISTED	Stock	313.13	320.6	310.98	319.03	162249.0
2019-03-11	ABR	Stock	12.7	12.79	12.64	12.78	769100.0
2019-03-11	ABR.A-DELISTED	Stock	25.73	25.735	25.7	25.7	3900.0
2019-03-11	ABR.B-DELISTED	Stock	25.55	25.81	25.507	25.7	4000.0
2019-03-11	ABR.C-DELISTED	Stock	25.8308	25.8691	25.8201	25.8691	2761.0
2019-03-11	ABT	Stock	76.92	77.85	76.7	77.81	4254600.0
2019-03-11	ABTC	Stock	304200.0	304500.0	303600.0	303900.0	1.1066666666666667

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

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