PREVIEW / stock_1hour / 2014-11-11

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-11-11.parquet
  size:    1.0 MB
  rows:    48,759
  symbols: 3,534

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-11-11 04:00:00	AAPL	Stock	27.1875	27.1875	27.1875	27.1875	4840.0
2014-11-11 05:00:00	AAPL	Stock	27.1825	27.1825	27.175	27.175	5600.0
2014-11-11 06:00:00	AAPL	Stock	27.16	27.1825	27.1375	27.1825	25576.0
2014-11-11 07:00:00	AAPL	Stock	27.1825	27.1975	27.165	27.18	43344.0
2014-11-11 08:00:00	AAPL	Stock	27.18	27.215	26.95	27.18	214344.0
2014-11-11 09:00:00	AAPL	Stock	27.18	27.225	27.1	27.13	15022240.0
2014-11-11 10:00:00	AAPL	Stock	27.1325	27.26	27.125	27.2375	16788252.0
2014-11-11 11:00:00	AAPL	Stock	27.2358	27.2375	27.165	27.2025	9956180.0
2014-11-11 12:00:00	AAPL	Stock	27.2025	27.23	27.18	27.2075	7108268.0
2014-11-11 13:00:00	AAPL	Stock	27.2075	27.275	27.1925	27.2702	8546508.0
2014-11-11 14:00:00	AAPL	Stock	27.2725	27.3125	27.24	27.31	13312400.0
2014-11-11 15:00:00	AAPL	Stock	27.3075	27.4375	27.2902	27.425	24947412.0
2014-11-11 16:00:00	AAPL	Stock	27.425	27.45	27.1875	27.4325	5912372.0
2014-11-11 17:00:00	AAPL	Stock	27.44	27.4425	27.2405	27.4325	241868.0
2014-11-11 18:00:00	AAPL	Stock	27.4325	27.48	27.425	27.445	148512.0
2014-11-11 19:00:00	AAPL	Stock	27.445	27.4475	27.425	27.4275	92816.0
2014-11-11 07:00:00	MSFT	Stock	48.88	48.88	48.88	48.88	900.0
2014-11-11 08:00:00	MSFT	Stock	48.88	48.95	48.88	48.94	2174.0
2014-11-11 09:00:00	MSFT	Stock	48.91	48.91	48.645	48.7	2498091.0
2014-11-11 10:00:00	MSFT	Stock	48.71	48.93	48.685	48.85	3050511.0
2014-11-11 11:00:00	MSFT	Stock	48.86	48.9	48.81	48.835	2296711.0
2014-11-11 12:00:00	MSFT	Stock	48.83	48.87	48.78	48.795	1600581.0
2014-11-11 13:00:00	MSFT	Stock	48.798	48.84	48.745	48.79	1821766.0
2014-11-11 14:00:00	MSFT	Stock	48.79	48.84	48.78	48.79	2877762.0
2014-11-11 15:00:00	MSFT	Stock	48.79	48.87	48.77	48.86	5806932.0
2014-11-11 16:00:00	MSFT	Stock	48.87	48.87	48.8	48.8	1297983.0
2014-11-11 17:00:00	MSFT	Stock	48.91	48.91	48.819	48.87	67973.0
2014-11-11 18:00:00	MSFT	Stock	48.87	48.87	48.8	48.8	1211461.0
2014-11-11 19:00:00	MSFT	Stock	48.84	48.84	48.84	48.84	100.0
2014-11-11 09:00:00	NVDA	Stock	0.4975	0.5003	0.493	0.494	43449160.0
2014-11-11 10:00:00	NVDA	Stock	0.4942	0.4968	0.4928	0.4935	36389120.0
2014-11-11 11:00:00	NVDA	Stock	0.4935	0.4938	0.4925	0.4932	13879920.0
2014-11-11 12:00:00	NVDA	Stock	0.493	0.494	0.4928	0.4928	11368880.0
2014-11-11 13:00:00	NVDA	Stock	0.4928	0.494	0.4901	0.4932	20480160.0
2014-11-11 14:00:00	NVDA	Stock	0.4935	0.4948	0.4928	0.4938	24161160.0
2014-11-11 15:00:00	NVDA	Stock	0.494	0.495	0.4935	0.4942	49785000.0
2014-11-11 16:00:00	NVDA	Stock	0.4945	0.4945	0.4942	0.4945	1305240.0
2014-11-11 17:00:00	NVDA	Stock	0.4936	0.4945	0.4936	0.4945	677560.0
2014-11-11 19:00:00	NVDA	Stock	0.4945	0.4945	0.4945	0.4945	20000.0
2014-11-11 07:00:00	AMZN	Stock	15.299	15.2995	15.2985	15.2985	26980.0
2014-11-11 08:00:00	AMZN	Stock	15.2925	15.2925	15.2585	15.2585	64640.0
2014-11-11 09:00:00	AMZN	Stock	15.2675	15.3125	15.1823	15.296	10620540.0
2014-11-11 10:00:00	AMZN	Stock	15.292	15.5435	15.292	15.523	16331760.0
2014-11-11 11:00:00	AMZN	Stock	15.521	15.5226	15.4565	15.4744	6117220.0
2014-11-11 12:00:00	AMZN	Stock	15.4725	15.554	15.457	15.514	5663760.0
2014-11-11 13:00:00	AMZN	Stock	15.513	15.565	15.489	15.536	4809420.0
2014-11-11 14:00:00	AMZN	Stock	15.5385	15.6015	15.523	15.6015	5975480.0
2014-11-11 15:00:00	AMZN	Stock	15.601	15.619	15.5635	15.6015	15954180.0
2014-11-11 16:00:00	AMZN	Stock	15.6005	15.6315	15.4767	15.5825	1398420.0
2014-11-11 17:00:00	AMZN	Stock	15.5825	15.6005	15.5825	15.5975	88540.0

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

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