PREVIEW / stock_1hour / 2010-10-11

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-10-11.parquet
  size:    883 KB
  rows:    42,546
  symbols: 3,465

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-10-11 04:00:00	AAPL	Stock	10.4929	10.4929	10.4929	10.4929	2800.0
2010-10-11 06:00:00	AAPL	Stock	10.5107	10.5111	10.5107	10.5111	5600.0
2010-10-11 07:00:00	AAPL	Stock	10.5346	10.5446	10.5154	10.5364	224280.0
2010-10-11 08:00:00	AAPL	Stock	10.5357	10.5439	10.5225	10.5357	3382092.0
2010-10-11 09:00:00	AAPL	Stock	10.5361	10.5961	10.5179	10.5764	87459792.0
2010-10-11 10:00:00	AAPL	Stock	10.5754	10.6114	10.5571	10.573	97353564.0
2010-10-11 11:00:00	AAPL	Stock	10.5721	10.5936	10.5661	10.5739	37407328.0
2010-10-11 12:00:00	AAPL	Stock	10.575	10.6007	10.5679	10.5927	23729776.0
2010-10-11 13:00:00	AAPL	Stock	10.5929	10.6046	10.5857	10.6004	21195076.0
2010-10-11 14:00:00	AAPL	Stock	10.6018	10.6157	10.5914	10.6054	43459864.0
2010-10-11 15:00:00	AAPL	Stock	10.6052	10.61	10.5214	10.5486	96878488.0
2010-10-11 16:00:00	AAPL	Stock	10.5529	10.581	10.5481	10.581	15005676.0
2010-10-11 17:00:00	AAPL	Stock	10.5039	10.5593	10.5039	10.5579	214928.0
2010-10-11 18:00:00	AAPL	Stock	10.5589	10.5593	10.5432	10.5536	762580.0
2010-10-11 19:00:00	AAPL	Stock	10.5546	10.5546	10.5432	10.5479	134960.0
2010-10-11 04:00:00	MSFT	Stock	24.75	24.75	24.75	24.75	990.0
2010-10-11 05:00:00	MSFT	Stock	24.72	24.75	24.71	24.71	1410.0
2010-10-11 06:00:00	MSFT	Stock	24.71	24.72	24.71	24.72	1500.0
2010-10-11 07:00:00	MSFT	Stock	24.77	24.77	24.71	24.74	1030.0
2010-10-11 08:00:00	MSFT	Stock	24.71	24.75	24.68	24.7	33047.0
2010-10-11 09:00:00	MSFT	Stock	24.72	24.74	24.53	24.59	3108988.0
2010-10-11 10:00:00	MSFT	Stock	24.585	24.64	24.56	24.57	5845222.0
2010-10-11 11:00:00	MSFT	Stock	24.57	24.64	24.55	24.635	3758549.0
2010-10-11 12:00:00	MSFT	Stock	24.63	24.71	24.62	24.68	3583393.0
2010-10-11 13:00:00	MSFT	Stock	24.675	24.68	24.61	24.658	1685827.0
2010-10-11 14:00:00	MSFT	Stock	24.659	24.66	24.6	24.6	2076825.0
2010-10-11 15:00:00	MSFT	Stock	24.6	24.62	24.5	24.58	5848259.0
2010-10-11 16:00:00	MSFT	Stock	24.59	24.62	24.533	24.589	785348.0
2010-10-11 17:00:00	MSFT	Stock	24.61	24.62	24.6	24.6	4580.0
2010-10-11 18:00:00	MSFT	Stock	24.6	24.62	24.59	24.6	34873.0
2010-10-11 19:00:00	MSFT	Stock	24.59	24.6	24.59	24.59	1375.0
2010-10-11 08:00:00	NVDA	Stock	0.2712	0.323	0.2712	0.2738	362560.0
2010-10-11 09:00:00	NVDA	Stock	0.2738	0.275	0.27	0.2712	53082480.0
2010-10-11 10:00:00	NVDA	Stock	0.271	0.2748	0.2703	0.2725	109081560.0
2010-10-11 11:00:00	NVDA	Stock	0.2724	0.275	0.2718	0.2738	62106840.0
2010-10-11 12:00:00	NVDA	Stock	0.2738	0.2748	0.273	0.2743	42760400.0
2010-10-11 13:00:00	NVDA	Stock	0.2745	0.2748	0.2732	0.2738	23663760.0
2010-10-11 14:00:00	NVDA	Stock	0.2738	0.274	0.272	0.2725	35799720.0
2010-10-11 15:00:00	NVDA	Stock	0.2725	0.273	0.269	0.27	110977560.0
2010-10-11 16:00:00	NVDA	Stock	0.2705	0.2722	0.2692	0.2702	2799480.0
2010-10-11 17:00:00	NVDA	Stock	0.2715	0.2715	0.2703	0.2703	96000.0
2010-10-11 18:00:00	NVDA	Stock	0.2708	0.2708	0.2703	0.2703	88000.0
2010-10-11 19:00:00	NVDA	Stock	0.2703	0.2703	0.2695	0.2695	262000.0
2010-10-11 08:00:00	AMZN	Stock	7.787	7.787	7.758	7.758	36100.0
2010-10-11 09:00:00	AMZN	Stock	7.7505	7.8315	7.732	7.7793	11071760.0
2010-10-11 10:00:00	AMZN	Stock	7.78	7.8115	7.72	7.723	17733640.0
2010-10-11 11:00:00	AMZN	Stock	7.7256	7.7495	7.7005	7.7305	9561880.0
2010-10-11 12:00:00	AMZN	Stock	7.7315	7.7615	7.7252	7.7515	7430660.0
2010-10-11 13:00:00	AMZN	Stock	7.7515	7.7595	7.74	7.75	5593560.0
2010-10-11 14:00:00	AMZN	Stock	7.75	7.7535	7.6815	7.684	10686580.0

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

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