PREVIEW / stock_1hour / 2010-11-04

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-11-04.parquet
  size:    941 KB
  rows:    44,745
  symbols: 3,518

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2010-11-04 04:00:00	AAPL	Stock	11.1907	11.25	11.1789	11.25	19880.0
2010-11-04 06:00:00	AAPL	Stock	11.2554	11.2554	11.2554	11.2554	5600.0
2010-11-04 07:00:00	AAPL	Stock	11.2668	11.2775	11.2357	11.2464	457296.0
2010-11-04 08:00:00	AAPL	Stock	11.2464	11.2943	11.2439	11.2854	5298720.0
2010-11-04 09:00:00	AAPL	Stock	11.285	11.3443	11.2511	11.3287	100029412.0
2010-11-04 10:00:00	AAPL	Stock	11.3298	11.4232	11.2932	11.4164	133557788.0
2010-11-04 11:00:00	AAPL	Stock	11.4164	11.435	11.3729	11.3786	112177716.0
2010-11-04 12:00:00	AAPL	Stock	11.3771	11.3882	11.3511	11.3756	52945172.0
2010-11-04 13:00:00	AAPL	Stock	11.3768	11.3914	11.3607	11.3607	38736404.0
2010-11-04 14:00:00	AAPL	Stock	11.3611	11.3857	11.3493	11.3636	46202072.0
2010-11-04 15:00:00	AAPL	Stock	11.3636	11.3792	11.3143	11.3661	106279656.0
2010-11-04 16:00:00	AAPL	Stock	11.3668	11.3693	11.3096	11.3179	31284008.0
2010-11-04 17:00:00	AAPL	Stock	11.3175	11.3354	11.3093	11.3321	983780.0
2010-11-04 18:00:00	AAPL	Stock	11.3314	11.3668	11.3125	11.3221	2027116.0
2010-11-04 19:00:00	AAPL	Stock	11.3232	11.3307	11.31	11.3107	1588440.0
2010-11-04 04:00:00	MSFT	Stock	27.31	27.31	27.31	27.31	200.0
2010-11-04 05:00:00	MSFT	Stock	27.45	27.45	27.45	27.45	3900.0
2010-11-04 06:00:00	MSFT	Stock	27.45	27.45	27.44	27.44	3000.0
2010-11-04 07:00:00	MSFT	Stock	27.4	27.4	27.35	27.38	5000.0
2010-11-04 08:00:00	MSFT	Stock	27.35	27.4	27.29	27.35	101493.0
2010-11-04 09:00:00	MSFT	Stock	27.35	27.44	27.15	27.15	11487923.0
2010-11-04 10:00:00	MSFT	Stock	27.16	27.25	27.09	27.175	12528556.0
2010-11-04 11:00:00	MSFT	Stock	27.17	27.22	27.11	27.122	8686544.0
2010-11-04 12:00:00	MSFT	Stock	27.115	27.19	27.07	27.17	8266979.0
2010-11-04 13:00:00	MSFT	Stock	27.17	27.19	27.06	27.135	5929769.0
2010-11-04 14:00:00	MSFT	Stock	27.135	27.21	27.12	27.141	7163301.0
2010-11-04 15:00:00	MSFT	Stock	27.15	27.17	27.01	27.12	14434671.0
2010-11-04 16:00:00	MSFT	Stock	27.13	27.23	27.06	27.13	4649441.0
2010-11-04 17:00:00	MSFT	Stock	27.15	27.15	27.1	27.11	34493.0
2010-11-04 18:00:00	MSFT	Stock	27.14	27.14	27.08	27.1	43246.0
2010-11-04 19:00:00	MSFT	Stock	27.1	27.11	27.1	27.1	6792.0
2010-11-04 08:00:00	NVDA	Stock	0.311	0.313	0.311	0.313	429360.0
2010-11-04 09:00:00	NVDA	Stock	0.313	0.3153	0.3123	0.3128	81785400.0
2010-11-04 10:00:00	NVDA	Stock	0.3128	0.3158	0.3115	0.3155	70788720.0
2010-11-04 11:00:00	NVDA	Stock	0.3158	0.3158	0.312	0.3123	66038760.0
2010-11-04 12:00:00	NVDA	Stock	0.312	0.3128	0.311	0.3125	94640880.0
2010-11-04 13:00:00	NVDA	Stock	0.3124	0.3128	0.3115	0.3118	79150200.0
2010-11-04 14:00:00	NVDA	Stock	0.3118	0.312	0.3115	0.3118	49829120.0
2010-11-04 15:00:00	NVDA	Stock	0.3116	0.312	0.3095	0.31	235068120.0
2010-11-04 16:00:00	NVDA	Stock	0.3098	0.312	0.3095	0.312	4274760.0
2010-11-04 17:00:00	NVDA	Stock	0.311	0.312	0.3098	0.3098	248040.0
2010-11-04 18:00:00	NVDA	Stock	0.3098	0.3115	0.3062	0.3088	561280.0
2010-11-04 19:00:00	NVDA	Stock	0.31	0.31	0.3062	0.3075	102960.0
2010-11-04 04:00:00	AMZN	Stock	8.44	8.45	8.44	8.45	4000.0
2010-11-04 06:00:00	AMZN	Stock	8.499	8.5	8.499	8.5	19980.0
2010-11-04 07:00:00	AMZN	Stock	8.4985	8.4985	8.495	8.4985	21000.0
2010-11-04 08:00:00	AMZN	Stock	8.4875	8.495	8.45	8.485	442360.0
2010-11-04 09:00:00	AMZN	Stock	8.485	8.6265	8.475	8.5775	25673020.0
2010-11-04 10:00:00	AMZN	Stock	8.5785	8.5845	8.5334	8.5705	19667240.0
2010-11-04 11:00:00	AMZN	Stock	8.5715	8.58	8.5	8.5483	16951760.0

> showing 50 of 44,745 rows — these rows as CSV

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