PREVIEW / stock_daily / 2017-03-01

all stock daily files

  file:    by_date/stock_daily/2017/2017-03-01.parquet
  size:    217 KB
  rows:    6,506
  symbols: 3,080

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
2017-03-01	AAPL	Stock	34.4725	35.0375	34.4	34.9475	145658400.0
2017-03-01	MSFT	Stock	64.13	64.99	64.02	64.94	26937500.0
2017-03-01	NVDA	Stock	2.5948	2.6093	2.5278	2.5698	504804000.0
2017-03-01	AMZN	Stock	42.6525	42.7415	42.4505	42.654	55202000.0
2017-03-01	GOOGL	Stock	42.569	42.9	42.451	42.8375	36373420.0
2017-03-01	META	Stock	136.47	137.48	136.3	137.42	16257000.0
2017-03-01	TSLA	Stock	16.9453	16.99	16.6073	16.668	72142500.0
2017-03-01	TLT	Stock	119.44	119.55	118.95	119.47	10717113.0
2017-03-01	ES	Stock	57.98	58.6	57.6	58.19	1787800.0
2017-03-01	CL	Stock	73.05	73.57	72.7	73.46	4093000.0
2017-03-01	A	Stock	51.62	52.26	51.62	52.04	2026600.0
2017-03-01	AA	Stock	35.93	38.15	35.85	37.99	10564500.0
2017-03-01	AAAP-DELISTED	Stock	38.0	38.3299	37.67	37.84	109534.0
2017-03-01	AABA-DELISTED	Stock	45.89	46.41	45.89	46.24	6686747.0
2017-03-01	AAC-DELISTED	Stock	9.32	9.68	8.8	8.9	273685.0
2017-03-01	AACG	Stock	3.83	3.91	3.71	3.74	6000.0
2017-03-01	AAIC-DELISTED	Stock	14.96	15.0	14.77	14.78	330812.0
2017-03-01	AAL	Stock	46.79	48.14	46.7	47.09	8278900.0
2017-03-01	AAMC-DELISTED	Stock	20.9706	22.4559	20.9706	21.6324	11795.0
2017-03-01	AAME	Stock	3.9	3.9	3.75	3.75	1500.0
2017-03-01	AAMI	Stock	15.17	15.26	15.085	15.2	239100.0
2017-03-01	AAOI	Stock	46.42	47.72	45.898	46.85	1025100.0
2017-03-01	AAON	Stock	22.7333	23.5667	22.7333	23.5333	364950.0
2017-03-01	AAP	Stock	158.59	158.59	155.64	156.68	1037800.0
2017-03-01	AAT	Stock	43.97	44.07	43.37	43.79	228200.0
2017-03-01	AAU-DELISTED	Stock	1.04	1.16	1.04	1.16	245315.0
2017-03-01	AAUAF-DELISTED	Stock	1.04	1.16	1.04	1.16	256748.0
2017-03-01	AAV-DELISTED	Stock	6.05	6.14	6.01	6.05	40084.0
2017-03-01	AAWW-DELISTED	Stock	57.7	59.6	57.25	57.7	294270.0
2017-03-01	AAXJ	Stock	60.96	61.28	60.9	61.2	574784.0
2017-03-01	AAXN-DELISTED	Stock	24.77	25.13	22.905	24.32	5054383.0
2017-03-01	AB	Stock	23.9	24.0	23.35	23.5	448800.0
2017-03-01	ABAC-DELISTED	Stock	2.76	3.0363	2.67	2.67	25160.0
2017-03-01	ABAX-DELISTED	Stock	50.31	50.61	49.85	50.37	75102.0
2017-03-01	ABB-DELISTED	Stock	22.77	23.02	22.77	22.98	1546917.0
2017-03-01	ABBNY-DELISTED	Stock	22.77	23.02	22.77	22.98	1584483.0
2017-03-01	ABBV	Stock	62.16	62.93	61.95	62.83	7737400.0
2017-03-01	ABC-DELISTED	Stock	92.19	92.807	91.69	92.24	1172593.0
2017-03-01	ABCB	Stock	48.1	48.5	47.25	48.0	1506300.0
2017-03-01	ABCD-DELISTED	Stock	4.97	4.98	4.77	4.86	23697.0
2017-03-01	ABCO-DELISTED	Stock	45.0	46.85	44.75	45.85	1288039.0
2017-03-01	ABDC-DELISTED	Stock	12.51	12.79	12.35	12.58	64474.0
2017-03-01	ABE-DELISTED	Stock	12.05	12.15	12.04	12.15	103233.0
2017-03-01	ABEO	Stock	136.25	142.5	133.75	136.25	7604.0
2017-03-01	ABEOW-DELISTED	Stock	3.0	3.0	3.0	3.0	468.0
2017-03-01	ABEV	Stock	5.72	5.79	5.68	5.75	13822800.0
2017-03-01	ABG	Stock	66.0	66.9	65.15	65.45	186300.0
2017-03-01	ABIL-DELISTED	Stock	2.64	2.67	2.64	2.67	1900.0
2017-03-01	ABM	Stock	41.15	41.61	41.0	41.15	712300.0
2017-03-01	ABMD-DELISTED	Stock	119.16	121.83	118.02	121.29	350811.0

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

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