PREVIEW / stock_1hour / 2010-05-06

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-05-06.parquet
  size:    994 KB
  rows:    47,056
  symbols: 3,492

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-05-06 04:00:00	AAPL	Stock	9.1129	9.2857	9.1129	9.1429	134400.0
2010-05-06 05:00:00	AAPL	Stock	9.1429	9.1429	9.1286	9.1286	5600.0
2010-05-06 06:00:00	AAPL	Stock	9.1357	9.1643	9.1339	9.1643	25200.0
2010-05-06 07:00:00	AAPL	Stock	9.1714	9.1918	9.1425	9.15	227752.0
2010-05-06 08:00:00	AAPL	Stock	9.155	9.1661	9.0536	9.0554	2983148.0
2010-05-06 09:00:00	AAPL	Stock	9.0536	9.2082	9.0357	9.1771	94677212.0
2010-05-06 10:00:00	AAPL	Stock	9.1789	9.2232	9.1096	9.1332	102607204.0
2010-05-06 11:00:00	AAPL	Stock	9.1336	9.1396	9.0446	9.1129	110559036.0
2010-05-06 12:00:00	AAPL	Stock	9.1136	9.1285	8.9807	9.0414	88154136.0
2010-05-06 13:00:00	AAPL	Stock	9.043	9.0607	8.9471	8.975	94182032.0
2010-05-06 14:00:00	AAPL	Stock	8.9739	8.9825	7.1161	8.6789	417971708.0
2010-05-06 15:00:00	AAPL	Stock	8.6775	9.0536	8.5643	8.7875	338303504.0
2010-05-06 16:00:00	AAPL	Stock	8.7886	8.9816	8.6191	8.7236	20572524.0
2010-05-06 17:00:00	AAPL	Stock	8.7286	8.8008	8.5764	8.625	3456544.0
2010-05-06 18:00:00	AAPL	Stock	8.625	8.6568	8.5364	8.5536	2753856.0
2010-05-06 19:00:00	AAPL	Stock	8.5675	9.1755	8.5196	8.6429	2350460.0
2010-05-06 06:00:00	MSFT	Stock	29.9	29.9	29.9	29.9	3100.0
2010-05-06 07:00:00	MSFT	Stock	29.9	29.9	29.77	29.84	2839.0
2010-05-06 08:00:00	MSFT	Stock	29.84	29.84	29.69	29.7	16627.0
2010-05-06 09:00:00	MSFT	Stock	29.7	29.8	29.52	29.76	6217460.0
2010-05-06 10:00:00	MSFT	Stock	29.76	29.84	29.63	29.68	9156998.0
2010-05-06 11:00:00	MSFT	Stock	29.67	29.75	29.58	29.72	12608616.0
2010-05-06 12:00:00	MSFT	Stock	29.73	29.88	29.67	29.765	6795914.0
2010-05-06 13:00:00	MSFT	Stock	29.76	29.81	29.61	29.671	12087326.0
2010-05-06 14:00:00	MSFT	Stock	29.68	29.74	27.91	28.8	40086457.0
2010-05-06 15:00:00	MSFT	Stock	28.8	29.56	28.56	28.98	33962333.0
2010-05-06 16:00:00	MSFT	Stock	28.98	29.86	28.9	28.97	4653324.0
2010-05-06 17:00:00	MSFT	Stock	29.704	29.704	28.8	28.95	43140.0
2010-05-06 18:00:00	MSFT	Stock	28.91	28.93	28.815	28.82	49125.0
2010-05-06 19:00:00	MSFT	Stock	28.85	28.98	28.63	28.96	14311.0
2010-05-06 07:00:00	NVDA	Stock	0.363	0.363	0.363	0.363	12000.0
2010-05-06 08:00:00	NVDA	Stock	0.3625	0.363	0.36	0.36	100640.0
2010-05-06 09:00:00	NVDA	Stock	0.36	0.3675	0.36	0.3639	74843640.0
2010-05-06 10:00:00	NVDA	Stock	0.3658	0.367	0.3572	0.3594	123748520.0
2010-05-06 11:00:00	NVDA	Stock	0.3598	0.3618	0.3576	0.3615	103688560.0
2010-05-06 12:00:00	NVDA	Stock	0.3618	0.3648	0.36	0.3608	85894400.0
2010-05-06 13:00:00	NVDA	Stock	0.3608	0.3612	0.3565	0.3578	109894640.0
2010-05-06 14:00:00	NVDA	Stock	0.3575	0.3582	0.326	0.3518	257062320.0
2010-05-06 15:00:00	NVDA	Stock	0.3518	0.3608	0.3462	0.355	210040480.0
2010-05-06 16:00:00	NVDA	Stock	0.354	0.364	0.35	0.355	21393400.0
2010-05-06 17:00:00	NVDA	Stock	0.3545	0.3545	0.3465	0.35	169400.0
2010-05-06 18:00:00	NVDA	Stock	0.35	0.35	0.3473	0.3475	160000.0
2010-05-06 19:00:00	NVDA	Stock	0.3475	0.35	0.3475	0.35	68000.0
2010-05-06 08:00:00	AMZN	Stock	6.5515	6.5515	6.5	6.5065	512500.0
2010-05-06 09:00:00	AMZN	Stock	6.4875	6.6165	6.48	6.5645	18893800.0
2010-05-06 10:00:00	AMZN	Stock	6.565	6.5968	6.455	6.4758	24708700.0
2010-05-06 11:00:00	AMZN	Stock	6.4765	6.504	6.439	6.5025	15528220.0
2010-05-06 12:00:00	AMZN	Stock	6.5	6.5875	6.4925	6.5325	20538100.0
2010-05-06 13:00:00	AMZN	Stock	6.533	6.5625	6.4825	6.511	17806420.0
2010-05-06 14:00:00	AMZN	Stock	6.511	6.539	6.03	6.343	49170960.0

> showing 50 of 47,056 rows — these rows as CSV

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