PREVIEW / stock_1hour / 2006-10-03

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-10-03.parquet
  size:    627 KB
  rows:    29,924
  symbols: 2,393

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-03 08:00:00	AAPL	Stock	2.6643	2.6729	2.6579	2.6614	1067892.0
2006-10-03 09:00:00	AAPL	Stock	2.6625	2.6643	2.6321	2.6479	98184072.0
2006-10-03 10:00:00	AAPL	Stock	2.6475	2.6607	2.6189	2.6239	157502240.0
2006-10-03 11:00:00	AAPL	Stock	2.6239	2.6411	2.6139	2.635	112424424.0
2006-10-03 12:00:00	AAPL	Stock	2.6353	2.6768	2.6332	2.6725	134312696.0
2006-10-03 13:00:00	AAPL	Stock	2.6732	2.675	2.6575	2.6625	83377252.0
2006-10-03 14:00:00	AAPL	Stock	2.6604	2.665	2.6446	2.6568	83602260.0
2006-10-03 15:00:00	AAPL	Stock	2.6568	2.6593	2.6364	2.6443	104864872.0
2006-10-03 16:00:00	AAPL	Stock	2.645	2.6489	2.6429	2.6446	6661144.0
2006-10-03 17:00:00	AAPL	Stock	2.645	2.6464	2.6429	2.6446	143304.0
2006-10-03 18:00:00	AAPL	Stock	2.6446	2.6482	2.6446	2.6464	81116.0
2006-10-03 19:00:00	AAPL	Stock	2.6464	2.6471	2.6464	2.6471	148400.0
2006-10-03 07:00:00	MSFT	Stock	27.28	27.29	27.28	27.29	1000.0
2006-10-03 08:00:00	MSFT	Stock	27.27	27.3	27.25	27.3	6400.0
2006-10-03 09:00:00	MSFT	Stock	27.29	27.43	27.27	27.37	4516185.0
2006-10-03 10:00:00	MSFT	Stock	27.37	27.4	27.22	27.259	7302021.0
2006-10-03 11:00:00	MSFT	Stock	27.25	27.32	27.21	27.283	3342165.0
2006-10-03 12:00:00	MSFT	Stock	27.282	27.47	27.27	27.47	6041796.0
2006-10-03 13:00:00	MSFT	Stock	27.47	27.48	27.42	27.45	4054614.0
2006-10-03 14:00:00	MSFT	Stock	27.44	27.48	27.409	27.453	4531470.0
2006-10-03 15:00:00	MSFT	Stock	27.45	27.47	27.35	27.37	7679155.0
2006-10-03 16:00:00	MSFT	Stock	27.37	27.4	27.37	27.37	91154.0
2006-10-03 17:00:00	MSFT	Stock	27.38	27.38	27.35	27.36	34250.0
2006-10-03 18:00:00	MSFT	Stock	27.38	27.38	27.38	27.38	450.0
2006-10-03 08:00:00	NVDA	Stock	0.4775	0.4775	0.4698	0.4717	1463160.0
2006-10-03 09:00:00	NVDA	Stock	0.4717	0.473	0.4638	0.4675	106760280.0
2006-10-03 10:00:00	NVDA	Stock	0.4675	0.4693	0.4612	0.4632	108312660.0
2006-10-03 11:00:00	NVDA	Stock	0.463	0.4665	0.4612	0.465	107529900.0
2006-10-03 12:00:00	NVDA	Stock	0.4648	0.4743	0.4643	0.4737	150214980.0
2006-10-03 13:00:00	NVDA	Stock	0.4737	0.4753	0.4647	0.4683	136482480.0
2006-10-03 14:00:00	NVDA	Stock	0.4685	0.4717	0.4683	0.4698	81069180.0
2006-10-03 15:00:00	NVDA	Stock	0.47	0.4743	0.4688	0.4714	194093400.0
2006-10-03 16:00:00	NVDA	Stock	0.4717	0.4717	0.4715	0.4715	157020.0
2006-10-03 17:00:00	NVDA	Stock	0.4712	0.4715	0.4712	0.4715	72000.0
2006-10-03 18:00:00	NVDA	Stock	0.4725	0.4733	0.4725	0.4725	66000.0
2006-10-03 19:00:00	NVDA	Stock	0.4712	0.4712	0.47	0.47	210000.0
2006-10-03 08:00:00	AMZN	Stock	1.54	1.54	1.54	1.54	30000.0
2006-10-03 09:00:00	AMZN	Stock	1.541	1.549	1.529	1.539	15315440.0
2006-10-03 10:00:00	AMZN	Stock	1.5395	1.554	1.5325	1.546	23277000.0
2006-10-03 11:00:00	AMZN	Stock	1.5465	1.5785	1.5375	1.5776	24311720.0
2006-10-03 12:00:00	AMZN	Stock	1.5775	1.6	1.5775	1.585	30431880.0
2006-10-03 13:00:00	AMZN	Stock	1.585	1.5885	1.575	1.586	12956420.0
2006-10-03 14:00:00	AMZN	Stock	1.586	1.595	1.55	1.59	19635980.0
2006-10-03 15:00:00	AMZN	Stock	1.59	1.6	1.5815	1.585	27665900.0
2006-10-03 16:00:00	AMZN	Stock	1.5855	1.5865	1.585	1.586	85460.0
2006-10-03 17:00:00	AMZN	Stock	1.5885	1.5885	1.5885	1.5885	8200.0
2006-10-03 09:00:00	CL	Stock	31.1	31.215	31.08	31.095	182400.0
2006-10-03 10:00:00	CL	Stock	31.105	31.11	30.96	31.0	476200.0
2006-10-03 11:00:00	CL	Stock	30.99	31.135	30.965	30.985	418600.0
2006-10-03 12:00:00	CL	Stock	30.985	31.15	30.97	31.145	282400.0

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

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