PREVIEW / stock_daily / 2011-01-05

all stock daily files

  file:    by_date/stock_daily/2011/2011-01-05.parquet
  size:    197 KB
  rows:    6,064
  symbols: 3,551

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
2011-01-05	AAPL	Stock	11.7696	11.9407	11.7679	11.9286	255519600.0
2011-01-05	MSFT	Stock	27.9	28.01	27.77	28.0	58998700.0
2011-01-05	NVDA	Stock	0.4015	0.425	0.3975	0.4245	1428216000.0
2011-01-05	AMZN	Stock	9.205	9.3725	9.2035	9.371	68376000.0
2011-01-05	TSLA	Stock	1.7653	1.7933	1.746	1.7887	21700500.0
2011-01-05	TLT	Stock	92.49	92.69	91.19	91.46	17569203.0
2011-01-05	ES	Stock	31.81	31.85	31.41	31.49	2333400.0
2011-01-05	CL	Stock	39.235	39.695	39.2	39.59	7206600.0
2011-01-05	A	Stock	29.5136	29.8498	29.3276	29.6137	4519035.0
2011-01-05	AABA-DELISTED	Stock	16.52	16.91	16.34	16.9	21606903.0
2011-01-05	AACC-DELISTED	Stock	6.1	6.17	6.01	6.15	30869.0
2011-01-05	AACG	Stock	3.78	3.82	3.66	3.7	6400.0
2011-01-05	AAI-DELISTED	Stock	7.46	7.5	7.45	7.47	1643476.0
2011-01-05	AAIC-DELISTED	Stock	23.92	24.84	23.92	24.65	63388.0
2011-01-05	AAME	Stock	2.06	2.06	2.06	2.06	5200.0
2011-01-05	AAON	Stock	5.5506	5.6316	5.4677	5.5802	357412.0
2011-01-05	AAP	Stock	62.32	63.21	61.96	62.32	1426100.0
2011-01-05	AATI-DELISTED	Stock	3.86	3.92	3.82	3.89	65463.0
2011-01-05	AAU-DELISTED	Stock	4.75	4.8498	4.49	4.79	642458.0
2011-01-05	AAUAF-DELISTED	Stock	4.76	4.86	4.5	4.78	646830.0
2011-01-05	AAV-DELISTED	Stock	6.75	6.94	6.74	6.94	299369.0
2011-01-05	AAWW-DELISTED	Stock	53.9	54.4999	53.54	53.97	231588.0
2011-01-05	AAXJ	Stock	64.44	64.91	64.44	64.78	314855.0
2011-01-05	AAXN-DELISTED	Stock	4.77	4.88	4.69	4.875	496579.0
2011-01-05	AB	Stock	23.58	23.82	23.26	23.57	333400.0
2011-01-05	ABAC-DELISTED	Stock	5.885	6.0	5.67	5.78	40275.0
2011-01-05	ABAX-DELISTED	Stock	26.15	26.5	26.05	26.37	77412.0
2011-01-05	ABB-DELISTED	Stock	21.88	22.01	21.75	21.91	2983477.0
2011-01-05	ABBC-DELISTED	Stock	11.67	11.92	11.65	11.9	52804.0
2011-01-05	ABBNY-DELISTED	Stock	21.88	22.01	21.75	21.92	3003827.0
2011-01-05	ABC-DELISTED	Stock	33.93	34.49	33.92	34.48	3589693.0
2011-01-05	ABCB	Stock	10.59	11.1	10.55	11.07	36500.0
2011-01-05	ABCD-DELISTED	Stock	3.39	3.5	3.39	3.43	21234.0
2011-01-05	ABCO-DELISTED	Stock	24.11	24.79	23.92	24.63	102935.0
2011-01-05	ABCW-DELISTED	Stock	1.2011	1.2798	1.1814	1.27	141940.0
2011-01-05	ABD-DELISTED	Stock	8.74	8.94	8.69	8.85	222840.0
2011-01-05	ABE-DELISTED	Stock	19.23	19.355	19.16	19.34	2940.0
2011-01-05	ABEO	Stock	3062.5	3062.5	3000.0	3062.5	10.0
2011-01-05	ABFS-DELISTED	Stock	27.33	27.36	26.67	26.84	220231.0
2011-01-05	ABG	Stock	18.5	18.79	18.27	18.63	138800.0
2011-01-05	ABH-DELISTED	Stock	23.25	23.89	22.99	23.4	793037.0
2011-01-05	ABM	Stock	26.03	26.5	25.94	26.5	227700.0
2011-01-05	ABMD-DELISTED	Stock	9.8	10.06	9.71	10.01	217965.0
2011-01-05	ABR	Stock	5.68	5.82	5.65	5.8	29500.0
2011-01-05	ABT	Stock	23.136	23.4238	23.064	23.1599	28342643.0
2011-01-05	ABTL-DELISTED	Stock	4.3447	4.8648	4.3412	4.8053	47232.0
2011-01-05	ABUS	Stock	4.75	4.75	4.62	4.65	1800.0
2011-01-05	ABV-DELISTED	Stock	31.22	31.22	30.47	30.54	2965205.0
2011-01-05	ABVT-DELISTED	Stock	60.94	62.14	60.85	62.06	102942.0
2011-01-05	ABX-DELISTED	Stock	51.18	51.25	49.89	49.89	16038520.0

> showing 50 of 6,064 rows — these rows as CSV

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