PREVIEW / stock_daily / 2007-01-19

all stock daily files

  file:    by_date/stock_daily/2007/2007-01-19.parquet
  size:    160 KB
  rows:    4,825
  symbols: 3,026

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-19	AAPL	Stock	3.1654	3.2018	3.1471	3.1607	1364473600.0
2007-01-19	MSFT	Stock	30.73	31.11	30.69	31.11	75826900.0
2007-01-19	NVDA	Stock	0.5225	0.5423	0.5188	0.5313	942606000.0
2007-01-19	AMZN	Stock	1.8345	1.874	1.83	1.851	121918000.0
2007-01-19	TLT	Stock	88.15	88.15	87.87	87.99	882500.0
2007-01-19	CL	Stock	33.275	33.425	33.12	33.425	2695000.0
2007-01-19	A	Stock	23.1402	23.5622	23.1187	23.4621	3501011.0
2007-01-19	AABA-DELISTED	Stock	27.9300003051758	28.3400001525879	27.5499992370605	27.6399993896484	24757700.0
2007-01-19	AACC-DELISTED	Stock	15.51	15.66	15.33	15.62	66887.0
2007-01-19	AACQU-DELISTED	Stock	6.78	6.78	6.78	6.78	100.0
2007-01-19	AACQW-DELISTED	Stock	0.65	0.68	0.65	0.66	45515.0
2007-01-19	AAI-DELISTED	Stock	12.01	12.16	11.99	12.13	1170500.0
2007-01-19	AAIC-DELISTED	Stock	158.6	161.6	156.8	161.0	939300.0
2007-01-19	AAME	Stock	3.4	3.4	3.29	3.29	1200.0
2007-01-19	AAON	Stock	3.4871	3.6346	3.4594	3.6188	210347.0
2007-01-19	AAP	Stock	36.98	37.32	36.75	37.3	682900.0
2007-01-19	AATI-DELISTED	Stock	5.68	5.8	5.55	5.65	167105.0
2007-01-19	AAU-DELISTED	Stock	2.23	2.23	2.16	2.2299	47100.0
2007-01-19	AAUAF-DELISTED	Stock	2.23	2.23	2.16	2.2298	47100.0
2007-01-19	AAV-DELISTED	Stock	10.83	10.91	10.6	10.72	673700.0
2007-01-19	AAWW-DELISTED	Stock	47.37	47.85	47.37	47.55	36084.0
2007-01-19	AAXN-DELISTED	Stock	7.76999998092651	7.96999979019165	7.75	7.82000017166138	847200.0
2007-01-19	AB	Stock	87.25	88.48	87.15	87.85	195900.0
2007-01-19	ABAX-DELISTED	Stock	18.54	18.86	17.9	17.97	471980.0
2007-01-19	ABB-DELISTED	Stock	17.34	17.59	17.3	17.48	2021200.0
2007-01-19	ABBC-DELISTED	Stock	18.82	19.1	18.82	19.05	2760.0
2007-01-19	ABC-DELISTED	Stock	24.18	24.18	23.92	23.97	2630800.0
2007-01-19	ABCB	Stock	25.989	26.5531	25.989	26.3781	12749.0
2007-01-19	ABCO-DELISTED	Stock	26.41	27.1	26.41	27.03	154759.0
2007-01-19	ABCW-DELISTED	Stock	28.72	28.85	28.7	28.74	41120.0
2007-01-19	ABD-DELISTED	Stock	23.51	24.34	23.16	24.33	657610.0
2007-01-19	ABE-DELISTED	Stock	18.36	18.43	18.2201	18.25	33000.0
2007-01-19	ABFS-DELISTED	Stock	39.0	39.07	38.45	38.92	370768.0
2007-01-19	ABG	Stock	23.38	23.75	23.29	23.72	212900.0
2007-01-19	ABK-DELISTED	Stock	87.57	87.57	86.5	87.27	635600.0
2007-01-19	ABM	Stock	24.5	24.53	24.28	24.31	252200.0
2007-01-19	ABMD-DELISTED	Stock	14.46	14.64	14.13	14.58	159298.0
2007-01-19	ABP-DELISTED	Stock	3.04	3.18	3.04	3.11	229400.0
2007-01-19	ABR	Stock	30.39	31.24	30.19	31.16	101000.0
2007-01-19	ABT	Stock	25.5925	25.7892	25.5014	25.6789	25347228.0
2007-01-19	ABTL-DELISTED	Stock	16.6	17.25	16.25	17.15	14491.0
2007-01-19	ABV-DELISTED	Stock	50.54	50.54	49.63	50.08	279200.0
2007-01-19	ABVA-DELISTED	Stock	16.52	16.75	16.52	16.75	7150.0
2007-01-19	ABVT-DELISTED	Stock	54.0	59.0	54.0	59.0	523.0
2007-01-19	ABX-DELISTED	Stock	28.44	28.73	28.27	28.57	4455503.0
2007-01-19	ACAD	Stock	7.37	7.37	7.12	7.25	128400.0
2007-01-19	ACAP-DELISTED	Stock	36.6	37.0	36.36	36.84	47878.0
2007-01-19	ACAS-DELISTED	Stock	47.03	47.22	46.87	47.12	555799.0
2007-01-19	ACAT-DELISTED	Stock	16.89	16.96	16.68	16.89	45132.0
2007-01-19	ACC-DELISTED	Stock	30.18	31.33	30.12	31.31	123779.0

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

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