PREVIEW / stock_1hour / 2006-11-16

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-11-16.parquet
  size:    636 KB
  rows:    30,300
  symbols: 2,444

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-11-16 04:00:00	AAPL	Stock	3.0214	3.0214	3.0214	3.0214	2800.0
2006-11-16 07:00:00	AAPL	Stock	3.0189	3.035	3.0179	3.0214	251832.0
2006-11-16 08:00:00	AAPL	Stock	3.0214	3.0336	3.0179	3.0286	5316500.0
2006-11-16 09:00:00	AAPL	Stock	3.0286	3.0429	3.0221	3.0414	98076776.0
2006-11-16 10:00:00	AAPL	Stock	3.0411	3.06	3.0325	3.0471	123235672.0
2006-11-16 11:00:00	AAPL	Stock	3.0471	3.0579	3.0429	3.0518	52784088.0
2006-11-16 12:00:00	AAPL	Stock	3.0521	3.0704	3.0489	3.0646	82061868.0
2006-11-16 13:00:00	AAPL	Stock	3.0646	3.0821	3.0607	3.0768	102586372.0
2006-11-16 14:00:00	AAPL	Stock	3.0771	3.0804	3.0571	3.0646	74579512.0
2006-11-16 15:00:00	AAPL	Stock	3.0646	3.08	3.0568	3.0593	122826032.0
2006-11-16 16:00:00	AAPL	Stock	3.0593	3.075	3.0571	3.0607	12086368.0
2006-11-16 17:00:00	AAPL	Stock	3.0607	3.0618	3.0543	3.0575	543480.0
2006-11-16 18:00:00	AAPL	Stock	3.0586	3.0589	3.0554	3.0554	201936.0
2006-11-16 19:00:00	AAPL	Stock	3.0554	3.0604	3.0543	3.0604	120176.0
2006-11-16 08:00:00	MSFT	Stock	29.03	29.12	29.03	29.12	29687.0
2006-11-16 09:00:00	MSFT	Stock	29.12	29.28	29.1	29.27	5531355.0
2006-11-16 10:00:00	MSFT	Stock	29.27	29.41	29.27	29.4	9510640.0
2006-11-16 11:00:00	MSFT	Stock	29.4	29.47	29.37	29.45	5532170.0
2006-11-16 12:00:00	MSFT	Stock	29.458	29.48	29.19	29.48	6673440.0
2006-11-16 13:00:00	MSFT	Stock	29.47	29.64	29.42	29.49	9783977.0
2006-11-16 14:00:00	MSFT	Stock	29.49	29.61	29.45	29.54	7366651.0
2006-11-16 15:00:00	MSFT	Stock	29.54	29.61	29.43	29.44	14791513.0
2006-11-16 16:00:00	MSFT	Stock	29.45	29.48	29.41	29.45	133016.0
2006-11-16 17:00:00	MSFT	Stock	29.48	29.48	29.45	29.45	8700.0
2006-11-16 18:00:00	MSFT	Stock	29.45	29.45	29.45	29.45	400.0
2006-11-16 19:00:00	MSFT	Stock	29.45	29.45	29.45	29.45	100.0
2006-11-16 07:00:00	NVDA	Stock	0.5983	0.5983	0.5983	0.5983	6000.0
2006-11-16 08:00:00	NVDA	Stock	0.5967	0.5985	0.595	0.5975	693420.0
2006-11-16 09:00:00	NVDA	Stock	0.5975	0.6038	0.5933	0.5993	58783380.0
2006-11-16 10:00:00	NVDA	Stock	0.5993	0.6025	0.5957	0.6	76680060.0
2006-11-16 11:00:00	NVDA	Stock	0.6002	0.6033	0.5978	0.6022	46656960.0
2006-11-16 12:00:00	NVDA	Stock	0.602	0.6032	0.5987	0.6012	45294360.0
2006-11-16 13:00:00	NVDA	Stock	0.601	0.6053	0.6003	0.6032	52207440.0
2006-11-16 14:00:00	NVDA	Stock	0.6033	0.6043	0.6007	0.6032	51396360.0
2006-11-16 15:00:00	NVDA	Stock	0.6032	0.6058	0.6025	0.6035	94039380.0
2006-11-16 16:00:00	NVDA	Stock	0.6035	0.6038	0.6028	0.6028	313080.0
2006-11-16 17:00:00	NVDA	Stock	0.6028	0.6047	0.6028	0.6037	8349540.0
2006-11-16 18:00:00	NVDA	Stock	0.604	0.604	0.6023	0.6033	120060.0
2006-11-16 19:00:00	NVDA	Stock	0.6025	0.6025	0.6025	0.6025	72000.0
2006-11-16 08:00:00	AMZN	Stock	2.125	2.14	2.115	2.118	601300.0
2006-11-16 09:00:00	AMZN	Stock	2.123	2.14	2.121	2.1245	26525460.0
2006-11-16 10:00:00	AMZN	Stock	2.1245	2.1475	2.12	2.1265	49735960.0
2006-11-16 11:00:00	AMZN	Stock	2.1255	2.138	2.124	2.1365	17235840.0
2006-11-16 12:00:00	AMZN	Stock	2.1355	2.14	2.129	2.1295	18864120.0
2006-11-16 13:00:00	AMZN	Stock	2.129	2.1355	2.1255	2.1275	20277720.0
2006-11-16 14:00:00	AMZN	Stock	2.128	2.138	2.1205	2.1345	23727940.0
2006-11-16 15:00:00	AMZN	Stock	2.135	2.144	2.1345	2.142	32503260.0
2006-11-16 16:00:00	AMZN	Stock	2.1415	2.1495	2.1415	2.144	50640.0
2006-11-16 17:00:00	AMZN	Stock	2.143	2.143	2.13	2.13	127420.0
2006-11-16 18:00:00	AMZN	Stock	2.144	2.144	2.144	2.144	2000.0

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

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