PREVIEW / stock_1hour / 2014-10-28

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-10-28.parquet
  size:    1.0 MB
  rows:    48,743
  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
2014-10-28 04:00:00	AAPL	Stock	26.1725	26.4425	26.1725	26.4425	41360.0
2014-10-28 05:00:00	AAPL	Stock	26.4	26.43	26.4	26.43	28432.0
2014-10-28 06:00:00	AAPL	Stock	26.43	26.43	26.4	26.425	58772.0
2014-10-28 07:00:00	AAPL	Stock	26.4225	26.425	26.375	26.3975	189508.0
2014-10-28 08:00:00	AAPL	Stock	26.4	26.4225	26.1725	26.375	752064.0
2014-10-28 09:00:00	AAPL	Stock	26.38	26.5425	26.33	26.5222	27507932.0
2014-10-28 10:00:00	AAPL	Stock	26.52	26.575	26.465	26.57	27662036.0
2014-10-28 11:00:00	AAPL	Stock	26.5738	26.5925	26.545	26.56	17942788.0
2014-10-28 12:00:00	AAPL	Stock	26.56	26.615	26.5525	26.6065	13040760.0
2014-10-28 13:00:00	AAPL	Stock	26.6075	26.6575	26.6038	26.6462	15607212.0
2014-10-28 14:00:00	AAPL	Stock	26.6462	26.6588	26.605	26.6375	16795044.0
2014-10-28 15:00:00	AAPL	Stock	26.6375	26.68	26.615	26.6775	28514376.0
2014-10-28 16:00:00	AAPL	Stock	26.685	26.6875	26.5745	26.6875	1742072.0
2014-10-28 17:00:00	AAPL	Stock	26.68	26.6875	26.59	26.5925	5913948.0
2014-10-28 18:00:00	AAPL	Stock	26.5975	26.65	26.5025	26.5875	423924.0
2014-10-28 19:00:00	AAPL	Stock	26.5875	26.6225	26.5875	26.6225	216756.0
2014-10-28 04:00:00	MSFT	Stock	46.1	46.1	46.1	46.1	730.0
2014-10-28 05:00:00	MSFT	Stock	46.08	46.15	46.08	46.15	800.0
2014-10-28 06:00:00	MSFT	Stock	46.08	46.08	46.08	46.08	1000.0
2014-10-28 07:00:00	MSFT	Stock	46.09	46.1	46.09	46.1	800.0
2014-10-28 08:00:00	MSFT	Stock	46.19	46.19	46.01	46.05	7997.0
2014-10-28 09:00:00	MSFT	Stock	46.04	46.19	45.86	46.06	2829951.0
2014-10-28 10:00:00	MSFT	Stock	46.05	46.07	45.77	45.99	4149879.0
2014-10-28 11:00:00	MSFT	Stock	45.99	46.05	45.95	45.98	2229519.0
2014-10-28 12:00:00	MSFT	Stock	45.98	45.99	45.9	45.94	1682359.0
2014-10-28 13:00:00	MSFT	Stock	45.94	46.1	45.935	46.09	3013730.0
2014-10-28 14:00:00	MSFT	Stock	46.085	46.3	46.06	46.27	3551206.0
2014-10-28 15:00:00	MSFT	Stock	46.275	46.5	46.27	46.49	6946670.0
2014-10-28 16:00:00	MSFT	Stock	46.45	46.53	45.955	46.49	467806.0
2014-10-28 17:00:00	MSFT	Stock	46.5	46.5	46.35	46.35	416600.0
2014-10-28 18:00:00	MSFT	Stock	46.29	46.49	46.16	46.17	27844.0
2014-10-28 19:00:00	MSFT	Stock	46.27	46.34	46.26	46.28	3881.0
2014-10-28 09:00:00	NVDA	Stock	0.461	0.4668	0.4605	0.4638	16097680.0
2014-10-28 10:00:00	NVDA	Stock	0.464	0.4659	0.464	0.4643	17196680.0
2014-10-28 11:00:00	NVDA	Stock	0.4645	0.4683	0.464	0.4683	34923520.0
2014-10-28 12:00:00	NVDA	Stock	0.4683	0.469	0.4645	0.4658	17374520.0
2014-10-28 13:00:00	NVDA	Stock	0.466	0.471	0.4658	0.4708	22299800.0
2014-10-28 14:00:00	NVDA	Stock	0.4708	0.4718	0.4692	0.4713	17264120.0
2014-10-28 15:00:00	NVDA	Stock	0.4713	0.4739	0.471	0.4732	53711000.0
2014-10-28 16:00:00	NVDA	Stock	0.4732	0.4732	0.473	0.4732	2625840.0
2014-10-28 04:00:00	AMZN	Stock	14.5005	14.503	14.5005	14.503	4020.0
2014-10-28 05:00:00	AMZN	Stock	14.5185	14.5365	14.513	14.535	76000.0
2014-10-28 06:00:00	AMZN	Stock	14.5775	14.5775	14.5495	14.55	35120.0
2014-10-28 07:00:00	AMZN	Stock	14.56	14.575	14.56	14.56	21480.0
2014-10-28 08:00:00	AMZN	Stock	14.5605	14.5605	14.4985	14.5	360500.0
2014-10-28 09:00:00	AMZN	Stock	14.5	14.708	14.475	14.676	14823060.0
2014-10-28 10:00:00	AMZN	Stock	14.68	14.8235	14.675	14.8175	19643080.0
2014-10-28 11:00:00	AMZN	Stock	14.8195	14.9	14.8114	14.8195	13457000.0
2014-10-28 12:00:00	AMZN	Stock	14.82	14.8342	14.7815	14.7815	9623000.0
2014-10-28 13:00:00	AMZN	Stock	14.7815	14.8585	14.763	14.855	7669460.0

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

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