PREVIEW / stock_1hour / 2015-02-13

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-02-13.parquet
  size:    1.0 MB
  rows:    48,841
  symbols: 3,525

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
2015-02-13 04:00:00	AAPL	Stock	31.59	31.79	31.59	31.7575	127972.0
2015-02-13 05:00:00	AAPL	Stock	31.7675	31.825	31.7525	31.775	72252.0
2015-02-13 06:00:00	AAPL	Stock	31.775	31.825	31.74	31.7725	115888.0
2015-02-13 07:00:00	AAPL	Stock	31.77	31.8	31.7275	31.7325	252000.0
2015-02-13 08:00:00	AAPL	Stock	31.745	31.8125	31.55	31.77	1193112.0
2015-02-13 09:00:00	AAPL	Stock	31.7725	31.8275	31.57	31.6512	34628776.0
2015-02-13 10:00:00	AAPL	Stock	31.655	31.6975	31.4125	31.52	41182524.0
2015-02-13 11:00:00	AAPL	Stock	31.52	31.5775	31.4525	31.5625	19453740.0
2015-02-13 12:00:00	AAPL	Stock	31.5625	31.585	31.505	31.5425	12148136.0
2015-02-13 13:00:00	AAPL	Stock	31.54	31.6262	31.415	31.4875	19711108.0
2015-02-13 14:00:00	AAPL	Stock	31.485	31.5775	31.45	31.565	14228052.0
2015-02-13 15:00:00	AAPL	Stock	31.565	31.8075	31.56	31.77	46320568.0
2015-02-13 16:00:00	AAPL	Stock	31.77	31.77	31.5188	31.755	8093256.0
2015-02-13 17:00:00	AAPL	Stock	31.5488	31.7875	31.5488	31.78	982416.0
2015-02-13 18:00:00	AAPL	Stock	31.78	31.8	31.775	31.795	283948.0
2015-02-13 19:00:00	AAPL	Stock	31.7925	31.8075	31.77	31.8075	420604.0
2015-02-13 06:00:00	MSFT	Stock	43.19	43.19	43.18	43.19	2586.0
2015-02-13 07:00:00	MSFT	Stock	43.18	43.18	43.18	43.18	450.0
2015-02-13 08:00:00	MSFT	Stock	43.17	43.27	43.13	43.24	17142.0
2015-02-13 09:00:00	MSFT	Stock	43.22	43.44	43.15	43.28	4355524.0
2015-02-13 10:00:00	MSFT	Stock	43.27	43.44	43.17	43.285	8270797.0
2015-02-13 11:00:00	MSFT	Stock	43.285	43.49	43.28	43.462	4460993.0
2015-02-13 12:00:00	MSFT	Stock	43.467	43.66	43.46	43.61	3144899.0
2015-02-13 13:00:00	MSFT	Stock	43.61	43.7	43.55	43.565	4013600.0
2015-02-13 14:00:00	MSFT	Stock	43.57	43.65	43.56	43.625	3462549.0
2015-02-13 15:00:00	MSFT	Stock	43.625	43.87	43.62	43.86	7248683.0
2015-02-13 16:00:00	MSFT	Stock	43.87	43.87	43.283	43.7	2427403.0
2015-02-13 17:00:00	MSFT	Stock	43.74	43.83	43.71	43.83	39780.0
2015-02-13 18:00:00	MSFT	Stock	43.83	43.86	43.82	43.86	7118.0
2015-02-13 19:00:00	MSFT	Stock	43.86	43.87	43.86	43.87	72027.0
2015-02-13 07:00:00	NVDA	Stock	0.5568	0.5568	0.5568	0.5568	12000.0
2015-02-13 08:00:00	NVDA	Stock	0.553	0.5582	0.55	0.5575	100000.0
2015-02-13 09:00:00	NVDA	Stock	0.555	0.5585	0.551	0.5552	46995560.0
2015-02-13 10:00:00	NVDA	Stock	0.5555	0.5565	0.55	0.5509	42260640.0
2015-02-13 11:00:00	NVDA	Stock	0.5509	0.552	0.5478	0.5516	35527000.0
2015-02-13 12:00:00	NVDA	Stock	0.5516	0.5538	0.551	0.5519	19197760.0
2015-02-13 13:00:00	NVDA	Stock	0.5519	0.554	0.5518	0.554	24879000.0
2015-02-13 14:00:00	NVDA	Stock	0.5538	0.5555	0.5528	0.553	33787600.0
2015-02-13 15:00:00	NVDA	Stock	0.5531	0.5578	0.553	0.5576	76007200.0
2015-02-13 16:00:00	NVDA	Stock	0.5578	0.5578	0.5527	0.5527	6603440.0
2015-02-13 17:00:00	NVDA	Stock	0.5555	0.5555	0.5555	0.5555	12000.0
2015-02-13 05:00:00	AMZN	Stock	18.8445	18.8445	18.8425	18.8425	8700.0
2015-02-13 07:00:00	AMZN	Stock	18.818	18.8255	18.818	18.8255	4000.0
2015-02-13 08:00:00	AMZN	Stock	18.775	18.85	18.775	18.85	46700.0
2015-02-13 09:00:00	AMZN	Stock	18.8495	19.073	18.828	19.0495	12794660.0
2015-02-13 10:00:00	AMZN	Stock	19.044	19.104	18.9755	19.066	13035060.0
2015-02-13 11:00:00	AMZN	Stock	19.066	19.1125	19.02	19.088	6840820.0
2015-02-13 12:00:00	AMZN	Stock	19.085	19.15	19.066	19.122	7558040.0
2015-02-13 13:00:00	AMZN	Stock	19.124	19.137	18.991	19.0325	7833700.0
2015-02-13 14:00:00	AMZN	Stock	19.027	19.087	19.009	19.033	4541620.0

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

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