PREVIEW / stock_1hour / 2010-07-07

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-07-07.parquet
  size:    910 KB
  rows:    44,734
  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-07-07 05:00:00	AAPL	Stock	8.85	8.8661	8.85	8.8661	5600.0
2010-07-07 06:00:00	AAPL	Stock	8.8661	8.8796	8.8661	8.8796	16800.0
2010-07-07 07:00:00	AAPL	Stock	8.8761	8.8929	8.8696	8.8911	200508.0
2010-07-07 08:00:00	AAPL	Stock	8.895	8.8975	8.8586	8.8811	2146536.0
2010-07-07 09:00:00	AAPL	Stock	8.8889	8.9879	8.8839	8.9625	86989560.0
2010-07-07 10:00:00	AAPL	Stock	8.9632	9.0389	8.9611	9.0278	121125368.0
2010-07-07 11:00:00	AAPL	Stock	9.0268	9.0661	9.0179	9.0349	89039076.0
2010-07-07 12:00:00	AAPL	Stock	9.0343	9.0882	9.0329	9.0732	53103148.0
2010-07-07 13:00:00	AAPL	Stock	9.0732	9.1339	9.065	9.1157	67289964.0
2010-07-07 14:00:00	AAPL	Stock	9.1161	9.1396	9.1007	9.1396	64824984.0
2010-07-07 15:00:00	AAPL	Stock	9.1386	9.2418	9.1195	9.2418	145498052.0
2010-07-07 16:00:00	AAPL	Stock	9.2386	9.2675	8.946	9.2482	17682364.0
2010-07-07 17:00:00	AAPL	Stock	9.2482	9.2561	9.1279	9.255	705908.0
2010-07-07 18:00:00	AAPL	Stock	9.255	9.2571	9.2382	9.2496	658560.0
2010-07-07 19:00:00	AAPL	Stock	9.2486	9.2536	9.2411	9.2536	598892.0
2010-07-07 07:00:00	MSFT	Stock	23.85	23.85	23.81	23.81	5500.0
2010-07-07 08:00:00	MSFT	Stock	23.84	23.95	23.82	23.95	21160.0
2010-07-07 09:00:00	MSFT	Stock	23.95	23.95	23.61	23.74	9987390.0
2010-07-07 10:00:00	MSFT	Stock	23.74	24.13	23.7	24.092	15354960.0
2010-07-07 11:00:00	MSFT	Stock	24.09	24.12	23.95	24.0	9385220.0
2010-07-07 12:00:00	MSFT	Stock	24.0	24.04	23.925	23.951	6021355.0
2010-07-07 13:00:00	MSFT	Stock	23.95	24.14	23.92	24.07	6125119.0
2010-07-07 14:00:00	MSFT	Stock	24.07	24.1	23.91	24.07	6961671.0
2010-07-07 15:00:00	MSFT	Stock	24.06	24.31	24.0	24.31	19348715.0
2010-07-07 16:00:00	MSFT	Stock	24.29	24.39	23.985	24.33	3299403.0
2010-07-07 17:00:00	MSFT	Stock	23.82	24.36	23.82	24.36	39701.0
2010-07-07 18:00:00	MSFT	Stock	24.34	24.35	24.3	24.3	22964.0
2010-07-07 19:00:00	MSFT	Stock	24.33	24.35	24.3	24.32	2525.0
2010-07-07 20:00:00	MSFT	Stock	23.92	23.92	23.92	23.92	5900.0
2010-07-07 08:00:00	NVDA	Stock	0.2538	0.2538	0.2538	0.2538	20000.0
2010-07-07 09:00:00	NVDA	Stock	0.2545	0.2612	0.254	0.2605	61735400.0
2010-07-07 10:00:00	NVDA	Stock	0.2608	0.2625	0.2588	0.261	134928240.0
2010-07-07 11:00:00	NVDA	Stock	0.261	0.2615	0.258	0.2603	58129080.0
2010-07-07 12:00:00	NVDA	Stock	0.2603	0.2608	0.2595	0.2603	38468400.0
2010-07-07 13:00:00	NVDA	Stock	0.2603	0.263	0.2603	0.2625	66845560.0
2010-07-07 14:00:00	NVDA	Stock	0.2625	0.2638	0.2615	0.2632	62859280.0
2010-07-07 15:00:00	NVDA	Stock	0.2632	0.2672	0.262	0.2658	166170800.0
2010-07-07 16:00:00	NVDA	Stock	0.266	0.2672	0.2616	0.266	7596000.0
2010-07-07 17:00:00	NVDA	Stock	0.2668	0.2668	0.2665	0.2665	24000.0
2010-07-07 18:00:00	NVDA	Stock	0.2665	0.2668	0.2652	0.2652	86920.0
2010-07-07 19:00:00	NVDA	Stock	0.2663	0.2665	0.266	0.2665	108000.0
2010-07-07 08:00:00	AMZN	Stock	5.5055	5.5055	5.5055	5.5055	2000.0
2010-07-07 09:00:00	AMZN	Stock	5.507	5.5495	5.4905	5.5235	8088520.0
2010-07-07 10:00:00	AMZN	Stock	5.5245	5.593	5.522	5.5815	16313720.0
2010-07-07 11:00:00	AMZN	Stock	5.5798	5.583	5.501	5.537	11970300.0
2010-07-07 12:00:00	AMZN	Stock	5.5368	5.5398	5.496	5.5065	7241840.0
2010-07-07 13:00:00	AMZN	Stock	5.507	5.5868	5.5035	5.5775	12826360.0
2010-07-07 14:00:00	AMZN	Stock	5.5775	5.6295	5.5775	5.629	12415600.0
2010-07-07 15:00:00	AMZN	Stock	5.6295	5.6815	5.618	5.6725	24400300.0
2010-07-07 16:00:00	AMZN	Stock	5.6745	5.6775	5.5815	5.673	4106100.0

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

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