PREVIEW / stock_1hour / 2014-04-21

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-04-21.parquet
  size:    1.0 MB
  rows:    47,919
  symbols: 3,567

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-04-21 07:00:00	AAPL	Stock	18.8021	18.8171	18.7857	18.8036	140728.0
2014-04-21 08:00:00	AAPL	Stock	18.8025	18.8025	18.7607	18.7625	507668.0
2014-04-21 09:00:00	AAPL	Stock	18.7679	18.8743	18.7129	18.8609	32807012.0
2014-04-21 10:00:00	AAPL	Stock	18.8611	18.9243	18.8464	18.87	29078952.0
2014-04-21 11:00:00	AAPL	Stock	18.8704	18.9168	18.8689	18.9064	12031824.0
2014-04-21 12:00:00	AAPL	Stock	18.905	18.9554	18.8968	18.9511	15448300.0
2014-04-21 13:00:00	AAPL	Stock	18.9514	19.0004	18.9471	18.9929	17247832.0
2014-04-21 14:00:00	AAPL	Stock	18.9993	19.005	18.9464	18.9543	10290336.0
2014-04-21 15:00:00	AAPL	Stock	18.9543	18.97	18.9286	18.97	19788944.0
2014-04-21 16:00:00	AAPL	Stock	18.9704	18.9971	18.8827	18.9589	9502864.0
2014-04-21 17:00:00	AAPL	Stock	18.9571	18.9711	18.9571	18.9711	339528.0
2014-04-21 18:00:00	AAPL	Stock	18.9729	18.98	18.9711	18.98	24920.0
2014-04-21 19:00:00	AAPL	Stock	18.9768	18.9821	18.9768	18.9821	84028.0
2014-04-21 07:00:00	MSFT	Stock	40.06	40.06	40.06	40.06	249.0
2014-04-21 08:00:00	MSFT	Stock	40.24	40.24	40.02	40.02	7351.0
2014-04-21 09:00:00	MSFT	Stock	40.06	40.15	39.98	40.06	2524534.0
2014-04-21 10:00:00	MSFT	Stock	40.064	40.15	39.79	39.99	3714914.0
2014-04-21 11:00:00	MSFT	Stock	40.0	40.14	39.97	40.1	2941231.0
2014-04-21 12:00:00	MSFT	Stock	40.11	40.15	40.04	40.1	2051592.0
2014-04-21 13:00:00	MSFT	Stock	40.107	40.12	39.99	40.01	1681093.0
2014-04-21 14:00:00	MSFT	Stock	40.01	40.04	39.92	39.99	2165031.0
2014-04-21 15:00:00	MSFT	Stock	40.0	40.01	39.91	39.92	4308321.0
2014-04-21 16:00:00	MSFT	Stock	39.94	40.015	39.9	39.9	2008882.0
2014-04-21 17:00:00	MSFT	Stock	40.14	40.14	39.91	40.0	10493.0
2014-04-21 18:00:00	MSFT	Stock	39.94	39.99	39.94	39.99	11113.0
2014-04-21 19:00:00	MSFT	Stock	39.99	39.99	39.99	39.99	200.0
2014-04-21 09:00:00	NVDA	Stock	0.4662	0.469	0.4643	0.4658	10949840.0
2014-04-21 10:00:00	NVDA	Stock	0.466	0.468	0.4612	0.4652	29388880.0
2014-04-21 11:00:00	NVDA	Stock	0.4655	0.4669	0.464	0.466	11432920.0
2014-04-21 12:00:00	NVDA	Stock	0.4661	0.4673	0.4655	0.4658	8456760.0
2014-04-21 13:00:00	NVDA	Stock	0.466	0.4664	0.4645	0.4652	6974760.0
2014-04-21 14:00:00	NVDA	Stock	0.4652	0.4671	0.4645	0.4665	9983120.0
2014-04-21 15:00:00	NVDA	Stock	0.4666	0.4678	0.4658	0.4678	28485840.0
2014-04-21 16:00:00	NVDA	Stock	0.4678	0.4678	0.466	0.4678	8422480.0
2014-04-21 07:00:00	AMZN	Stock	16.25	16.25	16.25	16.25	42000.0
2014-04-21 08:00:00	AMZN	Stock	16.2515	16.2515	16.2	16.2055	73180.0
2014-04-21 09:00:00	AMZN	Stock	16.2	16.34	16.1155	16.234	7663320.0
2014-04-21 10:00:00	AMZN	Stock	16.239	16.3685	16.202	16.2492	8559440.0
2014-04-21 11:00:00	AMZN	Stock	16.2625	16.4145	16.235	16.408	4908360.0
2014-04-21 12:00:00	AMZN	Stock	16.4065	16.487	16.3785	16.478	7431460.0
2014-04-21 13:00:00	AMZN	Stock	16.475	16.518	16.4315	16.4925	5062100.0
2014-04-21 14:00:00	AMZN	Stock	16.4975	16.5575	16.4695	16.5005	6110380.0
2014-04-21 15:00:00	AMZN	Stock	16.496	16.5455	16.4515	16.545	11922280.0
2014-04-21 16:00:00	AMZN	Stock	16.5435	16.6515	16.51	16.5468	2940500.0
2014-04-21 17:00:00	AMZN	Stock	16.5435	16.5435	16.5435	16.5435	67220.0
2014-04-21 18:00:00	AMZN	Stock	16.5435	16.625	16.5435	16.625	89580.0
2014-04-21 19:00:00	AMZN	Stock	16.6275	16.6275	16.6	16.6	10000.0
2014-04-21 07:00:00	GOOGL	Stock	27.3375	27.3375	27.3375	27.3375	2000.0
2014-04-21 08:00:00	GOOGL	Stock	27.2995	27.4	27.1	27.17	128660.0
2014-04-21 09:00:00	GOOGL	Stock	27.2145	27.225	26.932	26.9375	5872880.0

> showing 50 of 47,919 rows — these rows as CSV

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