PREVIEW / stock_1hour / 2015-10-06

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-10-06.parquet
  size:    1.0 MB
  rows:    48,445
  symbols: 3,427

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-10-06 04:00:00	AAPL	Stock	27.5825	27.585	27.4425	27.535	19320.0
2015-10-06 05:00:00	AAPL	Stock	27.5375	27.5575	27.5125	27.5125	13844.0
2015-10-06 06:00:00	AAPL	Stock	27.545	27.565	27.515	27.5475	61424.0
2015-10-06 07:00:00	AAPL	Stock	27.55	27.57	27.4525	27.535	84508.0
2015-10-06 08:00:00	AAPL	Stock	27.525	27.6575	27.525	27.64	485516.0
2015-10-06 09:00:00	AAPL	Stock	27.6475	27.8725	27.525	27.6	30959488.0
2015-10-06 10:00:00	AAPL	Stock	27.5995	27.6075	27.4412	27.5025	30531288.0
2015-10-06 11:00:00	AAPL	Stock	27.5002	27.7875	27.495	27.7325	27366292.0
2015-10-06 12:00:00	AAPL	Stock	27.7322	27.8238	27.67	27.75	19915740.0
2015-10-06 13:00:00	AAPL	Stock	27.75	27.935	27.7312	27.865	21217788.0
2015-10-06 14:00:00	AAPL	Stock	27.8625	27.9312	27.7875	27.84	17608348.0
2015-10-06 15:00:00	AAPL	Stock	27.8375	27.885	27.7825	27.8325	25286240.0
2015-10-06 16:00:00	AAPL	Stock	27.8275	27.875	27.625	27.625	9636220.0
2015-10-06 17:00:00	AAPL	Stock	27.6325	27.6325	27.5125	27.6125	323244.0
2015-10-06 18:00:00	AAPL	Stock	27.6125	27.6475	27.6025	27.645	64876.0
2015-10-06 19:00:00	AAPL	Stock	27.6425	27.645	27.6275	27.6425	60468.0
2015-10-06 04:00:00	MSFT	Stock	46.26	46.26	46.26	46.26	1000.0
2015-10-06 05:00:00	MSFT	Stock	46.4	46.4	46.4	46.4	100.0
2015-10-06 07:00:00	MSFT	Stock	46.42	46.42	46.4	46.4	1200.0
2015-10-06 08:00:00	MSFT	Stock	46.45	46.53	46.4	46.48	8218.0
2015-10-06 09:00:00	MSFT	Stock	46.55	46.56	46.22	46.52	2557661.0
2015-10-06 10:00:00	MSFT	Stock	46.516	46.92	46.38	46.816	3204947.0
2015-10-06 11:00:00	MSFT	Stock	46.81	47.175	46.804	47.0	3757916.0
2015-10-06 12:00:00	MSFT	Stock	47.0	47.04	46.78	46.894	2502282.0
2015-10-06 13:00:00	MSFT	Stock	46.89	47.0	46.81	46.97	1859441.0
2015-10-06 14:00:00	MSFT	Stock	46.97	47.07	46.805	46.86	2896810.0
2015-10-06 15:00:00	MSFT	Stock	46.86	46.92	46.71	46.76	5934937.0
2015-10-06 16:00:00	MSFT	Stock	46.75	46.905	46.59	46.59	3228664.0
2015-10-06 17:00:00	MSFT	Stock	46.5	46.59	46.5	46.55	4149.0
2015-10-06 18:00:00	MSFT	Stock	46.55	46.59	46.55	46.55	3009.0
2015-10-06 19:00:00	MSFT	Stock	46.55	46.56	46.55	46.56	300.0
2015-10-06 08:00:00	NVDA	Stock	0.6353	0.6353	0.6353	0.6353	8000.0
2015-10-06 09:00:00	NVDA	Stock	0.632	0.6448	0.6263	0.6448	93157720.0
2015-10-06 10:00:00	NVDA	Stock	0.6448	0.6455	0.6339	0.6388	84178320.0
2015-10-06 11:00:00	NVDA	Stock	0.6388	0.6435	0.6376	0.6388	66953920.0
2015-10-06 12:00:00	NVDA	Stock	0.639	0.6405	0.6338	0.6349	27740320.0
2015-10-06 13:00:00	NVDA	Stock	0.635	0.6399	0.6348	0.6395	26028880.0
2015-10-06 14:00:00	NVDA	Stock	0.6395	0.645	0.6388	0.6418	41780440.0
2015-10-06 15:00:00	NVDA	Stock	0.6415	0.6465	0.6405	0.6438	56383920.0
2015-10-06 16:00:00	NVDA	Stock	0.6438	0.6438	0.6438	0.6438	13072400.0
2015-10-06 17:00:00	NVDA	Stock	0.6438	0.6438	0.6438	0.6438	16000.0
2015-10-06 06:00:00	AMZN	Stock	27.1015	27.1015	27.1015	27.1015	2000.0
2015-10-06 07:00:00	AMZN	Stock	27.0725	27.0725	27.0725	27.0725	6000.0
2015-10-06 08:00:00	AMZN	Stock	27.0825	27.1995	27.078	27.1985	182380.0
2015-10-06 09:00:00	AMZN	Stock	27.1975	27.5589	27.175	27.5225	10038240.0
2015-10-06 10:00:00	AMZN	Stock	27.521	27.575	27.034	27.0801	13354420.0
2015-10-06 11:00:00	AMZN	Stock	27.0675	27.2263	26.856	26.88	8963280.0
2015-10-06 12:00:00	AMZN	Stock	26.9	26.9608	26.685	26.6995	8444700.0
2015-10-06 13:00:00	AMZN	Stock	26.6985	26.911	26.6665	26.722	10048340.0
2015-10-06 14:00:00	AMZN	Stock	26.7165	26.8784	26.6956	26.7675	7205620.0

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

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