PREVIEW / stock_daily / 2006-08-10

all stock daily files

  file:    by_date/stock_daily/2006/2006-08-10.parquet
  size:    147 KB
  rows:    4,440
  symbols: 2,792

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
2006-08-10	AAPL	Stock	2.2589	2.3146	2.2393	2.2882	697760000.0
2006-08-10	MSFT	Stock	24.37	24.6	24.34	24.46	31753400.0
2006-08-10	NVDA	Stock	0.401	0.405	0.3942	0.4027	1072140000.0
2006-08-10	AMZN	Stock	1.31	1.326	1.294	1.3245	128112000.0
2006-08-10	CL	Stock	29.555	30.045	29.515	29.895	3856400.0
2006-08-10	A	Stock	19.4492	19.9285	19.3705	19.8856	3337725.0
2006-08-10	AABA-DELISTED	Stock	26.9500007629395	27.7999992370605	26.8500003814697	27.4899997711182	12597900.0
2006-08-10	AACC-DELISTED	Stock	15.43	15.746	15.02	15.71	180492.0
2006-08-10	AACQU-DELISTED	Stock	6.15	6.15	6.15	6.15	1200.0
2006-08-10	AACQW-DELISTED	Stock	0.38	0.41	0.37	0.41	144000.0
2006-08-10	AAI-DELISTED	Stock	11.26	11.76	11.23	11.75	3276000.0
2006-08-10	AAIC-DELISTED	Stock	174.0	178.6	172.6	178.2	2178200.0
2006-08-10	AAON	Stock	3.0591	3.0591	2.93	2.9643	166303.0
2006-08-10	AAP	Stock	27.8	30.39	27.65	29.78	3024300.0
2006-08-10	AATI-DELISTED	Stock	8.76	8.95	8.67	8.86	39132.0
2006-08-10	AAU-DELISTED	Stock	2.56	2.6	2.5	2.6	21400.0
2006-08-10	AAUAF-DELISTED	Stock	2.56	2.6	2.5	2.6	21400.0
2006-08-10	AAV-DELISTED	Stock	16.28	16.29	15.97	16.0	491900.0
2006-08-10	AAWW-DELISTED	Stock	37.07	37.23	35.1	35.92	430131.0
2006-08-10	AAXN-DELISTED	Stock	7.07000017166138	7.09999990463257	6.92999982833862	6.92999982833862	705700.0
2006-08-10	AB	Stock	65.21	65.85	64.75	65.67	170000.0
2006-08-10	ABAX-DELISTED	Stock	21.79	22.11	21.49	21.74	107142.0
2006-08-10	ABB-DELISTED	Stock	12.81	12.99	12.8	12.97	5178700.0
2006-08-10	ABBC-DELISTED	Stock	14.67	14.76	14.65	14.69	11691.0
2006-08-10	ABC-DELISTED	Stock	21.43	21.7	21.43	21.62	2627200.0
2006-08-10	ABCB	Stock	25.2887	25.6875	25.2595	25.5318	41639.0
2006-08-10	ABCO-DELISTED	Stock	23.94	24.45	23.63	24.29	378665.0
2006-08-10	ABCW-DELISTED	Stock	28.89	28.89	28.11	28.46	52110.0
2006-08-10	ABD-DELISTED	Stock	18.05	18.76	17.95	18.28	280900.0
2006-08-10	ABE-DELISTED	Stock	12.88	12.92	12.85	12.92	6900.0
2006-08-10	ABFS-DELISTED	Stock	42.07	43.43	41.83	43.01	403396.0
2006-08-10	ABG	Stock	19.97	20.21	19.77	19.9	86600.0
2006-08-10	ABK-DELISTED	Stock	82.88	83.22	82.7	83.01	684800.0
2006-08-10	ABM	Stock	16.15	16.55	16.11	16.47	125500.0
2006-08-10	ABMD-DELISTED	Stock	13.04	13.27	12.96	13.11	82460.0
2006-08-10	ABP-DELISTED	Stock	3.86	3.9	3.65	3.89	694100.0
2006-08-10	ABR	Stock	24.5	24.75	24.23	24.75	68200.0
2006-08-10	ABT	Stock	22.5842	22.9104	22.4642	22.8961	11208837.0
2006-08-10	ABTL-DELISTED	Stock	15.05	15.551	14.598	15.2	90625.0
2006-08-10	ABV-DELISTED	Stock	41.05	41.34	40.74	41.16	529600.0
2006-08-10	ABVA-DELISTED	Stock	16.62	16.62	16.36	16.53	2100.0
2006-08-10	ABX-DELISTED	Stock	32.5	32.58	31.53	31.91	14157900.0
2006-08-10	ACAD	Stock	5.5	5.5	5.07	5.26	354100.0
2006-08-10	ACAP-DELISTED	Stock	46.75	47.69	46.62	47.03	32427.0
2006-08-10	ACAS-DELISTED	Stock	36.57	37.0	36.21	36.95	1053218.0
2006-08-10	ACAT-DELISTED	Stock	18.0	18.38	17.75	18.11	58119.0
2006-08-10	ACC-DELISTED	Stock	24.9	25.34	24.9	25.08	29300.0
2006-08-10	ACCL-DELISTED	Stock	6.3	6.31	6.15	6.24	16372.0
2006-08-10	ACCO	Stock	18.05	18.76	17.95	18.28	290800.0
2006-08-10	ACCP-DELISTED	Stock	0.8	0.88	0.75	0.88	9015.0

> showing 50 of 4,440 rows — these rows as CSV

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