PREVIEW / stock_1hour / 2010-04-09

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-04-09.parquet
  size:    904 KB
  rows:    42,998
  symbols: 3,475

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
2010-04-09 04:00:00	AAPL	Stock	8.5893	8.6304	8.5893	8.6304	33600.0
2010-04-09 05:00:00	AAPL	Stock	8.6418	8.6646	8.6418	8.6643	22400.0
2010-04-09 06:00:00	AAPL	Stock	8.6357	8.6511	8.6357	8.6511	23184.0
2010-04-09 07:00:00	AAPL	Stock	8.6429	8.6511	8.625	8.625	447020.0
2010-04-09 08:00:00	AAPL	Stock	8.6232	8.625	8.5986	8.6107	2449440.0
2010-04-09 09:00:00	AAPL	Stock	8.6121	8.6243	8.5825	8.6168	71568140.0
2010-04-09 10:00:00	AAPL	Stock	8.6179	8.6304	8.5982	8.6039	74485292.0
2010-04-09 11:00:00	AAPL	Stock	8.6025	8.6232	8.5982	8.6082	33702592.0
2010-04-09 12:00:00	AAPL	Stock	8.6082	8.6179	8.6	8.605	19122152.0
2010-04-09 13:00:00	AAPL	Stock	8.605	8.6118	8.5918	8.5946	25503184.0
2010-04-09 14:00:00	AAPL	Stock	8.5943	8.6179	8.5893	8.6131	25155256.0
2010-04-09 15:00:00	AAPL	Stock	8.6125	8.6386	8.6054	8.6386	73317524.0
2010-04-09 16:00:00	AAPL	Stock	8.6375	8.6468	8.6087	8.6429	7034076.0
2010-04-09 17:00:00	AAPL	Stock	8.6446	8.6482	8.6418	8.6421	185192.0
2010-04-09 18:00:00	AAPL	Stock	8.6429	8.645	8.6354	8.645	60872.0
2010-04-09 19:00:00	AAPL	Stock	8.645	8.6464	8.6429	8.6464	258468.0
2010-04-09 06:00:00	MSFT	Stock	30.06	30.06	30.06	30.06	100.0
2010-04-09 07:00:00	MSFT	Stock	30.0	30.0	29.98	29.98	800.0
2010-04-09 08:00:00	MSFT	Stock	29.99	30.02	29.98	30.01	76985.0
2010-04-09 09:00:00	MSFT	Stock	30.01	30.05	29.895	29.98	5231458.0
2010-04-09 10:00:00	MSFT	Stock	29.97	30.0	29.91	29.95	8826885.0
2010-04-09 11:00:00	MSFT	Stock	29.95	30.1	29.94	30.064	6172127.0
2010-04-09 12:00:00	MSFT	Stock	30.06	30.17	30.02	30.095	6550318.0
2010-04-09 13:00:00	MSFT	Stock	30.1	30.28	30.09	30.26	5770465.0
2010-04-09 14:00:00	MSFT	Stock	30.255	30.3	30.162	30.275	5118198.0
2010-04-09 15:00:00	MSFT	Stock	30.27	30.41	30.23	30.33	12956156.0
2010-04-09 16:00:00	MSFT	Stock	30.33	30.42	29.888	30.36	2635484.0
2010-04-09 17:00:00	MSFT	Stock	30.35	30.36	30.32	30.36	15161.0
2010-04-09 18:00:00	MSFT	Stock	30.34	30.38	30.34	30.38	6210.0
2010-04-09 19:00:00	MSFT	Stock	30.38	30.38	30.34	30.34	1100.0
2010-04-09 20:00:00	MSFT	Stock	30.06	30.06	30.06	30.06	300.0
2010-04-09 08:00:00	NVDA	Stock	0.425	0.425	0.425	0.425	4000.0
2010-04-09 09:00:00	NVDA	Stock	0.4248	0.4258	0.4188	0.4248	137621920.0
2010-04-09 10:00:00	NVDA	Stock	0.4248	0.4262	0.4232	0.4245	158774440.0
2010-04-09 11:00:00	NVDA	Stock	0.4248	0.426	0.4235	0.4255	92204200.0
2010-04-09 12:00:00	NVDA	Stock	0.4255	0.4258	0.4245	0.425	61958320.0
2010-04-09 13:00:00	NVDA	Stock	0.4248	0.4253	0.4245	0.425	68088160.0
2010-04-09 14:00:00	NVDA	Stock	0.425	0.4255	0.423	0.4232	125664080.0
2010-04-09 15:00:00	NVDA	Stock	0.4232	0.425	0.422	0.4245	148494560.0
2010-04-09 16:00:00	NVDA	Stock	0.4245	0.4248	0.4225	0.4225	10805120.0
2010-04-09 17:00:00	NVDA	Stock	0.4245	0.4245	0.4225	0.4225	70800.0
2010-04-09 18:00:00	NVDA	Stock	0.4225	0.4225	0.4225	0.4225	4000.0
2010-04-09 19:00:00	NVDA	Stock	0.4232	0.4245	0.4232	0.4245	34000.0
2010-04-09 08:00:00	AMZN	Stock	7.09	7.095	7.065	7.0755	120960.0
2010-04-09 09:00:00	AMZN	Stock	7.075	7.08	6.965	7.0075	26767180.0
2010-04-09 10:00:00	AMZN	Stock	7.0075	7.0345	6.9805	6.9848	21904080.0
2010-04-09 11:00:00	AMZN	Stock	6.9852	7.0075	6.9665	6.981	13787720.0
2010-04-09 12:00:00	AMZN	Stock	6.9822	6.99	6.9535	6.9755	12913100.0
2010-04-09 13:00:00	AMZN	Stock	6.9735	7.0115	6.958	6.9845	11804740.0
2010-04-09 14:00:00	AMZN	Stock	6.9845	7.0	6.973	6.978	8390560.0

> showing 50 of 42,998 rows — these rows as CSV

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