PREVIEW / stock_1hour / 2015-03-27

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-03-27.parquet
  size:    1.0 MB
  rows:    47,891
  symbols: 3,476

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-03-27 04:00:00	AAPL	Stock	31.0875	31.2	31.0875	31.1025	16000.0
2015-03-27 05:00:00	AAPL	Stock	31.15	31.165	31.0875	31.1	49416.0
2015-03-27 06:00:00	AAPL	Stock	31.1	31.145	31.1	31.125	42640.0
2015-03-27 07:00:00	AAPL	Stock	31.125	31.165	31.1175	31.145	52308.0
2015-03-27 08:00:00	AAPL	Stock	31.145	31.165	31.1025	31.13	432668.0
2015-03-27 09:00:00	AAPL	Stock	31.1275	31.1875	30.9775	31.005	20719920.0
2015-03-27 10:00:00	AAPL	Stock	31.0025	31.0675	30.85	31.0535	26211284.0
2015-03-27 11:00:00	AAPL	Stock	31.0525	31.0875	30.8875	30.9325	15165804.0
2015-03-27 12:00:00	AAPL	Stock	30.9275	30.93	30.8	30.87	16100012.0
2015-03-27 13:00:00	AAPL	Stock	30.8725	30.925	30.8375	30.865	9005108.0
2015-03-27 14:00:00	AAPL	Stock	30.865	30.8975	30.7275	30.7625	15965672.0
2015-03-27 15:00:00	AAPL	Stock	30.7625	30.8875	30.7525	30.81	33178540.0
2015-03-27 16:00:00	AAPL	Stock	30.8125	31.11	30.765	30.8125	10405916.0
2015-03-27 17:00:00	AAPL	Stock	30.805	30.835	30.7925	30.7925	232552.0
2015-03-27 18:00:00	AAPL	Stock	30.79	30.7925	30.775	30.775	113628.0
2015-03-27 19:00:00	AAPL	Stock	30.785	30.7875	30.7625	30.775	69048.0
2015-03-27 05:00:00	MSFT	Stock	41.22	41.22	41.22	41.22	200.0
2015-03-27 06:00:00	MSFT	Stock	41.16	41.16	41.1	41.1	500.0
2015-03-27 07:00:00	MSFT	Stock	41.21	41.22	41.21	41.22	200.0
2015-03-27 08:00:00	MSFT	Stock	41.23	41.25	41.12	41.18	2890.0
2015-03-27 09:00:00	MSFT	Stock	41.18	41.43	41.06	41.33	3089469.0
2015-03-27 10:00:00	MSFT	Stock	41.33	41.35	40.925	41.027	5515531.0
2015-03-27 11:00:00	MSFT	Stock	41.025	41.12	40.925	40.94	3142773.0
2015-03-27 12:00:00	MSFT	Stock	40.935	41.01	40.91	40.946	2657797.0
2015-03-27 13:00:00	MSFT	Stock	40.945	40.97	40.88	40.95	1841884.0
2015-03-27 14:00:00	MSFT	Stock	40.96	40.97	40.88	40.895	2647502.0
2015-03-27 15:00:00	MSFT	Stock	40.895	41.11	40.83	41.01	10668052.0
2015-03-27 16:00:00	MSFT	Stock	41.01	41.027	40.897	40.968	3302606.0
2015-03-27 17:00:00	MSFT	Stock	40.97	41.06	40.97	41.05	34323.0
2015-03-27 18:00:00	MSFT	Stock	40.971	41.0	40.971	41.0	1100.0
2015-03-27 19:00:00	MSFT	Stock	40.97	41.01	40.97	40.98	404151.0
2015-03-27 08:00:00	NVDA	Stock	0.5253	0.5253	0.5253	0.5253	20000.0
2015-03-27 09:00:00	NVDA	Stock	0.524	0.5293	0.524	0.5254	20855200.0
2015-03-27 10:00:00	NVDA	Stock	0.5253	0.5278	0.5188	0.523	37467800.0
2015-03-27 11:00:00	NVDA	Stock	0.523	0.5234	0.5196	0.521	18955600.0
2015-03-27 12:00:00	NVDA	Stock	0.5213	0.524	0.521	0.5238	12023360.0
2015-03-27 13:00:00	NVDA	Stock	0.5235	0.5242	0.522	0.5232	10653080.0
2015-03-27 14:00:00	NVDA	Stock	0.5232	0.5244	0.522	0.5235	14753120.0
2015-03-27 15:00:00	NVDA	Stock	0.5238	0.5365	0.5236	0.5345	161185640.0
2015-03-27 16:00:00	NVDA	Stock	0.5345	0.5365	0.529	0.5365	17346800.0
2015-03-27 17:00:00	NVDA	Stock	0.5382	0.5382	0.5382	0.5382	4000.0
2015-03-27 19:00:00	NVDA	Stock	0.5358	0.5358	0.5358	0.5358	12000.0
2015-03-27 06:00:00	AMZN	Stock	18.365	18.365	18.365	18.365	4140.0
2015-03-27 08:00:00	AMZN	Stock	18.4065	18.4065	18.382	18.382	4000.0
2015-03-27 09:00:00	AMZN	Stock	18.3675	18.575	18.3286	18.474	9052180.0
2015-03-27 10:00:00	AMZN	Stock	18.474	18.5745	18.422	18.545	7521120.0
2015-03-27 11:00:00	AMZN	Stock	18.5475	18.6155	18.528	18.5885	5485520.0
2015-03-27 12:00:00	AMZN	Stock	18.597	18.597	18.4891	18.5795	4612200.0
2015-03-27 13:00:00	AMZN	Stock	18.5855	18.6235	18.5675	18.602	4073920.0
2015-03-27 14:00:00	AMZN	Stock	18.6005	18.6585	18.5795	18.6365	3834000.0

> showing 50 of 47,891 rows — these rows as CSV

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