PREVIEW / stock_daily / 2007-05-21

all stock daily files

  file:    by_date/stock_daily/2007/2007-05-21.parquet
  size:    176 KB
  rows:    5,372
  symbols: 3,230

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-05-21	AAPL	Stock	3.9396	4.0161	3.9304	3.9993	639892400.0
2007-05-21	MSFT	Stock	30.73	31.16	30.73	31.05	41836400.0
2007-05-21	NVDA	Stock	0.582	0.6	0.5792	0.5855	645768000.0
2007-05-21	AMZN	Stock	3.179	3.434	3.165	3.415	729376000.0
2007-05-21	TLT	Stock	86.93	87.24	86.8305	87.19	831063.0
2007-05-21	CL	Stock	33.66	33.66	33.265	33.515	5068000.0
2007-05-21	A	Stock	26.8956	27.5393	26.8956	27.4106	4919702.0
2007-05-21	AABA-DELISTED	Stock	29.62	29.86	29.32	29.35	16509436.0
2007-05-21	AACC-DELISTED	Stock	18.57	18.72	18.52	18.53	154516.0
2007-05-21	AAI-DELISTED	Stock	11.99	12.12	11.87	11.98	1084413.0
2007-05-21	AAIC-DELISTED	Stock	110.8	114.2	110.8	114.0	1192200.0
2007-05-21	AAME	Stock	4.9	5.05	4.76	5.05	22700.0
2007-05-21	AAON	Stock	3.6359	3.7307	3.6359	3.7017	497391.0
2007-05-21	AAP	Stock	40.43	41.71	40.43	41.64	2260600.0
2007-05-21	AATI-DELISTED	Stock	7.95	8.01	7.89	7.99	236972.0
2007-05-21	AAU-DELISTED	Stock	2.38	2.4	2.33	2.37	50500.0
2007-05-21	AAUAF-DELISTED	Stock	2.38	2.4	2.33	2.371	52000.0
2007-05-21	AAV-DELISTED	Stock	12.85	13.25	12.65	13.17	1311200.0
2007-05-21	AAWW-DELISTED	Stock	58.72	58.87	58.38	58.68	62883.0
2007-05-21	AAXN-DELISTED	Stock	9.26	9.45	9.23	9.32	1157562.0
2007-05-21	AB	Stock	90.03	91.25	90.01	90.32	307100.0
2007-05-21	ABAX-DELISTED	Stock	20.95	21.7	20.72	21.68	169757.0
2007-05-21	ABB-DELISTED	Stock	20.35	20.4	20.31	20.37	1511000.0
2007-05-21	ABBC-DELISTED	Stock	18.4	18.4	18.15	18.33	10907.0
2007-05-21	ABBNY-DELISTED	Stock	20.35	20.4	20.31	20.38	2721500.0
2007-05-21	ABC-DELISTED	Stock	25.48	25.94	25.34	25.82	2778098.0
2007-05-21	ABCB	Stock	22.3027	22.5751	22.1859	22.3222	28890.0
2007-05-21	ABCO-DELISTED	Stock	24.53	24.99	24.51	24.65	231365.0
2007-05-21	ABCW-DELISTED	Stock	28.25	28.42	28.16	28.37	115310.0
2007-05-21	ABD-DELISTED	Stock	23.13	23.41	23.07	23.36	205000.0
2007-05-21	ABE-DELISTED	Stock	21.2	22.0	21.2	21.75	19100.0
2007-05-21	ABEO	Stock	6262.5	6550.0	6250.0	6437.5	4.0
2007-05-21	ABFS-DELISTED	Stock	39.06	39.67	39.06	39.54	232297.0
2007-05-21	ABG	Stock	27.0	27.36	26.96	27.1	528900.0
2007-05-21	ABK-DELISTED	Stock	95.91	96.09	95.13	95.29	564600.0
2007-05-21	ABM	Stock	28.32	28.82	28.16	28.73	134100.0
2007-05-21	ABMD-DELISTED	Stock	11.98	12.15	11.68	11.93	174084.0
2007-05-21	ABP-DELISTED	Stock	3.96	4.09	3.68	3.68	272500.0
2007-05-21	ABR	Stock	27.3	28.4	27.3	28.16	129200.0
2007-05-21	ABT	Stock	28.4282	28.4761	28.0683	28.1307	9604210.0
2007-05-21	ABTL-DELISTED	Stock	20.38	22.97	20.38	22.42	84538.0
2007-05-21	ABV-DELISTED	Stock	68.4	68.95	67.9	68.6	539300.0
2007-05-21	ABVA-DELISTED	Stock	13.31	13.79	13.26	13.69	93122.0
2007-05-21	ABX-DELISTED	Stock	29.9	30.47	29.69	30.22	3407100.0
2007-05-21	ACAD	Stock	13.24	13.59	13.12	13.43	248900.0
2007-05-21	ACAP-DELISTED	Stock	38.75	38.86	38.29	38.33	49315.0
2007-05-21	ACAS-DELISTED	Stock	46.59	47.17	46.51	46.85	726997.0
2007-05-21	ACAT-DELISTED	Stock	19.39	19.82	19.35	19.5	138975.0
2007-05-21	ACC-DELISTED	Stock	27.31	28.14	27.31	27.94	76700.0
2007-05-21	ACCL-DELISTED	Stock	6.18	6.5	6.18	6.4799	68699.0

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

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