PREVIEW / stock_1hour / 2013-03-28

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-03-28.parquet
  size:    984 KB
  rows:    45,572
  symbols: 3,494

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
2013-03-28 04:00:00	AAPL	Stock	16.0936	16.0936	16.0936	16.0936	2800.0
2013-03-28 07:00:00	AAPL	Stock	16.1564	16.1786	16.1493	16.1682	55636.0
2013-03-28 08:00:00	AAPL	Stock	16.1786	16.1786	16.0929	16.1018	776692.0
2013-03-28 09:00:00	AAPL	Stock	16.1061	16.1364	16.0032	16.0714	64022168.0
2013-03-28 10:00:00	AAPL	Stock	16.0714	16.0929	15.9871	16.0168	59056956.0
2013-03-28 11:00:00	AAPL	Stock	16.02	16.024	15.8454	15.8704	76740804.0
2013-03-28 12:00:00	AAPL	Stock	15.8693	15.8982	15.8463	15.8646	44809492.0
2013-03-28 13:00:00	AAPL	Stock	15.8646	15.8918	15.8404	15.8586	22805076.0
2013-03-28 14:00:00	AAPL	Stock	15.8586	15.8618	15.7721	15.825	48303668.0
2013-03-28 15:00:00	AAPL	Stock	15.8257	15.8386	15.7768	15.805	80391276.0
2013-03-28 16:00:00	AAPL	Stock	15.8041	15.9139	15.7143	15.7714	33560184.0
2013-03-28 17:00:00	AAPL	Stock	15.7786	15.8082	15.7707	15.7964	1761340.0
2013-03-28 18:00:00	AAPL	Stock	15.7843	15.7939	15.7786	15.7939	72436.0
2013-03-28 19:00:00	AAPL	Stock	15.7893	15.7893	15.7679	15.7857	117880.0
2013-03-28 06:00:00	MSFT	Stock	28.21	28.21	28.21	28.21	400.0
2013-03-28 07:00:00	MSFT	Stock	28.38	28.48	28.38	28.48	490.0
2013-03-28 08:00:00	MSFT	Stock	28.37	28.45	28.32	28.4	13904.0
2013-03-28 09:00:00	MSFT	Stock	28.38	28.47	28.26	28.355	3728503.0
2013-03-28 10:00:00	MSFT	Stock	28.36	28.52	28.34	28.5	3733534.0
2013-03-28 11:00:00	MSFT	Stock	28.5	28.66	28.49	28.555	8109128.0
2013-03-28 12:00:00	MSFT	Stock	28.555	28.565	28.333	28.46	8709409.0
2013-03-28 13:00:00	MSFT	Stock	28.46	28.51	28.45	28.455	1955796.0
2013-03-28 14:00:00	MSFT	Stock	28.46	28.6	28.455	28.56	4448493.0
2013-03-28 15:00:00	MSFT	Stock	28.57	28.635	28.51	28.6	8489072.0
2013-03-28 16:00:00	MSFT	Stock	28.615	28.635	28.484	28.61	10818244.0
2013-03-28 17:00:00	MSFT	Stock	28.62	28.66	28.59	28.62	14093.0
2013-03-28 18:00:00	MSFT	Stock	28.61	28.61	28.6	28.6	1000.0
2013-03-28 19:00:00	MSFT	Stock	28.6	28.6	28.6	28.6	900.0
2013-03-28 08:00:00	NVDA	Stock	0.3163	0.3163	0.3163	0.3163	22000.0
2013-03-28 09:00:00	NVDA	Stock	0.3175	0.3175	0.3133	0.315	27039760.0
2013-03-28 10:00:00	NVDA	Stock	0.3149	0.316	0.314	0.3156	27973160.0
2013-03-28 11:00:00	NVDA	Stock	0.3158	0.3185	0.3153	0.3183	27471120.0
2013-03-28 12:00:00	NVDA	Stock	0.3182	0.3183	0.3158	0.3168	22419400.0
2013-03-28 13:00:00	NVDA	Stock	0.3168	0.317	0.3163	0.3163	15368880.0
2013-03-28 14:00:00	NVDA	Stock	0.3165	0.318	0.3163	0.3178	26166200.0
2013-03-28 15:00:00	NVDA	Stock	0.318	0.321	0.3173	0.3203	146043400.0
2013-03-28 16:00:00	NVDA	Stock	0.3204	0.3213	0.319	0.3213	55717360.0
2013-03-28 05:00:00	AMZN	Stock	13.245	13.245	13.245	13.245	2000.0
2013-03-28 06:00:00	AMZN	Stock	13.238	13.238	13.238	13.238	2000.0
2013-03-28 07:00:00	AMZN	Stock	13.265	13.265	13.265	13.265	2000.0
2013-03-28 08:00:00	AMZN	Stock	13.2675	13.275	13.2675	13.275	34000.0
2013-03-28 09:00:00	AMZN	Stock	13.273	13.3688	13.265	13.343	8827640.0
2013-03-28 10:00:00	AMZN	Stock	13.3455	13.3524	13.2485	13.2555	7940960.0
2013-03-28 11:00:00	AMZN	Stock	13.2605	13.272	13.203	13.248	5310680.0
2013-03-28 12:00:00	AMZN	Stock	13.2525	13.2895	13.237	13.2495	3238980.0
2013-03-28 13:00:00	AMZN	Stock	13.257	13.279	13.2415	13.2695	2560700.0
2013-03-28 14:00:00	AMZN	Stock	13.268	13.3024	13.264	13.2745	3227580.0
2013-03-28 15:00:00	AMZN	Stock	13.276	13.361	13.266	13.321	10961680.0
2013-03-28 16:00:00	AMZN	Stock	13.3255	13.3275	13.2715	13.324	2153700.0
2013-03-28 17:00:00	AMZN	Stock	13.305	13.324	13.305	13.324	18000.0

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

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