PREVIEW / stock_1hour / 2014-11-12

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-11-12.parquet
  size:    1.0 MB
  rows:    48,568
  symbols: 3,549

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-12 04:00:00	AAPL	Stock	27.35	27.3975	27.33	27.3375	12000.0
2014-11-12 05:00:00	AAPL	Stock	27.3225	27.375	27.3075	27.375	14000.0
2014-11-12 06:00:00	AAPL	Stock	27.35	27.375	27.3075	27.33	14480.0
2014-11-12 07:00:00	AAPL	Stock	27.3325	27.3625	27.3325	27.35	63876.0
2014-11-12 08:00:00	AAPL	Stock	27.3575	27.3675	27.2075	27.3425	379392.0
2014-11-12 09:00:00	AAPL	Stock	27.3375	27.6175	27.3375	27.56	33603612.0
2014-11-12 10:00:00	AAPL	Stock	27.56	27.7325	27.515	27.6282	32195648.0
2014-11-12 11:00:00	AAPL	Stock	27.6275	27.75	27.605	27.7475	20989996.0
2014-11-12 12:00:00	AAPL	Stock	27.7475	27.77	27.7035	27.7465	16191788.0
2014-11-12 13:00:00	AAPL	Stock	27.7475	27.7925	27.7275	27.7558	13701004.0
2014-11-12 14:00:00	AAPL	Stock	27.755	27.7775	27.705	27.745	11589248.0
2014-11-12 15:00:00	AAPL	Stock	27.745	27.8575	27.735	27.8125	26635236.0
2014-11-12 16:00:00	AAPL	Stock	27.8125	27.85	27.6675	27.85	15863560.0
2014-11-12 17:00:00	AAPL	Stock	27.845	27.845	27.7158	27.8125	491484.0
2014-11-12 18:00:00	AAPL	Stock	27.8475	27.855	27.8125	27.85	954304.0
2014-11-12 19:00:00	AAPL	Stock	27.8475	27.855	27.8375	27.8475	98272.0
2014-11-12 06:00:00	MSFT	Stock	48.75	48.75	48.75	48.75	100.0
2014-11-12 07:00:00	MSFT	Stock	48.7	48.7	48.7	48.7	215.0
2014-11-12 08:00:00	MSFT	Stock	48.7	48.74	48.61	48.68	6889.0
2014-11-12 09:00:00	MSFT	Stock	48.69	48.835	48.49	48.805	1648854.0
2014-11-12 10:00:00	MSFT	Stock	48.81	48.83	48.64	48.725	2237367.0
2014-11-12 11:00:00	MSFT	Stock	48.725	48.85	48.62	48.79	3456436.0
2014-11-12 12:00:00	MSFT	Stock	48.79	48.88	48.78	48.843	2345255.0
2014-11-12 13:00:00	MSFT	Stock	48.84	48.92	48.73	48.74	2605491.0
2014-11-12 14:00:00	MSFT	Stock	48.73	48.87	48.72	48.78	2528892.0
2014-11-12 15:00:00	MSFT	Stock	48.775	48.89	48.75	48.77	4613000.0
2014-11-12 16:00:00	MSFT	Stock	48.78	48.87	48.77	48.87	2381682.0
2014-11-12 17:00:00	MSFT	Stock	48.78	48.85	48.78	48.8	26761.0
2014-11-12 18:00:00	MSFT	Stock	48.8	48.8	48.78	48.78	600.0
2014-11-12 08:00:00	NVDA	Stock	0.4945	0.4945	0.4945	0.4945	5988000.0
2014-11-12 09:00:00	NVDA	Stock	0.4923	0.494	0.4868	0.487	27515480.0
2014-11-12 10:00:00	NVDA	Stock	0.487	0.4883	0.4848	0.4852	48733080.0
2014-11-12 11:00:00	NVDA	Stock	0.4855	0.4892	0.4845	0.4883	28603080.0
2014-11-12 12:00:00	NVDA	Stock	0.4885	0.4905	0.4875	0.4902	12246800.0
2014-11-12 13:00:00	NVDA	Stock	0.4905	0.4912	0.4898	0.4905	11874880.0
2014-11-12 14:00:00	NVDA	Stock	0.4905	0.4918	0.4895	0.4898	19106280.0
2014-11-12 15:00:00	NVDA	Stock	0.4895	0.4919	0.4892	0.491	37335800.0
2014-11-12 16:00:00	NVDA	Stock	0.4911	0.4955	0.491	0.491	8285720.0
2014-11-12 17:00:00	NVDA	Stock	0.4911	0.4911	0.4892	0.4892	700520.0
2014-11-12 19:00:00	NVDA	Stock	0.4907	0.491	0.4907	0.491	635480.0
2014-11-12 06:00:00	AMZN	Stock	15.515	15.5205	15.515	15.5205	4000.0
2014-11-12 07:00:00	AMZN	Stock	15.515	15.535	15.515	15.5175	11840.0
2014-11-12 08:00:00	AMZN	Stock	15.6005	15.6005	15.5	15.5545	177220.0
2014-11-12 09:00:00	AMZN	Stock	15.5565	15.5745	15.4395	15.452	5699160.0
2014-11-12 10:00:00	AMZN	Stock	15.4515	15.5715	15.4465	15.4725	6579480.0
2014-11-12 11:00:00	AMZN	Stock	15.471	15.5604	15.443	15.5444	4517780.0
2014-11-12 12:00:00	AMZN	Stock	15.542	15.618	15.5035	15.6085	4166600.0
2014-11-12 13:00:00	AMZN	Stock	15.6085	15.629	15.586	15.6145	2828660.0
2014-11-12 14:00:00	AMZN	Stock	15.6155	15.6235	15.5345	15.5345	4072680.0
2014-11-12 15:00:00	AMZN	Stock	15.534	15.609	15.5065	15.5744	8034080.0

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

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