PREVIEW / stock_1hour / 2015-12-10

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-12-10.parquet
  size:    1.0 MB
  rows:    48,746
  symbols: 3,408

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-12-10 04:00:00	AAPL	Stock	28.985	29.0175	28.96	28.9875	8800.0
2015-12-10 05:00:00	AAPL	Stock	28.96	29.045	28.96	29.035	2692.0
2015-12-10 06:00:00	AAPL	Stock	29.0375	29.0375	28.95	28.9925	20384.0
2015-12-10 07:00:00	AAPL	Stock	29.0025	29.005	28.94	28.985	47928.0
2015-12-10 08:00:00	AAPL	Stock	28.985	29.07	28.9625	29.02	356112.0
2015-12-10 09:00:00	AAPL	Stock	29.02	29.0975	28.9	28.96	18738652.0
2015-12-10 10:00:00	AAPL	Stock	28.9525	29.1725	28.8775	29.1	22369288.0
2015-12-10 11:00:00	AAPL	Stock	29.1	29.1175	28.9425	28.9875	12775640.0
2015-12-10 12:00:00	AAPL	Stock	28.9878	29.0525	28.9425	29.0225	10220876.0
2015-12-10 13:00:00	AAPL	Stock	29.025	29.125	29.0025	29.0638	8883604.0
2015-12-10 14:00:00	AAPL	Stock	29.0642	29.235	29.06	29.165	11503100.0
2015-12-10 15:00:00	AAPL	Stock	29.1638	29.1775	28.975	29.045	17238440.0
2015-12-10 16:00:00	AAPL	Stock	29.0425	29.06	29.015	29.0475	6432704.0
2015-12-10 17:00:00	AAPL	Stock	29.065	29.07	29.045	29.05	60104.0
2015-12-10 18:00:00	AAPL	Stock	29.0525	29.095	29.0525	29.095	38780.0
2015-12-10 19:00:00	AAPL	Stock	29.0925	29.105	29.0725	29.105	36652.0
2015-12-10 06:00:00	MSFT	Stock	55.25	55.25	55.03	55.03	900.0
2015-12-10 07:00:00	MSFT	Stock	55.11	55.11	55.0	55.1	10100.0
2015-12-10 08:00:00	MSFT	Stock	55.05	55.23	55.05	55.1	37746.0
2015-12-10 09:00:00	MSFT	Stock	55.1	55.55	55.01	55.32	3362940.0
2015-12-10 10:00:00	MSFT	Stock	55.32	55.585	55.165	55.45	4343087.0
2015-12-10 11:00:00	MSFT	Stock	55.44	55.55	55.3	55.4	2803816.0
2015-12-10 12:00:00	MSFT	Stock	55.39	55.42	55.02	55.3	2907960.0
2015-12-10 13:00:00	MSFT	Stock	55.31	55.435	55.18	55.245	2238356.0
2015-12-10 14:00:00	MSFT	Stock	55.24	55.655	55.23	55.48	3050517.0
2015-12-10 15:00:00	MSFT	Stock	55.485	55.509	55.081	55.28	7210940.0
2015-12-10 16:00:00	MSFT	Stock	55.27	55.28	55.19	55.27	3802859.0
2015-12-10 17:00:00	MSFT	Stock	55.25	55.26	55.23	55.26	9200.0
2015-12-10 18:00:00	MSFT	Stock	55.3	55.3	55.3	55.3	100.0
2015-12-10 19:00:00	MSFT	Stock	55.29	55.35	55.29	55.35	2904.0
2015-12-10 08:00:00	NVDA	Stock	0.8315	0.8315	0.8128	0.8128	32000.0
2015-12-10 09:00:00	NVDA	Stock	0.8203	0.8288	0.819	0.8255	18376880.0
2015-12-10 10:00:00	NVDA	Stock	0.8255	0.8262	0.8191	0.8195	28898400.0
2015-12-10 11:00:00	NVDA	Stock	0.8195	0.822	0.8175	0.8203	28437080.0
2015-12-10 12:00:00	NVDA	Stock	0.8205	0.8225	0.8185	0.82	23590680.0
2015-12-10 13:00:00	NVDA	Stock	0.8203	0.824	0.8198	0.8236	25966480.0
2015-12-10 14:00:00	NVDA	Stock	0.8236	0.829	0.8234	0.8278	29411720.0
2015-12-10 15:00:00	NVDA	Stock	0.8276	0.8278	0.8232	0.8248	52596680.0
2015-12-10 16:00:00	NVDA	Stock	0.8245	0.8278	0.8245	0.8278	1656320.0
2015-12-10 18:00:00	NVDA	Stock	0.828	0.828	0.8275	0.8275	20000.0
2015-12-10 19:00:00	NVDA	Stock	0.8275	0.8275	0.8275	0.8275	56000.0
2015-12-10 05:00:00	AMZN	Stock	33.328	33.333	33.328	33.333	4000.0
2015-12-10 06:00:00	AMZN	Stock	33.325	33.325	33.325	33.325	2000.0
2015-12-10 07:00:00	AMZN	Stock	33.229	33.25	33.229	33.2395	46720.0
2015-12-10 08:00:00	AMZN	Stock	33.249	33.3375	33.249	33.3	215140.0
2015-12-10 09:00:00	AMZN	Stock	33.297	33.3625	33.015	33.057	12032620.0
2015-12-10 10:00:00	AMZN	Stock	33.087	33.4263	32.978	33.1883	13689660.0
2015-12-10 11:00:00	AMZN	Stock	33.1815	33.2382	33.11	33.1901	5999880.0
2015-12-10 12:00:00	AMZN	Stock	33.177	33.2375	33.036	33.206	5274220.0
2015-12-10 13:00:00	AMZN	Stock	33.22	33.238	33.1685	33.1832	5224900.0

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

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