PREVIEW / stock_daily / 2019-05-16

all stock daily files

  file:    by_date/stock_daily/2019/2019-05-16.parquet
  size:    220 KB
  rows:    6,541
  symbols: 2,557

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-05-16	AAPL	Stock	47.4775	48.1175	47.21	47.52	132125600.0
2019-05-16	MSFT	Stock	126.75	129.38	126.46	128.93	30112200.0
2019-05-16	NVDA	Stock	3.984	4.0478	3.9412	4.0048	781088000.0
2019-05-16	AMZN	Stock	94.297	95.8755	94.1145	95.3785	94156000.0
2019-05-16	GOOGL	Stock	58.592	59.708	58.4225	59.225	35307760.0
2019-05-16	META	Stock	185.05	188.58	185.05	186.99	12953100.0
2019-05-16	TSLA	Stock	15.2993	15.4	15.1	15.222	112249500.0
2019-05-16	TLT	Stock	125.81	125.83	125.53	125.71	7666369.0
2019-05-16	ES	Stock	72.4	73.32	72.28	73.13	1098100.0
2019-05-16	CL	Stock	71.75	73.1	71.58	72.5	3581300.0
2019-05-16	A	Stock	67.6	69.42	67.6	69.3	4567700.0
2019-05-16	AA	Stock	25.13	25.235	24.67	24.98	2237900.0
2019-05-16	AABA-DELISTED	Stock	71.32	71.6075	70.34	70.52	5325555.0
2019-05-16	AAC-DELISTED	Stock	1.66	1.8	1.64	1.685	490069.0
2019-05-16	AACG	Stock	2.38	2.45	2.31	2.4	180800.0
2019-05-16	AAIC-DELISTED	Stock	7.6	7.64	7.55	7.58	186225.0
2019-05-16	AAIC.C-DELISTED	Stock	23.64	23.64	23.5027	23.6376	2310.0
2019-05-16	AAL	Stock	32.2	32.9	32.02	32.32	4739700.0
2019-05-16	AAM.A-DELISTED	Stock	25.81	25.82	25.72	25.8	24122.0
2019-05-16	AAM.B-DELISTED	Stock	25.76	25.825	25.7279	25.77	66148.0
2019-05-16	AAMC-DELISTED	Stock	6.3971	6.9294	6.0294	6.4559	53672.0
2019-05-16	AAME	Stock	2.45	2.45	2.33	2.33	1400.0
2019-05-16	AAMI	Stock	12.16	12.41	12.08	12.3	1074200.0
2019-05-16	AAOI	Stock	9.98	10.1	9.7	9.71	614000.0
2019-05-16	AAON	Stock	31.14	31.3667	30.58	30.8733	293850.0
2019-05-16	AAP	Stock	155.8	158.67	154.12	157.28	1264500.0
2019-05-16	AAT	Stock	46.06	46.48	46.06	46.43	240600.0
2019-05-16	AAU-DELISTED	Stock	0.4994	0.4994	0.46	0.4642	75321.0
2019-05-16	AAUAF-DELISTED	Stock	0.4994	0.4994	0.46	0.4642	79269.0
2019-05-16	AAWW-DELISTED	Stock	40.47	41.38	40.3098	41.26	156733.0
2019-05-16	AAXJ	Stock	67.75	68.09	67.56	67.57	784647.0
2019-05-16	AAXN-DELISTED	Stock	65.51	68.49	65.46	68.18	535284.0
2019-05-16	AB	Stock	29.1	29.42	28.92	29.34	172200.0
2019-05-16	ABB-DELISTED	Stock	19.09	19.26	19.04	19.255	2140822.0
2019-05-16	ABBNY-DELISTED	Stock	19.09	19.26	19.04	19.25	2251695.0
2019-05-16	ABBV	Stock	78.98	80.75	78.71	79.5	5404700.0
2019-05-16	ABC-DELISTED	Stock	77.84	78.75	77.36	77.58	1009181.0
2019-05-16	ABCB	Stock	36.09	36.68	36.09	36.23	172000.0
2019-05-16	ABDC-DELISTED	Stock	8.47	8.55	8.4373	8.52	25467.0
2019-05-16	ABEO	Stock	182.75	191.25	182.75	186.25	20484.0
2019-05-16	ABEV	Stock	4.1	4.19	4.09	4.14	32202600.0
2019-05-16	ABG	Stock	79.79	81.0	79.46	79.63	103000.0
2019-05-16	ABIL-DELISTED	Stock	1.29	1.52	1.23	1.279	625072.0
2019-05-16	ABM	Stock	38.01	38.6	37.99	38.34	153500.0
2019-05-16	ABMD-DELISTED	Stock	258.57	268.515	258.53	262.14	891504.0
2019-05-16	ABR	Stock	13.05	13.23	12.88	12.95	6363000.0
2019-05-16	ABR.A-DELISTED	Stock	25.76	26.03	25.7272	25.85	6188.0
2019-05-16	ABR.B-DELISTED	Stock	25.65	25.66	25.65	25.66	1500.0
2019-05-16	ABR.C-DELISTED	Stock	26.15	26.24	26.15	26.15	1655.0
2019-05-16	ABT	Stock	76.52	77.37	76.17	76.6	6098100.0

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

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