PREVIEW / stock_1hour / 2015-03-25

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-03-25.parquet
  size:    1.0 MB
  rows:    48,428
  symbols: 3,490

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-25 04:00:00	AAPL	Stock	31.75	31.785	31.75	31.785	3600.0
2015-03-25 05:00:00	AAPL	Stock	31.7425	31.75	31.7375	31.75	2800.0
2015-03-25 06:00:00	AAPL	Stock	31.765	31.7725	31.7425	31.7425	1600.0
2015-03-25 07:00:00	AAPL	Stock	31.7075	31.72	31.25	31.45	297080.0
2015-03-25 08:00:00	AAPL	Stock	31.4525	31.76	31.375	31.6425	917020.0
2015-03-25 09:00:00	AAPL	Stock	31.6425	31.705	31.3825	31.4375	25674404.0
2015-03-25 10:00:00	AAPL	Stock	31.4375	31.5225	31.325	31.4962	26237448.0
2015-03-25 11:00:00	AAPL	Stock	31.4962	31.55	31.2	31.2775	29688704.0
2015-03-25 12:00:00	AAPL	Stock	31.2775	31.2925	31.105	31.2275	23609600.0
2015-03-25 13:00:00	AAPL	Stock	31.2275	31.2575	31.1075	31.185	16628792.0
2015-03-25 14:00:00	AAPL	Stock	31.1825	31.2125	31.055	31.06	16893628.0
2015-03-25 15:00:00	AAPL	Stock	31.06	31.0875	30.8475	30.8475	41078924.0
2015-03-25 16:00:00	AAPL	Stock	30.845	31.6712	30.845	30.98	10611472.0
2015-03-25 17:00:00	AAPL	Stock	30.9825	31.0125	30.845	30.9798	318320.0
2015-03-25 18:00:00	AAPL	Stock	30.98	30.985	30.875	30.9075	267532.0
2015-03-25 19:00:00	AAPL	Stock	30.9075	30.93	30.9075	30.9125	130428.0
2015-03-25 05:00:00	MSFT	Stock	42.9	42.9	42.9	42.9	100.0
2015-03-25 06:00:00	MSFT	Stock	43.0	43.0	43.0	43.0	100.0
2015-03-25 07:00:00	MSFT	Stock	42.96	42.96	42.92	42.92	725.0
2015-03-25 08:00:00	MSFT	Stock	42.8	42.83	42.76	42.83	7120.0
2015-03-25 09:00:00	MSFT	Stock	42.88	42.93	42.3	42.37	5089591.0
2015-03-25 10:00:00	MSFT	Stock	42.37	42.37	42.0	42.08	5694396.0
2015-03-25 11:00:00	MSFT	Stock	42.075	42.16	41.585	41.71	7221456.0
2015-03-25 12:00:00	MSFT	Stock	41.71	41.89	41.65	41.855	5912663.0
2015-03-25 13:00:00	MSFT	Stock	41.86	41.88	41.64	41.722	3429132.0
2015-03-25 14:00:00	MSFT	Stock	41.72	41.74	41.54	41.55	4059127.0
2015-03-25 15:00:00	MSFT	Stock	41.555	41.65	41.44	41.46	7439233.0
2015-03-25 16:00:00	MSFT	Stock	41.46	41.876	41.46	41.46	2812456.0
2015-03-25 17:00:00	MSFT	Stock	41.54	41.55	41.46	41.55	37865.0
2015-03-25 18:00:00	MSFT	Stock	41.55	41.56	41.54	41.54	2260.0
2015-03-25 19:00:00	MSFT	Stock	41.541	41.59	41.541	41.59	1700.0
2015-03-25 09:00:00	NVDA	Stock	0.5598	0.5598	0.5432	0.544	72614120.0
2015-03-25 10:00:00	NVDA	Stock	0.5438	0.5455	0.5388	0.5407	76792480.0
2015-03-25 11:00:00	NVDA	Stock	0.541	0.542	0.5298	0.5324	92947120.0
2015-03-25 12:00:00	NVDA	Stock	0.5324	0.5324	0.529	0.5308	56052480.0
2015-03-25 13:00:00	NVDA	Stock	0.5305	0.5315	0.5262	0.5296	45759360.0
2015-03-25 14:00:00	NVDA	Stock	0.5295	0.5308	0.528	0.5293	33614040.0
2015-03-25 15:00:00	NVDA	Stock	0.5293	0.5294	0.5242	0.5258	129981760.0
2015-03-25 16:00:00	NVDA	Stock	0.526	0.5398	0.5258	0.531	30046320.0
2015-03-25 17:00:00	NVDA	Stock	0.5322	0.5325	0.526	0.5322	1295920.0
2015-03-25 18:00:00	NVDA	Stock	0.5322	0.535	0.5322	0.535	30000.0
2015-03-25 19:00:00	NVDA	Stock	0.5338	0.5365	0.5332	0.5332	84400.0
2015-03-25 07:00:00	AMZN	Stock	18.737	18.767	18.737	18.765	44040.0
2015-03-25 08:00:00	AMZN	Stock	18.765	18.7775	18.75	18.7505	195340.0
2015-03-25 09:00:00	AMZN	Stock	18.7506	18.945	18.746	18.855	10135100.0
2015-03-25 10:00:00	AMZN	Stock	18.8608	19.025	18.8435	18.955	10311120.0
2015-03-25 11:00:00	AMZN	Stock	18.9595	18.9605	18.7215	18.7295	7682720.0
2015-03-25 12:00:00	AMZN	Stock	18.725	18.7445	18.588	18.6235	6936960.0
2015-03-25 13:00:00	AMZN	Stock	18.6235	18.6775	18.5142	18.637	6870220.0
2015-03-25 14:00:00	AMZN	Stock	18.635	18.6995	18.5855	18.6705	5557620.0

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

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