PREVIEW / stock_daily / 2007-06-12

all stock daily files

  file:    by_date/stock_daily/2007/2007-06-12.parquet
  size:    177 KB
  rows:    5,404
  symbols: 3,240

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-12	AAPL	Stock	4.2625	4.3468	4.2254	4.2993	1426566400.0
2007-06-12	MSFT	Stock	29.96	30.24	29.77	29.85	56981800.0
2007-06-12	NVDA	Stock	0.6082	0.6167	0.6047	0.605	526770000.0
2007-06-12	AMZN	Stock	3.522	3.538	3.471	3.5035	236590000.0
2007-06-12	TLT	Stock	82.91	83.42	82.2	82.35	9048346.0
2007-06-12	CL	Stock	33.495	33.785	33.42	33.745	5662800.0
2007-06-12	A	Stock	26.7811	27.0601	26.5379	26.8026	3016884.0
2007-06-12	AABA-DELISTED	Stock	27.3	27.66	26.98	27.03	20300582.0
2007-06-12	AACC-DELISTED	Stock	18.75	18.96	18.7	18.88	303315.0
2007-06-12	AAI-DELISTED	Stock	11.43	11.58	11.22	11.26	2404447.0
2007-06-12	AAIC-DELISTED	Stock	126.0	126.0	121.2	121.4	2261435.0
2007-06-12	AAME	Stock	4.31	4.43	4.3	4.32	21000.0
2007-06-12	AAON	Stock	3.8835	3.8914	3.7663	3.7847	508781.0
2007-06-12	AAP	Stock	41.4	41.58	40.88	40.95	721800.0
2007-06-12	AATI-DELISTED	Stock	9.32	9.36	9.11	9.15	291329.0
2007-06-12	AAU-DELISTED	Stock	2.35	2.38	2.29	2.3	65400.0
2007-06-12	AAUAF-DELISTED	Stock	2.35	2.3796	2.29	2.3	65400.0
2007-06-12	AAV-DELISTED	Stock	12.81	13.03	12.8	12.9	1019000.0
2007-06-12	AAWW-DELISTED	Stock	57.47	57.47	56.1	56.59	186855.0
2007-06-12	AAXN-DELISTED	Stock	11.67	12.5	11.67	12.05	7690319.0
2007-06-12	AB	Stock	90.09	91.58	88.93	90.15	366600.0
2007-06-12	ABAX-DELISTED	Stock	22.67	22.7	22.04	22.1645	109535.0
2007-06-12	ABB-DELISTED	Stock	21.48	21.6	21.16	21.25	2176900.0
2007-06-12	ABBC-DELISTED	Stock	17.7	17.7	17.32	17.32	45066.0
2007-06-12	ABBNY-DELISTED	Stock	21.48	21.5999	21.16	21.24	2176900.0
2007-06-12	ABC-DELISTED	Stock	25.4	25.73	25.4	25.5	2216000.0
2007-06-12	ABCB	Stock	21.972	22.1665	21.3981	21.5051	37218.0
2007-06-12	ABCO-DELISTED	Stock	26.56	26.82	26.34	26.67	290905.0
2007-06-12	ABCW-DELISTED	Stock	27.91	28.11	27.42	27.6	146230.0
2007-06-12	ABD-DELISTED	Stock	24.69	24.8	24.34	24.41	223900.0
2007-06-12	ABE-DELISTED	Stock	21.65	21.75	21.4244	21.4244	32500.0
2007-06-12	ABEO	Stock	6062.5	6550.0	6000.0	6550.0	7.0
2007-06-12	ABFS-DELISTED	Stock	39.34	39.34	38.68	38.92	440241.0
2007-06-12	ABG	Stock	24.44	24.5	24.19	24.22	811100.0
2007-06-12	ABK-DELISTED	Stock	88.83	88.86	87.5	87.65	832800.0
2007-06-12	ABM	Stock	27.2	27.2	25.83	26.09	634500.0
2007-06-12	ABMD-DELISTED	Stock	11.34	11.43	11.03	11.06	158452.0
2007-06-12	ABP-DELISTED	Stock	4.09	4.14	4.02	4.06	189600.0
2007-06-12	ABR	Stock	27.42	27.55	26.94	27.14	172400.0
2007-06-12	ABT	Stock	25.7557	25.8708	25.5589	25.5925	13334931.0
2007-06-12	ABTL-DELISTED	Stock	20.46	21.56	20.36	20.84	20115.0
2007-06-12	ABV-DELISTED	Stock	70.06	70.15	69.0	69.17	613860.0
2007-06-12	ABVA-DELISTED	Stock	14.14	14.19	13.89	13.91	2265.0
2007-06-12	ABX-DELISTED	Stock	28.43	28.65	28.14	28.21	5278900.0
2007-06-12	ACAD	Stock	14.45	14.55	14.05	14.28	1267300.0
2007-06-12	ACAP-DELISTED	Stock	41.09	41.38	40.28	40.54	40310.0
2007-06-12	ACAS-DELISTED	Stock	45.0	45.43	44.62	44.67	1305494.0
2007-06-12	ACAT-DELISTED	Stock	19.18	19.38	19.15	19.24	76257.0
2007-06-12	ACC-DELISTED	Stock	28.85	28.85	28.26	28.47	131300.0
2007-06-12	ACCL-DELISTED	Stock	6.03	6.09	6.0	6.02	66213.0

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

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