PREVIEW / stock_1hour / 2013-04-02

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-04-02.parquet
  size:    985 KB
  rows:    45,780
  symbols: 3,473

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
2013-04-02 04:00:00	AAPL	Stock	15.295	15.295	15.2107	15.2429	66220.0
2013-04-02 05:00:00	AAPL	Stock	15.2504	15.3154	15.2504	15.3154	23744.0
2013-04-02 06:00:00	AAPL	Stock	15.2911	15.3143	15.2804	15.3143	114100.0
2013-04-02 07:00:00	AAPL	Stock	15.3143	15.4196	15.3143	15.3554	1142820.0
2013-04-02 08:00:00	AAPL	Stock	15.3454	15.4143	15.2357	15.2789	4073132.0
2013-04-02 09:00:00	AAPL	Stock	15.2768	15.5604	15.2232	15.5282	103993960.0
2013-04-02 10:00:00	AAPL	Stock	15.5246	15.5957	15.4961	15.5704	87816428.0
2013-04-02 11:00:00	AAPL	Stock	15.5732	15.6304	15.5189	15.5493	46034632.0
2013-04-02 12:00:00	AAPL	Stock	15.5493	15.6146	15.5425	15.5979	30939832.0
2013-04-02 13:00:00	AAPL	Stock	15.5989	15.6479	15.3939	15.4254	75145336.0
2013-04-02 14:00:00	AAPL	Stock	15.4218	15.4392	15.2396	15.3214	88745104.0
2013-04-02 15:00:00	AAPL	Stock	15.3239	15.3729	15.2768	15.3532	70201292.0
2013-04-02 16:00:00	AAPL	Stock	15.3532	15.5868	15.3254	15.3446	14983332.0
2013-04-02 17:00:00	AAPL	Stock	15.3464	15.5715	15.3393	15.3625	485716.0
2013-04-02 18:00:00	AAPL	Stock	15.3714	15.3836	15.3679	15.3711	226324.0
2013-04-02 19:00:00	AAPL	Stock	15.3654	15.3764	15.3625	15.3764	146524.0
2013-04-02 05:00:00	MSFT	Stock	28.65	28.67	28.65	28.67	850.0
2013-04-02 07:00:00	MSFT	Stock	28.67	28.67	28.67	28.67	259.0
2013-04-02 08:00:00	MSFT	Stock	28.67	28.67	28.56	28.62	23728.0
2013-04-02 09:00:00	MSFT	Stock	28.64	28.74	28.52	28.725	3872809.0
2013-04-02 10:00:00	MSFT	Stock	28.73	28.85	28.7	28.805	5753489.0
2013-04-02 11:00:00	MSFT	Stock	28.81	28.85	28.75	28.78	2529972.0
2013-04-02 12:00:00	MSFT	Stock	28.772	28.8	28.76	28.783	1668244.0
2013-04-02 13:00:00	MSFT	Stock	28.785	28.8	28.75	28.76	2336147.0
2013-04-02 14:00:00	MSFT	Stock	28.76	28.77	28.67	28.715	2933182.0
2013-04-02 15:00:00	MSFT	Stock	28.716	28.8	28.7	28.8	6895198.0
2013-04-02 16:00:00	MSFT	Stock	28.8	28.82	28.563	28.75	2014256.0
2013-04-02 17:00:00	MSFT	Stock	28.75	28.8	28.75	28.8	139000.0
2013-04-02 18:00:00	MSFT	Stock	28.79	28.79	28.75	28.75	1490.0
2013-04-02 19:00:00	MSFT	Stock	28.75	28.77	28.75	28.75	3179.0
2013-04-02 08:00:00	NVDA	Stock	0.311	0.3115	0.311	0.3115	155400.0
2013-04-02 09:00:00	NVDA	Stock	0.311	0.3113	0.3085	0.3093	39130920.0
2013-04-02 10:00:00	NVDA	Stock	0.3093	0.311	0.3073	0.308	90983120.0
2013-04-02 11:00:00	NVDA	Stock	0.308	0.3085	0.3075	0.3083	38025000.0
2013-04-02 12:00:00	NVDA	Stock	0.3081	0.3088	0.3062	0.3066	36836200.0
2013-04-02 13:00:00	NVDA	Stock	0.3065	0.3075	0.3062	0.3075	30718320.0
2013-04-02 14:00:00	NVDA	Stock	0.3074	0.3075	0.305	0.3058	35026560.0
2013-04-02 15:00:00	NVDA	Stock	0.3058	0.307	0.305	0.307	85114200.0
2013-04-02 16:00:00	NVDA	Stock	0.3065	0.3075	0.3062	0.3062	6522840.0
2013-04-02 17:00:00	NVDA	Stock	0.3069	0.307	0.3068	0.3068	362480.0
2013-04-02 19:00:00	NVDA	Stock	0.3075	0.3075	0.3075	0.3075	4000.0
2013-04-02 05:00:00	AMZN	Stock	13.1575	13.1575	13.1575	13.1575	2000.0
2013-04-02 06:00:00	AMZN	Stock	13.175	13.175	13.1725	13.1725	6000.0
2013-04-02 07:00:00	AMZN	Stock	13.1695	13.2	13.1625	13.1625	22000.0
2013-04-02 08:00:00	AMZN	Stock	13.1945	13.1945	13.0805	13.0805	119240.0
2013-04-02 09:00:00	AMZN	Stock	13.16	13.1875	13.0275	13.052	11838100.0
2013-04-02 10:00:00	AMZN	Stock	13.0528	13.1845	13.047	13.183	8308820.0
2013-04-02 11:00:00	AMZN	Stock	13.181	13.2945	13.1765	13.2229	10182480.0
2013-04-02 12:00:00	AMZN	Stock	13.2255	13.2775	13.2124	13.2695	3397640.0
2013-04-02 13:00:00	AMZN	Stock	13.27	13.274	13.2095	13.2482	3038020.0

> showing 50 of 45,780 rows — these rows as CSV

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