PREVIEW / stock_1hour / 2008-05-14

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-05-14.parquet
  size:    851 KB
  rows:    40,845
  symbols: 3,324

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
2008-05-14 04:00:00	AAPL	Stock	6.7975	6.7975	6.7975	6.7975	11200.0
2008-05-14 07:00:00	AAPL	Stock	6.7879	6.7943	6.7875	6.7943	15400.0
2008-05-14 08:00:00	AAPL	Stock	6.7843	6.8464	6.7836	6.8339	5097456.0
2008-05-14 09:00:00	AAPL	Stock	6.8339	6.8657	6.8214	6.8343	116171552.0
2008-05-14 10:00:00	AAPL	Stock	6.835	6.8475	6.7768	6.7879	156924684.0
2008-05-14 11:00:00	AAPL	Stock	6.7879	6.8061	6.7689	6.7907	101620932.0
2008-05-14 12:00:00	AAPL	Stock	6.7907	6.8161	6.7879	6.8	50640044.0
2008-05-14 13:00:00	AAPL	Stock	6.8004	6.83	6.8	6.8054	71026564.0
2008-05-14 14:00:00	AAPL	Stock	6.805	6.8168	6.725	6.7271	120366512.0
2008-05-14 15:00:00	AAPL	Stock	6.7279	6.7296	6.6275	6.6479	272510140.0
2008-05-14 16:00:00	AAPL	Stock	6.6482	6.7843	6.6429	6.6557	12798576.0
2008-05-14 17:00:00	AAPL	Stock	6.6554	6.6639	6.6482	6.6582	691460.0
2008-05-14 18:00:00	AAPL	Stock	6.6614	6.6643	6.6575	6.6643	390796.0
2008-05-14 19:00:00	AAPL	Stock	6.6643	6.6643	6.6593	6.6625	358876.0
2008-05-14 08:00:00	MSFT	Stock	29.6	29.78	29.6	29.77	4128.0
2008-05-14 09:00:00	MSFT	Stock	29.85	30.18	29.73	30.1	7262426.0
2008-05-14 10:00:00	MSFT	Stock	30.1	30.18	30.0	30.06	12909895.0
2008-05-14 11:00:00	MSFT	Stock	30.058	30.14	30.0	30.08	5772625.0
2008-05-14 12:00:00	MSFT	Stock	30.08	30.09	29.97	30.01	4938970.0
2008-05-14 13:00:00	MSFT	Stock	30.01	30.19	29.98	30.15	8468937.0
2008-05-14 14:00:00	MSFT	Stock	30.152	30.26	30.11	30.18	7474583.0
2008-05-14 15:00:00	MSFT	Stock	30.18	30.19	29.86	29.89	15696504.0
2008-05-14 16:00:00	MSFT	Stock	29.93	30.155	29.78	29.88	1630299.0
2008-05-14 17:00:00	MSFT	Stock	29.92	29.93	29.83	29.85	41699.0
2008-05-14 18:00:00	MSFT	Stock	29.84	29.88	29.84	29.88	6490.0
2008-05-14 19:00:00	MSFT	Stock	29.84	29.88	29.83	29.88	1500.0
2008-05-14 08:00:00	NVDA	Stock	0.536	0.5412	0.536	0.5412	243800.0
2008-05-14 09:00:00	NVDA	Stock	0.5412	0.56	0.5412	0.5575	116912200.0
2008-05-14 10:00:00	NVDA	Stock	0.5575	0.566	0.557	0.561	158563760.0
2008-05-14 11:00:00	NVDA	Stock	0.561	0.561	0.554	0.5598	83643520.0
2008-05-14 12:00:00	NVDA	Stock	0.56	0.564	0.5598	0.5622	61822400.0
2008-05-14 13:00:00	NVDA	Stock	0.562	0.565	0.5598	0.564	56205920.0
2008-05-14 14:00:00	NVDA	Stock	0.564	0.565	0.5592	0.5608	63095920.0
2008-05-14 15:00:00	NVDA	Stock	0.561	0.561	0.55	0.5515	157808760.0
2008-05-14 16:00:00	NVDA	Stock	0.551	0.5585	0.5482	0.5522	21739960.0
2008-05-14 17:00:00	NVDA	Stock	0.5518	0.5528	0.55	0.5528	12082880.0
2008-05-14 18:00:00	NVDA	Stock	0.5525	0.5525	0.552	0.552	64920.0
2008-05-14 19:00:00	NVDA	Stock	0.552	0.555	0.5512	0.555	28000.0
2008-05-14 08:00:00	AMZN	Stock	3.728	3.728	3.728	3.728	50000.0
2008-05-14 09:00:00	AMZN	Stock	3.7125	3.7685	3.7065	3.7465	9950040.0
2008-05-14 10:00:00	AMZN	Stock	3.7475	3.785	3.741	3.775	16327180.0
2008-05-14 11:00:00	AMZN	Stock	3.775	3.7875	3.756	3.7565	12038320.0
2008-05-14 12:00:00	AMZN	Stock	3.756	3.7605	3.7405	3.7492	7388920.0
2008-05-14 13:00:00	AMZN	Stock	3.75	3.7755	3.7465	3.7727	6421120.0
2008-05-14 14:00:00	AMZN	Stock	3.7725	3.785	3.7555	3.76	11003260.0
2008-05-14 15:00:00	AMZN	Stock	3.759	3.7605	3.699	3.708	23432440.0
2008-05-14 16:00:00	AMZN	Stock	3.7085	3.75	3.6775	3.71	4200900.0
2008-05-14 19:00:00	AMZN	Stock	3.71	3.71	3.71	3.71	10500.0
2008-05-14 08:00:00	TLT	Stock	91.4	91.4	91.4	91.4	300.0
2008-05-14 09:00:00	TLT	Stock	91.54	92.01	91.52	91.67	213780.0

> showing 50 of 40,845 rows — these rows as CSV

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