PREVIEW / stock_1hour / 2008-02-15

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-02-15.parquet
  size:    814 KB
  rows:    41,369
  symbols: 3,254

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
2008-02-15 07:00:00	AAPL	Stock	4.5386	4.5482	4.52	4.52	168280.0
2008-02-15 08:00:00	AAPL	Stock	4.5336	4.5336	4.4907	4.4971	3189200.0
2008-02-15 09:00:00	AAPL	Stock	4.4964	4.5386	4.4929	4.5168	159852840.0
2008-02-15 10:00:00	AAPL	Stock	4.5164	4.5325	4.4821	4.4918	142078020.0
2008-02-15 11:00:00	AAPL	Stock	4.4895	4.4943	4.4343	4.4586	131004300.0
2008-02-15 12:00:00	AAPL	Stock	4.4589	4.4736	4.4336	4.4479	102130336.0
2008-02-15 13:00:00	AAPL	Stock	4.4479	4.4589	4.4307	4.4482	79545480.0
2008-02-15 14:00:00	AAPL	Stock	4.4482	4.4514	4.4325	4.4425	78306032.0
2008-02-15 15:00:00	AAPL	Stock	4.4429	4.4664	4.4379	4.4511	182527660.0
2008-02-15 16:00:00	AAPL	Stock	4.4511	4.4729	4.445	4.4457	16475592.0
2008-02-15 17:00:00	AAPL	Stock	4.4454	4.4511	4.4429	4.4446	7697816.0
2008-02-15 18:00:00	AAPL	Stock	4.4464	4.4464	4.4375	4.4429	402780.0
2008-02-15 19:00:00	AAPL	Stock	4.4429	4.4439	4.4382	4.4429	204344.0
2008-02-15 08:00:00	MSFT	Stock	28.46	28.46	28.32	28.43	21967.0
2008-02-15 09:00:00	MSFT	Stock	28.4	28.5	28.25	28.46	13752046.0
2008-02-15 10:00:00	MSFT	Stock	28.45	28.64	28.44	28.49	8871019.0
2008-02-15 11:00:00	MSFT	Stock	28.49	28.55	28.32	28.39	8947040.0
2008-02-15 12:00:00	MSFT	Stock	28.39	28.46	28.31	28.39	7504652.0
2008-02-15 13:00:00	MSFT	Stock	28.381	28.55	28.34	28.38	4945085.0
2008-02-15 14:00:00	MSFT	Stock	28.37	28.38	28.31	28.35	8134833.0
2008-02-15 15:00:00	MSFT	Stock	28.34	28.44	28.31	28.42	10443534.0
2008-02-15 16:00:00	MSFT	Stock	28.41	28.45	28.355	28.43	3631549.0
2008-02-15 17:00:00	MSFT	Stock	28.42	28.45	28.42	28.42	2678364.0
2008-02-15 18:00:00	MSFT	Stock	28.43	28.46	28.42	28.42	2835.0
2008-02-15 19:00:00	MSFT	Stock	28.41	28.48	28.4	28.48	19430.0
2008-02-15 04:00:00	NVDA	Stock	0.5508	0.5508	0.5508	0.5508	8000.0
2008-02-15 05:00:00	NVDA	Stock	0.5735	0.5735	0.5735	0.5735	12000.0
2008-02-15 06:00:00	NVDA	Stock	0.5735	0.5735	0.5735	0.5735	4000.0
2008-02-15 07:00:00	NVDA	Stock	0.5735	0.5735	0.5732	0.5732	28000.0
2008-02-15 08:00:00	NVDA	Stock	0.5722	0.5725	0.5588	0.565	1028440.0
2008-02-15 09:00:00	NVDA	Stock	0.5638	0.5782	0.5612	0.566	147593080.0
2008-02-15 10:00:00	NVDA	Stock	0.5662	0.572	0.5555	0.5555	136048640.0
2008-02-15 11:00:00	NVDA	Stock	0.5555	0.5585	0.5488	0.5522	107216480.0
2008-02-15 12:00:00	NVDA	Stock	0.5522	0.5558	0.5478	0.55	81763520.0
2008-02-15 13:00:00	NVDA	Stock	0.55	0.5535	0.5488	0.553	59841400.0
2008-02-15 14:00:00	NVDA	Stock	0.5532	0.5542	0.55	0.5522	63131160.0
2008-02-15 15:00:00	NVDA	Stock	0.5525	0.5612	0.5522	0.557	196950240.0
2008-02-15 16:00:00	NVDA	Stock	0.5572	0.559	0.5539	0.5584	18049600.0
2008-02-15 17:00:00	NVDA	Stock	0.5568	0.5712	0.5568	0.557	8299800.0
2008-02-15 18:00:00	NVDA	Stock	0.557	0.558	0.5568	0.5578	252000.0
2008-02-15 19:00:00	NVDA	Stock	0.558	0.558	0.5562	0.5578	155200.0
2008-02-15 07:00:00	AMZN	Stock	3.7815	3.7815	3.765	3.765	20000.0
2008-02-15 08:00:00	AMZN	Stock	3.755	3.774	3.744	3.75	70000.0
2008-02-15 09:00:00	AMZN	Stock	3.75	3.77	3.6868	3.6875	36281160.0
2008-02-15 10:00:00	AMZN	Stock	3.6875	3.733	3.671	3.675	36327520.0
2008-02-15 11:00:00	AMZN	Stock	3.6755	3.676	3.63	3.638	29128040.0
2008-02-15 12:00:00	AMZN	Stock	3.638	3.675	3.626	3.641	29116000.0
2008-02-15 13:00:00	AMZN	Stock	3.6415	3.651	3.6125	3.6315	20137220.0
2008-02-15 14:00:00	AMZN	Stock	3.6305	3.634	3.597	3.6005	20126960.0
2008-02-15 15:00:00	AMZN	Stock	3.601	3.65	3.598	3.6475	46189380.0

> showing 50 of 41,369 rows — these rows as CSV

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