PREVIEW / stock_1hour / 2010-08-13

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-08-13.parquet
  size:    892 KB
  rows:    43,317
  symbols: 3,451

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-08-13 05:00:00	AAPL	Stock	8.9975	8.9975	8.9975	8.9975	5600.0
2010-08-13 06:00:00	AAPL	Stock	8.9725	8.9725	8.9696	8.9696	9408.0
2010-08-13 07:00:00	AAPL	Stock	8.9714	8.9757	8.9439	8.9596	87640.0
2010-08-13 08:00:00	AAPL	Stock	8.9636	9.0061	8.9554	8.9875	3148460.0
2010-08-13 09:00:00	AAPL	Stock	8.9925	8.9964	8.9089	8.9461	75381796.0
2010-08-13 10:00:00	AAPL	Stock	8.9482	8.9621	8.9054	8.9239	72908724.0
2010-08-13 11:00:00	AAPL	Stock	8.9243	8.9321	8.8961	8.9264	40644660.0
2010-08-13 12:00:00	AAPL	Stock	8.9267	8.9418	8.9239	8.94	23269120.0
2010-08-13 13:00:00	AAPL	Stock	8.94	8.9543	8.9279	8.9314	24247580.0
2010-08-13 14:00:00	AAPL	Stock	8.9311	8.9336	8.9143	8.9214	28805140.0
2010-08-13 15:00:00	AAPL	Stock	8.9232	8.9321	8.8964	8.8964	70360668.0
2010-08-13 16:00:00	AAPL	Stock	8.8964	8.9925	8.8857	8.8904	12549348.0
2010-08-13 17:00:00	AAPL	Stock	8.8893	8.8929	8.8868	8.8879	185500.0
2010-08-13 18:00:00	AAPL	Stock	8.8893	8.8964	8.8857	8.8893	330316.0
2010-08-13 19:00:00	AAPL	Stock	8.8882	8.8882	8.8786	8.8857	185388.0
2010-08-13 07:00:00	MSFT	Stock	24.48	24.48	24.48	24.48	2000.0
2010-08-13 08:00:00	MSFT	Stock	24.48	24.55	24.4	24.55	16495.0
2010-08-13 09:00:00	MSFT	Stock	24.59	24.59	24.24	24.4	5967562.0
2010-08-13 10:00:00	MSFT	Stock	24.4	24.41	24.28	24.38	6438020.0
2010-08-13 11:00:00	MSFT	Stock	24.389	24.46	24.35	24.45	5537669.0
2010-08-13 12:00:00	MSFT	Stock	24.445	24.5	24.42	24.495	3871775.0
2010-08-13 13:00:00	MSFT	Stock	24.492	24.61	24.49	24.59	4888108.0
2010-08-13 14:00:00	MSFT	Stock	24.59	24.67	24.56	24.59	5469149.0
2010-08-13 15:00:00	MSFT	Stock	24.59	24.61	24.39	24.4	8883545.0
2010-08-13 16:00:00	MSFT	Stock	24.4	24.53	24.35	24.36	2675237.0
2010-08-13 17:00:00	MSFT	Stock	24.4	24.41	24.4	24.4	30703.0
2010-08-13 18:00:00	MSFT	Stock	24.41	24.42	24.4	24.42	12641.0
2010-08-13 19:00:00	MSFT	Stock	24.45	24.45	24.4	24.43	2225.0
2010-08-13 20:00:00	MSFT	Stock	24.46	24.46	24.46	24.46	2300.0
2010-08-13 06:00:00	NVDA	Stock	0.2275	0.23	0.2275	0.23	200000.0
2010-08-13 07:00:00	NVDA	Stock	0.2288	0.235	0.2288	0.2335	6906400.0
2010-08-13 08:00:00	NVDA	Stock	0.2332	0.237	0.2303	0.2315	72646760.0
2010-08-13 09:00:00	NVDA	Stock	0.2315	0.237	0.2303	0.2345	400127720.0
2010-08-13 10:00:00	NVDA	Stock	0.2346	0.2355	0.232	0.2336	321221840.0
2010-08-13 11:00:00	NVDA	Stock	0.2338	0.2355	0.2322	0.2352	181192200.0
2010-08-13 12:00:00	NVDA	Stock	0.2352	0.238	0.2349	0.2375	172096040.0
2010-08-13 13:00:00	NVDA	Stock	0.2376	0.238	0.236	0.2362	155727680.0
2010-08-13 14:00:00	NVDA	Stock	0.2365	0.2375	0.234	0.2355	197465080.0
2010-08-13 15:00:00	NVDA	Stock	0.2355	0.2368	0.234	0.2345	238393880.0
2010-08-13 16:00:00	NVDA	Stock	0.2348	0.2375	0.224	0.2348	28549720.0
2010-08-13 17:00:00	NVDA	Stock	0.2365	0.2365	0.2342	0.2345	288480.0
2010-08-13 18:00:00	NVDA	Stock	0.235	0.2362	0.2348	0.2348	36000.0
2010-08-13 19:00:00	NVDA	Stock	0.2355	0.2358	0.2348	0.2358	323280.0
2010-08-13 08:00:00	AMZN	Stock	6.321	6.3245	6.321	6.3245	25980.0
2010-08-13 09:00:00	AMZN	Stock	6.32	6.374	6.2575	6.2925	12114960.0
2010-08-13 10:00:00	AMZN	Stock	6.293	6.299	6.237	6.2545	13092440.0
2010-08-13 11:00:00	AMZN	Stock	6.2535	6.2575	6.213	6.2325	11513580.0
2010-08-13 12:00:00	AMZN	Stock	6.232	6.254	6.2305	6.2515	7376960.0
2010-08-13 13:00:00	AMZN	Stock	6.25	6.277	6.236	6.2675	8084960.0
2010-08-13 14:00:00	AMZN	Stock	6.2675	6.276	6.2455	6.2475	7580040.0

> showing 50 of 43,317 rows — these rows as CSV

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