PREVIEW / stock_daily / 2019-05-14

all stock daily files

  file:    by_date/stock_daily/2019/2019-05-14.parquet
  size:    221 KB
  rows:    6,568
  symbols: 2,582

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-14	AAPL	Stock	46.6025	47.425	46.3525	47.165	146118800.0
2019-05-14	MSFT	Stock	123.87	125.88	123.7	124.73	25266300.0
2019-05-14	NVDA	Stock	4.0013	4.0865	3.9623	4.051	524880000.0
2019-05-14	AMZN	Stock	91.975	92.622	90.7875	92.006	92582000.0
2019-05-14	GOOGL	Stock	57.116	57.2432	56.1765	56.243	40391000.0
2019-05-14	META	Stock	182.52	183.49	178.1	180.73	17628100.0
2019-05-14	TSLA	Stock	15.2867	15.6333	15.2	15.4873	108786000.0
2019-05-14	TLT	Stock	125.51	125.65	125.2	125.36	5690447.0
2019-05-14	ES	Stock	72.85	73.23	72.32	72.59	1377600.0
2019-05-14	CL	Stock	71.5	71.97	71.13	71.15	2855400.0
2019-05-14	A	Stock	74.43	76.67	74.3	76.01	2557700.0
2019-05-14	AA	Stock	24.79	25.47	24.7	25.01	4318500.0
2019-05-14	AABA-DELISTED	Stock	69.75	70.6	69.18	70.27	5130917.0
2019-05-14	AAC-DELISTED	Stock	1.67	1.67	1.52	1.54	186311.0
2019-05-14	AACG	Stock	2.37	2.51	2.2	2.25	778400.0
2019-05-14	AAIC-DELISTED	Stock	7.55	7.65	7.52	7.61	179878.0
2019-05-14	AAIC.C-DELISTED	Stock	23.35	23.36	23.2648	23.265	1962.0
2019-05-14	AAL	Stock	32.19	32.65	32.01	32.34	5503900.0
2019-05-14	AAM.A-DELISTED	Stock	25.59	25.64	25.555	25.64	10271.0
2019-05-14	AAM.B-DELISTED	Stock	25.58	25.6857	25.55	25.67	41498.0
2019-05-14	AAMC-DELISTED	Stock	6.5475	6.5475	6.4265	6.4265	2353.0
2019-05-14	AAME	Stock	2.45	2.45	2.45	2.45	100.0
2019-05-14	AAMI	Stock	12.43	12.69	12.41	12.45	864900.0
2019-05-14	AAOI	Stock	10.25	10.531	10.19	10.38	600200.0
2019-05-14	AAON	Stock	31.1333	31.46	30.8667	31.0467	181800.0
2019-05-14	AAP	Stock	154.57	156.89	153.09	155.75	1216000.0
2019-05-14	AAT	Stock	45.43	45.95	45.36	45.93	214500.0
2019-05-14	AAU-DELISTED	Stock	0.46	0.4622	0.4458	0.4573	75724.0
2019-05-14	AAUAF-DELISTED	Stock	0.46	0.4622	0.4458	0.4573	82251.0
2019-05-14	AAWW-DELISTED	Stock	40.61	41.31	40.57	40.74	199093.0
2019-05-14	AAXJ	Stock	67.34	67.69	67.16	67.41	2159993.0
2019-05-14	AAXN-DELISTED	Stock	64.82	66.73	64.8	66.36	863408.0
2019-05-14	AB	Stock	29.01	29.5	29.01	29.26	310000.0
2019-05-14	ABB-DELISTED	Stock	18.65	18.82	18.575	18.69	1266153.0
2019-05-14	ABBNY-DELISTED	Stock	18.65	18.82	18.575	18.69	1331624.0
2019-05-14	ABBV	Stock	77.16	79.36	77.0	78.44	6365200.0
2019-05-14	ABC-DELISTED	Stock	75.94	78.925	75.47	76.69	1286532.0
2019-05-14	ABCB	Stock	35.65	36.87	35.48	36.57	230900.0
2019-05-14	ABDC-DELISTED	Stock	8.39	8.44	8.365	8.4	26820.0
2019-05-14	ABEO	Stock	177.75	186.75	177.75	182.25	16012.0
2019-05-14	ABEV	Stock	4.29	4.3	4.21	4.27	34348700.0
2019-05-14	ABG	Stock	78.43	79.69	78.39	79.67	116400.0
2019-05-14	ABIL-DELISTED	Stock	1.2348	1.3	1.18	1.27	89816.0
2019-05-14	ABM	Stock	37.4	38.18	37.38	37.85	162200.0
2019-05-14	ABMD-DELISTED	Stock	253.67	260.85	252.0	256.72	340120.0
2019-05-14	ABR	Stock	13.12	13.23	12.94	13.19	1113000.0
2019-05-14	ABR.A-DELISTED	Stock	26.06	26.06	25.9	25.9463	2465.0
2019-05-14	ABR.B-DELISTED	Stock	25.64	25.77	25.54	25.77	2149.0
2019-05-14	ABR.C-DELISTED	Stock	26.33	26.33	25.9592	26.3	4418.0
2019-05-14	ABT	Stock	75.64	76.77	75.63	76.03	5319300.0

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

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