PREVIEW / stock_1hour / 2015-05-05

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-05-05.parquet
  size:    1.0 MB
  rows:    49,194
  symbols: 3,523

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-05-05 04:00:00	AAPL	Stock	32.2	32.275	32.1925	32.2225	27984.0
2015-05-05 05:00:00	AAPL	Stock	32.225	32.265	32.215	32.265	5336.0
2015-05-05 06:00:00	AAPL	Stock	32.2375	32.245	32.1925	32.1925	24376.0
2015-05-05 07:00:00	AAPL	Stock	32.1925	32.1925	32.05	32.0675	225188.0
2015-05-05 08:00:00	AAPL	Stock	32.08	32.2325	32.05	32.0625	730844.0
2015-05-05 09:00:00	AAPL	Stock	32.0675	32.1125	31.69	31.7	30502616.0
2015-05-05 10:00:00	AAPL	Stock	31.7125	31.83	31.68	31.8132	27665924.0
2015-05-05 11:00:00	AAPL	Stock	31.81	31.81	31.555	31.6425	22406100.0
2015-05-05 12:00:00	AAPL	Stock	31.64	31.7375	31.6075	31.6175	14279176.0
2015-05-05 13:00:00	AAPL	Stock	31.6175	31.6218	31.475	31.575	22023892.0
2015-05-05 14:00:00	AAPL	Stock	31.575	31.6475	31.4625	31.55	21467356.0
2015-05-05 15:00:00	AAPL	Stock	31.5475	31.635	31.445	31.4525	30060240.0
2015-05-05 16:00:00	AAPL	Stock	31.45	31.9345	31.45	31.4725	13898164.0
2015-05-05 17:00:00	AAPL	Stock	31.465	31.4725	31.4525	31.4625	193736.0
2015-05-05 18:00:00	AAPL	Stock	31.4578	31.475	31.455	31.4625	144624.0
2015-05-05 19:00:00	AAPL	Stock	31.475	31.475	31.4625	31.4625	101404.0
2015-05-05 05:00:00	MSFT	Stock	48.15	48.15	48.15	48.15	100.0
2015-05-05 06:00:00	MSFT	Stock	48.15	48.15	48.08	48.08	400.0
2015-05-05 07:00:00	MSFT	Stock	48.08	48.11	48.05	48.11	4258.0
2015-05-05 08:00:00	MSFT	Stock	48.08	48.11	47.96	47.98	27481.0
2015-05-05 09:00:00	MSFT	Stock	48.0	48.16	47.71	48.04	5296915.0
2015-05-05 10:00:00	MSFT	Stock	48.04	48.14	47.86	48.015	5418760.0
2015-05-05 11:00:00	MSFT	Stock	48.01	48.03	47.76	47.894	4481659.0
2015-05-05 12:00:00	MSFT	Stock	47.9	47.98	47.8	47.85	2726523.0
2015-05-05 13:00:00	MSFT	Stock	47.86	47.88	47.65	47.71	3719494.0
2015-05-05 14:00:00	MSFT	Stock	47.71	48.03	47.31	47.625	10243650.0
2015-05-05 15:00:00	MSFT	Stock	47.62	47.88	47.44	47.61	14119348.0
2015-05-05 16:00:00	MSFT	Stock	47.6	47.818	47.6	47.7	2292390.0
2015-05-05 17:00:00	MSFT	Stock	47.65	47.65	47.61	47.65	4484.0
2015-05-05 18:00:00	MSFT	Stock	47.65	47.65	47.63	47.63	2300.0
2015-05-05 19:00:00	MSFT	Stock	47.72	47.72	47.63	47.63	362.0
2015-05-05 09:00:00	NVDA	Stock	0.5622	0.564	0.5579	0.558	18929200.0
2015-05-05 10:00:00	NVDA	Stock	0.5584	0.5612	0.5572	0.5605	32127000.0
2015-05-05 11:00:00	NVDA	Stock	0.5605	0.5605	0.5529	0.5554	45532520.0
2015-05-05 12:00:00	NVDA	Stock	0.5555	0.5558	0.5502	0.5519	45278520.0
2015-05-05 13:00:00	NVDA	Stock	0.5518	0.552	0.5484	0.5505	18848800.0
2015-05-05 14:00:00	NVDA	Stock	0.5505	0.5522	0.5482	0.5504	28959680.0
2015-05-05 15:00:00	NVDA	Stock	0.5502	0.5525	0.5495	0.5509	48294360.0
2015-05-05 16:00:00	NVDA	Stock	0.5508	0.5544	0.5508	0.5544	38127080.0
2015-05-05 04:00:00	AMZN	Stock	21.1655	21.1655	21.1655	21.1655	10000.0
2015-05-05 06:00:00	AMZN	Stock	21.112	21.112	21.112	21.112	3600.0
2015-05-05 08:00:00	AMZN	Stock	21.2095	21.2095	21.112	21.112	93000.0
2015-05-05 09:00:00	AMZN	Stock	21.1125	21.3755	21.1	21.2155	8893880.0
2015-05-05 10:00:00	AMZN	Stock	21.2235	21.293	21.1075	21.2835	8775880.0
2015-05-05 11:00:00	AMZN	Stock	21.2875	21.2882	21.165	21.246	7537380.0
2015-05-05 12:00:00	AMZN	Stock	21.2465	21.3275	21.2315	21.3015	5152260.0
2015-05-05 13:00:00	AMZN	Stock	21.306	21.333	21.1825	21.2	4163760.0
2015-05-05 14:00:00	AMZN	Stock	21.1975	21.2245	21.101	21.205	5480860.0
2015-05-05 15:00:00	AMZN	Stock	21.205	21.234	21.051	21.059	13371920.0
2015-05-05 16:00:00	AMZN	Stock	21.0785	21.085	21.0595	21.075	425460.0

> showing 50 of 49,194 rows — these rows as CSV

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