PREVIEW / stock_daily / 2010-04-16

all stock daily files

  file:    by_date/stock_daily/2010/2010-04-16.parquet
  size:    193 KB
  rows:    5,948
  symbols: 3,509

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
2010-04-16	AAPL	Stock	8.8775	8.9693	8.7339	8.8357	750545600.0
2010-04-16	MSFT	Stock	30.79	30.98	30.6	30.67	88703100.0
2010-04-16	NVDA	Stock	0.432	0.4338	0.417	0.4265	1917736000.0
2010-04-16	AMZN	Stock	7.244	7.3585	7.0725	7.1085	167936000.0
2010-04-16	TLT	Stock	89.4	89.99	89.24	89.86	8305705.0
2010-04-16	ES	Stock	27.81	27.98	27.36	27.38	1361700.0
2010-04-16	CL	Stock	41.995	42.37	41.85	42.125	5536400.0
2010-04-16	A	Stock	25.422	25.6795	25.0858	25.2289	8066180.0
2010-04-16	AABA-DELISTED	Stock	18.68	18.68	17.96	18.17	49643658.0
2010-04-16	AACC-DELISTED	Stock	6.79	6.87	6.75	6.84	22573.0
2010-04-16	AACG	Stock	3.52	3.56	3.52	3.55	6300.0
2010-04-16	AAI-DELISTED	Stock	5.93	5.93	5.62	5.71	3213923.0
2010-04-16	AAIC-DELISTED	Stock	20.3791	20.38	20.02	20.14	107850.0
2010-04-16	AAME	Stock	1.5	1.54	1.45	1.45	20300.0
2010-04-16	AAON	Stock	4.6637	4.6914	4.5926	4.6598	250087.0
2010-04-16	AAP	Stock	45.12	45.27	44.77	45.04	1932000.0
2010-04-16	AATI-DELISTED	Stock	4.04	4.1	3.86	4.06	238527.0
2010-04-16	AAU-DELISTED	Stock	1.0401	1.11	1.03	1.07	244728.0
2010-04-16	AAUAF-DELISTED	Stock	1.0401	1.11	1.03	1.07	245012.0
2010-04-16	AAV-DELISTED	Stock	6.95	7.03	6.82	6.98	482883.0
2010-04-16	AAWW-DELISTED	Stock	58.89	59.25	56.31	56.9	309087.0
2010-04-16	AAXJ	Stock	58.37	58.39	57.275	57.59	180478.0
2010-04-16	AAXN-DELISTED	Stock	5.37	5.3985	5.21	5.21	981293.0
2010-04-16	AB	Stock	33.3	33.3	31.4	31.98	633300.0
2010-04-16	ABAX-DELISTED	Stock	27.0	27.0	26.31	26.62	115797.0
2010-04-16	ABB-DELISTED	Stock	22.48	22.56	22.11	22.3	1865454.0
2010-04-16	ABBC-DELISTED	Stock	8.46	8.51	8.39	8.48	53351.0
2010-04-16	ABBNY-DELISTED	Stock	22.48	22.56	22.11	22.32	1876742.0
2010-04-16	ABC-DELISTED	Stock	29.5	29.92	29.36	29.9	5986145.0
2010-04-16	ABCB	Stock	10.3109	10.4502	10.291	10.4403	134638.0
2010-04-16	ABCD-DELISTED	Stock	5.1	5.25	5.06	5.18	38539.0
2010-04-16	ABCO-DELISTED	Stock	16.822	16.912	16.498	16.693	98337.0
2010-04-16	ABCW-DELISTED	Stock	0.9822	1.0294	0.9444	1.02	121270.0
2010-04-16	ABD-DELISTED	Stock	7.705	7.945	7.395	7.405	230390.0
2010-04-16	ABE-DELISTED	Stock	17.13	17.23	16.8815	17.05	12228.0
2010-04-16	ABEO	Stock	3437.5	3500.0	3375.0	3500.0	24.0
2010-04-16	ABFS-DELISTED	Stock	30.11	30.33	29.41	29.92	337303.0
2010-04-16	ABG	Stock	13.96	14.27	13.75	13.86	376600.0
2010-04-16	ABII-DELISTED	Stock	51.23	51.33	50.56	50.99	47021.0
2010-04-16	ABK-DELISTED	Stock	1.72	2.04	1.56	1.75	161518771.0
2010-04-16	ABM	Stock	21.42	21.59	21.22	21.36	140600.0
2010-04-16	ABMD-DELISTED	Stock	9.5	9.51	9.2	9.2	262570.0
2010-04-16	ABR	Stock	4.04	4.1	3.8	3.85	210400.0
2010-04-16	ABT	Stock	25.0648	25.1703	24.9592	25.0743	16562734.0
2010-04-16	ABTL-DELISTED	Stock	4.8039	5.0036	4.7034	4.9961	7173.0
2010-04-16	ABV-DELISTED	Stock	98.07	99.23	97.06	97.3	398771.0
2010-04-16	ABVA-DELISTED	Stock	2.84	2.85	2.58	2.73	7949.0
2010-04-16	ABVT-DELISTED	Stock	53.21	53.74	51.8001	52.2	174761.0
2010-04-16	ABX-DELISTED	Stock	39.61	39.92	38.44	39.12	13507031.0
2010-04-16	ACAD	Stock	1.77	1.79	1.63	1.7	492200.0

> showing 50 of 5,948 rows — these rows as CSV

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