PREVIEW / stock_daily / 2013-07-19

all stock daily files

  file:    by_date/stock_daily/2013/2013-07-19.parquet
  size:    210 KB
  rows:    6,297
  symbols: 3,487

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-07-19	AAPL	Stock	15.4679	15.4993	15.1554	15.1768	268721600.0
2013-07-19	MSFT	Stock	32.4	32.67	31.02	31.4	248428500.0
2013-07-19	NVDA	Stock	0.3615	0.3632	0.3522	0.356	480532000.0
2013-07-19	AMZN	Stock	15.2195	15.2895	15.0955	15.2615	59462000.0
2013-07-19	META	Stock	25.82	26.11	25.6	25.88	46539700.0
2013-07-19	TSLA	Stock	7.9	8.0367	7.7673	7.9787	88354500.0
2013-07-19	TLT	Stock	108.31	109.21	108.255	109.2	8523728.0
2013-07-19	ES	Stock	44.73	44.85	44.46	44.83	1115400.0
2013-07-19	CL	Stock	58.47	58.92	58.25	58.88	3135900.0
2013-07-19	A	Stock	32.7825	33.1044	32.6824	33.0472	1648801.0
2013-07-19	AABA-DELISTED	Stock	29.38	29.715	29.04	29.095	20584652.0
2013-07-19	AACG	Stock	4.72	4.88	4.72	4.73	1100.0
2013-07-19	AAIC-DELISTED	Stock	26.42	26.74	26.32	26.72	92051.0
2013-07-19	AAMC-DELISTED	Stock	83.8235	88.2353	83.8235	88.2353	5100.0
2013-07-19	AAME	Stock	3.65	3.74	3.6	3.69	8900.0
2013-07-19	AAMRQ-DELISTED	Stock	5.845	5.85	5.47	5.47	5920956.0
2013-07-19	AAON	Stock	10.6622	10.6711	10.5156	10.5644	190575.0
2013-07-19	AAP	Stock	82.15	82.74	82.01	82.21	355900.0
2013-07-19	AAT	Stock	33.84	33.94	33.63	33.76	73500.0
2013-07-19	AAU-DELISTED	Stock	1.44	1.55	1.44	1.53	102057.0
2013-07-19	AAUAF-DELISTED	Stock	1.47	1.58	1.47	1.53	100990.0
2013-07-19	AAV-DELISTED	Stock	4.21	4.33	4.21	4.31	117069.0
2013-07-19	AAWW-DELISTED	Stock	45.49	45.945	45.0201	45.8	392053.0
2013-07-19	AAXJ	Stock	55.87	55.95	55.71	55.87	351820.0
2013-07-19	AAXN-DELISTED	Stock	9.06	9.06	8.9	9.0	242941.0
2013-07-19	AB	Stock	21.19	21.79	20.92	21.75	403800.0
2013-07-19	ABAC-DELISTED	Stock	0.5723	0.6	0.5723	0.574	4100.0
2013-07-19	ABAX-DELISTED	Stock	49.75	50.42	49.75	50.27	80206.0
2013-07-19	ABB-DELISTED	Stock	22.76	22.92	22.71	22.87	978313.0
2013-07-19	ABBNY-DELISTED	Stock	22.76	22.92	22.71	22.86	1033877.0
2013-07-19	ABBV	Stock	44.49	44.91	44.12	44.52	4317900.0
2013-07-19	ABC-DELISTED	Stock	58.25	58.905	58.13	58.82	1521436.0
2013-07-19	ABCB	Stock	17.94	18.2	17.91	18.18	160300.0
2013-07-19	ABCD-DELISTED	Stock	1.32	1.38	1.24	1.3658	12101.0
2013-07-19	ABCO-DELISTED	Stock	55.39	56.15	54.78	56.14	126788.0
2013-07-19	ABCW-DELISTED	Stock	0.4	0.5	0.4	0.401	36075.0
2013-07-19	ABE-DELISTED	Stock	19.91	20.04	19.81	20.04	8046.0
2013-07-19	ABEO	Stock	500.0	525.0	487.5	525.0	32.0
2013-07-19	ABFS-DELISTED	Stock	22.83	23.04	22.33	22.49	438999.0
2013-07-19	ABG	Stock	44.99	45.07	44.16	44.64	280900.0
2013-07-19	ABM	Stock	26.13	26.68	26.01	26.6	353800.0
2013-07-19	ABMD-DELISTED	Stock	24.24	24.64	24.09	24.51	310922.0
2013-07-19	ABR	Stock	7.37	7.48	7.34	7.45	371200.0
2013-07-19	ABR.A-DELISTED	Stock	25.3483	25.4	25.3483	25.3799	3800.0
2013-07-19	ABR.B-DELISTED	Stock	24.01	24.01	23.88	24.0	1600.0
2013-07-19	ABT	Stock	35.73	35.89	35.52	35.87	7137500.0
2013-07-19	ABTL-DELISTED	Stock	5.14	5.15	5.1399	5.15	1500.0
2013-07-19	ABUS	Stock	5.15	5.2	5.1	5.16	40800.0
2013-07-19	ABV-DELISTED	Stock	35.79	35.95	35.63	35.77	1405176.0
2013-07-19	ABX-DELISTED	Stock	15.89	16.57	15.8	16.54	16042863.0

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

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