PREVIEW / stock_daily / 2007-01-12

all stock daily files

  file:    by_date/stock_daily/2007/2007-01-12.parquet
  size:    160 KB
  rows:    4,815
  symbols: 3,021

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-01-12	AAPL	Stock	3.3782	3.395	3.3296	3.3793	1312690400.0
2007-01-12	MSFT	Stock	30.65	31.39	30.64	31.21	103972500.0
2007-01-12	NVDA	Stock	0.5707	0.5895	0.568	0.5872	698190000.0
2007-01-12	AMZN	Stock	1.868	1.9105	1.8635	1.91	89328000.0
2007-01-12	TLT	Stock	88.15	88.84	87.9	88.04	878300.0
2007-01-12	CL	Stock	33.145	33.51	32.98	33.42	3438800.0
2007-01-12	A	Stock	24.0844	24.3491	23.9914	24.0343	1965448.0
2007-01-12	AABA-DELISTED	Stock	28.9799995422363	29.5	28.4899997711182	29.4500007629395	20971100.0
2007-01-12	AACC-DELISTED	Stock	16.34	16.61	16.15	16.29	30687.0
2007-01-12	AACQ-DELISTED	Stock	5.58	5.58	5.53	5.53	1500.0
2007-01-12	AACQU-DELISTED	Stock	6.73	6.73	6.73	6.73	1600.0
2007-01-12	AACQW-DELISTED	Stock	0.66	0.66	0.55	0.56	112800.0
2007-01-12	AAI-DELISTED	Stock	12.36	12.75	12.3	12.64	2330400.0
2007-01-12	AAIC-DELISTED	Stock	166.0	166.8	164.2	165.4	557800.0
2007-01-12	AAME	Stock	3.15	3.41	3.15	3.41	18000.0
2007-01-12	AAON	Stock	3.5714	3.736	3.5714	3.6859	589275.0
2007-01-12	AAP	Stock	36.27	36.5	35.86	36.2	1123000.0
2007-01-12	AATI-DELISTED	Stock	5.44	6.0	5.3	5.972	785288.0
2007-01-12	AAU-DELISTED	Stock	2.27	2.33	2.2584	2.33	41300.0
2007-01-12	AAUAF-DELISTED	Stock	2.27	2.33	2.2584	2.33	41300.0
2007-01-12	AAV-DELISTED	Stock	10.2	10.49	10.2	10.48	447000.0
2007-01-12	AAWW-DELISTED	Stock	46.99	47.4	46.99	47.06	225571.0
2007-01-12	AAXN-DELISTED	Stock	8.15999984741211	8.30000019073486	8.09000015258789	8.19999980926514	778800.0
2007-01-12	AB	Stock	87.7	88.05	86.87	87.89	340400.0
2007-01-12	ABAX-DELISTED	Stock	19.19	19.49	19.1101	19.34	54047.0
2007-01-12	ABB-DELISTED	Stock	17.56	17.74	17.5544	17.73	1064500.0
2007-01-12	ABBC-DELISTED	Stock	19.06	19.1	18.96	19.1	2243.0
2007-01-12	ABC-DELISTED	Stock	23.5	23.78	23.36	23.7	1938200.0
2007-01-12	ABCB	Stock	27.1561	27.7203	27.1561	27.7008	6374.0
2007-01-12	ABCO-DELISTED	Stock	26.82	27.05	26.73	26.95	86277.0
2007-01-12	ABCW-DELISTED	Stock	28.97	29.1	28.78	29.05	40700.0
2007-01-12	ABD-DELISTED	Stock	25.92	25.93	25.65	25.73	177810.0
2007-01-12	ABE-DELISTED	Stock	17.94	18.09	17.52	18.09	40000.0
2007-01-12	ABFS-DELISTED	Stock	38.979	39.93	38.979	39.9	150562.0
2007-01-12	ABG	Stock	23.49	23.54	22.97	23.52	179800.0
2007-01-12	ABK-DELISTED	Stock	88.37	88.75	88.15	88.5	455500.0
2007-01-12	ABM	Stock	23.96	24.35	23.82	24.35	370500.0
2007-01-12	ABMD-DELISTED	Stock	14.28	14.62	14.2	14.59	141541.0
2007-01-12	ABP-DELISTED	Stock	3.15	3.2	3.1	3.14	169800.0
2007-01-12	ABR	Stock	30.55	30.55	30.35	30.41	45200.0
2007-01-12	ABT	Stock	24.0236	24.2251	23.9948	24.2059	11189454.0
2007-01-12	ABTL-DELISTED	Stock	17.007	17.157	16.206	16.693	30913.0
2007-01-12	ABV-DELISTED	Stock	49.45	50.59	49.1	50.44	404500.0
2007-01-12	ABVA-DELISTED	Stock	16.31	16.48	16.31	16.413	6900.0
2007-01-12	ABVT-DELISTED	Stock	58.95	58.95	58.95	58.95	318.0
2007-01-12	ABX-DELISTED	Stock	29.09	29.35	28.98	29.23	4324000.0
2007-01-12	ACAD	Stock	7.75	7.85	7.24	7.44	321500.0
2007-01-12	ACAP-DELISTED	Stock	38.95	39.03	38.72	39.0	14022.0
2007-01-12	ACAS-DELISTED	Stock	47.2	47.24	46.67	47.03	628909.0
2007-01-12	ACAT-DELISTED	Stock	17.15	17.17	16.77	16.82	51740.0

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

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