PREVIEW / stock_1hour / 2015-02-10

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-02-10.parquet
  size:    1.0 MB
  rows:    48,701
  symbols: 3,522

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-10 04:00:00	AAPL	Stock	29.9125	29.95	29.9125	29.95	9148.0
2015-02-10 05:00:00	AAPL	Stock	29.9175	29.97	29.9175	29.97	2448.0
2015-02-10 06:00:00	AAPL	Stock	29.97	29.9975	29.95	29.95	12020.0
2015-02-10 07:00:00	AAPL	Stock	29.9975	30.105	29.9975	30.0575	230464.0
2015-02-10 08:00:00	AAPL	Stock	30.065	30.145	29.9525	30.135	1198720.0
2015-02-10 09:00:00	AAPL	Stock	30.135	30.3175	30.04	30.22	45154392.0
2015-02-10 10:00:00	AAPL	Stock	30.22	30.2775	30.105	30.19	35148172.0
2015-02-10 11:00:00	AAPL	Stock	30.19	30.3075	30.18	30.295	25813872.0
2015-02-10 12:00:00	AAPL	Stock	30.2962	30.43	30.275	30.4275	27413600.0
2015-02-10 13:00:00	AAPL	Stock	30.4275	30.4612	30.3675	30.39	20988296.0
2015-02-10 14:00:00	AAPL	Stock	30.3875	30.5175	30.385	30.5162	22757368.0
2015-02-10 15:00:00	AAPL	Stock	30.5162	30.5375	30.475	30.505	35421804.0
2015-02-10 16:00:00	AAPL	Stock	30.505	30.545	29.8582	30.5425	19748200.0
2015-02-10 17:00:00	AAPL	Stock	30.54	30.555	30.505	30.5475	399632.0
2015-02-10 18:00:00	AAPL	Stock	30.545	30.5475	30.5375	30.545	149840.0
2015-02-10 19:00:00	AAPL	Stock	30.5475	30.555	30.545	30.555	320168.0
2015-02-10 05:00:00	MSFT	Stock	42.37	42.37	42.37	42.37	100.0
2015-02-10 06:00:00	MSFT	Stock	42.5	42.5	42.5	42.5	100.0
2015-02-10 07:00:00	MSFT	Stock	42.6	42.72	42.6	42.65	4849.0
2015-02-10 08:00:00	MSFT	Stock	42.7	42.75	42.69	42.71	3625.0
2015-02-10 09:00:00	MSFT	Stock	42.74	42.83	42.31	42.34	4851423.0
2015-02-10 10:00:00	MSFT	Stock	42.34	42.45	42.18	42.315	4028013.0
2015-02-10 11:00:00	MSFT	Stock	42.315	42.58	42.28	42.566	2806860.0
2015-02-10 12:00:00	MSFT	Stock	42.57	42.725	42.53	42.575	2991537.0
2015-02-10 13:00:00	MSFT	Stock	42.575	42.63	42.48	42.556	1805633.0
2015-02-10 14:00:00	MSFT	Stock	42.55	42.605	42.53	42.585	3355396.0
2015-02-10 15:00:00	MSFT	Stock	42.587	42.69	42.54	42.6	4778945.0
2015-02-10 16:00:00	MSFT	Stock	42.595	42.615	42.408	42.6	3486269.0
2015-02-10 17:00:00	MSFT	Stock	42.603	42.603	42.6	42.6	13161.0
2015-02-10 18:00:00	MSFT	Stock	42.511	42.58	42.511	42.58	360.0
2015-02-10 19:00:00	MSFT	Stock	42.54	42.58	42.52	42.58	1950.0
2015-02-10 08:00:00	NVDA	Stock	0.509	0.5093	0.509	0.509	60000.0
2015-02-10 09:00:00	NVDA	Stock	0.51	0.5165	0.51	0.5102	15867480.0
2015-02-10 10:00:00	NVDA	Stock	0.5102	0.5115	0.5078	0.5112	22994360.0
2015-02-10 11:00:00	NVDA	Stock	0.5112	0.5142	0.5098	0.514	17407120.0
2015-02-10 12:00:00	NVDA	Stock	0.5139	0.5181	0.5136	0.5163	23514480.0
2015-02-10 13:00:00	NVDA	Stock	0.5165	0.517	0.5159	0.5162	20574720.0
2015-02-10 14:00:00	NVDA	Stock	0.5162	0.5222	0.5162	0.522	25765560.0
2015-02-10 15:00:00	NVDA	Stock	0.522	0.524	0.521	0.5235	74146400.0
2015-02-10 16:00:00	NVDA	Stock	0.5238	0.525	0.5177	0.5238	19985400.0
2015-02-10 07:00:00	AMZN	Stock	18.575	18.65	18.575	18.5975	34680.0
2015-02-10 08:00:00	AMZN	Stock	18.6	18.6	18.5385	18.5385	64280.0
2015-02-10 09:00:00	AMZN	Stock	18.575	18.595	18.4255	18.5266	6330000.0
2015-02-10 10:00:00	AMZN	Stock	18.5355	18.71	18.511	18.589	10037360.0
2015-02-10 11:00:00	AMZN	Stock	18.5755	18.682	18.5605	18.672	4381080.0
2015-02-10 12:00:00	AMZN	Stock	18.6705	18.715	18.62	18.6874	3286180.0
2015-02-10 13:00:00	AMZN	Stock	18.686	18.6925	18.577	18.59	4760500.0
2015-02-10 14:00:00	AMZN	Stock	18.5885	18.6375	18.577	18.637	3909580.0
2015-02-10 15:00:00	AMZN	Stock	18.632	18.6625	18.58	18.65	7169860.0
2015-02-10 16:00:00	AMZN	Stock	18.6498	18.6808	18.4836	18.6498	2274880.0

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

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