PREVIEW / stock_daily / 2018-06-18

all stock daily files

  file:    by_date/stock_daily/2018/2018-06-18.parquet
  size:    219 KB
  rows:    6,520
  symbols: 2,799

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-06-18	AAPL	Stock	46.97	47.305	46.8	47.185	73939600.0
2018-06-18	MSFT	Stock	100.01	101.11	99.42	100.86	23586000.0
2018-06-18	NVDA	Stock	6.587	6.645	6.5595	6.6272	356268000.0
2018-06-18	AMZN	Stock	85.313	86.337	85.128	86.1895	62154000.0
2018-06-18	GOOGL	Stock	57.6345	59.2065	57.55	59.179	33038260.0
2018-06-18	META	Stock	194.8	199.58	194.13	198.31	16826000.0
2018-06-18	TSLA	Stock	23.6933	24.9153	23.6333	24.722	181098000.0
2018-06-18	TLT	Stock	120.48	120.56	120.04	120.27	4893710.0
2018-06-18	ES	Stock	54.56	55.1	54.5	55.09	2393300.0
2018-06-18	CL	Stock	64.21	64.37	62.7	63.31	7904900.0
2018-06-18	A	Stock	65.48	65.54	64.53	64.97	2563100.0
2018-06-18	AA	Stock	45.01	45.87	45.0	45.78	2835700.0
2018-06-18	AABA-DELISTED	Stock	80.72	81.67	79.92	81.62	6640999.0
2018-06-18	AAC-DELISTED	Stock	9.95	10.07	9.84	9.95	108357.0
2018-06-18	AACG	Stock	5.29	5.29	5.29	5.29	200.0
2018-06-18	AAIC-DELISTED	Stock	10.77	10.88	10.63	10.64	1543787.0
2018-06-18	AAL	Stock	42.63	42.68	41.94	42.44	5372100.0
2018-06-18	AAM.A-DELISTED	Stock	25.43	25.545	25.4	25.43	24984.0
2018-06-18	AAM.B-DELISTED	Stock	24.82	24.87	24.77	24.82	76764.0
2018-06-18	AAME	Stock	2.5	2.7	2.3	2.5	4300.0
2018-06-18	AAMI	Stock	16.08	16.08	15.69	15.75	379300.0
2018-06-18	AAOI	Stock	42.89	43.49	42.15	43.47	656700.0
2018-06-18	AAON	Stock	22.0333	22.4667	21.6733	22.4	260400.0
2018-06-18	AAP	Stock	136.14	138.38	135.83	138.24	1226100.0
2018-06-18	AAT	Stock	37.39	37.69	37.28	37.57	162400.0
2018-06-18	AAU-DELISTED	Stock	0.76	0.76	0.7348	0.7389	65656.0
2018-06-18	AAUAF-DELISTED	Stock	0.76	0.76	0.7348	0.7389	70872.0
2018-06-18	AAV-DELISTED	Stock	3.05	3.175	3.0	3.15	211591.0
2018-06-18	AAWW-DELISTED	Stock	72.5	73.4	72.15	73.3	90790.0
2018-06-18	AAXJ	Stock	74.76	74.89	74.349	74.84	1037962.0
2018-06-18	AAXN-DELISTED	Stock	64.4	66.2199	63.77	66.12	895454.0
2018-06-18	AB	Stock	29.1	29.5	29.05	29.5	225500.0
2018-06-18	ABAC-DELISTED	Stock	2.25	2.3	2.1901	2.2822	10740.0
2018-06-18	ABAX-DELISTED	Stock	83.14	83.22	83.0	83.005	65252.0
2018-06-18	ABB-DELISTED	Stock	22.51	22.7099	22.485	22.655	1402194.0
2018-06-18	ABBNY-DELISTED	Stock	22.51	22.7099	22.485	22.65	1471267.0
2018-06-18	ABBV	Stock	99.15	99.33	98.31	98.48	6425600.0
2018-06-18	ABC-DELISTED	Stock	94.27	94.41	91.31	91.58	1061478.0
2018-06-18	ABCB	Stock	55.95	57.15	55.65	56.6	137800.0
2018-06-18	ABCD-DELISTED	Stock	10.82	11.05	10.75	10.99	103347.0
2018-06-18	ABDC-DELISTED	Stock	6.74	6.8029	6.7	6.74	21020.0
2018-06-18	ABEO	Stock	405.0	410.0	388.5	397.5	28264.0
2018-06-18	ABEOW-DELISTED	Stock	10.9147	11.13	10.9147	11.13	250.0
2018-06-18	ABEV	Stock	4.89	5.0	4.84	4.99	36763200.0
2018-06-18	ABG	Stock	73.2	74.75	73.2	74.15	202000.0
2018-06-18	ABIL-DELISTED	Stock	2.311	2.3215	2.261	2.261	5047.0
2018-06-18	ABM	Stock	30.93	31.16	30.72	30.95	795900.0
2018-06-18	ABMD-DELISTED	Stock	440.09	446.81	435.77	443.1	504333.0
2018-06-18	ABR	Stock	9.95	10.27	9.95	10.21	1897800.0
2018-06-18	ABR.A-DELISTED	Stock	26.07	26.07	26.0	26.01	765.0

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

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