PREVIEW / stock_daily / 2013-07-24

all stock daily files

  file:    by_date/stock_daily/2013/2013-07-24.parquet
  size:    212 KB
  rows:    6,346
  symbols: 3,508

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-24	AAPL	Stock	15.6761	15.8782	15.545	15.7325	591936800.0
2013-07-24	MSFT	Stock	32.04	32.19	31.89	31.96	52803100.0
2013-07-24	NVDA	Stock	0.3585	0.3595	0.3548	0.3553	284252000.0
2013-07-24	AMZN	Stock	15.151	15.192	14.902	14.947	40010000.0
2013-07-24	META	Stock	26.32	26.53	26.05	26.51	82635600.0
2013-07-24	TSLA	Stock	8.298	8.3	7.9707	8.1133	103035000.0
2013-07-24	TLT	Stock	107.65	107.89	106.79	107.52	8853022.0
2013-07-24	ES	Stock	44.95	44.95	44.06	44.17	1005400.0
2013-07-24	CL	Stock	58.5	58.66	58.2	58.47	3935200.0
2013-07-24	A	Stock	33.3834	33.4835	33.2546	33.4478	2560437.0
2013-07-24	AABA-DELISTED	Stock	27.53	27.92	27.23	27.85	22429568.0
2013-07-24	AACG	Stock	5.28	5.28	4.75	4.75	8500.0
2013-07-24	AAIC-DELISTED	Stock	26.5	26.5	25.88	25.91	126491.0
2013-07-24	AAMC-DELISTED	Stock	94.2647	94.2647	94.2647	94.2647	1989.0
2013-07-24	AAME	Stock	3.71	3.74	3.65	3.65	3500.0
2013-07-24	AAMRQ-DELISTED	Stock	5.358	5.76	5.34	5.61	9843669.0
2013-07-24	AAON	Stock	10.3244	10.3244	10.1511	10.1778	175275.0
2013-07-24	AAP	Stock	82.82	82.95	81.27	81.53	518000.0
2013-07-24	AAT	Stock	34.04	34.15	33.0	33.18	100300.0
2013-07-24	AAU-DELISTED	Stock	1.8	1.8027	1.69	1.69	132823.0
2013-07-24	AAUAF-DELISTED	Stock	1.76	1.76	1.65	1.69	140437.0
2013-07-24	AAV-DELISTED	Stock	4.05	4.06	3.91	3.92	374641.0
2013-07-24	AAWW-DELISTED	Stock	45.53	46.4	44.8	44.82	196639.0
2013-07-24	AAXJ	Stock	57.17	57.17	56.39	56.66	320299.0
2013-07-24	AAXN-DELISTED	Stock	8.93	9.01	8.9	8.95	132689.0
2013-07-24	AB	Stock	22.62	22.87	22.35	22.42	470300.0
2013-07-24	ABAC-DELISTED	Stock	0.628	0.628	0.58	0.6	25311.0
2013-07-24	ABAX-DELISTED	Stock	50.06	50.06	49.23	49.24	108743.0
2013-07-24	ABB-DELISTED	Stock	22.97	22.98	22.745	22.96	1276939.0
2013-07-24	ABBNY-DELISTED	Stock	22.97	22.98	22.745	22.96	1492118.0
2013-07-24	ABBV	Stock	44.28	44.37	43.39	43.64	3088100.0
2013-07-24	ABC-DELISTED	Stock	58.32	59.3	56.575	56.77	3072444.0
2013-07-24	ABCB	Stock	18.65	18.85	18.52	18.69	96500.0
2013-07-24	ABCD-DELISTED	Stock	1.3699	1.3699	1.3099	1.3099	900.0
2013-07-24	ABCO-DELISTED	Stock	57.11	58.13	56.38	56.65	135447.0
2013-07-24	ABCW-DELISTED	Stock	0.437	0.44	0.401	0.401	23685.0
2013-07-24	ABE-DELISTED	Stock	20.18	20.52	20.159	20.416	9405.0
2013-07-24	ABEO	Stock	500.0	500.0	475.0	475.0	11.0
2013-07-24	ABFS-DELISTED	Stock	21.71	22.225	21.25	21.33	264318.0
2013-07-24	ABG	Stock	47.23	47.6	46.37	46.82	339100.0
2013-07-24	ABM	Stock	26.24	26.29	25.77	25.86	223600.0
2013-07-24	ABMD-DELISTED	Stock	23.78	24.88	23.78	24.34	147403.0
2013-07-24	ABR	Stock	7.51	7.65	7.38	7.6	205400.0
2013-07-24	ABR.A-DELISTED	Stock	25.35	25.35	25.35	25.35	100.0
2013-07-24	ABR.B-DELISTED	Stock	24.45	24.45	24.22	24.39	600.0
2013-07-24	ABT	Stock	36.7	36.7	36.2	36.45	6060600.0
2013-07-24	ABTL-DELISTED	Stock	5.28	5.28	5.265	5.27	500.0
2013-07-24	ABUS	Stock	5.0	5.0	4.85	4.9	73000.0
2013-07-24	ABV-DELISTED	Stock	36.95	37.09	35.94	36.17	1964332.0
2013-07-24	ABX-DELISTED	Stock	18.0	18.06	16.84	17.165	23038085.0

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

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