PREVIEW / stock_daily / 2019-03-05

all stock daily files

  file:    by_date/stock_daily/2019/2019-03-05.parquet
  size:    219 KB
  rows:    6,502
  symbols: 2,595

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-05	AAPL	Stock	43.985	44.0	43.635	43.8825	78949600.0
2019-03-05	MSFT	Stock	112.25	112.39	111.23	111.7	19538300.0
2019-03-05	NVDA	Stock	3.9038	3.9515	3.849	3.913	362924000.0
2019-03-05	AMZN	Stock	85.1475	85.39	84.4505	84.6215	73630000.0
2019-03-05	GOOGL	Stock	57.8	58.8245	57.651	58.4595	40094460.0
2019-03-05	META	Stock	167.37	171.88	166.55	171.26	28187900.0
2019-03-05	TSLA	Stock	18.8	18.9333	18.0067	18.436	281470500.0
2019-03-05	TLT	Stock	119.28	119.87	119.27	119.84	5595345.0
2019-03-05	ES	Stock	68.86	68.96	68.38	68.59	2024700.0
2019-03-05	CL	Stock	66.06	66.18	65.55	65.72	3483900.0
2019-03-05	A	Stock	80.02	80.03	79.36	79.74	1405600.0
2019-03-05	AA	Stock	29.07	29.31	28.76	29.2	1890800.0
2019-03-05	AABA-DELISTED	Stock	75.96	76.26	75.08	75.1	6065006.0
2019-03-05	AAC-DELISTED	Stock	2.55	2.65	2.52	2.59	97842.0
2019-03-05	AACG	Stock	1.13	1.21	1.11	1.14	541400.0
2019-03-05	AAIC-DELISTED	Stock	8.31	8.33	8.21	8.25	551548.0
2019-03-05	AAL	Stock	34.03	34.38	33.17	33.23	7405700.0
2019-03-05	AAM.A-DELISTED	Stock	25.03	25.1	24.95	25.09	28148.0
2019-03-05	AAM.B-DELISTED	Stock	24.79	24.8	24.6301	24.8	21716.0
2019-03-05	AAMC-DELISTED	Stock	12.3088	12.3088	11.4676	11.6912	12172.0
2019-03-05	AAME	Stock	2.85	2.85	2.85	2.85	200.0
2019-03-05	AAMI	Stock	14.29	14.29	14.03	14.2	640200.0
2019-03-05	AAOI	Stock	13.95	13.97	13.46	13.64	839400.0
2019-03-05	AAON	Stock	27.9933	28.34	27.8867	28.2533	214950.0
2019-03-05	AAP	Stock	158.51	159.82	157.27	157.31	863100.0
2019-03-05	AAT	Stock	44.01	44.35	43.75	44.19	120300.0
2019-03-05	AAU-DELISTED	Stock	0.632	0.6502	0.63	0.6328	108564.0
2019-03-05	AAUAF-DELISTED	Stock	0.632	0.6502	0.63	0.6328	109965.0
2019-03-05	AAWW-DELISTED	Stock	51.66	51.83	50.6	51.29	374325.0
2019-03-05	AAXJ	Stock	69.98	70.39	69.81	70.28	966860.0
2019-03-05	AAXN-DELISTED	Stock	51.41	51.64	50.5	51.44	547962.0
2019-03-05	AB	Stock	29.76	29.85	29.38	29.74	261700.0
2019-03-05	ABB-DELISTED	Stock	19.39	19.5	19.37	19.38	2197641.0
2019-03-05	ABBNY-DELISTED	Stock	19.39	19.5	19.37	19.38	2289865.0
2019-03-05	ABBV	Stock	79.38	79.9	78.72	78.91	5933100.0
2019-03-05	ABC-DELISTED	Stock	80.7	80.7	79.43	79.64	1860485.0
2019-03-05	ABCB	Stock	40.79	41.09	40.16	40.79	259300.0
2019-03-05	ABDC-DELISTED	Stock	7.26	7.31	7.06	7.27	27356.0
2019-03-05	ABEO	Stock	198.0	201.75	188.5	195.75	19944.0
2019-03-05	ABEV	Stock	4.35	4.43	4.32	4.38	12903600.0
2019-03-05	ABG	Stock	69.22	69.22	67.6	68.04	189800.0
2019-03-05	ABIL-DELISTED	Stock	1.8165	1.8315	1.78	1.83	64067.0
2019-03-05	ABM	Stock	35.65	36.65	35.65	36.02	489700.0
2019-03-05	ABMD-DELISTED	Stock	337.48	337.48	332.4	333.21	233251.0
2019-03-05	ABR	Stock	12.9	12.97	12.87	12.93	828400.0
2019-03-05	ABR.A-DELISTED	Stock	25.66	25.66	25.3035	25.4469	3278.0
2019-03-05	ABR.B-DELISTED	Stock	25.2805	25.2805	25.2805	25.2805	385.0
2019-03-05	ABR.C-DELISTED	Stock	25.68	25.68	25.484	25.484	1800.0
2019-03-05	ABT	Stock	78.56	78.91	78.13	78.22	6547500.0
2019-03-05	ABTC	Stock	304200.0	304200.0	302700.0	303150.0	0.13333333333333333

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

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