PREVIEW / stock_daily / 2007-06-14

all stock daily files

  file:    by_date/stock_daily/2007/2007-06-14.parquet
  size:    176 KB
  rows:    5,392
  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-14	AAPL	Stock	4.1857	4.2661	4.1579	4.2411	973266000.0
2007-06-14	MSFT	Stock	30.35	30.71	30.3	30.52	59065700.0
2007-06-14	NVDA	Stock	0.6167	0.6328	0.6158	0.6305	508548000.0
2007-06-14	AMZN	Stock	3.545	3.606	3.54	3.597	164906000.0
2007-06-14	TLT	Stock	83.14	83.71	83.05	83.12	3384620.0
2007-06-14	CL	Stock	33.635	33.71	33.34	33.425	4880400.0
2007-06-14	A	Stock	27.4464	27.8827	27.4392	27.7897	2209958.0
2007-06-14	AABA-DELISTED	Stock	27.38	27.64	27.15	27.33	18190370.0
2007-06-14	AACC-DELISTED	Stock	17.75	17.97	17.1	17.33	328750.0
2007-06-14	AAI-DELISTED	Stock	11.25	11.34	11.11	11.29	2204900.0
2007-06-14	AAIC-DELISTED	Stock	123.6	128.0	123.2	125.6	2523600.0
2007-06-14	AAME	Stock	4.14	4.35	4.14	4.16	7200.0
2007-06-14	AAON	Stock	3.7847	3.8624	3.7847	3.8189	243000.0
2007-06-14	AAP	Stock	41.1	41.27	40.86	41.0	830400.0
2007-06-14	AATI-DELISTED	Stock	9.26	9.47	9.25	9.45	365195.0
2007-06-14	AAU-DELISTED	Stock	2.27	2.28	2.25	2.28	97300.0
2007-06-14	AAUAF-DELISTED	Stock	2.27	2.28	2.25	2.28	97300.0
2007-06-14	AAV-DELISTED	Stock	13.14	13.3	13.12	13.3	898000.0
2007-06-14	AAWW-DELISTED	Stock	56.62	57.1	56.17	57.03	118404.0
2007-06-14	AAXN-DELISTED	Stock	12.0	12.39	11.92	12.18	2998266.0
2007-06-14	AB	Stock	91.7	92.0	91.24	91.73	254700.0
2007-06-14	ABAX-DELISTED	Stock	22.53	23.15	22.52	22.78	70060.0
2007-06-14	ABB-DELISTED	Stock	21.72	22.35	21.7	22.1	2484681.0
2007-06-14	ABBC-DELISTED	Stock	17.32	17.32	17.0	17.13	30815.0
2007-06-14	ABBNY-DELISTED	Stock	21.72	22.35	21.7	22.11	3243081.0
2007-06-14	ABC-DELISTED	Stock	25.56	25.83	25.5	25.55	1456600.0
2007-06-14	ABCB	Stock	22.293	22.9155	22.2638	22.4972	43695.0
2007-06-14	ABCO-DELISTED	Stock	27.07	27.07	26.5	26.71	401187.0
2007-06-14	ABCW-DELISTED	Stock	27.5	27.81	27.3	27.46	244840.0
2007-06-14	ABD-DELISTED	Stock	24.68	24.98	24.68	24.91	486950.0
2007-06-14	ABE-DELISTED	Stock	21.5	21.68	21.334	21.62	33400.0
2007-06-14	ABEO	Stock	6250.0	6550.0	6250.0	6437.5	5.0
2007-06-14	ABFS-DELISTED	Stock	39.29	40.33	39.23	39.98	467607.0
2007-06-14	ABG	Stock	24.46	24.63	24.23	24.26	887800.0
2007-06-14	ABK-DELISTED	Stock	87.75	88.74	87.52	88.48	1162700.0
2007-06-14	ABM	Stock	26.13	26.29	26.04	26.16	211600.0
2007-06-14	ABMD-DELISTED	Stock	11.21	11.47	11.12	11.22	160290.0
2007-06-14	ABP-DELISTED	Stock	4.06	4.28	4.01	4.11	870600.0
2007-06-14	ABR	Stock	27.25	27.49	27.17	27.2	98400.0
2007-06-14	ABT	Stock	26.0052	26.1731	25.9188	26.0004	8666945.0
2007-06-14	ABTL-DELISTED	Stock	21.05	21.75	20.85	21.65	23646.0
2007-06-14	ABV-DELISTED	Stock	72.05	73.11	72.05	72.95	808000.0
2007-06-14	ABX-DELISTED	Stock	28.2	28.54	28.15	28.41	4201600.0
2007-06-14	ACAD	Stock	14.56	15.15	14.45	15.02	953900.0
2007-06-14	ACAP-DELISTED	Stock	41.64	41.98	41.55	41.89	43389.0
2007-06-14	ACAS-DELISTED	Stock	44.93	45.3	44.7801	45.27	913709.0
2007-06-14	ACAT-DELISTED	Stock	19.34	19.55	19.26	19.47	43830.0
2007-06-14	ACC-DELISTED	Stock	28.75	28.81	28.35	28.36	172219.0
2007-06-14	ACCL-DELISTED	Stock	6.07	6.3	6.0	6.28	42136.0
2007-06-14	ACCO	Stock	24.68	24.98	24.68	24.91	490200.0

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

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