PREVIEW / stock_daily / 2007-09-19

all stock daily files

  file:    by_date/stock_daily/2007/2007-09-19.parquet
  size:    178 KB
  rows:    5,516
  symbols: 3,331

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-09-19	AAPL	Stock	5.1079	5.1129	4.9786	5.0275	1026880400.0
2007-09-19	MSFT	Stock	28.87	28.91	28.3	28.67	94242200.0
2007-09-19	NVDA	Stock	0.883	0.9	0.8505	0.859	521360000.0
2007-09-19	AMZN	Stock	4.476	4.491	4.413	4.45	129174000.0
2007-09-19	TLT	Stock	88.71	89.01	88.37	88.83	3854630.0
2007-09-19	CL	Stock	34.73	35.025	34.25	34.945	5188600.0
2007-09-19	A	Stock	26.6452	26.8455	26.5021	26.6524	3213862.0
2007-09-19	AABA-DELISTED	Stock	25.09	25.37	24.81	25.3099	21222312.0
2007-09-19	AACC-DELISTED	Stock	10.29	10.67	10.27	10.64	358630.0
2007-09-19	AAI-DELISTED	Stock	10.46	10.77	10.46	10.55	773500.0
2007-09-19	AAIC-DELISTED	Stock	105.2	107.0	101.4	104.0	2101600.0
2007-09-19	AAME	Stock	2.82	2.86	2.8	2.84	1900.0
2007-09-19	AAON	Stock	4.0356	4.1877	3.9565	4.1067	405506.0
2007-09-19	AAP	Stock	35.0	35.5	34.21	34.45	1206200.0
2007-09-19	AATI-DELISTED	Stock	10.5	10.97	10.45	10.87	1628613.0
2007-09-19	AAU-DELISTED	Stock	2.3	2.31	2.19	2.26	46400.0
2007-09-19	AAUAF-DELISTED	Stock	2.3	2.31	2.192	2.26	46400.0
2007-09-19	AAV-DELISTED	Stock	11.4	11.54	11.35	11.46	666600.0
2007-09-19	AAWW-DELISTED	Stock	53.89	54.96	53.89	54.6	129529.0
2007-09-19	AAXN-DELISTED	Stock	15.25	15.77	15.2	15.77	3206726.0
2007-09-19	AB	Stock	84.3	88.55	84.1	87.95	634500.0
2007-09-19	ABAX-DELISTED	Stock	21.9	22.52	21.72	21.78	294473.0
2007-09-19	ABB-DELISTED	Stock	24.86	24.92	24.54	24.71	2603300.0
2007-09-19	ABBC-DELISTED	Stock	9.7	9.78	9.65	9.74	210924.0
2007-09-19	ABBNY-DELISTED	Stock	24.86	24.92	24.54	24.69	2767700.0
2007-09-19	ABC-DELISTED	Stock	23.1	23.1	22.91	22.95	3040600.0
2007-09-19	ABCB	Stock	18.4121	19.4432	18.2176	19.4432	61482.0
2007-09-19	ABCO-DELISTED	Stock	29.14	29.9	28.99	29.51	127998.0
2007-09-19	ABCW-DELISTED	Stock	28.72	29.1	28.54	28.99	118070.0
2007-09-19	ABD-DELISTED	Stock	21.79	22.61	21.63	22.45	619340.0
2007-09-19	ABE-DELISTED	Stock	22.84	22.8499	22.3	22.3	34100.0
2007-09-19	ABEO	Stock	5937.5	5962.5	5687.5	5862.5	14.0
2007-09-19	ABFS-DELISTED	Stock	35.03	35.7	34.12	34.3	261192.0
2007-09-19	ABG	Stock	22.39	23.17	22.36	22.56	478000.0
2007-09-19	ABK-DELISTED	Stock	65.87	71.34	65.86	68.98	3894800.0
2007-09-19	ABM	Stock	21.02	21.14	20.65	20.81	265300.0
2007-09-19	ABMD-DELISTED	Stock	11.99	12.49	11.96	12.48	187033.0
2007-09-19	ABP-DELISTED	Stock	3.52	3.57	3.4	3.54	170400.0
2007-09-19	ABR	Stock	20.83	21.97	20.72	21.36	387500.0
2007-09-19	ABT	Stock	25.8132	26.0052	25.6069	25.8852	12706336.0
2007-09-19	ABTL-DELISTED	Stock	15.175	15.525	14.924	15.475	11940.0
2007-09-19	ABV-DELISTED	Stock	70.65	72.26	70.4	71.14	767200.0
2007-09-19	ABVA-DELISTED	Stock	9.946	9.946	9.75	9.89	2100.0
2007-09-19	ABVT-DELISTED	Stock	80.0	80.0	80.0	80.0	200.0
2007-09-19	ABX-DELISTED	Stock	39.08	39.6	38.4	38.72	7979413.0
2007-09-19	ACAD	Stock	15.44	15.91	15.44	15.68	658300.0
2007-09-19	ACAP-DELISTED	Stock	39.37	39.79	38.02	39.21	82181.0
2007-09-19	ACAS-DELISTED	Stock	40.47	41.25	40.4	41.22	2468707.0
2007-09-19	ACAT-DELISTED	Stock	16.35	16.71	16.23	16.59	128033.0
2007-09-19	ACC-DELISTED	Stock	28.61	29.16	28.48	28.58	178258.0

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

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