PREVIEW / stock_1hour / 2014-07-02

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-07-02.parquet
  size:    1.1 MB
  rows:    50,531
  symbols: 3,570

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-07-02 05:00:00	AAPL	Stock	23.465	23.465	23.425	23.4275	9392.0
2014-07-02 06:00:00	AAPL	Stock	23.42	23.4725	23.41	23.4375	29252.0
2014-07-02 07:00:00	AAPL	Stock	23.4675	23.485	23.45	23.45	91452.0
2014-07-02 08:00:00	AAPL	Stock	23.45	23.525	23.445	23.455	510120.0
2014-07-02 09:00:00	AAPL	Stock	23.455	23.515	23.4125	23.4575	19822196.0
2014-07-02 10:00:00	AAPL	Stock	23.457	23.4725	23.3875	23.4218	18223304.0
2014-07-02 11:00:00	AAPL	Stock	23.4212	23.4425	23.335	23.425	17075100.0
2014-07-02 12:00:00	AAPL	Stock	23.425	23.435	23.3475	23.3675	8692484.0
2014-07-02 13:00:00	AAPL	Stock	23.3675	23.407	23.3475	23.3825	7991956.0
2014-07-02 14:00:00	AAPL	Stock	23.38	23.3925	23.3125	23.335	8067252.0
2014-07-02 15:00:00	AAPL	Stock	23.34	23.3825	23.2725	23.3675	20769328.0
2014-07-02 16:00:00	AAPL	Stock	23.37	23.41	23.3475	23.3525	4687904.0
2014-07-02 17:00:00	AAPL	Stock	23.355	23.4058	23.3425	23.37	79428.0
2014-07-02 18:00:00	AAPL	Stock	23.355	23.37	23.3525	23.3525	38884.0
2014-07-02 19:00:00	AAPL	Stock	23.355	23.365	23.3375	23.3575	139748.0
2014-07-02 08:00:00	MSFT	Stock	41.75	41.87	41.75	41.86	5731.0
2014-07-02 09:00:00	MSFT	Stock	41.85	41.85	41.58	41.66	3346216.0
2014-07-02 10:00:00	MSFT	Stock	41.66	41.67	41.53	41.56	4379829.0
2014-07-02 11:00:00	MSFT	Stock	41.564	41.77	41.56	41.76	2087078.0
2014-07-02 12:00:00	MSFT	Stock	41.76	41.83	41.75	41.795	1473691.0
2014-07-02 13:00:00	MSFT	Stock	41.79	41.81	41.7	41.755	1205109.0
2014-07-02 14:00:00	MSFT	Stock	41.76	41.85	41.74	41.84	1637979.0
2014-07-02 15:00:00	MSFT	Stock	41.84	41.9	41.78	41.9	3091059.0
2014-07-02 16:00:00	MSFT	Stock	41.9	41.9	41.725	41.9	2026424.0
2014-07-02 17:00:00	MSFT	Stock	41.605	41.908	41.605	41.908	9686.0
2014-07-02 19:00:00	MSFT	Stock	41.87	41.89	41.87	41.89	314.0
2014-07-02 08:00:00	NVDA	Stock	0.4685	0.4685	0.464	0.4648	66000.0
2014-07-02 09:00:00	NVDA	Stock	0.4665	0.4683	0.4655	0.4662	16173160.0
2014-07-02 10:00:00	NVDA	Stock	0.4663	0.469	0.4643	0.4681	36757640.0
2014-07-02 11:00:00	NVDA	Stock	0.468	0.4688	0.4665	0.4669	14395840.0
2014-07-02 12:00:00	NVDA	Stock	0.467	0.4688	0.4665	0.4688	35398400.0
2014-07-02 13:00:00	NVDA	Stock	0.4688	0.4688	0.4668	0.467	6316440.0
2014-07-02 14:00:00	NVDA	Stock	0.467	0.4672	0.4655	0.4665	20203320.0
2014-07-02 15:00:00	NVDA	Stock	0.4665	0.468	0.4665	0.4671	37560960.0
2014-07-02 16:00:00	NVDA	Stock	0.4673	0.468	0.467	0.4673	9412320.0
2014-07-02 17:00:00	NVDA	Stock	0.4674	0.4674	0.4674	0.4674	4400.0
2014-07-02 07:00:00	AMZN	Stock	16.6725	16.6725	16.6725	16.6725	2000.0
2014-07-02 08:00:00	AMZN	Stock	16.656	16.67	16.6	16.655	147220.0
2014-07-02 09:00:00	AMZN	Stock	16.6695	16.838	16.6565	16.799	13535920.0
2014-07-02 10:00:00	AMZN	Stock	16.802	16.828	16.7155	16.7395	7425320.0
2014-07-02 11:00:00	AMZN	Stock	16.7455	16.77	16.583	16.5935	7806540.0
2014-07-02 12:00:00	AMZN	Stock	16.593	16.6724	16.59	16.6495	5558320.0
2014-07-02 13:00:00	AMZN	Stock	16.6475	16.6545	16.619	16.6455	2825980.0
2014-07-02 14:00:00	AMZN	Stock	16.6465	16.649	16.5925	16.6195	3237880.0
2014-07-02 15:00:00	AMZN	Stock	16.6235	16.6593	16.617	16.6425	7319300.0
2014-07-02 16:00:00	AMZN	Stock	16.6425	16.6959	16.6227	16.65	224440.0
2014-07-02 17:00:00	AMZN	Stock	16.7291	16.7291	16.6455	16.6455	45180.0
2014-07-02 18:00:00	AMZN	Stock	16.6455	16.6455	16.6425	16.6425	7200.0
2014-07-02 07:00:00	GOOGL	Stock	29.71	29.71	29.71	29.71	2000.0
2014-07-02 08:00:00	GOOGL	Stock	29.7215	29.7245	29.71	29.7245	29900.0

> showing 50 of 50,531 rows — these rows as CSV

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