PREVIEW / stock_daily / 2007-07-06

all stock daily files

  file:    by_date/stock_daily/2007/2007-07-06.parquet
  size:    176 KB
  rows:    5,401
  symbols: 3,246

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-07-06	AAPL	Stock	4.7546	4.7621	4.6571	4.725	874694800.0
2007-07-06	MSFT	Stock	29.91	30.04	29.66	29.97	57541000.0
2007-07-06	NVDA	Stock	0.725	0.7323	0.7237	0.7295	282720000.0
2007-07-06	AMZN	Stock	3.4375	3.465	3.4005	3.4485	92306000.0
2007-07-06	TLT	Stock	83.54	83.55	83.28	83.48	1437714.0
2007-07-06	CL	Stock	33.025	33.035	32.755	33.005	3300400.0
2007-07-06	A	Stock	28.2475	28.5408	28.133	28.4835	2935520.0
2007-07-06	AABA-DELISTED	Stock	27.01	27.14	26.93	27.09	11110708.0
2007-07-06	AACC-DELISTED	Stock	17.25	17.51	17.09	17.42	95502.0
2007-07-06	AAI-DELISTED	Stock	10.98	11.07	10.86	11.0	3207568.0
2007-07-06	AAIC-DELISTED	Stock	107.2	108.6	105.6	107.8	1461300.0
2007-07-06	AAME	Stock	3.92	3.95	3.84	3.94	5100.0
2007-07-06	AAON	Stock	4.214	4.2601	4.1613	4.2469	407784.0
2007-07-06	AAP	Stock	41.58	42.0	41.43	41.92	353500.0
2007-07-06	AATI-DELISTED	Stock	9.8	9.92	9.79	9.87	332613.0
2007-07-06	AAU-DELISTED	Stock	2.49	2.7	2.49	2.67	135800.0
2007-07-06	AAUAF-DELISTED	Stock	2.49	2.6994	2.49	2.6701	135800.0
2007-07-06	AAV-DELISTED	Stock	14.17	14.24	14.04	14.22	523700.0
2007-07-06	AAWW-DELISTED	Stock	60.39	61.08	60.2	60.79	39804.0
2007-07-06	AAXN-DELISTED	Stock	14.04	14.15	13.7	14.07	2751882.0
2007-07-06	AB	Stock	88.0	90.25	87.7	90.14	301000.0
2007-07-06	ABAX-DELISTED	Stock	21.33	21.33	20.86	20.93	168476.0
2007-07-06	ABB-DELISTED	Stock	23.62	23.82	23.53	23.76	1093300.0
2007-07-06	ABBC-DELISTED	Stock	9.8	9.941	9.757	9.91	364716.0
2007-07-06	ABBNY-DELISTED	Stock	23.62	23.82	23.53	23.79	1093400.0
2007-07-06	ABC-DELISTED	Stock	24.91	25.0	24.78	24.96	1259000.0
2007-07-06	ABCB	Stock	22.1665	22.3513	22.0206	22.1373	16758.0
2007-07-06	ABCO-DELISTED	Stock	28.6	28.75	28.51	28.64	77956.0
2007-07-06	ABCW-DELISTED	Stock	26.11	26.11	25.83	25.98	134980.0
2007-07-06	ABD-DELISTED	Stock	23.67	23.8	23.38	23.6	142400.0
2007-07-06	ABE-DELISTED	Stock	21.75	22.12	21.58	22.12	26600.0
2007-07-06	ABEO	Stock	6437.5	6437.5	6375.0	6437.5	2.0
2007-07-06	ABFS-DELISTED	Stock	39.44	39.74	39.05	39.54	222355.0
2007-07-06	ABG	Stock	24.98	24.98	24.41	24.56	307300.0
2007-07-06	ABK-DELISTED	Stock	86.64	86.98	85.99	86.7	1109500.0
2007-07-06	ABM	Stock	26.05	26.15	25.77	26.01	625200.0
2007-07-06	ABMD-DELISTED	Stock	10.83	10.83	10.31	10.57	219533.0
2007-07-06	ABP-DELISTED	Stock	4.5	4.5	4.43	4.43	163100.0
2007-07-06	ABR	Stock	26.32	26.32	26.05	26.07	79100.0
2007-07-06	ABT	Stock	26.0675	26.1155	25.8516	25.9092	7504377.0
2007-07-06	ABTL-DELISTED	Stock	21.78	21.83	21.57	21.72	14851.0
2007-07-06	ABV-DELISTED	Stock	72.6	73.32	72.3	73.06	438200.0
2007-07-06	ABVA-DELISTED	Stock	13.03	13.29	13.03	13.11	11783.0
2007-07-06	ABVT-DELISTED	Stock	62.5	63.0	62.0	62.0	6980.0
2007-07-06	ABX-DELISTED	Stock	30.43	30.93	29.95	30.69	7703631.0
2007-07-06	ACAD	Stock	13.58	13.91	13.5	13.76	536500.0
2007-07-06	ACAP-DELISTED	Stock	40.12	40.12	39.67	39.67	21378.0
2007-07-06	ACAS-DELISTED	Stock	45.74	46.99	45.65	46.97	28786098.0
2007-07-06	ACAT-DELISTED	Stock	20.36	20.7	20.28	20.5	64395.0
2007-07-06	ACC-DELISTED	Stock	29.25	29.5	29.1	29.35	69400.0

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

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