PREVIEW / stock_1hour / 2013-10-30

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-10-30.parquet
  size:    1020 KB
  rows:    47,035
  symbols: 3,535

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-10-30 04:00:00	AAPL	Stock	18.5679	18.5679	18.5679	18.5679	6440.0
2013-10-30 05:00:00	AAPL	Stock	18.5625	18.5625	18.5321	18.5625	50372.0
2013-10-30 06:00:00	AAPL	Stock	18.5761	18.5786	18.5411	18.575	156072.0
2013-10-30 07:00:00	AAPL	Stock	18.5714	18.6	18.5179	18.5396	747068.0
2013-10-30 08:00:00	AAPL	Stock	18.5429	18.5893	18.5271	18.5707	2808652.0
2013-10-30 09:00:00	AAPL	Stock	18.5679	18.7282	18.465	18.7075	69676460.0
2013-10-30 10:00:00	AAPL	Stock	18.7093	18.8282	18.6093	18.8125	75380368.0
2013-10-30 11:00:00	AAPL	Stock	18.81	18.84	18.7043	18.7454	43356656.0
2013-10-30 12:00:00	AAPL	Stock	18.745	18.7818	18.6964	18.7696	29360016.0
2013-10-30 13:00:00	AAPL	Stock	18.7704	18.7818	18.7107	18.7343	17990168.0
2013-10-30 14:00:00	AAPL	Stock	18.7429	18.8036	18.5975	18.71	51502640.0
2013-10-30 15:00:00	AAPL	Stock	18.7079	18.7639	18.6482	18.7457	40122908.0
2013-10-30 16:00:00	AAPL	Stock	18.7479	18.7954	18.4909	18.7729	9885540.0
2013-10-30 17:00:00	AAPL	Stock	18.7696	18.7718	18.7196	18.7321	972804.0
2013-10-30 18:00:00	AAPL	Stock	18.7225	18.7357	18.6807	18.6875	343000.0
2013-10-30 19:00:00	AAPL	Stock	18.6789	18.7479	18.6607	18.6786	948332.0
2013-10-30 05:00:00	MSFT	Stock	35.68	35.68	35.68	35.68	200.0
2013-10-30 07:00:00	MSFT	Stock	35.68	35.71	35.67	35.67	10200.0
2013-10-30 08:00:00	MSFT	Stock	35.68	35.68	35.52	35.6	16545.0
2013-10-30 09:00:00	MSFT	Stock	35.6	35.69	35.52	35.65	4030962.0
2013-10-30 10:00:00	MSFT	Stock	35.64	35.79	35.58	35.695	4494947.0
2013-10-30 11:00:00	MSFT	Stock	35.695	35.74	35.49	35.555	4619082.0
2013-10-30 12:00:00	MSFT	Stock	35.56	35.689	35.55	35.68	3952237.0
2013-10-30 13:00:00	MSFT	Stock	35.67	35.69	35.59	35.67	2197666.0
2013-10-30 14:00:00	MSFT	Stock	35.665	35.78	35.43	35.6	5251728.0
2013-10-30 15:00:00	MSFT	Stock	35.6	35.73	35.525	35.55	7832978.0
2013-10-30 16:00:00	MSFT	Stock	35.54	35.64	35.533	35.56	2289456.0
2013-10-30 17:00:00	MSFT	Stock	35.52	35.53	35.52	35.53	2200.0
2013-10-30 18:00:00	MSFT	Stock	35.54	35.54	35.47	35.47	2968.0
2013-10-30 09:00:00	NVDA	Stock	0.3818	0.3838	0.3808	0.3822	30458360.0
2013-10-30 10:00:00	NVDA	Stock	0.3822	0.3833	0.3815	0.3821	34570880.0
2013-10-30 11:00:00	NVDA	Stock	0.3821	0.3822	0.38	0.3805	14871280.0
2013-10-30 12:00:00	NVDA	Stock	0.3805	0.3815	0.3789	0.3815	20066560.0
2013-10-30 13:00:00	NVDA	Stock	0.3815	0.3818	0.38	0.38	15800680.0
2013-10-30 14:00:00	NVDA	Stock	0.3801	0.381	0.3773	0.3786	44702720.0
2013-10-30 15:00:00	NVDA	Stock	0.3788	0.3813	0.3785	0.3805	37128120.0
2013-10-30 16:00:00	NVDA	Stock	0.3805	0.3813	0.3786	0.3808	4816000.0
2013-10-30 17:00:00	NVDA	Stock	0.3808	0.3808	0.3808	0.3808	16000.0
2013-10-30 06:00:00	AMZN	Stock	18.175	18.2	18.175	18.2	8000.0
2013-10-30 07:00:00	AMZN	Stock	18.1845	18.1845	18.1845	18.1845	2000.0
2013-10-30 08:00:00	AMZN	Stock	18.1425	18.1615	18.1425	18.149	126320.0
2013-10-30 09:00:00	AMZN	Stock	18.1375	18.25	18.0535	18.2105	44112940.0
2013-10-30 10:00:00	AMZN	Stock	18.2135	18.219	17.9325	18.12	12089280.0
2013-10-30 11:00:00	AMZN	Stock	18.1088	18.2415	18.071	18.112	8920200.0
2013-10-30 12:00:00	AMZN	Stock	18.123	18.1765	18.07	18.1252	3563500.0
2013-10-30 13:00:00	AMZN	Stock	18.125	18.1455	18.0205	18.0335	2706800.0
2013-10-30 14:00:00	AMZN	Stock	18.047	18.1385	17.944	18.0265	7004140.0
2013-10-30 15:00:00	AMZN	Stock	18.02	18.1215	18.003	18.0535	8094700.0
2013-10-30 16:00:00	AMZN	Stock	18.054	18.125	18.0503	18.0929	1999820.0
2013-10-30 17:00:00	AMZN	Stock	18.054	18.1	17.995	17.995	77160.0

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

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