PREVIEW / stock_daily / 2007-07-20

all stock daily files

  file:    by_date/stock_daily/2007/2007-07-20.parquet
  size:    178 KB
  rows:    5,434
  symbols: 3,263

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-20	AAPL	Stock	5.0589	5.1493	5.0	5.1339	1167773600.0
2007-07-20	MSFT	Stock	31.15	31.2	30.79	31.16	98292600.0
2007-07-20	NVDA	Stock	0.765	0.7677	0.748	0.7517	505650000.0
2007-07-20	AMZN	Stock	3.631	3.648	3.525	3.5815	182614000.0
2007-07-20	TLT	Stock	85.38	86.08	85.32	85.96	1461250.0
2007-07-20	CL	Stock	34.185	34.37	33.785	33.84	6288400.0
2007-07-20	A	Stock	28.5265	28.5265	28.1617	28.1688	3164932.0
2007-07-20	AABA-DELISTED	Stock	25.7	25.89	25.2	25.35	33613076.0
2007-07-20	AACC-DELISTED	Stock	15.32	15.37	14.83	14.88	270194.0
2007-07-20	AAI-DELISTED	Stock	10.49	10.6	10.26	10.27	2717100.0
2007-07-20	AAIC-DELISTED	Stock	101.6	102.0	96.4	99.8	2480100.0
2007-07-20	AAME	Stock	3.8	3.95	3.77	3.79	8700.0
2007-07-20	AAON	Stock	4.534	4.5366	4.2825	4.3088	634078.0
2007-07-20	AAP	Stock	38.91	39.22	38.7	38.78	950100.0
2007-07-20	AATI-DELISTED	Stock	10.23	10.27	9.95	10.0	348576.0
2007-07-20	AAU-DELISTED	Stock	2.73	2.75	2.68	2.75	105600.0
2007-07-20	AAUAF-DELISTED	Stock	2.73	2.75	2.68	2.75	105600.0
2007-07-20	AAV-DELISTED	Stock	13.95	13.95	13.8	13.84	689200.0
2007-07-20	AAWW-DELISTED	Stock	59.71	59.87	58.68	59.04	91512.0
2007-07-20	AAXN-DELISTED	Stock	17.25	17.58	16.92	17.14	5585270.0
2007-07-20	AB	Stock	88.72	89.03	86.12	86.43	405100.0
2007-07-20	ABAX-DELISTED	Stock	18.6	18.93	18.3	18.56	348712.0
2007-07-20	ABB-DELISTED	Stock	24.27	24.34	23.9	24.13	3011300.0
2007-07-20	ABBC-DELISTED	Stock	9.69	9.77	9.399	9.47	61338.0
2007-07-20	ABBNY-DELISTED	Stock	24.27	24.34	23.9	24.09	3011700.0
2007-07-20	ABC-DELISTED	Stock	25.55	25.55	24.11	24.14	2634670.0
2007-07-20	ABCB	Stock	21.1938	21.3106	19.5015	19.978	88111.0
2007-07-20	ABCO-DELISTED	Stock	27.99	28.04	27.24	27.6	230308.0
2007-07-20	ABCW-DELISTED	Stock	23.93	24.03	22.95	23.33	244480.0
2007-07-20	ABD-DELISTED	Stock	22.54	22.54	21.73	21.96	321700.0
2007-07-20	ABE-DELISTED	Stock	22.99	22.99	22.5	22.7	13300.0
2007-07-20	ABEO	Stock	5625.0	5625.0	5375.0	5437.5	12.0
2007-07-20	ABFS-DELISTED	Stock	41.25	41.25	39.62	40.23	347213.0
2007-07-20	ABG	Stock	23.8	24.5	23.26	23.63	367600.0
2007-07-20	ABK-DELISTED	Stock	81.55	82.06	78.94	80.29	3400000.0
2007-07-20	ABM	Stock	24.91	24.93	23.74	24.19	315000.0
2007-07-20	ABMD-DELISTED	Stock	11.15	11.17	10.48	10.81	357389.0
2007-07-20	ABP-DELISTED	Stock	4.35	4.39	4.26	4.35	105300.0
2007-07-20	ABR	Stock	24.92	24.92	24.05	24.28	199800.0
2007-07-20	ABT	Stock	26.0531	26.1347	25.2855	25.367	15715715.0
2007-07-20	ABTL-DELISTED	Stock	20.93	21.03	20.47	20.52	29255.0
2007-07-20	ABV-DELISTED	Stock	75.3	76.09	74.42	75.03	545500.0
2007-07-20	ABVA-DELISTED	Stock	12.7	12.7	12.41	12.59	1265.0
2007-07-20	ABVT-DELISTED	Stock	70.0	73.0	70.0	72.0	167325.0
2007-07-20	ABX-DELISTED	Stock	34.23	34.53	33.9	34.5	7327209.0
2007-07-20	ACAD	Stock	13.9	14.2	13.62	13.68	409800.0
2007-07-20	ACAP-DELISTED	Stock	35.75	36.0	34.66	34.97	204816.0
2007-07-20	ACAS-DELISTED	Stock	44.39	44.88	43.56	43.66	2317384.0
2007-07-20	ACAT-DELISTED	Stock	20.19	20.19	19.17	19.62	95164.0
2007-07-20	ACC-DELISTED	Stock	28.14	28.14	27.3	27.76	177400.0

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

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