PREVIEW / stock_daily / 2010-04-05

all stock daily files

  file:    by_date/stock_daily/2010/2010-04-05.parquet
  size:    192 KB
  rows:    5,971
  symbols: 3,522

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-05	AAPL	Stock	8.3921	8.5182	8.3846	8.5175	684507600.0
2010-04-05	MSFT	Stock	29.13	29.43	29.03	29.27	34331200.0
2010-04-05	NVDA	Stock	0.4332	0.4378	0.4328	0.437	413636000.0
2010-04-05	AMZN	Stock	6.6425	6.687	6.539	6.5745	116330000.0
2010-04-05	TLT	Stock	87.98	88.1399	87.41	87.47	5652112.0
2010-04-05	ES	Stock	28.0	28.12	27.94	28.04	709900.0
2010-04-05	CL	Stock	42.995	43.075	42.695	42.81	3914400.0
2010-04-05	A	Stock	24.7425	24.9213	24.7067	24.907	3731961.0
2010-04-05	AABA-DELISTED	Stock	16.35	16.56	16.3	16.52	9221365.0
2010-04-05	AACC-DELISTED	Stock	6.39	6.53	6.35	6.53	15795.0
2010-04-05	AACG	Stock	4.0	4.01	4.0	4.01	200.0
2010-04-05	AAI-DELISTED	Stock	5.11	5.13	5.02	5.05	3251077.0
2010-04-05	AAIC-DELISTED	Stock	18.13	18.32	17.95	18.05	27704.0
2010-04-05	AAME	Stock	1.54	1.54	1.51	1.51	5700.0
2010-04-05	AAON	Stock	4.4919	4.557	4.4405	4.557	205537.0
2010-04-05	AAP	Stock	42.46	42.97	42.42	42.67	954500.0
2010-04-05	AATI-DELISTED	Stock	3.68	3.68	3.57	3.65	228765.0
2010-04-05	AAU-DELISTED	Stock	1.0	1.0	0.92	0.98	294721.0
2010-04-05	AAUAF-DELISTED	Stock	1.0	1.0	0.92	0.98	298021.0
2010-04-05	AAV-DELISTED	Stock	7.14	7.3	7.08	7.29	495678.0
2010-04-05	AAWW-DELISTED	Stock	53.0	54.13	52.05	52.61	622642.0
2010-04-05	AAXJ	Stock	58.49	58.81	58.274	58.8	107434.0
2010-04-05	AAXN-DELISTED	Stock	5.61	5.64	5.35	5.6	3305661.0
2010-04-05	AB	Stock	31.97	32.78	31.8	32.75	676400.0
2010-04-05	ABAX-DELISTED	Stock	26.9	27.41	26.9	27.02	79850.0
2010-04-05	ABB-DELISTED	Stock	22.26	22.3	22.02	22.07	1646788.0
2010-04-05	ABBC-DELISTED	Stock	8.01	8.18	8.01	8.14	35697.0
2010-04-05	ABBNY-DELISTED	Stock	22.26	22.3	22.02	22.06	1663572.0
2010-04-05	ABC-DELISTED	Stock	28.63	29.02	28.53	28.93	2316026.0
2010-04-05	ABCB	Stock	9.037	9.5545	8.9872	9.5545	45114.0
2010-04-05	ABCD-DELISTED	Stock	4.74	4.75	4.51	4.6201	39412.0
2010-04-05	ABCO-DELISTED	Stock	16.395	16.49	16.28	16.365	79528.0
2010-04-05	ABCW-DELISTED	Stock	0.8	0.92	0.7586	0.82	1557270.0
2010-04-05	ABD-DELISTED	Stock	7.76	7.97	7.64	7.94	254780.0
2010-04-05	ABE-DELISTED	Stock	17.35	17.35	17.25	17.33	23798.0
2010-04-05	ABEO	Stock	2850.0	3125.0	2825.0	3037.5	24.0
2010-04-05	ABFS-DELISTED	Stock	30.19	30.7	29.82	30.05	555647.0
2010-04-05	ABG	Stock	13.62	13.96	13.62	13.83	141100.0
2010-04-05	ABII-DELISTED	Stock	51.37	51.71	51.095	51.64	97713.0
2010-04-05	ABK-DELISTED	Stock	0.58	0.58	0.55	0.5599	4838587.0
2010-04-05	ABM	Stock	21.06	21.26	20.84	20.99	183000.0
2010-04-05	ABMD-DELISTED	Stock	9.95	10.23	9.95	10.13	646833.0
2010-04-05	ABR	Stock	3.46	3.72	3.41	3.7	316400.0
2010-04-05	ABT	Stock	25.4246	25.5494	25.2855	25.3958	11130471.0
2010-04-05	ABTL-DELISTED	Stock	5.2	5.4	5.2	5.3	14141.0
2010-04-05	ABV-DELISTED	Stock	92.91	93.56	92.65	93.45	509966.0
2010-04-05	ABVA-DELISTED	Stock	2.53	2.6	2.53	2.6	200.0
2010-04-05	ABVT-DELISTED	Stock	50.6	50.6	49.19	49.44	267916.0
2010-04-05	ABX-DELISTED	Stock	39.69	39.89	39.25	39.61	6003731.0
2010-04-05	ACAD	Stock	1.48	1.57	1.48	1.55	274900.0

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

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