PREVIEW / stock_1hour / 2007-09-28

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-09-28.parquet
  size:    791 KB
  rows:    39,337
  symbols: 3,128

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
2007-09-28 05:00:00	AAPL	Stock	5.4911	5.4911	5.4911	5.4911	2800.0
2007-09-28 06:00:00	AAPL	Stock	5.5107	5.5107	5.4893	5.4893	53200.0
2007-09-28 07:00:00	AAPL	Stock	5.4893	5.495	5.4821	5.495	299964.0
2007-09-28 08:00:00	AAPL	Stock	5.4929	5.4943	5.4714	5.4793	5348364.0
2007-09-28 09:00:00	AAPL	Stock	5.4771	5.5125	5.4554	5.4896	106467480.0
2007-09-28 10:00:00	AAPL	Stock	5.4896	5.5021	5.4693	5.4876	104925604.0
2007-09-28 11:00:00	AAPL	Stock	5.4882	5.5018	5.4789	5.4889	66757712.0
2007-09-28 12:00:00	AAPL	Stock	5.4893	5.4971	5.4839	5.4939	40299000.0
2007-09-28 13:00:00	AAPL	Stock	5.4939	5.5118	5.4643	5.5117	60020548.0
2007-09-28 14:00:00	AAPL	Stock	5.5111	5.5214	5.4768	5.4839	83524924.0
2007-09-28 15:00:00	AAPL	Stock	5.4832	5.4918	5.4571	5.4821	126135352.0
2007-09-28 16:00:00	AAPL	Stock	5.4821	5.492	5.4715	5.4818	20248564.0
2007-09-28 17:00:00	AAPL	Stock	5.4821	5.4989	5.4804	5.4818	430500.0
2007-09-28 18:00:00	AAPL	Stock	5.4804	5.5214	5.4804	5.4893	1077216.0
2007-09-28 19:00:00	AAPL	Stock	5.4868	5.4868	5.4732	5.4768	340088.0
2007-09-28 08:00:00	MSFT	Stock	29.45	29.45	29.36	29.41	10760.0
2007-09-28 09:00:00	MSFT	Stock	29.46	29.69	29.41	29.56	4754462.0
2007-09-28 10:00:00	MSFT	Stock	29.56	29.59	29.35	29.36	6485107.0
2007-09-28 11:00:00	MSFT	Stock	29.35	29.38	29.23	29.32	4381983.0
2007-09-28 12:00:00	MSFT	Stock	29.32	29.37	29.29	29.318	4006816.0
2007-09-28 13:00:00	MSFT	Stock	29.318	29.39	29.3	29.33	3234328.0
2007-09-28 14:00:00	MSFT	Stock	29.33	29.35	29.27	29.3	4125512.0
2007-09-28 15:00:00	MSFT	Stock	29.3	29.47	29.23	29.47	12543336.0
2007-09-28 16:00:00	MSFT	Stock	29.46	29.49	29.32	29.383	6270136.0
2007-09-28 17:00:00	MSFT	Stock	29.48	29.48	29.34	29.48	20666.0
2007-09-28 18:00:00	MSFT	Stock	29.48	29.48	29.33	29.34	7900.0
2007-09-28 19:00:00	MSFT	Stock	29.48	29.5	29.48	29.5	14006.0
2007-09-28 08:00:00	NVDA	Stock	0.92	0.9242	0.9188	0.9242	100000.0
2007-09-28 09:00:00	NVDA	Stock	0.9228	0.9275	0.9188	0.927	41864240.0
2007-09-28 10:00:00	NVDA	Stock	0.927	0.9283	0.9213	0.9225	73150880.0
2007-09-28 11:00:00	NVDA	Stock	0.9228	0.924	0.9145	0.9165	40289200.0
2007-09-28 12:00:00	NVDA	Stock	0.9162	0.9203	0.9152	0.9176	26423760.0
2007-09-28 13:00:00	NVDA	Stock	0.9176	0.9188	0.9135	0.9135	37875760.0
2007-09-28 14:00:00	NVDA	Stock	0.9135	0.9148	0.9078	0.9118	82769200.0
2007-09-28 15:00:00	NVDA	Stock	0.9117	0.9118	0.904	0.9068	74787840.0
2007-09-28 16:00:00	NVDA	Stock	0.9068	0.9161	0.9058	0.9062	3648320.0
2007-09-28 17:00:00	NVDA	Stock	0.906	0.9062	0.906	0.9062	31160.0
2007-09-28 18:00:00	NVDA	Stock	0.9062	0.9062	0.9025	0.9025	28000.0
2007-09-28 19:00:00	NVDA	Stock	0.905	0.905	0.905	0.905	12000.0
2007-09-28 08:00:00	AMZN	Stock	4.6375	4.669	4.628	4.656	680200.0
2007-09-28 09:00:00	AMZN	Stock	4.651	4.68	4.6375	4.664	10775540.0
2007-09-28 10:00:00	AMZN	Stock	4.664	4.669	4.585	4.6135	22333720.0
2007-09-28 11:00:00	AMZN	Stock	4.613	4.645	4.6035	4.637	10972200.0
2007-09-28 12:00:00	AMZN	Stock	4.636	4.6495	4.626	4.6428	6127880.0
2007-09-28 13:00:00	AMZN	Stock	4.642	4.659	4.6345	4.659	6657340.0
2007-09-28 14:00:00	AMZN	Stock	4.659	4.6675	4.6455	4.6525	11985300.0
2007-09-28 15:00:00	AMZN	Stock	4.653	4.664	4.6325	4.658	18364460.0
2007-09-28 16:00:00	AMZN	Stock	4.6575	4.6675	4.641	4.6645	8303820.0
2007-09-28 17:00:00	AMZN	Stock	4.6675	4.67	4.6355	4.6655	57800.0
2007-09-28 18:00:00	AMZN	Stock	4.6655	4.6655	4.658	4.658	9000.0

> showing 50 of 39,337 rows — these rows as CSV

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