PREVIEW / stock_1hour / 2015-04-14

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-04-14.parquet
  size:    1.0 MB
  rows:    48,484
  symbols: 3,514

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-04-14 04:00:00	AAPL	Stock	31.8375	31.8675	31.8275	31.8275	20916.0
2015-04-14 05:00:00	AAPL	Stock	31.7775	31.7775	31.6775	31.69	23936.0
2015-04-14 06:00:00	AAPL	Stock	31.6975	31.785	31.6975	31.725	9400.0
2015-04-14 07:00:00	AAPL	Stock	31.7475	31.825	31.7475	31.75	88292.0
2015-04-14 08:00:00	AAPL	Stock	31.75	31.825	31.7175	31.785	245524.0
2015-04-14 09:00:00	AAPL	Stock	31.7875	31.8225	31.5275	31.56	18440884.0
2015-04-14 10:00:00	AAPL	Stock	31.56	31.61	31.4775	31.545	19142208.0
2015-04-14 11:00:00	AAPL	Stock	31.545	31.6625	31.5225	31.5625	11615904.0
2015-04-14 12:00:00	AAPL	Stock	31.5625	31.6875	31.5575	31.6025	9671248.0
2015-04-14 13:00:00	AAPL	Stock	31.6025	31.6425	31.5788	31.6125	5449164.0
2015-04-14 14:00:00	AAPL	Stock	31.61	31.6148	31.5375	31.6028	8413052.0
2015-04-14 15:00:00	AAPL	Stock	31.605	31.635	31.5288	31.575	16293756.0
2015-04-14 16:00:00	AAPL	Stock	31.575	31.6	31.5375	31.5775	5114744.0
2015-04-14 17:00:00	AAPL	Stock	31.575	31.585	31.575	31.585	76864.0
2015-04-14 18:00:00	AAPL	Stock	31.585	31.5925	31.585	31.5875	43856.0
2015-04-14 19:00:00	AAPL	Stock	31.5875	31.5925	31.58	31.5925	85528.0
2015-04-14 04:00:00	MSFT	Stock	41.93	41.93	41.93	41.93	100.0
2015-04-14 05:00:00	MSFT	Stock	41.68	41.68	41.68	41.68	100.0
2015-04-14 08:00:00	MSFT	Stock	41.7	41.74	41.63	41.63	1260.0
2015-04-14 09:00:00	MSFT	Stock	41.61	42.03	41.61	41.77	3670485.0
2015-04-14 10:00:00	MSFT	Stock	41.77	41.81	41.41	41.425	4859008.0
2015-04-14 11:00:00	MSFT	Stock	41.416	41.57	41.39	41.428	2700158.0
2015-04-14 12:00:00	MSFT	Stock	41.429	41.655	41.42	41.54	1883437.0
2015-04-14 13:00:00	MSFT	Stock	41.54	41.56	41.47	41.48	1286094.0
2015-04-14 14:00:00	MSFT	Stock	41.48	41.58	41.45	41.563	2215061.0
2015-04-14 15:00:00	MSFT	Stock	41.565	41.73	41.55	41.65	4323067.0
2015-04-14 16:00:00	MSFT	Stock	41.65	41.92	41.445	41.82	1845881.0
2015-04-14 17:00:00	MSFT	Stock	41.74	41.92	41.74	41.92	6660.0
2015-04-14 18:00:00	MSFT	Stock	41.89	41.89	41.89	41.89	495.0
2015-04-14 19:00:00	MSFT	Stock	41.81	41.84	41.81	41.84	1320.0
2015-04-14 09:00:00	NVDA	Stock	0.5622	0.5638	0.556	0.5572	18105600.0
2015-04-14 10:00:00	NVDA	Stock	0.557	0.5582	0.5536	0.557	32535400.0
2015-04-14 11:00:00	NVDA	Stock	0.5568	0.56	0.5554	0.56	30666000.0
2015-04-14 12:00:00	NVDA	Stock	0.56	0.561	0.5585	0.5586	17215920.0
2015-04-14 13:00:00	NVDA	Stock	0.5585	0.5598	0.5575	0.5588	26614800.0
2015-04-14 14:00:00	NVDA	Stock	0.5588	0.5595	0.5568	0.5592	18276640.0
2015-04-14 15:00:00	NVDA	Stock	0.5592	0.5608	0.5585	0.5592	35274520.0
2015-04-14 16:00:00	NVDA	Stock	0.559	0.5608	0.559	0.559	2668880.0
2015-04-14 19:00:00	NVDA	Stock	0.5615	0.5615	0.5615	0.5615	32000.0
2015-04-14 06:00:00	AMZN	Stock	19.1955	19.1955	19.1955	19.1955	8160.0
2015-04-14 07:00:00	AMZN	Stock	19.1935	19.205	19.1935	19.205	29700.0
2015-04-14 08:00:00	AMZN	Stock	19.1925	19.2755	19.1925	19.2375	126860.0
2015-04-14 09:00:00	AMZN	Stock	19.237	19.3905	19.164	19.249	10509600.0
2015-04-14 10:00:00	AMZN	Stock	19.25	19.25	19.0605	19.1081	10177280.0
2015-04-14 11:00:00	AMZN	Stock	19.105	19.219	19.0925	19.194	4627420.0
2015-04-14 12:00:00	AMZN	Stock	19.193	19.3075	19.193	19.245	4583520.0
2015-04-14 13:00:00	AMZN	Stock	19.2535	19.255	19.15	19.22	3570960.0
2015-04-14 14:00:00	AMZN	Stock	19.224	19.2875	19.2156	19.2493	4646740.0
2015-04-14 15:00:00	AMZN	Stock	19.2485	19.274	19.237	19.256	6082580.0
2015-04-14 16:00:00	AMZN	Stock	19.2555	19.27	19.1848	19.2555	3716740.0

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

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