PREVIEW / stock_1hour / 2006-10-26

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-10-26.parquet
  size:    628 KB
  rows:    30,030
  symbols: 2,414

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
2006-10-26 08:00:00	AAPL	Stock	2.925	2.9339	2.9232	2.9286	1384208.0
2006-10-26 09:00:00	AAPL	Stock	2.93	2.9304	2.9071	2.9132	53157272.0
2006-10-26 10:00:00	AAPL	Stock	2.9132	2.9168	2.8975	2.9079	66205104.0
2006-10-26 11:00:00	AAPL	Stock	2.9082	2.9282	2.9018	2.9265	50674008.0
2006-10-26 12:00:00	AAPL	Stock	2.9271	2.9336	2.9225	2.9271	59315928.0
2006-10-26 13:00:00	AAPL	Stock	2.9279	2.9461	2.9239	2.9386	59281012.0
2006-10-26 14:00:00	AAPL	Stock	2.9389	2.95	2.9386	2.9454	66397800.0
2006-10-26 15:00:00	AAPL	Stock	2.9457	2.9464	2.931	2.9339	69586356.0
2006-10-26 16:00:00	AAPL	Stock	2.9336	2.9375	2.9321	2.9332	804832.0
2006-10-26 17:00:00	AAPL	Stock	2.9343	2.9354	2.9314	2.9321	217672.0
2006-10-26 18:00:00	AAPL	Stock	2.9321	2.9325	2.9321	2.9321	109200.0
2006-10-26 19:00:00	AAPL	Stock	2.9304	2.9304	2.9304	2.9304	16800.0
2006-10-26 08:00:00	MSFT	Stock	28.35	28.49	28.33	28.42	48220.0
2006-10-26 09:00:00	MSFT	Stock	28.42	28.44	28.08	28.17	6357281.0
2006-10-26 10:00:00	MSFT	Stock	28.17	28.29	28.04	28.1	10941965.0
2006-10-26 11:00:00	MSFT	Stock	28.11	28.23	28.064	28.21	6507470.0
2006-10-26 12:00:00	MSFT	Stock	28.21	28.32	28.11	28.193	5511772.0
2006-10-26 13:00:00	MSFT	Stock	28.2	28.27	28.15	28.23	4603549.0
2006-10-26 14:00:00	MSFT	Stock	28.23	28.31	28.178	28.25	6870825.0
2006-10-26 15:00:00	MSFT	Stock	28.26	28.39	28.18	28.34	20986817.0
2006-10-26 16:00:00	MSFT	Stock	28.32	28.6	27.68	28.23	5333387.0
2006-10-26 17:00:00	MSFT	Stock	28.23	28.75	28.2	28.56	1413525.0
2006-10-26 18:00:00	MSFT	Stock	28.56	28.56	28.41	28.45	141548.0
2006-10-26 19:00:00	MSFT	Stock	28.43	28.44	28.36	28.37	29065.0
2006-10-26 08:00:00	NVDA	Stock	0.5492	0.55	0.5492	0.55	102000.0
2006-10-26 09:00:00	NVDA	Stock	0.549	0.5547	0.5475	0.552	30450420.0
2006-10-26 10:00:00	NVDA	Stock	0.5523	0.555	0.5488	0.553	59553480.0
2006-10-26 11:00:00	NVDA	Stock	0.5528	0.558	0.5522	0.5562	45641640.0
2006-10-26 12:00:00	NVDA	Stock	0.5563	0.5598	0.5538	0.559	44841600.0
2006-10-26 13:00:00	NVDA	Stock	0.559	0.5638	0.5568	0.563	38547480.0
2006-10-26 14:00:00	NVDA	Stock	0.563	0.5653	0.5622	0.5647	66127440.0
2006-10-26 15:00:00	NVDA	Stock	0.5647	0.5658	0.5625	0.5642	72623340.0
2006-10-26 16:00:00	NVDA	Stock	0.5642	0.565	0.5625	0.5642	1497300.0
2006-10-26 17:00:00	NVDA	Stock	0.5625	0.5653	0.5625	0.5653	47520.0
2006-10-26 18:00:00	NVDA	Stock	0.5655	0.5658	0.5655	0.5658	215400.0
2006-10-26 07:00:00	AMZN	Stock	1.875	1.875	1.8615	1.8705	50000.0
2006-10-26 08:00:00	AMZN	Stock	1.8705	1.875	1.855	1.8625	2144220.0
2006-10-26 09:00:00	AMZN	Stock	1.865	1.9205	1.859	1.8985	61450120.0
2006-10-26 10:00:00	AMZN	Stock	1.8985	1.905	1.8775	1.8895	57885040.0
2006-10-26 11:00:00	AMZN	Stock	1.8895	1.9095	1.8875	1.9045	36836060.0
2006-10-26 12:00:00	AMZN	Stock	1.9045	1.917	1.9	1.911	25899600.0
2006-10-26 13:00:00	AMZN	Stock	1.911	1.9245	1.9075	1.9125	38403620.0
2006-10-26 14:00:00	AMZN	Stock	1.9125	1.9145	1.8875	1.902	50829460.0
2006-10-26 15:00:00	AMZN	Stock	1.902	1.918	1.8985	1.917	57711420.0
2006-10-26 16:00:00	AMZN	Stock	1.917	1.9196	1.913	1.9175	2236820.0
2006-10-26 17:00:00	AMZN	Stock	1.9155	1.92	1.9135	1.92	325240.0
2006-10-26 18:00:00	AMZN	Stock	1.916	1.9225	1.915	1.9225	205000.0
2006-10-26 19:00:00	AMZN	Stock	1.9155	1.92	1.9155	1.92	33740.0
2006-10-26 09:00:00	CL	Stock	31.16	31.445	31.155	31.155	582400.0
2006-10-26 10:00:00	CL	Stock	31.155	31.165	31.005	31.155	664800.0

> showing 50 of 30,030 rows — these rows as CSV

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