PREVIEW / stock_daily / 2018-08-10

all stock daily files

  file:    by_date/stock_daily/2018/2018-08-10.parquet
  size:    217 KB
  rows:    6,483
  symbols: 2,736

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-08-10	AAPL	Stock	51.84	52.275	51.6675	51.8825	98444800.0
2018-08-10	MSFT	Stock	109.42	109.69	108.38	109.0	18183700.0
2018-08-10	NVDA	Stock	6.3288	6.4025	6.3175	6.3698	256396000.0
2018-08-10	AMZN	Stock	94.4255	94.975	93.9105	94.315	72798000.0
2018-08-10	GOOGL	Stock	62.959	63.06	62.3582	62.6255	26687740.0
2018-08-10	META	Stock	182.04	182.1	179.42	180.26	21500400.0
2018-08-10	TSLA	Stock	23.6	24.0	23.0667	23.6993	173280000.0
2018-08-10	TLT	Stock	120.37	121.05	120.28	120.66	8457940.0
2018-08-10	ES	Stock	61.3	61.8	61.2	61.35	1192400.0
2018-08-10	CL	Stock	65.76	65.85	65.27	65.43	2936600.0
2018-08-10	A	Stock	66.82	66.87	65.93	66.26	2165900.0
2018-08-10	AA	Stock	42.45	45.17	42.05	44.98	7608200.0
2018-08-10	AABA-DELISTED	Stock	69.84	71.44	69.77	70.97	17664184.0
2018-08-10	AAC-DELISTED	Stock	9.2	9.2	9.05	9.11	54750.0
2018-08-10	AACG	Stock	5.99	5.99	5.92	5.99	135700.0
2018-08-10	AAIC-DELISTED	Stock	10.21	10.28	10.15	10.18	340944.0
2018-08-10	AAL	Stock	37.75	37.79	36.45	37.26	7481700.0
2018-08-10	AAM.A-DELISTED	Stock	25.53	25.53	25.446	25.49	4379.0
2018-08-10	AAM.B-DELISTED	Stock	25.07	25.07	25.0552	25.07	7939.0
2018-08-10	AAMC-DELISTED	Stock	20.0	21.6171	19.5882	19.5882	3757.0
2018-08-10	AAME	Stock	2.55	2.6	2.55	2.55	2300.0
2018-08-10	AAMI	Stock	12.32	12.53	12.22	12.46	987100.0
2018-08-10	AAOI	Stock	39.45	43.15	38.9	42.5	2055800.0
2018-08-10	AAON	Stock	26.1667	26.3	25.9	26.0	235050.0
2018-08-10	AAP	Stock	146.84	147.91	145.12	146.35	1006400.0
2018-08-10	AAT	Stock	38.9	38.98	38.58	38.59	91000.0
2018-08-10	AAU-DELISTED	Stock	0.66	0.66	0.645	0.6492	110290.0
2018-08-10	AAUAF-DELISTED	Stock	0.66	0.66	0.645	0.645	114531.0
2018-08-10	AAV-DELISTED	Stock	3.2	3.2	3.1	3.15	43434.0
2018-08-10	AAWW-DELISTED	Stock	61.4	61.95	60.525	60.6	255021.0
2018-08-10	AAXJ	Stock	71.28	71.47	71.08	71.34	621015.0
2018-08-10	AAXN-DELISTED	Stock	59.27	61.94	58.04	61.47	607482.0
2018-08-10	AB	Stock	29.35	29.45	29.09	29.35	208400.0
2018-08-10	ABAC-DELISTED	Stock	2.27	2.4383	2.25	2.2755	8376.0
2018-08-10	ABB-DELISTED	Stock	22.64	22.69	22.53	22.6	1257348.0
2018-08-10	ABBNY-DELISTED	Stock	22.64	22.69	22.53	22.59	1306607.0
2018-08-10	ABBV	Stock	95.35	96.74	95.31	95.8	4446800.0
2018-08-10	ABC-DELISTED	Stock	83.0	83.08	81.65	81.97	1073815.0
2018-08-10	ABCB	Stock	48.6	49.1	48.4	48.85	187300.0
2018-08-10	ABCD-DELISTED	Stock	11.76	12.22	11.6615	12.03	94415.0
2018-08-10	ABDC-DELISTED	Stock	6.17	6.17	6.03	6.1	45371.0
2018-08-10	ABEO	Stock	357.5	368.75	340.0	341.25	16272.0
2018-08-10	ABEOW-DELISTED	Stock	8.9	8.9	8.9	8.9	200.0
2018-08-10	ABEV	Stock	4.93	4.96	4.88	4.9	53907500.0
2018-08-10	ABG	Stock	74.8	75.25	74.5	75.0	189700.0
2018-08-10	ABIL-DELISTED	Stock	5.05	5.4	4.55	4.7485	358281.0
2018-08-10	ABM	Stock	31.01	31.02	30.7	30.88	607100.0
2018-08-10	ABMD-DELISTED	Stock	379.46	387.79	377.11	377.82	265051.0
2018-08-10	ABR	Stock	11.5	11.51	11.42	11.44	1022300.0
2018-08-10	ABR.A-DELISTED	Stock	26.3223	26.3223	25.89	25.9451	617.0

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

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