PREVIEW / stock_daily / 2007-06-11

all stock daily files

  file:    by_date/stock_daily/2007/2007-06-11.parquet
  size:    175 KB
  rows:    5,378
  symbols: 3,230

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
2007-06-11	AAPL	Stock	4.5	4.5054	4.2693	4.2925	1874258400.0
2007-06-11	MSFT	Stock	29.94	30.25	29.93	30.02	48467400.0
2007-06-11	NVDA	Stock	0.6092	0.615	0.6058	0.6113	434634000.0
2007-06-11	AMZN	Stock	3.65	3.6525	3.55	3.5585	223182000.0
2007-06-11	TLT	Stock	83.49	83.89	83.26	83.56	2043725.0
2007-06-11	CL	Stock	33.26	33.65	33.18	33.61	4186000.0
2007-06-11	A	Stock	26.7382	27.1245	26.5737	26.9742	2103571.0
2007-06-11	AABA-DELISTED	Stock	27.27	27.52	27.15	27.35	11708536.0
2007-06-11	AACC-DELISTED	Stock	18.85	18.87	18.65	18.79	174900.0
2007-06-11	AAI-DELISTED	Stock	11.08	11.61	11.08	11.52	3010120.0
2007-06-11	AAIC-DELISTED	Stock	129.8	130.0	125.2	125.6	1948600.0
2007-06-11	AAME	Stock	4.45	4.5	4.34	4.4	12000.0
2007-06-11	AAON	Stock	3.8821	3.9137	3.79	3.9137	175416.0
2007-06-11	AAP	Stock	42.25	42.25	41.35	41.57	762700.0
2007-06-11	AATI-DELISTED	Stock	9.32	9.46	9.05	9.39	347247.0
2007-06-11	AAU-DELISTED	Stock	2.34	2.43	2.33	2.37	93100.0
2007-06-11	AAUAF-DELISTED	Stock	2.34	2.43	2.33	2.37	93100.0
2007-06-11	AAV-DELISTED	Stock	12.89	12.96	12.8	12.85	941250.0
2007-06-11	AAWW-DELISTED	Stock	57.51	57.73	56.26	57.63	95246.0
2007-06-11	AAXN-DELISTED	Stock	11.1	11.93	11.03	11.89	7437093.0
2007-06-11	AB	Stock	87.62	90.4	87.4	90.09	277000.0
2007-06-11	ABAX-DELISTED	Stock	22.53	22.89	22.5	22.65	100520.0
2007-06-11	ABB-DELISTED	Stock	21.59	21.82	21.44	21.64	1675650.0
2007-06-11	ABBC-DELISTED	Stock	17.9	18.15	17.75	17.8	36255.0
2007-06-11	ABBNY-DELISTED	Stock	21.59	21.82	21.44	21.65	1675650.0
2007-06-11	ABC-DELISTED	Stock	25.53	25.67	25.46	25.48	2933608.0
2007-06-11	ABCB	Stock	21.9526	22.5459	21.9526	22.1179	25806.0
2007-06-11	ABCO-DELISTED	Stock	26.51	26.72	26.26	26.7	240327.0
2007-06-11	ABCW-DELISTED	Stock	28.19	28.28	27.98	28.12	129690.0
2007-06-11	ABD-DELISTED	Stock	25.02	25.1	24.79	24.86	120200.0
2007-06-11	ABE-DELISTED	Stock	22.0	22.0	21.31	21.43	36000.0
2007-06-11	ABEO	Stock	6312.5	6500.0	6312.5	6437.5	9.0
2007-06-11	ABFS-DELISTED	Stock	39.6	39.64	38.9	39.49	443375.0
2007-06-11	ABG	Stock	24.64	24.82	24.2	24.62	279600.0
2007-06-11	ABK-DELISTED	Stock	88.59	89.33	88.45	88.92	908300.0
2007-06-11	ABM	Stock	27.26	27.58	27.14	27.33	253300.0
2007-06-11	ABMD-DELISTED	Stock	11.5	11.61	11.38	11.41	106016.0
2007-06-11	ABP-DELISTED	Stock	3.99	4.12	3.99	4.07	215900.0
2007-06-11	ABR	Stock	27.66	27.76	27.36	27.61	115600.0
2007-06-11	ABT	Stock	25.962	26.1539	25.8804	25.938	7607545.0
2007-06-11	ABTL-DELISTED	Stock	20.3	21.15	20.3	20.75	15563.0
2007-06-11	ABV-DELISTED	Stock	67.79	70.4	67.5	70.0	449040.0
2007-06-11	ABVA-DELISTED	Stock	14.24	14.25	14.13	14.15	3900.0
2007-06-11	ABX-DELISTED	Stock	28.61	28.95	28.43	28.65	6238982.0
2007-06-11	ACAD	Stock	14.49	14.63	14.1	14.46	1738900.0
2007-06-11	ACAP-DELISTED	Stock	41.59	41.59	41.01	41.31	58919.0
2007-06-11	ACAS-DELISTED	Stock	45.74	45.97	45.33	45.89	1059867.0
2007-06-11	ACAT-DELISTED	Stock	19.29	19.58	19.21	19.27	43706.0
2007-06-11	ACC-DELISTED	Stock	29.25	29.25	28.64	29.0	175100.0
2007-06-11	ACCL-DELISTED	Stock	6.2	6.22	6.1	6.12	34272.0

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

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