PREVIEW / stock_daily / 2018-01-04

all stock daily files

  file:    by_date/stock_daily/2018/2018-01-04.parquet
  size:    218 KB
  rows:    6,508
  symbols: 2,898

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-04	AAPL	Stock	43.135	43.3675	43.02	43.2575	89738400.0
2018-01-04	MSFT	Stock	86.59	87.66	86.57	87.11	21912000.0
2018-01-04	NVDA	Stock	5.394	5.4513	5.3173	5.3398	583268000.0
2018-01-04	AMZN	Stock	60.25	60.7935	60.233	60.4795	60442000.0
2018-01-04	GOOGL	Stock	54.8545	55.2038	54.713	54.788	26051380.0
2018-01-04	META	Stock	184.9	186.21	184.1	184.33	13880900.0
2018-01-04	TSLA	Stock	20.858	21.2367	20.3787	20.9747	149194500.0
2018-01-04	TLT	Stock	125.65	126.16	125.37	126.07	9217876.0
2018-01-04	ES	Stock	62.52	62.61	61.61	61.71	2300300.0
2018-01-04	CL	Stock	75.05	75.96	74.98	75.33	2501700.0
2018-01-04	A	Stock	69.54	69.82	68.78	68.8	2230700.0
2018-01-04	AA	Stock	54.81	55.43	54.075	54.7	3555100.0
2018-01-04	AAAP-DELISTED	Stock	81.73	81.8	81.67	81.7	410705.0
2018-01-04	AABA-DELISTED	Stock	74.1	75.215	74.01	74.62	7100949.0
2018-01-04	AAC-DELISTED	Stock	9.23	9.47	8.99	9.32	92444.0
2018-01-04	AACG	Stock	5.22	5.45	5.22	5.4	11100.0
2018-01-04	AAIC-DELISTED	Stock	11.7	11.81	11.7	11.73	336981.0
2018-01-04	AAL	Stock	52.48	54.4	52.27	52.67	3557100.0
2018-01-04	AAM.A-DELISTED	Stock	26.0596	26.09	25.8801	25.97	24854.0
2018-01-04	AAMC-DELISTED	Stock	23.5882	23.5882	23.5882	23.5882	1010.0
2018-01-04	AAME	Stock	3.35	3.4	3.25	3.25	2800.0
2018-01-04	AAMI	Stock	16.94	17.18	16.805	16.83	545000.0
2018-01-04	AAOI	Stock	37.95	38.65	37.91	38.38	696600.0
2018-01-04	AAON	Stock	25.1333	25.3333	24.6667	24.9667	345150.0
2018-01-04	AAP	Stock	107.75	111.53	107.48	111.0	2104500.0
2018-01-04	AAT	Stock	37.81	37.84	37.11	37.12	106400.0
2018-01-04	AAU-DELISTED	Stock	1.01	1.0186	0.98	0.9922	333678.0
2018-01-04	AAUAF-DELISTED	Stock	1.01	1.0186	0.98	0.98	338944.0
2018-01-04	AAV-DELISTED	Stock	4.4	4.4	4.15	4.25	314240.0
2018-01-04	AAWW-DELISTED	Stock	58.8	59.5	57.95	59.25	164879.0
2018-01-04	AAXJ	Stock	78.63	78.81	78.55	78.69	928089.0
2018-01-04	AAXN-DELISTED	Stock	26.8	26.89	26.5	26.84	310000.0
2018-01-04	AB	Stock	25.5	26.0	25.45	25.85	309800.0
2018-01-04	ABAC-DELISTED	Stock	2.9	2.9	2.7	2.75	6568.0
2018-01-04	ABAX-DELISTED	Stock	49.7	50.21	49.05	49.5	153287.0
2018-01-04	ABB-DELISTED	Stock	27.31	27.49	27.29	27.45	1712698.0
2018-01-04	ABBNY-DELISTED	Stock	27.31	27.49	27.29	27.45	2236005.0
2018-01-04	ABBV	Stock	100.07	100.12	98.35	99.38	3579000.0
2018-01-04	ABC-DELISTED	Stock	94.64	94.83	92.86	94.17	1534290.0
2018-01-04	ABCB	Stock	48.85	49.8	48.85	49.25	378800.0
2018-01-04	ABCD-DELISTED	Stock	5.99	6.05	5.85	5.9	77051.0
2018-01-04	ABDC-DELISTED	Stock	8.49	8.6231	8.49	8.56	74183.0
2018-01-04	ABE-DELISTED	Stock	14.95	15.04	14.9298	14.98	6678.0
2018-01-04	ABEO	Stock	435.0	437.5	414.0	420.0	17732.0
2018-01-04	ABEOW-DELISTED	Stock	12.13	12.13	12.13	12.13	100.0
2018-01-04	ABEV	Stock	6.68	6.72	6.59	6.64	10704000.0
2018-01-04	ABG	Stock	63.85	64.55	62.5	64.1	266700.0
2018-01-04	ABIL-DELISTED	Stock	0.453	0.4798	0.4515	0.4601	51220.0
2018-01-04	ABLX-DELISTED	Stock	24.64	25.18	24.64	25.03	278088.0
2018-01-04	ABM	Stock	37.8	38.5	37.8	38.33	488600.0

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

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