PREVIEW / stock_1hour / 2009-11-05

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-11-05.parquet
  size:    891 KB
  rows:    42,700
  symbols: 3,399

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
2009-11-05 04:00:00	AAPL	Stock	6.8286	6.8286	6.8286	6.8286	2800.0
2009-11-05 06:00:00	AAPL	Stock	6.8286	6.8286	6.8286	6.8286	7196.0
2009-11-05 07:00:00	AAPL	Stock	6.8339	6.8339	6.8229	6.8229	14000.0
2009-11-05 08:00:00	AAPL	Stock	6.8339	6.875	6.8339	6.8596	1603588.0
2009-11-05 09:00:00	AAPL	Stock	6.8596	6.9071	6.8146	6.9036	64482852.0
2009-11-05 10:00:00	AAPL	Stock	6.9039	6.9643	6.8943	6.9457	87255700.0
2009-11-05 11:00:00	AAPL	Stock	6.9464	6.9536	6.9107	6.9143	43340976.0
2009-11-05 12:00:00	AAPL	Stock	6.9139	6.945	6.91	6.9207	24169628.0
2009-11-05 13:00:00	AAPL	Stock	6.9211	6.9321	6.9107	6.9214	29136380.0
2009-11-05 14:00:00	AAPL	Stock	6.9211	6.9425	6.9211	6.9311	36709596.0
2009-11-05 15:00:00	AAPL	Stock	6.9307	6.9379	6.9018	6.9343	68808992.0
2009-11-05 16:00:00	AAPL	Stock	6.9346	6.9364	6.9117	6.9304	10861928.0
2009-11-05 17:00:00	AAPL	Stock	6.9304	6.9321	6.9286	6.9289	259000.0
2009-11-05 18:00:00	AAPL	Stock	6.9296	6.9339	6.9296	6.9307	2879576.0
2009-11-05 19:00:00	AAPL	Stock	6.9329	6.9329	6.9286	6.9286	75712.0
2009-11-05 05:00:00	MSFT	Stock	28.29	28.29	28.29	28.29	300.0
2009-11-05 07:00:00	MSFT	Stock	28.31	28.41	28.3	28.35	3941.0
2009-11-05 08:00:00	MSFT	Stock	28.35	28.44	28.06	28.41	27960.0
2009-11-05 09:00:00	MSFT	Stock	28.45	28.6	28.06	28.51	5667279.0
2009-11-05 10:00:00	MSFT	Stock	28.502	28.74	28.463	28.675	9826247.0
2009-11-05 11:00:00	MSFT	Stock	28.685	28.72	28.6	28.64	5226145.0
2009-11-05 12:00:00	MSFT	Stock	28.631	28.72	28.58	28.63	5865046.0
2009-11-05 13:00:00	MSFT	Stock	28.63	28.65	28.518	28.555	4459201.0
2009-11-05 14:00:00	MSFT	Stock	28.555	28.62	28.53	28.6	5051121.0
2009-11-05 15:00:00	MSFT	Stock	28.6	28.6	28.4	28.47	8591002.0
2009-11-05 16:00:00	MSFT	Stock	28.48	28.609	28.4	28.51	4001582.0
2009-11-05 17:00:00	MSFT	Stock	28.666	28.666	28.46	28.53	22705.0
2009-11-05 18:00:00	MSFT	Stock	28.51	28.51	28.47	28.5	46735.0
2009-11-05 19:00:00	MSFT	Stock	28.49	28.5	28.49	28.5	866.0
2009-11-05 07:00:00	NVDA	Stock	0.3058	0.3058	0.3	0.3	41600.0
2009-11-05 08:00:00	NVDA	Stock	0.3038	0.3045	0.3038	0.3045	337200.0
2009-11-05 09:00:00	NVDA	Stock	0.3045	0.3073	0.302	0.3062	87137960.0
2009-11-05 10:00:00	NVDA	Stock	0.3062	0.3098	0.3052	0.308	140802880.0
2009-11-05 11:00:00	NVDA	Stock	0.308	0.3085	0.3035	0.3038	96243160.0
2009-11-05 12:00:00	NVDA	Stock	0.3038	0.306	0.3033	0.306	78119760.0
2009-11-05 13:00:00	NVDA	Stock	0.306	0.3068	0.3045	0.3055	87684200.0
2009-11-05 14:00:00	NVDA	Stock	0.3058	0.3068	0.303	0.3035	105079560.0
2009-11-05 15:00:00	NVDA	Stock	0.3038	0.3078	0.303	0.3065	248673800.0
2009-11-05 16:00:00	NVDA	Stock	0.3068	0.331	0.3025	0.3238	54428000.0
2009-11-05 17:00:00	NVDA	Stock	0.3238	0.33	0.3233	0.3243	19970640.0
2009-11-05 18:00:00	NVDA	Stock	0.3248	0.327	0.3243	0.3253	3940520.0
2009-11-05 19:00:00	NVDA	Stock	0.3258	0.3268	0.325	0.325	1946320.0
2009-11-05 08:00:00	AMZN	Stock	5.89	5.89	5.87	5.887	51260.0
2009-11-05 09:00:00	AMZN	Stock	5.888	5.9375	5.8125	5.9215	30895380.0
2009-11-05 10:00:00	AMZN	Stock	5.9205	6.035	5.9165	6.0345	48897820.0
2009-11-05 11:00:00	AMZN	Stock	6.0335	6.038	5.9539	5.959	25752120.0
2009-11-05 12:00:00	AMZN	Stock	5.959	6.017	5.9485	5.9835	14806800.0
2009-11-05 13:00:00	AMZN	Stock	5.983	6.0165	5.9735	5.9925	11799300.0
2009-11-05 14:00:00	AMZN	Stock	5.9925	6.0085	5.984	6.0085	12908460.0
2009-11-05 15:00:00	AMZN	Stock	6.0085	6.0475	5.99	6.031	29264120.0

> showing 50 of 42,700 rows — these rows as CSV

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