PREVIEW / stock_daily / 2019-08-08

all stock daily files

  file:    by_date/stock_daily/2019/2019-08-08.parquet
  size:    222 KB
  rows:    6,614
  symbols: 2,538

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-08-08	AAPL	Stock	50.05	50.8825	49.8475	50.8575	108038000.0
2019-08-08	MSFT	Stock	136.6	138.99	135.93	138.89	27496500.0
2019-08-08	NVDA	Stock	3.9053	3.9578	3.8475	3.9565	309300000.0
2019-08-08	AMZN	Stock	90.3	91.713	89.9055	91.6445	74024000.0
2019-08-08	GOOGL	Stock	59.3215	60.314	58.7	60.3095	30116960.0
2019-08-08	META	Stock	186.62	190.34	184.05	190.16	14828900.0
2019-08-08	TSLA	Stock	15.63	15.9867	15.51	15.8867	79114500.0
2019-08-08	TLT	Stock	139.14	140.43	137.98	140.33	14745985.0
2019-08-08	ES	Stock	77.88	78.69	77.2	78.41	1313900.0
2019-08-08	CL	Stock	70.67	71.77	70.1	71.71	2712900.0
2019-08-08	A	Stock	68.43	69.51	68.1	69.49	2014300.0
2019-08-08	AA	Stock	19.79	20.24	19.68	20.12	2980800.0
2019-08-08	AABA-DELISTED	Stock	70.15	70.2	69.84	69.93	4119307.0
2019-08-08	AAC-DELISTED	Stock	0.8151	0.94	0.815	0.8735	98688.0
2019-08-08	AACG	Stock	2.35	2.49	2.35	2.4	33100.0
2019-08-08	AAIC-DELISTED	Stock	5.9	6.0	5.78	5.98	466245.0
2019-08-08	AAIC.C-DELISTED	Stock	22.46	22.77	22.3301	22.68	5603.0
2019-08-08	AAL	Stock	28.81	29.39	28.76	29.08	5028200.0
2019-08-08	AAM.A-DELISTED	Stock	26.27	26.27	26.195	26.245	8688.0
2019-08-08	AAM.B-DELISTED	Stock	26.78	26.78	26.56	26.6	50798.0
2019-08-08	AAMC-DELISTED	Stock	3.2676	3.3206	3.2647	3.3088	6827.0
2019-08-08	AAME	Stock	2.47	2.47	2.42	2.42	800.0
2019-08-08	AAMI	Stock	8.98	9.21	8.94	9.0	311300.0
2019-08-08	AAOI	Stock	11.0	11.0	10.05	10.9	1273500.0
2019-08-08	AAON	Stock	30.06	30.3933	29.9533	30.2933	167550.0
2019-08-08	AAP	Stock	144.9	146.62	144.09	144.43	1291600.0
2019-08-08	AAT	Stock	46.67	47.63	46.23	47.59	310500.0
2019-08-08	AAU-DELISTED	Stock	0.79	0.82	0.7512	0.775	238866.0
2019-08-08	AAUAF-DELISTED	Stock	0.79	0.82	0.7512	0.775	253471.0
2019-08-08	AAWW-DELISTED	Stock	29.57	30.92	29.37	30.92	301678.0
2019-08-08	AAXJ	Stock	64.69	65.055	64.485	64.98	1890763.0
2019-08-08	AAXN-DELISTED	Stock	66.25	69.14	66.25	68.46	844909.0
2019-08-08	AB	Stock	28.25	28.45	27.83	28.01	235500.0
2019-08-08	ABB-DELISTED	Stock	18.03	18.19	17.98	18.15	1332389.0
2019-08-08	ABBNY-DELISTED	Stock	18.03	18.19	17.98	18.15	1442109.0
2019-08-08	ABBV	Stock	64.79	65.45	64.33	65.45	7427400.0
2019-08-08	ABC-DELISTED	Stock	85.8	88.39	85.48	87.93	1076088.0
2019-08-08	ABCB	Stock	36.98	37.99	36.98	37.9	277000.0
2019-08-08	ABDC-DELISTED	Stock	8.22	8.32	8.22	8.24	44910.0
2019-08-08	ABEO	Stock	62.0	63.0	56.25	57.0	21348.0
2019-08-08	ABEV	Stock	5.12	5.17	5.08	5.1	48231600.0
2019-08-08	ABG	Stock	92.31	93.89	92.25	92.93	111400.0
2019-08-08	ABIL-DELISTED	Stock	0.7066	0.7296	0.68	0.6899	29266.0
2019-08-08	ABM	Stock	40.35	41.15	40.26	41.11	183600.0
2019-08-08	ABMD-DELISTED	Stock	190.23	192.94	181.02	191.7	974071.0
2019-08-08	ABR	Stock	12.67	12.7	12.54	12.67	975600.0
2019-08-08	ABR.A-DELISTED	Stock	26.18	26.3	26.1581	26.251	2800.0
2019-08-08	ABR.B-DELISTED	Stock	26.0	26.0	26.0	26.0	296.0
2019-08-08	ABR.C-DELISTED	Stock	26.49	26.77	26.3592	26.77	2511.0
2019-08-08	ABT	Stock	85.11	86.27	85.01	85.56	6439300.0

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

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