PREVIEW / stock_1hour / 2014-09-10

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-09-10.parquet
  size:    1.0 MB
  rows:    48,672
  symbols: 3,569

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
2014-09-10 04:00:00	AAPL	Stock	23.475	24.6	23.475	24.325	237416.0
2014-09-10 05:00:00	AAPL	Stock	24.345	24.4475	24.345	24.4125	149376.0
2014-09-10 06:00:00	AAPL	Stock	24.405	24.6625	24.3925	24.64	313892.0
2014-09-10 07:00:00	AAPL	Stock	24.63	24.6475	24.3375	24.3875	1710292.0
2014-09-10 08:00:00	AAPL	Stock	24.4125	24.6275	24.255	24.495	3386052.0
2014-09-10 09:00:00	AAPL	Stock	24.4825	24.825	24.4475	24.57	68434976.0
2014-09-10 10:00:00	AAPL	Stock	24.5675	24.725	24.44	24.6888	65944864.0
2014-09-10 11:00:00	AAPL	Stock	24.6875	24.9375	24.575	24.9125	52101096.0
2014-09-10 12:00:00	AAPL	Stock	24.91	25.185	24.855	25.1102	48079188.0
2014-09-10 13:00:00	AAPL	Stock	25.111	25.2775	25.015	25.045	51729576.0
2014-09-10 14:00:00	AAPL	Stock	25.045	25.13	24.975	25.0818	27323776.0
2014-09-10 15:00:00	AAPL	Stock	25.0825	25.2625	25.06	25.245	55717512.0
2014-09-10 16:00:00	AAPL	Stock	25.25	25.26	24.4835	25.24	8098192.0
2014-09-10 17:00:00	AAPL	Stock	25.2375	25.25	25.215	25.215	1365144.0
2014-09-10 18:00:00	AAPL	Stock	25.215	25.25	25.2125	25.2425	394492.0
2014-09-10 19:00:00	AAPL	Stock	25.24	25.2975	25.24	25.2975	341728.0
2014-09-10 06:00:00	MSFT	Stock	46.97	47.08	46.97	47.08	1300.0
2014-09-10 07:00:00	MSFT	Stock	46.99	47.0	46.95	46.95	4300.0
2014-09-10 08:00:00	MSFT	Stock	46.85	46.93	46.85	46.9	18472.0
2014-09-10 09:00:00	MSFT	Stock	46.9	46.93	46.28	46.71	4948516.0
2014-09-10 10:00:00	MSFT	Stock	46.705	46.81	46.63	46.72	3939377.0
2014-09-10 11:00:00	MSFT	Stock	46.72	46.78	46.66	46.78	3892635.0
2014-09-10 12:00:00	MSFT	Stock	46.77	46.79	46.71	46.76	1411991.0
2014-09-10 13:00:00	MSFT	Stock	46.765	46.88	46.72	46.86	2121287.0
2014-09-10 14:00:00	MSFT	Stock	46.86	46.94	46.7	46.76	2772576.0
2014-09-10 15:00:00	MSFT	Stock	46.755	46.86	46.75	46.825	4647854.0
2014-09-10 16:00:00	MSFT	Stock	46.84	46.88	46.748	46.85	2047509.0
2014-09-10 17:00:00	MSFT	Stock	46.84	46.88	46.84	46.88	1864.0
2014-09-10 18:00:00	MSFT	Stock	46.84	46.9	46.84	46.9	4457.0
2014-09-10 19:00:00	MSFT	Stock	46.85	46.85	46.85	46.85	599.0
2014-09-10 09:00:00	NVDA	Stock	0.4912	0.4921	0.486	0.4866	18544920.0
2014-09-10 10:00:00	NVDA	Stock	0.4865	0.4875	0.4856	0.4865	22603920.0
2014-09-10 11:00:00	NVDA	Stock	0.4868	0.4885	0.486	0.488	17228560.0
2014-09-10 12:00:00	NVDA	Stock	0.488	0.4888	0.4869	0.4871	12029280.0
2014-09-10 13:00:00	NVDA	Stock	0.487	0.4884	0.487	0.4876	9956040.0
2014-09-10 14:00:00	NVDA	Stock	0.4878	0.4885	0.4872	0.4883	10123840.0
2014-09-10 15:00:00	NVDA	Stock	0.488	0.4908	0.488	0.4902	50630920.0
2014-09-10 16:00:00	NVDA	Stock	0.4902	0.4902	0.4886	0.4902	26307400.0
2014-09-10 04:00:00	AMZN	Stock	16.4375	16.4375	16.4375	16.4375	6000.0
2014-09-10 07:00:00	AMZN	Stock	16.45	16.45	16.4375	16.4375	4600.0
2014-09-10 08:00:00	AMZN	Stock	16.4375	16.775	16.4	16.7	421680.0
2014-09-10 09:00:00	AMZN	Stock	16.6745	16.8	16.5	16.5295	21889260.0
2014-09-10 10:00:00	AMZN	Stock	16.5218	16.6125	16.441	16.5695	13408140.0
2014-09-10 11:00:00	AMZN	Stock	16.572	16.62	16.4925	16.5011	6226720.0
2014-09-10 12:00:00	AMZN	Stock	16.501	16.5894	16.501	16.5165	5205420.0
2014-09-10 13:00:00	AMZN	Stock	16.52	16.6105	16.5183	16.5956	4859180.0
2014-09-10 14:00:00	AMZN	Stock	16.5989	16.611	16.487	16.5115	4645580.0
2014-09-10 15:00:00	AMZN	Stock	16.5115	16.5775	16.507	16.567	10125900.0
2014-09-10 16:00:00	AMZN	Stock	16.5665	16.57	16.553	16.57	101180.0
2014-09-10 17:00:00	AMZN	Stock	16.565	16.565	16.565	16.565	2400.0

> showing 50 of 48,672 rows — these rows as CSV

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