PREVIEW / stock_1hour / 2015-09-28

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-09-28.parquet
  size:    1.0 MB
  rows:    48,996
  symbols: 3,459

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-09-28 04:00:00	AAPL	Stock	28.6775	28.7625	28.6525	28.6525	19616.0
2015-09-28 05:00:00	AAPL	Stock	28.575	28.6125	28.5275	28.55	40000.0
2015-09-28 06:00:00	AAPL	Stock	28.55	28.55	28.55	28.55	760.0
2015-09-28 07:00:00	AAPL	Stock	28.475	28.5625	28.47	28.515	121796.0
2015-09-28 08:00:00	AAPL	Stock	28.5225	28.7925	28.455	28.65	4450700.0
2015-09-28 09:00:00	AAPL	Stock	28.6675	28.75	28.1575	28.17	35579272.0
2015-09-28 10:00:00	AAPL	Stock	28.163	28.42	28.115	28.41	32324844.0
2015-09-28 11:00:00	AAPL	Stock	28.41	28.455	28.2525	28.2552	18532916.0
2015-09-28 12:00:00	AAPL	Stock	28.2575	28.33	28.2075	28.2888	17705400.0
2015-09-28 13:00:00	AAPL	Stock	28.2925	28.3925	28.2575	28.2875	15349600.0
2015-09-28 14:00:00	AAPL	Stock	28.2875	28.3225	28.1475	28.1888	19938704.0
2015-09-28 15:00:00	AAPL	Stock	28.1875	28.32	28.1125	28.115	34081548.0
2015-09-28 16:00:00	AAPL	Stock	28.125	28.287	28.085	28.155	16759996.0
2015-09-28 17:00:00	AAPL	Stock	28.1625	28.1625	28.115	28.125	250208.0
2015-09-28 18:00:00	AAPL	Stock	28.125	28.185	28.125	28.175	124376.0
2015-09-28 19:00:00	AAPL	Stock	28.18	28.195	28.1725	28.19	126644.0
2015-09-28 05:00:00	MSFT	Stock	43.9	43.9	43.81	43.81	400.0
2015-09-28 07:00:00	MSFT	Stock	43.6	43.78	43.6	43.6	1800.0
2015-09-28 08:00:00	MSFT	Stock	43.65	43.75	43.65	43.72	8128.0
2015-09-28 09:00:00	MSFT	Stock	43.75	44.03	43.67	43.91	3098331.0
2015-09-28 10:00:00	MSFT	Stock	43.9	44.085	43.75	43.915	3817628.0
2015-09-28 11:00:00	MSFT	Stock	43.91	43.985	43.61	43.66	2153500.0
2015-09-28 12:00:00	MSFT	Stock	43.65	43.72	43.51	43.61	2391800.0
2015-09-28 13:00:00	MSFT	Stock	43.62	43.78	43.45	43.61	2205036.0
2015-09-28 14:00:00	MSFT	Stock	43.6	43.65	43.314	43.395	3762433.0
2015-09-28 15:00:00	MSFT	Stock	43.4	43.505	43.205	43.3	6533576.0
2015-09-28 16:00:00	MSFT	Stock	43.29	43.35	43.29	43.29	2216398.0
2015-09-28 18:00:00	MSFT	Stock	43.4	43.4	43.31	43.31	800.0
2015-09-28 19:00:00	MSFT	Stock	43.32	43.32	43.32	43.32	370.0
2015-09-28 07:00:00	NVDA	Stock	0.5883	0.5883	0.5883	0.5883	8000.0
2015-09-28 08:00:00	NVDA	Stock	0.588	0.6082	0.5875	0.5875	80000.0
2015-09-28 09:00:00	NVDA	Stock	0.5905	0.5939	0.588	0.5898	46030320.0
2015-09-28 10:00:00	NVDA	Stock	0.59	0.59	0.585	0.5878	39315400.0
2015-09-28 11:00:00	NVDA	Stock	0.5878	0.5885	0.5828	0.5828	24177040.0
2015-09-28 12:00:00	NVDA	Stock	0.5828	0.5854	0.5813	0.5834	18423000.0
2015-09-28 13:00:00	NVDA	Stock	0.5834	0.5863	0.5818	0.5818	27954960.0
2015-09-28 14:00:00	NVDA	Stock	0.582	0.5832	0.5788	0.5812	28535240.0
2015-09-28 15:00:00	NVDA	Stock	0.5812	0.5862	0.5798	0.5825	86214840.0
2015-09-28 16:00:00	NVDA	Stock	0.5825	0.5825	0.5822	0.5825	109345960.0
2015-09-28 17:00:00	NVDA	Stock	0.583	0.583	0.583	0.583	20000.0
2015-09-28 06:00:00	AMZN	Stock	26.1	26.1	26.009	26.009	34000.0
2015-09-28 07:00:00	AMZN	Stock	25.983	26.0015	25.975	26.0	32080.0
2015-09-28 08:00:00	AMZN	Stock	26.05	26.095	26.0	26.075	147700.0
2015-09-28 09:00:00	AMZN	Stock	26.0735	26.095	25.5375	25.5625	11681000.0
2015-09-28 10:00:00	AMZN	Stock	25.5505	25.6095	25.175	25.4335	14806760.0
2015-09-28 11:00:00	AMZN	Stock	25.434	25.5325	25.175	25.1825	7730880.0
2015-09-28 12:00:00	AMZN	Stock	25.176	25.3165	25.115	25.1156	11121520.0
2015-09-28 13:00:00	AMZN	Stock	25.1155	25.221	24.8855	24.8855	10764580.0
2015-09-28 14:00:00	AMZN	Stock	24.895	25.0975	24.7167	24.9625	15310220.0
2015-09-28 15:00:00	AMZN	Stock	24.9625	25.323	24.9625	25.1915	21090180.0

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

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