PREVIEW / stock_1hour / 2014-02-28

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-02-28.parquet
  size:    1.1 MB
  rows:    48,624
  symbols: 3,536

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-02-28 06:00:00	AAPL	Stock	18.8943	18.9	18.8929	18.8929	16212.0
2014-02-28 07:00:00	AAPL	Stock	18.8929	18.8929	18.8289	18.8346	171640.0
2014-02-28 08:00:00	AAPL	Stock	18.8489	18.8932	18.8304	18.8829	522788.0
2014-02-28 09:00:00	AAPL	Stock	18.8846	18.9954	18.8486	18.9718	46880148.0
2014-02-28 10:00:00	AAPL	Stock	18.9721	19.0268	18.8571	18.8639	48808144.0
2014-02-28 11:00:00	AAPL	Stock	18.8643	18.9279	18.8143	18.9209	28461216.0
2014-02-28 12:00:00	AAPL	Stock	18.9207	18.9214	18.8143	18.838	23131584.0
2014-02-28 13:00:00	AAPL	Stock	18.8361	18.8914	18.6925	18.7371	39271876.0
2014-02-28 14:00:00	AAPL	Stock	18.735	18.7764	18.6864	18.7411	30706172.0
2014-02-28 15:00:00	AAPL	Stock	18.7375	18.8186	18.6471	18.7964	55692308.0
2014-02-28 16:00:00	AAPL	Stock	18.7943	18.8426	18.7276	18.7768	41827212.0
2014-02-28 17:00:00	AAPL	Stock	18.7804	18.7943	18.7764	18.7854	431032.0
2014-02-28 18:00:00	AAPL	Stock	18.7786	18.7846	18.7768	18.7821	47068.0
2014-02-28 19:00:00	AAPL	Stock	18.7775	18.7814	18.7732	18.7732	141708.0
2014-02-28 07:00:00	MSFT	Stock	37.72	37.72	37.71	37.71	700.0
2014-02-28 08:00:00	MSFT	Stock	37.75	37.8	37.75	37.8	1160.0
2014-02-28 09:00:00	MSFT	Stock	37.83	38.23	37.82	38.2	4024677.0
2014-02-28 10:00:00	MSFT	Stock	38.19	38.46	38.18	38.275	5099987.0
2014-02-28 11:00:00	MSFT	Stock	38.27	38.4	38.22	38.369	3267164.0
2014-02-28 12:00:00	MSFT	Stock	38.37	38.395	38.28	38.33	2838221.0
2014-02-28 13:00:00	MSFT	Stock	38.323	38.34	38.18	38.26	3003544.0
2014-02-28 14:00:00	MSFT	Stock	38.25	38.32	38.15	38.19	4289606.0
2014-02-28 15:00:00	MSFT	Stock	38.18	38.32	37.88	38.31	9536110.0
2014-02-28 16:00:00	MSFT	Stock	38.31	38.35	38.066	38.25	7640205.0
2014-02-28 17:00:00	MSFT	Stock	38.18	38.31	38.15	38.15	146634.0
2014-02-28 18:00:00	MSFT	Stock	38.15	38.15	38.15	38.15	443.0
2014-02-28 19:00:00	MSFT	Stock	38.15	38.15	38.15	38.15	1525.0
2014-02-28 09:00:00	NVDA	Stock	0.46	0.4608	0.4528	0.46	53380680.0
2014-02-28 10:00:00	NVDA	Stock	0.46	0.4638	0.4598	0.461	42344040.0
2014-02-28 11:00:00	NVDA	Stock	0.4611	0.4645	0.4598	0.4622	32342400.0
2014-02-28 12:00:00	NVDA	Stock	0.4624	0.4628	0.4603	0.4608	20571520.0
2014-02-28 13:00:00	NVDA	Stock	0.461	0.4622	0.4605	0.461	24189720.0
2014-02-28 14:00:00	NVDA	Stock	0.4608	0.4618	0.4579	0.4593	31060520.0
2014-02-28 15:00:00	NVDA	Stock	0.4593	0.4603	0.456	0.4594	79437320.0
2014-02-28 16:00:00	NVDA	Stock	0.4595	0.46	0.4582	0.4596	28352320.0
2014-02-28 07:00:00	AMZN	Stock	18.01	18.01	18.01	18.01	2000.0
2014-02-28 08:00:00	AMZN	Stock	18.0125	18.0125	17.9785	18.0	33620.0
2014-02-28 09:00:00	AMZN	Stock	17.976	18.2295	17.975	18.155	10736000.0
2014-02-28 10:00:00	AMZN	Stock	18.148	18.2932	18.1405	18.2755	16419860.0
2014-02-28 11:00:00	AMZN	Stock	18.283	18.2875	18.1445	18.2245	7983360.0
2014-02-28 12:00:00	AMZN	Stock	18.237	18.237	18.1425	18.159	4145000.0
2014-02-28 13:00:00	AMZN	Stock	18.157	18.192	18.1325	18.172	4967100.0
2014-02-28 14:00:00	AMZN	Stock	18.1655	18.1735	17.9651	17.988	5851340.0
2014-02-28 15:00:00	AMZN	Stock	18.002	18.119	17.8542	18.105	13826760.0
2014-02-28 16:00:00	AMZN	Stock	18.0915	18.1175	17.9	18.1048	1707180.0
2014-02-28 17:00:00	AMZN	Stock	18.08	18.105	18.038	18.105	65060.0
2014-02-28 18:00:00	AMZN	Stock	18.0225	18.0225	18.0225	18.0225	7000.0
2014-02-28 19:00:00	AMZN	Stock	18.05	18.05	18.04	18.04	14700.0
2014-02-28 04:00:00	META	Stock	69.2	69.25	69.2	69.25	700.0
2014-02-28 05:00:00	META	Stock	69.44	69.45	69.22	69.22	1600.0

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

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