PREVIEW / stock_daily / 2006-07-28

all stock daily files

  file:    by_date/stock_daily/2006/2006-07-28.parquet
  size:    148 KB
  rows:    4,439
  symbols: 2,794

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-28	AAPL	Stock	2.2836	2.3457	2.2679	2.3425	691507600.0
2006-07-28	MSFT	Stock	24.08	24.28	24.06	24.25	51705800.0
2006-07-28	NVDA	Stock	0.3512	0.3785	0.3492	0.3778	815298000.0
2006-07-28	AMZN	Stock	1.34	1.359	1.3285	1.3585	248440000.0
2006-07-28	CL	Stock	29.6	29.97	29.49	29.835	3376600.0
2006-07-28	A	Stock	19.7639	20.1502	19.6495	19.9714	4428864.0
2006-07-28	AABA-DELISTED	Stock	26.8999996185303	27.5	26.3299999237061	27.4699993133545	21584800.0
2006-07-28	AACC-DELISTED	Stock	17.65	18.5	17.65	18.33	86510.0
2006-07-28	AACQW-DELISTED	Stock	0.39	0.39	0.38	0.38	15000.0
2006-07-28	AAI-DELISTED	Stock	12.69	13.05	12.4	12.99	1501900.0
2006-07-28	AAIC-DELISTED	Stock	187.8	191.4	176.0	186.0	3058000.0
2006-07-28	AAME	Stock	2.8	2.95	2.8	2.8	3800.0
2006-07-28	AAON	Stock	3.0762	3.1684	3.042	3.15	307547.0
2006-07-28	AAP	Stock	30.67	30.99	30.45	30.52	1068700.0
2006-07-28	AATI-DELISTED	Stock	9.29	9.56	8.93	9.25	196798.0
2006-07-28	AAU-DELISTED	Stock	2.44	2.52	2.4	2.49	35900.0
2006-07-28	AAUAF-DELISTED	Stock	2.44	2.52	2.4	2.49	35900.0
2006-07-28	AAV-DELISTED	Stock	16.27	16.34	16.12	16.16	349000.0
2006-07-28	AAWW-DELISTED	Stock	40.67	42.21	40.46	41.11	120818.0
2006-07-28	AAXN-DELISTED	Stock	7.21999979019165	7.30000019073486	6.98000001907349	7.1399998664856	2408700.0
2006-07-28	AB	Stock	63.85	67.02	63.76	66.9	595300.0
2006-07-28	ABAX-DELISTED	Stock	21.14	22.77	21.13	22.32	731502.0
2006-07-28	ABB-DELISTED	Stock	12.71	12.93	12.68	12.86	4570100.0
2006-07-28	ABBC-DELISTED	Stock	14.3	14.7	14.3	14.69	29068.0
2006-07-28	ABC-DELISTED	Stock	21.51	21.68	21.37	21.49	2071800.0
2006-07-28	ABCB	Stock	23.538	23.9853	23.5185	23.8492	111449.0
2006-07-28	ABCO-DELISTED	Stock	23.32	23.67	23.04	23.5	251206.0
2006-07-28	ABCW-DELISTED	Stock	29.28	30.42	29.28	30.3	26510.0
2006-07-28	ABD-DELISTED	Stock	19.6	20.24	19.6	20.16	123900.0
2006-07-28	ABE-DELISTED	Stock	12.44	12.8699	12.44	12.8499	33600.0
2006-07-28	ABFS-DELISTED	Stock	43.31	44.82	43.31	44.25	519177.0
2006-07-28	ABG	Stock	20.33	20.6	20.19	20.35	170100.0
2006-07-28	ABK-DELISTED	Stock	83.17	83.57	82.98	83.06	644400.0
2006-07-28	ABM	Stock	16.53	16.81	16.45	16.79	176300.0
2006-07-28	ABMD-DELISTED	Stock	13.52	13.81	13.35	13.72	126208.0
2006-07-28	ABP-DELISTED	Stock	4.42	4.42	4.21	4.25	120100.0
2006-07-28	ABR	Stock	25.4	25.79	25.32	25.52	101200.0
2006-07-28	ABT	Stock	22.8145	23.0832	22.7809	22.944	9469154.0
2006-07-28	ABTL-DELISTED	Stock	15.975	16.525	15.924	16.525	22126.0
2006-07-28	ABV-DELISTED	Stock	40.3	40.73	40.06	40.54	392900.0
2006-07-28	ABVA-DELISTED	Stock	16.0	16.0	15.82	16.0	1850.0
2006-07-28	ABX-DELISTED	Stock	29.63	30.56	29.63	30.52	4036700.0
2006-07-28	ACAD	Stock	6.38	6.75	6.38	6.63	81200.0
2006-07-28	ACAP-DELISTED	Stock	47.1	47.39	46.61	46.85	27490.0
2006-07-28	ACAS-DELISTED	Stock	34.91	35.01	34.71	34.98	766330.0
2006-07-28	ACAT-DELISTED	Stock	18.62	18.62	17.68	18.35	389096.0
2006-07-28	ACC-DELISTED	Stock	25.51	25.96	25.46	25.7	43600.0
2006-07-28	ACCL-DELISTED	Stock	6.28	6.36	6.22	6.33	11354.0
2006-07-28	ACCO	Stock	19.6	20.24	19.6	20.16	131000.0
2006-07-28	ACCP-DELISTED	Stock	1.03	1.05	1.03	1.05	300.0

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

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