PREVIEW / stock_1hour / 2016-03-10

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-03-10.parquet
  size:    1.0 MB
  rows:    48,173
  symbols: 3,331

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
2016-03-10 04:00:00	AAPL	Stock	25.3	25.365	25.3	25.3	3604.0
2016-03-10 06:00:00	AAPL	Stock	25.3225	25.325	25.3225	25.325	2740.0
2016-03-10 07:00:00	AAPL	Stock	25.3375	25.56	25.335	25.55	199228.0
2016-03-10 08:00:00	AAPL	Stock	25.525	25.555	25.3625	25.475	648644.0
2016-03-10 09:00:00	AAPL	Stock	25.465	25.56	25.3075	25.55	17532376.0
2016-03-10 10:00:00	AAPL	Stock	25.552	25.56	25.19	25.205	20849556.0
2016-03-10 11:00:00	AAPL	Stock	25.2075	25.2825	25.1125	25.255	16008448.0
2016-03-10 12:00:00	AAPL	Stock	25.255	25.38	25.075	25.11	18058220.0
2016-03-10 13:00:00	AAPL	Stock	25.1078	25.1875	25.0375	25.0925	13496612.0
2016-03-10 14:00:00	AAPL	Stock	25.095	25.2825	25.0725	25.24	11480076.0
2016-03-10 15:00:00	AAPL	Stock	25.2395	25.3775	25.2075	25.2925	18226724.0
2016-03-10 16:00:00	AAPL	Stock	25.2925	25.4185	25.25	25.255	6685296.0
2016-03-10 17:00:00	AAPL	Stock	25.26	25.29	25.2575	25.275	75260.0
2016-03-10 18:00:00	AAPL	Stock	25.2675	25.285	25.2625	25.265	22200.0
2016-03-10 19:00:00	AAPL	Stock	25.2825	25.285	25.26	25.285	30932.0
2016-03-10 05:00:00	MSFT	Stock	52.85	52.85	52.84	52.84	200.0
2016-03-10 07:00:00	MSFT	Stock	52.94	53.4	52.94	53.4	15478.0
2016-03-10 08:00:00	MSFT	Stock	53.13	53.6	53.1	53.14	43082.0
2016-03-10 09:00:00	MSFT	Stock	53.14	53.18	52.53	52.73	4147726.0
2016-03-10 10:00:00	MSFT	Stock	52.74	52.79	52.025	52.05	5222295.0
2016-03-10 11:00:00	MSFT	Stock	52.05	52.17	51.8	51.955	5223453.0
2016-03-10 12:00:00	MSFT	Stock	51.95	52.09	51.265	51.41	4688162.0
2016-03-10 13:00:00	MSFT	Stock	51.4	51.5	51.16	51.31	3983713.0
2016-03-10 14:00:00	MSFT	Stock	51.314	51.96	51.22	51.81	3874065.0
2016-03-10 15:00:00	MSFT	Stock	51.815	52.15	51.7	52.05	6628716.0
2016-03-10 16:00:00	MSFT	Stock	52.05	52.05	51.97	52.05	2267999.0
2016-03-10 17:00:00	MSFT	Stock	52.1	52.1	51.95	51.95	1500.0
2016-03-10 18:00:00	MSFT	Stock	52.04	52.05	52.04	52.05	600.0
2016-03-10 19:00:00	MSFT	Stock	51.95	52.15	51.95	52.15	500.0
2016-03-10 08:00:00	NVDA	Stock	0.7982	0.8048	0.7948	0.7998	138880.0
2016-03-10 09:00:00	NVDA	Stock	0.7992	0.8018	0.7915	0.7995	18702400.0
2016-03-10 10:00:00	NVDA	Stock	0.7998	0.8025	0.7902	0.7905	38097840.0
2016-03-10 11:00:00	NVDA	Stock	0.791	0.791	0.7843	0.7865	30705960.0
2016-03-10 12:00:00	NVDA	Stock	0.7865	0.7892	0.7763	0.7806	35859280.0
2016-03-10 13:00:00	NVDA	Stock	0.7808	0.7832	0.776	0.7787	36015280.0
2016-03-10 14:00:00	NVDA	Stock	0.7787	0.7928	0.7787	0.7898	48450360.0
2016-03-10 15:00:00	NVDA	Stock	0.7898	0.796	0.7885	0.792	59913560.0
2016-03-10 16:00:00	NVDA	Stock	0.792	0.793	0.792	0.793	4982240.0
2016-03-10 18:00:00	NVDA	Stock	0.792	0.792	0.792	0.792	4000.0
2016-03-10 07:00:00	AMZN	Stock	28.119	28.347	28.1015	28.325	196640.0
2016-03-10 08:00:00	AMZN	Stock	28.3285	28.35	28.2075	28.2495	308720.0
2016-03-10 09:00:00	AMZN	Stock	28.2	28.35	28.0595	28.246	9238900.0
2016-03-10 10:00:00	AMZN	Stock	28.2462	28.2995	27.834	27.8535	13414200.0
2016-03-10 11:00:00	AMZN	Stock	27.864	27.9961	27.759	27.8965	6321100.0
2016-03-10 12:00:00	AMZN	Stock	27.8731	27.9625	27.4502	27.553	9207080.0
2016-03-10 13:00:00	AMZN	Stock	27.5575	27.6215	27.395	27.54	7154160.0
2016-03-10 14:00:00	AMZN	Stock	27.5355	27.775	27.44	27.7335	8198780.0
2016-03-10 15:00:00	AMZN	Stock	27.737	27.982	27.672	27.9465	11727580.0
2016-03-10 16:00:00	AMZN	Stock	27.9465	27.9465	27.9	27.922	1202360.0
2016-03-10 17:00:00	AMZN	Stock	27.9	27.9	27.8985	27.8985	57000.0

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

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