PREVIEW / stock_daily / 2015-10-23

all stock daily files

  file:    by_date/stock_daily/2015/2015-10-23.parquet
  size:    222 KB
  rows:    6,627
  symbols: 3,419

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
2015-10-23	AAPL	Stock	29.175	29.8075	29.0825	29.77	237467600.0
2015-10-23	MSFT	Stock	52.3	54.07	52.25	52.87	135227100.0
2015-10-23	NVDA	Stock	0.7163	0.7195	0.7055	0.7148	381776000.0
2015-10-23	AMZN	Stock	30.884	30.9725	29.768	29.9515	213854000.0
2015-10-23	GOOGL	Stock	37.503	37.625	35.897	35.9665	126726380.0
2015-10-23	META	Stock	101.91	102.85	100.16	102.19	42809700.0
2015-10-23	TSLA	Stock	14.3333	14.3567	13.846	13.9393	63532500.0
2015-10-23	TLT	Stock	123.1	123.455	122.85	123.2	7058213.0
2015-10-23	ES	Stock	52.61	52.68	51.64	51.72	1017400.0
2015-10-23	CL	Stock	68.72	69.2	68.35	68.94	3956700.0
2015-10-23	A	Stock	36.5	37.27	36.18	37.11	2732600.0
2015-10-23	AA.B-DELISTED	Stock	33.37	33.56	33.1	33.18	66971.0
2015-10-23	AABA-DELISTED	Stock	32.65	33.36	32.24	33.18	23326780.0
2015-10-23	AAC-DELISTED	Stock	26.08	27.0991	25.76	25.99	103802.0
2015-10-23	AACG	Stock	3.73	4.0	3.73	3.89	19300.0
2015-10-23	AAIC-DELISTED	Stock	15.37	15.41	15.12	15.12	201013.0
2015-10-23	AAL	Stock	46.37	46.42	43.81	45.67	20281400.0
2015-10-23	AAMC-DELISTED	Stock	8.4529	8.4676	7.6324	7.8529	34867.0
2015-10-23	AAME	Stock	4.38	4.38	4.28	4.3	2000.0
2015-10-23	AAMI	Stock	15.02	15.55	14.96	15.4	321300.0
2015-10-23	AAOI	Stock	19.53	19.95	19.06	19.76	370000.0
2015-10-23	AAON	Stock	14.2467	14.3467	14.0467	14.3333	89250.0
2015-10-23	AAP	Stock	193.71	193.79	189.0	191.94	571700.0
2015-10-23	AAT	Stock	43.4	43.7	43.07	43.5	208200.0
2015-10-23	AAU-DELISTED	Stock	0.59	0.6	0.5662	0.57	87655.0
2015-10-23	AAUAF-DELISTED	Stock	0.59	0.6	0.5662	0.57	88348.0
2015-10-23	AAV-DELISTED	Stock	5.91	5.93	5.76	5.82	154153.0
2015-10-23	AAVL-DELISTED	Stock	7.72	7.93	7.53	7.65	292065.0
2015-10-23	AAWW-DELISTED	Stock	41.78	41.83	41.05	41.21	226559.0
2015-10-23	AAXJ	Stock	58.77	58.94	58.5	58.77	507464.0
2015-10-23	AAXN-DELISTED	Stock	22.17	22.62	21.999	22.36	905821.0
2015-10-23	AB	Stock	27.52	27.66	27.12	27.41	359900.0
2015-10-23	ABAC-DELISTED	Stock	0.6	0.6399	0.6	0.63	22224.0
2015-10-23	ABAX-DELISTED	Stock	42.57	43.655	42.22	43.05	297504.0
2015-10-23	ABB-DELISTED	Stock	18.65	18.665	18.55	18.59	2683544.0
2015-10-23	ABBNY-DELISTED	Stock	18.65	18.665	18.4672	18.6	4806634.0
2015-10-23	ABBV	Stock	49.41	51.73	48.64	50.34	26214800.0
2015-10-23	ABC-DELISTED	Stock	93.65	94.29	92.4	93.13	2361108.0
2015-10-23	ABCB	Stock	29.03	30.38	29.03	30.15	220600.0
2015-10-23	ABCD-DELISTED	Stock	4.95	5.0	4.92	4.96	26172.0
2015-10-23	ABCO-DELISTED	Stock	45.42	45.42	43.95	44.26	367639.0
2015-10-23	ABCW-DELISTED	Stock	42.14	42.4	41.84	42.02	7503.0
2015-10-23	ABDC-DELISTED	Stock	12.49	12.7934	12.128	12.25	24436.0
2015-10-23	ABE-DELISTED	Stock	11.55	11.55	11.522	11.522	736.0
2015-10-23	ABEO	Stock	98.75	101.75	93.75	100.75	5228.0
2015-10-23	ABEOW-DELISTED	Stock	1.517	1.517	1.4	1.41	3218.0
2015-10-23	ABEV	Stock	5.02	5.07	5.01	5.04	12040800.0
2015-10-23	ABG	Stock	79.88	80.85	78.81	80.55	305900.0
2015-10-23	ABGB-DELISTED	Stock	4.8	4.8	4.7	4.74	66377.0
2015-10-23	ABIL-DELISTED	Stock	10.1	10.1	10.0	10.0	4728.0

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

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