PREVIEW / stock_daily / 2019-01-16

all stock daily files

  file:    by_date/stock_daily/2019/2019-01-16.parquet
  size:    218 KB
  rows:    6,535
  symbols: 2,646

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-01-16	AAPL	Stock	38.27	38.97	38.25	38.735	122278800.0
2019-01-16	MSFT	Stock	105.26	106.26	104.96	105.38	29853900.0
2019-01-16	NVDA	Stock	3.7742	3.8075	3.7155	3.721	470104000.0
2019-01-16	AMZN	Stock	84.211	85.25	83.794	84.189	127338000.0
2019-01-16	GOOGL	Stock	54.5	55.118	54.4005	54.4755	38280820.0
2019-01-16	META	Stock	149.0	149.65	147.0	147.54	18025700.0
2019-01-16	TSLA	Stock	22.9853	23.4667	22.9	23.07	70375500.0
2019-01-16	TLT	Stock	119.59	120.39	119.51	120.16	6048446.0
2019-01-16	ES	Stock	66.22	66.77	66.13	66.66	2177100.0
2019-01-16	CL	Stock	61.85	62.33	61.7	62.13	3017600.0
2019-01-16	A	Stock	70.82	71.13	69.97	70.03	1480300.0
2019-01-16	AA	Stock	29.19	29.33	28.16	28.98	9242900.0
2019-01-16	AABA-DELISTED	Stock	62.93	64.2	62.93	63.93	9376447.0
2019-01-16	AAC-DELISTED	Stock	2.84	2.9301	2.75	2.76	122546.0
2019-01-16	AACG	Stock	1.02	1.03	0.98	0.98	47800.0
2019-01-16	AAIC-DELISTED	Stock	8.07	8.155	8.05	8.15	392580.0
2019-01-16	AAL	Stock	32.82	33.67	32.74	32.84	9141600.0
2019-01-16	AAM.A-DELISTED	Stock	24.17	24.55	24.17	24.49	61087.0
2019-01-16	AAM.B-DELISTED	Stock	24.29	24.34	23.91	24.14	75445.0
2019-01-16	AAMC-DELISTED	Stock	9.0147	9.3941	7.5853	8.3	198988.0
2019-01-16	AAME	Stock	2.52	2.52	2.5	2.5	1900.0
2019-01-16	AAMI	Stock	11.38	11.84	11.38	11.72	477700.0
2019-01-16	AAOI	Stock	16.18	16.29	15.84	15.95	377200.0
2019-01-16	AAON	Stock	23.6467	24.1933	23.4867	23.86	129750.0
2019-01-16	AAP	Stock	160.89	162.46	159.03	162.44	1158000.0
2019-01-16	AAT	Stock	40.49	41.15	40.4	40.9	241100.0
2019-01-16	AAU-DELISTED	Stock	0.8	0.83	0.79	0.8249	162819.0
2019-01-16	AAUAF-DELISTED	Stock	0.8	0.83	0.79	0.8249	169177.0
2019-01-16	AAWW-DELISTED	Stock	48.0	49.08	47.57	47.94	131407.0
2019-01-16	AAXJ	Stock	65.86	66.425	65.86	66.17	905948.0
2019-01-16	AAXN-DELISTED	Stock	49.36	50.005	48.68	49.64	248044.0
2019-01-16	AB	Stock	28.95	29.67	28.95	29.47	373800.0
2019-01-16	ABAC-DELISTED	Stock	1.6002	1.7885	1.6002	1.7632	42493.0
2019-01-16	ABB-DELISTED	Stock	19.08	19.265	19.07	19.17	1825385.0
2019-01-16	ABBNY-DELISTED	Stock	19.08	19.265	19.07	19.17	1895449.0
2019-01-16	ABBV	Stock	85.66	86.39	85.45	85.55	4927000.0
2019-01-16	ABC-DELISTED	Stock	77.25	77.77	76.67	77.29	851804.0
2019-01-16	ABCB	Stock	34.61	35.37	34.53	35.34	310500.0
2019-01-16	ABDC-DELISTED	Stock	6.85	7.0	6.84	6.88	25513.0
2019-01-16	ABEO	Stock	180.5	188.0	175.25	175.5	7188.0
2019-01-16	ABEOW-DELISTED	Stock	2.96	2.96	2.96	2.96	100.0
2019-01-16	ABEV	Stock	4.71	4.76	4.66	4.69	25838800.0
2019-01-16	ABG	Stock	69.23	70.21	69.1	70.02	125800.0
2019-01-16	ABIL-DELISTED	Stock	2.17	2.44	2.15	2.3352	3066344.0
2019-01-16	ABM	Stock	34.35	35.09	34.28	34.97	373700.0
2019-01-16	ABMD-DELISTED	Stock	326.06	332.93	323.29	324.15	357613.0
2019-01-16	ABR	Stock	11.35	11.4	11.27	11.35	802000.0
2019-01-16	ABR.A-DELISTED	Stock	25.5791	25.58	25.5067	25.5067	900.0
2019-01-16	ABR.C-DELISTED	Stock	25.6476	25.6476	25.6476	25.6476	410.0
2019-01-16	ABT	Stock	70.5	70.76	69.74	69.82	6357300.0

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

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