PREVIEW / stock_daily / 2007-07-13

all stock daily files

  file:    by_date/stock_daily/2007/2007-07-13.parquet
  size:    177 KB
  rows:    5,424
  symbols: 3,260

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-13	AAPL	Stock	4.8225	4.9232	4.8043	4.9189	907606000.0
2007-07-13	MSFT	Stock	29.94	30.02	29.66	29.82	42173000.0
2007-07-13	NVDA	Stock	0.767	0.7762	0.7637	0.7645	372630000.0
2007-07-13	AMZN	Stock	3.654	3.7675	3.6485	3.755	250040000.0
2007-07-13	TLT	Stock	84.45	84.5485	83.94	84.26	725900.0
2007-07-13	CL	Stock	33.99	34.375	33.965	34.225	5591800.0
2007-07-13	A	Stock	28.7482	28.7768	28.5408	28.5837	3641371.0
2007-07-13	AABA-DELISTED	Stock	26.87	26.97	26.5	26.58	17862467.0
2007-07-13	AACC-DELISTED	Stock	17.66	17.88	17.4	17.45	149830.0
2007-07-13	AAI-DELISTED	Stock	10.73	10.74	10.48	10.63	1494900.0
2007-07-13	AAIC-DELISTED	Stock	102.2	104.0	101.6	103.4	1353300.0
2007-07-13	AAME	Stock	4.02	4.02	4.02	4.02	300.0
2007-07-13	AAON	Stock	4.3588	4.5011	4.2877	4.4273	908972.0
2007-07-13	AAP	Stock	40.19	40.48	39.76	39.8	1122100.0
2007-07-13	AATI-DELISTED	Stock	9.73	9.9	9.69	9.81	154930.0
2007-07-13	AAU-DELISTED	Stock	2.79	2.79	2.68	2.73	42600.0
2007-07-13	AAUAF-DELISTED	Stock	2.79	2.79	2.68	2.7292	42600.0
2007-07-13	AAV-DELISTED	Stock	13.87	13.92	13.81	13.86	615200.0
2007-07-13	AAWW-DELISTED	Stock	59.86	60.54	59.65	60.33	46915.0
2007-07-13	AAXN-DELISTED	Stock	15.35	16.65	15.3	16.26	7906261.0
2007-07-13	AB	Stock	90.0	91.66	89.28	89.55	235200.0
2007-07-13	ABAX-DELISTED	Stock	19.94	19.96	19.21	19.4	451773.0
2007-07-13	ABB-DELISTED	Stock	24.87	24.9	24.6	24.8	3084300.0
2007-07-13	ABBC-DELISTED	Stock	9.79	9.81	9.76	9.81	152553.0
2007-07-13	ABBNY-DELISTED	Stock	24.87	24.9	24.6	24.82	3085000.0
2007-07-13	ABC-DELISTED	Stock	25.1	25.16	24.76	25.06	1453200.0
2007-07-13	ABCB	Stock	22.2249	22.2249	21.8941	22.0692	22619.0
2007-07-13	ABCO-DELISTED	Stock	28.4	28.8	28.22	28.68	124990.0
2007-07-13	ABCW-DELISTED	Stock	24.65	24.77	24.51	24.62	153410.0
2007-07-13	ABD-DELISTED	Stock	23.03	23.3	22.93	23.2	324200.0
2007-07-13	ABE-DELISTED	Stock	22.34	22.5	22.15	22.35	20700.0
2007-07-13	ABEO	Stock	6350.0	6350.0	6125.0	6125.0	7.0
2007-07-13	ABFS-DELISTED	Stock	40.18	40.32	39.85	39.97	203728.0
2007-07-13	ABG	Stock	24.49	24.7	23.9	24.13	323900.0
2007-07-13	ABK-DELISTED	Stock	85.45	85.88	84.75	85.48	954200.0
2007-07-13	ABM	Stock	25.69	25.69	25.51	25.57	115900.0
2007-07-13	ABMD-DELISTED	Stock	10.72	11.2	10.72	11.11	279402.0
2007-07-13	ABP-DELISTED	Stock	4.42	4.55	4.42	4.55	280200.0
2007-07-13	ABR	Stock	25.31	25.38	25.07	25.25	136800.0
2007-07-13	ABT	Stock	25.6933	25.7892	25.535	25.5446	10062526.0
2007-07-13	ABTL-DELISTED	Stock	21.1	22.0	21.0	21.25	20360.0
2007-07-13	ABV-DELISTED	Stock	74.2	75.04	73.45	74.86	403600.0
2007-07-13	ABVA-DELISTED	Stock	12.7	12.85	12.7	12.85	415.0
2007-07-13	ABX-DELISTED	Stock	31.99	32.13	31.73	32.01	4650690.0
2007-07-13	ACAD	Stock	13.5	13.7	13.37	13.7	322200.0
2007-07-13	ACAP-DELISTED	Stock	38.72	38.93	38.4	38.77	47032.0
2007-07-13	ACAS-DELISTED	Stock	45.8	46.15	45.5	46.03	1844635.0
2007-07-13	ACAT-DELISTED	Stock	19.99	20.0	19.29	19.52	179989.0
2007-07-13	ACC-DELISTED	Stock	28.38	28.95	28.19	28.84	269443.0
2007-07-13	ACCL-DELISTED	Stock	6.46	6.46	6.32	6.45	124341.0

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

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