PREVIEW / stock_daily / 2013-01-28

all stock daily files

  file:    by_date/stock_daily/2013/2013-01-28.parquet
  size:    206 KB
  rows:    6,243
  symbols: 3,499

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-01-28	AAPL	Stock	15.6368	16.1861	15.5664	16.0654	785517600.0
2013-01-28	MSFT	Stock	28.01	28.23	27.76	27.91	56056500.0
2013-01-28	NVDA	Stock	0.3118	0.3173	0.311	0.3153	422492000.0
2013-01-28	AMZN	Stock	14.189	14.224	13.72	13.802	86428000.0
2013-01-28	META	Stock	31.88	32.51	31.81	32.47	59682500.0
2013-01-28	TSLA	Stock	2.4573	2.5807	2.4573	2.5353	29790000.0
2013-01-28	TLT	Stock	117.02	117.72	117.0	117.6	6060021.0
2013-01-28	ES	Stock	40.37	40.39	40.04	40.25	1242500.0
2013-01-28	CL	Stock	55.095	55.235	54.62	55.075	3188000.0
2013-01-28	A	Stock	32.3247	32.4964	32.1316	32.3176	3315077.0
2013-01-28	AABA-DELISTED	Stock	20.5	20.5	20.2	20.3	38525283.0
2013-01-28	AACC-DELISTED	Stock	4.99	5.2	4.99	5.1	19400.0
2013-01-28	AACG	Stock	5.6	5.6	5.5	5.57	2600.0
2013-01-28	AAIC-DELISTED	Stock	22.98	23.14	22.89	23.12	102440.0
2013-01-28	AAMC-DELISTED	Stock	33.8294	35.2941	33.8294	35.1029	65362.0
2013-01-28	AAME	Stock	3.22	3.39	3.22	3.33	6200.0
2013-01-28	AAMRQ-DELISTED	Stock	1.37	1.37	1.21	1.25	9405475.0
2013-01-28	AAON	Stock	6.6874	6.7615	6.64	6.6756	198113.0
2013-01-28	AAP	Stock	75.42	76.71	75.25	75.94	1043500.0
2013-01-28	AAT	Stock	28.66	28.84	28.45	28.62	235300.0
2013-01-28	AAU-DELISTED	Stock	2.87	2.87	2.77	2.77	142046.0
2013-01-28	AAUAF-DELISTED	Stock	2.87	2.87	2.76	2.76	142196.0
2013-01-28	AAV-DELISTED	Stock	2.99	2.99	2.92	2.94	224828.0
2013-01-28	AAWW-DELISTED	Stock	46.92	46.92	46.3501	46.8	269643.0
2013-01-28	AAXJ	Stock	60.12	60.12	59.75	59.9	951921.0
2013-01-28	AAXN-DELISTED	Stock	9.18	9.24	8.7	8.825	1061227.0
2013-01-28	AB	Stock	20.79	20.81	20.26	20.33	329600.0
2013-01-28	ABAC-DELISTED	Stock	0.9609	0.9609	0.88	0.89	10862.0
2013-01-28	ABAX-DELISTED	Stock	39.84	40.1	39.49	39.57	55116.0
2013-01-28	ABB-DELISTED	Stock	21.38	21.39	21.29	21.3	1410750.0
2013-01-28	ABBNY-DELISTED	Stock	21.38	21.39	21.29	21.29	1582760.0
2013-01-28	ABBV	Stock	37.65	37.87	36.71	36.89	7140100.0
2013-01-28	ABC-DELISTED	Stock	45.06	45.21	44.865	45.11	1986655.0
2013-01-28	ABCB	Stock	13.2	13.25	13.13	13.18	71200.0
2013-01-28	ABCD-DELISTED	Stock	1.2	1.32	1.2	1.32	14657.0
2013-01-28	ABCO-DELISTED	Stock	53.97	54.77	53.82	54.37	165567.0
2013-01-28	ABCW-DELISTED	Stock	0.6	0.67	0.6	0.64	43626.0
2013-01-28	ABE-DELISTED	Stock	22.01	22.0101	21.7275	21.765	37470.0
2013-01-28	ABEO	Stock	450.0	450.0	387.5	450.0	31.0
2013-01-28	ABFS-DELISTED	Stock	11.15	11.2	10.93	11.11	192373.0
2013-01-28	ABG	Stock	34.53	34.74	33.86	34.45	187900.0
2013-01-28	ABM	Stock	21.86	22.0	21.67	21.85	316800.0
2013-01-28	ABMD-DELISTED	Stock	13.23	13.769	13.18	13.61	750603.0
2013-01-28	ABR	Stock	7.12	7.17	6.85	7.01	235100.0
2013-01-28	ABT	Stock	32.81	33.11	32.75	33.0	13671600.0
2013-01-28	ABTL-DELISTED	Stock	4.09	4.12	3.961	4.09	17648.0
2013-01-28	ABUS	Stock	4.68	4.72	4.63	4.63	24900.0
2013-01-28	ABV-DELISTED	Stock	45.52	45.69	45.15	45.45	1935695.0
2013-01-28	ABX-DELISTED	Stock	32.87	32.9	32.45	32.55	6965292.0
2013-01-28	ACAD	Stock	6.5	6.88	6.23	6.66	7563600.0

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

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