PREVIEW / stock_1hour / 2014-06-16

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-06-16.parquet
  size:    1.0 MB
  rows:    48,245
  symbols: 3,543

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-06-16 04:00:00	AAPL	Stock	22.85	22.85	22.725	22.82	22148.0
2014-06-16 05:00:00	AAPL	Stock	22.7625	22.825	22.7625	22.825	9464.0
2014-06-16 06:00:00	AAPL	Stock	22.8025	22.8625	22.8025	22.84	25080.0
2014-06-16 07:00:00	AAPL	Stock	22.8625	22.8725	22.8475	22.8625	65268.0
2014-06-16 08:00:00	AAPL	Stock	22.8575	22.925	22.805	22.9125	674900.0
2014-06-16 09:00:00	AAPL	Stock	22.9125	23.0625	22.8625	23.0325	26821120.0
2014-06-16 10:00:00	AAPL	Stock	23.035	23.1875	23.0345	23.12	27664900.0
2014-06-16 11:00:00	AAPL	Stock	23.1175	23.1225	22.935	23.0045	20490796.0
2014-06-16 12:00:00	AAPL	Stock	23.004	23.065	22.9875	23.0197	10780560.0
2014-06-16 13:00:00	AAPL	Stock	23.0175	23.05	22.9275	22.9575	10305672.0
2014-06-16 14:00:00	AAPL	Stock	22.955	23.075	22.95	23.025	11575000.0
2014-06-16 15:00:00	AAPL	Stock	23.0225	23.0625	22.9725	23.0425	16881384.0
2014-06-16 16:00:00	AAPL	Stock	23.05	23.07	23.04	23.0575	5909444.0
2014-06-16 17:00:00	AAPL	Stock	23.0625	23.0875	23.0575	23.0775	75024.0
2014-06-16 18:00:00	AAPL	Stock	23.0825	23.0825	23.0725	23.075	91448.0
2014-06-16 19:00:00	AAPL	Stock	23.075	23.0775	23.0675	23.0675	74784.0
2014-06-16 07:00:00	MSFT	Stock	41.39	41.4	41.38	41.4	1000.0
2014-06-16 08:00:00	MSFT	Stock	41.25	41.25	41.19	41.24	2885.0
2014-06-16 09:00:00	MSFT	Stock	41.24	41.45	41.01	41.448	3316342.0
2014-06-16 10:00:00	MSFT	Stock	41.44	41.597	41.41	41.55	3220368.0
2014-06-16 11:00:00	MSFT	Stock	41.55	41.55	41.16	41.274	2193196.0
2014-06-16 12:00:00	MSFT	Stock	41.27	41.525	41.265	41.4	1647055.0
2014-06-16 13:00:00	MSFT	Stock	41.395	41.55	41.37	41.42	1765034.0
2014-06-16 14:00:00	MSFT	Stock	41.415	41.61	41.38	41.54	2294317.0
2014-06-16 15:00:00	MSFT	Stock	41.53	41.55	41.43	41.49	4982070.0
2014-06-16 16:00:00	MSFT	Stock	41.5	41.51	41.46	41.5	3519658.0
2014-06-16 19:00:00	MSFT	Stock	41.44	41.44	41.44	41.44	152.0
2014-06-16 08:00:00	NVDA	Stock	0.4862	0.4862	0.4862	0.4862	291920.0
2014-06-16 09:00:00	NVDA	Stock	0.4875	0.4883	0.486	0.4875	21543800.0
2014-06-16 10:00:00	NVDA	Stock	0.4875	0.4883	0.4852	0.486	27329440.0
2014-06-16 11:00:00	NVDA	Stock	0.4862	0.4865	0.4828	0.4854	18585760.0
2014-06-16 12:00:00	NVDA	Stock	0.4852	0.4885	0.4852	0.4875	18554520.0
2014-06-16 13:00:00	NVDA	Stock	0.4878	0.4902	0.4875	0.49	25740120.0
2014-06-16 14:00:00	NVDA	Stock	0.49	0.4902	0.4888	0.489	21712160.0
2014-06-16 15:00:00	NVDA	Stock	0.489	0.4892	0.487	0.4872	47297000.0
2014-06-16 16:00:00	NVDA	Stock	0.4878	0.4878	0.4869	0.4872	1118280.0
2014-06-16 17:00:00	NVDA	Stock	0.4869	0.4895	0.4869	0.4895	39480.0
2014-06-16 07:00:00	AMZN	Stock	16.2705	16.2785	16.2	16.25	81860.0
2014-06-16 08:00:00	AMZN	Stock	16.2115	16.27	16.2115	16.254	90800.0
2014-06-16 09:00:00	AMZN	Stock	16.2235	16.4347	16.2235	16.294	7612680.0
2014-06-16 10:00:00	AMZN	Stock	16.2995	16.4145	16.1885	16.215	10572760.0
2014-06-16 11:00:00	AMZN	Stock	16.2155	16.248	16.176	16.2155	4380800.0
2014-06-16 12:00:00	AMZN	Stock	16.211	16.264	16.182	16.2325	4209160.0
2014-06-16 13:00:00	AMZN	Stock	16.2345	16.3295	16.2265	16.288	3258240.0
2014-06-16 14:00:00	AMZN	Stock	16.29	16.3694	16.2855	16.3195	3047280.0
2014-06-16 15:00:00	AMZN	Stock	16.313	16.395	16.275	16.381	7972240.0
2014-06-16 16:00:00	AMZN	Stock	16.381	16.3925	16.3565	16.3565	2095280.0
2014-06-16 17:00:00	AMZN	Stock	16.375	16.375	16.375	16.375	2000.0
2014-06-16 18:00:00	AMZN	Stock	16.4	16.4	16.395	16.395	11960.0
2014-06-16 08:00:00	GOOGL	Stock	27.87	27.8975	27.87	27.8975	40000.0

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

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