PREVIEW / stock_daily / 2017-10-18

all stock daily files

  file:    by_date/stock_daily/2017/2017-10-18.parquet
  size:    215 KB
  rows:    6,443
  symbols: 2,903

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-10-18	AAPL	Stock	40.105	40.1775	39.9	39.94	65496800.0
2017-10-18	MSFT	Stock	77.67	77.85	77.37	77.61	13300700.0
2017-10-18	NVDA	Stock	4.9528	4.9535	4.833	4.9395	567316000.0
2017-10-18	AMZN	Stock	50.4635	51.1155	49.8275	49.85	49994000.0
2017-10-18	GOOGL	Stock	50.5525	50.8155	50.266	50.637	25595600.0
2017-10-18	META	Stock	176.65	176.74	175.75	176.03	12752400.0
2017-10-18	TSLA	Stock	23.7313	24.2	23.6087	23.9767	74086500.0
2017-10-18	TLT	Stock	125.05	125.18	124.68	125.09	5943823.0
2017-10-18	ES	Stock	61.6	61.66	61.25	61.44	1050000.0
2017-10-18	CL	Stock	74.82	74.85	74.26	74.44	2682100.0
2017-10-18	A	Stock	66.38	66.58	66.07	66.44	1150500.0
2017-10-18	AA	Stock	47.38	47.84	46.51	47.75	4606100.0
2017-10-18	AAAP-DELISTED	Stock	70.72	71.74	70.09	70.6	98707.0
2017-10-18	AABA-DELISTED	Stock	67.2	68.04	66.98	67.79	3226488.0
2017-10-18	AAC-DELISTED	Stock	7.93	8.34	7.93	8.21	84781.0
2017-10-18	AAIC-DELISTED	Stock	12.72	12.799	12.72	12.72	273852.0
2017-10-18	AAL	Stock	52.11	52.44	51.86	52.03	2542400.0
2017-10-18	AAM.A-DELISTED	Stock	26.05	26.2	26.0213	26.14	28349.0
2017-10-18	AAMC-DELISTED	Stock	25.3824	25.3824	25.3824	25.3824	1452.0
2017-10-18	AAME	Stock	3.4	3.55	3.25	3.25	10500.0
2017-10-18	AAMI	Stock	15.1	15.31	15.1	15.22	175800.0
2017-10-18	AAOI	Stock	43.5	44.59	41.95	42.29	2004400.0
2017-10-18	AAON	Stock	22.5667	22.9667	22.5333	22.8333	126300.0
2017-10-18	AAP	Stock	87.83	88.88	87.44	87.81	2345200.0
2017-10-18	AAT	Stock	40.53	40.57	40.16	40.2	139600.0
2017-10-18	AAU-DELISTED	Stock	1.11	1.1452	1.1	1.139	109395.0
2017-10-18	AAUAF-DELISTED	Stock	1.11	1.1452	1.1	1.139	114683.0
2017-10-18	AAV-DELISTED	Stock	5.4	5.5315	5.4	5.45	48070.0
2017-10-18	AAWW-DELISTED	Stock	62.25	62.75	61.9	62.45	154332.0
2017-10-18	AAXJ	Stock	75.33	75.47	75.07	75.29	494874.0
2017-10-18	AAXN-DELISTED	Stock	23.94	25.02	23.6	25.01	1415458.0
2017-10-18	AB	Stock	25.1	25.3	24.9	25.2	238600.0
2017-10-18	ABAC-DELISTED	Stock	3.45	3.51	3.45	3.51	1168.0
2017-10-18	ABAX-DELISTED	Stock	45.81	47.28	45.81	47.01	72607.0
2017-10-18	ABB-DELISTED	Stock	24.84	25.15	24.82	25.06	3678020.0
2017-10-18	ABBNY-DELISTED	Stock	24.84	25.15	24.82	25.06	4121381.0
2017-10-18	ABBV	Stock	92.35	96.44	92.2	96.04	10979700.0
2017-10-18	ABC-DELISTED	Stock	80.13	81.66	80.13	80.49	1392550.0
2017-10-18	ABCB	Stock	49.3	49.7	47.35	49.45	122300.0
2017-10-18	ABCD-DELISTED	Stock	6.12	6.26	6.12	6.23	26872.0
2017-10-18	ABCO-DELISTED	Stock	53.8	53.825	53.7	53.75	589389.0
2017-10-18	ABDC-DELISTED	Stock	10.4	10.4	10.15	10.18	46763.0
2017-10-18	ABE-DELISTED	Stock	14.72	14.72	14.6501	14.68	35373.0
2017-10-18	ABEO	Stock	443.75	450.0	417.5	437.5	74248.0
2017-10-18	ABEOW-DELISTED	Stock	12.5	12.53	12.49	12.5	2400.0
2017-10-18	ABEV	Stock	6.81	6.84	6.79	6.82	11275100.0
2017-10-18	ABG	Stock	57.2	58.3	57.2	57.4	212300.0
2017-10-18	ABIL-DELISTED	Stock	0.7121	0.7497	0.6901	0.7161	93319.0
2017-10-18	ABM	Stock	42.67	42.89	42.54	42.64	131400.0
2017-10-18	ABMD-DELISTED	Stock	172.97	173.75	171.91	172.99	133253.0

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

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