PREVIEW / stock_1hour / 2013-09-11

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-09-11.parquet
  size:    1011 KB
  rows:    46,695
  symbols: 3,519

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-09-11 04:00:00	AAPL	Stock	17.6429	17.6429	17.2643	17.3161	274176.0
2013-09-11 05:00:00	AAPL	Stock	17.315	17.3421	17.2846	17.3111	522116.0
2013-09-11 06:00:00	AAPL	Stock	17.3229	17.3471	17.1996	17.2136	1095752.0
2013-09-11 07:00:00	AAPL	Stock	17.2214	17.2496	16.8857	16.9554	11360440.0
2013-09-11 08:00:00	AAPL	Stock	16.95	17.0536	16.8664	16.8861	23606940.0
2013-09-11 09:00:00	AAPL	Stock	16.8814	16.9175	16.6004	16.7483	268384984.0
2013-09-11 10:00:00	AAPL	Stock	16.7479	16.8443	16.61	16.625	175835688.0
2013-09-11 11:00:00	AAPL	Stock	16.6289	16.7243	16.6071	16.6332	95923604.0
2013-09-11 12:00:00	AAPL	Stock	16.6343	16.7257	16.6268	16.6954	68361664.0
2013-09-11 13:00:00	AAPL	Stock	16.6961	16.805	16.6818	16.7793	64771560.0
2013-09-11 14:00:00	AAPL	Stock	16.7814	16.8232	16.7348	16.7725	48309184.0
2013-09-11 15:00:00	AAPL	Stock	16.7743	16.7857	16.6604	16.7082	103324788.0
2013-09-11 16:00:00	AAPL	Stock	16.7082	16.8238	16.6629	16.7082	23858016.0
2013-09-11 17:00:00	AAPL	Stock	16.7714	16.7857	16.7082	16.7661	1288616.0
2013-09-11 18:00:00	AAPL	Stock	16.7625	16.7786	16.7143	16.7421	504644.0
2013-09-11 19:00:00	AAPL	Stock	16.7443	16.7682	16.7411	16.7682	616364.0
2013-09-11 06:00:00	MSFT	Stock	32.5	32.5	32.5	32.5	200.0
2013-09-11 08:00:00	MSFT	Stock	32.44	32.52	32.35	32.41	27817.0
2013-09-11 09:00:00	MSFT	Stock	32.4	32.8	32.4	32.7	7327434.0
2013-09-11 10:00:00	MSFT	Stock	32.69	32.84	32.66	32.835	7095941.0
2013-09-11 11:00:00	MSFT	Stock	32.835	32.93	32.77	32.85	5187260.0
2013-09-11 12:00:00	MSFT	Stock	32.845	32.9	32.77	32.854	3096193.0
2013-09-11 13:00:00	MSFT	Stock	32.86	32.87	32.79	32.801	2812249.0
2013-09-11 14:00:00	MSFT	Stock	32.81	32.86	32.78	32.805	2575516.0
2013-09-11 15:00:00	MSFT	Stock	32.8	32.82	32.72	32.75	5922712.0
2013-09-11 16:00:00	MSFT	Stock	32.74	32.87	32.57	32.78	4028199.0
2013-09-11 17:00:00	MSFT	Stock	32.76	32.78	32.75	32.78	3122.0
2013-09-11 18:00:00	MSFT	Stock	32.76	32.78	32.76	32.78	12200.0
2013-09-11 19:00:00	MSFT	Stock	32.76	32.78	32.76	32.78	5500.0
2013-09-11 09:00:00	NVDA	Stock	0.386	0.387	0.3831	0.3838	29207640.0
2013-09-11 10:00:00	NVDA	Stock	0.3836	0.389	0.3835	0.3884	67793800.0
2013-09-11 11:00:00	NVDA	Stock	0.3885	0.3922	0.3882	0.3913	73814680.0
2013-09-11 12:00:00	NVDA	Stock	0.3915	0.3938	0.3908	0.3931	44658440.0
2013-09-11 13:00:00	NVDA	Stock	0.3933	0.3938	0.3918	0.3925	37597000.0
2013-09-11 14:00:00	NVDA	Stock	0.3925	0.393	0.3918	0.3926	32875640.0
2013-09-11 15:00:00	NVDA	Stock	0.3925	0.3933	0.3915	0.3928	87216960.0
2013-09-11 16:00:00	NVDA	Stock	0.3928	0.3928	0.3906	0.3915	19381160.0
2013-09-11 06:00:00	AMZN	Stock	14.9995	14.9995	14.9995	14.9995	2000.0
2013-09-11 07:00:00	AMZN	Stock	15.0	15.0	14.9985	14.9985	10000.0
2013-09-11 08:00:00	AMZN	Stock	15.015	15.015	15.015	15.015	30000.0
2013-09-11 09:00:00	AMZN	Stock	14.963	15.093	14.892	14.9707	6795960.0
2013-09-11 10:00:00	AMZN	Stock	14.9725	15.006	14.892	14.961	5687060.0
2013-09-11 11:00:00	AMZN	Stock	14.9588	15.005	14.9385	14.9825	4277860.0
2013-09-11 12:00:00	AMZN	Stock	14.9805	15.003	14.9735	14.9765	2777500.0
2013-09-11 13:00:00	AMZN	Stock	14.978	14.9925	14.917	14.978	3558840.0
2013-09-11 14:00:00	AMZN	Stock	14.9815	14.985	14.9365	14.952	2929840.0
2013-09-11 15:00:00	AMZN	Stock	14.953	14.982	14.9075	14.982	6474880.0
2013-09-11 16:00:00	AMZN	Stock	14.977	14.988	14.9386	14.985	2060580.0
2013-09-11 17:00:00	AMZN	Stock	14.9825	14.9825	14.9825	14.9825	2000.0
2013-09-11 18:00:00	AMZN	Stock	14.987	14.987	14.987	14.987	14420.0

> showing 50 of 46,695 rows — these rows as CSV

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