PREVIEW / stock_1hour / 2006-10-16

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-10-16.parquet
  size:    617 KB
  rows:    29,570
  symbols: 2,388

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-16 04:00:00	AAPL	Stock	2.6896	2.6904	2.6896	2.6904	14000.0
2006-10-16 07:00:00	AAPL	Stock	2.6904	2.6929	2.6854	2.6854	28000.0
2006-10-16 08:00:00	AAPL	Stock	2.6857	2.6893	2.6825	2.6832	1869000.0
2006-10-16 09:00:00	AAPL	Stock	2.6825	2.6982	2.6807	2.685	77103068.0
2006-10-16 10:00:00	AAPL	Stock	2.6854	2.6879	2.6714	2.6757	101346784.0
2006-10-16 11:00:00	AAPL	Stock	2.6757	2.6911	2.671	2.6886	58559872.0
2006-10-16 12:00:00	AAPL	Stock	2.6886	2.6946	2.6871	2.6921	35796124.0
2006-10-16 13:00:00	AAPL	Stock	2.6925	2.7071	2.6846	2.7036	57697416.0
2006-10-16 14:00:00	AAPL	Stock	2.7054	2.71	2.6946	2.7029	56685272.0
2006-10-16 15:00:00	AAPL	Stock	2.7032	2.7071	2.6921	2.695	70467348.0
2006-10-16 16:00:00	AAPL	Stock	2.6939	2.695	2.6921	2.6936	2364740.0
2006-10-16 17:00:00	AAPL	Stock	2.6929	2.6936	2.6921	2.6936	40726252.0
2006-10-16 18:00:00	AAPL	Stock	2.6936	2.6936	2.6911	2.6936	265636.0
2006-10-16 19:00:00	AAPL	Stock	2.695	2.695	2.6936	2.6936	10500.0
2006-10-16 07:00:00	MSFT	Stock	28.5	28.57	28.5	28.57	4300.0
2006-10-16 08:00:00	MSFT	Stock	28.38	28.58	28.37	28.47	65975.0
2006-10-16 09:00:00	MSFT	Stock	28.5	28.5	28.38	28.42	5935827.0
2006-10-16 10:00:00	MSFT	Stock	28.42	28.6	28.4	28.56	8152050.0
2006-10-16 11:00:00	MSFT	Stock	28.57	28.59	28.45	28.46	6406091.0
2006-10-16 12:00:00	MSFT	Stock	28.47	28.55	28.33	28.34	6080539.0
2006-10-16 13:00:00	MSFT	Stock	28.34	28.47	28.33	28.45	4832025.0
2006-10-16 14:00:00	MSFT	Stock	28.46	28.5	28.4	28.44	4389727.0
2006-10-16 15:00:00	MSFT	Stock	28.442	28.53	28.42	28.46	11070315.0
2006-10-16 16:00:00	MSFT	Stock	28.46	28.5	28.418	28.44	615809.0
2006-10-16 17:00:00	MSFT	Stock	28.44	28.48	28.44	28.48	12450.0
2006-10-16 18:00:00	MSFT	Stock	28.45	28.48	28.45	28.48	200.0
2006-10-16 08:00:00	NVDA	Stock	0.5625	0.5678	0.5625	0.5667	801120.0
2006-10-16 09:00:00	NVDA	Stock	0.566	0.5702	0.5518	0.5702	81621780.0
2006-10-16 10:00:00	NVDA	Stock	0.57	0.5738	0.5638	0.5653	105605400.0
2006-10-16 11:00:00	NVDA	Stock	0.5653	0.5697	0.5648	0.567	43483860.0
2006-10-16 12:00:00	NVDA	Stock	0.567	0.5675	0.5633	0.5653	29407380.0
2006-10-16 13:00:00	NVDA	Stock	0.5652	0.57	0.5652	0.5683	33575580.0
2006-10-16 14:00:00	NVDA	Stock	0.5683	0.5683	0.5633	0.5638	55908240.0
2006-10-16 15:00:00	NVDA	Stock	0.5638	0.565	0.5617	0.562	85828020.0
2006-10-16 16:00:00	NVDA	Stock	0.5622	0.5625	0.5595	0.561	613740.0
2006-10-16 17:00:00	NVDA	Stock	0.5622	0.5622	0.5608	0.5617	21025140.0
2006-10-16 18:00:00	NVDA	Stock	0.5618	0.5618	0.5618	0.5618	6000.0
2006-10-16 19:00:00	NVDA	Stock	0.5617	0.5617	0.5617	0.5617	60000.0
2006-10-16 05:00:00	AMZN	Stock	1.6625	1.6625	1.6455	1.6455	4000.0
2006-10-16 06:00:00	AMZN	Stock	1.6	1.6	1.6	1.6	20000.0
2006-10-16 07:00:00	AMZN	Stock	1.645	1.645	1.645	1.645	172000.0
2006-10-16 08:00:00	AMZN	Stock	1.6505	1.6505	1.6405	1.6405	288000.0
2006-10-16 09:00:00	AMZN	Stock	1.64	1.66	1.6375	1.6505	20019840.0
2006-10-16 10:00:00	AMZN	Stock	1.651	1.6535	1.639	1.6405	19290280.0
2006-10-16 11:00:00	AMZN	Stock	1.6405	1.6545	1.6325	1.6345	17121700.0
2006-10-16 12:00:00	AMZN	Stock	1.635	1.6405	1.6335	1.6395	10314660.0
2006-10-16 13:00:00	AMZN	Stock	1.6395	1.6395	1.6345	1.637	11129840.0
2006-10-16 14:00:00	AMZN	Stock	1.637	1.6385	1.6345	1.6345	13495420.0
2006-10-16 15:00:00	AMZN	Stock	1.6345	1.6355	1.6275	1.6298	29135160.0
2006-10-16 16:00:00	AMZN	Stock	1.6315	1.638	1.629	1.63	2162280.0

> showing 50 of 29,570 rows — these rows as CSV

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