PREVIEW / stock_daily / 2007-09-14

all stock daily files

  file:    by_date/stock_daily/2007/2007-09-14.parquet
  size:    175 KB
  rows:    5,447
  symbols: 3,275

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-14	AAPL	Stock	4.8775	4.9636	4.8643	4.9575	607320000.0
2007-09-14	MSFT	Stock	28.98	29.11	28.88	29.04	33496600.0
2007-09-14	NVDA	Stock	0.8225	0.8235	0.8038	0.8062	487308000.0
2007-09-14	AMZN	Stock	4.3205	4.4045	4.3155	4.3885	79094000.0
2007-09-14	TLT	Stock	90.58	90.59	89.62	89.91	1357170.0
2007-09-14	CL	Stock	33.695	34.12	33.635	34.015	4368000.0
2007-09-14	A	Stock	25.9156	26.1731	25.7296	25.8655	2444263.0
2007-09-14	AABA-DELISTED	Stock	23.69	25.0	23.65	24.73	24641404.0
2007-09-14	AACC-DELISTED	Stock	9.74	9.87	9.59	9.68	119797.0
2007-09-14	AAI-DELISTED	Stock	10.29	10.55	10.25	10.31	928600.0
2007-09-14	AAIC-DELISTED	Stock	95.8	98.6	95.2	97.6	871800.0
2007-09-14	AAME	Stock	2.85	3.03	2.85	2.99	4000.0
2007-09-14	AAON	Stock	3.7531	3.7531	3.6346	3.676	456131.0
2007-09-14	AAP	Stock	33.32	34.18	33.22	34.01	546300.0
2007-09-14	AATI-DELISTED	Stock	9.74	9.9	9.51	9.84	211903.0
2007-09-14	AAU-DELISTED	Stock	2.18	2.27	2.15	2.18	60200.0
2007-09-14	AAUAF-DELISTED	Stock	2.18	2.27	2.15	2.18	60200.0
2007-09-14	AAV-DELISTED	Stock	11.45	11.51	11.36	11.44	288495.0
2007-09-14	AAWW-DELISTED	Stock	52.81	53.08	52.07	52.42	121714.0
2007-09-14	AAXN-DELISTED	Stock	14.29	14.48	14.23	14.36	882597.0
2007-09-14	AB	Stock	78.2	81.47	78.2	81.44	226200.0
2007-09-14	ABAX-DELISTED	Stock	20.07	21.09	20.0	21.01	255136.0
2007-09-14	ABB-DELISTED	Stock	23.61	23.86	23.53	23.8	935900.0
2007-09-14	ABBC-DELISTED	Stock	9.59	9.7	9.51	9.58	21756.0
2007-09-14	ABBNY-DELISTED	Stock	23.61	23.86	23.53	23.8	971400.0
2007-09-14	ABC-DELISTED	Stock	22.99	22.99	22.02	22.3	4538000.0
2007-09-14	ABCB	Stock	17.809	17.8967	17.4103	17.5757	78035.0
2007-09-14	ABCO-DELISTED	Stock	27.69	27.84	27.38	27.82	198534.0
2007-09-14	ABCW-DELISTED	Stock	27.24	28.0	27.02	27.83	112020.0
2007-09-14	ABD-DELISTED	Stock	20.75	21.65	20.75	21.47	404200.0
2007-09-14	ABE-DELISTED	Stock	21.6	21.95	21.6	21.75	14000.0
2007-09-14	ABEO	Stock	5937.5	5937.5	5587.5	5587.5	7.0
2007-09-14	ABFS-DELISTED	Stock	33.11	33.91	32.86	33.88	378885.0
2007-09-14	ABG	Stock	19.96	20.36	19.76	20.31	292800.0
2007-09-14	ABK-DELISTED	Stock	62.26	62.46	61.0	61.94	1436900.0
2007-09-14	ABM	Stock	19.93	20.37	19.83	20.03	412400.0
2007-09-14	ABMD-DELISTED	Stock	11.41	11.5	11.16	11.22	97903.0
2007-09-14	ABP-DELISTED	Stock	3.42	3.49	3.38	3.41	141300.0
2007-09-14	ABR	Stock	18.81	19.96	17.6	19.93	195400.0
2007-09-14	ABT	Stock	24.9208	25.0839	24.8488	24.9976	8456440.0
2007-09-14	ABTL-DELISTED	Stock	14.75	15.1	14.6	15.1	3655.0
2007-09-14	ABV-DELISTED	Stock	67.68	70.12	67.68	68.97	329500.0
2007-09-14	ABVA-DELISTED	Stock	10.09	10.1	9.96	10.09	204041.0
2007-09-14	ABVT-DELISTED	Stock	75.25	76.25	75.0	76.0	18810.0
2007-09-14	ABX-DELISTED	Stock	37.19	38.31	36.82	37.2	5792600.0
2007-09-14	ACAD	Stock	15.68	15.83	15.08	15.38	116800.0
2007-09-14	ACAP-DELISTED	Stock	35.7	37.33	35.31	36.97	84612.0
2007-09-14	ACAS-DELISTED	Stock	39.17	39.37	38.89	39.26	1159701.0
2007-09-14	ACAT-DELISTED	Stock	15.9	16.18	15.8	16.18	127683.0
2007-09-14	ACC-DELISTED	Stock	28.18	28.6	28.18	28.53	68081.0

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

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