PREVIEW / stock_1hour / 2009-10-29

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-10-29.parquet
  size:    921 KB
  rows:    44,167
  symbols: 3,402

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
2009-10-29 04:00:00	AAPL	Stock	6.8214	6.8214	6.7986	6.7986	16800.0
2009-10-29 05:00:00	AAPL	Stock	6.8214	6.8232	6.8093	6.8232	61684.0
2009-10-29 06:00:00	AAPL	Stock	6.835	6.8393	6.8214	6.8382	52892.0
2009-10-29 07:00:00	AAPL	Stock	6.8304	6.8571	6.8304	6.8561	229348.0
2009-10-29 08:00:00	AAPL	Stock	6.8393	6.9936	6.8393	6.9911	11902212.0
2009-10-29 09:00:00	AAPL	Stock	6.99	6.9954	6.8621	6.9393	114603412.0
2009-10-29 10:00:00	AAPL	Stock	6.9421	6.9982	6.9346	6.9857	122096044.0
2009-10-29 11:00:00	AAPL	Stock	6.9857	6.9925	6.9621	6.9721	52019520.0
2009-10-29 12:00:00	AAPL	Stock	6.9721	6.9893	6.9696	6.9818	41302996.0
2009-10-29 13:00:00	AAPL	Stock	6.9818	6.9839	6.9486	6.974	44918776.0
2009-10-29 14:00:00	AAPL	Stock	6.9739	7.0071	6.9611	7.0071	52687656.0
2009-10-29 15:00:00	AAPL	Stock	7.0068	7.0289	6.9961	7.0139	105507864.0
2009-10-29 16:00:00	AAPL	Stock	7.0136	7.0246	6.9936	7.0189	7972804.0
2009-10-29 17:00:00	AAPL	Stock	7.0146	7.025	7.0146	7.0179	166320.0
2009-10-29 18:00:00	AAPL	Stock	7.02	7.0339	7.0125	7.0321	1076320.0
2009-10-29 19:00:00	AAPL	Stock	7.0321	7.0396	7.0321	7.0357	362684.0
2009-10-29 06:00:00	MSFT	Stock	28.05	28.05	28.05	28.05	400.0
2009-10-29 08:00:00	MSFT	Stock	28.14	28.3	28.05	28.3	87133.0
2009-10-29 09:00:00	MSFT	Stock	28.34	28.35	27.85	27.99	7875041.0
2009-10-29 10:00:00	MSFT	Stock	28.0	28.14	27.96	28.08	8600797.0
2009-10-29 11:00:00	MSFT	Stock	28.06	28.11	27.93	27.98	8181820.0
2009-10-29 12:00:00	MSFT	Stock	27.98	28.222	27.93	28.15	9141110.0
2009-10-29 13:00:00	MSFT	Stock	28.16	28.41	28.14	28.41	6001746.0
2009-10-29 14:00:00	MSFT	Stock	28.4	28.41	28.3	28.4	6195468.0
2009-10-29 15:00:00	MSFT	Stock	28.39	28.4	28.12	28.22	13539080.0
2009-10-29 16:00:00	MSFT	Stock	28.22	28.284	28.058	28.22	2422042.0
2009-10-29 17:00:00	MSFT	Stock	28.16	28.22	28.15	28.19	5650.0
2009-10-29 18:00:00	MSFT	Stock	28.2	28.35	28.19	28.22	28726.0
2009-10-29 19:00:00	MSFT	Stock	28.22	28.25	28.2	28.25	748.0
2009-10-29 08:00:00	NVDA	Stock	0.3	0.3035	0.3	0.3035	78000.0
2009-10-29 09:00:00	NVDA	Stock	0.3035	0.307	0.3025	0.3038	78840720.0
2009-10-29 10:00:00	NVDA	Stock	0.304	0.311	0.304	0.3103	121168120.0
2009-10-29 11:00:00	NVDA	Stock	0.3103	0.3113	0.3088	0.3101	87815080.0
2009-10-29 12:00:00	NVDA	Stock	0.31	0.3128	0.3095	0.3103	60860400.0
2009-10-29 13:00:00	NVDA	Stock	0.3104	0.3118	0.3098	0.3105	38997640.0
2009-10-29 14:00:00	NVDA	Stock	0.3105	0.314	0.3093	0.314	71684240.0
2009-10-29 15:00:00	NVDA	Stock	0.3138	0.3153	0.312	0.3135	162583440.0
2009-10-29 16:00:00	NVDA	Stock	0.3135	0.3138	0.3075	0.3133	1826600.0
2009-10-29 17:00:00	NVDA	Stock	0.3138	0.3138	0.3113	0.3113	87560.0
2009-10-29 18:00:00	NVDA	Stock	0.3113	0.3113	0.3113	0.3113	4000.0
2009-10-29 19:00:00	NVDA	Stock	0.3125	0.3125	0.3125	0.3125	20000.0
2009-10-29 05:00:00	AMZN	Stock	6.0845	6.0845	6.0845	6.0845	2000.0
2009-10-29 08:00:00	AMZN	Stock	6.0885	6.2045	6.084	6.195	2341320.0
2009-10-29 09:00:00	AMZN	Stock	6.195	6.215	6.1135	6.1495	41399920.0
2009-10-29 10:00:00	AMZN	Stock	6.1495	6.1785	6.054	6.099	58804100.0
2009-10-29 11:00:00	AMZN	Stock	6.1	6.109	6.0675	6.082	25743840.0
2009-10-29 12:00:00	AMZN	Stock	6.082	6.1035	6.0635	6.0685	18773620.0
2009-10-29 13:00:00	AMZN	Stock	6.069	6.0775	6.0135	6.0275	32022680.0
2009-10-29 14:00:00	AMZN	Stock	6.0285	6.0875	6.006	6.0735	30905600.0
2009-10-29 15:00:00	AMZN	Stock	6.0725	6.1345	6.065	6.13	41138160.0

> showing 50 of 44,167 rows — these rows as CSV

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