PREVIEW / stock_1hour / 2014-01-17

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-01-17.parquet
  size:    1.1 MB
  rows:    49,689
  symbols: 3,531

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-01-17 05:00:00	AAPL	Stock	19.8214	19.8214	19.8054	19.8154	35420.0
2014-01-17 06:00:00	AAPL	Stock	19.7946	19.8111	19.7254	19.7464	202636.0
2014-01-17 07:00:00	AAPL	Stock	19.7325	19.7607	19.6464	19.695	758296.0
2014-01-17 08:00:00	AAPL	Stock	19.6964	19.7625	19.5939	19.6432	3779048.0
2014-01-17 09:00:00	AAPL	Stock	19.6543	19.7168	19.5571	19.6314	96177732.0
2014-01-17 10:00:00	AAPL	Stock	19.6325	19.6509	19.5789	19.6127	33780712.0
2014-01-17 11:00:00	AAPL	Stock	19.6116	19.6229	19.5843	19.5868	18608828.0
2014-01-17 12:00:00	AAPL	Stock	19.5864	19.6032	19.5789	19.5825	14844396.0
2014-01-17 13:00:00	AAPL	Stock	19.5814	19.5848	19.3896	19.4629	50962072.0
2014-01-17 14:00:00	AAPL	Stock	19.4654	19.4796	19.3961	19.4193	39871440.0
2014-01-17 15:00:00	AAPL	Stock	19.4193	19.4268	19.2821	19.3004	84490532.0
2014-01-17 16:00:00	AAPL	Stock	19.3054	19.6924	19.2946	19.3096	16570008.0
2014-01-17 17:00:00	AAPL	Stock	19.3132	19.3139	19.2925	19.2925	5132316.0
2014-01-17 18:00:00	AAPL	Stock	19.2961	19.3071	19.2907	19.3018	491708.0
2014-01-17 19:00:00	AAPL	Stock	19.3007	19.3211	19.2971	19.3179	223580.0
2014-01-17 07:00:00	MSFT	Stock	36.88	36.88	36.85	36.85	3250.0
2014-01-17 08:00:00	MSFT	Stock	36.85	36.92	36.85	36.89	17100.0
2014-01-17 09:00:00	MSFT	Stock	36.88	36.92	36.18	36.365	17977184.0
2014-01-17 10:00:00	MSFT	Stock	36.37	36.42	36.15	36.29	4976722.0
2014-01-17 11:00:00	MSFT	Stock	36.29	36.359	36.25	36.35	2761404.0
2014-01-17 12:00:00	MSFT	Stock	36.35	36.5	36.33	36.4	3327871.0
2014-01-17 13:00:00	MSFT	Stock	36.39	36.51	36.36	36.41	2612100.0
2014-01-17 14:00:00	MSFT	Stock	36.41	36.45	36.36	36.37	1885374.0
2014-01-17 15:00:00	MSFT	Stock	36.36	36.41	36.22	36.36	6641132.0
2014-01-17 16:00:00	MSFT	Stock	36.36	36.516	36.286	36.38	4488610.0
2014-01-17 17:00:00	MSFT	Stock	36.38	36.39	36.38	36.39	600.0
2014-01-17 18:00:00	MSFT	Stock	36.38	36.38	36.38	36.38	30802.0
2014-01-17 19:00:00	MSFT	Stock	36.39	36.39	36.39	36.39	100.0
2014-01-17 08:00:00	NVDA	Stock	0.4038	0.4043	0.4032	0.4035	108000.0
2014-01-17 09:00:00	NVDA	Stock	0.4018	0.4018	0.399	0.4008	55653560.0
2014-01-17 10:00:00	NVDA	Stock	0.4009	0.4048	0.4005	0.4038	47748120.0
2014-01-17 11:00:00	NVDA	Stock	0.4038	0.4062	0.4038	0.4045	27967680.0
2014-01-17 12:00:00	NVDA	Stock	0.4046	0.4048	0.4032	0.4032	29852000.0
2014-01-17 13:00:00	NVDA	Stock	0.4034	0.4035	0.4005	0.4009	30174960.0
2014-01-17 14:00:00	NVDA	Stock	0.4009	0.401	0.3985	0.3995	28970920.0
2014-01-17 15:00:00	NVDA	Stock	0.3995	0.4003	0.3973	0.3998	100834720.0
2014-01-17 16:00:00	NVDA	Stock	0.3998	0.4003	0.3997	0.3998	2729080.0
2014-01-17 17:00:00	NVDA	Stock	0.3993	0.3993	0.3993	0.3993	80000.0
2014-01-17 07:00:00	AMZN	Stock	19.869	19.869	19.869	19.869	2000.0
2014-01-17 08:00:00	AMZN	Stock	19.7735	19.7925	19.55	19.7565	135580.0
2014-01-17 09:00:00	AMZN	Stock	19.785	19.916	19.654	19.8945	23075920.0
2014-01-17 10:00:00	AMZN	Stock	19.8815	20.1185	19.85	20.0805	13804120.0
2014-01-17 11:00:00	AMZN	Stock	20.0875	20.115	19.9775	20.11	8386020.0
2014-01-17 12:00:00	AMZN	Stock	20.103	20.1745	20.1018	20.117	5075880.0
2014-01-17 13:00:00	AMZN	Stock	20.115	20.148	20.0675	20.1335	6527940.0
2014-01-17 14:00:00	AMZN	Stock	20.1265	20.1575	20.021	20.023	5405120.0
2014-01-17 15:00:00	AMZN	Stock	20.029	20.0515	19.8595	19.9775	15533240.0
2014-01-17 16:00:00	AMZN	Stock	19.9805	20.1723	19.9275	19.9545	1107780.0
2014-01-17 17:00:00	AMZN	Stock	19.933	19.9875	19.9275	19.9875	89060.0
2014-01-17 18:00:00	AMZN	Stock	19.9805	19.9805	19.9605	19.9805	64700.0

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

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