PREVIEW / stock_1hour / 2013-11-18

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-11-18.parquet
  size:    1.0 MB
  rows:    47,694
  symbols: 3,557

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-11-18 04:00:00	AAPL	Stock	18.7496	18.7804	18.7496	18.7804	21700.0
2013-11-18 05:00:00	AAPL	Stock	18.7986	18.8011	18.7929	18.8011	11200.0
2013-11-18 06:00:00	AAPL	Stock	18.7875	18.8175	18.7143	18.7143	250152.0
2013-11-18 07:00:00	AAPL	Stock	18.7679	18.8368	18.7679	18.8143	365148.0
2013-11-18 08:00:00	AAPL	Stock	18.8036	18.8357	18.7143	18.795	1702120.0
2013-11-18 09:00:00	AAPL	Stock	18.7893	18.8282	18.6539	18.6679	38102120.0
2013-11-18 10:00:00	AAPL	Stock	18.668	18.6996	18.645	18.6785	37052260.0
2013-11-18 11:00:00	AAPL	Stock	18.6786	18.7207	18.6564	18.6786	35409752.0
2013-11-18 12:00:00	AAPL	Stock	18.6786	18.7346	18.6686	18.6946	16695728.0
2013-11-18 13:00:00	AAPL	Stock	18.6959	18.7179	18.6714	18.6861	9149252.0
2013-11-18 14:00:00	AAPL	Stock	18.6861	18.75	18.6789	18.6818	18981704.0
2013-11-18 15:00:00	AAPL	Stock	18.685	18.6932	18.5071	18.5232	65067688.0
2013-11-18 16:00:00	AAPL	Stock	18.5259	18.6836	18.5043	18.5268	18462360.0
2013-11-18 17:00:00	AAPL	Stock	18.5236	18.5264	18.5125	18.5204	547736.0
2013-11-18 18:00:00	AAPL	Stock	18.5221	18.5246	18.5107	18.5143	191492.0
2013-11-18 19:00:00	AAPL	Stock	18.5118	18.5282	18.51	18.5268	312788.0
2013-11-18 05:00:00	MSFT	Stock	38.05	38.05	38.05	38.05	150.0
2013-11-18 06:00:00	MSFT	Stock	37.85	37.85	37.37	37.37	28100.0
2013-11-18 07:00:00	MSFT	Stock	37.4	37.44	37.25	37.28	29335.0
2013-11-18 08:00:00	MSFT	Stock	37.3	37.44	37.17	37.28	283241.0
2013-11-18 09:00:00	MSFT	Stock	37.28	37.58	37.22	37.42	9490671.0
2013-11-18 10:00:00	MSFT	Stock	37.42	37.46	37.26	37.363	7757720.0
2013-11-18 11:00:00	MSFT	Stock	37.37	37.43	37.28	37.308	4571262.0
2013-11-18 12:00:00	MSFT	Stock	37.31	37.44	37.28	37.37	3748467.0
2013-11-18 13:00:00	MSFT	Stock	37.38	37.43	37.34	37.391	2574436.0
2013-11-18 14:00:00	MSFT	Stock	37.4	37.42	37.26	37.34	4264975.0
2013-11-18 15:00:00	MSFT	Stock	37.335	37.35	37.07	37.2	14100707.0
2013-11-18 16:00:00	MSFT	Stock	37.2	37.94	37.12	37.18	2679647.0
2013-11-18 17:00:00	MSFT	Stock	37.16	37.2	37.15	37.15	25399.0
2013-11-18 18:00:00	MSFT	Stock	37.15	37.2	37.15	37.15	2579.0
2013-11-18 19:00:00	MSFT	Stock	37.19	37.24	37.19	37.24	3659.0
2013-11-18 07:00:00	NVDA	Stock	0.3968	0.397	0.3928	0.397	168000.0
2013-11-18 08:00:00	NVDA	Stock	0.397	0.3985	0.3953	0.3958	1556000.0
2013-11-18 09:00:00	NVDA	Stock	0.3958	0.398	0.3948	0.3955	70353560.0
2013-11-18 10:00:00	NVDA	Stock	0.3958	0.3976	0.3953	0.3975	45606200.0
2013-11-18 11:00:00	NVDA	Stock	0.3973	0.399	0.3962	0.3968	27493480.0
2013-11-18 12:00:00	NVDA	Stock	0.3968	0.397	0.3955	0.3966	26244240.0
2013-11-18 13:00:00	NVDA	Stock	0.3966	0.3968	0.3958	0.3961	18536920.0
2013-11-18 14:00:00	NVDA	Stock	0.396	0.3975	0.3955	0.3956	32510880.0
2013-11-18 15:00:00	NVDA	Stock	0.3956	0.396	0.3935	0.3945	83914960.0
2013-11-18 16:00:00	NVDA	Stock	0.3945	0.3945	0.3935	0.3942	9613120.0
2013-11-18 17:00:00	NVDA	Stock	0.3945	0.3945	0.3945	0.3945	6000.0
2013-11-18 18:00:00	NVDA	Stock	0.3945	0.3945	0.3945	0.3945	12000.0
2013-11-18 19:00:00	NVDA	Stock	0.3945	0.3945	0.3945	0.3945	28000.0
2013-11-18 04:00:00	AMZN	Stock	18.4815	18.4815	18.4515	18.4515	6000.0
2013-11-18 05:00:00	AMZN	Stock	18.475	18.51	18.4565	18.51	8000.0
2013-11-18 06:00:00	AMZN	Stock	18.497	18.5015	18.497	18.5015	4000.0
2013-11-18 07:00:00	AMZN	Stock	18.4625	18.5125	18.4625	18.5055	71980.0
2013-11-18 08:00:00	AMZN	Stock	18.4995	18.539	18.4585	18.5105	531820.0
2013-11-18 09:00:00	AMZN	Stock	18.5185	18.6745	18.4335	18.439	10437080.0

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

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