PREVIEW / stock_daily / 2013-09-25

all stock daily files

  file:    by_date/stock_daily/2013/2013-09-25.parquet
  size:    213 KB
  rows:    6,389
  symbols: 3,537

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
2013-09-25	AAPL	Stock	17.4714	17.4871	17.1939	17.1975	316957200.0
2013-09-25	MSFT	Stock	32.49	32.8	32.4	32.51	28907500.0
2013-09-25	NVDA	Stock	0.3918	0.396	0.39	0.393	233156000.0
2013-09-25	AMZN	Stock	15.7265	15.8355	15.5375	15.6325	40172000.0
2013-09-25	META	Stock	49.23	49.54	48.46	49.46	87879700.0
2013-09-25	TSLA	Stock	12.2373	12.42	12.0333	12.3493	123790500.0
2013-09-25	TLT	Stock	106.54	107.279	106.39	107.05	8130878.0
2013-09-25	ES	Stock	41.61	41.81	41.32	41.34	1313700.0
2013-09-25	CL	Stock	60.02	60.13	59.29	59.34	2714500.0
2013-09-25	A	Stock	36.9027	37.289	36.7954	37.0744	4005410.0
2013-09-25	AABA-DELISTED	Stock	31.4	32.03	31.12	31.33	18761112.0
2013-09-25	AACG	Stock	4.59	4.98	4.59	4.83	15000.0
2013-09-25	AAIC-DELISTED	Stock	26.46	26.98	26.43	26.72	394063.0
2013-09-25	AAMC-DELISTED	Stock	130.5294	139.7765	126.4706	139.7765	31028.0
2013-09-25	AAME	Stock	4.03	4.05	4.01	4.01	7800.0
2013-09-25	AAMRQ-DELISTED	Stock	4.18	4.5	4.17	4.49	11180816.0
2013-09-25	AAON	Stock	11.6622	11.84	11.56	11.7467	91125.0
2013-09-25	AAP	Stock	80.13	81.57	79.97	81.46	768900.0
2013-09-25	AAT	Stock	30.79	31.2	30.71	30.92	181200.0
2013-09-25	AAU-DELISTED	Stock	1.38	1.4251	1.33	1.4	191043.0
2013-09-25	AAUAF-DELISTED	Stock	1.38	1.42	1.33	1.4	192017.0
2013-09-25	AAV-DELISTED	Stock	3.67	3.77	3.67	3.68	123169.0
2013-09-25	AAWW-DELISTED	Stock	45.68	45.84	45.04	45.29	205435.0
2013-09-25	AAXJ	Stock	59.47	59.47	58.92	59.02	1046761.0
2013-09-25	AAXN-DELISTED	Stock	14.66	15.3	14.66	14.97	1203144.0
2013-09-25	AB	Stock	19.95	20.0	19.61	19.63	314600.0
2013-09-25	ABAC-DELISTED	Stock	0.7999	0.815	0.7699	0.7749	19400.0
2013-09-25	ABAX-DELISTED	Stock	41.82	42.21	41.54	41.75	118300.0
2013-09-25	ABB-DELISTED	Stock	23.72	23.89	23.7	23.79	1017978.0
2013-09-25	ABBNY-DELISTED	Stock	23.72	23.89	23.7	23.8	1055216.0
2013-09-25	ABBV	Stock	46.09	46.16	45.02	45.33	4571900.0
2013-09-25	ABC-DELISTED	Stock	60.83	61.33	60.83	61.0	1031028.0
2013-09-25	ABCB	Stock	18.06	19.04	18.01	18.82	62000.0
2013-09-25	ABCD-DELISTED	Stock	1.51	1.6001	1.51	1.57	102345.0
2013-09-25	ABCO-DELISTED	Stock	59.47	59.47	58.004	58.246	193652.0
2013-09-25	ABE-DELISTED	Stock	19.67	19.79	19.67	19.721	7196.0
2013-09-25	ABEO	Stock	500.0	500.0	425.0	475.0	29.0
2013-09-25	ABFS-DELISTED	Stock	25.65	26.03	25.12	25.55	273267.0
2013-09-25	ABG	Stock	53.18	53.84	52.93	53.62	300200.0
2013-09-25	ABM	Stock	26.43	26.67	26.3	26.34	161700.0
2013-09-25	ABMD-DELISTED	Stock	20.35	20.9	18.875	18.93	827207.0
2013-09-25	ABR	Stock	6.91	6.94	6.81	6.91	459100.0
2013-09-25	ABR.A-DELISTED	Stock	24.73	24.73	24.51	24.51	600.0
2013-09-25	ABR.B-DELISTED	Stock	23.5	23.5	23.24	23.48	2981.0
2013-09-25	ABT	Stock	34.32	34.35	33.35	33.67	26193500.0
2013-09-25	ABTL-DELISTED	Stock	7.3711	7.5167	7.108	7.3	57261.0
2013-09-25	ABUS	Stock	7.2	7.66	6.76	7.16	415900.0
2013-09-25	ABV-DELISTED	Stock	38.81	38.91	38.44	38.57	2018990.0
2013-09-25	ABX-DELISTED	Stock	18.61	19.04	18.4	18.67	13948595.0
2013-09-25	ACAD	Stock	25.03	25.18	24.67	24.67	915700.0

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

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