PREVIEW / stock_1hour / 2014-10-30

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-10-30.parquet
  size:    1.0 MB
  rows:    48,210
  symbols: 3,554

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-10-30 04:00:00	AAPL	Stock	26.8	26.85	26.775	26.775	56520.0
2014-10-30 05:00:00	AAPL	Stock	26.775	26.775	26.665	26.69	43248.0
2014-10-30 06:00:00	AAPL	Stock	26.68	26.71	26.65	26.65	84760.0
2014-10-30 07:00:00	AAPL	Stock	26.6475	26.6875	26.6	26.6725	305332.0
2014-10-30 08:00:00	AAPL	Stock	26.6625	26.835	26.61	26.7325	680304.0
2014-10-30 09:00:00	AAPL	Stock	26.7325	26.8225	26.69	26.74	17696252.0
2014-10-30 10:00:00	AAPL	Stock	26.74	26.755	26.475	26.57	33850656.0
2014-10-30 11:00:00	AAPL	Stock	26.57	26.6425	26.5625	26.6118	16576576.0
2014-10-30 12:00:00	AAPL	Stock	26.615	26.7575	26.6	26.755	14984908.0
2014-10-30 13:00:00	AAPL	Stock	26.7528	26.8375	26.7075	26.79	15956648.0
2014-10-30 14:00:00	AAPL	Stock	26.79	26.8	26.635	26.6562	14296344.0
2014-10-30 15:00:00	AAPL	Stock	26.656	26.745	26.625	26.745	21586968.0
2014-10-30 16:00:00	AAPL	Stock	26.745	26.745	26.6045	26.7125	17245328.0
2014-10-30 17:00:00	AAPL	Stock	26.715	26.745	26.715	26.7325	66588.0
2014-10-30 18:00:00	AAPL	Stock	26.73	26.755	26.705	26.7325	192332.0
2014-10-30 19:00:00	AAPL	Stock	26.755	26.775	26.7375	26.775	86140.0
2014-10-30 05:00:00	MSFT	Stock	46.42	46.42	46.42	46.42	500.0
2014-10-30 07:00:00	MSFT	Stock	46.26	46.26	46.25	46.25	1400.0
2014-10-30 08:00:00	MSFT	Stock	46.29	46.41	46.29	46.3	8056.0
2014-10-30 09:00:00	MSFT	Stock	46.35	46.4	45.925	45.95	2789456.0
2014-10-30 10:00:00	MSFT	Stock	45.95	46.11	45.79	46.09	3865448.0
2014-10-30 11:00:00	MSFT	Stock	46.09	46.2	45.97	45.99	3253472.0
2014-10-30 12:00:00	MSFT	Stock	45.995	46.0	45.77	45.935	2929429.0
2014-10-30 13:00:00	MSFT	Stock	45.935	46.27	45.93	46.11	4709687.0
2014-10-30 14:00:00	MSFT	Stock	46.12	46.16	45.92	45.94	2706224.0
2014-10-30 15:00:00	MSFT	Stock	45.94	46.06	45.83	46.05	6314112.0
2014-10-30 16:00:00	MSFT	Stock	46.05	46.07	45.999	46.0	2368372.0
2014-10-30 17:00:00	MSFT	Stock	46.05	46.07	46.05	46.05	19090.0
2014-10-30 18:00:00	MSFT	Stock	45.98	46.05	45.7	46.0	25179.0
2014-10-30 19:00:00	MSFT	Stock	45.95	46.07	45.95	46.07	7200.0
2014-10-30 09:00:00	NVDA	Stock	0.469	0.471	0.4629	0.4635	21463920.0
2014-10-30 10:00:00	NVDA	Stock	0.4633	0.4675	0.4612	0.464	30109000.0
2014-10-30 11:00:00	NVDA	Stock	0.464	0.4652	0.4612	0.465	16355600.0
2014-10-30 12:00:00	NVDA	Stock	0.465	0.4662	0.4638	0.4645	11132560.0
2014-10-30 13:00:00	NVDA	Stock	0.4645	0.47	0.4645	0.4692	13675360.0
2014-10-30 14:00:00	NVDA	Stock	0.4692	0.4705	0.4652	0.4659	13199480.0
2014-10-30 15:00:00	NVDA	Stock	0.4658	0.468	0.4652	0.4675	50815320.0
2014-10-30 16:00:00	NVDA	Stock	0.4673	0.4673	0.4673	0.4673	10099920.0
2014-10-30 05:00:00	AMZN	Stock	14.646	14.666	14.646	14.666	18000.0
2014-10-30 06:00:00	AMZN	Stock	14.6465	14.648	14.6375	14.6375	36000.0
2014-10-30 07:00:00	AMZN	Stock	14.6225	14.625	14.585	14.625	57380.0
2014-10-30 08:00:00	AMZN	Stock	14.6325	14.675	14.625	14.655	207540.0
2014-10-30 09:00:00	AMZN	Stock	14.66	14.792	14.618	14.635	8555600.0
2014-10-30 10:00:00	AMZN	Stock	14.629	14.8715	14.619	14.87	14405540.0
2014-10-30 11:00:00	AMZN	Stock	14.8685	14.975	14.8415	14.884	14035160.0
2014-10-30 12:00:00	AMZN	Stock	14.8835	14.9105	14.8515	14.859	7985500.0
2014-10-30 13:00:00	AMZN	Stock	14.8626	14.987	14.852	14.964	9541820.0
2014-10-30 14:00:00	AMZN	Stock	14.971	14.985	14.8705	14.893	6502880.0
2014-10-30 15:00:00	AMZN	Stock	14.8955	14.968	14.8615	14.9535	11908100.0
2014-10-30 16:00:00	AMZN	Stock	14.953	14.9565	14.8538	14.9025	301080.0

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

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