PREVIEW / stock_1hour / 2014-09-19

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-09-19.parquet
  size:    1.1 MB
  rows:    49,659
  symbols: 3,582

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-09-19 04:00:00	AAPL	Stock	25.4975	25.59	25.4975	25.5475	37472.0
2014-09-19 05:00:00	AAPL	Stock	25.5475	25.555	25.5	25.5	37332.0
2014-09-19 06:00:00	AAPL	Stock	25.5	25.55	25.4875	25.53	51116.0
2014-09-19 07:00:00	AAPL	Stock	25.535	25.575	25.4875	25.4925	339684.0
2014-09-19 08:00:00	AAPL	Stock	25.5	25.57	25.4475	25.52	802860.0
2014-09-19 09:00:00	AAPL	Stock	25.515	25.5875	25.43	25.4768	72704908.0
2014-09-19 10:00:00	AAPL	Stock	25.4775	25.4875	25.31	25.4425	29890856.0
2014-09-19 11:00:00	AAPL	Stock	25.4425	25.49	25.3502	25.4062	19862156.0
2014-09-19 12:00:00	AAPL	Stock	25.4075	25.437	25.33	25.3825	16827540.0
2014-09-19 13:00:00	AAPL	Stock	25.385	25.4625	25.365	25.4425	16566800.0
2014-09-19 14:00:00	AAPL	Stock	25.4432	25.4975	25.4125	25.49	16941376.0
2014-09-19 15:00:00	AAPL	Stock	25.49	25.51	25.22	25.2425	42746116.0
2014-09-19 16:00:00	AAPL	Stock	25.24	25.4918	25.2325	25.315	51589388.0
2014-09-19 17:00:00	AAPL	Stock	25.315	25.325	25.24	25.315	235848.0
2014-09-19 18:00:00	AAPL	Stock	25.3075	25.4475	25.24	25.325	274980.0
2014-09-19 19:00:00	AAPL	Stock	25.315	25.33	25.275	25.2875	163172.0
2014-09-19 05:00:00	MSFT	Stock	46.81	46.81	46.81	46.81	300.0
2014-09-19 06:00:00	MSFT	Stock	46.81	46.81	46.81	46.81	600.0
2014-09-19 07:00:00	MSFT	Stock	46.68	46.75	46.5	46.7	15216.0
2014-09-19 08:00:00	MSFT	Stock	46.68	46.7	46.66	46.66	4310.0
2014-09-19 09:00:00	MSFT	Stock	46.55	47.19	46.54	47.177	22502962.0
2014-09-19 10:00:00	MSFT	Stock	47.175	47.18	46.74	46.98	6936661.0
2014-09-19 11:00:00	MSFT	Stock	46.98	47.01	46.8	46.85	3732066.0
2014-09-19 12:00:00	MSFT	Stock	46.85	46.87	46.71	46.86	3984007.0
2014-09-19 13:00:00	MSFT	Stock	46.87	46.99	46.82	46.925	3854281.0
2014-09-19 14:00:00	MSFT	Stock	46.92	47.15	46.83	47.03	4494216.0
2014-09-19 15:00:00	MSFT	Stock	47.045	47.57	46.945	47.53	28246672.0
2014-09-19 16:00:00	MSFT	Stock	47.52	47.534	46.944	47.35	124566503.0
2014-09-19 17:00:00	MSFT	Stock	47.33	47.52	47.28	47.33	12694.0
2014-09-19 18:00:00	MSFT	Stock	47.33	47.52	47.28	47.33	42266.0
2014-09-19 19:00:00	MSFT	Stock	47.28	47.33	47.28	47.33	2100.0
2014-09-19 08:00:00	NVDA	Stock	0.4875	0.4875	0.4875	0.4875	8000.0
2014-09-19 09:00:00	NVDA	Stock	0.4875	0.488	0.481	0.4836	71897960.0
2014-09-19 10:00:00	NVDA	Stock	0.4835	0.4848	0.4805	0.482	31858280.0
2014-09-19 11:00:00	NVDA	Stock	0.482	0.483	0.4778	0.479	22137600.0
2014-09-19 12:00:00	NVDA	Stock	0.479	0.4803	0.4768	0.4788	23487400.0
2014-09-19 13:00:00	NVDA	Stock	0.4788	0.4793	0.4775	0.4788	15955960.0
2014-09-19 14:00:00	NVDA	Stock	0.4785	0.4815	0.4782	0.4798	27739680.0
2014-09-19 15:00:00	NVDA	Stock	0.4799	0.4803	0.4763	0.4765	91378680.0
2014-09-19 16:00:00	NVDA	Stock	0.4765	0.4798	0.4765	0.4769	310589440.0
2014-09-19 17:00:00	NVDA	Stock	0.477	0.477	0.477	0.477	249120.0
2014-09-19 19:00:00	NVDA	Stock	0.477	0.477	0.477	0.477	20000.0
2014-09-19 04:00:00	AMZN	Stock	16.379	16.475	16.379	16.475	15200.0
2014-09-19 05:00:00	AMZN	Stock	16.475	16.544	16.475	16.512	15400.0
2014-09-19 06:00:00	AMZN	Stock	16.4	16.415	16.4	16.415	46000.0
2014-09-19 07:00:00	AMZN	Stock	16.3765	16.45	16.3765	16.39	94260.0
2014-09-19 08:00:00	AMZN	Stock	16.4	16.435	16.35	16.3775	177480.0
2014-09-19 09:00:00	AMZN	Stock	16.375	16.594	16.2785	16.529	32317960.0
2014-09-19 10:00:00	AMZN	Stock	16.5275	16.6378	16.5175	16.5435	17228600.0
2014-09-19 11:00:00	AMZN	Stock	16.5405	16.609	16.445	16.5175	9245260.0

> showing 50 of 49,659 rows — these rows as CSV

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