PREVIEW / stock_daily / 2018-01-17

all stock daily files

  file:    by_date/stock_daily/2018/2018-01-17.parquet
  size:    218 KB
  rows:    6,499
  symbols: 2,883

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
2018-01-17	AAPL	Stock	44.0375	44.8125	43.7675	44.775	137547200.0
2018-01-17	MSFT	Stock	89.08	90.28	88.75	90.14	25621200.0
2018-01-17	NVDA	Stock	5.5175	5.628	5.4225	5.618	538408000.0
2018-01-17	AMZN	Stock	65.612	65.7	64.044	64.75	105076000.0
2018-01-17	GOOGL	Stock	56.818	56.966	56.1745	56.955	27830200.0
2018-01-17	META	Stock	179.26	179.32	175.8	177.6	27992400.0
2018-01-17	TSLA	Stock	22.698	23.2667	22.65	23.144	106552500.0
2018-01-17	TLT	Stock	125.08	125.64	124.595	124.87	8326973.0
2018-01-17	ES	Stock	60.94	61.78	60.87	61.65	1986000.0
2018-01-17	CL	Stock	75.82	77.12	75.67	76.68	3455200.0
2018-01-17	A	Stock	71.72	72.31	71.59	72.06	1824500.0
2018-01-17	AA	Stock	56.03	57.04	55.58	56.99	8189700.0
2018-01-17	AAAP-DELISTED	Stock	81.85	81.88	81.82	81.84	720337.0
2018-01-17	AABA-DELISTED	Stock	74.41	74.6	72.86	74.2	4363856.0
2018-01-17	AAC-DELISTED	Stock	9.12	9.17	9.0	9.02	92436.0
2018-01-17	AACG	Stock	5.8	5.82	5.47	5.7	30300.0
2018-01-17	AAIC-DELISTED	Stock	11.84	11.89	11.73	11.86	365649.0
2018-01-17	AAL	Stock	58.31	58.58	57.8	58.16	3148900.0
2018-01-17	AAM.A-DELISTED	Stock	25.78	25.85	25.69	25.69	16250.0
2018-01-17	AAMC-DELISTED	Stock	21.0297	21.0297	21.0297	21.0297	1000.0
2018-01-17	AAME	Stock	3.3	3.35	3.25	3.35	2700.0
2018-01-17	AAMI	Stock	18.13	18.45	17.85	18.31	592800.0
2018-01-17	AAOI	Stock	34.0	35.49	33.99	34.0	1242700.0
2018-01-17	AAON	Stock	24.2	24.32	23.9667	24.2	266700.0
2018-01-17	AAP	Stock	114.74	116.24	112.98	115.35	1354200.0
2018-01-17	AAT	Stock	36.18	36.41	36.08	36.34	181900.0
2018-01-17	AAU-DELISTED	Stock	0.98	0.98	0.94	0.9527	179123.0
2018-01-17	AAUAF-DELISTED	Stock	0.98	0.98	0.94	0.95	185391.0
2018-01-17	AAV-DELISTED	Stock	3.65	3.725	3.55	3.65	395755.0
2018-01-17	AAWW-DELISTED	Stock	62.2	62.7	61.35	61.95	155739.0
2018-01-17	AAXJ	Stock	80.4	80.84	80.17	80.74	1168118.0
2018-01-17	AAXN-DELISTED	Stock	27.39	27.79	27.3552	27.71	397626.0
2018-01-17	AB	Stock	26.95	27.25	26.7	27.05	186300.0
2018-01-17	ABAC-DELISTED	Stock	2.7	2.92	2.6999	2.91	13841.0
2018-01-17	ABAX-DELISTED	Stock	62.78	63.1	60.5003	61.0	187788.0
2018-01-17	ABB-DELISTED	Stock	28.03	28.03	27.84	27.905	1037257.0
2018-01-17	ABBNY-DELISTED	Stock	28.03	28.03	27.84	27.9	1093616.0
2018-01-17	ABBV	Stock	103.0	104.84	102.55	104.36	5384900.0
2018-01-17	ABC-DELISTED	Stock	99.77	101.85	99.77	101.29	1640792.0
2018-01-17	ABCB	Stock	53.45	53.63	52.6	53.55	173800.0
2018-01-17	ABCD-DELISTED	Stock	6.92	7.17	6.7788	7.09	104531.0
2018-01-17	ABDC-DELISTED	Stock	8.63	8.67	8.41	8.51	155921.0
2018-01-17	ABE-DELISTED	Stock	15.23	15.32	15.18	15.26	1026.0
2018-01-17	ABEO	Stock	375.0	388.75	371.25	381.25	23620.0
2018-01-17	ABEOW-DELISTED	Stock	10.57	10.57	10.57	10.57	100.0
2018-01-17	ABEV	Stock	6.76	6.81	6.73	6.78	14457400.0
2018-01-17	ABG	Stock	73.05	73.65	72.47	72.6	127600.0
2018-01-17	ABIL-DELISTED	Stock	0.54	0.54	0.4701	0.51	331292.0
2018-01-17	ABLX-DELISTED	Stock	41.9	42.05	41.07	41.43	432595.0
2018-01-17	ABM	Stock	38.69	38.89	38.4	38.73	405300.0

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

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