PREVIEW / stock_daily / 2010-04-27

all stock daily files

  file:    by_date/stock_daily/2010/2010-04-27.parquet
  size:    195 KB
  rows:    6,001
  symbols: 3,541

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-27	AAPL	Stock	9.5454	9.5657	9.3043	9.3586	709343600.0
2010-04-27	MSFT	Stock	30.95	31.25	30.75	30.85	68730900.0
2010-04-27	NVDA	Stock	0.412	0.4162	0.402	0.4032	606704000.0
2010-04-27	AMZN	Stock	7.2775	7.322	7.0555	7.101	172780000.0
2010-04-27	TLT	Stock	90.85	91.92	90.7	91.48	13199242.0
2010-04-27	ES	Stock	27.48	27.58	27.0	27.02	1515100.0
2010-04-27	CL	Stock	41.9	42.28	41.75	41.795	4482200.0
2010-04-27	A	Stock	26.1803	26.4378	25.8441	25.9084	6097377.0
2010-04-27	AABA-DELISTED	Stock	17.26	17.36	16.88	16.92	22549560.0
2010-04-27	AACC-DELISTED	Stock	7.3	7.39	7.3	7.32	13593.0
2010-04-27	AACG	Stock	3.5	3.58	3.5	3.5	1300.0
2010-04-27	AAI-DELISTED	Stock	5.48	5.6	5.355	5.38	6551097.0
2010-04-27	AAIC-DELISTED	Stock	20.65	20.65	20.3	20.5375	20811.0
2010-04-27	AAME	Stock	1.56	1.65	1.56	1.65	5300.0
2010-04-27	AAON	Stock	4.6519	4.6973	4.5551	4.5926	400950.0
2010-04-27	AAP	Stock	46.28	46.5	45.11	45.24	990700.0
2010-04-27	AATI-DELISTED	Stock	4.01	4.01	3.8	3.86	604579.0
2010-04-27	AAU-DELISTED	Stock	1.11	1.18	1.11	1.13	111651.0
2010-04-27	AAUAF-DELISTED	Stock	1.11	1.18	1.11	1.13	112751.0
2010-04-27	AAV-DELISTED	Stock	7.34	7.48	7.19	7.2	471444.0
2010-04-27	AAWW-DELISTED	Stock	58.23	58.45	56.42	56.96	454061.0
2010-04-27	AAXJ	Stock	57.91	57.91	56.54	56.7	330686.0
2010-04-27	AAXN-DELISTED	Stock	4.92	5.07	4.8	4.96	2853132.0
2010-04-27	AB	Stock	32.74	32.96	31.55	31.67	357100.0
2010-04-27	ABAX-DELISTED	Stock	26.72	27.3275	26.52	26.57	121491.0
2010-04-27	ABB-DELISTED	Stock	20.22	20.32	19.58	19.67	7123318.0
2010-04-27	ABBC-DELISTED	Stock	9.11	9.46	9.11	9.27	66911.0
2010-04-27	ABBNY-DELISTED	Stock	20.22	20.32	19.58	19.67	7445338.0
2010-04-27	ABC-DELISTED	Stock	31.0	31.39	30.77	30.84	3381576.0
2010-04-27	ABCB	Stock	10.9877	11.1668	10.7986	10.9777	161566.0
2010-04-27	ABCD-DELISTED	Stock	5.36	5.36	5.1	5.25	50854.0
2010-04-27	ABCO-DELISTED	Stock	17.116	17.191	16.464	16.614	166554.0
2010-04-27	ABCW-DELISTED	Stock	1.34	1.39	1.16	1.19	468190.0
2010-04-27	ABD-DELISTED	Stock	9.05	9.43	8.98	9.15	1069590.0
2010-04-27	ABE-DELISTED	Stock	16.92	17.07	16.76	16.8	30698.0
2010-04-27	ABEO	Stock	3437.5	3450.0	3325.0	3325.0	30.0
2010-04-27	ABFS-DELISTED	Stock	32.47	33.52	31.27	31.36	761055.0
2010-04-27	ABG	Stock	15.09	15.1	14.33	14.35	358100.0
2010-04-27	ABII-DELISTED	Stock	51.81	52.22	50.5	50.66	72732.0
2010-04-27	ABK-DELISTED	Stock	1.76	1.82	1.64	1.65	42286657.0
2010-04-27	ABM	Stock	21.87	22.24	21.68	21.77	144100.0
2010-04-27	ABMD-DELISTED	Stock	9.35	9.45	9.21	9.22	155659.0
2010-04-27	ABR	Stock	4.47	4.47	4.13	4.16	221000.0
2010-04-27	ABT	Stock	24.1243	24.2587	23.8365	23.8796	21777199.0
2010-04-27	ABTL-DELISTED	Stock	3.9382	4.407	3.66	4.3118	39884.0
2010-04-27	ABV-DELISTED	Stock	99.38	99.7	96.59	96.74	447392.0
2010-04-27	ABVA-DELISTED	Stock	3.13	3.38	3.1	3.38	3400.0
2010-04-27	ABVT-DELISTED	Stock	49.38	50.75	48.36	49.2	177078.0
2010-04-27	ABX-DELISTED	Stock	39.93	40.94	39.79	40.64	10505444.0
2010-04-27	ACAD	Stock	1.68	1.69	1.61	1.62	285300.0

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

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