PREVIEW / stock_1hour / 2011-06-21

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-06-21.parquet
  size:    954 KB
  rows:    45,981
  symbols: 3,560

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
2011-06-21 04:00:00	AAPL	Stock	11.2679	11.2907	11.2679	11.2875	19600.0
2011-06-21 05:00:00	AAPL	Stock	11.2789	11.2789	11.2789	11.2789	2800.0
2011-06-21 06:00:00	AAPL	Stock	11.2586	11.2818	11.2586	11.28	67200.0
2011-06-21 07:00:00	AAPL	Stock	11.285	11.3693	11.285	11.3493	826616.0
2011-06-21 08:00:00	AAPL	Stock	11.3464	11.3525	11.2614	11.3375	2122064.0
2011-06-21 09:00:00	AAPL	Stock	11.3375	11.4057	11.2571	11.3856	93259208.0
2011-06-21 10:00:00	AAPL	Stock	11.3854	11.5625	11.3799	11.5396	122109008.0
2011-06-21 11:00:00	AAPL	Stock	11.5396	11.5932	11.528	11.5663	72188788.0
2011-06-21 12:00:00	AAPL	Stock	11.5665	11.5796	11.5382	11.5714	42316204.0
2011-06-21 13:00:00	AAPL	Stock	11.5709	11.6064	11.5621	11.5871	40517288.0
2011-06-21 14:00:00	AAPL	Stock	11.5875	11.6357	11.5843	11.6215	42335804.0
2011-06-21 15:00:00	AAPL	Stock	11.6232	11.6318	11.5679	11.6168	64114904.0
2011-06-21 16:00:00	AAPL	Stock	11.6179	11.625	11.2614	11.6179	9970408.0
2011-06-21 17:00:00	AAPL	Stock	11.6207	11.6286	11.6014	11.6179	354816.0
2011-06-21 18:00:00	AAPL	Stock	11.6179	11.625	11.5982	11.6125	404712.0
2011-06-21 19:00:00	AAPL	Stock	11.6143	11.6179	11.6	11.6154	251244.0
2011-06-21 06:00:00	MSFT	Stock	24.6	24.6	24.6	24.6	900.0
2011-06-21 07:00:00	MSFT	Stock	24.6	24.62	24.5	24.56	1800.0
2011-06-21 08:00:00	MSFT	Stock	24.59	24.62	24.47	24.57	59338.0
2011-06-21 09:00:00	MSFT	Stock	24.57	24.65	24.4	24.61	5788357.0
2011-06-21 10:00:00	MSFT	Stock	24.61	24.8	24.59	24.77	6667532.0
2011-06-21 11:00:00	MSFT	Stock	24.77	24.86	24.76	24.8	6483651.0
2011-06-21 12:00:00	MSFT	Stock	24.8	24.82	24.75	24.77	4324754.0
2011-06-21 13:00:00	MSFT	Stock	24.76	24.77	24.68	24.735	4937030.0
2011-06-21 14:00:00	MSFT	Stock	24.73	24.81	24.68	24.77	4639920.0
2011-06-21 15:00:00	MSFT	Stock	24.78	24.8	24.69	24.76	8028699.0
2011-06-21 16:00:00	MSFT	Stock	24.76	24.763	24.47	24.734	2308744.0
2011-06-21 17:00:00	MSFT	Stock	24.79	24.79	24.71	24.73	20687.0
2011-06-21 18:00:00	MSFT	Stock	24.76	24.76	24.68	24.74	51001.0
2011-06-21 19:00:00	MSFT	Stock	24.68	24.68	24.68	24.68	1560.0
2011-06-21 07:00:00	NVDA	Stock	0.3908	0.3928	0.3908	0.3928	22400.0
2011-06-21 08:00:00	NVDA	Stock	0.3905	0.3925	0.3905	0.3925	265640.0
2011-06-21 09:00:00	NVDA	Stock	0.3938	0.3975	0.3882	0.3962	73801880.0
2011-06-21 10:00:00	NVDA	Stock	0.3962	0.3993	0.3933	0.395	152948400.0
2011-06-21 11:00:00	NVDA	Stock	0.395	0.402	0.3945	0.3993	145741640.0
2011-06-21 12:00:00	NVDA	Stock	0.399	0.3993	0.397	0.399	35465400.0
2011-06-21 13:00:00	NVDA	Stock	0.3988	0.3993	0.3958	0.396	44488360.0
2011-06-21 14:00:00	NVDA	Stock	0.3962	0.4005	0.396	0.3982	68032840.0
2011-06-21 15:00:00	NVDA	Stock	0.3982	0.4	0.3978	0.3988	139198680.0
2011-06-21 16:00:00	NVDA	Stock	0.3988	0.4	0.3976	0.3998	15105080.0
2011-06-21 17:00:00	NVDA	Stock	0.3985	0.3985	0.3985	0.3985	76440.0
2011-06-21 18:00:00	NVDA	Stock	0.3998	0.3998	0.3998	0.3998	160000.0
2011-06-21 19:00:00	NVDA	Stock	0.3998	0.3998	0.3998	0.3998	22000.0
2011-06-21 07:00:00	AMZN	Stock	9.409	9.409	9.409	9.409	2000.0
2011-06-21 08:00:00	AMZN	Stock	9.4235	9.5	9.4225	9.454	132600.0
2011-06-21 09:00:00	AMZN	Stock	9.45	9.486	9.356	9.486	9461900.0
2011-06-21 10:00:00	AMZN	Stock	9.4835	9.6125	9.48	9.594	14362580.0
2011-06-21 11:00:00	AMZN	Stock	9.5955	9.722	9.589	9.704	18001100.0
2011-06-21 12:00:00	AMZN	Stock	9.704	9.7105	9.675	9.697	6777500.0
2011-06-21 13:00:00	AMZN	Stock	9.6975	9.6975	9.667	9.683	5753860.0

> showing 50 of 45,981 rows — these rows as CSV

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