PREVIEW / stock_daily / 2010-04-01

all stock daily files

  file:    by_date/stock_daily/2010/2010-04-01.parquet
  size:    191 KB
  rows:    5,939
  symbols: 3,504

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-01	AAPL	Stock	8.4789	8.5261	8.3125	8.4275	603145200.0
2010-04-01	MSFT	Stock	29.35	29.54	28.62	29.16	74768100.0
2010-04-01	NVDA	Stock	0.437	0.442	0.426	0.4305	339664000.0
2010-04-01	AMZN	Stock	6.79	6.8255	6.559	6.5905	175716000.0
2010-04-01	TLT	Stock	88.77	89.03	88.43	88.95	2912399.0
2010-04-01	ES	Stock	27.75	28.1	27.75	27.97	1008400.0
2010-04-01	CL	Stock	42.675	42.965	42.635	42.905	3489200.0
2010-04-01	A	Stock	24.7067	24.9428	24.4993	24.7139	3105098.0
2010-04-01	AABA-DELISTED	Stock	16.58	16.6	16.22	16.29	19901441.0
2010-04-01	AACC-DELISTED	Stock	6.37	6.38	6.28	6.38	28419.0
2010-04-01	AACG	Stock	4.06	4.09	3.98	3.99	20500.0
2010-04-01	AAI-DELISTED	Stock	5.16	5.17	5.05	5.06	1904180.0
2010-04-01	AAIC-DELISTED	Stock	17.91	18.18	17.91	18.03	19210.0
2010-04-01	AAME	Stock	1.48	1.54	1.48	1.54	1700.0
2010-04-01	AAON	Stock	4.5096	4.5768	4.4385	4.482	516375.0
2010-04-01	AAP	Stock	42.12	42.46	41.97	42.36	627600.0
2010-04-01	AATI-DELISTED	Stock	3.42	3.8	3.42	3.65	786958.0
2010-04-01	AAU-DELISTED	Stock	0.91	0.94	0.91	0.92	66513.0
2010-04-01	AAUAF-DELISTED	Stock	0.91	0.94	0.91	0.92	68013.0
2010-04-01	AAV-DELISTED	Stock	6.87	7.19	6.85	7.12	694069.0
2010-04-01	AAWW-DELISTED	Stock	53.53	53.88	52.454	53.22	256792.0
2010-04-01	AAXJ	Stock	57.8	58.1	57.47	58.0	863390.0
2010-04-01	AAXN-DELISTED	Stock	5.93	5.97	5.76	5.79	699616.0
2010-04-01	AB	Stock	31.55	31.89	31.23	31.68	777500.0
2010-04-01	ABAX-DELISTED	Stock	27.29	27.65	26.55	26.87	107265.0
2010-04-01	ABB-DELISTED	Stock	22.17	22.3	21.92	22.13	2218810.0
2010-04-01	ABBC-DELISTED	Stock	7.94	8.05	7.9	7.978	49607.0
2010-04-01	ABBNY-DELISTED	Stock	22.17	22.3	21.92	22.14	2223226.0
2010-04-01	ABC-DELISTED	Stock	28.99	29.13	28.42	28.58	3679324.0
2010-04-01	ABCB	Stock	9.0469	9.3455	8.8976	8.9573	24416.0
2010-04-01	ABCD-DELISTED	Stock	4.02	4.75	4.0	4.66	195223.0
2010-04-01	ABCO-DELISTED	Stock	15.87	16.3	15.825	16.185	122238.0
2010-04-01	ABCW-DELISTED	Stock	1.12	1.17	1.12	1.15	59870.0
2010-04-01	ABD-DELISTED	Stock	7.74	7.941	7.58	7.75	380400.0
2010-04-01	ABE-DELISTED	Stock	17.1	17.25	17.09	17.25	25850.0
2010-04-01	ABEO	Stock	3062.5	3062.5	2812.5	2925.0	45.0
2010-04-01	ABFS-DELISTED	Stock	29.97	30.42	29.88	30.42	446762.0
2010-04-01	ABG	Stock	13.45	13.63	13.35	13.61	211600.0
2010-04-01	ABII-DELISTED	Stock	51.56	51.75	51.0	51.38	70759.0
2010-04-01	ABK-DELISTED	Stock	0.56	0.57	0.54	0.56	12647758.0
2010-04-01	ABM	Stock	21.37	21.45	20.86	20.98	223700.0
2010-04-01	ABMD-DELISTED	Stock	10.36	10.46	9.97	10.01	439328.0
2010-04-01	ABR	Stock	3.24	3.5	3.21	3.45	266700.0
2010-04-01	ABT	Stock	25.3334	25.415	25.2279	25.4102	12903501.0
2010-04-01	ABTL-DELISTED	Stock	5.45	5.45	5.2	5.2	15829.0
2010-04-01	ABV-DELISTED	Stock	92.83	92.84	91.76	92.04	773390.0
2010-04-01	ABVA-DELISTED	Stock	2.5	2.5	2.5	2.5	100.0
2010-04-01	ABVT-DELISTED	Stock	50.94	51.2	49.8	50.6	483142.0
2010-04-01	ABX-DELISTED	Stock	38.95	39.52	38.61	39.45	10118312.0
2010-04-01	ACAD	Stock	1.53	1.54	1.45	1.51	421400.0

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

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