PREVIEW / stock_1hour / 2010-03-19

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-03-19.parquet
  size:    947 KB
  rows:    44,146
  symbols: 3,459

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-03-19 06:00:00	AAPL	Stock	7.9896	7.9896	7.9846	7.9871	14000.0
2010-03-19 07:00:00	AAPL	Stock	7.9904	8.0	7.985	7.9911	53872.0
2010-03-19 08:00:00	AAPL	Stock	7.9975	8.0121	7.9946	7.9975	1364468.0
2010-03-19 09:00:00	AAPL	Stock	7.9989	8.0443	7.9604	7.9746	74376764.0
2010-03-19 10:00:00	AAPL	Stock	7.9746	7.975	7.9179	7.9275	92882468.0
2010-03-19 11:00:00	AAPL	Stock	7.9284	7.9482	7.915	7.9436	59417624.0
2010-03-19 12:00:00	AAPL	Stock	7.9436	7.9518	7.9286	7.93	33888120.0
2010-03-19 13:00:00	AAPL	Stock	7.9311	7.9393	7.9175	7.9365	34996948.0
2010-03-19 14:00:00	AAPL	Stock	7.9371	7.9446	7.9271	7.9314	32437160.0
2010-03-19 15:00:00	AAPL	Stock	7.9325	7.9404	7.9011	7.9361	89042856.0
2010-03-19 16:00:00	AAPL	Stock	7.9375	7.9592	7.912	7.9375	37794960.0
2010-03-19 17:00:00	AAPL	Stock	7.9346	7.9393	7.9321	7.9321	338968.0
2010-03-19 18:00:00	AAPL	Stock	7.9311	7.9375	7.9243	7.9257	233436.0
2010-03-19 19:00:00	AAPL	Stock	7.9257	7.9279	7.9179	7.9214	438284.0
2010-03-19 07:00:00	MSFT	Stock	29.45	29.51	29.41	29.51	3000.0
2010-03-19 08:00:00	MSFT	Stock	29.53	29.67	29.53	29.65	25339.0
2010-03-19 09:00:00	MSFT	Stock	29.65	29.9	29.51	29.77	27161202.0
2010-03-19 10:00:00	MSFT	Stock	29.77	29.78	29.51	29.61	6921736.0
2010-03-19 11:00:00	MSFT	Stock	29.6	29.62	29.39	29.45	5646349.0
2010-03-19 12:00:00	MSFT	Stock	29.44	29.53	29.35	29.37	4509910.0
2010-03-19 13:00:00	MSFT	Stock	29.38	29.51	29.36	29.495	4367812.0
2010-03-19 14:00:00	MSFT	Stock	29.5	29.59	29.435	29.48	4480035.0
2010-03-19 15:00:00	MSFT	Stock	29.488	29.6	29.38	29.6	9111618.0
2010-03-19 16:00:00	MSFT	Stock	29.6	29.65	29.415	29.61	14898737.0
2010-03-19 17:00:00	MSFT	Stock	29.58	29.61	29.55	29.6	4816.0
2010-03-19 18:00:00	MSFT	Stock	29.59	29.6	29.55	29.55	6918.0
2010-03-19 19:00:00	MSFT	Stock	29.55	29.58	29.54	29.58	2600.0
2010-03-19 07:00:00	NVDA	Stock	0.4365	0.4365	0.4365	0.4365	12000.0
2010-03-19 08:00:00	NVDA	Stock	0.4365	0.4372	0.4325	0.4372	227720.0
2010-03-19 09:00:00	NVDA	Stock	0.4372	0.4442	0.4302	0.434	68632120.0
2010-03-19 10:00:00	NVDA	Stock	0.4342	0.4342	0.4258	0.4271	101832840.0
2010-03-19 11:00:00	NVDA	Stock	0.4272	0.4318	0.4258	0.431	55341480.0
2010-03-19 12:00:00	NVDA	Stock	0.4311	0.432	0.4293	0.4304	50040360.0
2010-03-19 13:00:00	NVDA	Stock	0.4302	0.4315	0.4293	0.4315	34401720.0
2010-03-19 14:00:00	NVDA	Stock	0.4315	0.4322	0.4304	0.4312	39711800.0
2010-03-19 15:00:00	NVDA	Stock	0.4312	0.4322	0.4293	0.4312	121413000.0
2010-03-19 16:00:00	NVDA	Stock	0.4312	0.4322	0.4299	0.43	24322240.0
2010-03-19 17:00:00	NVDA	Stock	0.4312	0.432	0.4312	0.432	78600.0
2010-03-19 18:00:00	NVDA	Stock	0.432	0.432	0.432	0.432	6200.0
2010-03-19 19:00:00	NVDA	Stock	0.4312	0.4312	0.4312	0.4312	15560.0
2010-03-19 07:00:00	AMZN	Stock	6.6125	6.6375	6.6085	6.6335	50000.0
2010-03-19 08:00:00	AMZN	Stock	6.625	6.65	6.625	6.6455	69100.0
2010-03-19 09:00:00	AMZN	Stock	6.6375	6.6855	6.5955	6.604	12592560.0
2010-03-19 10:00:00	AMZN	Stock	6.6035	6.6073	6.538	6.5505	19575900.0
2010-03-19 11:00:00	AMZN	Stock	6.5495	6.554	6.5215	6.5345	13541000.0
2010-03-19 12:00:00	AMZN	Stock	6.5345	6.5435	6.501	6.509	10698180.0
2010-03-19 13:00:00	AMZN	Stock	6.5095	6.519	6.49	6.5055	15995720.0
2010-03-19 14:00:00	AMZN	Stock	6.5065	6.5175	6.5005	6.5028	15413880.0
2010-03-19 15:00:00	AMZN	Stock	6.5034	6.5255	6.483	6.5245	35319860.0
2010-03-19 16:00:00	AMZN	Stock	6.5245	6.5504	6.493	6.5249	30243700.0

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

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