PREVIEW / stock_1hour / 2014-09-05

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-09-05.parquet
  size:    1.0 MB
  rows:    48,175
  symbols: 3,585

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-05 04:00:00	AAPL	Stock	24.525	24.6125	24.5125	24.5325	18948.0
2014-09-05 05:00:00	AAPL	Stock	24.525	24.595	24.525	24.54	40268.0
2014-09-05 06:00:00	AAPL	Stock	24.54	24.555	24.515	24.5225	61616.0
2014-09-05 07:00:00	AAPL	Stock	24.5375	24.6825	24.5375	24.6575	334608.0
2014-09-05 08:00:00	AAPL	Stock	24.655	24.75	24.53	24.7275	1681496.0
2014-09-05 09:00:00	AAPL	Stock	24.7375	24.8125	24.61	24.745	39447572.0
2014-09-05 10:00:00	AAPL	Stock	24.7475	24.8475	24.645	24.775	38400240.0
2014-09-05 11:00:00	AAPL	Stock	24.7738	24.8125	24.646	24.69	29591476.0
2014-09-05 12:00:00	AAPL	Stock	24.6925	24.7325	24.6	24.6048	21074868.0
2014-09-05 13:00:00	AAPL	Stock	24.605	24.6775	24.5775	24.675	15076824.0
2014-09-05 14:00:00	AAPL	Stock	24.6775	24.715	24.6475	24.6625	16289360.0
2014-09-05 15:00:00	AAPL	Stock	24.6612	24.7475	24.6125	24.7375	37777352.0
2014-09-05 16:00:00	AAPL	Stock	24.7425	24.765	23.3368	24.755	11863752.0
2014-09-05 17:00:00	AAPL	Stock	24.7525	24.7625	24.678	24.7575	636244.0
2014-09-05 18:00:00	AAPL	Stock	24.76	24.7625	24.7425	24.7425	335988.0
2014-09-05 19:00:00	AAPL	Stock	24.74	24.75	24.735	24.7475	149644.0
2014-09-05 05:00:00	MSFT	Stock	45.21	45.21	45.21	45.21	1500.0
2014-09-05 07:00:00	MSFT	Stock	45.16	45.16	45.16	45.16	100.0
2014-09-05 08:00:00	MSFT	Stock	45.11	45.23	45.1	45.22	22250.0
2014-09-05 09:00:00	MSFT	Stock	45.15	45.31	45.11	45.17	4363923.0
2014-09-05 10:00:00	MSFT	Stock	45.165	45.36	45.15	45.215	3479802.0
2014-09-05 11:00:00	MSFT	Stock	45.22	45.43	45.21	45.38	3015758.0
2014-09-05 12:00:00	MSFT	Stock	45.37	45.72	45.37	45.719	4132803.0
2014-09-05 13:00:00	MSFT	Stock	45.71	45.875	45.7	45.79	4953272.0
2014-09-05 14:00:00	MSFT	Stock	45.79	45.91	45.74	45.77	3620056.0
2014-09-05 15:00:00	MSFT	Stock	45.77	45.93	45.76	45.9	8501046.0
2014-09-05 16:00:00	MSFT	Stock	45.91	45.93	45.11	45.91	3764720.0
2014-09-05 17:00:00	MSFT	Stock	45.88	46.27	45.823	46.17	223344.0
2014-09-05 18:00:00	MSFT	Stock	46.23	46.33	45.91	46.18	53406.0
2014-09-05 19:00:00	MSFT	Stock	46.16	46.19	46.1	46.19	18310.0
2014-09-05 06:00:00	NVDA	Stock	0.5025	0.5025	0.5025	0.5025	20000.0
2014-09-05 07:00:00	NVDA	Stock	0.5025	0.5025	0.5008	0.5008	32000.0
2014-09-05 08:00:00	NVDA	Stock	0.5025	0.5025	0.5008	0.5008	45200.0
2014-09-05 09:00:00	NVDA	Stock	0.5008	0.5032	0.4968	0.502	39520360.0
2014-09-05 10:00:00	NVDA	Stock	0.5022	0.5025	0.4975	0.4978	45717720.0
2014-09-05 11:00:00	NVDA	Stock	0.4978	0.4992	0.496	0.4985	33935320.0
2014-09-05 12:00:00	NVDA	Stock	0.4986	0.5	0.4975	0.4978	22723560.0
2014-09-05 13:00:00	NVDA	Stock	0.4978	0.4988	0.4972	0.4979	14313240.0
2014-09-05 14:00:00	NVDA	Stock	0.498	0.499	0.4975	0.4979	19024400.0
2014-09-05 15:00:00	NVDA	Stock	0.498	0.5003	0.4978	0.499	55697680.0
2014-09-05 16:00:00	NVDA	Stock	0.4992	0.5006	0.4992	0.4992	1169320.0
2014-09-05 04:00:00	AMZN	Stock	17.309	17.309	17.275	17.275	9220.0
2014-09-05 07:00:00	AMZN	Stock	17.299	17.3105	17.2975	17.31	60020.0
2014-09-05 08:00:00	AMZN	Stock	17.2975	17.3875	17.275	17.3465	273380.0
2014-09-05 09:00:00	AMZN	Stock	17.3175	17.35	17.125	17.2655	8238100.0
2014-09-05 10:00:00	AMZN	Stock	17.265	17.2845	17.151	17.1895	5687260.0
2014-09-05 11:00:00	AMZN	Stock	17.1915	17.262	17.17	17.253	3210100.0
2014-09-05 12:00:00	AMZN	Stock	17.2525	17.276	17.2355	17.2575	2625480.0
2014-09-05 13:00:00	AMZN	Stock	17.2595	17.3375	17.2435	17.2545	3774520.0
2014-09-05 14:00:00	AMZN	Stock	17.2585	17.318	17.256	17.2648	2933160.0

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

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