PREVIEW / stock_daily / 2006-07-14

all stock daily files

  file:    by_date/stock_daily/2006/2006-07-14.parquet
  size:    147 KB
  rows:    4,427
  symbols: 2,793

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-07-14	AAPL	Stock	1.875	1.8889	1.7914	1.8096	993036800.0
2006-07-14	MSFT	Stock	22.28	22.55	22.23	22.29	67499400.0
2006-07-14	NVDA	Stock	0.3015	0.3032	0.2862	0.2945	572148000.0
2006-07-14	AMZN	Stock	1.6755	1.6865	1.64	1.646	161896000.0
2006-07-14	CL	Stock	30.66	30.66	30.205	30.505	3139800.0
2006-07-14	A	Stock	20.3505	20.5937	20.1359	20.5222	3501710.0
2006-07-14	AABA-DELISTED	Stock	32.3400001525879	32.4799995422363	31.8500003814697	32.0800018310547	12484700.0
2006-07-14	AACC-DELISTED	Stock	17.95	18.41	17.27	17.64	323743.0
2006-07-14	AACQ-DELISTED	Stock	5.31	5.33	5.31	5.33	13000.0
2006-07-14	AACQU-DELISTED	Stock	6.15	6.15	6.13	6.15	5300.0
2006-07-14	AACQW-DELISTED	Stock	0.43	0.43	0.43	0.43	29000.0
2006-07-14	AAI-DELISTED	Stock	13.13	13.48	12.67	12.83	1590100.0
2006-07-14	AAIC-DELISTED	Stock	199.2	200.0	194.0	197.4	1443900.0
2006-07-14	AAME	Stock	2.8	2.93	2.8	2.92	1000.0
2006-07-14	AAON	Stock	2.963	2.988	2.8708	2.9235	258947.0
2006-07-14	AAP	Stock	28.85	29.16	28.63	29.04	1694900.0
2006-07-14	AATI-DELISTED	Stock	8.43	8.59	8.42	8.46	241574.0
2006-07-14	AAU-DELISTED	Stock	2.46	2.56	2.46	2.52	32800.0
2006-07-14	AAUAF-DELISTED	Stock	2.46	2.56	2.46	2.52	32800.0
2006-07-14	AAV-DELISTED	Stock	15.64	16.21	15.57	16.17	1732800.0
2006-07-14	AAWW-DELISTED	Stock	42.31	42.31	40.69	41.54	84310.0
2006-07-14	AAXN-DELISTED	Stock	7.94000005722046	7.98000001907349	7.42999982833862	7.6100001335144	957500.0
2006-07-14	AB	Stock	57.0	57.55	56.1	57.5	301000.0
2006-07-14	ABAX-DELISTED	Stock	19.71	19.81	19.02	19.19	281252.0
2006-07-14	ABB-DELISTED	Stock	11.89	11.91	11.56	11.85	2090100.0
2006-07-14	ABBC-DELISTED	Stock	14.26	14.69	14.19	14.48	13396.0
2006-07-14	ABC-DELISTED	Stock	20.74	20.92	20.56	20.84	2033600.0
2006-07-14	ABCB	Stock	20.6687	20.8632	20.5227	20.6297	23647.0
2006-07-14	ABCO-DELISTED	Stock	23.92	23.96	23.32	23.81	162305.0
2006-07-14	ABCW-DELISTED	Stock	28.55	28.85	28.4	28.62	32160.0
2006-07-14	ABD-DELISTED	Stock	20.25	20.41	19.98	20.22	282300.0
2006-07-14	ABE-DELISTED	Stock	12.2	12.2	11.38	11.5005	18200.0
2006-07-14	ABFS-DELISTED	Stock	45.56	46.06	44.41	46.0	489693.0
2006-07-14	ABG	Stock	19.82	20.7	19.73	19.91	241500.0
2006-07-14	ABK-DELISTED	Stock	82.08	82.29	80.89	81.13	857400.0
2006-07-14	ABM	Stock	16.54	16.65	16.31	16.41	208500.0
2006-07-14	ABMD-DELISTED	Stock	13.26	13.26	12.55	12.69	72026.0
2006-07-14	ABP-DELISTED	Stock	4.45	4.52	4.31	4.42	246600.0
2006-07-14	ABR	Stock	25.02	25.44	24.85	25.04	99900.0
2006-07-14	ABT	Stock	21.0488	21.2599	21.0392	21.116	9913089.0
2006-07-14	ABTL-DELISTED	Stock	17.313	17.438	16.286	16.937	17737.0
2006-07-14	ABV-DELISTED	Stock	39.15	39.22	37.92	38.73	1293000.0
2006-07-14	ABVA-DELISTED	Stock	16.4	16.4	16.08	16.15	6260.0
2006-07-14	ABX-DELISTED	Stock	29.66	30.37	29.51	30.33	3600200.0
2006-07-14	ACAD	Stock	7.66	7.88	7.43	7.52	180500.0
2006-07-14	ACAP-DELISTED	Stock	48.35	48.85	48.31	48.43	26986.0
2006-07-14	ACAS-DELISTED	Stock	33.65	33.71	33.04	33.45	656161.0
2006-07-14	ACAT-DELISTED	Stock	16.77	17.59	16.7	16.91	170784.0
2006-07-14	ACC-DELISTED	Stock	24.25	24.26	23.8	23.87	58000.0
2006-07-14	ACCL-DELISTED	Stock	6.8	6.86	6.7	6.86	29739.0

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

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